Add Responsibility to USER using pl/sql - EBS

SELECT FAV.APPLICATION_SHORT_NAME, FAV.APPLICATION_NAME,FRV.RESPONSIBILITY_KEY, FRV.RESPONSIBILITY_NAME

FROM FND_APPLICATION_VL FAV, FND_RESPONSIBILITY_VL FRV
WHERE 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;

/