APPS.INV_RESERVATION_WORKFLOW dependencies on FND_FLEX_EXT

Line 19: l_segs1 fnd_flex_ext.segmentarray;

15: ) IS
16: l_val BOOLEAN;
17: l_nseg NUMBER;
18: l_seglist fnd_flex_key_api.segment_list;
19: l_segs1 fnd_flex_ext.segmentarray;
20: l_segs2 fnd_flex_ext.segmentarray;
21: l_fftype fnd_flex_key_api.flexfield_type;
22: l_ffstru fnd_flex_key_api.structure_type;
23: l_segment_type fnd_flex_key_api.segment_type;

Line 20: l_segs2 fnd_flex_ext.segmentarray;

16: l_val BOOLEAN;
17: l_nseg NUMBER;
18: l_seglist fnd_flex_key_api.segment_list;
19: l_segs1 fnd_flex_ext.segmentarray;
20: l_segs2 fnd_flex_ext.segmentarray;
21: l_fftype fnd_flex_key_api.flexfield_type;
22: l_ffstru fnd_flex_key_api.structure_type;
23: l_segment_type fnd_flex_key_api.segment_type;
24: l_item_number VARCHAR2(32000);

Line 56: l_delim := fnd_flex_ext.get_delimiter('INV', 'MSTK', 101);

52: WHERE organization_id = p_organization_id
53: AND inventory_item_id = p_inventory_item_id;
54:
55: -- get delimiter for segment concatenation
56: l_delim := fnd_flex_ext.get_delimiter('INV', 'MSTK', 101);
57:
58: -- concatenate segments based on the order defined by the flex
59: -- field structure
60: FOR l_loop IN 1..l_nseg LOOP

Line 91: l_segs1 fnd_flex_ext.segmentarray;

87: , x_locator OUT NOCOPY VARCHAR2
88: ) IS
89: l_nseg NUMBER;
90: l_seglist fnd_flex_key_api.segment_list;
91: l_segs1 fnd_flex_ext.segmentarray;
92: l_segs2 fnd_flex_ext.segmentarray;
93: l_fftype fnd_flex_key_api.flexfield_type;
94: l_ffstru fnd_flex_key_api.structure_type;
95: l_segment_type fnd_flex_key_api.segment_type;

Line 92: l_segs2 fnd_flex_ext.segmentarray;

88: ) IS
89: l_nseg NUMBER;
90: l_seglist fnd_flex_key_api.segment_list;
91: l_segs1 fnd_flex_ext.segmentarray;
92: l_segs2 fnd_flex_ext.segmentarray;
93: l_fftype fnd_flex_key_api.flexfield_type;
94: l_ffstru fnd_flex_key_api.structure_type;
95: l_segment_type fnd_flex_key_api.segment_type;
96: l_locator VARCHAR2(32000);

Line 133: l_delim := fnd_flex_ext.get_delimiter('INV', 'MTLL', 101);

129: WHERE organization_id = p_organization_id
130: AND inventory_location_id = p_locator_id;
131:
132: -- get delimiter for segment concatenation
133: l_delim := fnd_flex_ext.get_delimiter('INV', 'MTLL', 101);
134:
135: -- concatenate segments based on the order defined by the flex
136: -- field structure
137: FOR l_loop IN 1..l_nseg LOOP