Tuesday, November 6, 2012

How to add responsibility using PLSQL

BEGIN
        fnd_user_pkg.addresp ('MYUSERID','APPL_SHORT_NAME','REPONSIBILITY_SHORT_NAME','STANDARD','Add Responsibility to USER using pl/sql',SYSDATE,'');
        COMMIT;
        DBMS_OUTPUT.put_line ('Responsibility Added Successfully');
EXCEPTION
        WHEN OTHERS
        THEN
        DBMS_OUTPUT.put_line (   ' Responsibility is not added due to '|| SQLCODE||' - '|| SUBSTR (SQLERRM, 1, 100));
        ROLLBACK;
END;
/

No comments:

Post a Comment