Sunday, October 4, 2009

Assign and Delete Responsibility to User from backend

begin
fnd_user_pkg.addresp(
username VARCHAR2,
resp_app VARCHAR2,
resp_key VARCHAR2,
security_group VARCHAR2,
description VARCHAR2,
start_date DATE
end_date DATE);
commit;
exception
when others then
dbms_output.put_line(SQLERRM);
end;
Ex:-
---
begin
fnd_user_pkg.addresp(
username => 'SUN',
resp_app => 'XDO',
resp_key => 'XDO_ADMINISTRATION',
security_group => 'STANDARD',
description => 'Oracle XML Publisher Administrator responsibility',
start_date => trunc(sysdate),
end_date => NULL);
commit;
exception
when others then
dbms_output.put_line(SQLERRM);
end;
Ex:-
---
begin
fnd_user_pkg.DelResp(username => 'SUN',
resp_app => 'XDO',
resp_key => 'XDO_ADMINISTRATION',
security_group => 'STANDARD'
);
dbms_output.put_line('Success');
commit;
exception
when others then
dbms_output.put_line(SQLERRM);
end;

No comments:

Post a Comment

Blog Archive