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

Line 4244: l_key_flex_field fnd_flex_key_api.flexfield_type;

4240: RETURN VARCHAR2
4241: IS
4242:
4243: l_proc_name VARCHAR2(30) := 'concatenate_segments';
4244: l_key_flex_field fnd_flex_key_api.flexfield_type;
4245: l_structure_type fnd_flex_key_api.structure_type;
4246: l_segment_type fnd_flex_key_api.segment_type;
4247: l_segment_list fnd_flex_key_api.segment_list;
4248: l_segment_array fnd_flex_ext.SegmentArray;

Line 4245: l_structure_type fnd_flex_key_api.structure_type;

4241: IS
4242:
4243: l_proc_name VARCHAR2(30) := 'concatenate_segments';
4244: l_key_flex_field fnd_flex_key_api.flexfield_type;
4245: l_structure_type fnd_flex_key_api.structure_type;
4246: l_segment_type fnd_flex_key_api.segment_type;
4247: l_segment_list fnd_flex_key_api.segment_list;
4248: l_segment_array fnd_flex_ext.SegmentArray;
4249: l_cur_icc_segment_array fnd_flex_ext.SegmentArray;

Line 4246: l_segment_type fnd_flex_key_api.segment_type;

4242:
4243: l_proc_name VARCHAR2(30) := 'concatenate_segments';
4244: l_key_flex_field fnd_flex_key_api.flexfield_type;
4245: l_structure_type fnd_flex_key_api.structure_type;
4246: l_segment_type fnd_flex_key_api.segment_type;
4247: l_segment_list fnd_flex_key_api.segment_list;
4248: l_segment_array fnd_flex_ext.SegmentArray;
4249: l_cur_icc_segment_array fnd_flex_ext.SegmentArray;
4250: l_num_segments NUMBER;

Line 4247: l_segment_list fnd_flex_key_api.segment_list;

4243: l_proc_name VARCHAR2(30) := 'concatenate_segments';
4244: l_key_flex_field fnd_flex_key_api.flexfield_type;
4245: l_structure_type fnd_flex_key_api.structure_type;
4246: l_segment_type fnd_flex_key_api.segment_type;
4247: l_segment_list fnd_flex_key_api.segment_list;
4248: l_segment_array fnd_flex_ext.SegmentArray;
4249: l_cur_icc_segment_array fnd_flex_ext.SegmentArray;
4250: l_num_segments NUMBER;
4251: l_flag BOOLEAN;

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

4255: BEGIN
4256:
4257: write_debug(l_proc_name, 'Start');
4258:
4259: fnd_flex_key_api.set_session_mode('seed_data');
4260:
4261: l_key_flex_field :=
4262: fnd_flex_key_api.find_flexfield(p_appl_short_name,
4263: p_key_flex_code);

Line 4262: fnd_flex_key_api.find_flexfield(p_appl_short_name,

4258:
4259: fnd_flex_key_api.set_session_mode('seed_data');
4260:
4261: l_key_flex_field :=
4262: fnd_flex_key_api.find_flexfield(p_appl_short_name,
4263: p_key_flex_code);
4264:
4265: l_structure_type :=
4266: fnd_flex_key_api.find_structure(l_key_flex_field,

Line 4266: fnd_flex_key_api.find_structure(l_key_flex_field,

4262: fnd_flex_key_api.find_flexfield(p_appl_short_name,
4263: p_key_flex_code);
4264:
4265: l_structure_type :=
4266: fnd_flex_key_api.find_structure(l_key_flex_field,
4267: p_structure_number);
4268:
4269: fnd_flex_key_api.get_segments(l_key_flex_field, l_structure_type,
4270: TRUE, l_num_segments, l_segment_list);

Line 4269: fnd_flex_key_api.get_segments(l_key_flex_field, l_structure_type,

4265: l_structure_type :=
4266: fnd_flex_key_api.find_structure(l_key_flex_field,
4267: p_structure_number);
4268:
4269: fnd_flex_key_api.get_segments(l_key_flex_field, l_structure_type,
4270: TRUE, l_num_segments, l_segment_list);
4271:
4272:
4273: l_cur_icc_segment_array(1) := p_icc_rec.segment1;

Line 4308: fnd_flex_key_api.find_segment(l_key_flex_field,

4304: --
4305: for i in 1..l_num_segments
4306: loop
4307: l_segment_type :=
4308: fnd_flex_key_api.find_segment(l_key_flex_field,
4309: l_structure_type,
4310: l_segment_list(i));
4311: j := to_number(substr(l_segment_type.column_name,8));
4312: l_segment_array(i) := l_cur_icc_segment_array(j);

Line 9140: l_key_flex_field fnd_flex_key_api.flexfield_type;

9136: FOR UPDATE OF ITEM_CATALOG_NAME;
9137:
9138:
9139: l_proc_name VARCHAR2(40) := 'Update_ICC_Name_Frm_Segs';
9140: l_key_flex_field fnd_flex_key_api.flexfield_type;
9141: l_structure_type fnd_flex_key_api.structure_type;
9142: l_segment_type fnd_flex_key_api.segment_type;
9143: l_segment_list fnd_flex_key_api.segment_list;
9144: l_segment_array fnd_flex_ext.SegmentArray;

Line 9141: l_structure_type fnd_flex_key_api.structure_type;

9137:
9138:
9139: l_proc_name VARCHAR2(40) := 'Update_ICC_Name_Frm_Segs';
9140: l_key_flex_field fnd_flex_key_api.flexfield_type;
9141: l_structure_type fnd_flex_key_api.structure_type;
9142: l_segment_type fnd_flex_key_api.segment_type;
9143: l_segment_list fnd_flex_key_api.segment_list;
9144: l_segment_array fnd_flex_ext.SegmentArray;
9145: l_num_segments NUMBER;

Line 9142: l_segment_type fnd_flex_key_api.segment_type;

9138:
9139: l_proc_name VARCHAR2(40) := 'Update_ICC_Name_Frm_Segs';
9140: l_key_flex_field fnd_flex_key_api.flexfield_type;
9141: l_structure_type fnd_flex_key_api.structure_type;
9142: l_segment_type fnd_flex_key_api.segment_type;
9143: l_segment_list fnd_flex_key_api.segment_list;
9144: l_segment_array fnd_flex_ext.SegmentArray;
9145: l_num_segments NUMBER;
9146: l_flag BOOLEAN;

Line 9143: l_segment_list fnd_flex_key_api.segment_list;

9139: l_proc_name VARCHAR2(40) := 'Update_ICC_Name_Frm_Segs';
9140: l_key_flex_field fnd_flex_key_api.flexfield_type;
9141: l_structure_type fnd_flex_key_api.structure_type;
9142: l_segment_type fnd_flex_key_api.segment_type;
9143: l_segment_list fnd_flex_key_api.segment_list;
9144: l_segment_array fnd_flex_ext.SegmentArray;
9145: l_num_segments NUMBER;
9146: l_flag BOOLEAN;
9147: l_concat VARCHAR2(2000);

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

9148:
9149: BEGIN
9150: write_debug(l_proc_name, 'Start ');
9151:
9152: fnd_flex_key_api.set_session_mode('seed_data');
9153:
9154: l_key_flex_field :=
9155: fnd_flex_key_api.find_flexfield( G_ITEM_CAT_KFF_APPL,
9156: G_ICC_KFF_NAME

Line 9155: fnd_flex_key_api.find_flexfield( G_ITEM_CAT_KFF_APPL,

9151:
9152: fnd_flex_key_api.set_session_mode('seed_data');
9153:
9154: l_key_flex_field :=
9155: fnd_flex_key_api.find_flexfield( G_ITEM_CAT_KFF_APPL,
9156: G_ICC_KFF_NAME
9157: );
9158:
9159: l_structure_type :=

Line 9160: fnd_flex_key_api.find_structure( l_key_flex_field,

9156: G_ICC_KFF_NAME
9157: );
9158:
9159: l_structure_type :=
9160: fnd_flex_key_api.find_structure( l_key_flex_field,
9161: G_STRUCTURE_NUMBER
9162: );
9163:
9164: fnd_flex_key_api.get_segments(l_key_flex_field

Line 9164: fnd_flex_key_api.get_segments(l_key_flex_field

9160: fnd_flex_key_api.find_structure( l_key_flex_field,
9161: G_STRUCTURE_NUMBER
9162: );
9163:
9164: fnd_flex_key_api.get_segments(l_key_flex_field
9165: , l_structure_type
9166: , TRUE -- GET enabled_segments only
9167: , l_num_segments
9168: , l_segment_list