APPS.BEN_ICD_FLEX_FIELD_SETUP dependencies on BEN_ICD_SS_CONFIG

Line 217: l_user_enterable_flag ben_icd_ss_config.USER_ENTERABLE_FLAG%TYPE;

213: l_segment_display_size fnd_descr_flex_column_usages.display_size%TYPE;
214: l_value_set_format_type fnd_flex_value_sets.format_type%TYPE;
215: l_value_set_maximum_size fnd_flex_value_sets.maximum_size%TYPE;
216: l_value_set_number_precision fnd_flex_value_sets.number_precision%TYPE;
217: l_user_enterable_flag ben_icd_ss_config.USER_ENTERABLE_FLAG%TYPE;
218: l_show_on_overview_flag ben_icd_ss_config.SHOW_ON_OVERVIEW_flag%TYPE;
219: l_context_exists_flag boolean;
220: l_ss_config_exists_flag boolean;
221: l_lowest_seq_input_value_id number;

Line 218: l_show_on_overview_flag ben_icd_ss_config.SHOW_ON_OVERVIEW_flag%TYPE;

214: l_value_set_format_type fnd_flex_value_sets.format_type%TYPE;
215: l_value_set_maximum_size fnd_flex_value_sets.maximum_size%TYPE;
216: l_value_set_number_precision fnd_flex_value_sets.number_precision%TYPE;
217: l_user_enterable_flag ben_icd_ss_config.USER_ENTERABLE_FLAG%TYPE;
218: l_show_on_overview_flag ben_icd_ss_config.SHOW_ON_OVERVIEW_flag%TYPE;
219: l_context_exists_flag boolean;
220: l_ss_config_exists_flag boolean;
221: l_lowest_seq_input_value_id number;
222: l_required varchar2(1);

Line 540: from ben_icd_ss_config

536: -- Create the SS CONFIG information for this Input Value
537:
538: begin
539: select input_value_id into l_input_value_id
540: from ben_icd_ss_config
541: where input_value_id = l_input_value.input_value_id;
542: EXCEPTION
543: when no_data_found then
544: l_ss_config_exists_flag := false;

Line 549: insert into ben_icd_ss_config(element_type_id,input_value_id,uom,show_on_overview_flag,user_enterable_flag,input_value_id_char,order_num)

545: end;
546:
547: if(NOT l_ss_config_exists_flag) then
548: hr_utility.set_location('Creating Config Information',36);
549: insert into ben_icd_ss_config(element_type_id,input_value_id,uom,show_on_overview_flag,user_enterable_flag,input_value_id_char,order_num)
550: values(l_element_type_id,l_input_value.input_value_id,l_input_value.uom,l_show_on_overview_flag,l_user_enterable_flag,to_char(l_input_value.input_value_id),i);
551: else
552: hr_utility.set_location('Updating Config Information',37);
553: update ben_icd_ss_config

Line 553: update ben_icd_ss_config

549: insert into ben_icd_ss_config(element_type_id,input_value_id,uom,show_on_overview_flag,user_enterable_flag,input_value_id_char,order_num)
550: values(l_element_type_id,l_input_value.input_value_id,l_input_value.uom,l_show_on_overview_flag,l_user_enterable_flag,to_char(l_input_value.input_value_id),i);
551: else
552: hr_utility.set_location('Updating Config Information',37);
553: update ben_icd_ss_config
554: set
555: uom = l_input_value.uom
556: ,show_on_overview_flag = l_show_on_overview_flag
557: ,user_enterable_flag = l_user_enterable_flag

Line 565: update ben_icd_ss_config

561: i := i + 1;
562:
563: end loop;
564: --flag an input value as show on overview if none is flagged by now.
565: update ben_icd_ss_config
566: set show_on_overview_flag = 'Y'
567: where input_value_id = l_lowest_seq_input_value_id
568: and not exists (select 'Y' from ben_icd_ss_config
569: where element_type_id = p_element_type_id

Line 568: and not exists (select 'Y' from ben_icd_ss_config

564: --flag an input value as show on overview if none is flagged by now.
565: update ben_icd_ss_config
566: set show_on_overview_flag = 'Y'
567: where input_value_id = l_lowest_seq_input_value_id
568: and not exists (select 'Y' from ben_icd_ss_config
569: where element_type_id = p_element_type_id
570: and show_on_overview_flag = 'Y');
571: end;
572: end if;

Line 601: select input_value_id from ben_icd_ss_config

597: from fnd_flex_value_sets
598: where flex_value_set_id = p_value_set_id;
599:
600: cursor c_check_show_on_overview(P_ELEMENT_TYPE_ID NUMBER,P_INPUT_VALUE_ID number) is
601: select input_value_id from ben_icd_ss_config
602: where element_type_id = p_element_type_id
603: and show_on_overview_flag = 'Y'
604: and input_value_id <> P_INPUT_VALUE_ID;
605:

Line 620: update ben_icd_ss_config

616: if('Y' = P_SHOW_ON_OVERVIEW_FLAG) then
617: open c_check_show_on_overview(P_ELEMENT_TYPE_ID,P_INPUT_VALUE_ID);
618: fetch c_check_show_on_overview into l_input_value_id;
619: if( c_check_show_on_overview%found) then
620: update ben_icd_ss_config
621: set show_on_overview_flag = 'N'
622: where input_value_id = l_input_value_id;
623: end if;
624: close c_check_show_on_overview;

Line 664: update ben_icd_ss_config

660: hr_utility.set_location('Updating SS Config info',40);
661: -- if( 'Y' = p_show_on_overview_flag) then
662: /*check if there is any other checked already then error*/
663:
664: update ben_icd_ss_config
665: set user_enterable_flag = p_user_enterable_flag,
666: show_on_overview_flag = p_show_on_overview_flag
667: where input_value_id = p_input_value_id;
668:

Line 716: delete from ben_icd_ss_config

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);
715: -- Delete the existing SS Config information
716: delete from ben_icd_ss_config
717: where element_type_id = p_element_type_id;
718:
719: hr_utility.set_location('Leaving: '||l_proc,40);
720: end DELETE_ICD_CONFIG;