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