how to add responsibility from back end
begin
--fnd_user_pkg.addresp(
-- ‘&user_name’, /*application user name */
-- ‘&responsablity_application_short_name’, /*get from query below */
-- ‘&responsibility_key’,/*get from query below */
-- ‘&security_group’, /* most of cases it is ‘standard’ so you can hard code it */
-- ‘&description’, /* any comments you want */
-- ‘&start_date’, /* sysdate from today */
-- ‘&end_date’ ); /* sysdate + 365 rights for next one year*/
fnd_user_pkg.addresp ('user_name','sysadmin','system_administrator','standard','add responsibility to user using pl/sql',sysdate-1,sysdate + 100);
commit;
dbms_output.put_line('responsibility added successfully to the user ');
exception
when others then
dbms_output.put_line(' responsibility adding failed due to' || "sqlcode" || substr(sqlerrm, 1, 100));
rollback;
end;
No comments:
Post a Comment