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;
760: l_index NUMBER;
761: l_block HXC_BLOCK_TYPE;
762: l_list hxc_timecard.block_list;
763:
764: l_new_bb_id hxc_time_building_blocks.time_building_block_id%type;
765: l_old_bb_id hxc_time_building_blocks.time_building_block_id%type;
766: l_new_ovn hxc_time_building_blocks.object_version_number%type;
767: l_old_ovn hxc_time_building_blocks.object_version_number%type;
768:
761: l_block HXC_BLOCK_TYPE;
762: l_list hxc_timecard.block_list;
763:
764: l_new_bb_id hxc_time_building_blocks.time_building_block_id%type;
765: l_old_bb_id hxc_time_building_blocks.time_building_block_id%type;
766: l_new_ovn hxc_time_building_blocks.object_version_number%type;
767: l_old_ovn hxc_time_building_blocks.object_version_number%type;
768:
769: l_duplicate_block BOOLEAN := false;
762: l_list hxc_timecard.block_list;
763:
764: l_new_bb_id hxc_time_building_blocks.time_building_block_id%type;
765: l_old_bb_id hxc_time_building_blocks.time_building_block_id%type;
766: l_new_ovn hxc_time_building_blocks.object_version_number%type;
767: l_old_ovn hxc_time_building_blocks.object_version_number%type;
768:
769: l_duplicate_block BOOLEAN := false;
770:
763:
764: l_new_bb_id hxc_time_building_blocks.time_building_block_id%type;
765: l_old_bb_id hxc_time_building_blocks.time_building_block_id%type;
766: l_new_ovn hxc_time_building_blocks.object_version_number%type;
767: l_old_ovn hxc_time_building_blocks.object_version_number%type;
768:
769: l_duplicate_block BOOLEAN := false;
770:
771: Begin
928:
929: Procedure deposit_attributes
930: (p_attributes in out nocopy hxc_attribute_table_type,
931: p_messages in out nocopy hxc_message_table_type,
932: p_timecard_id in hxc_time_building_blocks.time_building_block_id%type,
933: p_timecard_ovn in hxc_time_building_blocks.object_version_number%type,
934: p_deleted_blocks in out nocopy hxc_timecard.block_list,
935: p_blocks in out nocopy hxc_block_table_type,
936: p_transaction_info in out nocopy hxc_timecard.transaction_info
929: Procedure deposit_attributes
930: (p_attributes in out nocopy hxc_attribute_table_type,
931: p_messages in out nocopy hxc_message_table_type,
932: p_timecard_id in hxc_time_building_blocks.time_building_block_id%type,
933: p_timecard_ovn in hxc_time_building_blocks.object_version_number%type,
934: p_deleted_blocks in out nocopy hxc_timecard.block_list,
935: p_blocks in out nocopy hxc_block_table_type,
936: p_transaction_info in out nocopy hxc_timecard.transaction_info
937: ) is
962: l_timecard_id number;
963: l_timecard_ovn number;
964: l_block_updated number := -999;
965:
966: l_new_bb_id hxc_time_building_blocks.time_building_block_id%type;
967: l_old_bb_id hxc_time_building_blocks.time_building_block_id%type;
968: l_updated_blocks hxc_timecard.block_list;
969: l_local_index number;
970:
963: l_timecard_ovn number;
964: l_block_updated number := -999;
965:
966: l_new_bb_id hxc_time_building_blocks.time_building_block_id%type;
967: l_old_bb_id hxc_time_building_blocks.time_building_block_id%type;
968: l_updated_blocks hxc_timecard.block_list;
969: l_local_index number;
970:
971: Begin
1193: is
1194:
1195: cursor c_get_data_set_id(p_tbb_id number,p_tbb_ovn number) is
1196: select data_set_id
1197: from hxc_time_building_blocks
1198: where time_building_block_id = p_tbb_id
1199: and object_version_number = p_tbb_ovn;
1200:
1201: l_data_set_id hxc_transaction_details.data_set_id%TYPE;
1232: p_messages in out nocopy hxc_message_table_type,
1233: p_transaction_info in out nocopy hxc_timecard.transaction_info
1234: ) is
1235:
1236: l_timecard_id hxc_time_building_blocks.time_building_block_id%type;
1237: l_timecard_ovn hxc_time_building_blocks.object_version_number%type;
1238:
1239: l_deleted_blocks hxc_timecard.block_list;
1240: l_dummy boolean;
1233: p_transaction_info in out nocopy hxc_timecard.transaction_info
1234: ) is
1235:
1236: l_timecard_id hxc_time_building_blocks.time_building_block_id%type;
1237: l_timecard_ovn hxc_time_building_blocks.object_version_number%type;
1238:
1239: l_deleted_blocks hxc_timecard.block_list;
1240: l_dummy boolean;
1241: