APPS.HXC_ALIAS_TYPES_UPLOAD_PKG dependencies on HXC_MAPPING_COMPONENTS

Line 43: FROM hxc_mapping_components

39:
40: FUNCTION find_mapping_component_id (p_mapping_component_name VARCHAR2) RETURN number IS
41: CURSOR csr_get_mapping_component_id IS
42: SELECT mapping_component_id
43: FROM hxc_mapping_components
44: WHERE name = p_mapping_component_name;
45: l_mapping_component_id hxc_mapping_components.mapping_component_id%TYPE;
46: BEGIN
47: OPEN csr_get_mapping_component_id;

Line 45: l_mapping_component_id hxc_mapping_components.mapping_component_id%TYPE;

41: CURSOR csr_get_mapping_component_id IS
42: SELECT mapping_component_id
43: FROM hxc_mapping_components
44: WHERE name = p_mapping_component_name;
45: l_mapping_component_id hxc_mapping_components.mapping_component_id%TYPE;
46: BEGIN
47: OPEN csr_get_mapping_component_id;
48: FETCH csr_get_mapping_component_id INTO l_mapping_component_id;
49: CLOSE csr_get_mapping_component_id;

Line 113: l_mapping_component_id hxc_mapping_components.mapping_component_id%TYPE;

109: , p_reference_object IN VARCHAR2
110: , p_owner IN VARCHAR2
111: , p_custom_mode IN VARCHAR2 ) IS
112: l_alias_type_id hxc_alias_types.alias_type_id%TYPE;
113: l_mapping_component_id hxc_mapping_components.mapping_component_id%TYPE;
114: l_alias_type_component_id hxc_alias_type_components.alias_type_component_id%TYPE;
115: l_component_name hxc_alias_type_components.component_name%TYPE;
116: l_component_type hxc_alias_type_components.component_type%TYPE;
117: l_ovn hxc_alias_type_components.object_version_number%TYPE;