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 427: ,p_flexfield_name in FND_DESCRIPTIVE_FLEXS.DESCRIPTIVE_FLEXFIELD_NAME%TYPE

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

Line 881: ,p_flex_name in FND_DESCRIPTIVE_FLEXS.DESCRIPTIVE_FLEXFIELD_NAME%TYPE

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

Line 885: p_flex_name in FND_DESCRIPTIVE_FLEXS.DESCRIPTIVE_FLEXFIELD_NAME%TYPE

881: ,p_flex_name in FND_DESCRIPTIVE_FLEXS.DESCRIPTIVE_FLEXFIELD_NAME%TYPE
882: ) IS
883:
884: cursor c_missing(
885: p_flex_name in FND_DESCRIPTIVE_FLEXS.DESCRIPTIVE_FLEXFIELD_NAME%TYPE
886: )is
887: select fdfc.DESCRIPTIVE_FLEX_CONTEXT_CODE
888: from fnd_descr_flex_contexts fdfc
889: where descriptive_flexfield_name = p_flex_name

Line 1079: ,p_otc_flex_name in FND_DESCRIPTIVE_FLEXS.DESCRIPTIVE_FLEXFIELD_NAME%TYPE

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
1082:
1083: l_segments FND_DFLEX.segments_dr;

Line 1184: p_flexfield_name in FND_DESCRIPTIVE_FLEXS.DESCRIPTIVE_FLEXFIELD_NAME%TYPE,

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

Line 1186: p_otc_flex_name in FND_DESCRIPTIVE_FLEXS.DESCRIPTIVE_FLEXFIELD_NAME%TYPE,

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