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

Line 100: g_cache_value fnd_plsql_cache.generic_cache_value_type;

96: -- CACHING
97: -- ==================================================
98: g_cache_return_code VARCHAR2(30);
99: g_cache_key VARCHAR2(2000);
100: g_cache_value fnd_plsql_cache.generic_cache_value_type;
101:
102: -- ======================================================================
103: -- EXT : get_delimiter cache
104: -- ======================================================================

Line 105: gdl_cache_controller fnd_plsql_cache.cache_1to1_controller_type;

101:
102: -- ======================================================================
103: -- EXT : get_delimiter cache
104: -- ======================================================================
105: gdl_cache_controller fnd_plsql_cache.cache_1to1_controller_type;
106: gdl_cache_storage fnd_plsql_cache.generic_cache_values_type;
107:
108: -- ======================================================================
109: -- EXT ccid cache : IDC

Line 106: gdl_cache_storage fnd_plsql_cache.generic_cache_values_type;

102: -- ======================================================================
103: -- EXT : get_delimiter cache
104: -- ======================================================================
105: gdl_cache_controller fnd_plsql_cache.cache_1to1_controller_type;
106: gdl_cache_storage fnd_plsql_cache.generic_cache_values_type;
107:
108: -- ======================================================================
109: -- EXT ccid cache : IDC
110: --

Line 116: idc_cache_controller fnd_plsql_cache.cache_1to1_controller_type;

112: -- || NEWLINE || || NEWLINE ||
113: -- || NEWLINE ||
114: --
115: -- ======================================================================
116: idc_cache_controller fnd_plsql_cache.cache_1to1_controller_type;
117: idc_cache_storage fnd_plsql_cache.generic_cache_values_type;
118:
119: FUNCTION check_idc(p_appl_short_name IN VARCHAR2,
120: p_id_flex_code IN VARCHAR2,

Line 117: idc_cache_storage fnd_plsql_cache.generic_cache_values_type;

113: -- || NEWLINE ||
114: --
115: -- ======================================================================
116: idc_cache_controller fnd_plsql_cache.cache_1to1_controller_type;
117: idc_cache_storage fnd_plsql_cache.generic_cache_values_type;
118:
119: FUNCTION check_idc(p_appl_short_name IN VARCHAR2,
120: p_id_flex_code IN VARCHAR2,
121: p_id_flex_num IN NUMBER,

Line 133: fnd_plsql_cache.generic_1to1_get_value(idc_cache_controller,

129: p_id_flex_code || '.' ||
130: p_id_flex_num || '.' ||
131: p_ccid);
132:
133: fnd_plsql_cache.generic_1to1_get_value(idc_cache_controller,
134: idc_cache_storage,
135: g_cache_key,
136: g_cache_value,
137: g_cache_return_code);

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

135: g_cache_key,
136: g_cache_value,
137: g_cache_return_code);
138:
139: IF (g_cache_return_code = fnd_plsql_cache.CACHE_FOUND) THEN
140: IF (g_cache_value.varchar2_1 IS NULL) THEN
141: --
142: -- No error message.
143: --

Line 146: RETURN(fnd_plsql_cache.CACHE_VALID);

142: -- No error message.
143: --
144: x_delimiter := g_cache_value.varchar2_2;
145: x_newline_comb := g_cache_value.varchar2_3;
146: RETURN(fnd_plsql_cache.CACHE_VALID);
147: ELSE
148: --
149: -- Error message.
150: --

Line 152: RETURN(fnd_plsql_cache.CACHE_INVALID);

148: --
149: -- Error message.
150: --
151: fnd_message.set_encoded(g_cache_value.varchar2_1);
152: RETURN(fnd_plsql_cache.CACHE_INVALID);
153: END IF;
154: END IF;
155: RETURN(g_cache_return_code);
156: EXCEPTION

Line 158: RETURN(fnd_plsql_cache.CACHE_NOTFOUND);

154: END IF;
155: RETURN(g_cache_return_code);
156: EXCEPTION
157: WHEN OTHERS THEN
158: RETURN(fnd_plsql_cache.CACHE_NOTFOUND);
159: END check_idc;
160:
161: PROCEDURE update_idc(p_appl_short_name IN VARCHAR2,
162: p_id_flex_code IN VARCHAR2,

Line 181: fnd_plsql_cache.generic_cache_new_value

177: l_enc_err_msg := fnd_message.get_encoded;
178: fnd_message.set_encoded(l_enc_err_msg);
179: END IF;
180:
181: fnd_plsql_cache.generic_cache_new_value
182: (x_value => g_cache_value,
183: p_varchar2_1 => l_enc_err_msg,
184: p_varchar2_2 => p_delimiter,
185: p_varchar2_3 => p_newline_comb);

Line 187: fnd_plsql_cache.generic_1to1_put_value(idc_cache_controller,

183: p_varchar2_1 => l_enc_err_msg,
184: p_varchar2_2 => p_delimiter,
185: p_varchar2_3 => p_newline_comb);
186:
187: fnd_plsql_cache.generic_1to1_put_value(idc_cache_controller,
188: idc_cache_storage,
189: g_cache_key,
190: g_cache_value);
191:

Line 200: fnd_plsql_cache.generic_1to1_clear(idc_cache_controller,

196:
197: PROCEDURE clear_ccid_cache
198: IS
199: BEGIN
200: fnd_plsql_cache.generic_1to1_clear(idc_cache_controller,
201: idc_cache_storage);
202: END clear_ccid_cache;
203:
204: -- -----------------------------------------------------------------------

Line 341: fnd_plsql_cache.generic_1to1_get_value(gdl_cache_controller,

337: init_message;
338:
339: g_cache_key := (application_short_name || '.' || key_flex_code || '.' ||
340: structure_number);
341: fnd_plsql_cache.generic_1to1_get_value(gdl_cache_controller,
342: gdl_cache_storage,
343: g_cache_key,
344: g_cache_value,
345: g_cache_return_code);

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

342: gdl_cache_storage,
343: g_cache_key,
344: g_cache_value,
345: g_cache_return_code);
346: IF (g_cache_return_code = fnd_plsql_cache.CACHE_FOUND) THEN
347: delim := g_cache_value.varchar2_1;
348: ELSE
349: SELECT s.concatenated_segment_delimiter
350: INTO delim

Line 358: fnd_plsql_cache.generic_1to1_put_value(gdl_cache_controller,

354: AND s.id_flex_num = structure_number
355: AND a.application_short_name = get_delimiter.application_short_name;
356:
357: g_cache_value.varchar2_1 := delim;
358: fnd_plsql_cache.generic_1to1_put_value(gdl_cache_controller,
359: gdl_cache_storage,
360: g_cache_key,
361: g_cache_value);
362: END IF;

Line 646: IF (l_idc_code = fnd_plsql_cache.CACHE_VALID) THEN

642: structure_number,
643: combination_id,
644: delim,
645: l_newline_comb);
646: IF (l_idc_code = fnd_plsql_cache.CACHE_VALID) THEN
647: n_segments := breakup_segments(l_newline_comb,
648: chr_newline,
649: segments);
650: GOTO label_success;

Line 651: ELSIF (l_idc_code = fnd_plsql_cache.CACHE_INVALID) THEN

647: n_segments := breakup_segments(l_newline_comb,
648: chr_newline,
649: segments);
650: GOTO label_success;
651: ELSIF (l_idc_code = fnd_plsql_cache.CACHE_INVALID) THEN
652: --
653: -- message is set by check_idc;
654: --
655: GOTO label_failure;

Line 658: -- l_idc_code is either fnd_plsql_cache.CACHE_NOTFOUND.

654: --
655: GOTO label_failure;
656: END IF;
657: --
658: -- l_idc_code is either fnd_plsql_cache.CACHE_NOTFOUND.
659: -- continue on validation.
660: --
661:
662: -- Check whether this key flexfield allows id value sets or not.

Line 827: IF (l_idc_code IN (fnd_plsql_cache.CACHE_NOTFOUND)) THEN

823: GOTO label_failure;
824: end if;
825:
826: <>
827: IF (l_idc_code IN (fnd_plsql_cache.CACHE_NOTFOUND)) THEN
828: update_idc(application_short_name,
829: key_flex_code,
830: structure_number,
831: combination_id,

Line 840: IF (l_idc_code IN (fnd_plsql_cache.CACHE_NOTFOUND)) THEN

836: ext_globals_valid := TRUE;
837: RETURN(TRUE);
838:
839: <>
840: IF (l_idc_code IN (fnd_plsql_cache.CACHE_NOTFOUND)) THEN
841: update_idc(application_short_name,
842: key_flex_code,
843: structure_number,
844: combination_id,

Line 1330: fnd_plsql_cache.generic_1to1_init('EXT.IDC',

1326:
1327: BEGIN
1328: chr_newline := fnd_global.newline;
1329:
1330: fnd_plsql_cache.generic_1to1_init('EXT.IDC',
1331: idc_cache_controller,
1332: idc_cache_storage);
1333:
1334: fnd_plsql_cache.generic_1to1_init('EXT.GDL',

Line 1334: fnd_plsql_cache.generic_1to1_init('EXT.GDL',

1330: fnd_plsql_cache.generic_1to1_init('EXT.IDC',
1331: idc_cache_controller,
1332: idc_cache_storage);
1333:
1334: fnd_plsql_cache.generic_1to1_init('EXT.GDL',
1335: gdl_cache_controller,
1336: gdl_cache_storage);
1337:
1338: END fnd_flex_ext;