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.POS_PRODUCT_SERVICE_UTL_PKG dependencies on FND_FLEX_KEY_API

Line 8: TABLE OF fnd_flex_key_api.segment_type INDEX BY BINARY_INTEGER;

4: -- type definition
5: TYPE cursor_ref_type IS REF CURSOR;
6:
7: TYPE structure_segment_table IS
8: TABLE OF fnd_flex_key_api.segment_type INDEX BY BINARY_INTEGER;
9:
10: TYPE varchar10_table IS TABLE OF VARCHAR2(10) INDEX BY BINARY_INTEGER;
11: TYPE varchar1000_table IS TABLE OF VARCHAR2(1000) INDEX BY BINARY_INTEGER;
12: TYPE number_table IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;

Line 278: l_flexfield fnd_flex_key_api.flexfield_type;

274: RETURN;
275: END validate_segment_definition;
276:
277: PROCEDURE query_po_category_flexfield IS
278: l_flexfield fnd_flex_key_api.flexfield_type;
279: l_structure fnd_flex_key_api.structure_type;
280: l_segment_list fnd_flex_key_api.segment_list;
281: BEGIN
282: -- this call is a must before calling other procedures in fnd_flex_key_api package

Line 279: l_structure fnd_flex_key_api.structure_type;

275: END validate_segment_definition;
276:
277: PROCEDURE query_po_category_flexfield IS
278: l_flexfield fnd_flex_key_api.flexfield_type;
279: l_structure fnd_flex_key_api.structure_type;
280: l_segment_list fnd_flex_key_api.segment_list;
281: BEGIN
282: -- this call is a must before calling other procedures in fnd_flex_key_api package
283: fnd_flex_key_api.set_session_mode('seed_data');

Line 280: l_segment_list fnd_flex_key_api.segment_list;

276:
277: PROCEDURE query_po_category_flexfield IS
278: l_flexfield fnd_flex_key_api.flexfield_type;
279: l_structure fnd_flex_key_api.structure_type;
280: l_segment_list fnd_flex_key_api.segment_list;
281: BEGIN
282: -- this call is a must before calling other procedures in fnd_flex_key_api package
283: fnd_flex_key_api.set_session_mode('seed_data');
284:

Line 282: -- this call is a must before calling other procedures in fnd_flex_key_api package

278: l_flexfield fnd_flex_key_api.flexfield_type;
279: l_structure fnd_flex_key_api.structure_type;
280: l_segment_list fnd_flex_key_api.segment_list;
281: BEGIN
282: -- this call is a must before calling other procedures in fnd_flex_key_api package
283: fnd_flex_key_api.set_session_mode('seed_data');
284:
285: -- find flexfield
286: l_flexfield := fnd_flex_key_api.find_flexfield('INV','MCAT');

Line 283: fnd_flex_key_api.set_session_mode('seed_data');

279: l_structure fnd_flex_key_api.structure_type;
280: l_segment_list fnd_flex_key_api.segment_list;
281: BEGIN
282: -- this call is a must before calling other procedures in fnd_flex_key_api package
283: fnd_flex_key_api.set_session_mode('seed_data');
284:
285: -- find flexfield
286: l_flexfield := fnd_flex_key_api.find_flexfield('INV','MCAT');
287:

Line 286: l_flexfield := fnd_flex_key_api.find_flexfield('INV','MCAT');

282: -- this call is a must before calling other procedures in fnd_flex_key_api package
283: fnd_flex_key_api.set_session_mode('seed_data');
284:
285: -- find flexfield
286: l_flexfield := fnd_flex_key_api.find_flexfield('INV','MCAT');
287:
288: -- find structure
289: l_structure := fnd_flex_key_api.find_structure(l_flexfield, g_structure_id);
290:

Line 289: l_structure := fnd_flex_key_api.find_structure(l_flexfield, g_structure_id);

285: -- find flexfield
286: l_flexfield := fnd_flex_key_api.find_flexfield('INV','MCAT');
287:
288: -- find structure
289: l_structure := fnd_flex_key_api.find_structure(l_flexfield, g_structure_id);
290:
291: -- store the segment_separator in package variable
292: g_delimiter := l_structure.segment_separator;
293:

Line 295: fnd_flex_key_api.get_segments(flexfield => l_flexfield,

291: -- store the segment_separator in package variable
292: g_delimiter := l_structure.segment_separator;
293:
294: -- get segment count and name list
295: fnd_flex_key_api.get_segments(flexfield => l_flexfield,
296: structure => l_structure,
297: enabled_only => TRUE,
298: nsegments => g_structure_segment_count,
299: segments => l_segment_list);

Line 304: fnd_flex_key_api.find_segment(l_flexfield, l_structure, l_segment_list(l_index));

300:
301: -- get each segment info
302: FOR l_index IN 1..g_structure_segment_count LOOP
303: g_structure_segments(l_index) :=
304: fnd_flex_key_api.find_segment(l_flexfield, l_structure, l_segment_list(l_index));
305: END LOOP;
306: END query_po_category_flexfield;
307:
308: PROCEDURE query_def_po_category_set_id IS