APPS.HXC_TIMECARD_DEPOSIT_COMMON dependencies on HXC_BLOCK_TABLE_TYPE

Line 11: (p_blocks in out nocopy HXC_BLOCK_TABLE_TYPE

7: Alias Translator Procedure
8: This procedure....
9: ***************************************************************************/
10: Procedure alias_translation
11: (p_blocks in out nocopy HXC_BLOCK_TABLE_TYPE
12: ,p_attributes in out nocopy HXC_ATTRIBUTE_TABLE_TYPE
13: ,p_messages in out nocopy HXC_MESSAGE_TABLE_TYPE
14: ) is
15:

Line 39: ,p_blocks in out nocopy hxc_block_table_type

35: ***************************************************************************/
36: /*
37: Procedure validate_setup
38: (p_deposit_mode in varchar2
39: ,p_blocks in out nocopy hxc_block_table_type
40: ,p_attributes in out nocopy hxc_attribute_table_type
41: ,p_messages in out nocopy hxc_message_table_type
42: ) is
43:

Line 109: ) return hxc_block_table_type is

105: ***************************************************************************/
106: Function load_blocks
107: (p_timecard_id in out nocopy hxc_time_building_blocks.time_building_block_id%type
108: ,p_timecard_ovn in out nocopy hxc_time_building_blocks.object_version_number%type
109: ) return hxc_block_table_type is
110:
111: cursor c_blocks
112: (p_tc_id in hxc_time_building_blocks.time_building_block_id%type
113: ) is

Line 122: l_blocks hxc_block_table_type := hxc_block_table_type();

118: start with (tbb.time_building_block_id = p_tc_id)
119: connect by prior tbb.time_building_block_id = tbb.parent_building_block_id
120: and prior tbb.object_version_number = tbb.parent_building_block_ovn;
121:
122: l_blocks hxc_block_table_type := hxc_block_table_type();
123: l_block_count number := 1;
124:
125:
126: Begin

Line 150: (p_blocks in out nocopy hxc_block_table_type)

146: Load Attribures Procedure
147: This procedure....
148: ***************************************************************************/
149: Function load_attributes
150: (p_blocks in out nocopy hxc_block_table_type)
151: return hxc_attribute_table_type is
152:
153: cursor c_attributes
154: (p_building_block_id in hxc_time_building_blocks.time_building_block_id%type

Line 207: l_blocks hxc_block_table_type := hxc_block_table_type();

203: from hxc_time_building_blocks tbb
204: where tbb.time_building_block_id = p_timecard_id
205: and tbb.date_to = hr_general.end_of_time;
206:
207: l_blocks hxc_block_table_type := hxc_block_table_type();
208: l_attributes hxc_attribute_table_type := hxc_attribute_table_type();
209: l_messages hxc_message_table_type := hxc_message_table_type();
210:
211: l_timecard_blocks hxc_timecard.block_list;