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_FLEX_XML_PUBLISHER_APIS dependencies on FND_PLSQL_CACHE

Line 7: g_snum_generic_1to1_controller fnd_plsql_cache.cache_1to1_controller_type;

3:
4: --
5: -- Qualifier Segment Number cache, generic version. One value per key
6: --
7: g_snum_generic_1to1_controller fnd_plsql_cache.cache_1to1_controller_type;
8: g_snum_generic_1to1_storage fnd_plsql_cache.generic_cache_values_type;
9: --
10: -- Application cache, generic version. One value per key
11: --

Line 8: g_snum_generic_1to1_storage fnd_plsql_cache.generic_cache_values_type;

4: --
5: -- Qualifier Segment Number cache, generic version. One value per key
6: --
7: g_snum_generic_1to1_controller fnd_plsql_cache.cache_1to1_controller_type;
8: g_snum_generic_1to1_storage fnd_plsql_cache.generic_cache_values_type;
9: --
10: -- Application cache, generic version. One value per key
11: --
12: g_app_generic_1to1_controller fnd_plsql_cache.cache_1to1_controller_type;

Line 12: g_app_generic_1to1_controller fnd_plsql_cache.cache_1to1_controller_type;

8: g_snum_generic_1to1_storage fnd_plsql_cache.generic_cache_values_type;
9: --
10: -- Application cache, generic version. One value per key
11: --
12: g_app_generic_1to1_controller fnd_plsql_cache.cache_1to1_controller_type;
13: g_app_generic_1to1_storage fnd_plsql_cache.generic_cache_values_type;
14:
15: --
16: -- Key Flexfield cache, generic version. One value per key

Line 13: g_app_generic_1to1_storage fnd_plsql_cache.generic_cache_values_type;

9: --
10: -- Application cache, generic version. One value per key
11: --
12: g_app_generic_1to1_controller fnd_plsql_cache.cache_1to1_controller_type;
13: g_app_generic_1to1_storage fnd_plsql_cache.generic_cache_values_type;
14:
15: --
16: -- Key Flexfield cache, generic version. One value per key
17: --

Line 18: g_kflx_generic_1to1_controller fnd_plsql_cache.cache_1to1_controller_type;

14:
15: --
16: -- Key Flexfield cache, generic version. One value per key
17: --
18: g_kflx_generic_1to1_controller fnd_plsql_cache.cache_1to1_controller_type;
19: g_kflx_generic_1to1_storage fnd_plsql_cache.generic_cache_values_type;
20:
21: --
22: -- Key Flexfield Structure Number cache, generic version. Many values per key

Line 19: g_kflx_generic_1to1_storage fnd_plsql_cache.generic_cache_values_type;

15: --
16: -- Key Flexfield cache, generic version. One value per key
17: --
18: g_kflx_generic_1to1_controller fnd_plsql_cache.cache_1to1_controller_type;
19: g_kflx_generic_1to1_storage fnd_plsql_cache.generic_cache_values_type;
20:
21: --
22: -- Key Flexfield Structure Number cache, generic version. Many values per key
23: --

Line 24: g_stno_generic_1tom_controller fnd_plsql_cache.cache_1tom_controller_type;

20:
21: --
22: -- Key Flexfield Structure Number cache, generic version. Many values per key
23: --
24: g_stno_generic_1tom_controller fnd_plsql_cache.cache_1tom_controller_type;
25: g_stno_generic_1tom_storage fnd_plsql_cache.generic_cache_values_type;
26: --
27: -- Key Flexfield Structure cache, generic version. One value per key
28: --

Line 25: g_stno_generic_1tom_storage fnd_plsql_cache.generic_cache_values_type;

21: --
22: -- Key Flexfield Structure Number cache, generic version. Many values per key
23: --
24: g_stno_generic_1tom_controller fnd_plsql_cache.cache_1tom_controller_type;
25: g_stno_generic_1tom_storage fnd_plsql_cache.generic_cache_values_type;
26: --
27: -- Key Flexfield Structure cache, generic version. One value per key
28: --
29: g_str_generic_1to1_controller fnd_plsql_cache.cache_1to1_controller_type;

Line 29: g_str_generic_1to1_controller fnd_plsql_cache.cache_1to1_controller_type;

25: g_stno_generic_1tom_storage fnd_plsql_cache.generic_cache_values_type;
26: --
27: -- Key Flexfield Structure cache, generic version. One value per key
28: --
29: g_str_generic_1to1_controller fnd_plsql_cache.cache_1to1_controller_type;
30: g_str_generic_1to1_storage fnd_plsql_cache.generic_cache_values_type;
31: --
32: --
33: -- Key Flexfield Segment cache, generic version. One value per key

Line 30: g_str_generic_1to1_storage fnd_plsql_cache.generic_cache_values_type;

26: --
27: -- Key Flexfield Structure cache, generic version. One value per key
28: --
29: g_str_generic_1to1_controller fnd_plsql_cache.cache_1to1_controller_type;
30: g_str_generic_1to1_storage fnd_plsql_cache.generic_cache_values_type;
31: --
32: --
33: -- Key Flexfield Segment cache, generic version. One value per key
34: --

Line 35: g_seg_generic_1to1_controller fnd_plsql_cache.cache_1to1_controller_type;

31: --
32: --
33: -- Key Flexfield Segment cache, generic version. One value per key
34: --
35: g_seg_generic_1to1_controller fnd_plsql_cache.cache_1to1_controller_type;
36: g_seg_generic_1to1_storage fnd_plsql_cache.generic_cache_values_type;
37: --
38: -- Key Flexfield Segment TL cache, generic version. One value per key
39: --

Line 36: g_seg_generic_1to1_storage fnd_plsql_cache.generic_cache_values_type;

32: --
33: -- Key Flexfield Segment cache, generic version. One value per key
34: --
35: g_seg_generic_1to1_controller fnd_plsql_cache.cache_1to1_controller_type;
36: g_seg_generic_1to1_storage fnd_plsql_cache.generic_cache_values_type;
37: --
38: -- Key Flexfield Segment TL cache, generic version. One value per key
39: --
40: g_segt_generic_1to1_controller fnd_plsql_cache.cache_1to1_controller_type;

Line 40: g_segt_generic_1to1_controller fnd_plsql_cache.cache_1to1_controller_type;

36: g_seg_generic_1to1_storage fnd_plsql_cache.generic_cache_values_type;
37: --
38: -- Key Flexfield Segment TL cache, generic version. One value per key
39: --
40: g_segt_generic_1to1_controller fnd_plsql_cache.cache_1to1_controller_type;
41: g_segt_generic_1to1_storage fnd_plsql_cache.generic_cache_values_type;
42: --
43: -- Parent Value Set Id cache, generic version. One value per key
44: --

Line 41: g_segt_generic_1to1_storage fnd_plsql_cache.generic_cache_values_type;

37: --
38: -- Key Flexfield Segment TL cache, generic version. One value per key
39: --
40: g_segt_generic_1to1_controller fnd_plsql_cache.cache_1to1_controller_type;
41: g_segt_generic_1to1_storage fnd_plsql_cache.generic_cache_values_type;
42: --
43: -- Parent Value Set Id cache, generic version. One value per key
44: --
45: p_vsid_generic_1to1_controller fnd_plsql_cache.cache_1to1_controller_type;

Line 45: p_vsid_generic_1to1_controller fnd_plsql_cache.cache_1to1_controller_type;

41: g_segt_generic_1to1_storage fnd_plsql_cache.generic_cache_values_type;
42: --
43: -- Parent Value Set Id cache, generic version. One value per key
44: --
45: p_vsid_generic_1to1_controller fnd_plsql_cache.cache_1to1_controller_type;
46: p_vsid_generic_1to1_storage fnd_plsql_cache.generic_cache_values_type;
47: --
48: -- Key Flexfield Segment Info, generic version. Many values per key
49: --

Line 46: p_vsid_generic_1to1_storage fnd_plsql_cache.generic_cache_values_type;

42: --
43: -- Parent Value Set Id cache, generic version. One value per key
44: --
45: p_vsid_generic_1to1_controller fnd_plsql_cache.cache_1to1_controller_type;
46: p_vsid_generic_1to1_storage fnd_plsql_cache.generic_cache_values_type;
47: --
48: -- Key Flexfield Segment Info, generic version. Many values per key
49: --
50: seginf_generic_1tom_controller fnd_plsql_cache.cache_1tom_controller_type;

Line 50: seginf_generic_1tom_controller fnd_plsql_cache.cache_1tom_controller_type;

46: p_vsid_generic_1to1_storage fnd_plsql_cache.generic_cache_values_type;
47: --
48: -- Key Flexfield Segment Info, generic version. Many values per key
49: --
50: seginf_generic_1tom_controller fnd_plsql_cache.cache_1tom_controller_type;
51: seginf_generic_1tom_storage fnd_plsql_cache.generic_cache_values_type;
52: --
53: -- Process KFF Combination, generic version. One value per key
54: --

Line 51: seginf_generic_1tom_storage fnd_plsql_cache.generic_cache_values_type;

47: --
48: -- Key Flexfield Segment Info, generic version. Many values per key
49: --
50: seginf_generic_1tom_controller fnd_plsql_cache.cache_1tom_controller_type;
51: seginf_generic_1tom_storage fnd_plsql_cache.generic_cache_values_type;
52: --
53: -- Process KFF Combination, generic version. One value per key
54: --
55: prcomb_generic_1to1_controller fnd_plsql_cache.cache_1to1_controller_type;

Line 55: prcomb_generic_1to1_controller fnd_plsql_cache.cache_1to1_controller_type;

51: seginf_generic_1tom_storage fnd_plsql_cache.generic_cache_values_type;
52: --
53: -- Process KFF Combination, generic version. One value per key
54: --
55: prcomb_generic_1to1_controller fnd_plsql_cache.cache_1to1_controller_type;
56: prcomb_generic_1to1_storage fnd_plsql_cache.generic_cache_values_type;
57:
58: -- ERROR constants
59: --

Line 56: prcomb_generic_1to1_storage fnd_plsql_cache.generic_cache_values_type;

52: --
53: -- Process KFF Combination, generic version. One value per key
54: --
55: prcomb_generic_1to1_controller fnd_plsql_cache.cache_1to1_controller_type;
56: prcomb_generic_1to1_storage fnd_plsql_cache.generic_cache_values_type;
57:
58: -- ERROR constants
59: --
60: error_others CONSTANT NUMBER := -20100;

Line 632: l_value fnd_plsql_cache.generic_cache_value_type;

628: x_app OUT nocopy app_type)
629: IS
630: l_application app_type;
631: l_key VARCHAR2(2000);
632: l_value fnd_plsql_cache.generic_cache_value_type;
633: l_return_code VARCHAR2(1);
634: BEGIN
635: --
636: -- Create the key. If you have a composite key then concatenate

Line 643: fnd_plsql_cache.generic_1to1_get_value(g_app_generic_1to1_controller,

639: l_key := p_application_short_name;
640: --
641: -- First check the cache.
642: --
643: fnd_plsql_cache.generic_1to1_get_value(g_app_generic_1to1_controller,
644: g_app_generic_1to1_storage,
645: l_key,
646: l_value,
647: l_return_code);

Line 648: IF (l_return_code = fnd_plsql_cache.CACHE_FOUND) THEN

644: g_app_generic_1to1_storage,
645: l_key,
646: l_value,
647: l_return_code);
648: IF (l_return_code = fnd_plsql_cache.CACHE_FOUND) THEN
649: --
650: -- Entity is in the cache, populate the return value.
651: --
652: l_application.application_id := l_value.number_1;

Line 667: fnd_plsql_cache.generic_cache_new_value

663: WHERE fa.application_short_name = p_application_short_name;
664: --
665: -- Create the cache value, and populate it with values came from DB.
666: --
667: fnd_plsql_cache.generic_cache_new_value
668: (x_value => l_value,
669: p_number_1 => l_application.application_id,
670: p_varchar2_1 => l_application.application_short_name);
671:

Line 675: fnd_plsql_cache.generic_1to1_put_value(g_app_generic_1to1_controller,

671:
672: --
673: -- Put the value in cache.
674: --
675: fnd_plsql_cache.generic_1to1_put_value(g_app_generic_1to1_controller,
676: g_app_generic_1to1_storage,
677: l_key,
678: l_value);
679: EXCEPTION

Line 708: l_value fnd_plsql_cache.generic_cache_value_type;

704: IS
705: l_application app_type;
706: l_kff_flx kff_flx_type;
707: l_key VARCHAR2(2000);
708: l_value fnd_plsql_cache.generic_cache_value_type;
709: l_return_code VARCHAR2(1);
710: BEGIN
711: get_app(p_application_short_name, l_application);
712:

Line 720: fnd_plsql_cache.generic_1to1_get_value(g_kflx_generic_1to1_controller,

716: l_key := p_application_short_name || '.' || p_id_flex_code;
717: --
718: -- First check the cache.
719: --
720: fnd_plsql_cache.generic_1to1_get_value(g_kflx_generic_1to1_controller,
721: g_kflx_generic_1to1_storage,
722: l_key,
723: l_value,
724: l_return_code);

Line 725: IF (l_return_code = fnd_plsql_cache.CACHE_FOUND) THEN

721: g_kflx_generic_1to1_storage,
722: l_key,
723: l_value,
724: l_return_code);
725: IF (l_return_code = fnd_plsql_cache.CACHE_FOUND) THEN
726: --
727: -- Entity is in the cache, populate the return value.
728: --
729: l_kff_flx.application_id := l_value.number_1;

Line 747: fnd_plsql_cache.generic_cache_new_value

743: AND fif.id_flex_code = p_id_flex_code;
744: --
745: -- Create the cache value, and populate it with values came from DB.
746: --
747: fnd_plsql_cache.generic_cache_new_value
748: (x_value => l_value,
749: p_number_1 => l_kff_flx.application_id,
750: p_varchar2_1 => l_kff_flx.id_flex_code,
751: p_varchar2_2 => l_kff_flx.set_defining_column_name,

Line 757: fnd_plsql_cache.generic_1to1_put_value(g_kflx_generic_1to1_controller,

753:
754: --
755: -- Put the value in cache.
756: --
757: fnd_plsql_cache.generic_1to1_put_value(g_kflx_generic_1to1_controller,
758: g_kflx_generic_1to1_storage,
759: l_key,
760: l_value);
761: EXCEPTION

Line 789: l_values fnd_plsql_cache.generic_cache_values_type;

785: x_numof_structures OUT nocopy NUMBER,
786: x_structure_numbers OUT nocopy number_array_type)
787: IS
788: l_key VARCHAR2(2000);
789: l_values fnd_plsql_cache.generic_cache_values_type;
790: l_numof_values NUMBER;
791: l_return_code VARCHAR2(1);
792: i NUMBER;
793: l_numof_structures NUMBER;

Line 804: fnd_plsql_cache.generic_1tom_get_values(g_stno_generic_1tom_controller,

800:
801: --
802: -- First check the cache.
803: --
804: fnd_plsql_cache.generic_1tom_get_values(g_stno_generic_1tom_controller,
805: g_stno_generic_1tom_storage,
806: l_key,
807: l_numof_values,
808: l_values,

Line 811: IF (l_return_code = fnd_plsql_cache.CACHE_FOUND) THEN

807: l_numof_values,
808: l_values,
809: l_return_code);
810:
811: IF (l_return_code = fnd_plsql_cache.CACHE_FOUND) THEN
812: --
813: -- Entity is in the cache, populate the return values.
814: --
815: FOR i IN 1..l_numof_values LOOP

Line 834: fnd_plsql_cache.generic_cache_new_value

830: FOR i IN 1..l_structure_numbers.COUNT LOOP
831: --
832: -- Create the cache value, and populate it with values came from DB.
833: --
834: fnd_plsql_cache.generic_cache_new_value
835: (x_value => l_values(i),
836: p_number_1 => l_structure_numbers(i));
837: END LOOP;
838: l_numof_values := l_numof_structures;

Line 842: fnd_plsql_cache.generic_1tom_put_values(g_stno_generic_1tom_controller,

838: l_numof_values := l_numof_structures;
839: --
840: -- Put the values in cache.
841: --
842: fnd_plsql_cache.generic_1tom_put_values(g_stno_generic_1tom_controller,
843: g_stno_generic_1tom_storage,
844: l_key,
845: l_numof_values,
846: l_values);

Line 879: l_value fnd_plsql_cache.generic_cache_value_type;

875: x_kff_str OUT nocopy kff_str_type)
876: IS
877: l_key VARCHAR2(2000);
878: l_return_code VARCHAR2(1);
879: l_value fnd_plsql_cache.generic_cache_value_type;
880: l_kff_str kff_str_type;
881: BEGIN
882: --
883: -- Create the key.

Line 890: fnd_plsql_cache.generic_1to1_get_value(g_str_generic_1to1_controller,

886:
887: --
888: -- First check the cache.
889: --
890: fnd_plsql_cache.generic_1to1_get_value(g_str_generic_1to1_controller,
891: g_str_generic_1to1_storage,
892: l_key,
893: l_value,
894: l_return_code);

Line 896: IF (l_return_code = fnd_plsql_cache.CACHE_FOUND) THEN

892: l_key,
893: l_value,
894: l_return_code);
895:
896: IF (l_return_code = fnd_plsql_cache.CACHE_FOUND) THEN
897: --
898: -- Entity is in the cache, populate the return value.
899: --
900: l_kff_str.application_id := l_value.number_1;

Line 919: fnd_plsql_cache.generic_cache_new_value

915: AND fifst.id_flex_num = p_id_flex_num;
916: --
917: -- Create the cache value, and populate it with values came from DB.
918: --
919: fnd_plsql_cache.generic_cache_new_value
920: (x_value => l_value,
921: p_number_1 => l_kff_str.application_id,
922: p_varchar2_1 => l_kff_str.id_flex_code,
923: p_number_2 => l_kff_str.id_flex_num,

Line 929: fnd_plsql_cache.generic_1to1_put_value(g_str_generic_1to1_controller,

925:
926: --
927: -- Put the value in cache.
928: --
929: fnd_plsql_cache.generic_1to1_put_value(g_str_generic_1to1_controller,
930: g_str_generic_1to1_storage,
931: l_key,
932: l_value);
933: EXCEPTION

Line 1011: l_value fnd_plsql_cache.generic_cache_value_type;

1007: l_nsegments NUMBER;
1008: l_tmp_number NUMBER;
1009: l_display_index NUMBER;
1010: l_parent_value_set_id fnd_flex_value_sets.parent_flex_value_set_id%TYPE;
1011: l_value fnd_plsql_cache.generic_cache_value_type;
1012: l_key VARCHAR2(2000);
1013: l_values fnd_plsql_cache.generic_cache_values_type;
1014: l_numof_values NUMBER;
1015: l_return_code VARCHAR2(1);

Line 1013: l_values fnd_plsql_cache.generic_cache_values_type;

1009: l_display_index NUMBER;
1010: l_parent_value_set_id fnd_flex_value_sets.parent_flex_value_set_id%TYPE;
1011: l_value fnd_plsql_cache.generic_cache_value_type;
1012: l_key VARCHAR2(2000);
1013: l_values fnd_plsql_cache.generic_cache_values_type;
1014: l_numof_values NUMBER;
1015: l_return_code VARCHAR2(1);
1016: l_segment_info_array segment_info_array;
1017:

Line 1127: l_value fnd_plsql_cache.generic_cache_value_type;

1123: RETURN BOOLEAN
1124: IS
1125: l_key VARCHAR2(2000);
1126: l_return_code VARCHAR2(1);
1127: l_value fnd_plsql_cache.generic_cache_value_type;
1128: l_segment_number NUMBER;
1129: this_segment_num NUMBER;
1130: BEGIN
1131: --

Line 1139: fnd_plsql_cache.generic_1to1_get_value(g_snum_generic_1to1_controller,

1135:
1136: --
1137: -- First check the cache.
1138: --
1139: fnd_plsql_cache.generic_1to1_get_value(g_snum_generic_1to1_controller,
1140: g_snum_generic_1to1_storage,
1141: l_key,
1142: l_value,
1143: l_return_code);

Line 1144: IF (l_return_code = fnd_plsql_cache.CACHE_FOUND) THEN

1140: g_snum_generic_1to1_storage,
1141: l_key,
1142: l_value,
1143: l_return_code);
1144: IF (l_return_code = fnd_plsql_cache.CACHE_FOUND) THEN
1145: --
1146: -- Entity is in the cache, populate the return value.
1147: --
1148: l_segment_number := l_value.number_1;

Line 1188: fnd_plsql_cache.generic_cache_new_value

1184:
1185: --
1186: -- Create the cache value, and populate it with values came from DB.
1187: --
1188: fnd_plsql_cache.generic_cache_new_value
1189: (x_value => l_value,
1190: p_number_1 => l_segment_number);
1191: --
1192: -- Put the value in cache.

Line 1194: fnd_plsql_cache.generic_1to1_put_value(g_snum_generic_1to1_controller,

1190: p_number_1 => l_segment_number);
1191: --
1192: -- Put the value in cache.
1193: --
1194: fnd_plsql_cache.generic_1to1_put_value(g_snum_generic_1to1_controller,
1195: g_snum_generic_1to1_storage,
1196: l_key,
1197: l_value);
1198: END IF;

Line 1239: fnd_plsql_cache.generic_1tom_get_values(seginf_generic_1tom_controller,

1235: l_key := p_kff_str.application_id||'.'||p_kff_str.id_flex_code||'.'||p_kff_str.id_flex_num;
1236: --
1237: -- First check the cache.
1238: --
1239: fnd_plsql_cache.generic_1tom_get_values(seginf_generic_1tom_controller,
1240: seginf_generic_1tom_storage,
1241: l_key,
1242: l_numof_values,
1243: l_values,

Line 1245: IF (l_return_code = fnd_plsql_cache.CACHE_FOUND) THEN

1241: l_key,
1242: l_numof_values,
1243: l_values,
1244: l_return_code);
1245: IF (l_return_code = fnd_plsql_cache.CACHE_FOUND) THEN
1246: --
1247: -- Entity is in the cache, populate the return values.
1248: --
1249: FOR i IN 1..l_numof_values LOOP

Line 1266: fnd_plsql_cache.generic_cache_new_value

1262: l_segment_info_array(l_nsegments).flex_value_set_id := l_segment_info.flex_value_set_id;
1263: --
1264: -- Create the cache value, and populate it with values came from DB.
1265: --
1266: fnd_plsql_cache.generic_cache_new_value
1267: (x_value => l_values(l_nsegments),
1268: p_varchar2_1 => l_segment_info.application_column_name,
1269: p_varchar2_2 => l_segment_info.enabled_flag,
1270: p_varchar2_3 => l_segment_info.display_flag,

Line 1276: fnd_plsql_cache.generic_1tom_put_values(seginf_generic_1tom_controller,

1272: END LOOP;
1273: --
1274: -- Put the values in cache.
1275: --
1276: fnd_plsql_cache.generic_1tom_put_values(seginf_generic_1tom_controller,
1277: seginf_generic_1tom_storage,
1278: l_key,
1279: l_nsegments,
1280: l_values);

Line 1350: fnd_plsql_cache.generic_1to1_get_value(p_vsid_generic_1to1_controller,

1346: l_key := l_segment_info_array(i).flex_value_set_id;
1347: --
1348: -- First check the cache.
1349: --
1350: fnd_plsql_cache.generic_1to1_get_value(p_vsid_generic_1to1_controller,
1351: p_vsid_generic_1to1_storage,
1352: l_key,
1353: l_value,
1354: l_return_code);

Line 1355: IF (l_return_code = fnd_plsql_cache.CACHE_FOUND) THEN

1351: p_vsid_generic_1to1_storage,
1352: l_key,
1353: l_value,
1354: l_return_code);
1355: IF (l_return_code = fnd_plsql_cache.CACHE_FOUND) THEN
1356: --
1357: -- Entity is in the cache, populate the return value.
1358: --
1359: l_parent_value_set_id := l_value.number_1;

Line 1370: fnd_plsql_cache.generic_cache_new_value

1366: WHERE flex_value_set_id = l_segment_info_array(i).flex_value_set_id;
1367: --
1368: -- Create the cache value, and populate it with values came from DB.
1369: --
1370: fnd_plsql_cache.generic_cache_new_value
1371: (x_value => l_value,
1372: p_number_1 => l_parent_value_set_id);
1373: --
1374: -- Put the value in cache.

Line 1376: fnd_plsql_cache.generic_1to1_put_value(p_vsid_generic_1to1_controller, p_vsid_generic_1to1_storage,

1372: p_number_1 => l_parent_value_set_id);
1373: --
1374: -- Put the value in cache.
1375: --
1376: fnd_plsql_cache.generic_1to1_put_value(p_vsid_generic_1to1_controller, p_vsid_generic_1to1_storage,
1377: l_key,
1378: l_value);
1379: END IF;
1380:

Line 1452: l_value fnd_plsql_cache.generic_cache_value_type;

1448: p_application_column_name IN fnd_id_flex_segments.application_column_name%TYPE,
1449: x_kff_seg OUT nocopy kff_seg_type)
1450: IS
1451: l_key VARCHAR2(2000);
1452: l_value fnd_plsql_cache.generic_cache_value_type;
1453: l_return_code VARCHAR2(1);
1454: l_kff_seg kff_seg_type;
1455: BEGIN
1456: --

Line 1463: fnd_plsql_cache.generic_1to1_get_value(g_seg_generic_1to1_controller,

1459: l_key := p_kff_str.application_id || '.' || p_kff_str.id_flex_code || '.' || p_kff_str.id_flex_num || '.' || p_application_column_name;
1460: --
1461: -- First check the cache.
1462: --
1463: fnd_plsql_cache.generic_1to1_get_value(g_seg_generic_1to1_controller,
1464: g_seg_generic_1to1_storage,
1465: l_key,
1466: l_value,
1467: l_return_code);

Line 1468: IF (l_return_code = fnd_plsql_cache.CACHE_FOUND) THEN

1464: g_seg_generic_1to1_storage,
1465: l_key,
1466: l_value,
1467: l_return_code);
1468: IF (l_return_code = fnd_plsql_cache.CACHE_FOUND) THEN
1469: --
1470: -- Entity is in the cache, populate the return value.
1471: --
1472: l_kff_seg.application_id := l_value.number_1;

Line 1491: fnd_plsql_cache.generic_cache_new_value

1487: AND fifsg.application_column_name = p_application_column_name;
1488: --
1489: -- Create the cache value, and populate it with values came from DB.
1490: --
1491: fnd_plsql_cache.generic_cache_new_value
1492: (x_value => l_value,
1493: p_number_1 => l_kff_seg.application_id,
1494: p_varchar2_1 => l_kff_seg.id_flex_code,
1495: p_number_2 => l_kff_seg.id_flex_num,

Line 1501: fnd_plsql_cache.generic_1to1_put_value(g_seg_generic_1to1_controller,

1497:
1498: --
1499: -- Put the value in cache.
1500: --
1501: fnd_plsql_cache.generic_1to1_put_value(g_seg_generic_1to1_controller,
1502: g_seg_generic_1to1_storage,
1503: l_key,
1504: l_value);
1505: EXCEPTION

Line 1536: l_value fnd_plsql_cache.generic_cache_value_type;

1532: (p_kff_seg IN kff_seg_type,
1533: x_kff_seg_tl OUT nocopy kff_seg_tl_type)
1534: IS
1535: l_key VARCHAR2(2000);
1536: l_value fnd_plsql_cache.generic_cache_value_type;
1537: l_return_code VARCHAR2(1);
1538: l_kff_seg_tl kff_seg_tl_type;
1539: BEGIN
1540: --

Line 1547: fnd_plsql_cache.generic_1to1_get_value(g_segt_generic_1to1_controller,

1543: l_key := p_kff_seg.application_id || '.' || p_kff_seg.id_flex_code || '.' || p_kff_seg.id_flex_num || '.' || p_kff_seg.application_column_name || '.' || userenv('LANG');
1544: --
1545: -- First check the cache.
1546: --
1547: fnd_plsql_cache.generic_1to1_get_value(g_segt_generic_1to1_controller,
1548: g_segt_generic_1to1_storage,
1549: l_key,
1550: l_value,
1551: l_return_code);

Line 1552: IF (l_return_code = fnd_plsql_cache.CACHE_FOUND) THEN

1548: g_segt_generic_1to1_storage,
1549: l_key,
1550: l_value,
1551: l_return_code);
1552: IF (l_return_code = fnd_plsql_cache.CACHE_FOUND) THEN
1553: --
1554: -- Entity is in the cache, populate the return value.
1555: --
1556: l_kff_seg_tl.form_above_prompt := l_value.varchar2_1;

Line 1575: fnd_plsql_cache.generic_cache_new_value

1571:
1572: --
1573: -- Create the cache value, and populate it with values came from DB.
1574: --
1575: fnd_plsql_cache.generic_cache_new_value
1576: (x_value => l_value,
1577: p_varchar2_1 => l_kff_seg_tl.form_above_prompt,
1578: p_varchar2_2 => l_kff_seg_tl.form_left_prompt);
1579:

Line 1583: fnd_plsql_cache.generic_1to1_put_value(g_segt_generic_1to1_controller,

1579:
1580: --
1581: -- Put the value in cache.
1582: --
1583: fnd_plsql_cache.generic_1to1_put_value(g_segt_generic_1to1_controller,
1584: g_segt_generic_1to1_storage,
1585: l_key,
1586: l_value);
1587: EXCEPTION

Line 2050: l_value fnd_plsql_cache.generic_cache_value_type;

2046: l_flex_values fnd_flex_server1.stringarray;
2047: n_segments NUMBER;
2048:
2049: l_key VARCHAR2(2000);
2050: l_value fnd_plsql_cache.generic_cache_value_type;
2051: l_return_code VARCHAR2(1);
2052: BEGIN
2053: --
2054: -- For performance reasons, this API assumes that all of the input

Line 2066: fnd_plsql_cache.generic_1to1_get_value(prcomb_generic_1to1_controller,

2062:
2063: --
2064: -- First check the cache.
2065: --
2066: fnd_plsql_cache.generic_1to1_get_value(prcomb_generic_1to1_controller,
2067: prcomb_generic_1to1_storage,
2068: l_key,
2069: l_value,
2070: l_return_code);

Line 2072: IF (l_return_code = fnd_plsql_cache.CACHE_FOUND) THEN

2068: l_key,
2069: l_value,
2070: l_return_code);
2071:
2072: IF (l_return_code = fnd_plsql_cache.CACHE_FOUND) THEN
2073: --
2074: -- Entity is in the cache, populate the return value.
2075: --
2076: l_return := l_value.varchar2_1;

Line 2236: fnd_plsql_cache.generic_cache_new_value

2232: <>
2233: --
2234: -- Create the cache value, and populate it with values came from DB.
2235: --
2236: fnd_plsql_cache.generic_cache_new_value
2237: (x_value => l_value,
2238: p_varchar2_1 => l_return);
2239:
2240: --

Line 2243: fnd_plsql_cache.generic_1to1_put_value(prcomb_generic_1to1_controller,

2239:
2240: --
2241: -- Put the value in cache.
2242: --
2243: fnd_plsql_cache.generic_1to1_put_value(prcomb_generic_1to1_controller,
2244: prcomb_generic_1to1_storage,
2245: l_key,
2246: l_value);
2247: RETURN (l_return);

Line 2789: fnd_plsql_cache.generic_1to1_init('Ql.Segnum Generic 1to1 Cache',

2785: --
2786: --
2787: -- Qualifier Segment Number Generic 1to1 Cache.
2788: --
2789: fnd_plsql_cache.generic_1to1_init('Ql.Segnum Generic 1to1 Cache',
2790: g_snum_generic_1to1_controller,
2791: g_snum_generic_1to1_storage);
2792: -- Application Generic 1to1 Cache.
2793: --

Line 2794: fnd_plsql_cache.generic_1to1_init('Application Generic 1to1 Cache',

2790: g_snum_generic_1to1_controller,
2791: g_snum_generic_1to1_storage);
2792: -- Application Generic 1to1 Cache.
2793: --
2794: fnd_plsql_cache.generic_1to1_init('Application Generic 1to1 Cache',
2795: g_app_generic_1to1_controller,
2796: g_app_generic_1to1_storage);
2797: --
2798: -- Key Flexfield Generic 1to1 Cache.

Line 2800: fnd_plsql_cache.generic_1to1_init('KFF Generic 1to1 Cache',

2796: g_app_generic_1to1_storage);
2797: --
2798: -- Key Flexfield Generic 1to1 Cache.
2799: --
2800: fnd_plsql_cache.generic_1to1_init('KFF Generic 1to1 Cache',
2801: g_kflx_generic_1to1_controller,
2802: g_kflx_generic_1to1_storage);
2803: --
2804: -- Key Flexfield Structure Numbers Generic 1toM Cache

Line 2806: fnd_plsql_cache.generic_1tom_init('KFF Str No. Generic 1toM Cache',

2802: g_kflx_generic_1to1_storage);
2803: --
2804: -- Key Flexfield Structure Numbers Generic 1toM Cache
2805: --
2806: fnd_plsql_cache.generic_1tom_init('KFF Str No. Generic 1toM Cache',
2807: g_stno_generic_1tom_controller,
2808: g_stno_generic_1tom_storage);
2809:
2810: --

Line 2813: fnd_plsql_cache.generic_1to1_init('KFF Structure 1to1 Cache',

2809:
2810: --
2811: -- Key Flexfield Structure Generic 1to1 Cache.
2812: --
2813: fnd_plsql_cache.generic_1to1_init('KFF Structure 1to1 Cache',
2814: g_str_generic_1to1_controller,
2815: g_str_generic_1to1_storage);
2816: --
2817: -- Key Flexfield Segment Generic 1to1 Cache.

Line 2819: fnd_plsql_cache.generic_1to1_init('KFF Segment 1to1 Cache',

2815: g_str_generic_1to1_storage);
2816: --
2817: -- Key Flexfield Segment Generic 1to1 Cache.
2818: --
2819: fnd_plsql_cache.generic_1to1_init('KFF Segment 1to1 Cache',
2820: g_seg_generic_1to1_controller,
2821: g_seg_generic_1to1_storage);
2822: --
2823: -- Key Flexfield Segment TL Generic 1to1 Cache.

Line 2825: fnd_plsql_cache.generic_1to1_init('KFF Seg TL 1to1 Cache',

2821: g_seg_generic_1to1_storage);
2822: --
2823: -- Key Flexfield Segment TL Generic 1to1 Cache.
2824: --
2825: fnd_plsql_cache.generic_1to1_init('KFF Seg TL 1to1 Cache',
2826: g_segt_generic_1to1_controller,
2827: g_segt_generic_1to1_storage);
2828: --
2829: -- Parent Value Set Id Generic 1to1 Cache.

Line 2831: fnd_plsql_cache.generic_1to1_init('Parent VSet Id 1to1 Cache',

2827: g_segt_generic_1to1_storage);
2828: --
2829: -- Parent Value Set Id Generic 1to1 Cache.
2830: --
2831: fnd_plsql_cache.generic_1to1_init('Parent VSet Id 1to1 Cache',
2832: p_vsid_generic_1to1_controller,
2833: p_vsid_generic_1to1_storage);
2834: --
2835: -- Key Flexfield Segment Info Generic 1toM Cache

Line 2837: fnd_plsql_cache.generic_1tom_init('KFF SegInfo Generic 1toM Cache',

2833: p_vsid_generic_1to1_storage);
2834: --
2835: -- Key Flexfield Segment Info Generic 1toM Cache
2836: --
2837: fnd_plsql_cache.generic_1tom_init('KFF SegInfo Generic 1toM Cache',
2838: seginf_generic_1tom_controller,
2839: seginf_generic_1tom_storage);
2840: --
2841: -- Process KFF Combination Generic 1to1 Cache.

Line 2843: fnd_plsql_cache.generic_1to1_init('Process KFF Comb. 1to1 Cache',

2839: seginf_generic_1tom_storage);
2840: --
2841: -- Process KFF Combination Generic 1to1 Cache.
2842: --
2843: fnd_plsql_cache.generic_1to1_init('Process KFF Comb. 1to1 Cache',
2844: prcomb_generic_1to1_controller,
2845: prcomb_generic_1to1_storage);
2846:
2847: g_newline := fnd_global.newline();