APPS.HXC_MPC_UPLOAD_PKG dependencies on HXC_BLD_BLK_INFO_TYPES

Line 8: FROM hxc_bld_blk_info_types

4: FUNCTION find_bld_blk_info_type_id ( p_bld_Blk_info_type VARCHAR2 ) RETURN number IS
5:
6: CURSOR csr_get_bld_blk_info_type_id IS
7: SELECT bld_blk_info_type_id
8: FROM hxc_bld_blk_info_types
9: WHERE bld_blk_info_type = p_bld_blk_info_type;
10:
11: l_bld_blk_info_type_id hxc_bld_blk_info_types.bld_blk_info_type_id%TYPE;
12:

Line 11: l_bld_blk_info_type_id hxc_bld_blk_info_types.bld_blk_info_type_id%TYPE;

7: SELECT bld_blk_info_type_id
8: FROM hxc_bld_blk_info_types
9: WHERE bld_blk_info_type = p_bld_blk_info_type;
10:
11: l_bld_blk_info_type_id hxc_bld_blk_info_types.bld_blk_info_type_id%TYPE;
12:
13: BEGIN
14:
15: OPEN csr_get_bld_blk_info_type_id;

Line 32: l_bld_blk_info_type_id hxc_bld_blk_info_types.bld_blk_info_type_id%TYPE;

28: , p_segment IN VARCHAR2
29: , p_owner IN VARCHAR2
30: , p_custom_mode IN VARCHAR2 ) IS
31:
32: l_bld_blk_info_type_id hxc_bld_blk_info_types.bld_blk_info_type_id%TYPE;
33: l_bld_blk_info_type hxc_bld_blk_info_types.bld_blk_info_type%TYPE;
34: l_segment hxc_mapping_components.segment%TYPE;
35: l_field_name hxc_mapping_components.field_name%TYPE;
36: l_mapping_component_id hxc_mapping_components.mapping_component_id%TYPE;

Line 33: l_bld_blk_info_type hxc_bld_blk_info_types.bld_blk_info_type%TYPE;

29: , p_owner IN VARCHAR2
30: , p_custom_mode IN VARCHAR2 ) IS
31:
32: l_bld_blk_info_type_id hxc_bld_blk_info_types.bld_blk_info_type_id%TYPE;
33: l_bld_blk_info_type hxc_bld_blk_info_types.bld_blk_info_type%TYPE;
34: l_segment hxc_mapping_components.segment%TYPE;
35: l_field_name hxc_mapping_components.field_name%TYPE;
36: l_mapping_component_id hxc_mapping_components.mapping_component_id%TYPE;
37: l_ovn hxc_mapping_components.object_version_number%TYPE;