eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_ICD_FLEX_FIELD_SETUP dependencies on FND_FLEX_VALUE_SETS

Line 209: l_value_set_name fnd_flex_value_sets.flex_value_set_name%TYPE;

205: l_element_type_id pay_element_types_f.element_type_id%TYPE;
206: l_element_entry_id number;
207: l_context_code FND_DESCR_FLEX_CONTEXTS.DESCRIPTIVE_FLEX_CONTEXT_CODE%TYPE;
208: l_element_type pay_element_types_f%ROWTYPE;
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;

Line 210: l_lookup_value_set_name fnd_flex_value_sets.flex_value_set_name%TYPE;

206: l_element_entry_id number;
207: l_context_code FND_DESCR_FLEX_CONTEXTS.DESCRIPTIVE_FLEX_CONTEXT_CODE%TYPE;
208: l_element_type pay_element_types_f%ROWTYPE;
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;

Line 211: l_minmax_value_set_name fnd_flex_value_sets.flex_value_set_name%TYPE;

207: l_context_code FND_DESCR_FLEX_CONTEXTS.DESCRIPTIVE_FLEX_CONTEXT_CODE%TYPE;
208: l_element_type pay_element_types_f%ROWTYPE;
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;

Line 212: l_dataformat_value_set_name fnd_flex_value_sets.flex_value_set_name%TYPE;

208: l_element_type pay_element_types_f%ROWTYPE;
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;

Line 214: l_value_set_format_type fnd_flex_value_sets.format_type%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;
218: l_show_on_overview_flag ben_icd_ss_config.SHOW_ON_OVERVIEW_flag%TYPE;

Line 215: l_value_set_maximum_size fnd_flex_value_sets.maximum_size%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;
218: l_show_on_overview_flag ben_icd_ss_config.SHOW_ON_OVERVIEW_flag%TYPE;
219: l_context_exists_flag boolean;

Line 216: l_value_set_number_precision fnd_flex_value_sets.number_precision%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;
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;

Line 375: FROM fnd_flex_value_sets

371: begin
372: begin
373: SELECT
374: flex_value_set_name,maximum_size into l_value_set_name,l_value_set_maximum_size
375: FROM fnd_flex_value_sets
376: WHERE flex_value_set_id =l_input_value.value_set_id;
377: Exception
378: When No_Data_Found Then
379: RAISE;

Line 597: from fnd_flex_value_sets

593: and end_user_column_name = 'ICD_'||p_input_value_id;
594:
595: cursor c_value_set_name(p_value_set_id number) is
596: select flex_value_set_name
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

Line 608: l_value_set_name fnd_flex_value_sets.flex_value_set_name%TYPE;

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
612: hr_utility.set_location('Entering: '||l_proc,10);