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,
43: time_period_id hxt_timecards_f.time_period_id%TYPE,
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,
43: time_period_id hxt_timecards_f.time_period_id%TYPE,
44: auto_gen_flag hxt_timecards_f.auto_gen_flag%TYPE,
45: approv_person_id hxt_timecards_f.approv_person_id%TYPE,
46: approved_timestamp hxt_timecards_f.approved_timestamp%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,
43: time_period_id hxt_timecards_f.time_period_id%TYPE,
44: auto_gen_flag hxt_timecards_f.auto_gen_flag%TYPE,
45: approv_person_id hxt_timecards_f.approv_person_id%TYPE,
46: approved_timestamp hxt_timecards_f.approved_timestamp%TYPE,
47: created_by hxt_timecards_f.created_by%TYPE,
40: valid_tc_retcode number,
41: tc_rowid varchar2(500),
42: for_person_id hxt_timecards_f.for_person_id%TYPE,
43: time_period_id hxt_timecards_f.time_period_id%TYPE,
44: auto_gen_flag hxt_timecards_f.auto_gen_flag%TYPE,
45: approv_person_id hxt_timecards_f.approv_person_id%TYPE,
46: approved_timestamp hxt_timecards_f.approved_timestamp%TYPE,
47: created_by hxt_timecards_f.created_by%TYPE,
48: creation_date hxt_timecards_f.creation_date%TYPE,
41: tc_rowid varchar2(500),
42: for_person_id hxt_timecards_f.for_person_id%TYPE,
43: time_period_id hxt_timecards_f.time_period_id%TYPE,
44: auto_gen_flag hxt_timecards_f.auto_gen_flag%TYPE,
45: approv_person_id hxt_timecards_f.approv_person_id%TYPE,
46: approved_timestamp hxt_timecards_f.approved_timestamp%TYPE,
47: created_by hxt_timecards_f.created_by%TYPE,
48: creation_date hxt_timecards_f.creation_date%TYPE,
49: last_updated_by hxt_timecards_f.last_updated_by%TYPE,
42: for_person_id hxt_timecards_f.for_person_id%TYPE,
43: time_period_id hxt_timecards_f.time_period_id%TYPE,
44: auto_gen_flag hxt_timecards_f.auto_gen_flag%TYPE,
45: approv_person_id hxt_timecards_f.approv_person_id%TYPE,
46: approved_timestamp hxt_timecards_f.approved_timestamp%TYPE,
47: created_by hxt_timecards_f.created_by%TYPE,
48: creation_date hxt_timecards_f.creation_date%TYPE,
49: last_updated_by hxt_timecards_f.last_updated_by%TYPE,
50: last_update_date hxt_timecards_f.last_update_date%TYPE,
43: time_period_id hxt_timecards_f.time_period_id%TYPE,
44: auto_gen_flag hxt_timecards_f.auto_gen_flag%TYPE,
45: approv_person_id hxt_timecards_f.approv_person_id%TYPE,
46: approved_timestamp hxt_timecards_f.approved_timestamp%TYPE,
47: created_by hxt_timecards_f.created_by%TYPE,
48: creation_date hxt_timecards_f.creation_date%TYPE,
49: last_updated_by hxt_timecards_f.last_updated_by%TYPE,
50: last_update_date hxt_timecards_f.last_update_date%TYPE,
51: last_update_login hxt_timecards_f.last_update_login%TYPE,
44: auto_gen_flag hxt_timecards_f.auto_gen_flag%TYPE,
45: approv_person_id hxt_timecards_f.approv_person_id%TYPE,
46: approved_timestamp hxt_timecards_f.approved_timestamp%TYPE,
47: created_by hxt_timecards_f.created_by%TYPE,
48: creation_date hxt_timecards_f.creation_date%TYPE,
49: last_updated_by hxt_timecards_f.last_updated_by%TYPE,
50: last_update_date hxt_timecards_f.last_update_date%TYPE,
51: last_update_login hxt_timecards_f.last_update_login%TYPE,
52: payroll_id hxt_timecards_f.payroll_id%TYPE,
45: approv_person_id hxt_timecards_f.approv_person_id%TYPE,
46: approved_timestamp hxt_timecards_f.approved_timestamp%TYPE,
47: created_by hxt_timecards_f.created_by%TYPE,
48: creation_date hxt_timecards_f.creation_date%TYPE,
49: last_updated_by hxt_timecards_f.last_updated_by%TYPE,
50: last_update_date hxt_timecards_f.last_update_date%TYPE,
51: last_update_login hxt_timecards_f.last_update_login%TYPE,
52: payroll_id hxt_timecards_f.payroll_id%TYPE,
53: status hxt_timecards_f.status%TYPE,
46: approved_timestamp hxt_timecards_f.approved_timestamp%TYPE,
47: created_by hxt_timecards_f.created_by%TYPE,
48: creation_date hxt_timecards_f.creation_date%TYPE,
49: last_updated_by hxt_timecards_f.last_updated_by%TYPE,
50: last_update_date hxt_timecards_f.last_update_date%TYPE,
51: last_update_login hxt_timecards_f.last_update_login%TYPE,
52: payroll_id hxt_timecards_f.payroll_id%TYPE,
53: status hxt_timecards_f.status%TYPE,
54: effective_start_date hxt_timecards_f.effective_start_date%TYPE,
47: created_by hxt_timecards_f.created_by%TYPE,
48: creation_date hxt_timecards_f.creation_date%TYPE,
49: last_updated_by hxt_timecards_f.last_updated_by%TYPE,
50: last_update_date hxt_timecards_f.last_update_date%TYPE,
51: last_update_login hxt_timecards_f.last_update_login%TYPE,
52: payroll_id hxt_timecards_f.payroll_id%TYPE,
53: status hxt_timecards_f.status%TYPE,
54: effective_start_date hxt_timecards_f.effective_start_date%TYPE,
55: effective_end_date hxt_timecards_f.effective_end_date%TYPE,
48: creation_date hxt_timecards_f.creation_date%TYPE,
49: last_updated_by hxt_timecards_f.last_updated_by%TYPE,
50: last_update_date hxt_timecards_f.last_update_date%TYPE,
51: last_update_login hxt_timecards_f.last_update_login%TYPE,
52: payroll_id hxt_timecards_f.payroll_id%TYPE,
53: status hxt_timecards_f.status%TYPE,
54: effective_start_date hxt_timecards_f.effective_start_date%TYPE,
55: effective_end_date hxt_timecards_f.effective_end_date%TYPE,
56: object_version_number hxt_timecards_f.object_version_number%TYPE
49: last_updated_by hxt_timecards_f.last_updated_by%TYPE,
50: last_update_date hxt_timecards_f.last_update_date%TYPE,
51: last_update_login hxt_timecards_f.last_update_login%TYPE,
52: payroll_id hxt_timecards_f.payroll_id%TYPE,
53: status hxt_timecards_f.status%TYPE,
54: effective_start_date hxt_timecards_f.effective_start_date%TYPE,
55: effective_end_date hxt_timecards_f.effective_end_date%TYPE,
56: object_version_number hxt_timecards_f.object_version_number%TYPE
57: ); /*** To record the validated timecards details ***/
50: last_update_date hxt_timecards_f.last_update_date%TYPE,
51: last_update_login hxt_timecards_f.last_update_login%TYPE,
52: payroll_id hxt_timecards_f.payroll_id%TYPE,
53: status hxt_timecards_f.status%TYPE,
54: effective_start_date hxt_timecards_f.effective_start_date%TYPE,
55: effective_end_date hxt_timecards_f.effective_end_date%TYPE,
56: object_version_number hxt_timecards_f.object_version_number%TYPE
57: ); /*** To record the validated timecards details ***/
58:
51: last_update_login hxt_timecards_f.last_update_login%TYPE,
52: payroll_id hxt_timecards_f.payroll_id%TYPE,
53: status hxt_timecards_f.status%TYPE,
54: effective_start_date hxt_timecards_f.effective_start_date%TYPE,
55: effective_end_date hxt_timecards_f.effective_end_date%TYPE,
56: object_version_number hxt_timecards_f.object_version_number%TYPE
57: ); /*** To record the validated timecards details ***/
58:
59: TYPE merge_batches_type_table IS TABLE OF merge_batches_type_rec
52: payroll_id hxt_timecards_f.payroll_id%TYPE,
53: status hxt_timecards_f.status%TYPE,
54: effective_start_date hxt_timecards_f.effective_start_date%TYPE,
55: effective_end_date hxt_timecards_f.effective_end_date%TYPE,
56: object_version_number hxt_timecards_f.object_version_number%TYPE
57: ); /*** To record the validated timecards details ***/
58:
59: TYPE merge_batches_type_table IS TABLE OF merge_batches_type_rec
60: INDEX BY BINARY_INTEGER;