APPS.HXC_TIMECARD_ATTRIBUTE_UTILS dependencies on HXC_BLD_BLK_INFO_TYPES

Line 7: type bld_blk_info_type_ids is table of hxc_bld_blk_info_types.bld_blk_info_type%type index by binary_integer;

3:
4: g_debug boolean := hr_utility.debug_enabled;
5:
6: type attribute_index is table of hxc_time_attributes.time_attribute_id%type index by binary_integer;
7: type bld_blk_info_type_ids is table of hxc_bld_blk_info_types.bld_blk_info_type%type index by binary_integer;
8:
9: g_bld_blk_info_type_ids bld_blk_info_type_ids;
10:
11: g_package varchar2(30) := 'hxc_timecard_attribute_utils';

Line 53: from hxc_bld_blk_info_types

49: return varchar2 is
50:
51: cursor get_info_type(p_info_type_id in number) is
52: select bld_blk_info_type
53: from hxc_bld_blk_info_types
54: where bld_blk_info_type_id = p_info_type_id;
55:
56: l_info_type HXC_BLD_BLK_INFO_TYPES.BLD_BLK_INFO_TYPE%TYPE;
57:

Line 56: l_info_type HXC_BLD_BLK_INFO_TYPES.BLD_BLK_INFO_TYPE%TYPE;

52: select bld_blk_info_type
53: from hxc_bld_blk_info_types
54: where bld_blk_info_type_id = p_info_type_id;
55:
56: l_info_type HXC_BLD_BLK_INFO_TYPES.BLD_BLK_INFO_TYPE%TYPE;
57:
58: Begin
59:
60: --

Line 87: from hxc_bld_blk_info_types

83: RETURN number is
84:
85: cursor csr_get_bld_blk_info_type_id IS
86: select bld_blk_info_type_id
87: from hxc_bld_blk_info_types
88: where bld_blk_info_type = p_info_type;
89:
90: l_index NUMBER;
91: l_info_type_id hxc_bld_blk_info_types.bld_blk_info_type_id%type := NULL;

Line 91: l_info_type_id hxc_bld_blk_info_types.bld_blk_info_type_id%type := NULL;

87: from hxc_bld_blk_info_types
88: where bld_blk_info_type = p_info_type;
89:
90: l_index NUMBER;
91: l_info_type_id hxc_bld_blk_info_types.bld_blk_info_type_id%type := NULL;
92:
93: BEGIN
94: --
95: -- Check to see if we've cache the bld blk info type already