307: -- Local variables
308: --
309: l_segments t_segments := t_segments();
310: l_segments_exist BOOLEAN := FALSE;
311: l_all_segments hr_descr_flex_info.t_segments := hr_descr_flex_info.t_segments();
312: l_used_segments t_segments := t_segments();
313: l_all_index_number NUMBER;
314: l_used_index_number NUMBER;
315: l_used_segment_found BOOLEAN;
333: ELSE
334: --
335: -- Retrieve all segments available for this descriptive flexfield
336: --
337: l_all_segments := hr_descr_flex_info.segments
338: (p_application_id => p_application_id
339: ,p_descriptive_flexfield_name => p_descriptive_flexfield_name
340: );
341: --