APPS.WMS_PARAMETER_PVT dependencies on FND_FLEX_KEY_API

Line 115: l_flexfield fnd_flex_key_api.flexfield_type;

111: , x_flex_data_type_code OUT NOCOPY NUMBER
112: , x_flex_name OUT NOCOPY VARCHAR2
113: , x_flex_description OUT NOCOPY VARCHAR2
114: ) IS
115: l_flexfield fnd_flex_key_api.flexfield_type;
116: l_segment fnd_flex_key_api.segment_type;
117: l_nstructures NUMBER;
118: l_structure fnd_flex_key_api.structure_type;
119: l_structure_list fnd_flex_key_api.structure_list;

Line 116: l_segment fnd_flex_key_api.segment_type;

112: , x_flex_name OUT NOCOPY VARCHAR2
113: , x_flex_description OUT NOCOPY VARCHAR2
114: ) IS
115: l_flexfield fnd_flex_key_api.flexfield_type;
116: l_segment fnd_flex_key_api.segment_type;
117: l_nstructures NUMBER;
118: l_structure fnd_flex_key_api.structure_type;
119: l_structure_list fnd_flex_key_api.structure_list;
120: l_valueset_dr fnd_vset.valueset_dr;

Line 118: l_structure fnd_flex_key_api.structure_type;

114: ) IS
115: l_flexfield fnd_flex_key_api.flexfield_type;
116: l_segment fnd_flex_key_api.segment_type;
117: l_nstructures NUMBER;
118: l_structure fnd_flex_key_api.structure_type;
119: l_structure_list fnd_flex_key_api.structure_list;
120: l_valueset_dr fnd_vset.valueset_dr;
121: l_valueset_r fnd_vset.valueset_r;
122: l_segment_found BOOLEAN := FALSE;

Line 119: l_structure_list fnd_flex_key_api.structure_list;

115: l_flexfield fnd_flex_key_api.flexfield_type;
116: l_segment fnd_flex_key_api.segment_type;
117: l_nstructures NUMBER;
118: l_structure fnd_flex_key_api.structure_type;
119: l_structure_list fnd_flex_key_api.structure_list;
120: l_valueset_dr fnd_vset.valueset_dr;
121: l_valueset_r fnd_vset.valueset_r;
122: l_segment_found BOOLEAN := FALSE;
123: l_nsegment NUMBER;

Line 124: l_segment_list fnd_flex_key_api.segment_list;

120: l_valueset_dr fnd_vset.valueset_dr;
121: l_valueset_r fnd_vset.valueset_r;
122: l_segment_found BOOLEAN := FALSE;
123: l_nsegment NUMBER;
124: l_segment_list fnd_flex_key_api.segment_list;
125: BEGIN
126: -- initialize
127: x_if_flex_then_available := 'Y';
128: x_flex_data_type_code := NULL;

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

128: x_flex_data_type_code := NULL;
129: x_flex_name := NULL;
130: x_flex_description := NULL;
131: --
132: fnd_flex_key_api.set_session_mode('seed_data');
133: --
134: l_flexfield := fnd_flex_key_api.find_flexfield(p_application_short_name, p_flexfield_name);
135:
136: --

Line 134: l_flexfield := fnd_flex_key_api.find_flexfield(p_application_short_name, p_flexfield_name);

130: x_flex_description := NULL;
131: --
132: fnd_flex_key_api.set_session_mode('seed_data');
133: --
134: l_flexfield := fnd_flex_key_api.find_flexfield(p_application_short_name, p_flexfield_name);
135:
136: --
137: IF l_flexfield.instantiated = 'N' THEN
138: RETURN;

Line 143: fnd_flex_key_api.get_structures(

139: END IF;
140:
141: -- since we have no info about the structure we would look at
142: -- all structures
143: fnd_flex_key_api.get_structures(
144: flexfield => l_flexfield
145: , enabled_only => TRUE
146: , nstructures => l_nstructures
147: , structures => l_structure_list

Line 152: l_structure := fnd_flex_key_api.find_structure(flexfield => l_flexfield, structure_number => l_structure_list(l_index));

148: );
149:
150: FOR l_index IN 1 .. l_nstructures LOOP
151: -- find the structure
152: l_structure := fnd_flex_key_api.find_structure(flexfield => l_flexfield, structure_number => l_structure_list(l_index));
153:
154: -- find the segment. only consider the ones freezed
155: IF l_structure.instantiated = 'Y'
156: AND l_structure.freeze_flag = 'Y' THEN

Line 157: fnd_flex_key_api.get_segments(l_flexfield, l_structure, TRUE, l_nsegment, l_segment_list);

153:
154: -- find the segment. only consider the ones freezed
155: IF l_structure.instantiated = 'Y'
156: AND l_structure.freeze_flag = 'Y' THEN
157: fnd_flex_key_api.get_segments(l_flexfield, l_structure, TRUE, l_nsegment, l_segment_list);
158:
159: FOR l_seg_index IN 1 .. l_nsegment LOOP
160: l_segment := fnd_flex_key_api.find_segment(l_flexfield, l_structure, l_segment_list(l_seg_index));
161:

Line 160: l_segment := fnd_flex_key_api.find_segment(l_flexfield, l_structure, l_segment_list(l_seg_index));

156: AND l_structure.freeze_flag = 'Y' THEN
157: fnd_flex_key_api.get_segments(l_flexfield, l_structure, TRUE, l_nsegment, l_segment_list);
158:
159: FOR l_seg_index IN 1 .. l_nsegment LOOP
160: l_segment := fnd_flex_key_api.find_segment(l_flexfield, l_structure, l_segment_list(l_seg_index));
161:
162: IF l_segment.column_name = p_column_name THEN
163: l_segment_found := TRUE;
164: EXIT;