APPS.BEN_ICD_FLEX_FIELD_SETUP SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 10

	select input_value_id
	from pay_input_values_f
	where element_type_id = p_element_type_id
	and p_effective_date between effective_start_date and effective_end_date
	order by display_sequence asc;

Line: 189

select * from
pay_input_values_f
where element_type_id = p_element_type_id
and p_effective_date between effective_start_date and effective_end_date
order by input_value_id asc;

Line: 196

select * from
pay_element_types_f
where element_type_id = p_element_type_id
and p_effective_date between effective_start_date and effective_end_date;

Line: 233

select element_type_id into l_element_type_id
  from PAY_ELEMENT_LINKS_F
  where element_link_id = P_ELEMENT_LINK_ID
  and p_effective_date between effective_start_date and effective_end_date; */

Line: 254

    select DESCRIPTIVE_FLEX_CONTEXT_CODE into l_context_code
    from FND_DESCR_FLEX_CONTEXTS
    where application_id = 805
    and DESCRIPTIVE_FLEXFIELD_NAME = 'Ben ICD Developer DF'
    and DESCRIPTIVE_FLEX_CONTEXT_CODE = to_char(l_element_type.element_type_id);

Line: 373

			SELECT
	   		flex_value_set_name,maximum_size into l_value_set_name,l_value_set_maximum_size
        		FROM fnd_flex_value_sets
        		WHERE flex_value_set_id =l_input_value.value_set_id;

Line: 539

		select input_value_id into l_input_value_id
		from ben_icd_ss_config
		where input_value_id = l_input_value.input_value_id;

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)
		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);

Line: 553

		update ben_icd_ss_config
		set
			uom = l_input_value.uom
			,show_on_overview_flag = l_show_on_overview_flag
			,user_enterable_flag = l_user_enterable_flag
		where input_value_id = l_input_value.input_value_id;

Line: 565

       update ben_icd_ss_config
	    set show_on_overview_flag = 'Y'
		where input_value_id =  l_lowest_seq_input_value_id
		and not exists (select 'Y' from ben_icd_ss_config
		                 where element_type_id = p_element_type_id
						 and show_on_overview_flag = 'Y');

Line: 576

procedure UPDATE_ICD_CONFIG(
	P_ELEMENT_TYPE_ID IN NUMBER,
	P_INPUT_VALUE_ID IN NUMBER,
	P_COLUMN_SEQ_NUM IN NUMBER,
	P_SELF_SERVICE_DISPLAY_PROMPT IN VARCHAR2,
	P_HIDDEN_IN_SELFSERVICE IN VARCHAR2,
	P_USER_ENTERABLE_FLAG IN VARCHAR2,
	P_SHOW_ON_OVERVIEW_FLAG IN VARCHAR2
	) is

cursor c_input_value_segment is
	select *
	from	fnd_descr_flex_column_usages
	where application_id = 805
	and descriptive_flexfield_name = 'Ben ICD Developer DF'
	and descriptive_flex_context_code = to_char(p_element_type_id)
	   --vkodedal 7827903 - append string to input value id
	and end_user_column_name = 'ICD_'||p_input_value_id;

Line: 596

	select flex_value_set_name
	from fnd_flex_value_sets
	where flex_value_set_id = p_value_set_id;

Line: 601

    select input_value_id from ben_icd_ss_config
	where element_type_id = p_element_type_id
	and show_on_overview_flag = 'Y'
    and input_value_id <> P_INPUT_VALUE_ID;

Line: 606

l_proc varchar2(100) := g_package||'update_icd_config';

Line: 620

           update ben_icd_ss_config
	         set show_on_overview_flag = 'N'
	       where input_value_id = l_input_value_id;

Line: 664

	update ben_icd_ss_config
	  set user_enterable_flag = p_user_enterable_flag,
	      show_on_overview_flag = p_show_on_overview_flag
	  where input_value_id = p_input_value_id;

Line: 673

end UPDATE_ICD_CONFIG;

Line: 689

	delete_icd_config(p_element_type_id,p_effective_date);

Line: 700

procedure DELETE_ICD_CONFIG (
	 P_ELEMENT_TYPE_ID IN NUMBER,
         P_EFFECTIVE_DATE IN DATE
        ) is
l_proc varchar2(100) := g_package||'delete_icd_config';

Line: 710

	fnd_flex_dsc_api.delete_context(
		appl_short_name  => 'BEN',
		 flexfield_name	  => 'Ben ICD Developer DF',
		 context          => to_char(p_element_type_id));

Line: 715

	-- Delete the existing SS Config information
	  delete from ben_icd_ss_config
	  where element_type_id = p_element_type_id;

Line: 720

end DELETE_ICD_CONFIG;