APPS.HXC_MPC_BUS dependencies on HXC_MAPPING_COMPONENTS

Line 100: p_name in hxc_mapping_components.name%TYPE,

96: -- {End Of Comments}
97: -- ----------------------------------------------------------------------------
98: Procedure chk_name
99: (
100: p_name in hxc_mapping_components.name%TYPE,
101: p_mapping_component_id in hxc_mapping_components.mapping_component_id%TYPE
102: ) IS
103: --
104: l_proc varchar2(72);

Line 101: p_mapping_component_id in hxc_mapping_components.mapping_component_id%TYPE

97: -- ----------------------------------------------------------------------------
98: Procedure chk_name
99: (
100: p_name in hxc_mapping_components.name%TYPE,
101: p_mapping_component_id in hxc_mapping_components.mapping_component_id%TYPE
102: ) IS
103: --
104: l_proc varchar2(72);
105: --

Line 113: FROM hxc_mapping_components mpc

109: SELECT 'error'
110: FROM sys.dual
111: WHERE EXISTS (
112: SELECT 'x'
113: FROM hxc_mapping_components mpc
114: WHERE mpc.name = p_name
115: AND ( mpc.mapping_component_id <> p_mapping_component_id OR
116: p_mapping_component_id IS NULL ) );
117: --

Line 187: , p_segment in hxc_mapping_components.segment%TYPE

183: -- ----------------------------------------------------------------------------
184: Procedure chk_bld_blk_info_type_id
185: (
186: p_bld_blk_info_type_id in hxc_bld_blk_info_type_usages.bld_blk_info_type_id%TYPE
187: , p_segment in hxc_mapping_components.segment%TYPE
188: ) IS
189: --
190: l_proc varchar2(72);
191: --

Line 282: , p_segment in hxc_mapping_components.segment%TYPE

278: -- ----------------------------------------------------------------------------
279: Procedure chk_segment
280: (
281: p_bld_blk_info_type_id IN hxc_bld_blk_info_types.bld_blk_info_type_id%TYPE
282: , p_segment in hxc_mapping_components.segment%TYPE
283: ) IS
284: --
285: l_proc varchar2(72);
286:

Line 372: p_object_version_number in hxc_mapping_components.object_version_number%TYPE

368: -- {End Of Comments}
369: -- ----------------------------------------------------------------------------
370: Procedure chk_composite_key
371: (
372: p_object_version_number in hxc_mapping_components.object_version_number%TYPE
373: , p_field_name IN hxc_mapping_components.field_name%TYPE
374: , p_bld_blk_info_type_id IN hxc_mapping_components.bld_blk_info_type_id%TYPE
375: , p_segment IN hxc_mapping_components.segment%TYPE
376: ) IS

Line 373: , p_field_name IN hxc_mapping_components.field_name%TYPE

369: -- ----------------------------------------------------------------------------
370: Procedure chk_composite_key
371: (
372: p_object_version_number in hxc_mapping_components.object_version_number%TYPE
373: , p_field_name IN hxc_mapping_components.field_name%TYPE
374: , p_bld_blk_info_type_id IN hxc_mapping_components.bld_blk_info_type_id%TYPE
375: , p_segment IN hxc_mapping_components.segment%TYPE
376: ) IS
377: --

Line 374: , p_bld_blk_info_type_id IN hxc_mapping_components.bld_blk_info_type_id%TYPE

370: Procedure chk_composite_key
371: (
372: p_object_version_number in hxc_mapping_components.object_version_number%TYPE
373: , p_field_name IN hxc_mapping_components.field_name%TYPE
374: , p_bld_blk_info_type_id IN hxc_mapping_components.bld_blk_info_type_id%TYPE
375: , p_segment IN hxc_mapping_components.segment%TYPE
376: ) IS
377: --
378: l_proc varchar2(72);

Line 375: , p_segment IN hxc_mapping_components.segment%TYPE

371: (
372: p_object_version_number in hxc_mapping_components.object_version_number%TYPE
373: , p_field_name IN hxc_mapping_components.field_name%TYPE
374: , p_bld_blk_info_type_id IN hxc_mapping_components.bld_blk_info_type_id%TYPE
375: , p_segment IN hxc_mapping_components.segment%TYPE
376: ) IS
377: --
378: l_proc varchar2(72);
379:

Line 387: FROM hxc_mapping_components mpc

383: SELECT 'error'
384: FROM sys.dual
385: WHERE EXISTS (
386: SELECT 'x'
387: FROM hxc_mapping_components mpc
388: WHERE mpc.field_name = p_field_name
389: AND mpc.bld_blk_info_type_id = p_bld_blk_info_type_id
390: AND mpc.segment = p_segment
391: AND mpc.object_version_number <> NVL( p_object_version_number, -1 ));

Line 449: p_field_name in hxc_mapping_components.field_name%TYPE

445: -- {End Of Comments}
446: -- ----------------------------------------------------------------------------
447: Procedure chk_field_name
448: (
449: p_field_name in hxc_mapping_components.field_name%TYPE
450: ) IS
451: --
452: l_proc varchar2(72);
453:

Line 517: p_mapping_component_id in hxc_mapping_components.mapping_component_id%TYPE

513: -- {End Of Comments}
514: -- ----------------------------------------------------------------------------
515: Procedure chk_delete
516: (
517: p_mapping_component_id in hxc_mapping_components.mapping_component_id%TYPE
518: ) IS
519: --
520: l_proc varchar2(72);
521: --