DBA Data[Home] [Help]

APPS.FND_PROFILE dependencies on FND_GLOBAL

Line 857: /* Bug 5209533: FND_GLOBAL.INITIALIZE RAISES APP-FND-02500 EXECUTING

853: PROFILE_OPTION_EXISTS := TRUE;
854:
855: else
856:
857: /* Bug 5209533: FND_GLOBAL.INITIALIZE RAISES APP-FND-02500 EXECUTING
858: ** RULE FUNCTIONS FOR WF EVENT
859: ** Setting PROFILE_OPTION_EXISTS = TRUE explicitly IF the condition is
860: ** not satisfied. This guarantees that the profile gets evaluated if
861: ** PROFILE_OPTION_EXISTS is not FALSE, e.g. NULL;

Line 1486: /* Bug 5209533: FND_GLOBAL.INITIALIZE RAISES APP-FND-02500 EXECUTING

1482: USER_CHANGEABLE);
1483: end if;
1484: else
1485:
1486: /* Bug 5209533: FND_GLOBAL.INITIALIZE RAISES APP-FND-02500 EXECUTING
1487: ** RULE FUNCTIONS FOR WF EVENT
1488: ** Setting PROFILE_OPTION_EXISTS = TRUE explicitly IF the condition is
1489: ** not satisfied. This guarantees that the profile gets evaluated if
1490: ** PROFILE_OPTION_EXISTS is not FALSE, e.g. NULL;

Line 3854: ** CALL VIA FND_GLOBAL.INITIALIZE('ORG_ID',org_id)

3850: end PUTMULTIPLE;
3851:
3852: /*
3853: ** FOR AOL INTERNAL USE ONLY - DO NOT CALL DIRECTLY,
3854: ** CALL VIA FND_GLOBAL.INITIALIZE('ORG_ID',org_id)
3855: ** FND_PROFILE.INITIALIZE also calls this API to initialize the org context.
3856: **
3857: ** initialize_org_context - Initializes the org context used by profiles.
3858: ** The org-level cache is cleared of all database (non-put) options first.

Line 3859: ** Sets PROFILES_ORG_ID to the current value fnd_global.org_id

3855: ** FND_PROFILE.INITIALIZE also calls this API to initialize the org context.
3856: **
3857: ** initialize_org_context - Initializes the org context used by profiles.
3858: ** The org-level cache is cleared of all database (non-put) options first.
3859: ** Sets PROFILES_ORG_ID to the current value fnd_global.org_id
3860: */
3861: procedure INITIALIZE_ORG_CONTEXT
3862: is
3863: begin

Line 3865: if ((PROFILES_ORG_ID is null) or (PROFILES_ORG_ID <> fnd_global.org_id))

3861: procedure INITIALIZE_ORG_CONTEXT
3862: is
3863: begin
3864: -- Clear org-level cache, if applicable
3865: if ((PROFILES_ORG_ID is null) or (PROFILES_ORG_ID <> fnd_global.org_id))
3866: then
3867: ORG_NAME_TAB.DELETE();
3868: ORG_VAL_TAB.DELETE();
3869: end if;

Line 3871: -- Set profiles org context variable to fnd_global.org_id

3867: ORG_NAME_TAB.DELETE();
3868: ORG_VAL_TAB.DELETE();
3869: end if;
3870:
3871: -- Set profiles org context variable to fnd_global.org_id
3872: PROFILES_ORG_ID := fnd_global.org_id;
3873:
3874: if release_version < 12 then
3875: -- For releases less than R12, the ORG_ID profile is the source of the

Line 3872: PROFILES_ORG_ID := fnd_global.org_id;

3868: ORG_VAL_TAB.DELETE();
3869: end if;
3870:
3871: -- Set profiles org context variable to fnd_global.org_id
3872: PROFILES_ORG_ID := fnd_global.org_id;
3873:
3874: if release_version < 12 then
3875: -- For releases less than R12, the ORG_ID profile is the source of the
3876: -- org context. FND_GLOBAL.ORG_ID = FND_PROFILE.VALUE('ORG_ID')

Line 3876: -- org context. FND_GLOBAL.ORG_ID = FND_PROFILE.VALUE('ORG_ID')

3872: PROFILES_ORG_ID := fnd_global.org_id;
3873:
3874: if release_version < 12 then
3875: -- For releases less than R12, the ORG_ID profile is the source of the
3876: -- org context. FND_GLOBAL.ORG_ID = FND_PROFILE.VALUE('ORG_ID')
3877: PUT('ORG_ID', to_char(PROFILES_ORG_ID));
3878: else
3879: -- Bug 7423364: For R12, the profile option ORG_ID is not always an
3880: -- equivalent of FND_GLOBAL.ORG_ID, which is the org context. The

Line 3880: -- equivalent of FND_GLOBAL.ORG_ID, which is the org context. The

3876: -- org context. FND_GLOBAL.ORG_ID = FND_PROFILE.VALUE('ORG_ID')
3877: PUT('ORG_ID', to_char(PROFILES_ORG_ID));
3878: else
3879: -- Bug 7423364: For R12, the profile option ORG_ID is not always an
3880: -- equivalent of FND_GLOBAL.ORG_ID, which is the org context. The
3881: -- global variable PROFILES_ORG_ID is the org context used for
3882: -- evaluating org-level profile option values and should be equal to
3883: -- FND_GLOBAL.ORG_ID. A value fetch on the profile option ORG_ID
3884: -- should return the profile option table value, not the org context.

Line 3883: -- FND_GLOBAL.ORG_ID. A value fetch on the profile option ORG_ID

3879: -- Bug 7423364: For R12, the profile option ORG_ID is not always an
3880: -- equivalent of FND_GLOBAL.ORG_ID, which is the org context. The
3881: -- global variable PROFILES_ORG_ID is the org context used for
3882: -- evaluating org-level profile option values and should be equal to
3883: -- FND_GLOBAL.ORG_ID. A value fetch on the profile option ORG_ID
3884: -- should return the profile option table value, not the org context.
3885: -- This behavior was confirmed with JMARY and SHNARAYA of the MO Team.
3886: -- CURRENT_ORG_CONTEXT is being introduced so that profiles code can
3887: -- provide similar functionality such that FND_GLOBAL.ORG_ID will be

Line 3887: -- provide similar functionality such that FND_GLOBAL.ORG_ID will be

3883: -- FND_GLOBAL.ORG_ID. A value fetch on the profile option ORG_ID
3884: -- should return the profile option table value, not the org context.
3885: -- This behavior was confirmed with JMARY and SHNARAYA of the MO Team.
3886: -- CURRENT_ORG_CONTEXT is being introduced so that profiles code can
3887: -- provide similar functionality such that FND_GLOBAL.ORG_ID will be
3888: -- equivalent to FND_PROFILE.VALUE('CURRENT_ORG_CONTEXT').
3889: -- FND_GLOBAL.VALUE('ORG_ID') will return a value obtained in the
3890: -- FND_PROFILE_OPTION_VALUES table.
3891: PUT('CURRENT_ORG_CONTEXT', to_char(PROFILES_ORG_ID));

Line 3889: -- FND_GLOBAL.VALUE('ORG_ID') will return a value obtained in the

3885: -- This behavior was confirmed with JMARY and SHNARAYA of the MO Team.
3886: -- CURRENT_ORG_CONTEXT is being introduced so that profiles code can
3887: -- provide similar functionality such that FND_GLOBAL.ORG_ID will be
3888: -- equivalent to FND_PROFILE.VALUE('CURRENT_ORG_CONTEXT').
3889: -- FND_GLOBAL.VALUE('ORG_ID') will return a value obtained in the
3890: -- FND_PROFILE_OPTION_VALUES table.
3891: PUT('CURRENT_ORG_CONTEXT', to_char(PROFILES_ORG_ID));
3892: end if;
3893:

Line 3894: PUT('ORG_NAME', fnd_global.org_name);

3890: -- FND_PROFILE_OPTION_VALUES table.
3891: PUT('CURRENT_ORG_CONTEXT', to_char(PROFILES_ORG_ID));
3892: end if;
3893:
3894: PUT('ORG_NAME', fnd_global.org_name);
3895:
3896: end INITIALIZE_ORG_CONTEXT;
3897:
3898: /*

Line 3900: ** CALL VIA FND_GLOBAL.APPS_INITIALIZE

3896: end INITIALIZE_ORG_CONTEXT;
3897:
3898: /*
3899: ** FOR AOL INTERNAL USE ONLY - DO NOT CALL DIRECTLY,
3900: ** CALL VIA FND_GLOBAL.APPS_INITIALIZE
3901: ** initialize - Initialize the internal profile information
3902: ** The cache is cleared of all database (non-put) options first.
3903: ** Initializes the profiles for the level context information.
3904: **

Line 3983: (PROFILES_SERVER_ID <> fnd_global.server_id)) then

3979: end if;
3980: end if;
3981:
3982: if ((PROFILES_SERVER_ID is null) or
3983: (PROFILES_SERVER_ID <> fnd_global.server_id)) then
3984: SERVER_NAME_TAB.DELETE();
3985: SERVER_VAL_TAB.DELETE();
3986: -- A change in server affects the SERVRESP hierarchy and the cache
3987: -- should be emptied if the server changes.

Line 3995: PROFILES_SERVER_ID := fnd_global.server_id;

3991:
3992: PROFILES_USER_ID := USER_ID_Z;
3993: PROFILES_RESP_ID := RESPONSIBILITY_ID_Z;
3994: PROFILES_APPL_ID := APPLICATION_ID_Z;
3995: PROFILES_SERVER_ID := fnd_global.server_id;
3996: PROFILES_SESSION_ID := SESSION_ID;
3997:
3998: -- Set login appl/resp/user specific security profiles
3999: if (user_id_z is not null) then

Line 4002: if (user_id_z = fnd_global.user_id) then

3998: -- Set login appl/resp/user specific security profiles
3999: if (user_id_z is not null) then
4000: PUT('USER_ID', to_char(user_id_z));
4001:
4002: if (user_id_z = fnd_global.user_id) then
4003: -- Use global to avoid select if current user
4004: NAME := fnd_global.user_name;
4005: elsif (user_id_z = -1) then
4006: NAME := 'DEFAULT_USER';

Line 4004: NAME := fnd_global.user_name;

4000: PUT('USER_ID', to_char(user_id_z));
4001:
4002: if (user_id_z = fnd_global.user_id) then
4003: -- Use global to avoid select if current user
4004: NAME := fnd_global.user_name;
4005: elsif (user_id_z = -1) then
4006: NAME := 'DEFAULT_USER';
4007: else
4008: begin

Line 4032: fnd_global.org_id,

4028: 'FP.I',
4029: USER_ID_Z,
4030: RESPONSIBILITY_ID_Z,
4031: APPLICATION_ID_Z,
4032: fnd_global.org_id,
4033: fnd_global.server_id);
4034: end if;
4035:
4036: if ((responsibility_id_z is not null) and (application_id_z is not null))

Line 4033: fnd_global.server_id);

4029: USER_ID_Z,
4030: RESPONSIBILITY_ID_Z,
4031: APPLICATION_ID_Z,
4032: fnd_global.org_id,
4033: fnd_global.server_id);
4034: end if;
4035:
4036: if ((responsibility_id_z is not null) and (application_id_z is not null))
4037: then

Line 4040: if ((responsibility_id_z = fnd_global.resp_id) and

4036: if ((responsibility_id_z is not null) and (application_id_z is not null))
4037: then
4038: PUT('RESP_ID', to_char(responsibility_id_z));
4039: PUT('RESP_APPL_ID', to_char(application_id_z));
4040: if ((responsibility_id_z = fnd_global.resp_id) and
4041: (application_id_z = fnd_global.resp_appl_id)) then
4042: -- Use global to avoid select if current resp
4043: NAME := fnd_global.resp_name;
4044: elsif ((responsibility_id_z = -1) and (application_id_z = -1)) then

Line 4041: (application_id_z = fnd_global.resp_appl_id)) then

4037: then
4038: PUT('RESP_ID', to_char(responsibility_id_z));
4039: PUT('RESP_APPL_ID', to_char(application_id_z));
4040: if ((responsibility_id_z = fnd_global.resp_id) and
4041: (application_id_z = fnd_global.resp_appl_id)) then
4042: -- Use global to avoid select if current resp
4043: NAME := fnd_global.resp_name;
4044: elsif ((responsibility_id_z = -1) and (application_id_z = -1)) then
4045: NAME := 'DEFAULT_RESP';

Line 4043: NAME := fnd_global.resp_name;

4039: PUT('RESP_APPL_ID', to_char(application_id_z));
4040: if ((responsibility_id_z = fnd_global.resp_id) and
4041: (application_id_z = fnd_global.resp_appl_id)) then
4042: -- Use global to avoid select if current resp
4043: NAME := fnd_global.resp_name;
4044: elsif ((responsibility_id_z = -1) and (application_id_z = -1)) then
4045: NAME := 'DEFAULT_RESP';
4046: else
4047: begin