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 426: p_appl_short_name in FND_APPLICATION.APPLICATION_SHORT_NAME%TYPE

422:
423:
424:
425: PROCEDURE undo(
426: p_appl_short_name in FND_APPLICATION.APPLICATION_SHORT_NAME%TYPE
427: ,p_flexfield_name in FND_DESCRIPTIVE_FLEXS.DESCRIPTIVE_FLEXFIELD_NAME%TYPE
428: ,p_element_set_id in PAY_ELEMENT_SETS.ELEMENT_SET_ID%TYPE
429: ,p_effective_date in DATE
430: ,p_include_cost in VARCHAR2

Line 880: p_appl_short_name in FND_APPLICATION.APPLICATION_SHORT_NAME%TYPE

876:
877: END create_bld_blk_info_type;
878:
879: PROCEDURE create_missing_type_usages(
880: p_appl_short_name in FND_APPLICATION.APPLICATION_SHORT_NAME%TYPE
881: ,p_flex_name in FND_DESCRIPTIVE_FLEXS.DESCRIPTIVE_FLEXFIELD_NAME%TYPE
882: ) IS
883:
884: cursor c_missing(

Line 1077: p_otc_appl_short_name in FND_APPLICATION.APPLICATION_SHORT_NAME%TYPE

1073: END create_dummy_context;
1074:
1075:
1076: PROCEDURE create_segments(
1077: p_otc_appl_short_name in FND_APPLICATION.APPLICATION_SHORT_NAME%TYPE
1078: ,p_context in FND_DFLEX.context_r
1079: ,p_otc_flex_name in FND_DESCRIPTIVE_FLEXS.DESCRIPTIVE_FLEXFIELD_NAME%TYPE
1080: ,p_context_code in FND_DESCR_FLEX_CONTEXTS.DESCRIPTIVE_FLEX_CONTEXT_CODE%TYPE
1081: ) is

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

1179:
1180: END check_contexts;
1181:
1182: PROCEDURE duplicate_desc_flex
1183: (p_appl_short_name in FND_APPLICATION.APPLICATION_SHORT_NAME%TYPE,
1184: p_flexfield_name in FND_DESCRIPTIVE_FLEXS.DESCRIPTIVE_FLEXFIELD_NAME%TYPE,
1185: p_otc_appl_short_name in FND_APPLICATION.APPLICATION_SHORT_NAME%TYPE,
1186: p_otc_flex_name in FND_DESCRIPTIVE_FLEXS.DESCRIPTIVE_FLEXFIELD_NAME%TYPE,
1187: p_context_prefix in varchar2,

Line 1185: p_otc_appl_short_name in FND_APPLICATION.APPLICATION_SHORT_NAME%TYPE,

1181:
1182: PROCEDURE duplicate_desc_flex
1183: (p_appl_short_name in FND_APPLICATION.APPLICATION_SHORT_NAME%TYPE,
1184: p_flexfield_name in FND_DESCRIPTIVE_FLEXS.DESCRIPTIVE_FLEXFIELD_NAME%TYPE,
1185: p_otc_appl_short_name in FND_APPLICATION.APPLICATION_SHORT_NAME%TYPE,
1186: p_otc_flex_name in FND_DESCRIPTIVE_FLEXS.DESCRIPTIVE_FLEXFIELD_NAME%TYPE,
1187: p_context_prefix in varchar2,
1188: p_preserve in boolean
1189: ) is