DBA Data[Home] [Help]

APPS.HXC_CREATE_FLEX_MAPPINGS dependencies on FND_DESCRIPTIVE_FLEXS

Line 258: p_flexfield_name in FND_DESCRIPTIVE_FLEXS.DESCRIPTIVE_FLEXFIELD_NAME%TYPE,

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(
262: p_flex_context_basis in HXC_BLD_BLK_INFO_TYPES.BLD_BLK_INFO_TYPE%TYPE

Line 302: p_flex_name in FND_DESCRIPTIVE_FLEXS.DESCRIPTIVE_FLEXFIELD_NAME%TYPE

298:
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(

Line 307: 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
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,

Line 348: ,p_flexfield_name in FND_DESCRIPTIVE_FLEXS.DESCRIPTIVE_FLEXFIELD_NAME%TYPE

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
352: ,p_include_group in VARCHAR2

Line 782: ,p_flex_name in FND_DESCRIPTIVE_FLEXS.DESCRIPTIVE_FLEXFIELD_NAME%TYPE

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(
786: p_flex_name in FND_DESCRIPTIVE_FLEXS.DESCRIPTIVE_FLEXFIELD_NAME%TYPE

Line 786: p_flex_name in FND_DESCRIPTIVE_FLEXS.DESCRIPTIVE_FLEXFIELD_NAME%TYPE

782: ,p_flex_name in FND_DESCRIPTIVE_FLEXS.DESCRIPTIVE_FLEXFIELD_NAME%TYPE
783: ) IS
784:
785: cursor c_missing(
786: p_flex_name in FND_DESCRIPTIVE_FLEXS.DESCRIPTIVE_FLEXFIELD_NAME%TYPE
787: )is
788: select fdfc.DESCRIPTIVE_FLEX_CONTEXT_CODE
789: from fnd_descr_flex_contexts fdfc
790: where descriptive_flexfield_name = p_flex_name

Line 980: ,p_otc_flex_name in FND_DESCRIPTIVE_FLEXS.DESCRIPTIVE_FLEXFIELD_NAME%TYPE

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
983:
984: l_segments FND_DFLEX.segments_dr;

Line 1085: p_flexfield_name in FND_DESCRIPTIVE_FLEXS.DESCRIPTIVE_FLEXFIELD_NAME%TYPE,

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,
1089: p_preserve in boolean

Line 1087: p_otc_flex_name in FND_DESCRIPTIVE_FLEXS.DESCRIPTIVE_FLEXFIELD_NAME%TYPE,

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
1091: