6: --
7: /********Bug: 4620315 **********/
8:
9: TYPE merge_batches_type_rec IS RECORD (batch_id pay_batch_headers.batch_id%TYPE,
10: tc_id hxt_timecards_f.id%TYPE,
11: valid_tc_retcode number,
12: tc_rowid varchar2(500),
13: for_person_id hxt_timecards_f.for_person_id%TYPE,
14: time_period_id hxt_timecards_f.time_period_id%TYPE,
9: TYPE merge_batches_type_rec IS RECORD (batch_id pay_batch_headers.batch_id%TYPE,
10: tc_id hxt_timecards_f.id%TYPE,
11: valid_tc_retcode number,
12: tc_rowid varchar2(500),
13: for_person_id hxt_timecards_f.for_person_id%TYPE,
14: time_period_id hxt_timecards_f.time_period_id%TYPE,
15: auto_gen_flag hxt_timecards_f.auto_gen_flag%TYPE,
16: approv_person_id hxt_timecards_f.approv_person_id%TYPE,
17: approved_timestamp hxt_timecards_f.approved_timestamp%TYPE,
10: tc_id hxt_timecards_f.id%TYPE,
11: valid_tc_retcode number,
12: tc_rowid varchar2(500),
13: for_person_id hxt_timecards_f.for_person_id%TYPE,
14: time_period_id hxt_timecards_f.time_period_id%TYPE,
15: auto_gen_flag hxt_timecards_f.auto_gen_flag%TYPE,
16: approv_person_id hxt_timecards_f.approv_person_id%TYPE,
17: approved_timestamp hxt_timecards_f.approved_timestamp%TYPE,
18: created_by hxt_timecards_f.created_by%TYPE,
11: valid_tc_retcode number,
12: tc_rowid varchar2(500),
13: for_person_id hxt_timecards_f.for_person_id%TYPE,
14: time_period_id hxt_timecards_f.time_period_id%TYPE,
15: auto_gen_flag hxt_timecards_f.auto_gen_flag%TYPE,
16: approv_person_id hxt_timecards_f.approv_person_id%TYPE,
17: approved_timestamp hxt_timecards_f.approved_timestamp%TYPE,
18: created_by hxt_timecards_f.created_by%TYPE,
19: creation_date hxt_timecards_f.creation_date%TYPE,
12: tc_rowid varchar2(500),
13: for_person_id hxt_timecards_f.for_person_id%TYPE,
14: time_period_id hxt_timecards_f.time_period_id%TYPE,
15: auto_gen_flag hxt_timecards_f.auto_gen_flag%TYPE,
16: approv_person_id hxt_timecards_f.approv_person_id%TYPE,
17: approved_timestamp hxt_timecards_f.approved_timestamp%TYPE,
18: created_by hxt_timecards_f.created_by%TYPE,
19: creation_date hxt_timecards_f.creation_date%TYPE,
20: last_updated_by hxt_timecards_f.last_updated_by%TYPE,
13: for_person_id hxt_timecards_f.for_person_id%TYPE,
14: time_period_id hxt_timecards_f.time_period_id%TYPE,
15: auto_gen_flag hxt_timecards_f.auto_gen_flag%TYPE,
16: approv_person_id hxt_timecards_f.approv_person_id%TYPE,
17: approved_timestamp hxt_timecards_f.approved_timestamp%TYPE,
18: created_by hxt_timecards_f.created_by%TYPE,
19: creation_date hxt_timecards_f.creation_date%TYPE,
20: last_updated_by hxt_timecards_f.last_updated_by%TYPE,
21: last_update_date hxt_timecards_f.last_update_date%TYPE,
14: time_period_id hxt_timecards_f.time_period_id%TYPE,
15: auto_gen_flag hxt_timecards_f.auto_gen_flag%TYPE,
16: approv_person_id hxt_timecards_f.approv_person_id%TYPE,
17: approved_timestamp hxt_timecards_f.approved_timestamp%TYPE,
18: created_by hxt_timecards_f.created_by%TYPE,
19: creation_date hxt_timecards_f.creation_date%TYPE,
20: last_updated_by hxt_timecards_f.last_updated_by%TYPE,
21: last_update_date hxt_timecards_f.last_update_date%TYPE,
22: last_update_login hxt_timecards_f.last_update_login%TYPE,
15: auto_gen_flag hxt_timecards_f.auto_gen_flag%TYPE,
16: approv_person_id hxt_timecards_f.approv_person_id%TYPE,
17: approved_timestamp hxt_timecards_f.approved_timestamp%TYPE,
18: created_by hxt_timecards_f.created_by%TYPE,
19: creation_date hxt_timecards_f.creation_date%TYPE,
20: last_updated_by hxt_timecards_f.last_updated_by%TYPE,
21: last_update_date hxt_timecards_f.last_update_date%TYPE,
22: last_update_login hxt_timecards_f.last_update_login%TYPE,
23: payroll_id hxt_timecards_f.payroll_id%TYPE,
16: approv_person_id hxt_timecards_f.approv_person_id%TYPE,
17: approved_timestamp hxt_timecards_f.approved_timestamp%TYPE,
18: created_by hxt_timecards_f.created_by%TYPE,
19: creation_date hxt_timecards_f.creation_date%TYPE,
20: last_updated_by hxt_timecards_f.last_updated_by%TYPE,
21: last_update_date hxt_timecards_f.last_update_date%TYPE,
22: last_update_login hxt_timecards_f.last_update_login%TYPE,
23: payroll_id hxt_timecards_f.payroll_id%TYPE,
24: status hxt_timecards_f.status%TYPE,
17: approved_timestamp hxt_timecards_f.approved_timestamp%TYPE,
18: created_by hxt_timecards_f.created_by%TYPE,
19: creation_date hxt_timecards_f.creation_date%TYPE,
20: last_updated_by hxt_timecards_f.last_updated_by%TYPE,
21: last_update_date hxt_timecards_f.last_update_date%TYPE,
22: last_update_login hxt_timecards_f.last_update_login%TYPE,
23: payroll_id hxt_timecards_f.payroll_id%TYPE,
24: status hxt_timecards_f.status%TYPE,
25: effective_start_date hxt_timecards_f.effective_start_date%TYPE,
18: created_by hxt_timecards_f.created_by%TYPE,
19: creation_date hxt_timecards_f.creation_date%TYPE,
20: last_updated_by hxt_timecards_f.last_updated_by%TYPE,
21: last_update_date hxt_timecards_f.last_update_date%TYPE,
22: last_update_login hxt_timecards_f.last_update_login%TYPE,
23: payroll_id hxt_timecards_f.payroll_id%TYPE,
24: status hxt_timecards_f.status%TYPE,
25: effective_start_date hxt_timecards_f.effective_start_date%TYPE,
26: effective_end_date hxt_timecards_f.effective_end_date%TYPE,
19: creation_date hxt_timecards_f.creation_date%TYPE,
20: last_updated_by hxt_timecards_f.last_updated_by%TYPE,
21: last_update_date hxt_timecards_f.last_update_date%TYPE,
22: last_update_login hxt_timecards_f.last_update_login%TYPE,
23: payroll_id hxt_timecards_f.payroll_id%TYPE,
24: status hxt_timecards_f.status%TYPE,
25: effective_start_date hxt_timecards_f.effective_start_date%TYPE,
26: effective_end_date hxt_timecards_f.effective_end_date%TYPE,
27: object_version_number hxt_timecards_f.object_version_number%TYPE
20: last_updated_by hxt_timecards_f.last_updated_by%TYPE,
21: last_update_date hxt_timecards_f.last_update_date%TYPE,
22: last_update_login hxt_timecards_f.last_update_login%TYPE,
23: payroll_id hxt_timecards_f.payroll_id%TYPE,
24: status hxt_timecards_f.status%TYPE,
25: effective_start_date hxt_timecards_f.effective_start_date%TYPE,
26: effective_end_date hxt_timecards_f.effective_end_date%TYPE,
27: object_version_number hxt_timecards_f.object_version_number%TYPE
28: ); /*** To record the validated timecards details ***/
21: last_update_date hxt_timecards_f.last_update_date%TYPE,
22: last_update_login hxt_timecards_f.last_update_login%TYPE,
23: payroll_id hxt_timecards_f.payroll_id%TYPE,
24: status hxt_timecards_f.status%TYPE,
25: effective_start_date hxt_timecards_f.effective_start_date%TYPE,
26: effective_end_date hxt_timecards_f.effective_end_date%TYPE,
27: object_version_number hxt_timecards_f.object_version_number%TYPE
28: ); /*** To record the validated timecards details ***/
29:
22: last_update_login hxt_timecards_f.last_update_login%TYPE,
23: payroll_id hxt_timecards_f.payroll_id%TYPE,
24: status hxt_timecards_f.status%TYPE,
25: effective_start_date hxt_timecards_f.effective_start_date%TYPE,
26: effective_end_date hxt_timecards_f.effective_end_date%TYPE,
27: object_version_number hxt_timecards_f.object_version_number%TYPE
28: ); /*** To record the validated timecards details ***/
29:
30: TYPE merge_batches_type_table IS TABLE OF merge_batches_type_rec
23: payroll_id hxt_timecards_f.payroll_id%TYPE,
24: status hxt_timecards_f.status%TYPE,
25: effective_start_date hxt_timecards_f.effective_start_date%TYPE,
26: effective_end_date hxt_timecards_f.effective_end_date%TYPE,
27: object_version_number hxt_timecards_f.object_version_number%TYPE
28: ); /*** To record the validated timecards details ***/
29:
30: TYPE merge_batches_type_table IS TABLE OF merge_batches_type_rec
31: INDEX BY BINARY_INTEGER;