34:
35: --
36: /********Bug: 4620315 **********/
37:
38: TYPE merge_batches_type_rec IS RECORD (batch_id pay_batch_headers.batch_id%TYPE,
39: tc_id hxt_timecards_f.id%TYPE,
40: valid_tc_retcode number,
41: tc_rowid varchar2(500),
42: for_person_id hxt_timecards_f.for_person_id%TYPE,
58:
59: TYPE merge_batches_type_table IS TABLE OF merge_batches_type_rec
60: INDEX BY BINARY_INTEGER;
61:
62: TYPE del_empty_batches_type_rec IS RECORD (batch_id pay_batch_headers.batch_id%TYPE,
63: batch_ovn pay_batch_headers.object_version_number%TYPE
64: ); /*** To record the empty batches detail ***/
65:
66: TYPE del_empty_batches_type_table IS TABLE OF del_empty_batches_type_rec
59: TYPE merge_batches_type_table IS TABLE OF merge_batches_type_rec
60: INDEX BY BINARY_INTEGER;
61:
62: TYPE del_empty_batches_type_rec IS RECORD (batch_id pay_batch_headers.batch_id%TYPE,
63: batch_ovn pay_batch_headers.object_version_number%TYPE
64: ); /*** To record the empty batches detail ***/
65:
66: TYPE del_empty_batches_type_table IS TABLE OF del_empty_batches_type_rec
67: INDEX BY BINARY_INTEGER;