APPS.WMS_PARAMETER_PVT dependencies on FND_VSET

Line 120: l_valueset_dr fnd_vset.valueset_dr;

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;
124: l_segment_list fnd_flex_key_api.segment_list;

Line 121: l_valueset_r fnd_vset.valueset_r;

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;
124: l_segment_list fnd_flex_key_api.segment_list;
125: BEGIN

Line 188: fnd_vset.get_valueset(valueset_id => l_segment.value_set_id, valueset => l_valueset_r, format => l_valueset_dr);

184: -- if the segment does not use a value set, no type info
185: IF l_segment.value_set_id IS NULL THEN
186: x_flex_data_type_code := NULL;
187: ELSE
188: fnd_vset.get_valueset(valueset_id => l_segment.value_set_id, valueset => l_valueset_r, format => l_valueset_dr);
189:
190: --
191: IF l_valueset_dr.format_type = 'N' THEN -- number type
192: x_flex_data_type_code := 1;

Line 237: l_valueset_dr fnd_vset.valueset_dr;

233: l_segments fnd_dflex.segments_dr;
234: l_segment_index BINARY_INTEGER;
235: l_context_index BINARY_INTEGER;
236: l_global_context_idx BINARY_INTEGER;
237: l_valueset_dr fnd_vset.valueset_dr;
238: l_valueset_r fnd_vset.valueset_r;
239: BEGIN
240: -- initialize
241: x_flex_data_type_code := NULL;

Line 238: l_valueset_r fnd_vset.valueset_r;

234: l_segment_index BINARY_INTEGER;
235: l_context_index BINARY_INTEGER;
236: l_global_context_idx BINARY_INTEGER;
237: l_valueset_dr fnd_vset.valueset_dr;
238: l_valueset_r fnd_vset.valueset_r;
239: BEGIN
240: -- initialize
241: x_flex_data_type_code := NULL;
242: x_flex_name := NULL;

Line 339: fnd_vset.get_valueset(valueset_id => l_segments.value_set(l_segment_index), valueset => l_valueset_r, format => l_valueset_dr);

335: -- if the segment does not use a value set, no type info
336: IF l_segments.value_set(l_segment_index) IS NULL THEN
337: x_flex_data_type_code := NULL;
338: ELSE
339: fnd_vset.get_valueset(valueset_id => l_segments.value_set(l_segment_index), valueset => l_valueset_r, format => l_valueset_dr);
340:
341: IF l_valueset_dr.format_type = 'N' THEN -- number type
342: x_flex_data_type_code := 1;
343: ELSIF l_valueset_dr.format_type = 'C' THEN -- character type