DBA Data[Home] [Help]

APPS.HXT_BATCH_PROCESS dependencies on HXT_TIMECARDS_F

Line 39: tc_id hxt_timecards_f.id%TYPE,

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,

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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