DBA Data[Home] [Help]

APPS.HXC_TIMECARD_DEPOSIT dependencies on HXC_TIME_BUILDING_BLOCKS

Line 7: (p_time_building_block_id in hxc_time_building_blocks.time_building_block_id%type

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

Line 8: ,p_object_version_number in hxc_time_building_blocks.object_version_number%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

Line 57: ,p_time_building_block_id in hxc_time_building_blocks.time_building_block_id%type

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);

Line 58: ,p_time_building_block_ovn in hxc_time_building_blocks.object_version_number%type

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:

Line 208: ,p_old_ta_id in hxc_time_building_blocks.time_building_block_id%type

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

Line 209: ,p_old_ta_ovn in hxc_time_building_blocks.object_version_number%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

Line 210: ,p_new_ta_id in hxc_time_building_blocks.time_building_block_id%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

Line 211: ,p_new_ta_ovn in hxc_time_building_blocks.object_version_number%type

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:

Line 212: ,p_timecard_id in hxc_time_building_blocks.time_building_block_id%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:
216: l_index number;

Line 213: ,p_timecard_ovn in hxc_time_building_blocks.object_version_number%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;
217:

Line 243: ,p_old_bb_id in hxc_time_building_blocks.time_building_block_id%type

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

Line 244: ,p_old_bb_ovn in hxc_time_building_blocks.object_version_number%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

Line 245: ,p_new_bb_id in hxc_time_building_blocks.time_building_block_id%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

Line 246: ,p_new_bb_ovn in hxc_time_building_blocks.object_version_number%type

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:

Line 247: ,p_timecard_id in hxc_time_building_blocks.time_building_block_id%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:
251: l_index number;

Line 248: ,p_timecard_ovn in hxc_time_building_blocks.object_version_number%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;
252:

Line 279: ,l_old_bb_id in hxc_time_building_blocks.time_building_block_id%type

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

Line 280: ,l_old_ovn in hxc_time_building_blocks.object_version_number%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

Line 281: ,l_new_bb_id in hxc_time_building_blocks.time_building_block_id%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

Line 282: ,l_new_ovn in hxc_time_building_blocks.object_version_number%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
286:

Line 283: ,p_timecard_id in hxc_time_building_blocks.time_building_block_id%type

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;

Line 284: ,p_timecard_ovn in hxc_time_building_blocks.object_version_number%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;
288: l_index number;

Line 391: l_object_version_number HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE;

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:

Line 392: l_time_building_block_id HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE := null;

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;

Line 461: l_object_version_number hxc_time_building_blocks.object_version_number%type;

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

Line 560: l_new_bb_id hxc_time_building_blocks.time_building_block_id%type;

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:

Line 561: l_old_bb_id hxc_time_building_blocks.time_building_block_id%type;

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

Line 562: l_new_ovn hxc_time_building_blocks.object_version_number%type;

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:

Line 563: l_old_ovn hxc_time_building_blocks.object_version_number%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:
567: l_index := p_timecard_blocks.first;

Line 637: l_new_bb_id hxc_time_building_blocks.time_building_block_id%type;

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:

Line 638: l_old_bb_id hxc_time_building_blocks.time_building_block_id%type;

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

Line 639: l_new_ovn hxc_time_building_blocks.object_version_number%type;

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:

Line 640: l_old_ovn hxc_time_building_blocks.object_version_number%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:
644: l_index := p_day_blocks.first;

Line 764: l_new_bb_id hxc_time_building_blocks.time_building_block_id%type;

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:

Line 765: l_old_bb_id hxc_time_building_blocks.time_building_block_id%type;

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;

Line 766: l_new_ovn hxc_time_building_blocks.object_version_number%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;
770:

Line 767: l_old_ovn hxc_time_building_blocks.object_version_number%type;

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

Line 932: p_timecard_id in hxc_time_building_blocks.time_building_block_id%type,

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

Line 933: p_timecard_ovn in hxc_time_building_blocks.object_version_number%type,

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

Line 966: l_new_bb_id hxc_time_building_blocks.time_building_block_id%type;

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:

Line 967: l_old_bb_id hxc_time_building_blocks.time_building_block_id%type;

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

Line 1197: from hxc_time_building_blocks

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;

Line 1236: l_timecard_id hxc_time_building_blocks.time_building_block_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;

Line 1237: l_timecard_ovn hxc_time_building_blocks.object_version_number%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;
1241: