270: and enabled_flag='Y'
271: order by segment_num;
272:
273: l_xname varchar2(240);
274: l_ch_seg FND_FLEX_EXT.SegmentArray;
275: c number;
276: l_rnum number;
277: l_format varchar2(1);
278: l_flexnum number;
305: l_delimiter := FND_FLEX_APIS.get_segment_delimiter(
306: x_application_id => 801,
307: x_id_flex_code => 'GRP' ,
308: x_id_flex_num => l_flexnum );
309: c := fnd_flex_ext.breakup_segments(l_xname,l_delimiter,l_ch_seg);
310: fnd_profile.get('ICX_DATE_FORMAT_MASK',l_dateformat);
311:
312: IF g_debug THEN
313: hr_utility.set_location( g_package || l_proc, 10);
327: end if;
328:
329: i := i + 1;
330: end loop;
331: l_xname:= fnd_flex_ext.concatenate_segments(c,l_ch_seg,l_delimiter);
332: -- p_group_name := l_xname;
333: end if;
334: --End of Fix 2762904
335: IF g_debug THEN