DBA Data[Home] [Help]

APPS.HXT_BATCH_VAL dependencies on HXT_TIMECARDS_F

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

31: PROCEDURE set_error_level (p_valid IN VARCHAR, p_msg_level IN VARCHAR2);
32:
33: PROCEDURE reset_error_level;
34:
35: PROCEDURE delete_prev_val_errors (p_tim_id IN hxt_timecards_f.id%TYPE);
36:
37: FUNCTION errors_exist (p_tim_id IN hxt_timecards.id%TYPE)
38: RETURN BOOLEAN;
39:

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

36:
37: FUNCTION errors_exist (p_tim_id IN hxt_timecards.id%TYPE)
38: RETURN BOOLEAN;
39:
40: FUNCTION timecard_end_date (p_tim_id IN hxt_timecards_f.id%TYPE)
41: RETURN per_time_periods.end_date%TYPE;
42:
43: FUNCTION person_effective_at_tc_end (
44: p_person_id IN per_people_f.person_id%TYPE,

Line 58: p_person_id IN hxt_timecards.for_person_id%TYPE,

54: );
55:
56: PROCEDURE person_validation (
57: p_batch_id IN NUMBER,
58: p_person_id IN hxt_timecards.for_person_id%TYPE,
59: p_period_id IN hxt_timecards.time_period_id%TYPE,
60: p_tim_id IN hxt_timecards.id%TYPE
61: );
62:

Line 66: p_person_id IN hxt_timecards.for_person_id%TYPE,

62:
63: PROCEDURE excess_pto (
64: p_batch_id IN NUMBER,
65: p_calculation_date IN hxt_sum_hours_worked_x.date_worked%TYPE,
66: p_person_id IN hxt_timecards.for_person_id%TYPE,
67: p_period_id IN hxt_timecards.time_period_id%TYPE,
68: p_tim_id IN hxt_timecards.id%TYPE
69: );
70:

Line 100: p_approver_id IN hxt_timecards_f.approv_person_id%TYPE,

96: RETURN BOOLEAN;
97:
98: FUNCTION timecard_approved (
99: p_tim_id IN hxt_holiday_calendars.id%TYPE,
100: p_approver_id IN hxt_timecards_f.approv_person_id%TYPE,
101: p_source_flag IN hxt_timecards_f.auto_gen_flag%TYPE
102: )
103: RETURN BOOLEAN;
104:

Line 101: p_source_flag IN hxt_timecards_f.auto_gen_flag%TYPE

97:
98: FUNCTION timecard_approved (
99: p_tim_id IN hxt_holiday_calendars.id%TYPE,
100: p_approver_id IN hxt_timecards_f.approv_person_id%TYPE,
101: p_source_flag IN hxt_timecards_f.auto_gen_flag%TYPE
102: )
103: RETURN BOOLEAN;
104:
105: PROCEDURE tcard_approved (

Line 107: p_person_id IN hxt_timecards.for_person_id%TYPE,

103: RETURN BOOLEAN;
104:
105: PROCEDURE tcard_approved (
106: p_batch_id IN NUMBER,
107: p_person_id IN hxt_timecards.for_person_id%TYPE,
108: p_period_id IN hxt_timecards.time_period_id%TYPE,
109: p_tim_id IN hxt_timecards.id%TYPE,
110: p_approver_id IN hxt_timecards_f.approv_person_id%TYPE,
111: p_source_flag IN hxt_timecards_f.auto_gen_flag%TYPE

Line 110: p_approver_id IN hxt_timecards_f.approv_person_id%TYPE,

106: p_batch_id IN NUMBER,
107: p_person_id IN hxt_timecards.for_person_id%TYPE,
108: p_period_id IN hxt_timecards.time_period_id%TYPE,
109: p_tim_id IN hxt_timecards.id%TYPE,
110: p_approver_id IN hxt_timecards_f.approv_person_id%TYPE,
111: p_source_flag IN hxt_timecards_f.auto_gen_flag%TYPE
112: );
113:
114: FUNCTION legislation_code (

Line 111: p_source_flag IN hxt_timecards_f.auto_gen_flag%TYPE

107: p_person_id IN hxt_timecards.for_person_id%TYPE,
108: p_period_id IN hxt_timecards.time_period_id%TYPE,
109: p_tim_id IN hxt_timecards.id%TYPE,
110: p_approver_id IN hxt_timecards_f.approv_person_id%TYPE,
111: p_source_flag IN hxt_timecards_f.auto_gen_flag%TYPE
112: );
113:
114: FUNCTION legislation_code (
115: p_bg_id IN per_business_groups.business_group_id%TYPE

Line 133: p_person_id IN hxt_timecards.for_person_id%TYPE,

129: RETURN BOOLEAN;
130:
131: PROCEDURE inactive_emp_tcard (
132: p_batch_id IN NUMBER,
133: p_person_id IN hxt_timecards.for_person_id%TYPE,
134: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
135: p_period_id IN hxt_timecards.time_period_id%TYPE,
136: p_tim_id IN hxt_timecards.id%TYPE,
137: p_day IN DATE

Line 164: p_person_id IN hxt_timecards.for_person_id%TYPE,

160: RETURN NUMBER;
161:
162: PROCEDURE holiday_mismatch (
163: p_batch_id IN NUMBER,
164: p_person_id IN hxt_timecards.for_person_id%TYPE,
165: p_period_id IN hxt_timecards.time_period_id%TYPE,
166: p_tim_id IN hxt_timecards.id%TYPE,
167: p_day IN DATE,
168: p_hours_type IN hxt_sum_hours_worked_f.element_type_id%TYPE,

Line 174: p_person_id IN hxt_timecards.for_person_id%TYPE,

170: );
171:
172: PROCEDURE holiday_valid (
173: p_batch_id IN NUMBER,
174: p_person_id IN hxt_timecards.for_person_id%TYPE,
175: p_period_id IN hxt_timecards.time_period_id%TYPE,
176: p_tim_id IN hxt_timecards.id%TYPE,
177: p_day IN DATE,
178: p_hours_type IN hxt_sum_hours_worked_f.element_type_id%TYPE,

Line 229: p_person_id IN hxt_timecards.for_person_id%TYPE,

225: RETURN NUMBER;
226:
227: PROCEDURE day_over_24 (
228: p_batch_id IN NUMBER,
229: p_person_id IN hxt_timecards.for_person_id%TYPE,
230: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
231: p_period_id IN hxt_timecards.time_period_id%TYPE,
232: p_tim_id IN hxt_timecards.id%TYPE,
233: p_day IN DATE,

Line 239: p_person_id IN hxt_timecards.for_person_id%TYPE,

235: );
236:
237: PROCEDURE holiday_as_reg (
238: p_batch_id IN NUMBER,
239: p_person_id IN hxt_timecards.for_person_id%TYPE,
240: p_period_id IN hxt_timecards.time_period_id%TYPE,
241: p_tim_id IN hxt_timecards.id%TYPE,
242: p_day IN DATE,
243: p_hours_type IN hxt_sum_hours_worked_f.element_type_id%TYPE,

Line 250: p_person_id IN hxt_timecards.for_person_id%TYPE,

246:
247: PROCEDURE validate_tc (
248: p_batch_id IN NUMBER,
249: p_tim_id IN hxt_timecards.id%TYPE,
250: p_person_id IN hxt_timecards.for_person_id%TYPE,
251: p_period_id IN hxt_timecards.time_period_id%TYPE,
252: p_approv_person_id IN hxt_timecards.approv_person_id%TYPE,
253: p_auto_gen_flag IN hxt_timecards.auto_gen_flag%TYPE,
254: p_error_level IN OUT NOCOPY NUMBER