[Home] [Help]
PACKAGE: APPS.PER_ABSENCE_ATTENDANCES_PKG
Source
1 package PER_ABSENCE_ATTENDANCES_PKG AUTHID CURRENT_USER as
2 /* $Header: peaba01t.pkh 115.5 2003/08/13 05:31:55 ablinko ship $ */
3
4 /*
5 Date Name Release Description
6 |------------|---------|---------|--------------------------------------------|
7 07-SEP-1998 JARTHURT 110.1 Added new parameters to the insert, update
8 and lock routines to deal with a new DFF
9 22-DEC-1998 A.MYERS 110.2 Bug 725730: Maternity update changes.
10 11-AUG-2003 A.BLINKO 115.4 Bug 2829746: Added default_MPP_start_date
11 Added parameter to get_due_date_2
12 |------------|---------|---------|--------------------------------------------|
13 */
14
15 -- The following variable is set by procedure mpp_update_mode, and controls
16 -- whether the mpp date is updated or not when an absence change is made.
17 g_mpp_update_mode boolean := FALSE;
18 g_mpp_updated_date date;
19
20 PROCEDURE mpp_update_mode(p_update_mode in number);
21
22 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
23 X_Absence_Attendance_Id IN OUT NOCOPY NUMBER,
24 X_Business_Group_Id NUMBER,
25 X_Absence_Attendance_Type_Id NUMBER,
26 X_Abs_Attendance_Reason_Id NUMBER,
27 X_Person_Id NUMBER,
28 X_Authorising_Person_Id NUMBER,
29 X_Replacement_Person_Id NUMBER,
30 X_Period_Of_Incapacity_Id NUMBER,
31 X_Absence_Days NUMBER,
32 X_Absence_Hours NUMBER,
33 X_Comments VARCHAR2,
34 X_Date_End DATE,
35 X_Date_Notification DATE,
36 X_Date_Projected_End DATE,
37 X_Date_Projected_Start DATE,
38 X_Date_Start DATE,
39 X_Occurrence NUMBER,
40 X_Ssp1_Issued VARCHAR2,
41 X_Time_End VARCHAR2,
42 X_Time_Projected_End VARCHAR2,
43 X_Time_Projected_Start VARCHAR2,
44 X_Time_Start VARCHAR2,
45 X_Attribute_Category VARCHAR2,
46 X_Attribute1 VARCHAR2,
47 X_Attribute2 VARCHAR2,
48 X_Attribute3 VARCHAR2,
49 X_Attribute4 VARCHAR2,
50 X_Attribute5 VARCHAR2,
51 X_Attribute6 VARCHAR2,
52 X_Attribute7 VARCHAR2,
53 X_Attribute8 VARCHAR2,
54 X_Attribute9 VARCHAR2,
55 X_Attribute10 VARCHAR2,
56 X_Attribute11 VARCHAR2,
57 X_Attribute12 VARCHAR2,
58 X_Attribute13 VARCHAR2,
59 X_Attribute14 VARCHAR2,
60 X_Attribute15 VARCHAR2,
61 X_Attribute16 VARCHAR2,
62 X_Attribute17 VARCHAR2,
63 X_Attribute18 VARCHAR2,
64 X_Attribute19 VARCHAR2,
65 X_Attribute20 VARCHAR2,
66 X_Linked_Absence_id NUMBER,
67 X_Sickness_Start_Date DATE,
68 X_Sickness_End_Date DATE,
69 X_Accept_Late_Notif_Flag VARCHAR2,
70 X_Reason_For_Late_Notification VARCHAR2,
71 X_Pregnancy_Related_Illness VARCHAR2,
72 X_Maternity_Id NUMBER,
73 X_Batch_Id NUMBER DEFAULT NULL,
74 X_Abs_Information_Category VARCHAR2,
75 X_Abs_Information1 VARCHAR2,
76 X_Abs_Information2 VARCHAR2,
77 X_Abs_Information3 VARCHAR2,
78 X_Abs_Information4 VARCHAR2,
79 X_Abs_Information5 VARCHAR2,
80 X_Abs_Information6 VARCHAR2,
81 X_Abs_Information7 VARCHAR2,
82 X_Abs_Information8 VARCHAR2,
83 X_Abs_Information9 VARCHAR2,
84 X_Abs_Information10 VARCHAR2,
85 X_Abs_Information11 VARCHAR2,
86 X_Abs_Information12 VARCHAR2,
87 X_Abs_Information13 VARCHAR2,
88 X_Abs_Information14 VARCHAR2,
89 X_Abs_Information15 VARCHAR2,
90 X_Abs_Information16 VARCHAR2,
91 X_Abs_Information17 VARCHAR2,
92 X_Abs_Information18 VARCHAR2,
93 X_Abs_Information19 VARCHAR2,
94 X_Abs_Information20 VARCHAR2,
95 X_Abs_Information21 VARCHAR2,
96 X_Abs_Information22 VARCHAR2,
97 X_Abs_Information23 VARCHAR2,
98 X_Abs_Information24 VARCHAR2,
99 X_Abs_Information25 VARCHAR2,
100 X_Abs_Information26 VARCHAR2,
101 X_Abs_Information27 VARCHAR2,
102 X_Abs_Information28 VARCHAR2,
103 X_Abs_Information29 VARCHAR2,
104 X_Abs_Information30 VARCHAR2) ;
105
106 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
107 X_Absence_Attendance_Id NUMBER,
108 X_Business_Group_Id NUMBER,
109 X_Absence_Attendance_Type_Id NUMBER,
110 X_Abs_Attendance_Reason_Id NUMBER,
111 X_Person_Id NUMBER,
112 X_Authorising_Person_Id NUMBER,
113 X_Replacement_Person_Id NUMBER,
114 X_Period_Of_Incapacity_Id NUMBER,
115 X_Absence_Days NUMBER,
116 X_Absence_Hours NUMBER,
117 X_Comments VARCHAR2,
118 X_Date_End DATE,
119 X_Date_Notification DATE,
120 X_Date_Projected_End DATE,
121 X_Date_Projected_Start DATE,
122 X_Date_Start DATE,
123 X_Occurrence NUMBER,
124 X_Ssp1_Issued VARCHAR2,
125 X_Time_End VARCHAR2,
126 X_Time_Projected_End VARCHAR2,
127 X_Time_Projected_Start VARCHAR2,
128 X_Time_Start VARCHAR2,
129 X_Attribute_Category VARCHAR2,
130 X_Attribute1 VARCHAR2,
131 X_Attribute2 VARCHAR2,
132 X_Attribute3 VARCHAR2,
133 X_Attribute4 VARCHAR2,
134 X_Attribute5 VARCHAR2,
135 X_Attribute6 VARCHAR2,
136 X_Attribute7 VARCHAR2,
137 X_Attribute8 VARCHAR2,
138 X_Attribute9 VARCHAR2,
139 X_Attribute10 VARCHAR2,
140 X_Attribute11 VARCHAR2,
141 X_Attribute12 VARCHAR2,
142 X_Attribute13 VARCHAR2,
143 X_Attribute14 VARCHAR2,
144 X_Attribute15 VARCHAR2,
145 X_Attribute16 VARCHAR2,
146 X_Attribute17 VARCHAR2,
147 X_Attribute18 VARCHAR2,
148 X_Attribute19 VARCHAR2,
149 X_Attribute20 VARCHAR2,
150 X_Linked_Absence_id NUMBER,
151 X_Sickness_Start_Date DATE,
152 X_Sickness_End_Date DATE,
153 X_Accept_Late_Notif_Flag VARCHAR2,
154 X_Reason_For_Late_Notification VARCHAR2,
155 X_Pregnancy_Related_Illness VARCHAR2,
156 X_Maternity_Id NUMBER,
157 X_Abs_Information_Category VARCHAR2,
158 X_Abs_Information1 VARCHAR2,
159 X_Abs_Information2 VARCHAR2,
160 X_Abs_Information3 VARCHAR2,
161 X_Abs_Information4 VARCHAR2,
162 X_Abs_Information5 VARCHAR2,
163 X_Abs_Information6 VARCHAR2,
164 X_Abs_Information7 VARCHAR2,
165 X_Abs_Information8 VARCHAR2,
166 X_Abs_Information9 VARCHAR2,
167 X_Abs_Information10 VARCHAR2,
168 X_Abs_Information11 VARCHAR2,
169 X_Abs_Information12 VARCHAR2,
170 X_Abs_Information13 VARCHAR2,
171 X_Abs_Information14 VARCHAR2,
172 X_Abs_Information15 VARCHAR2,
173 X_Abs_Information16 VARCHAR2,
174 X_Abs_Information17 VARCHAR2,
175 X_Abs_Information18 VARCHAR2,
176 X_Abs_Information19 VARCHAR2,
177 X_Abs_Information20 VARCHAR2,
178 X_Abs_Information21 VARCHAR2,
179 X_Abs_Information22 VARCHAR2,
180 X_Abs_Information23 VARCHAR2,
181 X_Abs_Information24 VARCHAR2,
182 X_Abs_Information25 VARCHAR2,
183 X_Abs_Information26 VARCHAR2,
184 X_Abs_Information27 VARCHAR2,
185 X_Abs_Information28 VARCHAR2,
186 X_Abs_Information29 VARCHAR2,
187 X_Abs_Information30 VARCHAR2);
188
189 PROCEDURE Update_Row(X_Rowid VARCHAR2,
190 X_Absence_Attendance_Id NUMBER,
191 X_Business_Group_Id NUMBER,
192 X_Absence_Attendance_Type_Id NUMBER,
193 X_Abs_Attendance_Reason_Id NUMBER,
194 X_Person_Id NUMBER,
195 X_Authorising_Person_Id NUMBER,
196 X_Replacement_Person_Id NUMBER,
197 X_Period_Of_Incapacity_Id NUMBER,
198 X_Absence_Days NUMBER,
199 X_Absence_Hours NUMBER,
200 X_Comments VARCHAR2,
201 X_Date_End DATE,
202 X_Date_Notification DATE,
203 X_Date_Projected_End DATE,
204 X_Date_Projected_Start DATE,
205 X_Date_Start DATE,
206 X_Occurrence NUMBER,
207 X_Ssp1_Issued VARCHAR2,
208 X_Time_End VARCHAR2,
209 X_Time_Projected_End VARCHAR2,
210 X_Time_Projected_Start VARCHAR2,
211 X_Time_Start VARCHAR2,
212 X_Attribute_Category VARCHAR2,
213 X_Attribute1 VARCHAR2,
214 X_Attribute2 VARCHAR2,
215 X_Attribute3 VARCHAR2,
216 X_Attribute4 VARCHAR2,
217 X_Attribute5 VARCHAR2,
218 X_Attribute6 VARCHAR2,
219 X_Attribute7 VARCHAR2,
220 X_Attribute8 VARCHAR2,
221 X_Attribute9 VARCHAR2,
222 X_Attribute10 VARCHAR2,
223 X_Attribute11 VARCHAR2,
224 X_Attribute12 VARCHAR2,
225 X_Attribute13 VARCHAR2,
226 X_Attribute14 VARCHAR2,
227 X_Attribute15 VARCHAR2,
228 X_Attribute16 VARCHAR2,
229 X_Attribute17 VARCHAR2,
230 X_Attribute18 VARCHAR2,
231 X_Attribute19 VARCHAR2,
232 X_Attribute20 VARCHAR2,
233 X_Linked_Absence_id NUMBER,
234 X_Sickness_Start_Date DATE,
235 X_Sickness_End_Date DATE,
236 X_Accept_Late_Notif_Flag VARCHAR2,
237 X_Reason_For_Late_Notification VARCHAR2,
238 X_Pregnancy_Related_Illness VARCHAR2,
239 X_Maternity_Id NUMBER,
240 X_Abs_Information_Category VARCHAR2,
241 X_Abs_Information1 VARCHAR2,
242 X_Abs_Information2 VARCHAR2,
243 X_Abs_Information3 VARCHAR2,
244 X_Abs_Information4 VARCHAR2,
245 X_Abs_Information5 VARCHAR2,
246 X_Abs_Information6 VARCHAR2,
247 X_Abs_Information7 VARCHAR2,
248 X_Abs_Information8 VARCHAR2,
249 X_Abs_Information9 VARCHAR2,
250 X_Abs_Information10 VARCHAR2,
251 X_Abs_Information11 VARCHAR2,
252 X_Abs_Information12 VARCHAR2,
253 X_Abs_Information13 VARCHAR2,
254 X_Abs_Information14 VARCHAR2,
255 X_Abs_Information15 VARCHAR2,
256 X_Abs_Information16 VARCHAR2,
260 X_Abs_Information20 VARCHAR2,
257 X_Abs_Information17 VARCHAR2,
258 X_Abs_Information18 VARCHAR2,
259 X_Abs_Information19 VARCHAR2,
261 X_Abs_Information21 VARCHAR2,
262 X_Abs_Information22 VARCHAR2,
263 X_Abs_Information23 VARCHAR2,
264 X_Abs_Information24 VARCHAR2,
265 X_Abs_Information25 VARCHAR2,
266 X_Abs_Information26 VARCHAR2,
267 X_Abs_Information27 VARCHAR2,
268 X_Abs_Information28 VARCHAR2,
269 X_Abs_Information29 VARCHAR2,
270 X_Abs_Information30 VARCHAR2);
271
272 PROCEDURE Delete_Row(X_Rowid VARCHAR2);
273
274 PROCEDURE Delete_Row(X_Rowid VARCHAR2, p_maternity_id in number);
275
276 procedure b_check_auth_de(p_date_start IN DATE,
277 p_proj_start IN DATE,
278 p_date_end IN DATE,
279 p_proj_end IN DATE,
280 p_sess In DATE,
281 p_auth_id IN NUMBER);
282
283 procedure b_check_rep_de(p_date_start In DATE,
284 p_date_proj_start IN DATE,
285 p_date_end IN DATE,
286 p_date_proj_end IN DATE,
287 p_sess IN DATE,
288 p_rep_id IN NUMBER);
289
290 function check_for_term(p_date IN DATE,
291 p_rep_per IN NUMBER) RETURN BOOLEAN;
292
293 function chk_rep_req(p_psn_id IN NUMBER,
294 p_dstart IN DATE,
295 p_proj_start IN DATE,
296 p_sess IN DATE) RETURN BOOLEAN;
297
298 procedure chk_type(p_abat_type In NUMBER,
299 p_dstart IN DATE,
300 p_eot IN DATE,
301 p_dend IN DATE,
302 p_abs_from IN DATE,
303 p_abs_to IN DATE);
304
305 procedure chk_proj(p_abat_type IN NUMBER,
306 p_proj_start IN DATE,
307 p_eot IN DATE,
308 p_proj_end IN DATE);
309
310 function chkab1(p_abat_id IN NUMBER,
311 p_per_id IN NUMBER,
312 p_abat_type In NUMBER,
313 p_dstart IN DATE) RETURN BOOLEAN;
314
315 procedure chkab2(p_abat_id IN NUMBER,
316 p_per_id IN NUMBER,
317 p_abat_type IN NUMBER,
318 p_dstart IN DATE,
319 p_dend IN DATE,
320 p_eot IN DATE);
321
322 function chkab3(p_abat_id IN NUMBER,
323 p_per_id IN NUMBER,
324 p_abat_type IN NUMBER,
325 p_dstart IN DATE,
326 p_dend In DATE,
327 p_eot IN DATE) RETURN BOOLEAN;
328
329 procedure b_elmnt_entry_dets(p_per_id IN NUMBER,
330 p_sdstart IN DATE,
331 p_abat_id IN NUMBER,
332 p_e_entry_id IN OUT NOCOPY NUMBER,
333 p_e_link_id IN OUT NOCOPY NUMBER,
334 p_cpay_id IN OUT NOCOPY NUMBER,
335 p_period_sdate IN OUT NOCOPY DATE,
336 p_period_edate IN OUT NOCOPY DATE);
337
338 procedure b_get_category(p_mean IN OUT NOCOPY VARCHAR2,
339 p_abcat IN VARCHAR2);
340
341 procedure get_defaults(p_tend IN VARCHAR2,
342 p_tstart IN VARCHAR2,
343 p_dend IN DATE,
344 p_dstart IN DATE,
345 p_hrs_def IN OUT NOCOPY NUMBER,
346 p_dys_hrs IN OUT NOCOPY NUMBER,
347 p_dys_def IN OUT NOCOPY NUMBER);
348
349 procedure get_ele_det1(p_bgroup_id IN NUMBER,
350 p_eltype IN NUMBER,
351 p_per_id IN NUMBER,
352 p_dstart IN DATE,
353 p_sess IN DATE,
354 p_ass_id IN OUT NOCOPY NUMBER,
355 p_ele_link IN OUT NOCOPY NUMBER,
356 p_pay_id IN OUT NOCOPY NUMBER,
357 p_test IN OUT NOCOPY VARCHAR2);
358
359 procedure get_ele_det2(p_eletype IN NUMBER,
360 p_abat_type IN NUMBER,
361 p_dstart IN DATE,
362 p_dele_name IN OUT NOCOPY VARCHAR2);
363
364 procedure get_period_dates(p_cpay_id IN NUMBER,
365 p_dstart In DATE,
366 p_prd_start IN OUT NOCOPY DATE,
367 p_prd_end IN OUT NOCOPY DATE,
368 p_test IN OUT NOCOPY VARCHAR2);
369
370 procedure get_run_tot(p_abat_type IN NUMBER,
371 p_per_id IN NUMBER,
372 p_db_itm IN OUT NOCOPY VARCHAR2,
373 p_ass_id IN OUT NOCOPY NUMBER);
374
375 function get_annual_balance(p_session_date IN DATE,
376 p_abs_type_id IN NUMBER,
377 p_ass_id IN NUMBER)return NUMBER;
378
379 function is_emp_entitled (p_abs_att_type_id NUMBER,
380 p_ass_id NUMBER,
381 p_calculation_date DATE,
385
382 p_days_requested NUMBER,
383 p_hours_requested NUMBER)
384 return boolean;
386 procedure init_form(p_form_type IN OUT NOCOPY NUMBER,
387 p_per_id IN NUMBER,
388 p_sess IN DATE,
389 p_dstart IN OUT NOCOPY DATE,
390 p_dend IN OUT NOCOPY DATE);
391
392 procedure ins_ok(p_per_id IN NUMBER,
393 p_test IN OUT NOCOPY VARCHAR2);
394
395 procedure get_occur(p_bgroup_id IN NUMBER,
396 p_abat_type IN NUMBER,
397 p_per_id IN NUMBER,
398 p_occur IN OUT NOCOPY NUMBER);
399
400 function chk_serv_period(p_per_id in number,
401 p_curr_date_end in date,
402 p_proj_start in date) RETURN BOOLEAN;
403
404 procedure reset_MPP_start_date_on_delete
405 (
406 p_maternity_id in number
407 );
408
409 procedure get_mat_details
410 (
411 p_maternity_id in number,
412 p_due_date in out nocopy date,
413 p_mpp_start_date in out nocopy date,
414 p_earliest_abs_start_date in out nocopy date,
415 p_earliest_abs_rowid in out nocopy varchar2,
416 p_nos_absences in out nocopy number
417 );
418
419 Function get_due_date (p_maternity_id in number) return date;
420
421 Procedure check_val_abs_start (p_date_start in date,
422 p_maternity_id in number);
423
424 Procedure check_related_maternity (p_person_id in number);
425
426 Procedure check_evd_before_del(p_absence_attendance_id in number,
427 p_medical_type in varchar2);
428
429 Function late_abs_notification (p_date_notification in date,
430 p_date_start in date,
431 p_effective_date in date,
432 p_element_name in varchar2) return
433 boolean;
434
435 Function get_due_date_2 (p_person_id in number,
436 p_leave_type in varchar2,
437 p_smp_due_date in out nocopy date) return BOOLEAN;
438
439 Procedure default_MPP_start_date (p_maternity_id IN NUMBER,
440 p_start_date IN DATE,
441 p_end_date IN DATE);
442 --
443 end PER_ABSENCE_ATTENDANCES_PKG;