Wednesday, 6 July 2011

Add Responsibility from backend

select * from fnd_responsibility_tl where responsibility_name like 'Sys%Adm%';

select * from fnd_responsibility where responsibility_id = 20420     --20872;    20420
select * from fnd_application where application_id = 1       --178;     1


BEGIN
        fnd_user_pkg.addresp ('USERNAME'
                              , 'SYSADMIN'
                              , 'SYSTEM_ADMINISTRATOR'
                              , 'STANDARD'
                              , 'Add Responsibility to USER'
                              , '01-JAN-1900'
                              , null
        );
        COMMIT;
        DBMS_OUTPUT.put_line ('Responsibility Added Successfully');
EXCEPTION
        WHEN OTHERS
        THEN
        DBMS_OUTPUT.put_line ('Responsibility is not added due to'|| SUBSTR (SQLERRM, 1, 100));
        ROLLBACK;
END;
---------------------------------------------------------------------------
BEGIN
        fnd_user_pkg.DelResp ('CONVERSION'
                              , 'SYSADMIN'
                              , 'SYSTEM_ADMINISTRATOR'
                              , 'STANDARD'
                          
        );
        COMMIT;
        DBMS_OUTPUT.put_line ('Responsibility Deleted Successfully');
EXCEPTION
        WHEN OTHERS
        THEN
        DBMS_OUTPUT.put_line ('Responsibility is not deleted due to'|| SUBSTR (SQLERRM, 1, 100));
        ROLLBACK;
END;

No comments:

Post a Comment