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

Line 24: g_cache_value fnd_plsql_cache.generic_cache_value_type;

20: -- CACHING
21: -- ==================================================
22: g_cache_return_code VARCHAR2(30);
23: g_cache_key VARCHAR2(2000);
24: g_cache_value fnd_plsql_cache.generic_cache_value_type;
25:
26: -- --------------------------------------------------
27: -- uqs : Unique Qualifier to Segment Cache.
28: -- --------------------------------------------------

Line 29: uqs_cache_controller fnd_plsql_cache.cache_1to1_controller_type;

25:
26: -- --------------------------------------------------
27: -- uqs : Unique Qualifier to Segment Cache.
28: -- --------------------------------------------------
29: uqs_cache_controller fnd_plsql_cache.cache_1to1_controller_type;
30: uqs_cache_storage fnd_plsql_cache.generic_cache_values_type;
31:
32: -- --------------------------------------------------
33: -- gsn : Get Segment Number Cache.

Line 30: uqs_cache_storage fnd_plsql_cache.generic_cache_values_type;

26: -- --------------------------------------------------
27: -- uqs : Unique Qualifier to Segment Cache.
28: -- --------------------------------------------------
29: uqs_cache_controller fnd_plsql_cache.cache_1to1_controller_type;
30: uqs_cache_storage fnd_plsql_cache.generic_cache_values_type;
31:
32: -- --------------------------------------------------
33: -- gsn : Get Segment Number Cache.
34: -- --------------------------------------------------

Line 35: gsn_cache_controller fnd_plsql_cache.cache_1to1_controller_type;

31:
32: -- --------------------------------------------------
33: -- gsn : Get Segment Number Cache.
34: -- --------------------------------------------------
35: gsn_cache_controller fnd_plsql_cache.cache_1to1_controller_type;
36: gsn_cache_storage fnd_plsql_cache.generic_cache_values_type;
37:
38: -- ----------------------------------------
39: -- idc : CCID Cache.

Line 36: gsn_cache_storage fnd_plsql_cache.generic_cache_values_type;

32: -- --------------------------------------------------
33: -- gsn : Get Segment Number Cache.
34: -- --------------------------------------------------
35: gsn_cache_controller fnd_plsql_cache.cache_1to1_controller_type;
36: gsn_cache_storage fnd_plsql_cache.generic_cache_values_type;
37:
38: -- ----------------------------------------
39: -- idc : CCID Cache.
40: --

Line 47: idc_cache_controller fnd_plsql_cache.cache_1to1_controller_type;

43: --
44: -- Combination : || NEWLINE || ... || NEWLINE || || NEWLINE
45: --
46: -- ----------------------------------------
47: idc_cache_controller fnd_plsql_cache.cache_1to1_controller_type;
48: idc_cache_storage fnd_plsql_cache.generic_cache_values_type;
49:
50: TYPE idc_last_record_type IS RECORD
51: (primary_key VARCHAR2(32000) := NULL,

Line 48: idc_cache_storage fnd_plsql_cache.generic_cache_values_type;

44: -- Combination : || NEWLINE || ... || NEWLINE || || NEWLINE
45: --
46: -- ----------------------------------------
47: idc_cache_controller fnd_plsql_cache.cache_1to1_controller_type;
48: idc_cache_storage fnd_plsql_cache.generic_cache_values_type;
49:
50: TYPE idc_last_record_type IS RECORD
51: (primary_key VARCHAR2(32000) := NULL,
52: encoded_error_message VARCHAR2(32000),

Line 54: segment_values fnd_plsql_cache.cache_varchar2_varray_type);

50: TYPE idc_last_record_type IS RECORD
51: (primary_key VARCHAR2(32000) := NULL,
52: encoded_error_message VARCHAR2(32000),
53: segment_count NUMBER,
54: segment_values fnd_plsql_cache.cache_varchar2_varray_type);
55:
56: idc_last_record idc_last_record_type;
57:
58: -- ----------------------------------------

Line 67: ccc_cache_controller fnd_plsql_cache.cache_1to1_controller_type;

63: -- || NEWLINE || || NEWLINE ||
64: -- || || NEWLINE ||
65: --
66: -- ----------------------------------------
67: ccc_cache_controller fnd_plsql_cache.cache_1to1_controller_type;
68: ccc_cache_storage fnd_plsql_cache.generic_cache_values_type;
69:
70: TYPE ccc_last_record_type IS RECORD
71: (primary_key VARCHAR2(32000) := NULL,

Line 68: ccc_cache_storage fnd_plsql_cache.generic_cache_values_type;

64: -- || || NEWLINE ||
65: --
66: -- ----------------------------------------
67: ccc_cache_controller fnd_plsql_cache.cache_1to1_controller_type;
68: ccc_cache_storage fnd_plsql_cache.generic_cache_values_type;
69:
70: TYPE ccc_last_record_type IS RECORD
71: (primary_key VARCHAR2(32000) := NULL,
72: encoded_error_message VARCHAR2(32000),

Line 97: fnd_plsql_cache.generic_1to1_get_value(idc_cache_controller,

93: p_id_flex_code || '.' ||
94: p_id_flex_num || '.' ||
95: p_ccid);
96:
97: fnd_plsql_cache.generic_1to1_get_value(idc_cache_controller,
98: idc_cache_storage,
99: g_cache_key,
100: g_cache_value,
101: g_cache_return_code);

Line 103: IF (g_cache_return_code = fnd_plsql_cache.CACHE_FOUND) THEN

99: g_cache_key,
100: g_cache_value,
101: g_cache_return_code);
102:
103: IF (g_cache_return_code = fnd_plsql_cache.CACHE_FOUND) THEN
104: IF (g_cache_value.varchar2_1 IS NULL) THEN
105: --
106: -- No error message.
107: --

Line 108: g_cache_return_code := fnd_plsql_cache.CACHE_VALID;

104: IF (g_cache_value.varchar2_1 IS NULL) THEN
105: --
106: -- No error message.
107: --
108: g_cache_return_code := fnd_plsql_cache.CACHE_VALID;
109: ELSE
110: g_cache_return_code := fnd_plsql_cache.CACHE_INVALID;
111: END IF;
112: END IF;

Line 110: g_cache_return_code := fnd_plsql_cache.CACHE_INVALID;

106: -- No error message.
107: --
108: g_cache_return_code := fnd_plsql_cache.CACHE_VALID;
109: ELSE
110: g_cache_return_code := fnd_plsql_cache.CACHE_INVALID;
111: END IF;
112: END IF;
113:
114: IF (g_cache_return_code = fnd_plsql_cache.CACHE_VALID) THEN

Line 114: IF (g_cache_return_code = fnd_plsql_cache.CACHE_VALID) THEN

110: g_cache_return_code := fnd_plsql_cache.CACHE_INVALID;
111: END IF;
112: END IF;
113:
114: IF (g_cache_return_code = fnd_plsql_cache.CACHE_VALID) THEN
115: GOTO return_true;
116: ELSIF (g_cache_return_code = fnd_plsql_cache.CACHE_INVALID) THEN
117: GOTO return_false;
118: END IF;

Line 116: ELSIF (g_cache_return_code = fnd_plsql_cache.CACHE_INVALID) THEN

112: END IF;
113:
114: IF (g_cache_return_code = fnd_plsql_cache.CACHE_VALID) THEN
115: GOTO return_true;
116: ELSIF (g_cache_return_code = fnd_plsql_cache.CACHE_INVALID) THEN
117: GOTO return_false;
118: END IF;
119:
120: --

Line 136: fnd_plsql_cache.generic_cache_new_value

132: FOR i IN 1..Nvl(fnd_flex_keyval.segment_count, 0) LOOP
133: l_vc2 := l_vc2 || fnd_flex_keyval.segment_value(i) || chr_newline;
134: END LOOP;
135:
136: fnd_plsql_cache.generic_cache_new_value
137: (x_value => g_cache_value,
138: p_varchar2_1 => NULL,
139: p_number_1 => Nvl(fnd_flex_keyval.segment_count, 0),
140: p_varchar2_2 => l_vc2);

Line 142: fnd_plsql_cache.generic_1to1_put_value(idc_cache_controller,

138: p_varchar2_1 => NULL,
139: p_number_1 => Nvl(fnd_flex_keyval.segment_count, 0),
140: p_varchar2_2 => l_vc2);
141:
142: fnd_plsql_cache.generic_1to1_put_value(idc_cache_controller,
143: idc_cache_storage,
144: g_cache_key,
145: g_cache_value);
146: GOTO return_true;

Line 148: fnd_plsql_cache.generic_cache_new_value

144: g_cache_key,
145: g_cache_value);
146: GOTO return_true;
147: ELSE
148: fnd_plsql_cache.generic_cache_new_value
149: (x_value => g_cache_value,
150: p_varchar2_1 => Nvl(fnd_flex_keyval.encoded_error_message,
151: 'FND-FLEX'),
152: p_number_1 => 0,

Line 155: fnd_plsql_cache.generic_1to1_put_value(idc_cache_controller,

151: 'FND-FLEX'),
152: p_number_1 => 0,
153: p_varchar2_2 => NULL);
154:
155: fnd_plsql_cache.generic_1to1_put_value(idc_cache_controller,
156: idc_cache_storage,
157: g_cache_key,
158: g_cache_value);
159: GOTO return_false;

Line 163: IF ((g_cache_return_code = fnd_plsql_cache.CACHE_VALID) AND

159: GOTO return_false;
160: END IF;
161:
162: <>
163: IF ((g_cache_return_code = fnd_plsql_cache.CACHE_VALID) AND
164: (g_cache_key = idc_last_record.primary_key)) THEN
165: RETURN(TRUE);
166: END IF;
167:

Line 183: IF ((g_cache_return_code = fnd_plsql_cache.CACHE_INVALID) AND

179: END LOOP;
180: RETURN(TRUE);
181:
182: <>
183: IF ((g_cache_return_code = fnd_plsql_cache.CACHE_INVALID) AND
184: (g_cache_key = idc_last_record.primary_key)) THEN
185: fnd_message.set_encoded(idc_last_record.encoded_error_message);
186: RETURN(FALSE);
187: END IF;

Line 254: fnd_plsql_cache.generic_1to1_get_value(ccc_cache_controller,

250: g_cache_key := g_cache_key ||
251: To_char(p_validation_date, 'YYYY/MM/DD') || '.';
252: END IF;
253:
254: fnd_plsql_cache.generic_1to1_get_value(ccc_cache_controller,
255: ccc_cache_storage,
256: g_cache_key,
257: g_cache_value,
258: g_cache_return_code);

Line 260: IF (g_cache_return_code = fnd_plsql_cache.CACHE_FOUND) THEN

256: g_cache_key,
257: g_cache_value,
258: g_cache_return_code);
259:
260: IF (g_cache_return_code = fnd_plsql_cache.CACHE_FOUND) THEN
261: IF (g_cache_value.varchar2_1 IS NULL) THEN
262: --
263: -- No error message.
264: --

Line 265: g_cache_return_code := fnd_plsql_cache.CACHE_VALID;

261: IF (g_cache_value.varchar2_1 IS NULL) THEN
262: --
263: -- No error message.
264: --
265: g_cache_return_code := fnd_plsql_cache.CACHE_VALID;
266: ELSE
267: g_cache_return_code := fnd_plsql_cache.CACHE_INVALID;
268: END IF;
269: END IF;

Line 267: g_cache_return_code := fnd_plsql_cache.CACHE_INVALID;

263: -- No error message.
264: --
265: g_cache_return_code := fnd_plsql_cache.CACHE_VALID;
266: ELSE
267: g_cache_return_code := fnd_plsql_cache.CACHE_INVALID;
268: END IF;
269: END IF;
270:
271: IF (g_cache_return_code = fnd_plsql_cache.CACHE_VALID) THEN

Line 271: IF (g_cache_return_code = fnd_plsql_cache.CACHE_VALID) THEN

267: g_cache_return_code := fnd_plsql_cache.CACHE_INVALID;
268: END IF;
269: END IF;
270:
271: IF (g_cache_return_code = fnd_plsql_cache.CACHE_VALID) THEN
272: GOTO return_true;
273: ELSIF (g_cache_return_code = fnd_plsql_cache.CACHE_INVALID) THEN
274: GOTO return_false;
275: END IF;

Line 273: ELSIF (g_cache_return_code = fnd_plsql_cache.CACHE_INVALID) THEN

269: END IF;
270:
271: IF (g_cache_return_code = fnd_plsql_cache.CACHE_VALID) THEN
272: GOTO return_true;
273: ELSIF (g_cache_return_code = fnd_plsql_cache.CACHE_INVALID) THEN
274: GOTO return_false;
275: END IF;
276:
277: --

Line 293: fnd_plsql_cache.generic_cache_new_value

289: p_allow_orphans, NULL, NULL, NULL);
290:
291:
292: IF (l_bool) THEN
293: fnd_plsql_cache.generic_cache_new_value
294: (x_value => g_cache_value,
295: p_varchar2_1 => NULL,
296: p_number_1 => fnd_flex_keyval.combination_id,
297: p_varchar2_2 => fnd_flex_keyval.concatenated_values,

Line 302: fnd_plsql_cache.generic_1to1_put_value(ccc_cache_controller,

298: p_varchar2_3 => fnd_flex_keyval.concatenated_ids,
299: p_varchar2_4 => fnd_flex_keyval.concatenated_descriptions,
300: p_boolean_1 => fnd_flex_keyval.new_combination);
301:
302: fnd_plsql_cache.generic_1to1_put_value(ccc_cache_controller,
303: ccc_cache_storage,
304: g_cache_key,
305: g_cache_value);
306: GOTO return_true;

Line 308: fnd_plsql_cache.generic_cache_new_value

304: g_cache_key,
305: g_cache_value);
306: GOTO return_true;
307: ELSE
308: fnd_plsql_cache.generic_cache_new_value
309: (x_value => g_cache_value,
310: p_varchar2_1 => Nvl(fnd_flex_keyval.encoded_error_message,
311: 'FND-FLEX'),
312: p_number_1 => NULL,

Line 318: fnd_plsql_cache.generic_1to1_put_value(ccc_cache_controller,

314: p_varchar2_3 => NULL,
315: p_varchar2_4 => NULL,
316: p_boolean_1 => NULL);
317:
318: fnd_plsql_cache.generic_1to1_put_value(ccc_cache_controller,
319: ccc_cache_storage,
320: g_cache_key,
321: g_cache_value);
322: GOTO return_false;

Line 326: IF ((g_cache_return_code = fnd_plsql_cache.CACHE_VALID) AND

322: GOTO return_false;
323: END IF;
324:
325: <>
326: IF ((g_cache_return_code = fnd_plsql_cache.CACHE_VALID) AND
327: (g_cache_key = ccc_last_record.primary_key)) THEN
328: RETURN(TRUE);
329: END IF;
330:

Line 341: IF ((g_cache_return_code = fnd_plsql_cache.CACHE_INVALID) AND

337: ccc_last_record.new_combination := g_cache_value.boolean_1;
338: RETURN(TRUE);
339:
340: <>
341: IF ((g_cache_return_code = fnd_plsql_cache.CACHE_INVALID) AND
342: (g_cache_key = ccc_last_record.primary_key)) THEN
343: RETURN(FALSE);
344: END IF;
345:

Line 500: fnd_plsql_cache.generic_1to1_get_value(uqs_cache_controller,

496: -- Get the segment name, using qualifier name.
497: --
498: g_cache_key := (p_application_id || '.' || p_id_flex_code || '.' ||
499: p_id_flex_num || '.' || p_segment_identifier);
500: fnd_plsql_cache.generic_1to1_get_value(uqs_cache_controller,
501: uqs_cache_storage,
502: g_cache_key,
503: g_cache_value,
504: g_cache_return_code);

Line 505: IF (g_cache_return_code = fnd_plsql_cache.CACHE_FOUND) THEN

501: uqs_cache_storage,
502: g_cache_key,
503: g_cache_value,
504: g_cache_return_code);
505: IF (g_cache_return_code = fnd_plsql_cache.CACHE_FOUND) THEN
506: l_segment_name := g_cache_value.varchar2_1;
507: ELSE
508: SELECT s.segment_name
509: INTO l_segment_name

Line 527: fnd_plsql_cache.generic_cache_new_value

523: AND sat.application_id = p_application_id
524: AND sat.id_flex_code = p_id_flex_code
525: AND sat.segment_attribute_type = p_segment_identifier;
526:
527: fnd_plsql_cache.generic_cache_new_value
528: (x_value => g_cache_value,
529: p_varchar2_1 => l_segment_name);
530:
531: fnd_plsql_cache.generic_1to1_put_value(uqs_cache_controller,

Line 531: fnd_plsql_cache.generic_1to1_put_value(uqs_cache_controller,

527: fnd_plsql_cache.generic_cache_new_value
528: (x_value => g_cache_value,
529: p_varchar2_1 => l_segment_name);
530:
531: fnd_plsql_cache.generic_1to1_put_value(uqs_cache_controller,
532: uqs_cache_storage,
533: g_cache_key,
534: g_cache_value);
535: END IF;

Line 561: fnd_plsql_cache.generic_1to1_get_value(gsn_cache_controller,

557: -- Get the user specified segment number
558: --
559: g_cache_key := (p_application_id || '.' || p_id_flex_code || '.' ||
560: p_id_flex_num || '.' || l_segment_name);
561: fnd_plsql_cache.generic_1to1_get_value(gsn_cache_controller,
562: gsn_cache_storage,
563: g_cache_key,
564: g_cache_value,
565: g_cache_return_code);

Line 567: IF (g_cache_return_code = fnd_plsql_cache.CACHE_FOUND) THEN

563: g_cache_key,
564: g_cache_value,
565: g_cache_return_code);
566:
567: IF (g_cache_return_code = fnd_plsql_cache.CACHE_FOUND) THEN
568: l_segment_num := g_cache_value.number_1;
569: l_segment_index := g_cache_value.number_2;
570: ELSE
571: SELECT segment_num

Line 593: fnd_plsql_cache.generic_cache_new_value

589: AND id_flex_num = p_id_flex_num
590: AND enabled_flag = 'Y'
591: AND segment_num <= l_segment_num;
592:
593: fnd_plsql_cache.generic_cache_new_value
594: (x_value => g_cache_value,
595: p_number_1 => l_segment_num,
596: p_number_2 => l_segment_index);
597:

Line 598: fnd_plsql_cache.generic_1to1_put_value(gsn_cache_controller,

594: (x_value => g_cache_value,
595: p_number_1 => l_segment_num,
596: p_number_2 => l_segment_index);
597:
598: fnd_plsql_cache.generic_1to1_put_value(gsn_cache_controller,
599: gsn_cache_storage,
600: g_cache_key,
601: g_cache_value);
602: END IF;

Line 2030: fnd_plsql_cache.generic_1to1_init('WKA.UQS',

2026: complete_failure := wf_engine.eng_completed || ':' || 'FAILURE';
2027: complete_success := wf_engine.eng_completed || ':' || 'SUCCESS';
2028:
2029:
2030: fnd_plsql_cache.generic_1to1_init('WKA.UQS',
2031: uqs_cache_controller,
2032: uqs_cache_storage);
2033:
2034: fnd_plsql_cache.generic_1to1_init('WKA.GSN',

Line 2034: fnd_plsql_cache.generic_1to1_init('WKA.GSN',

2030: fnd_plsql_cache.generic_1to1_init('WKA.UQS',
2031: uqs_cache_controller,
2032: uqs_cache_storage);
2033:
2034: fnd_plsql_cache.generic_1to1_init('WKA.GSN',
2035: gsn_cache_controller,
2036: gsn_cache_storage);
2037:
2038: fnd_plsql_cache.generic_1to1_init('WKA.IDC',

Line 2038: fnd_plsql_cache.generic_1to1_init('WKA.IDC',

2034: fnd_plsql_cache.generic_1to1_init('WKA.GSN',
2035: gsn_cache_controller,
2036: gsn_cache_storage);
2037:
2038: fnd_plsql_cache.generic_1to1_init('WKA.IDC',
2039: idc_cache_controller,
2040: idc_cache_storage);
2041:
2042: fnd_plsql_cache.generic_1to1_init('WKA.CCC',

Line 2042: fnd_plsql_cache.generic_1to1_init('WKA.CCC',

2038: fnd_plsql_cache.generic_1to1_init('WKA.IDC',
2039: idc_cache_controller,
2040: idc_cache_storage);
2041:
2042: fnd_plsql_cache.generic_1to1_init('WKA.CCC',
2043: ccc_cache_controller,
2044: ccc_cache_storage);
2045:
2046: idc_last_record.segment_values := fnd_plsql_cache.cache_varchar2_varray_type();

Line 2046: idc_last_record.segment_values := fnd_plsql_cache.cache_varchar2_varray_type();

2042: fnd_plsql_cache.generic_1to1_init('WKA.CCC',
2043: ccc_cache_controller,
2044: ccc_cache_storage);
2045:
2046: idc_last_record.segment_values := fnd_plsql_cache.cache_varchar2_varray_type();
2047: idc_last_record.segment_values.EXTEND(fnd_plsql_cache.CACHE_MAX_NUMOF_KEYS);
2048: END fnd_flex_workflow_apis;

Line 2047: idc_last_record.segment_values.EXTEND(fnd_plsql_cache.CACHE_MAX_NUMOF_KEYS);

2043: ccc_cache_controller,
2044: ccc_cache_storage);
2045:
2046: idc_last_record.segment_values := fnd_plsql_cache.cache_varchar2_varray_type();
2047: idc_last_record.segment_values.EXTEND(fnd_plsql_cache.CACHE_MAX_NUMOF_KEYS);
2048: END fnd_flex_workflow_apis;