DBA Data[Home] [Help]

APPS.AHL_PRD_MTLTXN_PVT dependencies on FND_FLEX_KEY_API

Line 7541: l_flex_seglist fnd_flex_key_api.segment_list;

7537:
7538: IS
7539:
7540: l_flex_nseg NUMBER;
7541: l_flex_seglist fnd_flex_key_api.segment_list;
7542: l_fftype fnd_flex_key_api.flexfield_type;
7543: l_ffstru fnd_flex_key_api.structure_type;
7544: l_segment_type fnd_flex_key_api.segment_type;
7545: l_delim VARCHAR2(1);

Line 7542: l_fftype fnd_flex_key_api.flexfield_type;

7538: IS
7539:
7540: l_flex_nseg NUMBER;
7541: l_flex_seglist fnd_flex_key_api.segment_list;
7542: l_fftype fnd_flex_key_api.flexfield_type;
7543: l_ffstru fnd_flex_key_api.structure_type;
7544: l_segment_type fnd_flex_key_api.segment_type;
7545: l_delim VARCHAR2(1);
7546:

Line 7543: l_ffstru fnd_flex_key_api.structure_type;

7539:
7540: l_flex_nseg NUMBER;
7541: l_flex_seglist fnd_flex_key_api.segment_list;
7542: l_fftype fnd_flex_key_api.flexfield_type;
7543: l_ffstru fnd_flex_key_api.structure_type;
7544: l_segment_type fnd_flex_key_api.segment_type;
7545: l_delim VARCHAR2(1);
7546:
7547: l_loc_nseg number;

Line 7544: l_segment_type fnd_flex_key_api.segment_type;

7540: l_flex_nseg NUMBER;
7541: l_flex_seglist fnd_flex_key_api.segment_list;
7542: l_fftype fnd_flex_key_api.flexfield_type;
7543: l_ffstru fnd_flex_key_api.structure_type;
7544: l_segment_type fnd_flex_key_api.segment_type;
7545: l_delim VARCHAR2(1);
7546:
7547: l_loc_nseg number;
7548: l_loc_seglist fnd_flex_ext.SegmentArray;

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

7564: fnd_profile.put('MFG_ORGANIZATION_ID', p_organization_id);
7565:
7566: l_mti_seglist := p_x_mti_seglist;
7567:
7568: fnd_flex_key_api.set_session_mode('seed_data');
7569:
7570: -- find flex field type
7571: l_fftype := fnd_flex_key_api.find_flexfield('INV', 'MTLL');
7572:

Line 7571: l_fftype := fnd_flex_key_api.find_flexfield('INV', 'MTLL');

7567:
7568: fnd_flex_key_api.set_session_mode('seed_data');
7569:
7570: -- find flex field type
7571: l_fftype := fnd_flex_key_api.find_flexfield('INV', 'MTLL');
7572:
7573: -- find flex structure type
7574: l_ffstru := fnd_flex_key_api.find_structure(l_fftype, 101);
7575:

Line 7574: l_ffstru := fnd_flex_key_api.find_structure(l_fftype, 101);

7570: -- find flex field type
7571: l_fftype := fnd_flex_key_api.find_flexfield('INV', 'MTLL');
7572:
7573: -- find flex structure type
7574: l_ffstru := fnd_flex_key_api.find_structure(l_fftype, 101);
7575:
7576: -- find segment list for the key flex field
7577: fnd_flex_key_api.get_segments(l_fftype, l_ffstru, TRUE, l_flex_nseg, l_flex_seglist);
7578:

Line 7577: fnd_flex_key_api.get_segments(l_fftype, l_ffstru, TRUE, l_flex_nseg, l_flex_seglist);

7573: -- find flex structure type
7574: l_ffstru := fnd_flex_key_api.find_structure(l_fftype, 101);
7575:
7576: -- find segment list for the key flex field
7577: fnd_flex_key_api.get_segments(l_fftype, l_ffstru, TRUE, l_flex_nseg, l_flex_seglist);
7578:
7579: -- find segment delimiter
7580: l_delim := l_ffstru.segment_separator;
7581:

Line 7637: l_segment_type := fnd_flex_key_api.find_segment(l_fftype, l_ffstru, l_flex_seglist(l_loop));

7633: -- populate the corresponding columns from segments array.
7634: --
7635: FOR l_loop IN 1..l_flex_nseg LOOP
7636:
7637: l_segment_type := fnd_flex_key_api.find_segment(l_fftype, l_ffstru, l_flex_seglist(l_loop));
7638: --dbms_output.put_line('l_segment_type is : ' || l_segment_type.column_name);
7639:
7640: l_mti_seglist(To_number(Substr(l_segment_type.column_name, 8))) := l_loc_seglist(l_loop);
7641: