eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FND_PROFILE dependencies on FND_PROFILE

Line 1: package body FND_PROFILE as

1: package body FND_PROFILE as
2: /* $Header: AFPFPROB.pls 120.18.12010000.9 2009/01/28 16:39:09 pdeluna ship $ */
3:
4: type VAL_TAB_TYPE is table of varchar2(255) index by binary_integer;
5: type NAME_TAB_TYPE is table of varchar2(80) index by binary_integer;

Line 107: ** Added for Bug 5599946: APPSPERF:FND:LOGGING CALLS IN FND_PROFILE CAUSING

103: PROFILE_OPTION_EXISTS boolean := TRUE;
104:
105: /*
106: ** Global variable used to identify core logging is enabled or not.
107: ** Added for Bug 5599946: APPSPERF:FND:LOGGING CALLS IN FND_PROFILE CAUSING
108: ** PERFORMANCE REGRESSION
109: */
110: CORELOG_IS_ENABLED boolean := FND_CORE_LOG.IS_ENABLED;
111:

Line 145: ** Bug 5477866: INCONSISTENT VALUES RETURNED BY FND_PROFILE.VALUE_SPECIFIC

141:
142: /*
143: ** CHECK_CACHE_VERSIONS
144: **
145: ** Bug 5477866: INCONSISTENT VALUES RETURNED BY FND_PROFILE.VALUE_SPECIFIC
146: ** Broke this algorithm out of INITIALIZE so that VALUE_SPECIFIC can use
147: ** the algorithm also.
148: */
149: procedure CHECK_CACHE_VERSIONS

Line 285: /* Bug 5603664: APPSPERF:FND:OPTIMIZE FND_PROFILE.VALUE

281: ** API calling find passes UPPER(profile option name).
282: ** NAME_UPPER := upper(NAME);
283: */
284:
285: /* Bug 5603664: APPSPERF:FND:OPTIMIZE FND_PROFILE.VALUE
286: ** This is a failsafe. PROFILE_HASH_VALUE should always be passed by the
287: ** calling api.
288: **
289: ** TAB_INDEX := dbms_utility.get_hash_value(NAME_UPPER,1,TABLE_SIZE);

Line 356: /* Bug 5603664: APPSPERF:FND:OPTIMIZE FND_PROFILE.VALUE

352: ** table index if found, TABLE_SIZE if not found.
353: */
354: function FIND(NAME in varchar2) return binary_integer is
355: begin
356: /* Bug 5603664: APPSPERF:FND:OPTIMIZE FND_PROFILE.VALUE
357: ** UPPER function call removed, calling API would have done UPPER before
358: ** calling FIND
359: ** return FIND(UPPER(NAME),NAME_TAB);
360: */

Line 383: /* Bug 5603664: APPSPERF:FND:OPTIMIZE FND_PROFILE.VALUE

379: STORED boolean;
380: HASH_VALUE number;
381:
382: begin
383: /* Bug 5603664: APPSPERF:FND:OPTIMIZE FND_PROFILE.VALUE
384: ** Assignment removed since calling API would have used UPPER and passed
385: ** resulting value for NAME into PUT
386: **
387: ** NAME_UPPER := upper(NAME);

Line 395: /* Bug 5603664: APPSPERF:FND:OPTIMIZE FND_PROFILE.VALUE

391: if CORELOG_IS_ENABLED then
392: CORELOG(NAME,VAL,'Enter FP.P');
393: end if;
394:
395: /* Bug 5603664: APPSPERF:FND:OPTIMIZE FND_PROFILE.VALUE
396: ** This is a failsafe. PROFILE_HASH_VALUE should always be passed by the
397: ** calling api.
398: **
399: ** TABLE_INDEX := dbms_utility.get_hash_value(NAME,1,TABLE_SIZE);

Line 479: /* Bug 5603664: APPSPERF:FND:OPTIMIZE FND_PROFILE.VALUE

475: procedure PUT(
476: NAME in varchar2,
477: VAL in varchar2)
478: is
479: /* Bug 5603664: APPSPERF:FND:OPTIMIZE FND_PROFILE.VALUE
480: ** UPPER call is done early and value is passed on, which minimizes
481: ** number of UPPER calls
482: */
483: NAME_UPPER varchar2(80) := UPPER(NAME);

Line 491: /* Bug 5603664: APPSPERF:FND:OPTIMIZE FND_PROFILE.VALUE

487: if CORELOG_IS_ENABLED then
488: CORELOG(NAME_UPPER,VAL,'Enter Generic FP.P');
489: end if;
490:
491: /* Bug 5603664: APPSPERF:FND:OPTIMIZE FND_PROFILE.VALUE
492: ** Call dbms_utility.get_hash_value and pass as an argument to PUT
493: */
494: -- Private PUT call
495: PUT(NAME_UPPER,VAL,NAME_TAB,VAL_TAB,

Line 542: /* Bug 5603664: APPSPERF:FND:OPTIMIZE FND_PROFILE.VALUE

538: ** 'value' collection to obtain the value using the tableIndex
539: ** obtained. This fix was approved by the ATG Performance Team.
540: */
541:
542: /* Bug 5603664: APPSPERF:FND:OPTIMIZE FND_PROFILE.VALUE
543: ** This is a failsafe. PROFILE_HASH_VALUE should always be passed by the
544: ** calling api.
545: */
546: if PROFILE_HASH_VALUE is NULL then

Line 552: /* Bug 5603664: APPSPERF:FND:OPTIMIZE FND_PROFILE.VALUE

548: else
549: hashValue := PROFILE_HASH_VALUE;
550: end if;
551:
552: /* Bug 5603664: APPSPERF:FND:OPTIMIZE FND_PROFILE.VALUE
553: ** Removed all UPPER in FIND calls since calling API would have already
554: ** used UPPER and passed in resulting name_z. This minimizes UPPER calls.
555: */
556: if(level_id_z = 10001) then

Line 655: from fnd_profile_option_values

651: -- and user levels (10001/10002/10004)
652: --
653: cursor value_uas(pid number, aid number, lid number, lval number) is
654: select profile_option_value
655: from fnd_profile_option_values
656: where profile_option_id = pid
657: and application_id = aid
658: and level_id = lid
659: and level_value = lval

Line 667: from fnd_profile_option_values

663: -- level (10003)
664: --
665: cursor value_resp(pid number, aid number, lval number, laid number) is
666: select profile_option_value
667: from fnd_profile_option_values
668: where profile_option_id = pid
669: and application_id = aid
670: and level_id = 10003
671: and level_value = lval

Line 681: from fnd_profile_option_values

677: --
678: cursor value_servresp(pid number, aid number, lval number, laid number,
679: lval2 number) is
680: select profile_option_value
681: from fnd_profile_option_values
682: where profile_option_id = pid
683: and application_id = aid
684: and level_id = 10007
685: and level_value = lval

Line 775: from fnd_profile_options

771: server_enabled_flag,
772: SERVERRESP_ENABLED_FLAG,
773: hierarchy_type,
774: user_changeable_flag -- Bug 4257739
775: from fnd_profile_options
776: where profile_option_name = name_z -- Bug 5599946: Removed UPPER call
777: and start_date_active <= sysdate
778: and nvl(end_date_active, sysdate) >= sysdate;
779:

Line 790: /* Bug 5603664: APPSPERF:FND:OPTIMIZE FND_PROFILE.VALUE

786: CORELOG(name_z,nvl(val_z,'NOVAL'),'Enter FP.GSD',user_id_z,
787: responsibility_id_z,application_id_z,org_id_z,server_id_z);
788: end if;
789:
790: /* Bug 5603664: APPSPERF:FND:OPTIMIZE FND_PROFILE.VALUE
791: ** This is a failsafe. PROFILE_HASH_VALUE should always be passed by the
792: ** calling api.
793: */
794: if PROFILE_HASH_VALUE is NULL then

Line 1354: from fnd_profile_options

1350: server_enabled_flag,
1351: serverresp_enabled_flag,
1352: hierarchy_type,
1353: user_changeable_flag -- Bug 4257739
1354: from fnd_profile_options
1355: where profile_option_name = name_z
1356: and start_date_active <= sysdate
1357: and nvl(end_date_active, sysdate) >= sysdate;
1358:

Line 1365: from fnd_profile_option_values

1361: -- and user levels (10001/10002/10004)
1362: --
1363: cursor value_uas(pid number, aid number, lid number, lval number) is
1364: select profile_option_value
1365: from fnd_profile_option_values
1366: where profile_option_id = pid
1367: and application_id = aid
1368: and level_id = lid
1369: and level_value = lval

Line 1377: from fnd_profile_option_values

1373: -- level (10003)
1374: --
1375: cursor value_resp(pid number, aid number, lval number, laid number) is
1376: select profile_option_value
1377: from fnd_profile_option_values
1378: where profile_option_id = pid
1379: and application_id = aid
1380: and level_id = 10003
1381: and level_value = lval

Line 1391: from fnd_profile_option_values

1387: --
1388: cursor value_servresp(pid number, aid number, lval number, laid number,
1389: lval2 number) is
1390: select profile_option_value
1391: from fnd_profile_option_values
1392: where profile_option_id = pid
1393: and application_id = aid
1394: and level_id = 10007
1395: and level_value = lval

Line 2104: /* Bug 5603664: APPSPERF:FND:OPTIMIZE FND_PROFILE.VALUE

2100:
2101: val_z := NULL;
2102: defined_z := FALSE;
2103:
2104: /* Bug 5603664: APPSPERF:FND:OPTIMIZE FND_PROFILE.VALUE
2105: ** Generate hashValue and pass it on to FIND and PUT calls.
2106: */
2107: hashValue := dbms_utility.get_hash_value(name_z,1,TABLE_SIZE);
2108:

Line 2468: ** FND_PROFILE.VALUE_SPECIFIC and site value is consistently

2464: end if;
2465: else
2466: -- See if Servresp-level context has a value in DB
2467: /* Bug 4021624: FND_RUN_FUNCTION.GET_JSP_AGENT calls
2468: ** FND_PROFILE.VALUE_SPECIFIC and site value is consistently
2469: ** returned, given a Resp ID and Server ID. GET_SPECIFIC_DB_WNPS
2470: ** was being called for the Resp ID + Server ID combination ONLY
2471: ** and was missing the values set for Resp ID + (Server ID = -1)
2472: ** and (Resp ID = -1) + Server ID combos. GET_SPECIFIC_DB_WNPS

Line 2616: /* Bug 5603664: APPSPERF:FND:OPTIMIZE FND_PROFILE.VALUE

2612:
2613: val_z := NULL;
2614: defined_z := FALSE;
2615:
2616: /* Bug 5603664: APPSPERF:FND:OPTIMIZE FND_PROFILE.VALUE
2617: ** Generate hashValue and pass it on to FIND and PUT calls.
2618: */
2619: hashValue := dbms_utility.get_hash_value(name_z,1,TABLE_SIZE);
2620:

Line 2630: /* Bug 3637977: FND_PROFILE:CONTEXT-LEVEL CHANGES NOT REFLECTED BY RETURN

2626: -- follows the profile hierarchy. If the the profile option/value has
2627: -- never been cached, we will go to the DB after the cached calls.
2628: --
2629:
2630: /* Bug 3637977: FND_PROFILE:CONTEXT-LEVEL CHANGES NOT REFLECTED BY RETURN
2631: ** VALUES
2632: ** For each level, a call to GET_SPECIFIC_DB was added to
2633: ** ensure that a context-level value does not exist, if no value was
2634: ** found at context-level cache. The GET_SPECIFIC_DB call done is

Line 3032: -- The subscription that executes the FND_PROFILE.bumpCacheVersion_RF

3028: level_value := to_number(x_level_value);
3029: level_value_appl_id := to_number(x_level_value_app_id);
3030: --
3031: -- level_value2 was added for the Server/Resp Hierarchy.
3032: -- The subscription that executes the FND_PROFILE.bumpCacheVersion_RF
3033: -- rule function uses the level_id. For this subscription, the
3034: -- level_value2 value is irrelevant. However, it may become relevant
3035: -- to other subscriptions subscribing to the
3036: -- oracle.apps.fnd.profile.value.update event. At this time, the

Line 3036: -- oracle.apps.fnd.profile.value.update event. At this time, the

3032: -- The subscription that executes the FND_PROFILE.bumpCacheVersion_RF
3033: -- rule function uses the level_id. For this subscription, the
3034: -- level_value2 value is irrelevant. However, it may become relevant
3035: -- to other subscriptions subscribing to the
3036: -- oracle.apps.fnd.profile.value.update event. At this time, the
3037: -- level_value2 value will be stored but not passed into the
3038: -- event_key.
3039: --
3040: --Added for server/resp hierarchy

Line 3060: -- wf_event.raise(p_event_name=>'oracle.apps.fnd.profile.value.update',

3056: --
3057: -- Modified this direct call to wf_event.raise to use the
3058: -- fnd_wf_engine.default_event_raise wrapper API
3059: --
3060: -- wf_event.raise(p_event_name=>'oracle.apps.fnd.profile.value.update',
3061: -- p_event_key=>event_key);
3062: --
3063:
3064: fnd_wf_engine.default_event_raise(

Line 3065: p_event_name=>'oracle.apps.fnd.profile.value.update',

3061: -- p_event_key=>event_key);
3062: --
3063:
3064: fnd_wf_engine.default_event_raise(
3065: p_event_name=>'oracle.apps.fnd.profile.value.update',
3066: p_event_key=>event_key);
3067:
3068: end INVALIDATE_CACHE;
3069:

Line 3103: ** FND_PROFILE.SAVE('P_NAME', 'P_VAL', 'SITE');

3099: **
3100: ** ('SITE', 'APPL', 'RESP', 'USER', 'SERVER', 'ORG', or 'SERVRESP').
3101: **
3102: ** Examples of use:
3103: ** FND_PROFILE.SAVE('P_NAME', 'P_VAL', 'SITE');
3104: ** FND_PROFILE.SAVE('P_NAME', 'P_VAL', 'APPL', 321532);
3105: ** FND_PROFILE.SAVE('P_NAME', 'P_VAL', 'RESP', 321532, 345234);
3106: ** FND_PROFILE.SAVE('P_NAME', 'P_VAL', 'USER', 123321);
3107: ** FND_PROFILE.SAVE('P_NAME', 'SERVER', 25);

Line 3104: ** FND_PROFILE.SAVE('P_NAME', 'P_VAL', 'APPL', 321532);

3100: ** ('SITE', 'APPL', 'RESP', 'USER', 'SERVER', 'ORG', or 'SERVRESP').
3101: **
3102: ** Examples of use:
3103: ** FND_PROFILE.SAVE('P_NAME', 'P_VAL', 'SITE');
3104: ** FND_PROFILE.SAVE('P_NAME', 'P_VAL', 'APPL', 321532);
3105: ** FND_PROFILE.SAVE('P_NAME', 'P_VAL', 'RESP', 321532, 345234);
3106: ** FND_PROFILE.SAVE('P_NAME', 'P_VAL', 'USER', 123321);
3107: ** FND_PROFILE.SAVE('P_NAME', 'SERVER', 25);
3108: ** FND_PROFILE.SAVE('P_NAME', 'ORG', 204);

Line 3105: ** FND_PROFILE.SAVE('P_NAME', 'P_VAL', 'RESP', 321532, 345234);

3101: **
3102: ** Examples of use:
3103: ** FND_PROFILE.SAVE('P_NAME', 'P_VAL', 'SITE');
3104: ** FND_PROFILE.SAVE('P_NAME', 'P_VAL', 'APPL', 321532);
3105: ** FND_PROFILE.SAVE('P_NAME', 'P_VAL', 'RESP', 321532, 345234);
3106: ** FND_PROFILE.SAVE('P_NAME', 'P_VAL', 'USER', 123321);
3107: ** FND_PROFILE.SAVE('P_NAME', 'SERVER', 25);
3108: ** FND_PROFILE.SAVE('P_NAME', 'ORG', 204);
3109: ** FND_PROFILE.SAVE('P_NAME', 'SERVRESP', 321532, 345234, 25);

Line 3106: ** FND_PROFILE.SAVE('P_NAME', 'P_VAL', 'USER', 123321);

3102: ** Examples of use:
3103: ** FND_PROFILE.SAVE('P_NAME', 'P_VAL', 'SITE');
3104: ** FND_PROFILE.SAVE('P_NAME', 'P_VAL', 'APPL', 321532);
3105: ** FND_PROFILE.SAVE('P_NAME', 'P_VAL', 'RESP', 321532, 345234);
3106: ** FND_PROFILE.SAVE('P_NAME', 'P_VAL', 'USER', 123321);
3107: ** FND_PROFILE.SAVE('P_NAME', 'SERVER', 25);
3108: ** FND_PROFILE.SAVE('P_NAME', 'ORG', 204);
3109: ** FND_PROFILE.SAVE('P_NAME', 'SERVRESP', 321532, 345234, 25);
3110: ** FND_PROFILE.SAVE('P_NAME', 'SERVRESP', 321532, 345234, -1);

Line 3107: ** FND_PROFILE.SAVE('P_NAME', 'SERVER', 25);

3103: ** FND_PROFILE.SAVE('P_NAME', 'P_VAL', 'SITE');
3104: ** FND_PROFILE.SAVE('P_NAME', 'P_VAL', 'APPL', 321532);
3105: ** FND_PROFILE.SAVE('P_NAME', 'P_VAL', 'RESP', 321532, 345234);
3106: ** FND_PROFILE.SAVE('P_NAME', 'P_VAL', 'USER', 123321);
3107: ** FND_PROFILE.SAVE('P_NAME', 'SERVER', 25);
3108: ** FND_PROFILE.SAVE('P_NAME', 'ORG', 204);
3109: ** FND_PROFILE.SAVE('P_NAME', 'SERVRESP', 321532, 345234, 25);
3110: ** FND_PROFILE.SAVE('P_NAME', 'SERVRESP', 321532, 345234, -1);
3111: ** FND_PROFILE.SAVE('P_NAME', 'SERVRESP', -1, -1, 25);

Line 3108: ** FND_PROFILE.SAVE('P_NAME', 'ORG', 204);

3104: ** FND_PROFILE.SAVE('P_NAME', 'P_VAL', 'APPL', 321532);
3105: ** FND_PROFILE.SAVE('P_NAME', 'P_VAL', 'RESP', 321532, 345234);
3106: ** FND_PROFILE.SAVE('P_NAME', 'P_VAL', 'USER', 123321);
3107: ** FND_PROFILE.SAVE('P_NAME', 'SERVER', 25);
3108: ** FND_PROFILE.SAVE('P_NAME', 'ORG', 204);
3109: ** FND_PROFILE.SAVE('P_NAME', 'SERVRESP', 321532, 345234, 25);
3110: ** FND_PROFILE.SAVE('P_NAME', 'SERVRESP', 321532, 345234, -1);
3111: ** FND_PROFILE.SAVE('P_NAME', 'SERVRESP', -1, -1, 25);
3112: **

Line 3109: ** FND_PROFILE.SAVE('P_NAME', 'SERVRESP', 321532, 345234, 25);

3105: ** FND_PROFILE.SAVE('P_NAME', 'P_VAL', 'RESP', 321532, 345234);
3106: ** FND_PROFILE.SAVE('P_NAME', 'P_VAL', 'USER', 123321);
3107: ** FND_PROFILE.SAVE('P_NAME', 'SERVER', 25);
3108: ** FND_PROFILE.SAVE('P_NAME', 'ORG', 204);
3109: ** FND_PROFILE.SAVE('P_NAME', 'SERVRESP', 321532, 345234, 25);
3110: ** FND_PROFILE.SAVE('P_NAME', 'SERVRESP', 321532, 345234, -1);
3111: ** FND_PROFILE.SAVE('P_NAME', 'SERVRESP', -1, -1, 25);
3112: **
3113: ** returns: TRUE if successful, FALSE if failure.

Line 3110: ** FND_PROFILE.SAVE('P_NAME', 'SERVRESP', 321532, 345234, -1);

3106: ** FND_PROFILE.SAVE('P_NAME', 'P_VAL', 'USER', 123321);
3107: ** FND_PROFILE.SAVE('P_NAME', 'SERVER', 25);
3108: ** FND_PROFILE.SAVE('P_NAME', 'ORG', 204);
3109: ** FND_PROFILE.SAVE('P_NAME', 'SERVRESP', 321532, 345234, 25);
3110: ** FND_PROFILE.SAVE('P_NAME', 'SERVRESP', 321532, 345234, -1);
3111: ** FND_PROFILE.SAVE('P_NAME', 'SERVRESP', -1, -1, 25);
3112: **
3113: ** returns: TRUE if successful, FALSE if failure.
3114: */

Line 3111: ** FND_PROFILE.SAVE('P_NAME', 'SERVRESP', -1, -1, 25);

3107: ** FND_PROFILE.SAVE('P_NAME', 'SERVER', 25);
3108: ** FND_PROFILE.SAVE('P_NAME', 'ORG', 204);
3109: ** FND_PROFILE.SAVE('P_NAME', 'SERVRESP', 321532, 345234, 25);
3110: ** FND_PROFILE.SAVE('P_NAME', 'SERVRESP', 321532, 345234, -1);
3111: ** FND_PROFILE.SAVE('P_NAME', 'SERVRESP', -1, -1, 25);
3112: **
3113: ** returns: TRUE if successful, FALSE if failure.
3114: */
3115: function SAVE(

Line 3144: /* Bug 5603664: APPSPERF:FND:OPTIMIZE FND_PROFILE.VALUE */

3140: x_level_value2_actual NUMBER; -- Added for Server/Resp Hierarchy
3141: l_profile_option_value VARCHAR2(240); -- Bug 3958546
3142: l_defined BOOLEAN; -- Bug 3958546
3143:
3144: /* Bug 5603664: APPSPERF:FND:OPTIMIZE FND_PROFILE.VALUE */
3145: X_NAME_UPPER VARCHAR2(80) := upper(X_NAME);
3146:
3147: cursor C1 is
3148: select application_id, profile_option_id

Line 3149: from fnd_profile_options po

3145: X_NAME_UPPER VARCHAR2(80) := upper(X_NAME);
3146:
3147: cursor C1 is
3148: select application_id, profile_option_id
3149: from fnd_profile_options po
3150: where po.profile_option_name = X_NAME_UPPER
3151: /* Bug 5591340: FND_PROFILE.SAVE SHOULD NOT UPDATE VALUES FOR END_DATED
3152: ** PROFILE OPTIONS
3153: ** Added these date-sensitive conditions to prevent processing of

Line 3151: /* Bug 5591340: FND_PROFILE.SAVE SHOULD NOT UPDATE VALUES FOR END_DATED

3147: cursor C1 is
3148: select application_id, profile_option_id
3149: from fnd_profile_options po
3150: where po.profile_option_name = X_NAME_UPPER
3151: /* Bug 5591340: FND_PROFILE.SAVE SHOULD NOT UPDATE VALUES FOR END_DATED
3152: ** PROFILE OPTIONS
3153: ** Added these date-sensitive conditions to prevent processing of
3154: ** end-dated profile options
3155: */

Line 3174: -- message FND_PROFILE_OPTION_VAL_TOO_LRG into the error stack and

3170: X_LEVEL_VALUE2);
3171: end if;
3172:
3173: -- If profile option value being set is > 240 characters, then place the
3174: -- message FND_PROFILE_OPTION_VAL_TOO_LRG into the error stack and
3175: -- return FALSE.
3176: --
3177: -- The lengthb() function replaced the length() function to handle
3178: -- multibyte characters appropriately.

Line 3180: fnd_message.set_name('FND', 'FND_PROFILE_OPTION_VAL_TOO_LRG');

3176: --
3177: -- The lengthb() function replaced the length() function to handle
3178: -- multibyte characters appropriately.
3179: if lengthb(X_VALUE) > 240 then
3180: fnd_message.set_name('FND', 'FND_PROFILE_OPTION_VAL_TOO_LRG');
3181: fnd_message.set_token('PROFILE_OPTION_NAME', X_NAME);
3182: fnd_message.set_token('PROFILE_OPTION_VALUE', X_VALUE);
3183: return FALSE;
3184: end if;

Line 3222: /* Bug 5603664: APPSPERF:FND:OPTIMIZE FND_PROFILE.VALUE

3218: end if;
3219: end if;
3220:
3221:
3222: /* Bug 5603664: APPSPERF:FND:OPTIMIZE FND_PROFILE.VALUE
3223: ** Generate hashValue and pass it on to FIND and PUT calls.
3224: */
3225: hashValue := dbms_utility.get_hash_value(X_NAME_UPPER,1,TABLE_SIZE);
3226:

Line 3238: /* Bug 3958546: FND_PROFILE.SAVE SHOULD NOT RAISE INVALIDATION EVENT

3234: if CORELOG_IS_ENABLED then
3235: FND_CORE_LOG.PUT_LINE(X_NAME_UPPER,'GSD call FP.S, SL');
3236: end if;
3237:
3238: /* Bug 3958546: FND_PROFILE.SAVE SHOULD NOT RAISE INVALIDATION EVENT
3239: ** IF NO CHANGE IS MADE
3240: */
3241: GET_SPECIFIC_DB(
3242: name_z => X_NAME_UPPER,

Line 3256: /* Bug 3958546: FND_PROFILE.SAVE SHOULD NOT RAISE INVALIDATION EVENT

3252: if CORELOG_IS_ENABLED then
3253: FND_CORE_LOG.PUT_LINE(X_NAME_UPPER,'GSD call FP.S, AL');
3254: end if;
3255:
3256: /* Bug 3958546: FND_PROFILE.SAVE SHOULD NOT RAISE INVALIDATION EVENT
3257: ** IF NO CHANGE IS MADE
3258: */
3259: GET_SPECIFIC_DB(
3260: name_z => X_NAME_UPPER,

Line 3275: /* Bug 3958546: FND_PROFILE.SAVE SHOULD NOT RAISE INVALIDATION EVENT

3271: if CORELOG_IS_ENABLED then
3272: FND_CORE_LOG.PUT_LINE(X_NAME_UPPER,'GSD call FP.S, RL');
3273: end if;
3274:
3275: /* Bug 3958546: FND_PROFILE.SAVE SHOULD NOT RAISE INVALIDATION EVENT
3276: ** IF NO CHANGE IS MADE
3277: */
3278: GET_SPECIFIC_DB(
3279: name_z => X_NAME_UPPER,

Line 3295: /* Bug 3958546: FND_PROFILE.SAVE SHOULD NOT RAISE INVALIDATION EVENT

3291: if CORELOG_IS_ENABLED then
3292: FND_CORE_LOG.PUT_LINE(X_NAME_UPPER,'GSD call FP.S, UL');
3293: end if;
3294:
3295: /* Bug 3958546: FND_PROFILE.SAVE SHOULD NOT RAISE INVALIDATION EVENT
3296: ** IF NO CHANGE IS MADE
3297: */
3298: GET_SPECIFIC_DB(
3299: name_z => X_NAME_UPPER,

Line 3314: /* Bug 3958546: FND_PROFILE.SAVE SHOULD NOT RAISE INVALIDATION EVENT

3310: if CORELOG_IS_ENABLED then
3311: FND_CORE_LOG.PUT_LINE(X_NAME_UPPER,'GSD call FP.S, SRVL');
3312: end if;
3313:
3314: /* Bug 3958546: FND_PROFILE.SAVE SHOULD NOT RAISE INVALIDATION EVENT
3315: ** IF NO CHANGE IS MADE
3316: */
3317: GET_SPECIFIC_DB(
3318: name_z => X_NAME_UPPER,

Line 3333: /* Bug 3958546: FND_PROFILE.SAVE SHOULD NOT RAISE INVALIDATION EVENT

3329: if CORELOG_IS_ENABLED then
3330: FND_CORE_LOG.PUT_LINE(X_NAME_UPPER,'GSD call FP.S, OL');
3331: end if;
3332:
3333: /* Bug 3958546: FND_PROFILE.SAVE SHOULD NOT RAISE INVALIDATION EVENT
3334: ** IF NO CHANGE IS MADE
3335: */
3336: GET_SPECIFIC_DB(
3337: name_z => X_NAME_UPPER,

Line 3353: ** Bug 4025399 :3958546:SERVRESP:FND_PROFILE.SAVE RETURNS TRUE BUT

3349: FND_CORE_LOG.PUT_LINE(X_NAME_UPPER,'GSDW call FP.S, ServRespL');
3350: end if;
3351:
3352: /*
3353: ** Bug 4025399 :3958546:SERVRESP:FND_PROFILE.SAVE RETURNS TRUE BUT
3354: ** DOES NOT SAVE VALUE
3355: **
3356: ** Due to the unique nature of the SERVRESP hierarchy, GET_SPECIFIC_DB
3357: ** cannot be used to check the existing value of the profile option

Line 3373: /* Bug 3958546: FND_PROFILE.SAVE SHOULD NOT RAISE INVALIDATION EVENT

3369: ** server_id_z => X_LEVEL_VALUE2,
3370: ** level_id_z => x_level_id);
3371: */
3372:
3373: /* Bug 3958546: FND_PROFILE.SAVE SHOULD NOT RAISE INVALIDATION EVENT
3374: ** IF NO CHANGE IS MADE
3375: */
3376: GET_SPECIFIC_DB_WNPS(
3377: name_z => X_NAME_UPPER,

Line 3411: FND_PROFILE_OPTION_VALUES_PKG.DELETE_ROW(x_application_id,

3407: IF (X_VALUE is null) then
3408: -- If SERVRESP level, then take LEVEL_VALUE2 into consideration.
3409: if (x_level_id = 10007) then
3410: -- D E L E T E --
3411: FND_PROFILE_OPTION_VALUES_PKG.DELETE_ROW(x_application_id,
3412: x_profile_option_id, x_level_id, x_level_value_actual,
3413: X_LEVEL_VALUE_APP_ID, x_level_value2_actual);
3414: else
3415: -- D E L E T E --

Line 3416: FND_PROFILE_OPTION_VALUES_PKG.DELETE_ROW(x_application_id,

3412: x_profile_option_id, x_level_id, x_level_value_actual,
3413: X_LEVEL_VALUE_APP_ID, x_level_value2_actual);
3414: else
3415: -- D E L E T E --
3416: FND_PROFILE_OPTION_VALUES_PKG.DELETE_ROW(x_application_id,
3417: x_profile_option_id, x_level_id, x_level_value_actual,
3418: X_LEVEL_VALUE_APP_ID);
3419: end if;
3420:

Line 3424: x_last_updated_by := fnd_profile.value('USER_ID');

3420:
3421: ELSE
3422:
3423: x_last_update_date := SYSDATE;
3424: x_last_updated_by := fnd_profile.value('USER_ID');
3425: if x_last_updated_by is NULL then
3426: x_last_updated_by := -1;
3427: end if;
3428: x_last_update_login := fnd_profile.value('LOGIN_ID');

Line 3428: x_last_update_login := fnd_profile.value('LOGIN_ID');

3424: x_last_updated_by := fnd_profile.value('USER_ID');
3425: if x_last_updated_by is NULL then
3426: x_last_updated_by := -1;
3427: end if;
3428: x_last_update_login := fnd_profile.value('LOGIN_ID');
3429: if x_last_update_login is NULL then
3430: x_last_update_login := -1;
3431: end if;
3432:

Line 3438: FND_PROFILE_OPTION_VALUES_PKG.UPDATE_ROW(x_application_id,

3434: -- accordingly. If SERVRESP level, then take LEVEL_VALUE2 into
3435: -- consideration.
3436: if (x_level_id = 10007) then
3437: -- U P D A T E --
3438: FND_PROFILE_OPTION_VALUES_PKG.UPDATE_ROW(x_application_id,
3439: x_profile_option_id, x_level_id, x_level_value_actual,
3440: X_LEVEL_VALUE_APP_ID, x_level_value2_actual, X_VALUE,
3441: x_last_update_date, x_last_updated_by, x_last_update_login);
3442: else

Line 3444: FND_PROFILE_OPTION_VALUES_PKG.UPDATE_ROW(x_application_id,

3440: X_LEVEL_VALUE_APP_ID, x_level_value2_actual, X_VALUE,
3441: x_last_update_date, x_last_updated_by, x_last_update_login);
3442: else
3443: -- U P D A T E --
3444: FND_PROFILE_OPTION_VALUES_PKG.UPDATE_ROW(x_application_id,
3445: x_profile_option_id, x_level_id, x_level_value_actual,
3446: X_LEVEL_VALUE_APP_ID, X_VALUE, x_last_update_date,
3447: x_last_updated_by, x_last_update_login);
3448: end if;

Line 3452: /* Bug 5477866:INCONSISTENT VALUES RETURNED BY FND_PROFILE.VALUE_SPECIFIC

3448: end if;
3449:
3450: END IF;
3451:
3452: /* Bug 5477866:INCONSISTENT VALUES RETURNED BY FND_PROFILE.VALUE_SPECIFIC
3453: ** This block of code was separated from the update/insert code block of
3454: ** SAVE() so that deleted values are properly reflected in level caches
3455: ** just like non-NULL values are cached when saved.
3456: ** Previously, only non-NULL values were being cached in level caches

Line 3587: /* Bug 5603664: APPSPERF:FND:OPTIMIZE FND_PROFILE.VALUE */

3583: defined_z out NOCOPY boolean,
3584: org_id_z in number default null,
3585: server_id_z in number default null) is
3586:
3587: /* Bug 5603664: APPSPERF:FND:OPTIMIZE FND_PROFILE.VALUE */
3588: NAME_UPPER varchar2(80) := UPPER(name_z);
3589:
3590: begin
3591:

Line 3606: ** FND_PROFILE.VALUE_SPECIFIC

3602: server_id_z);
3603: end if;
3604:
3605: /* Bug 5477866: INCONSISTENT VALUES RETURNED BY
3606: ** FND_PROFILE.VALUE_SPECIFIC
3607: ** Check if fnd_cache_versions was updated. This refreshes level caches
3608: ** in order for value_specific to return accurate values should a new
3609: ** profile value be saved in another session. This will introduce a
3610: ** performance degradation which has been deemed necessary for

Line 3639: -- fnd_profile.value_specific('PROFILE_OPTION_NAME');

3635: end if;
3636: -- If NULLs were passed for the context levels, default to current
3637: -- context. This would normally happen when value_specific was called as
3638: -- such:
3639: -- fnd_profile.value_specific('PROFILE_OPTION_NAME');
3640: -- Note that there was no context passed in. Defaulting to current
3641: -- context effectively satisfies the IF condition above. Hence, redirect
3642: -- to GET also.
3643: elsif (user_id_z is NULL) and

Line 3855: ** FND_PROFILE.INITIALIZE also calls this API to initialize the org context.

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.
3859: ** Sets PROFILES_ORG_ID to the current value fnd_global.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 3888: -- equivalent to FND_PROFILE.VALUE('CURRENT_ORG_CONTEXT').

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));
3892: end if;

Line 3890: -- FND_PROFILE_OPTION_VALUES table.

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:
3894: PUT('ORG_NAME', fnd_global.org_name);

Line 4021: -- For FND_PROFILE.INITIALIZE(), the CORELOG

4017: end if;
4018: PUT('USERNAME', NAME);
4019: end if;
4020:
4021: -- For FND_PROFILE.INITIALIZE(), the CORELOG
4022: -- LOG_PROFNAME argument will be the code phase. LOG_PROFVAL will be
4023: -- user_name.
4024: if CORELOG_IS_ENABLED then
4025: CORELOG(

Line 4142: * oracle.apps.fnd.profile.value.update event. This function calls

4138:
4139: /*
4140: * bumpCacheVersion_RF
4141: * The rule function for FND's subscription on the
4142: * oracle.apps.fnd.profile.value.update event. This function calls
4143: * FND_CACHE_VERSION_PKG.bump_version to increase the version of the
4144: * appropriate profile level cache.
4145: */
4146: function bumpCacheVersion_RF (

Line 4194: WF_CORE.CONTEXT('FND_PROFILE', 'bumpCacheVersion_RF',

4190: return 'SUCCESS';
4191:
4192: exception
4193: when others then
4194: WF_CORE.CONTEXT('FND_PROFILE', 'bumpCacheVersion_RF',
4195: p_event.getEventName(), p_subscription_guid);
4196: WF_EVENT.setErrorInfo(p_event, 'ERROR');
4197: return 'ERROR';
4198: end;

Line 4212: ** FND_PROFILE.DELETE('P_NAME', 'SITE');

4208: **
4209: ** ('SITE', 'APPL', 'RESP', 'USER', 'SERVER', 'ORG', or 'SERVRESP').
4210: **
4211: ** Examples of use:
4212: ** FND_PROFILE.DELETE('P_NAME', 'SITE');
4213: ** FND_PROFILE.DELETE('P_NAME', 'APPL', 321532);
4214: ** FND_PROFILE.DELETE('P_NAME', 'RESP', 321532, 345234);
4215: ** FND_PROFILE.DELETE('P_NAME', 'USER', 123321);
4216: ** FND_PROFILE.DELETE('P_NAME', 'SERVER', 25);

Line 4213: ** FND_PROFILE.DELETE('P_NAME', 'APPL', 321532);

4209: ** ('SITE', 'APPL', 'RESP', 'USER', 'SERVER', 'ORG', or 'SERVRESP').
4210: **
4211: ** Examples of use:
4212: ** FND_PROFILE.DELETE('P_NAME', 'SITE');
4213: ** FND_PROFILE.DELETE('P_NAME', 'APPL', 321532);
4214: ** FND_PROFILE.DELETE('P_NAME', 'RESP', 321532, 345234);
4215: ** FND_PROFILE.DELETE('P_NAME', 'USER', 123321);
4216: ** FND_PROFILE.DELETE('P_NAME', 'SERVER', 25);
4217: ** FND_PROFILE.DELETE('P_NAME', 'ORG', 204);

Line 4214: ** FND_PROFILE.DELETE('P_NAME', 'RESP', 321532, 345234);

4210: **
4211: ** Examples of use:
4212: ** FND_PROFILE.DELETE('P_NAME', 'SITE');
4213: ** FND_PROFILE.DELETE('P_NAME', 'APPL', 321532);
4214: ** FND_PROFILE.DELETE('P_NAME', 'RESP', 321532, 345234);
4215: ** FND_PROFILE.DELETE('P_NAME', 'USER', 123321);
4216: ** FND_PROFILE.DELETE('P_NAME', 'SERVER', 25);
4217: ** FND_PROFILE.DELETE('P_NAME', 'ORG', 204);
4218: ** FND_PROFILE.DELETE('P_NAME', 'SERVRESP', 321532, 345234, 25);

Line 4215: ** FND_PROFILE.DELETE('P_NAME', 'USER', 123321);

4211: ** Examples of use:
4212: ** FND_PROFILE.DELETE('P_NAME', 'SITE');
4213: ** FND_PROFILE.DELETE('P_NAME', 'APPL', 321532);
4214: ** FND_PROFILE.DELETE('P_NAME', 'RESP', 321532, 345234);
4215: ** FND_PROFILE.DELETE('P_NAME', 'USER', 123321);
4216: ** FND_PROFILE.DELETE('P_NAME', 'SERVER', 25);
4217: ** FND_PROFILE.DELETE('P_NAME', 'ORG', 204);
4218: ** FND_PROFILE.DELETE('P_NAME', 'SERVRESP', 321532, 345234, 25);
4219: ** FND_PROFILE.DELETE('P_NAME', 'SERVRESP', 321532, 345234, -1);

Line 4216: ** FND_PROFILE.DELETE('P_NAME', 'SERVER', 25);

4212: ** FND_PROFILE.DELETE('P_NAME', 'SITE');
4213: ** FND_PROFILE.DELETE('P_NAME', 'APPL', 321532);
4214: ** FND_PROFILE.DELETE('P_NAME', 'RESP', 321532, 345234);
4215: ** FND_PROFILE.DELETE('P_NAME', 'USER', 123321);
4216: ** FND_PROFILE.DELETE('P_NAME', 'SERVER', 25);
4217: ** FND_PROFILE.DELETE('P_NAME', 'ORG', 204);
4218: ** FND_PROFILE.DELETE('P_NAME', 'SERVRESP', 321532, 345234, 25);
4219: ** FND_PROFILE.DELETE('P_NAME', 'SERVRESP', 321532, 345234, -1);
4220: ** FND_PROFILE.DELETE('P_NAME', 'SERVRESP', -1, -1, 25);

Line 4217: ** FND_PROFILE.DELETE('P_NAME', 'ORG', 204);

4213: ** FND_PROFILE.DELETE('P_NAME', 'APPL', 321532);
4214: ** FND_PROFILE.DELETE('P_NAME', 'RESP', 321532, 345234);
4215: ** FND_PROFILE.DELETE('P_NAME', 'USER', 123321);
4216: ** FND_PROFILE.DELETE('P_NAME', 'SERVER', 25);
4217: ** FND_PROFILE.DELETE('P_NAME', 'ORG', 204);
4218: ** FND_PROFILE.DELETE('P_NAME', 'SERVRESP', 321532, 345234, 25);
4219: ** FND_PROFILE.DELETE('P_NAME', 'SERVRESP', 321532, 345234, -1);
4220: ** FND_PROFILE.DELETE('P_NAME', 'SERVRESP', -1, -1, 25);
4221: **

Line 4218: ** FND_PROFILE.DELETE('P_NAME', 'SERVRESP', 321532, 345234, 25);

4214: ** FND_PROFILE.DELETE('P_NAME', 'RESP', 321532, 345234);
4215: ** FND_PROFILE.DELETE('P_NAME', 'USER', 123321);
4216: ** FND_PROFILE.DELETE('P_NAME', 'SERVER', 25);
4217: ** FND_PROFILE.DELETE('P_NAME', 'ORG', 204);
4218: ** FND_PROFILE.DELETE('P_NAME', 'SERVRESP', 321532, 345234, 25);
4219: ** FND_PROFILE.DELETE('P_NAME', 'SERVRESP', 321532, 345234, -1);
4220: ** FND_PROFILE.DELETE('P_NAME', 'SERVRESP', -1, -1, 25);
4221: **
4222: ** returns: TRUE if successful, FALSE if failure.

Line 4219: ** FND_PROFILE.DELETE('P_NAME', 'SERVRESP', 321532, 345234, -1);

4215: ** FND_PROFILE.DELETE('P_NAME', 'USER', 123321);
4216: ** FND_PROFILE.DELETE('P_NAME', 'SERVER', 25);
4217: ** FND_PROFILE.DELETE('P_NAME', 'ORG', 204);
4218: ** FND_PROFILE.DELETE('P_NAME', 'SERVRESP', 321532, 345234, 25);
4219: ** FND_PROFILE.DELETE('P_NAME', 'SERVRESP', 321532, 345234, -1);
4220: ** FND_PROFILE.DELETE('P_NAME', 'SERVRESP', -1, -1, 25);
4221: **
4222: ** returns: TRUE if successful, FALSE if failure.
4223: **

Line 4220: ** FND_PROFILE.DELETE('P_NAME', 'SERVRESP', -1, -1, 25);

4216: ** FND_PROFILE.DELETE('P_NAME', 'SERVER', 25);
4217: ** FND_PROFILE.DELETE('P_NAME', 'ORG', 204);
4218: ** FND_PROFILE.DELETE('P_NAME', 'SERVRESP', 321532, 345234, 25);
4219: ** FND_PROFILE.DELETE('P_NAME', 'SERVRESP', 321532, 345234, -1);
4220: ** FND_PROFILE.DELETE('P_NAME', 'SERVRESP', -1, -1, 25);
4221: **
4222: ** returns: TRUE if successful, FALSE if failure.
4223: **
4224: */

Line 4245: -- physically deletes the row from fnd_profile_option_values.

4241:
4242: begin
4243:
4244: -- Call SAVE routine and pass NULL for the profile option value. This
4245: -- physically deletes the row from fnd_profile_option_values.
4246: l_deleted := SAVE(X_NAME,
4247: NULL,
4248: X_LEVEL_NAME,
4249: X_LEVEL_VALUE,

Line 4261: end FND_PROFILE;

4257: begin
4258: -- Initialization section
4259: TABLE_SIZE := 8192;
4260:
4261: end FND_PROFILE;