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;
Subscribe to:
Post Comments (Atom)
Blog Archive
-
▼
2009
(44)
-
▼
October
(44)
- Steps to find pwd for an application user in oracl...
- Query to find Open invoce and customer information
- Query to get revenue distribution lines for Invoice
- Script to create customer,Party site,account site,...
- Query to retrive the PO and AP invoice information
- Query to Identify All Requistions errror out in WF
- Query To Identify All Purchase Orders errored out ...
- Query to find requisition number from PO number
- PO Requisitions and Project Details
- Purchase Orders with Project Details
- Employee Extraction
- Query to find Employee Contact information
- Check Provider and receiver projects for a project
- Query to find project, classfication and max trans...
- AP Invoice and PA Exp Details
- PA Revnue extract for exp and events
- Being Yogendra: Meebo Chat Gadget for iGoogle
- Find Customer information(bill&ship) for a Slaes O...
- Query to retrieve the line information of the Sale...
- Query to retrive the header information of the Sal...
- OM Flow and Table Level information
- Query to fetch all request groups attached to resp...
- Kill Locked Session
- To get all Conc Programs attached to a Reponsibility
- To Derive Module wise conc program count
- Calculate Request Time
- List of responsibilities assigned to specific user
- Finding Oracle Apps Version
- Query to find list of parameters used in Concurren...
- FNDLOAD(Ldt) Scripts
- Assign and Delete Responsibility to User from backend
- Assign Concurrent Prog to Reuest Group
- Change User passwrd in oracle application
- Sample query to build calendar
- Derive business days
- Derive Business Days Count
- Query to fetch Error workflow details
- Quickest way to generate the columns used in the c...
- Query to find all functions in a Menu
- fetch the values from a string separated by commas...
- Active alert information
- Steps to upload GIF, XLS, PDF, JPG and DOC files i...
- Reading and printing attachments in Oracle apps Te...
- Query to Check List of Form personalizations
-
▼
October
(44)
No comments:
Post a Comment