eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HXT_BATCH_VAL dependencies on HXT_TIMECARDS

Line 59: PROCEDURE delete_prev_val_errors (p_tim_id IN hxt_timecards_f.id%TYPE);

55: PROCEDURE set_error_level (p_valid IN VARCHAR, p_msg_level IN VARCHAR2);
56:
57: PROCEDURE reset_error_level;
58:
59: PROCEDURE delete_prev_val_errors (p_tim_id IN hxt_timecards_f.id%TYPE);
60:
61: FUNCTION errors_exist (p_tim_id IN hxt_timecards.id%TYPE)
62: RETURN BOOLEAN;
63:

Line 61: FUNCTION errors_exist (p_tim_id IN hxt_timecards.id%TYPE)

57: PROCEDURE reset_error_level;
58:
59: PROCEDURE delete_prev_val_errors (p_tim_id IN hxt_timecards_f.id%TYPE);
60:
61: FUNCTION errors_exist (p_tim_id IN hxt_timecards.id%TYPE)
62: RETURN BOOLEAN;
63:
64: FUNCTION timecard_end_date (p_tim_id IN hxt_timecards_f.id%TYPE)
65: RETURN per_time_periods.end_date%TYPE;

Line 64: FUNCTION timecard_end_date (p_tim_id IN hxt_timecards_f.id%TYPE)

60:
61: FUNCTION errors_exist (p_tim_id IN hxt_timecards.id%TYPE)
62: RETURN BOOLEAN;
63:
64: FUNCTION timecard_end_date (p_tim_id IN hxt_timecards_f.id%TYPE)
65: RETURN per_time_periods.end_date%TYPE;
66:
67: FUNCTION person_effective_at_tc_end (
68: p_person_id IN per_people_f.person_id%TYPE,

Line 69: p_tim_id IN hxt_timecards.id%TYPE

65: RETURN per_time_periods.end_date%TYPE;
66:
67: FUNCTION person_effective_at_tc_end (
68: p_person_id IN per_people_f.person_id%TYPE,
69: p_tim_id IN hxt_timecards.id%TYPE
70: )
71: RETURN BOOLEAN;
72:
73: PROCEDURE record_error (

Line 75: p_period_id IN hxt_timecards.time_period_id%TYPE,

71: RETURN BOOLEAN;
72:
73: PROCEDURE record_error (
74: p_batch_id IN NUMBER,
75: p_period_id IN hxt_timecards.time_period_id%TYPE,
76: p_tim_id IN hxt_timecards.id%TYPE,
77: p_error_code IN VARCHAR2
78: );
79:

Line 76: p_tim_id IN hxt_timecards.id%TYPE,

72:
73: PROCEDURE record_error (
74: p_batch_id IN NUMBER,
75: p_period_id IN hxt_timecards.time_period_id%TYPE,
76: p_tim_id IN hxt_timecards.id%TYPE,
77: p_error_code IN VARCHAR2
78: );
79:
80: PROCEDURE person_validation (

Line 82: p_person_id IN hxt_timecards.for_person_id%TYPE,

78: );
79:
80: PROCEDURE person_validation (
81: p_batch_id IN NUMBER,
82: p_person_id IN hxt_timecards.for_person_id%TYPE,
83: p_period_id IN hxt_timecards.time_period_id%TYPE,
84: p_tim_id IN hxt_timecards.id%TYPE
85: );
86:

Line 83: p_period_id IN hxt_timecards.time_period_id%TYPE,

79:
80: PROCEDURE person_validation (
81: p_batch_id IN NUMBER,
82: p_person_id IN hxt_timecards.for_person_id%TYPE,
83: p_period_id IN hxt_timecards.time_period_id%TYPE,
84: p_tim_id IN hxt_timecards.id%TYPE
85: );
86:
87: PROCEDURE excess_pto (

Line 84: p_tim_id IN hxt_timecards.id%TYPE

80: PROCEDURE person_validation (
81: p_batch_id IN NUMBER,
82: p_person_id IN hxt_timecards.for_person_id%TYPE,
83: p_period_id IN hxt_timecards.time_period_id%TYPE,
84: p_tim_id IN hxt_timecards.id%TYPE
85: );
86:
87: PROCEDURE excess_pto (
88: p_batch_id IN NUMBER,

Line 90: p_person_id IN hxt_timecards.for_person_id%TYPE,

86:
87: PROCEDURE excess_pto (
88: p_batch_id IN NUMBER,
89: p_calculation_date IN hxt_sum_hours_worked_x.date_worked%TYPE,
90: p_person_id IN hxt_timecards.for_person_id%TYPE,
91: p_period_id IN hxt_timecards.time_period_id%TYPE,
92: p_tim_id IN hxt_timecards.id%TYPE
93: );
94:

Line 91: p_period_id IN hxt_timecards.time_period_id%TYPE,

87: PROCEDURE excess_pto (
88: p_batch_id IN NUMBER,
89: p_calculation_date IN hxt_sum_hours_worked_x.date_worked%TYPE,
90: p_person_id IN hxt_timecards.for_person_id%TYPE,
91: p_period_id IN hxt_timecards.time_period_id%TYPE,
92: p_tim_id IN hxt_timecards.id%TYPE
93: );
94:
95: FUNCTION primary_assignment_id (

Line 92: p_tim_id IN hxt_timecards.id%TYPE

88: p_batch_id IN NUMBER,
89: p_calculation_date IN hxt_sum_hours_worked_x.date_worked%TYPE,
90: p_person_id IN hxt_timecards.for_person_id%TYPE,
91: p_period_id IN hxt_timecards.time_period_id%TYPE,
92: p_tim_id IN hxt_timecards.id%TYPE
93: );
94:
95: FUNCTION primary_assignment_id (
96: p_person_id IN per_people_f.person_id%TYPE,

Line 124: p_approver_id IN hxt_timecards_f.approv_person_id%TYPE,

120: RETURN BOOLEAN;
121:
122: FUNCTION timecard_approved (
123: p_tim_id IN hxt_holiday_calendars.id%TYPE,
124: p_approver_id IN hxt_timecards_f.approv_person_id%TYPE,
125: p_source_flag IN hxt_timecards_f.auto_gen_flag%TYPE
126: )
127: RETURN BOOLEAN;
128:

Line 125: p_source_flag IN hxt_timecards_f.auto_gen_flag%TYPE

121:
122: FUNCTION timecard_approved (
123: p_tim_id IN hxt_holiday_calendars.id%TYPE,
124: p_approver_id IN hxt_timecards_f.approv_person_id%TYPE,
125: p_source_flag IN hxt_timecards_f.auto_gen_flag%TYPE
126: )
127: RETURN BOOLEAN;
128:
129: PROCEDURE tcard_approved (

Line 131: p_person_id IN hxt_timecards.for_person_id%TYPE,

127: RETURN BOOLEAN;
128:
129: PROCEDURE tcard_approved (
130: p_batch_id IN NUMBER,
131: p_person_id IN hxt_timecards.for_person_id%TYPE,
132: p_period_id IN hxt_timecards.time_period_id%TYPE,
133: p_tim_id IN hxt_timecards.id%TYPE,
134: p_approver_id IN hxt_timecards_f.approv_person_id%TYPE,
135: p_source_flag IN hxt_timecards_f.auto_gen_flag%TYPE

Line 132: p_period_id IN hxt_timecards.time_period_id%TYPE,

128:
129: PROCEDURE tcard_approved (
130: p_batch_id IN NUMBER,
131: p_person_id IN hxt_timecards.for_person_id%TYPE,
132: p_period_id IN hxt_timecards.time_period_id%TYPE,
133: p_tim_id IN hxt_timecards.id%TYPE,
134: p_approver_id IN hxt_timecards_f.approv_person_id%TYPE,
135: p_source_flag IN hxt_timecards_f.auto_gen_flag%TYPE
136: );

Line 133: p_tim_id IN hxt_timecards.id%TYPE,

129: PROCEDURE tcard_approved (
130: p_batch_id IN NUMBER,
131: p_person_id IN hxt_timecards.for_person_id%TYPE,
132: p_period_id IN hxt_timecards.time_period_id%TYPE,
133: p_tim_id IN hxt_timecards.id%TYPE,
134: p_approver_id IN hxt_timecards_f.approv_person_id%TYPE,
135: p_source_flag IN hxt_timecards_f.auto_gen_flag%TYPE
136: );
137:

Line 134: p_approver_id IN hxt_timecards_f.approv_person_id%TYPE,

130: p_batch_id IN NUMBER,
131: p_person_id IN hxt_timecards.for_person_id%TYPE,
132: p_period_id IN hxt_timecards.time_period_id%TYPE,
133: p_tim_id IN hxt_timecards.id%TYPE,
134: p_approver_id IN hxt_timecards_f.approv_person_id%TYPE,
135: p_source_flag IN hxt_timecards_f.auto_gen_flag%TYPE
136: );
137:
138: FUNCTION legislation_code (

Line 135: p_source_flag IN hxt_timecards_f.auto_gen_flag%TYPE

131: p_person_id IN hxt_timecards.for_person_id%TYPE,
132: p_period_id IN hxt_timecards.time_period_id%TYPE,
133: p_tim_id IN hxt_timecards.id%TYPE,
134: p_approver_id IN hxt_timecards_f.approv_person_id%TYPE,
135: p_source_flag IN hxt_timecards_f.auto_gen_flag%TYPE
136: );
137:
138: FUNCTION legislation_code (
139: p_bg_id IN per_business_groups.business_group_id%TYPE

Line 157: p_person_id IN hxt_timecards.for_person_id%TYPE,

153: RETURN BOOLEAN;
154:
155: PROCEDURE inactive_emp_tcard (
156: p_batch_id IN NUMBER,
157: p_person_id IN hxt_timecards.for_person_id%TYPE,
158: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
159: p_period_id IN hxt_timecards.time_period_id%TYPE,
160: p_tim_id IN hxt_timecards.id%TYPE,
161: p_day IN DATE

Line 159: p_period_id IN hxt_timecards.time_period_id%TYPE,

155: PROCEDURE inactive_emp_tcard (
156: p_batch_id IN NUMBER,
157: p_person_id IN hxt_timecards.for_person_id%TYPE,
158: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
159: p_period_id IN hxt_timecards.time_period_id%TYPE,
160: p_tim_id IN hxt_timecards.id%TYPE,
161: p_day IN DATE
162: );
163:

Line 160: p_tim_id IN hxt_timecards.id%TYPE,

156: p_batch_id IN NUMBER,
157: p_person_id IN hxt_timecards.for_person_id%TYPE,
158: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
159: p_period_id IN hxt_timecards.time_period_id%TYPE,
160: p_tim_id IN hxt_timecards.id%TYPE,
161: p_day IN DATE
162: );
163:
164: PROCEDURE get_holiday_info (

Line 180: p_tim_id IN hxt_timecards.id%TYPE,

176: p_hol_element_type_id OUT NOCOPY hxt_holiday_calendars.element_type_id%TYPE
177: );
178:
179: FUNCTION sum_unexploded_hours (
180: p_tim_id IN hxt_timecards.id%TYPE,
181: p_day IN hxt_det_hours_worked_f.date_worked%TYPE,
182: p_hours_type IN hxt_det_hours_worked_f.hours%TYPE DEFAULT NULL
183: )
184: RETURN NUMBER;

Line 188: p_person_id IN hxt_timecards.for_person_id%TYPE,

184: RETURN NUMBER;
185:
186: PROCEDURE holiday_mismatch (
187: p_batch_id IN NUMBER,
188: p_person_id IN hxt_timecards.for_person_id%TYPE,
189: p_period_id IN hxt_timecards.time_period_id%TYPE,
190: p_tim_id IN hxt_timecards.id%TYPE,
191: p_day IN DATE,
192: p_hours_type IN hxt_sum_hours_worked_f.element_type_id%TYPE,

Line 189: p_period_id IN hxt_timecards.time_period_id%TYPE,

185:
186: PROCEDURE holiday_mismatch (
187: p_batch_id IN NUMBER,
188: p_person_id IN hxt_timecards.for_person_id%TYPE,
189: p_period_id IN hxt_timecards.time_period_id%TYPE,
190: p_tim_id IN hxt_timecards.id%TYPE,
191: p_day IN DATE,
192: p_hours_type IN hxt_sum_hours_worked_f.element_type_id%TYPE,
193: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE

Line 190: p_tim_id IN hxt_timecards.id%TYPE,

186: PROCEDURE holiday_mismatch (
187: p_batch_id IN NUMBER,
188: p_person_id IN hxt_timecards.for_person_id%TYPE,
189: p_period_id IN hxt_timecards.time_period_id%TYPE,
190: p_tim_id IN hxt_timecards.id%TYPE,
191: p_day IN DATE,
192: p_hours_type IN hxt_sum_hours_worked_f.element_type_id%TYPE,
193: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE
194: );

Line 198: p_person_id IN hxt_timecards.for_person_id%TYPE,

194: );
195:
196: PROCEDURE holiday_valid (
197: p_batch_id IN NUMBER,
198: p_person_id IN hxt_timecards.for_person_id%TYPE,
199: p_period_id IN hxt_timecards.time_period_id%TYPE,
200: p_tim_id IN hxt_timecards.id%TYPE,
201: p_day IN DATE,
202: p_hours_type IN hxt_sum_hours_worked_f.element_type_id%TYPE,

Line 199: p_period_id IN hxt_timecards.time_period_id%TYPE,

195:
196: PROCEDURE holiday_valid (
197: p_batch_id IN NUMBER,
198: p_person_id IN hxt_timecards.for_person_id%TYPE,
199: p_period_id IN hxt_timecards.time_period_id%TYPE,
200: p_tim_id IN hxt_timecards.id%TYPE,
201: p_day IN DATE,
202: p_hours_type IN hxt_sum_hours_worked_f.element_type_id%TYPE,
203: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE

Line 200: p_tim_id IN hxt_timecards.id%TYPE,

196: PROCEDURE holiday_valid (
197: p_batch_id IN NUMBER,
198: p_person_id IN hxt_timecards.for_person_id%TYPE,
199: p_period_id IN hxt_timecards.time_period_id%TYPE,
200: p_tim_id IN hxt_timecards.id%TYPE,
201: p_day IN DATE,
202: p_hours_type IN hxt_sum_hours_worked_f.element_type_id%TYPE,
203: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE
204: );

Line 244: p_tim_id IN hxt_timecards.id%TYPE,

240: )
241: RETURN BOOLEAN;
242:
243: FUNCTION sum_valid_det_hours (
244: p_tim_id IN hxt_timecards.id%TYPE,
245: p_day IN DATE,
246: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
247: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE
248: )

Line 253: p_person_id IN hxt_timecards.for_person_id%TYPE,

249: RETURN NUMBER;
250:
251: PROCEDURE day_over_24 (
252: p_batch_id IN NUMBER,
253: p_person_id IN hxt_timecards.for_person_id%TYPE,
254: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
255: p_period_id IN hxt_timecards.time_period_id%TYPE,
256: p_tim_id IN hxt_timecards.id%TYPE,
257: p_day IN DATE,

Line 255: p_period_id IN hxt_timecards.time_period_id%TYPE,

251: PROCEDURE day_over_24 (
252: p_batch_id IN NUMBER,
253: p_person_id IN hxt_timecards.for_person_id%TYPE,
254: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
255: p_period_id IN hxt_timecards.time_period_id%TYPE,
256: p_tim_id IN hxt_timecards.id%TYPE,
257: p_day IN DATE,
258: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE
259: );

Line 256: p_tim_id IN hxt_timecards.id%TYPE,

252: p_batch_id IN NUMBER,
253: p_person_id IN hxt_timecards.for_person_id%TYPE,
254: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
255: p_period_id IN hxt_timecards.time_period_id%TYPE,
256: p_tim_id IN hxt_timecards.id%TYPE,
257: p_day IN DATE,
258: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE
259: );
260:

Line 263: p_person_id IN hxt_timecards.for_person_id%TYPE,

259: );
260:
261: PROCEDURE holiday_as_reg (
262: p_batch_id IN NUMBER,
263: p_person_id IN hxt_timecards.for_person_id%TYPE,
264: p_period_id IN hxt_timecards.time_period_id%TYPE,
265: p_tim_id IN hxt_timecards.id%TYPE,
266: p_day IN DATE,
267: p_hours_type IN hxt_sum_hours_worked_f.element_type_id%TYPE,

Line 264: p_period_id IN hxt_timecards.time_period_id%TYPE,

260:
261: PROCEDURE holiday_as_reg (
262: p_batch_id IN NUMBER,
263: p_person_id IN hxt_timecards.for_person_id%TYPE,
264: p_period_id IN hxt_timecards.time_period_id%TYPE,
265: p_tim_id IN hxt_timecards.id%TYPE,
266: p_day IN DATE,
267: p_hours_type IN hxt_sum_hours_worked_f.element_type_id%TYPE,
268: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE

Line 265: p_tim_id IN hxt_timecards.id%TYPE,

261: PROCEDURE holiday_as_reg (
262: p_batch_id IN NUMBER,
263: p_person_id IN hxt_timecards.for_person_id%TYPE,
264: p_period_id IN hxt_timecards.time_period_id%TYPE,
265: p_tim_id IN hxt_timecards.id%TYPE,
266: p_day IN DATE,
267: p_hours_type IN hxt_sum_hours_worked_f.element_type_id%TYPE,
268: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE
269: );

Line 273: p_tim_id IN hxt_timecards.id%TYPE,

269: );
270:
271: PROCEDURE validate_tc (
272: p_batch_id IN NUMBER,
273: p_tim_id IN hxt_timecards.id%TYPE,
274: p_person_id IN hxt_timecards.for_person_id%TYPE,
275: p_period_id IN hxt_timecards.time_period_id%TYPE,
276: p_approv_person_id IN hxt_timecards.approv_person_id%TYPE,
277: p_auto_gen_flag IN hxt_timecards.auto_gen_flag%TYPE,

Line 274: p_person_id IN hxt_timecards.for_person_id%TYPE,

270:
271: PROCEDURE validate_tc (
272: p_batch_id IN NUMBER,
273: p_tim_id IN hxt_timecards.id%TYPE,
274: p_person_id IN hxt_timecards.for_person_id%TYPE,
275: p_period_id IN hxt_timecards.time_period_id%TYPE,
276: p_approv_person_id IN hxt_timecards.approv_person_id%TYPE,
277: p_auto_gen_flag IN hxt_timecards.auto_gen_flag%TYPE,
278: p_error_level IN OUT NOCOPY NUMBER

Line 275: p_period_id IN hxt_timecards.time_period_id%TYPE,

271: PROCEDURE validate_tc (
272: p_batch_id IN NUMBER,
273: p_tim_id IN hxt_timecards.id%TYPE,
274: p_person_id IN hxt_timecards.for_person_id%TYPE,
275: p_period_id IN hxt_timecards.time_period_id%TYPE,
276: p_approv_person_id IN hxt_timecards.approv_person_id%TYPE,
277: p_auto_gen_flag IN hxt_timecards.auto_gen_flag%TYPE,
278: p_error_level IN OUT NOCOPY NUMBER
279: );

Line 276: p_approv_person_id IN hxt_timecards.approv_person_id%TYPE,

272: p_batch_id IN NUMBER,
273: p_tim_id IN hxt_timecards.id%TYPE,
274: p_person_id IN hxt_timecards.for_person_id%TYPE,
275: p_period_id IN hxt_timecards.time_period_id%TYPE,
276: p_approv_person_id IN hxt_timecards.approv_person_id%TYPE,
277: p_auto_gen_flag IN hxt_timecards.auto_gen_flag%TYPE,
278: p_error_level IN OUT NOCOPY NUMBER
279: );
280:

Line 277: p_auto_gen_flag IN hxt_timecards.auto_gen_flag%TYPE,

273: p_tim_id IN hxt_timecards.id%TYPE,
274: p_person_id IN hxt_timecards.for_person_id%TYPE,
275: p_period_id IN hxt_timecards.time_period_id%TYPE,
276: p_approv_person_id IN hxt_timecards.approv_person_id%TYPE,
277: p_auto_gen_flag IN hxt_timecards.auto_gen_flag%TYPE,
278: p_error_level IN OUT NOCOPY NUMBER
279: );
280:
281: PROCEDURE val_batch (