DBA Data[Home] [Help]

APPS.HXC_MCU_UPLOAD_PKG dependencies on HXC_MAPPING_COMP_USAGES

Line 49: l_mapping_comp_usage_id hxc_mapping_comp_usages.mapping_comp_usage_id%TYPE;

45: , p_mapping_name IN VARCHAR2
46: , p_owner IN VARCHAR2
47: , p_custom_mode IN VARCHAR2 ) IS
48:
49: l_mapping_comp_usage_id hxc_mapping_comp_usages.mapping_comp_usage_id%TYPE;
50: l_mapping_component_id hxc_mapping_components.mapping_component_id%TYPE;
51: l_mapping_id hxc_mappings.mapping_id%TYPE;
52: l_ovn hxc_mapping_comp_usages.object_version_number%TYPE;
53: l_owner VARCHAR2(6);

Line 52: l_ovn hxc_mapping_comp_usages.object_version_number%TYPE;

48:
49: l_mapping_comp_usage_id hxc_mapping_comp_usages.mapping_comp_usage_id%TYPE;
50: l_mapping_component_id hxc_mapping_components.mapping_component_id%TYPE;
51: l_mapping_id hxc_mappings.mapping_id%TYPE;
52: l_ovn hxc_mapping_comp_usages.object_version_number%TYPE;
53: l_owner VARCHAR2(6);
54:
55: BEGIN
56:

Line 67: FROM hxc_mapping_comp_usages mcu

63: , DECODE( NVL( mcu.last_updated_by,-1), 1, 'SEED', 'CUSTOM')
64: INTO l_mapping_comp_usage_id
65: , l_ovn
66: , l_owner
67: FROM hxc_mapping_comp_usages mcu
68: , hxc_mapping_components mpc
69: WHERE mpc.name = P_NAME
70: AND mcu.mapping_component_id = mpc.mapping_component_id
71: AND mcu.mapping_id = l_mapping_id;