APPS.HXC_TIMECARD dependencies on HXC_BLOCK_TABLE_TYPE

Line 9: g_deposit_blocks hxc_block_table_type;

5:
6: attribute_id_list attribute_list;
7:
8: g_package varchar2(12) := 'HXC_TIMECARD';
9: g_deposit_blocks hxc_block_table_type;
10: g_deposit_attributes hxc_attribute_table_type;
11: g_audit_messages hxc_message_table_type;
12:
13: Procedure alias_translation

Line 14: (p_blocks in HXC_BLOCK_TABLE_TYPE

10: g_deposit_attributes hxc_attribute_table_type;
11: g_audit_messages hxc_message_table_type;
12:
13: Procedure alias_translation
14: (p_blocks in HXC_BLOCK_TABLE_TYPE
15: ,p_attributes in out nocopy HXC_ATTRIBUTE_TABLE_TYPE
16: ,p_messages in out nocopy HXC_MESSAGE_TABLE_TYPE
17: ) is
18:

Line 36: (p_blocks in out nocopy HXC_BLOCK_TABLE_TYPE

32:
33: End alias_translation;
34:
35: Procedure save_timecard
36: (p_blocks in out nocopy HXC_BLOCK_TABLE_TYPE
37: ,p_attributes in out nocopy HXC_ATTRIBUTE_TABLE_TYPE
38: ,p_timecard_props in HXC_TIMECARD_PROP_TABLE_TYPE
39: ,p_messages in out nocopy HXC_MESSAGE_TABLE_TYPE
40: ,p_timecard_id out nocopy hxc_time_building_blocks.time_building_block_id%type

Line 242: ,p_blocks in HXC_BLOCK_TABLE_TYPE

238: End save_timecard;
239:
240: Procedure deposit_controller
241: (p_validate in varchar2
242: ,p_blocks in HXC_BLOCK_TABLE_TYPE
243: ,p_attributes in HXC_ATTRIBUTE_TABLE_TYPE
244: ,p_messages in out nocopy HXC_MESSAGE_TABLE_TYPE
245: ,p_deposit_mode in VARCHAR2
246: ,p_template in VARCHAR2

Line 258: l_blocks hxc_block_table_type;

254: l_timecard_blocks hxc_timecard.block_list;
255: l_day_blocks hxc_timecard.block_list;
256: l_detail_blocks hxc_timecard.block_list;
257: l_attributes hxc_attribute_table_type;
258: l_blocks hxc_block_table_type;
259: l_transaction_info hxc_timecard.transaction_info;
260: l_timecard_props hxc_timecard_prop_table_type;
261: l_proc varchar2(33) := g_package||'.DEPOSIT_CONTROLLER';
262: l_can_deposit boolean := true;

Line 932: ,p_blocks in hxc_block_table_type

928: END deposit_controller;
929:
930: Procedure create_timecard
931: (p_validate in varchar2
932: ,p_blocks in hxc_block_table_type
933: ,p_attributes in hxc_attribute_table_type
934: ,p_deposit_mode in varchar2
935: ,p_template in varchar2
936: ,p_item_type in wf_items.item_type%type

Line 1088: ) return hxc_block_table_type is

1084: Function load_blocks
1085: (p_timecard_id in hxc_time_building_blocks.time_building_block_id%type
1086: ,p_timecard_ovn in hxc_time_building_blocks.object_version_number%type
1087: ,p_load_mode in varchar2 default c_nondelete
1088: ) return hxc_block_table_type is
1089:
1090: cursor c_blocks
1091: (p_tc_id in hxc_time_building_blocks.time_building_block_id%type
1092: ) is

Line 1101: l_blocks hxc_block_table_type := hxc_block_table_type();

1097: start with (tbb.time_building_block_id = p_tc_id)
1098: connect by prior tbb.time_building_block_id = tbb.parent_building_block_id
1099: and prior tbb.object_version_number = tbb.parent_building_block_ovn;
1100:
1101: l_blocks hxc_block_table_type := hxc_block_table_type();
1102: l_block_count number := 1;
1103:
1104:
1105: Begin

Line 1128: (p_blocks in hxc_block_table_type)

1124:
1125: End load_blocks;
1126:
1127: Function load_attributes
1128: (p_blocks in hxc_block_table_type)
1129: return hxc_attribute_table_type is
1130:
1131: cursor c_attributes
1132: (p_building_block_id in hxc_time_building_blocks.time_building_block_id%type

Line 1259: l_blocks hxc_block_table_type := hxc_block_table_type();

1255: from hxc_time_building_blocks tbb
1256: where tbb.time_building_block_id = p_timecard_id
1257: and tbb.date_to = hr_general.end_of_time;
1258:
1259: l_blocks hxc_block_table_type := hxc_block_table_type();
1260: l_attributes hxc_attribute_table_type := hxc_attribute_table_type();
1261: l_messages hxc_message_table_type := hxc_message_table_type();
1262:
1263: l_timecard_blocks hxc_timecard.block_list;