DBA Data[Home] [Help]

APPS.HXC_MCU_UPLOAD_PKG dependencies on HXC_MAPPING_COMPONENTS

Line 27: FROM hxc_mapping_components

23: FUNCTION get_mapping_component_id ( p_name IN VARCHAR2 ) RETURN NUMBER IS
24:
25: CURSOR csr_get_mapping_component_id IS
26: SELECT mapping_component_id
27: FROM hxc_mapping_components
28: WHERE name = p_name;
29:
30: l_mapping_component_id hxc_mapping_components.mapping_component_id%TYPE;
31:

Line 30: l_mapping_component_id hxc_mapping_components.mapping_component_id%TYPE;

26: SELECT mapping_component_id
27: FROM hxc_mapping_components
28: WHERE name = p_name;
29:
30: l_mapping_component_id hxc_mapping_components.mapping_component_id%TYPE;
31:
32: BEGIN
33:
34: OPEN csr_get_mapping_component_id;

Line 50: l_mapping_component_id hxc_mapping_components.mapping_component_id%TYPE;

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);
54:

Line 68: , hxc_mapping_components mpc

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;
72: