[Home] [Help]
PACKAGE: APPS.HXT_BATCH_VAL
Source
1 PACKAGE hxt_batch_val AS
2 /* $Header: hxtbtval.pkh 120.3.12010000.1 2008/07/25 09:48:09 appldev ship $ */
3 c_39315_max_hrs_exceeded CONSTANT fnd_lookup_values.lookup_code%TYPE
4 := '24_HOUR_EDIT';
5 c_39260_abs_not_asg_to_acrl CONSTANT fnd_lookup_values.lookup_code%TYPE
6 := 'ABS_NOT_ASG_TO_ACRL';
7 c_39509_accrual_exceeded CONSTANT fnd_lookup_values.lookup_code%TYPE
8 := 'ACCRUAL_EXCEEDED';
9 c_39332_day_on_hol_cal CONSTANT fnd_lookup_values.lookup_code%TYPE
10 := 'DAY_IS_HOLIDAY';
11 c_39333_hol_not_valid_on_cal CONSTANT fnd_lookup_values.lookup_code%TYPE
12 := 'HOLIDAY_NOT_VAL';
13 c_39334_hrs_chged_ne_cal_hrs CONSTANT fnd_lookup_values.lookup_code%TYPE
14 := 'HOURS_NOT_EQUAL';
15 c_39338_ins_error_occ CONSTANT fnd_lookup_values.lookup_code%TYPE
16 := 'INSERT_ERRORS';
17 c_39316_person_nf CONSTANT fnd_lookup_values.lookup_code%TYPE
18 := 'PERSON_NOT_IN_DB';
19 c_39335_exceeded_accrued_hrs CONSTANT fnd_lookup_values.lookup_code%TYPE
20 := 'PTO_CHG_ACCRUED';
21 c_39336_errs_in_batch CONSTANT fnd_lookup_values.lookup_code%TYPE
22 := 'TIMECARD_ERRORS';
23 c_39317_empl_inactive CONSTANT fnd_lookup_values.lookup_code%TYPE
24 := 'TIMECARD_INACTIVE';
25 c_39337_timecard_not_apprved CONSTANT fnd_lookup_values.lookup_code%TYPE
26 := 'TIMECARD_NOT_APPROVED';
27
28 FUNCTION error_level
29 RETURN NUMBER;
30
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
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,
45 p_tim_id IN hxt_timecards.id%TYPE
46 )
47 RETURN BOOLEAN;
48
49 PROCEDURE record_error (
50 p_batch_id IN NUMBER,
51 p_period_id IN hxt_timecards.time_period_id%TYPE,
52 p_tim_id IN hxt_timecards.id%TYPE,
53 p_error_code IN VARCHAR2
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
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
71 FUNCTION primary_assignment_id (
72 p_person_id IN per_people_f.person_id%TYPE,
73 p_effective_date IN DATE
74 )
75 RETURN per_all_assignments_f.assignment_id%TYPE;
76
77 FUNCTION holiday_calendar_id (
78 p_person_id IN per_people_f.person_id%TYPE,
79 p_effective_date IN DATE
80 )
81 RETURN hxt_holiday_calendars.id%TYPE;
82
83 FUNCTION holiday_calendar_id (
84 p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
85 p_effective_date IN DATE
86 )
87 RETURN hxt_holiday_calendars.id%TYPE;
88
89 FUNCTION holiday_element_id (p_hol_cal_id IN hxt_holiday_calendars.id%TYPE)
90 RETURN hxt_holiday_calendars.element_type_id%TYPE;
91
92 FUNCTION day_is_holiday (
93 p_hol_cal_id IN hxt_holiday_calendars.id%TYPE,
94 p_day IN DATE
95 )
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
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
112 );
113
114 FUNCTION legislation_code (
115 p_bg_id IN per_business_groups.business_group_id%TYPE
116 )
117 RETURN VARCHAR2; -- per_business_groups.legislation_code%TYPE;
118
119 FUNCTION legislation_code (
120 p_asg_id IN per_all_assignments_f.assignment_id%TYPE,
121 p_effective_date IN DATE
122 )
123 RETURN per_business_groups.legislation_code%TYPE;
124
125 FUNCTION assignment_is_active (
126 p_asg_id IN per_all_assignments_f.assignment_id%TYPE,
127 p_effective_date IN DATE
128 )
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
138 );
139
140 PROCEDURE get_holiday_info (
141 p_day IN DATE,
142 p_hol_cal_id IN hxt_holiday_calendars.id%TYPE,
143 p_hol_hours OUT NOCOPY hxt_holiday_days.hours%TYPE,
144 p_hol_element_type_id OUT NOCOPY hxt_holiday_calendars.element_type_id%TYPE
145 );
146
147 PROCEDURE get_holiday_info (
148 p_person_id IN per_people_f.person_id%TYPE,
149 p_day IN DATE,
150 p_effective_date IN DATE,
151 p_hol_hours OUT NOCOPY hxt_holiday_days.hours%TYPE,
152 p_hol_element_type_id OUT NOCOPY hxt_holiday_calendars.element_type_id%TYPE
153 );
154
155 FUNCTION sum_unexploded_hours (
156 p_tim_id IN hxt_timecards.id%TYPE,
157 p_day IN hxt_det_hours_worked_f.date_worked%TYPE,
158 p_hours_type IN hxt_det_hours_worked_f.hours%TYPE DEFAULT NULL
159 )
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,
169 p_hol_cal_id IN hxt_holiday_calendars.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,
179 p_hol_cal_id IN hxt_holiday_calendars.id%TYPE
180 );
181
182 FUNCTION element_link (
183 p_element_type_id IN pay_element_types_f.element_type_id%TYPE,
184 p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
185 p_effective_date IN DATE
186 )
187 RETURN pay_element_links_f.element_link_id%TYPE;
188
189 FUNCTION element_linked (
190 p_element_type_id IN pay_element_types_f.element_type_id%TYPE,
191 p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
192 p_effective_date IN DATE
193 )
194 RETURN BOOLEAN;
195
196 FUNCTION valid_for_summing (
197 p_element_id IN pay_element_types_f.element_type_id%TYPE,
198 p_earnings_category IN hxt_add_elem_info_f.earning_category%TYPE,
199 p_day IN DATE,
200 p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
201 p_hol_cal_id IN hxt_holiday_calendars.id%TYPE,
202 p_valid_earn_cat1 IN hxt_add_elem_info_f.earning_category%TYPE
203 DEFAULT NULL,
204 p_valid_earn_cat2 IN hxt_add_elem_info_f.earning_category%TYPE
205 DEFAULT NULL,
206 p_valid_earn_cat3 IN hxt_add_elem_info_f.earning_category%TYPE
207 DEFAULT NULL,
208 p_valid_earn_cat4 IN hxt_add_elem_info_f.earning_category%TYPE
209 DEFAULT NULL,
210 p_valid_earn_cat5 IN hxt_add_elem_info_f.earning_category%TYPE
211 DEFAULT NULL,
212 p_valid_earn_cat6 IN hxt_add_elem_info_f.earning_category%TYPE
213 DEFAULT NULL,
214 p_valid_earn_cat7 IN hxt_add_elem_info_f.earning_category%TYPE
215 DEFAULT NULL
216 )
217 RETURN BOOLEAN;
218
219 FUNCTION sum_valid_det_hours (
220 p_tim_id IN hxt_timecards.id%TYPE,
221 p_day IN DATE,
222 p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
223 p_hol_cal_id IN hxt_holiday_calendars.id%TYPE
224 )
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,
234 p_hol_cal_id IN hxt_holiday_calendars.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,
244 p_hol_cal_id IN hxt_holiday_calendars.id%TYPE
245 );
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
255 );
256
257 PROCEDURE val_batch (
258 p_batch_id IN NUMBER,
259 p_time_period_id IN NUMBER,
260 p_valid_retcode IN OUT NOCOPY NUMBER,
261 p_merge_flag IN VARCHAR2 DEFAULT '0',
262 p_merge_batches OUT NOCOPY HXT_BATCH_PROCESS.MERGE_BATCHES_TYPE_TABLE
263 );
264 END hxt_batch_val;