FND_GLOBAL.APPS_INITIALIZE for initializing session in Oracle Ebusiness suite
This procedure sets up global variables and profile values in a database session. Call this procedure to initialize the global security context for a database session. You can use it for routines such as PL/SQL or other programs that are not integrated with either the Oracle Applications concurrent processing facility or Oracle Forms (both of which already do a similar initialization for a database session).
Ex.
exec FND_GLOBAL.APPS_INITIALIZE (1152, --appplication user id
51200, --responsibility id
385, --applicaton id
0);
MO_GLOBAL.SET_POLICY_CONTEXT
This procedure has two parameters
p_access_mode
Pass a value "S" in case you want your current session to work against Single ORG_ID
Pass a value of "M" in case you want your current session to work against multiple ORG_ID's
p_org_id
Only applicable if p_access_mode is passed value of "S"
exec MO_GLOBAL.SET_POLICY_CONTEXT('S',141);
MO_GLOBAL.INIT
This will read the MO profile option values for your responsibility/user, and will initialize the Multi Org Access
It will check if new Multi Org Security Profile is set, to decide if new Security Profile method will be used.
If the new MO security profile is set, then mo_global.init inserts one record, for each Organization in Org Hierarchy, in table mo
exec MO_GLOBAL.INIT ('CE');
No comments:
Post a Comment