APPS.FND_PLSQL_CACHE dependencies on DBMS_UTILITY

Line 119: dbms_utility.format_error_stack());

115:
116: l_error := l_error || ') failed';
117:
118: l_error := (l_error || g_newline ||
119: dbms_utility.format_error_stack());
120:
121: IF (l_error NOT LIKE '%PL/SQL Call Stack%') THEN
122: l_error := (l_error || g_newline ||
123: dbms_utility.format_call_stack());

Line 123: dbms_utility.format_call_stack());

119: dbms_utility.format_error_stack());
120:
121: IF (l_error NOT LIKE '%PL/SQL Call Stack%') THEN
122: l_error := (l_error || g_newline ||
123: dbms_utility.format_call_stack());
124: END IF;
125:
126: raise_application_error(ERROR_WHEN_OTHERS, l_error);
127:

Line 516: l_key_index := dbms_utility.get_hash_value(l_key, 1,

512: -- Similar logic exists in custom_1to1_get_get_index()
513: --
514: -- Get the key index. (1..px_controller.max_numof_keys)
515: --
516: l_key_index := dbms_utility.get_hash_value(l_key, 1,
517: px_controller.max_numof_keys);
518: --
519: -- Is it in cache?
520: --

Line 548: l_key_index := dbms_utility.get_hash_value(l_key, 1,

544: -- Similar logic exists in custom_1to1_get_put_index()
545: --
546: -- Get the key index. (1..px_controller.max_numof_keys)
547: --
548: l_key_index := dbms_utility.get_hash_value(l_key, 1,
549: px_controller.max_numof_keys);
550:
551: IF (px_controller.keys(l_key_index) IS NULL) THEN
552: --

Line 658: l_key_index := dbms_utility.get_hash_value(l_key, 1,

654: -- Similar logic exists in custom_1tom_get_get_indexes()
655: --
656: -- Get the key index. (1..px_controller.max_numof_keys)
657: --
658: l_key_index := dbms_utility.get_hash_value(l_key, 1,
659: px_controller.max_numof_keys);
660: --
661: -- Is it in cache?
662: --

Line 823: l_key_index := dbms_utility.get_hash_value(l_key, 1,

819: -- Similar logic exists in generic_1to1_get_value()
820: --
821: -- Get the key index. (1..px_controller.max_numof_keys)
822: --
823: l_key_index := dbms_utility.get_hash_value(l_key, 1,
824: px_controller.max_numof_keys);
825: --
826: -- Is it in cache?
827: --

Line 854: l_key_index := dbms_utility.get_hash_value(l_key, 1,

850: -- Similar logic exists in generic_1to1_put_value()
851: --
852: -- Get the key index. (1..px_controller.max_numof_keys)
853: --
854: l_key_index := dbms_utility.get_hash_value(l_key, 1,
855: px_controller.max_numof_keys);
856:
857: IF (px_controller.keys(l_key_index) IS NULL) THEN
858: --

Line 887: l_key_index := dbms_utility.get_hash_value(l_key, 1,

883: BEGIN
884: --
885: -- Get the key index. (1..px_controller.max_numof_keys)
886: --
887: l_key_index := dbms_utility.get_hash_value(l_key, 1,
888: px_controller.max_numof_keys);
889:
890: --
891: -- Is it in cache?

Line 1064: l_key_index := dbms_utility.get_hash_value(l_key, 1,

1060: -- Similar logic exists in generic_1tom_get_values()
1061: --
1062: -- Get the key index. (1..px_controller.max_numof_keys)
1063: --
1064: l_key_index := dbms_utility.get_hash_value(l_key, 1,
1065: px_controller.max_numof_keys);
1066: --
1067: -- Is it in cache?
1068: --

Line 1121: l_key_index := dbms_utility.get_hash_value(l_key, 1,

1117:
1118: --
1119: -- Get the key index. (1..px_controller.max_numof_keys)
1120: --
1121: l_key_index := dbms_utility.get_hash_value(l_key, 1,
1122: px_controller.max_numof_keys);
1123:
1124: --
1125: -- Old entry is overwritten.

Line 1196: l_key_index := dbms_utility.get_hash_value(l_key, 1,

1192: BEGIN
1193: --
1194: -- Get the key index. (1..px_controller.max_numof_keys)
1195: --
1196: l_key_index := dbms_utility.get_hash_value(l_key, 1,
1197: px_controller.max_numof_keys);
1198: --
1199: -- Is it in cache?
1200: --

Line 1548: l_key_index := dbms_utility.get_hash_value(l_key, 1,

1544: l_index NUMBER;
1545: i NUMBER;
1546: l_return VARCHAR2(2000);
1547: BEGIN
1548: l_key_index := dbms_utility.get_hash_value(l_key, 1,
1549: CACHE_MAX_NUMOF_KEYS);
1550: i := 1;
1551: LOOP
1552: l_index := dbms_utility.get_hash_value(l_key || i, 1,

Line 1552: l_index := dbms_utility.get_hash_value(l_key || i, 1,

1548: l_key_index := dbms_utility.get_hash_value(l_key, 1,
1549: CACHE_MAX_NUMOF_KEYS);
1550: i := 1;
1551: LOOP
1552: l_index := dbms_utility.get_hash_value(l_key || i, 1,
1553: CACHE_MAX_NUMOF_KEYS);
1554: IF (l_index = l_key_index) THEN
1555: l_return := p_key || i;
1556: EXIT;