247: open c_element_type(l_element_type_id);
248: fetch c_element_type into l_element_type;
249: close c_element_type;
250:
251: fnd_flex_dsc_api.set_session_mode('customer_data');
252:
253: begin
254: select DESCRIPTIVE_FLEX_CONTEXT_CODE into l_context_code
255: from FND_DESCR_FLEX_CONTEXTS
263:
264: if(NOT l_context_exists_flag) then
265: begin
266: hr_utility.set_location('Creating Context: '||to_char(l_element_type.element_type_id),20);
267: fnd_flex_dsc_api.create_context(
268: /* identification */
269: appl_short_name => 'BEN',
270: flexfield_name => 'Ben ICD Developer DF',
271: /* data */
385: l_segment_display_size:=l_value_set_maximum_size;
386: end if ;
387: hr_utility.set_location('Fetched valueset: '||l_value_set_name,31);
388: hr_utility.set_location('Creating Segment for InputValue: '||to_char(l_input_value.input_value_id),32);
389: fnd_flex_dsc_api.create_segment(
390: /* identification */
391: appl_short_name => 'BEN',
392: flexfield_name => 'Ben ICD Developer DF',
393: context_name => to_char(l_element_type.element_type_id),
418: elsif(l_input_value.LOOKUP_TYPE is not null) then
419: begin
420: l_lookup_value_set_name := create_lookup_valueset(l_input_value.LOOKUP_TYPE,3,l_value_set_format_type);
421: hr_utility.set_location('Creating Segment for InputValue: '||to_char(l_input_value.input_value_id),33);
422: fnd_flex_dsc_api.create_segment(
423: /* identification */
424: appl_short_name => 'BEN',
425: flexfield_name => 'Ben ICD Developer DF',
426: context_name => to_char(l_element_type.element_type_id),
455: elsif(l_input_value.MIN_VALUE is not null or l_input_value.MAX_VALUE is not null) then
456: begin
457: l_minmax_value_set_name := create_minmax_valueset(3,l_value_set_format_type,l_input_value.MIN_VALUE,l_input_value.MAX_VALUE);
458: hr_utility.set_location('Creating Segment for InputValue: '||to_char(l_input_value.input_value_id),34);
459: fnd_flex_dsc_api.create_segment(
460: appl_short_name => 'BEN',
461: flexfield_name => 'Ben ICD Developer DF',
462: context_name => to_char(l_element_type.element_type_id),
463: name => to_char(l_input_value.input_value_id),
488: l_dataformat_value_set_name :=
489: create_data_format_valueset(l_value_set_format_type,l_value_set_maximum_size,l_value_set_number_precision,l_input_value.UOM);
490:
491: hr_utility.set_location('Creating Segment for InputValue: '||to_char(l_input_value.input_value_id),35);
492: fnd_flex_dsc_api.create_segment(
493: /* identification */
494: appl_short_name => 'BEN',
495: flexfield_name => 'Ben ICD Developer DF',
496: context_name => to_char(l_element_type.element_type_id),
623: end if;
624: close c_check_show_on_overview;
625: end if;
626:
627: fnd_flex_dsc_api.set_session_mode('customer_data');
628:
629: open c_input_value_segment;
630: fetch c_input_value_segment into l_input_value_segment;
631: close c_input_value_segment;
642: hr_utility.set_location('modifying the segment afresh',30);
643: -- Create the segment afresh with the new configuration options
644:
645:
646: fnd_flex_dsc_api.modify_segment(
647: p_appl_short_name => 'BEN',
648: p_flexfield_name => 'Ben ICD Developer DF',
649: p_context_code => to_char(p_element_type_id),
650: --vkodedal 7827903 - append string to input value id
706: hr_utility.set_location('Entering: '||l_proc,10);
707:
708: -- Deleting the existing Descriptive Flex information of this Element Type
709: hr_utility.set_location('Deleting flex context of: '||to_char(p_element_type_id),20);
710: fnd_flex_dsc_api.delete_context(
711: appl_short_name => 'BEN',
712: flexfield_name => 'Ben ICD Developer DF',
713: context => to_char(p_element_type_id));
714: hr_utility.set_location('Deleting ss config info of: '||to_char(p_element_type_id),30);