APPS.HXC_TIMECARD_ATTRIBUTE_UTILS dependencies on HXC_BLD_BLK_INFO_TYPES

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

1: PACKAGE BODY hxc_timecard_attribute_utils AS
2: /* $Header: hxctcatut.pkb 115.4 2004/01/02 16:32:48 arundell noship $ */
3:
4: type attribute_index is table of hxc_time_attributes.time_attribute_id%type index by binary_integer;
5: type bld_blk_info_type_ids is table of hxc_bld_blk_info_types.bld_blk_info_type%type index by binary_integer;
6:
7: g_bld_blk_info_type_ids bld_blk_info_type_ids;
8:
9: g_package varchar2(30) := 'hxc_timecard_attribute_utils';

Line 51: from hxc_bld_blk_info_types

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

Line 54: l_info_type HXC_BLD_BLK_INFO_TYPES.BLD_BLK_INFO_TYPE%TYPE;

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

Line 85: from hxc_bld_blk_info_types

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

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

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