APPS.HXC_CREATE_FLEX_MAPPINGS dependencies on FND_APPLICATION

Line 257: p_appl_short_name in FND_APPLICATION.APPLICATION_SHORT_NAME%TYPE,

253:
254: END remove_bld_blk_usage;
255:
256: PROCEDURE remove_flex_context(
257: p_appl_short_name in FND_APPLICATION.APPLICATION_SHORT_NAME%TYPE,
258: p_flexfield_name in FND_DESCRIPTIVE_FLEXS.DESCRIPTIVE_FLEXFIELD_NAME%TYPE,
259: p_flex_context_basis in VARCHAR2) IS
260:
261: cursor c_flex(

Line 303: ,p_appl_short_name in FND_APPLICATION.APPLICATION_SHORT_NAME%TYPE) is

299: END remove_bld_blk_info_type;
300:
301: PROCEDURE create_preference_definitions(
302: p_flex_name in FND_DESCRIPTIVE_FLEXS.DESCRIPTIVE_FLEXFIELD_NAME%TYPE
303: ,p_appl_short_name in FND_APPLICATION.APPLICATION_SHORT_NAME%TYPE) is
304:
305:
306: cursor c_flex_context_name(
307: p_flex_name in FND_DESCRIPTIVE_FLEXS.DESCRIPTIVE_FLEXFIELD_NAME%TYPE

Line 308: ,p_appl_short_name in FND_APPLICATION.APPLICATION_SHORT_NAME%TYPE

304:
305:
306: cursor c_flex_context_name(
307: p_flex_name in FND_DESCRIPTIVE_FLEXS.DESCRIPTIVE_FLEXFIELD_NAME%TYPE
308: ,p_appl_short_name in FND_APPLICATION.APPLICATION_SHORT_NAME%TYPE
309: ) is
310: select c.descriptive_flex_context_code, c.descriptive_flex_context_name
311: from fnd_descr_flex_contexts_vl c,
312: fnd_application a

Line 312: fnd_application a

308: ,p_appl_short_name in FND_APPLICATION.APPLICATION_SHORT_NAME%TYPE
309: ) is
310: select c.descriptive_flex_context_code, c.descriptive_flex_context_name
311: from fnd_descr_flex_contexts_vl c,
312: fnd_application a
313: where c.descriptive_flexfield_name = p_flex_name
314: and a.application_short_name = p_appl_short_name
315: and a.application_id = c.application_id
316: and c.descriptive_flex_context_code <> 'Global Data Elements';

Line 347: p_appl_short_name in FND_APPLICATION.APPLICATION_SHORT_NAME%TYPE

343:
344: END create_preference_definitions;
345:
346: PROCEDURE undo(
347: p_appl_short_name in FND_APPLICATION.APPLICATION_SHORT_NAME%TYPE
348: ,p_flexfield_name in FND_DESCRIPTIVE_FLEXS.DESCRIPTIVE_FLEXFIELD_NAME%TYPE
349: ,p_element_set_id in PAY_ELEMENT_SETS.ELEMENT_SET_ID%TYPE
350: ,p_effective_date in DATE
351: ,p_include_cost in VARCHAR2

Line 781: p_appl_short_name in FND_APPLICATION.APPLICATION_SHORT_NAME%TYPE

777:
778: END create_bld_blk_info_type;
779:
780: PROCEDURE create_missing_type_usages(
781: p_appl_short_name in FND_APPLICATION.APPLICATION_SHORT_NAME%TYPE
782: ,p_flex_name in FND_DESCRIPTIVE_FLEXS.DESCRIPTIVE_FLEXFIELD_NAME%TYPE
783: ) IS
784:
785: cursor c_missing(

Line 978: p_otc_appl_short_name in FND_APPLICATION.APPLICATION_SHORT_NAME%TYPE

974: END create_dummy_context;
975:
976:
977: PROCEDURE create_segments(
978: p_otc_appl_short_name in FND_APPLICATION.APPLICATION_SHORT_NAME%TYPE
979: ,p_context in FND_DFLEX.context_r
980: ,p_otc_flex_name in FND_DESCRIPTIVE_FLEXS.DESCRIPTIVE_FLEXFIELD_NAME%TYPE
981: ,p_context_code in FND_DESCR_FLEX_CONTEXTS.DESCRIPTIVE_FLEX_CONTEXT_CODE%TYPE
982: ) is

Line 1084: (p_appl_short_name in FND_APPLICATION.APPLICATION_SHORT_NAME%TYPE,

1080:
1081: END check_contexts;
1082:
1083: PROCEDURE duplicate_desc_flex
1084: (p_appl_short_name in FND_APPLICATION.APPLICATION_SHORT_NAME%TYPE,
1085: p_flexfield_name in FND_DESCRIPTIVE_FLEXS.DESCRIPTIVE_FLEXFIELD_NAME%TYPE,
1086: p_otc_appl_short_name in FND_APPLICATION.APPLICATION_SHORT_NAME%TYPE,
1087: p_otc_flex_name in FND_DESCRIPTIVE_FLEXS.DESCRIPTIVE_FLEXFIELD_NAME%TYPE,
1088: p_context_prefix in varchar2,

Line 1086: p_otc_appl_short_name in FND_APPLICATION.APPLICATION_SHORT_NAME%TYPE,

1082:
1083: PROCEDURE duplicate_desc_flex
1084: (p_appl_short_name in FND_APPLICATION.APPLICATION_SHORT_NAME%TYPE,
1085: p_flexfield_name in FND_DESCRIPTIVE_FLEXS.DESCRIPTIVE_FLEXFIELD_NAME%TYPE,
1086: p_otc_appl_short_name in FND_APPLICATION.APPLICATION_SHORT_NAME%TYPE,
1087: p_otc_flex_name in FND_DESCRIPTIVE_FLEXS.DESCRIPTIVE_FLEXFIELD_NAME%TYPE,
1088: p_context_prefix in varchar2,
1089: p_preserve in boolean
1090: ) is