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;