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