DBA Data[Home] [Help]

APPS.BEN_ICD_FLEX_FIELD_SETUP dependencies on FND_DESCR_FLEX_CONTEXTS

Line 207: l_context_code FND_DESCR_FLEX_CONTEXTS.DESCRIPTIVE_FLEX_CONTEXT_CODE%TYPE;

203: n Number;
204: l_proc varchar2(100) := g_package||'create_icd_config';
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;

Line 255: from FND_DESCR_FLEX_CONTEXTS

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
256: where application_id = 805
257: and DESCRIPTIVE_FLEXFIELD_NAME = 'Ben ICD Developer DF'
258: and DESCRIPTIVE_FLEX_CONTEXT_CODE = to_char(l_element_type.element_type_id);
259: EXCEPTION