DBA Data[Home] [Help]

APPS.HXT_BATCH_PROCESS dependencies on HXT_TIMECARDS_F

Line 10: tc_id hxt_timecards_f.id%TYPE,

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,

Line 13: for_person_id hxt_timecards_f.for_person_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,

Line 14: time_period_id hxt_timecards_f.time_period_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,
18: created_by hxt_timecards_f.created_by%TYPE,

Line 15: auto_gen_flag hxt_timecards_f.auto_gen_flag%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,

Line 16: approv_person_id hxt_timecards_f.approv_person_id%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,

Line 17: approved_timestamp hxt_timecards_f.approved_timestamp%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,

Line 18: created_by hxt_timecards_f.created_by%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,

Line 19: creation_date hxt_timecards_f.creation_date%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,

Line 20: last_updated_by hxt_timecards_f.last_updated_by%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,

Line 21: last_update_date hxt_timecards_f.last_update_date%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,

Line 22: last_update_login hxt_timecards_f.last_update_login%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,

Line 23: payroll_id hxt_timecards_f.payroll_id%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

Line 24: status hxt_timecards_f.status%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 ***/

Line 25: effective_start_date hxt_timecards_f.effective_start_date%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 ***/
29:

Line 26: effective_end_date hxt_timecards_f.effective_end_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:
30: TYPE merge_batches_type_table IS TABLE OF merge_batches_type_rec

Line 27: object_version_number hxt_timecards_f.object_version_number%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
31: INDEX BY BINARY_INTEGER;