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 1027: l_new_bb_id hxc_time_building_blocks.time_building_block_id%type;

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:

Line 1028: l_old_bb_id hxc_time_building_blocks.time_building_block_id%type;

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;

Line 1029: l_new_ovn hxc_time_building_blocks.object_version_number%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;
1033: l_overlapping_block BOOLEAN := false;

Line 1030: l_old_ovn hxc_time_building_blocks.object_version_number%type;

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:

Line 1293: p_timecard_id in hxc_time_building_blocks.time_building_block_id%type,

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

Line 1294: p_timecard_ovn in hxc_time_building_blocks.object_version_number%type,

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

Line 1327: l_new_bb_id hxc_time_building_blocks.time_building_block_id%type;

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:

Line 1328: l_old_bb_id hxc_time_building_blocks.time_building_block_id%type;

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

Line 1558: from hxc_time_building_blocks

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;

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

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