APPS.HXC_CREATE_FLEX_MAPPINGS dependencies on HXC_PREF_DEFINITIONS

Line 326: insert into hxc_pref_definitions

322: --
323:
324: for context_rec in c_flex_context_name(p_flex_name, p_appl_short_name) LOOP
325:
326: insert into hxc_pref_definitions
327: (PREF_DEFINITION_ID,
328: CODE,
329: DESCRIPTIVE_FLEXFIELD_NAME)
330: select

Line 331: hxc_pref_definitions_s.nextval,

327: (PREF_DEFINITION_ID,
328: CODE,
329: DESCRIPTIVE_FLEXFIELD_NAME)
330: select
331: hxc_pref_definitions_s.nextval,
332: context_rec.descriptive_flex_context_code,
333: p_flex_name
334: from dual
335: where not exists(

Line 337: from hxc_pref_definitions

333: p_flex_name
334: from dual
335: where not exists(
336: select 'Y'
337: from hxc_pref_definitions
338: where code = context_rec.descriptive_flex_context_code
339: and descriptive_flexfield_name = p_flex_name);
340:
341: END LOOP;