APPS.BEN_ICD_FLEX_FIELD_SETUP dependencies on FND_DESCR_FLEX_COLUMN_USAGES

Line 213: l_segment_display_size fnd_descr_flex_column_usages.display_size%TYPE;

209: l_value_set_name fnd_flex_value_sets.flex_value_set_name%TYPE;
210: l_lookup_value_set_name fnd_flex_value_sets.flex_value_set_name%TYPE;
211: l_minmax_value_set_name fnd_flex_value_sets.flex_value_set_name%TYPE;
212: l_dataformat_value_set_name fnd_flex_value_sets.flex_value_set_name%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;

Line 588: from fnd_descr_flex_column_usages

584: ) is
585:
586: cursor c_input_value_segment is
587: select *
588: from fnd_descr_flex_column_usages
589: where application_id = 805
590: and descriptive_flexfield_name = 'Ben ICD Developer DF'
591: and descriptive_flex_context_code = to_char(p_element_type_id)
592: --vkodedal 7827903 - append string to input value id

Line 607: l_display fnd_descr_flex_column_usages.display_flag%TYPE;

603: and show_on_overview_flag = 'Y'
604: and input_value_id <> P_INPUT_VALUE_ID;
605:
606: l_proc varchar2(100) := g_package||'update_icd_config';
607: l_display fnd_descr_flex_column_usages.display_flag%TYPE;
608: l_value_set_name fnd_flex_value_sets.flex_value_set_name%TYPE;
609: l_input_value_segment c_input_value_segment%ROWTYPE;
610: l_input_value_id number;
611: begin