API - fnd_user_pkg.addresp
Example -- -- ----------------------------------------------------------
-- Add Responsibility to Oracle FND User
-- ----------------------------------------------------------- DECLARE
lc_user_name VARCHAR2(100) := 'PRAJ_TEST';
lc_resp_appl_short_name VARCHAR2(100) := 'FND';
lc_responsibility_key VARCHAR2(100) := 'APPLICATION_DEVELOPER';
lc_security_group_key VARCHAR2(100) := 'STANDARD';
ld_resp_start_date DATE := TO_DATE('25-JUN-2012');
ld_resp_end_date DATE := NULL;
BEGIN
fnd_user_pkg.addresp
( username => lc_user_name,
resp_app => lc_resp_appl_short_name,
resp_key => lc_responsibility_key,
security_group => lc_security_group_key,
description => NULL,
start_date => ld_resp_start_date,
end_date => ld_resp_end_date
);
COMMIT;
EXCEPTION
WHEN OTHERS THEN
ROLLBACK; DBMS_OUTPUT.PUT_LINE(SQLERRM);
END;
/
SHOW ERR;
Court:Oracle Blog
2 comments:
Most of you hunger to know more about the glitzy life styles of glamorous celebrities and sensual models.
Talking of the walking dead, congratulations to Hugh Hefner, who is
getting married at age 84 to 24-year-old beauty Crystal Harris.
However, today, the wedding photographers capture photographs of moments
that are precious and that you would cherish all your life; and, when you least expects the wedding photographer to
capture you.
Feel free to surf to my website; insidebci.com
And as we all know, too much stress can be harmful to health.
For example, we often do some driving trains to encourage the students to speak a
few numbers in turn. There are a few selections of these
to choose from on this site too.
Stop by my webpage - more
Post a Comment