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.

[Home] [Help]

APPS.FND_PROFILE dependencies on DBMS_UTILITY

Line 289: ** TAB_INDEX := dbms_utility.get_hash_value(NAME_UPPER,1,TABLE_SIZE);

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);
290: */
291: if (PROFILE_HASH_VALUE is NULL) then
292: TAB_INDEX := dbms_utility.get_hash_value(NAME_UPPER,1,TABLE_SIZE);
293: else

Line 292: TAB_INDEX := dbms_utility.get_hash_value(NAME_UPPER,1,TABLE_SIZE);

288: **
289: ** TAB_INDEX := dbms_utility.get_hash_value(NAME_UPPER,1,TABLE_SIZE);
290: */
291: if (PROFILE_HASH_VALUE is NULL) then
292: TAB_INDEX := dbms_utility.get_hash_value(NAME_UPPER,1,TABLE_SIZE);
293: else
294: TAB_INDEX := PROFILE_HASH_VALUE;
295: end if;
296:

Line 362: dbms_utility.get_hash_value(NAME,1,TABLE_SIZE));

358: ** calling FIND
359: ** return FIND(UPPER(NAME),NAME_TAB);
360: */
361: return FIND(NAME,NAME_TAB,
362: dbms_utility.get_hash_value(NAME,1,TABLE_SIZE));
363: exception
364: when others then -- The entry doesn't exist
365: return TABLE_SIZE+1;
366: end FIND;

Line 399: ** TABLE_INDEX := dbms_utility.get_hash_value(NAME,1,TABLE_SIZE);

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);
400: */
401: if (PROFILE_HASH_VALUE is NULL) then
402: TABLE_INDEX := dbms_utility.get_hash_value(NAME,1,TABLE_SIZE);
403: else

Line 402: TABLE_INDEX := dbms_utility.get_hash_value(NAME,1,TABLE_SIZE);

398: **
399: ** TABLE_INDEX := dbms_utility.get_hash_value(NAME,1,TABLE_SIZE);
400: */
401: if (PROFILE_HASH_VALUE is NULL) then
402: TABLE_INDEX := dbms_utility.get_hash_value(NAME,1,TABLE_SIZE);
403: else
404: TABLE_INDEX := PROFILE_HASH_VALUE;
405: end if;
406:

Line 492: ** Call dbms_utility.get_hash_value and pass as an argument to PUT

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,
496: dbms_utility.get_hash_value(NAME_UPPER,1,TABLE_SIZE));

Line 496: dbms_utility.get_hash_value(NAME_UPPER,1,TABLE_SIZE));

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,
496: dbms_utility.get_hash_value(NAME_UPPER,1,TABLE_SIZE));
497: -- Log GENERIC PUT Exit
498: if CORELOG_IS_ENABLED then
499: CORELOG(NAME_UPPER,VAL,'Exit Generic FP.P');
500: end if;

Line 547: hashValue := dbms_utility.get_hash_value(name_z,1,TABLE_SIZE);

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
547: hashValue := dbms_utility.get_hash_value(name_z,1,TABLE_SIZE);
548: else
549: hashValue := PROFILE_HASH_VALUE;
550: end if;
551:

Line 795: hashValue := dbms_utility.get_hash_value(name_z,1,TABLE_SIZE);

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
795: hashValue := dbms_utility.get_hash_value(name_z,1,TABLE_SIZE);
796: else
797: hashValue := PROFILE_HASH_VALUE;
798: end if;
799:

Line 2107: hashValue := dbms_utility.get_hash_value(name_z,1,TABLE_SIZE);

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:
2109: -- Determine if any of the context parameters, passed in, is equal to -1.
2110: -- -1 means that the level will be skipped for evaluation. These boolean
2111: -- flags replace the context conditions that check whether the context is

Line 2619: hashValue := dbms_utility.get_hash_value(name_z,1,TABLE_SIZE);

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:
2621: --
2622: -- The algorithm is to check the cache first, if a profile option has
2623: -- been cached before, we will check if the tables were updated since it

Line 3225: hashValue := dbms_utility.get_hash_value(X_NAME_UPPER,1,TABLE_SIZE);

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:
3227: if (X_LEVEL_NAME = 'SITE') then
3228: x_level_id := 10001;
3229: