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.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 277: l_flexfield fnd_flex_key_api.flexfield_type;

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

Line 278: l_structure fnd_flex_key_api.structure_type;

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

Line 279: l_segment_list fnd_flex_key_api.segment_list;

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

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

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

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

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

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

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

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

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

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

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

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

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