3:
4: g_debug boolean := hr_utility.debug_enabled;
5:
6: Procedure add_transaction_info
7: (p_time_building_block_id in hxc_time_building_blocks.time_building_block_id%type
8: ,p_object_version_number in hxc_time_building_blocks.object_version_number%type
9: ,p_exception_desc in varchar2
10: ,p_transaction_info in out nocopy hxc_timecard.transaction_info
11: ,p_messages in out nocopy hxc_message_table_type
4: g_debug boolean := hr_utility.debug_enabled;
5:
6: Procedure add_transaction_info
7: (p_time_building_block_id in hxc_time_building_blocks.time_building_block_id%type
8: ,p_object_version_number in hxc_time_building_blocks.object_version_number%type
9: ,p_exception_desc in varchar2
10: ,p_transaction_info in out nocopy hxc_timecard.transaction_info
11: ,p_messages in out nocopy hxc_message_table_type
12: ) is
53:
54: Procedure deposit_error
55: (p_messages in out nocopy hxc_message_table_type
56: ,p_transaction_info in out nocopy hxc_timecard.transaction_info
57: ,p_time_building_block_id in hxc_time_building_blocks.time_building_block_id%type
58: ,p_time_building_block_ovn in hxc_time_building_blocks.object_version_number%type
59: ) is
60:
61: l_exception_desc varchar2(2000);
54: Procedure deposit_error
55: (p_messages in out nocopy hxc_message_table_type
56: ,p_transaction_info in out nocopy hxc_timecard.transaction_info
57: ,p_time_building_block_id in hxc_time_building_blocks.time_building_block_id%type
58: ,p_time_building_block_ovn in hxc_time_building_blocks.object_version_number%type
59: ) is
60:
61: l_exception_desc varchar2(2000);
62:
204: End set_child_process;
205:
206: Procedure maintain_error_table
207: (p_messages in out nocopy hxc_message_table_type
208: ,p_old_ta_id in hxc_time_building_blocks.time_building_block_id%type
209: ,p_old_ta_ovn in hxc_time_building_blocks.object_version_number%type
210: ,p_new_ta_id in hxc_time_building_blocks.time_building_block_id%type
211: ,p_new_ta_ovn in hxc_time_building_blocks.object_version_number%type
212: ,p_timecard_id in hxc_time_building_blocks.time_building_block_id%type
205:
206: Procedure maintain_error_table
207: (p_messages in out nocopy hxc_message_table_type
208: ,p_old_ta_id in hxc_time_building_blocks.time_building_block_id%type
209: ,p_old_ta_ovn in hxc_time_building_blocks.object_version_number%type
210: ,p_new_ta_id in hxc_time_building_blocks.time_building_block_id%type
211: ,p_new_ta_ovn in hxc_time_building_blocks.object_version_number%type
212: ,p_timecard_id in hxc_time_building_blocks.time_building_block_id%type
213: ,p_timecard_ovn in hxc_time_building_blocks.object_version_number%type
206: Procedure maintain_error_table
207: (p_messages in out nocopy hxc_message_table_type
208: ,p_old_ta_id in hxc_time_building_blocks.time_building_block_id%type
209: ,p_old_ta_ovn in hxc_time_building_blocks.object_version_number%type
210: ,p_new_ta_id in hxc_time_building_blocks.time_building_block_id%type
211: ,p_new_ta_ovn in hxc_time_building_blocks.object_version_number%type
212: ,p_timecard_id in hxc_time_building_blocks.time_building_block_id%type
213: ,p_timecard_ovn in hxc_time_building_blocks.object_version_number%type
214: ) is
207: (p_messages in out nocopy hxc_message_table_type
208: ,p_old_ta_id in hxc_time_building_blocks.time_building_block_id%type
209: ,p_old_ta_ovn in hxc_time_building_blocks.object_version_number%type
210: ,p_new_ta_id in hxc_time_building_blocks.time_building_block_id%type
211: ,p_new_ta_ovn in hxc_time_building_blocks.object_version_number%type
212: ,p_timecard_id in hxc_time_building_blocks.time_building_block_id%type
213: ,p_timecard_ovn in hxc_time_building_blocks.object_version_number%type
214: ) is
215:
208: ,p_old_ta_id in hxc_time_building_blocks.time_building_block_id%type
209: ,p_old_ta_ovn in hxc_time_building_blocks.object_version_number%type
210: ,p_new_ta_id in hxc_time_building_blocks.time_building_block_id%type
211: ,p_new_ta_ovn in hxc_time_building_blocks.object_version_number%type
212: ,p_timecard_id in hxc_time_building_blocks.time_building_block_id%type
213: ,p_timecard_ovn in hxc_time_building_blocks.object_version_number%type
214: ) is
215:
216: l_index number;
209: ,p_old_ta_ovn in hxc_time_building_blocks.object_version_number%type
210: ,p_new_ta_id in hxc_time_building_blocks.time_building_block_id%type
211: ,p_new_ta_ovn in hxc_time_building_blocks.object_version_number%type
212: ,p_timecard_id in hxc_time_building_blocks.time_building_block_id%type
213: ,p_timecard_ovn in hxc_time_building_blocks.object_version_number%type
214: ) is
215:
216: l_index number;
217:
239: End maintain_error_table;
240:
241: Procedure maintain_error_table
242: (p_messages in out nocopy hxc_message_table_type
243: ,p_old_bb_id in hxc_time_building_blocks.time_building_block_id%type
244: ,p_old_bb_ovn in hxc_time_building_blocks.object_version_number%type
245: ,p_new_bb_id in hxc_time_building_blocks.time_building_block_id%type
246: ,p_new_bb_ovn in hxc_time_building_blocks.object_version_number%type
247: ,p_timecard_id in hxc_time_building_blocks.time_building_block_id%type
240:
241: Procedure maintain_error_table
242: (p_messages in out nocopy hxc_message_table_type
243: ,p_old_bb_id in hxc_time_building_blocks.time_building_block_id%type
244: ,p_old_bb_ovn in hxc_time_building_blocks.object_version_number%type
245: ,p_new_bb_id in hxc_time_building_blocks.time_building_block_id%type
246: ,p_new_bb_ovn in hxc_time_building_blocks.object_version_number%type
247: ,p_timecard_id in hxc_time_building_blocks.time_building_block_id%type
248: ,p_timecard_ovn in hxc_time_building_blocks.object_version_number%type
241: Procedure maintain_error_table
242: (p_messages in out nocopy hxc_message_table_type
243: ,p_old_bb_id in hxc_time_building_blocks.time_building_block_id%type
244: ,p_old_bb_ovn in hxc_time_building_blocks.object_version_number%type
245: ,p_new_bb_id in hxc_time_building_blocks.time_building_block_id%type
246: ,p_new_bb_ovn in hxc_time_building_blocks.object_version_number%type
247: ,p_timecard_id in hxc_time_building_blocks.time_building_block_id%type
248: ,p_timecard_ovn in hxc_time_building_blocks.object_version_number%type
249: ) is
242: (p_messages in out nocopy hxc_message_table_type
243: ,p_old_bb_id in hxc_time_building_blocks.time_building_block_id%type
244: ,p_old_bb_ovn in hxc_time_building_blocks.object_version_number%type
245: ,p_new_bb_id in hxc_time_building_blocks.time_building_block_id%type
246: ,p_new_bb_ovn in hxc_time_building_blocks.object_version_number%type
247: ,p_timecard_id in hxc_time_building_blocks.time_building_block_id%type
248: ,p_timecard_ovn in hxc_time_building_blocks.object_version_number%type
249: ) is
250:
243: ,p_old_bb_id in hxc_time_building_blocks.time_building_block_id%type
244: ,p_old_bb_ovn in hxc_time_building_blocks.object_version_number%type
245: ,p_new_bb_id in hxc_time_building_blocks.time_building_block_id%type
246: ,p_new_bb_ovn in hxc_time_building_blocks.object_version_number%type
247: ,p_timecard_id in hxc_time_building_blocks.time_building_block_id%type
248: ,p_timecard_ovn in hxc_time_building_blocks.object_version_number%type
249: ) is
250:
251: l_index number;
244: ,p_old_bb_ovn in hxc_time_building_blocks.object_version_number%type
245: ,p_new_bb_id in hxc_time_building_blocks.time_building_block_id%type
246: ,p_new_bb_ovn in hxc_time_building_blocks.object_version_number%type
247: ,p_timecard_id in hxc_time_building_blocks.time_building_block_id%type
248: ,p_timecard_ovn in hxc_time_building_blocks.object_version_number%type
249: ) is
250:
251: l_index number;
252:
275: (p_blocks in out nocopy hxc_block_table_type
276: ,p_attributes in out nocopy hxc_attribute_table_type
277: ,p_messages in out nocopy hxc_message_table_type
278: ,p_block_list in hxc_timecard.block_list
279: ,l_old_bb_id in hxc_time_building_blocks.time_building_block_id%type
280: ,l_old_ovn in hxc_time_building_blocks.object_version_number%type
281: ,l_new_bb_id in hxc_time_building_blocks.time_building_block_id%type
282: ,l_new_ovn in hxc_time_building_blocks.object_version_number%type
283: ,p_timecard_id in hxc_time_building_blocks.time_building_block_id%type
276: ,p_attributes in out nocopy hxc_attribute_table_type
277: ,p_messages in out nocopy hxc_message_table_type
278: ,p_block_list in hxc_timecard.block_list
279: ,l_old_bb_id in hxc_time_building_blocks.time_building_block_id%type
280: ,l_old_ovn in hxc_time_building_blocks.object_version_number%type
281: ,l_new_bb_id in hxc_time_building_blocks.time_building_block_id%type
282: ,l_new_ovn in hxc_time_building_blocks.object_version_number%type
283: ,p_timecard_id in hxc_time_building_blocks.time_building_block_id%type
284: ,p_timecard_ovn in hxc_time_building_blocks.object_version_number%type
277: ,p_messages in out nocopy hxc_message_table_type
278: ,p_block_list in hxc_timecard.block_list
279: ,l_old_bb_id in hxc_time_building_blocks.time_building_block_id%type
280: ,l_old_ovn in hxc_time_building_blocks.object_version_number%type
281: ,l_new_bb_id in hxc_time_building_blocks.time_building_block_id%type
282: ,l_new_ovn in hxc_time_building_blocks.object_version_number%type
283: ,p_timecard_id in hxc_time_building_blocks.time_building_block_id%type
284: ,p_timecard_ovn in hxc_time_building_blocks.object_version_number%type
285: ) is
278: ,p_block_list in hxc_timecard.block_list
279: ,l_old_bb_id in hxc_time_building_blocks.time_building_block_id%type
280: ,l_old_ovn in hxc_time_building_blocks.object_version_number%type
281: ,l_new_bb_id in hxc_time_building_blocks.time_building_block_id%type
282: ,l_new_ovn in hxc_time_building_blocks.object_version_number%type
283: ,p_timecard_id in hxc_time_building_blocks.time_building_block_id%type
284: ,p_timecard_ovn in hxc_time_building_blocks.object_version_number%type
285: ) is
286:
279: ,l_old_bb_id in hxc_time_building_blocks.time_building_block_id%type
280: ,l_old_ovn in hxc_time_building_blocks.object_version_number%type
281: ,l_new_bb_id in hxc_time_building_blocks.time_building_block_id%type
282: ,l_new_ovn in hxc_time_building_blocks.object_version_number%type
283: ,p_timecard_id in hxc_time_building_blocks.time_building_block_id%type
284: ,p_timecard_ovn in hxc_time_building_blocks.object_version_number%type
285: ) is
286:
287: l_parent_chk pls_integer;
280: ,l_old_ovn in hxc_time_building_blocks.object_version_number%type
281: ,l_new_bb_id in hxc_time_building_blocks.time_building_block_id%type
282: ,l_new_ovn in hxc_time_building_blocks.object_version_number%type
283: ,p_timecard_id in hxc_time_building_blocks.time_building_block_id%type
284: ,p_timecard_ovn in hxc_time_building_blocks.object_version_number%type
285: ) is
286:
287: l_parent_chk pls_integer;
288: l_index number;
387: ,p_transaction_info in out nocopy hxc_timecard.transaction_info
388: ,p_messages in out nocopy hxc_message_table_type
389: ) is
390:
391: l_object_version_number HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE;
392: l_time_building_block_id HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE := null;
393:
394: Begin
395:
388: ,p_messages in out nocopy hxc_message_table_type
389: ) is
390:
391: l_object_version_number HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE;
392: l_time_building_block_id HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE := null;
393:
394: Begin
395:
396: p_old_bb_id := p_block.time_building_block_id;
457: p_transaction_info in out nocopy hxc_timecard.transaction_info,
458: p_messages in out nocopy hxc_message_table_type
459: ) is
460:
461: l_object_version_number hxc_time_building_blocks.object_version_number%type;
462:
463: Begin
464: --
465: -- Keep the old ovn for future use
556:
557: l_index NUMBER;
558: l_block HXC_BLOCK_TYPE;
559:
560: l_new_bb_id hxc_time_building_blocks.time_building_block_id%type;
561: l_old_bb_id hxc_time_building_blocks.time_building_block_id%type;
562: l_new_ovn hxc_time_building_blocks.object_version_number%type;
563: l_old_ovn hxc_time_building_blocks.object_version_number%type;
564:
557: l_index NUMBER;
558: l_block HXC_BLOCK_TYPE;
559:
560: l_new_bb_id hxc_time_building_blocks.time_building_block_id%type;
561: l_old_bb_id hxc_time_building_blocks.time_building_block_id%type;
562: l_new_ovn hxc_time_building_blocks.object_version_number%type;
563: l_old_ovn hxc_time_building_blocks.object_version_number%type;
564:
565: Begin
558: l_block HXC_BLOCK_TYPE;
559:
560: l_new_bb_id hxc_time_building_blocks.time_building_block_id%type;
561: l_old_bb_id hxc_time_building_blocks.time_building_block_id%type;
562: l_new_ovn hxc_time_building_blocks.object_version_number%type;
563: l_old_ovn hxc_time_building_blocks.object_version_number%type;
564:
565: Begin
566:
559:
560: l_new_bb_id hxc_time_building_blocks.time_building_block_id%type;
561: l_old_bb_id hxc_time_building_blocks.time_building_block_id%type;
562: l_new_ovn hxc_time_building_blocks.object_version_number%type;
563: l_old_ovn hxc_time_building_blocks.object_version_number%type;
564:
565: Begin
566:
567: l_index := p_timecard_blocks.first;
633:
634: l_index NUMBER;
635: l_block HXC_BLOCK_TYPE;
636:
637: l_new_bb_id hxc_time_building_blocks.time_building_block_id%type;
638: l_old_bb_id hxc_time_building_blocks.time_building_block_id%type;
639: l_new_ovn hxc_time_building_blocks.object_version_number%type;
640: l_old_ovn hxc_time_building_blocks.object_version_number%type;
641:
634: l_index NUMBER;
635: l_block HXC_BLOCK_TYPE;
636:
637: l_new_bb_id hxc_time_building_blocks.time_building_block_id%type;
638: l_old_bb_id hxc_time_building_blocks.time_building_block_id%type;
639: l_new_ovn hxc_time_building_blocks.object_version_number%type;
640: l_old_ovn hxc_time_building_blocks.object_version_number%type;
641:
642: Begin
635: l_block HXC_BLOCK_TYPE;
636:
637: l_new_bb_id hxc_time_building_blocks.time_building_block_id%type;
638: l_old_bb_id hxc_time_building_blocks.time_building_block_id%type;
639: l_new_ovn hxc_time_building_blocks.object_version_number%type;
640: l_old_ovn hxc_time_building_blocks.object_version_number%type;
641:
642: Begin
643:
636:
637: l_new_bb_id hxc_time_building_blocks.time_building_block_id%type;
638: l_old_bb_id hxc_time_building_blocks.time_building_block_id%type;
639: l_new_ovn hxc_time_building_blocks.object_version_number%type;
640: l_old_ovn hxc_time_building_blocks.object_version_number%type;
641:
642: Begin
643:
644: l_index := p_day_blocks.first;
1023: l_index NUMBER;
1024: l_block HXC_BLOCK_TYPE;
1025: l_list hxc_timecard.block_list;
1026:
1027: l_new_bb_id hxc_time_building_blocks.time_building_block_id%type;
1028: l_old_bb_id hxc_time_building_blocks.time_building_block_id%type;
1029: l_new_ovn hxc_time_building_blocks.object_version_number%type;
1030: l_old_ovn hxc_time_building_blocks.object_version_number%type;
1031:
1024: l_block HXC_BLOCK_TYPE;
1025: l_list hxc_timecard.block_list;
1026:
1027: l_new_bb_id hxc_time_building_blocks.time_building_block_id%type;
1028: l_old_bb_id hxc_time_building_blocks.time_building_block_id%type;
1029: l_new_ovn hxc_time_building_blocks.object_version_number%type;
1030: l_old_ovn hxc_time_building_blocks.object_version_number%type;
1031:
1032: l_duplicate_block BOOLEAN := false;
1025: l_list hxc_timecard.block_list;
1026:
1027: l_new_bb_id hxc_time_building_blocks.time_building_block_id%type;
1028: l_old_bb_id hxc_time_building_blocks.time_building_block_id%type;
1029: l_new_ovn hxc_time_building_blocks.object_version_number%type;
1030: l_old_ovn hxc_time_building_blocks.object_version_number%type;
1031:
1032: l_duplicate_block BOOLEAN := false;
1033: l_overlapping_block BOOLEAN := false;
1026:
1027: l_new_bb_id hxc_time_building_blocks.time_building_block_id%type;
1028: l_old_bb_id hxc_time_building_blocks.time_building_block_id%type;
1029: l_new_ovn hxc_time_building_blocks.object_version_number%type;
1030: l_old_ovn hxc_time_building_blocks.object_version_number%type;
1031:
1032: l_duplicate_block BOOLEAN := false;
1033: l_overlapping_block BOOLEAN := false;
1034:
1289:
1290: Procedure deposit_attributes
1291: (p_attributes in out nocopy hxc_attribute_table_type,
1292: p_messages in out nocopy hxc_message_table_type,
1293: p_timecard_id in hxc_time_building_blocks.time_building_block_id%type,
1294: p_timecard_ovn in hxc_time_building_blocks.object_version_number%type,
1295: p_deleted_blocks in out nocopy hxc_timecard.block_list,
1296: p_blocks in out nocopy hxc_block_table_type,
1297: p_transaction_info in out nocopy hxc_timecard.transaction_info
1290: Procedure deposit_attributes
1291: (p_attributes in out nocopy hxc_attribute_table_type,
1292: p_messages in out nocopy hxc_message_table_type,
1293: p_timecard_id in hxc_time_building_blocks.time_building_block_id%type,
1294: p_timecard_ovn in hxc_time_building_blocks.object_version_number%type,
1295: p_deleted_blocks in out nocopy hxc_timecard.block_list,
1296: p_blocks in out nocopy hxc_block_table_type,
1297: p_transaction_info in out nocopy hxc_timecard.transaction_info
1298: ) is
1323: l_timecard_id number;
1324: l_timecard_ovn number;
1325: l_block_updated number := -999;
1326:
1327: l_new_bb_id hxc_time_building_blocks.time_building_block_id%type;
1328: l_old_bb_id hxc_time_building_blocks.time_building_block_id%type;
1329: l_updated_blocks hxc_timecard.block_list;
1330: l_local_index number;
1331:
1324: l_timecard_ovn number;
1325: l_block_updated number := -999;
1326:
1327: l_new_bb_id hxc_time_building_blocks.time_building_block_id%type;
1328: l_old_bb_id hxc_time_building_blocks.time_building_block_id%type;
1329: l_updated_blocks hxc_timecard.block_list;
1330: l_local_index number;
1331:
1332: Begin
1554: is
1555:
1556: cursor c_get_data_set_id(p_tbb_id number,p_tbb_ovn number) is
1557: select data_set_id
1558: from hxc_time_building_blocks
1559: where time_building_block_id = p_tbb_id
1560: and object_version_number = p_tbb_ovn;
1561:
1562: l_data_set_id hxc_transaction_details.data_set_id%TYPE;
1593: p_messages in out nocopy hxc_message_table_type,
1594: p_transaction_info in out nocopy hxc_timecard.transaction_info
1595: ) is
1596:
1597: l_timecard_id hxc_time_building_blocks.time_building_block_id%type;
1598: l_timecard_ovn hxc_time_building_blocks.object_version_number%type;
1599:
1600: l_deleted_blocks hxc_timecard.block_list;
1601: l_dummy boolean;
1594: p_transaction_info in out nocopy hxc_timecard.transaction_info
1595: ) is
1596:
1597: l_timecard_id hxc_time_building_blocks.time_building_block_id%type;
1598: l_timecard_ovn hxc_time_building_blocks.object_version_number%type;
1599:
1600: l_deleted_blocks hxc_timecard.block_list;
1601: l_dummy boolean;
1602: