FND_GLOBAL.APPS_INITIALIZE

Check out the main article on: Stijf.com

Begin
FND_GLOBAL.APPS_INITIALIZE(USER_ID=>:user_id
,RESP_ID => :resp_id
,RESP_APPL_ID => :resp_appl_id
,SECURITY_GROUP_ID => :sec_group_id
,SERVER_ID => :server_id);
END;
/

 

To get the required parameter values:

USER_ID

SELECT user_id, user_name, description
FROM  fnd_user
WHERE user_name LIKE '%:USER_NAME%';

 

RESPONSIBILITY_ID / RESPONSIBILITY_APPLICATION_ID

SELECT fr.responsibility_id, fr.application_id, frt.language, frt. responsibility_name, frt.description, fr.responsibility_key, fa.application_short_name
FROM fnd_responsibility fr
JOIN fnd_responsibility_tl frt on fr.responsibility_id = frt.responsibility_id and fr.application_id = frt.application_id
JOIN fnd_application fa on fr.application_id = fa.application_id
WHERE frt.user_responsibility_name like '%:RESP_NAME%';

 

SERVER_ID

SELECT server_id, node_name
FROM fnd_nodes;