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

Line 59: l_seglist fnd_flex_key_api.segment_list;

55: )
56: IS
57: --l_val BOOLEAN;
58: l_nseg NUMBER;
59: l_seglist fnd_flex_key_api.segment_list;
60: l_segs1 fnd_flex_ext.segmentarray;
61: l_segs2 fnd_flex_ext.segmentarray;
62: l_fftype fnd_flex_key_api.flexfield_type;
63: l_ffstru fnd_flex_key_api.structure_type;

Line 62: l_fftype fnd_flex_key_api.flexfield_type;

58: l_nseg NUMBER;
59: l_seglist fnd_flex_key_api.segment_list;
60: l_segs1 fnd_flex_ext.segmentarray;
61: l_segs2 fnd_flex_ext.segmentarray;
62: l_fftype fnd_flex_key_api.flexfield_type;
63: l_ffstru fnd_flex_key_api.structure_type;
64: l_segment_type fnd_flex_key_api.segment_type;
65: l_item_number VARCHAR2(32000);
66: l_delim VARCHAR2(1);

Line 63: l_ffstru fnd_flex_key_api.structure_type;

59: l_seglist fnd_flex_key_api.segment_list;
60: l_segs1 fnd_flex_ext.segmentarray;
61: l_segs2 fnd_flex_ext.segmentarray;
62: l_fftype fnd_flex_key_api.flexfield_type;
63: l_ffstru fnd_flex_key_api.structure_type;
64: l_segment_type fnd_flex_key_api.segment_type;
65: l_item_number VARCHAR2(32000);
66: l_delim VARCHAR2(1);
67: l_index NUMBER;

Line 64: l_segment_type fnd_flex_key_api.segment_type;

60: l_segs1 fnd_flex_ext.segmentarray;
61: l_segs2 fnd_flex_ext.segmentarray;
62: l_fftype fnd_flex_key_api.flexfield_type;
63: l_ffstru fnd_flex_key_api.structure_type;
64: l_segment_type fnd_flex_key_api.segment_type;
65: l_item_number VARCHAR2(32000);
66: l_delim VARCHAR2(1);
67: l_index NUMBER;
68: BEGIN

Line 70: fnd_flex_key_api.set_session_mode('customer_data');

66: l_delim VARCHAR2(1);
67: l_index NUMBER;
68: BEGIN
69:
70: fnd_flex_key_api.set_session_mode('customer_data');
71: -- find flex field type
72: l_fftype := fnd_flex_key_api.find_flexfield('INV'
73: ,'MSTK');
74: -- find flex structure type

Line 72: l_fftype := fnd_flex_key_api.find_flexfield('INV'

68: BEGIN
69:
70: fnd_flex_key_api.set_session_mode('customer_data');
71: -- find flex field type
72: l_fftype := fnd_flex_key_api.find_flexfield('INV'
73: ,'MSTK');
74: -- find flex structure type
75: l_ffstru := fnd_flex_key_api.find_structure(l_fftype
76: ,101);

Line 75: l_ffstru := fnd_flex_key_api.find_structure(l_fftype

71: -- find flex field type
72: l_fftype := fnd_flex_key_api.find_flexfield('INV'
73: ,'MSTK');
74: -- find flex structure type
75: l_ffstru := fnd_flex_key_api.find_structure(l_fftype
76: ,101);
77: -- find segment list for the key flex field
78: fnd_flex_key_api.get_segments(l_fftype
79: ,l_ffstru

Line 78: fnd_flex_key_api.get_segments(l_fftype

74: -- find flex structure type
75: l_ffstru := fnd_flex_key_api.find_structure(l_fftype
76: ,101);
77: -- find segment list for the key flex field
78: fnd_flex_key_api.get_segments(l_fftype
79: ,l_ffstru
80: ,TRUE
81: ,l_nseg
82: ,l_seglist);

Line 86: l_segment_type := fnd_flex_key_api.find_segment(l_fftype

82: ,l_seglist);
83: -- get the corresponding clolumn for all segments
84: FOR l_loop IN 1 .. l_nseg
85: LOOP
86: l_segment_type := fnd_flex_key_api.find_segment(l_fftype
87: ,l_ffstru
88: ,l_seglist(l_loop));
89: l_segs2(l_loop) := l_segment_type.column_name;
90: END LOOP;

Line 182: l_seglist fnd_flex_key_api.segment_list;

178: RETURN VARCHAR2
179: IS
180: --l_val BOOLEAN;
181: l_nseg NUMBER;
182: l_seglist fnd_flex_key_api.segment_list;
183: l_segs1 fnd_flex_ext.segmentarray;
184: l_segs2 fnd_flex_ext.segmentarray;
185: l_fftype fnd_flex_key_api.flexfield_type;
186: l_ffstru fnd_flex_key_api.structure_type;

Line 185: l_fftype fnd_flex_key_api.flexfield_type;

181: l_nseg NUMBER;
182: l_seglist fnd_flex_key_api.segment_list;
183: l_segs1 fnd_flex_ext.segmentarray;
184: l_segs2 fnd_flex_ext.segmentarray;
185: l_fftype fnd_flex_key_api.flexfield_type;
186: l_ffstru fnd_flex_key_api.structure_type;
187: l_segment_type fnd_flex_key_api.segment_type;
188: l_item_number VARCHAR2(32000);
189: l_delim VARCHAR2(1);

Line 186: l_ffstru fnd_flex_key_api.structure_type;

182: l_seglist fnd_flex_key_api.segment_list;
183: l_segs1 fnd_flex_ext.segmentarray;
184: l_segs2 fnd_flex_ext.segmentarray;
185: l_fftype fnd_flex_key_api.flexfield_type;
186: l_ffstru fnd_flex_key_api.structure_type;
187: l_segment_type fnd_flex_key_api.segment_type;
188: l_item_number VARCHAR2(32000);
189: l_delim VARCHAR2(1);
190: l_index NUMBER;

Line 187: l_segment_type fnd_flex_key_api.segment_type;

183: l_segs1 fnd_flex_ext.segmentarray;
184: l_segs2 fnd_flex_ext.segmentarray;
185: l_fftype fnd_flex_key_api.flexfield_type;
186: l_ffstru fnd_flex_key_api.structure_type;
187: l_segment_type fnd_flex_key_api.segment_type;
188: l_item_number VARCHAR2(32000);
189: l_delim VARCHAR2(1);
190: l_index NUMBER;
191: BEGIN

Line 192: fnd_flex_key_api.set_session_mode('customer_data');

188: l_item_number VARCHAR2(32000);
189: l_delim VARCHAR2(1);
190: l_index NUMBER;
191: BEGIN
192: fnd_flex_key_api.set_session_mode('customer_data');
193: -- find flex field type
194: l_fftype := fnd_flex_key_api.find_flexfield('INV'
195: ,'MSTK');
196: -- find flex structure type

Line 194: l_fftype := fnd_flex_key_api.find_flexfield('INV'

190: l_index NUMBER;
191: BEGIN
192: fnd_flex_key_api.set_session_mode('customer_data');
193: -- find flex field type
194: l_fftype := fnd_flex_key_api.find_flexfield('INV'
195: ,'MSTK');
196: -- find flex structure type
197: l_ffstru := fnd_flex_key_api.find_structure(l_fftype
198: ,101);

Line 197: l_ffstru := fnd_flex_key_api.find_structure(l_fftype

193: -- find flex field type
194: l_fftype := fnd_flex_key_api.find_flexfield('INV'
195: ,'MSTK');
196: -- find flex structure type
197: l_ffstru := fnd_flex_key_api.find_structure(l_fftype
198: ,101);
199: -- find segment list for the key flex field
200: fnd_flex_key_api.get_segments(l_fftype
201: ,l_ffstru

Line 200: fnd_flex_key_api.get_segments(l_fftype

196: -- find flex structure type
197: l_ffstru := fnd_flex_key_api.find_structure(l_fftype
198: ,101);
199: -- find segment list for the key flex field
200: fnd_flex_key_api.get_segments(l_fftype
201: ,l_ffstru
202: ,TRUE
203: ,l_nseg
204: ,l_seglist);

Line 208: l_segment_type := fnd_flex_key_api.find_segment(l_fftype

204: ,l_seglist);
205: -- get the corresponding clolumn for all segments
206: FOR l_loop IN 1 .. l_nseg
207: LOOP
208: l_segment_type := fnd_flex_key_api.find_segment(l_fftype
209: ,l_ffstru
210: ,l_seglist(l_loop));
211: l_segs2(l_loop) := l_segment_type.column_name;
212: END LOOP;