DBA Data[Home] [Help]

APPS.HXT_BATCH_VAL dependencies on HXT_TIMECARDS_F

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 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 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 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 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 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 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 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 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 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 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