SELECT FAV.APPLICATION_SHORT_NAME, FAV.APPLICATION_NAME,FRV.RESPONSIBILITY_KEY, FRV.RESPONSIBILITY_NAME
FROM FND_APPLICATION_VL FAV, FND_RESPONSIBILITY_VL FRVWHERE FRV.APPLICATION_ID=FAV.APPLICATION_ID
ORDER BY FRV.RESPONSIBILITY_NAME
Using fnd_user_pkg:
Input (Mandatory)
-- username: User Name
-- resp_app: Application Short Name
-- resp_key: Responsibility Key
-- security_group: Security Group Key
-- description: Description
-- start_date: Start Date
-- end_date: End Date
Sample Usage:
set serveroutput on
BEGIN
fnd_user_pkg.addresp ('Username','OE','ORDER_ENTRY_SUPER_USER','STANDARD','Responsability added by Denilson Using PL/SQL',SYSDATE, null);
COMMIT;
DBMS_OUTPUT.put_line ('Responsibility Added Successfully');
EXCEPTION
WHEN OTHERS
THEN
DBMS_OUTPUT.put_line('Responsibility is not added due to');
DBMS_OUTPUT.PUT_LINE('ERROR: '||SQLERRM|| ' CODE: '||SQLCODE);
ROLLBACK;
END;
/
Comentários
Postar um comentário