1 PACKAGE HR_LOA_SS
2 /* $Header: hrloawrs.pkh 120.4 2011/11/15 11:55:57 sidsaxen ship $*/
3 AUTHID CURRENT_USER AS
4 /*
5 ||===========================================================================
6 || PROCEDURE: create_person_absence
7 ||---------------------------------------------------------------------------
8 ||
9 || Description:
10 || This procedure will call the actual API -
11 || hr_person_absence_api.create_person_absence()
12 ||
13 || Access Status:
14 || Public.
15 ||
16 ||===========================================================================
17 */
18 PROCEDURE create_person_absence
19 (p_validate in number default 0
20 ,p_effective_date in date
21 ,p_person_id in number
22 ,p_business_group_id in number
23 ,p_absence_attendance_type_id in number
24 ,p_abs_attendance_reason_id in number default null
25 ,p_comments in clob default null -- Bug#13362792
29 ,p_date_projected_end in date default null
26 ,p_date_notification in date default null
27 ,p_date_projected_start in date default null
28 ,p_time_projected_start in varchar2 default null
30 ,p_time_projected_end in date default null
31 ,p_date_start in date default null
32 ,p_time_start in varchar2 default null
33 ,p_date_end in date default null
34 ,p_time_end in varchar2 default null
35 ,p_absence_days in out nocopy number
36 ,p_absence_hours in out nocopy number
37 ,p_authorising_person_id in number default null
38 ,p_replacement_person_id in number default null
39 ,p_attribute_category in varchar2 default null
40 ,p_attribute1 in varchar2 default null
41 ,p_attribute2 in varchar2 default null
42 ,p_attribute3 in varchar2 default null
43 ,p_attribute4 in varchar2 default null
44 ,p_attribute5 in varchar2 default null
45 ,p_attribute6 in varchar2 default null
46 ,p_attribute7 in varchar2 default null
47 ,p_attribute8 in varchar2 default null
48 ,p_attribute9 in varchar2 default null
49 ,p_attribute10 in varchar2 default null
50 ,p_attribute11 in varchar2 default null
51 ,p_attribute12 in varchar2 default null
52 ,p_attribute13 in varchar2 default null
53 ,p_attribute14 in varchar2 default null
54 ,p_attribute15 in varchar2 default null
55 ,p_attribute16 in varchar2 default null
56 ,p_attribute17 in varchar2 default null
57 ,p_attribute18 in varchar2 default null
58 ,p_attribute19 in varchar2 default null
59 ,p_attribute20 in varchar2 default null
60 ,p_period_of_incapacity_id in number default null
61 ,p_ssp1_issued in varchar2 default 'N'
62 ,p_maternity_id in number default null
63 ,p_sickness_start_date in date default null
64 ,p_sickness_end_date in date default null
65 ,p_pregnancy_related_illness in varchar2 default 'N'
66 ,p_reason_for_notification_dela in varchar2 default null
67 ,p_accept_late_notification_fla in varchar2 default 'N'
68 ,p_linked_absence_id in number default null
69 ,p_abs_information_category in varchar2 default null
70 ,p_abs_information1 in varchar2 default null
71 ,p_abs_information2 in varchar2 default null
72 ,p_abs_information3 in varchar2 default null
73 ,p_abs_information4 in varchar2 default null
74 ,p_abs_information5 in varchar2 default null
75 ,p_abs_information6 in varchar2 default null
76 ,p_abs_information7 in varchar2 default null
77 ,p_abs_information8 in varchar2 default null
78 ,p_abs_information9 in varchar2 default null
79 ,p_abs_information10 in varchar2 default null
80 ,p_abs_information11 in varchar2 default null
81 ,p_abs_information12 in varchar2 default null
82 ,p_abs_information13 in varchar2 default null
83 ,p_abs_information14 in varchar2 default null
84 ,p_abs_information15 in varchar2 default null
85 ,p_abs_information16 in varchar2 default null
86 ,p_abs_information17 in varchar2 default null
87 ,p_abs_information18 in varchar2 default null
88 ,p_abs_information19 in varchar2 default null
89 ,p_abs_information20 in varchar2 default null
90 ,p_abs_information21 in varchar2 default null
91 ,p_abs_information22 in varchar2 default null
92 ,p_abs_information23 in varchar2 default null
93 ,p_abs_information24 in varchar2 default null
94 ,p_abs_information25 in varchar2 default null
95 ,p_abs_information26 in varchar2 default null
96 ,p_abs_information27 in varchar2 default null
97 ,p_abs_information28 in varchar2 default null
98 ,p_abs_information29 in varchar2 default null
99 ,p_abs_information30 in varchar2 default null
100 ,p_absence_attendance_id out nocopy number
101 ,p_object_version_number out nocopy number
102 ,p_occurrence out nocopy number
103 ,p_dur_dys_less_warning out nocopy number
104 ,p_dur_hrs_less_warning out nocopy number
105 ,p_exceeds_pto_entit_warning out nocopy number
106 ,p_exceeds_run_total_warning out nocopy number
107 ,p_abs_overlap_warning out nocopy number
108 ,p_abs_day_after_warning out nocopy number
109 ,p_dur_overwritten_warning out nocopy number
110 );
111
112
113 /*
114 ||===========================================================================
115 || PROCEDURE: update_person_absence
116 ||---------------------------------------------------------------------------
117 ||
118 || Description:
119 || This procedure will call the actual API -
120 || hr_person_absence_api.update_person_absence()
121 ||
125 ||===========================================================================
122 || Access Status:
123 || Public.
124 ||
126 */
127 PROCEDURE update_person_absence
128 (p_validate in number default 0
129 ,p_effective_date in date
130 ,p_business_group_id in number
131 ,p_absence_attendance_id in number
132 ,p_abs_attendance_reason_id in number default hr_api.g_number
133 ,p_comments in clob default hr_api.g_varchar2 -- Bug#13362792
134 ,p_date_notification in date default hr_api.g_date
135 ,p_date_projected_start in date default hr_api.g_date
136 ,p_time_projected_start in varchar2 default hr_api.g_varchar2
137 ,p_date_projected_end in date default hr_api.g_date
138 ,p_time_projected_end in varchar2 default hr_api.g_varchar2
139 ,p_date_start in date default hr_api.g_date
140 ,p_time_start in varchar2 default hr_api.g_varchar2
141 ,p_date_end in date default hr_api.g_date
142 ,p_time_end in varchar2 default hr_api.g_varchar2
143 ,p_absence_days in out nocopy number
144 ,p_absence_hours in out nocopy number
145 ,p_authorising_person_id in number default hr_api.g_number
146 ,p_replacement_person_id in number default hr_api.g_number
147 ,p_attribute_category in varchar2 default hr_api.g_varchar2
148 ,p_attribute1 in varchar2 default hr_api.g_varchar2
149 ,p_attribute2 in varchar2 default hr_api.g_varchar2
150 ,p_attribute3 in varchar2 default hr_api.g_varchar2
151 ,p_attribute4 in varchar2 default hr_api.g_varchar2
152 ,p_attribute5 in varchar2 default hr_api.g_varchar2
153 ,p_attribute6 in varchar2 default hr_api.g_varchar2
154 ,p_attribute7 in varchar2 default hr_api.g_varchar2
155 ,p_attribute8 in varchar2 default hr_api.g_varchar2
156 ,p_attribute9 in varchar2 default hr_api.g_varchar2
157 ,p_attribute10 in varchar2 default hr_api.g_varchar2
158 ,p_attribute11 in varchar2 default hr_api.g_varchar2
159 ,p_attribute12 in varchar2 default hr_api.g_varchar2
160 ,p_attribute13 in varchar2 default hr_api.g_varchar2
161 ,p_attribute14 in varchar2 default hr_api.g_varchar2
162 ,p_attribute15 in varchar2 default hr_api.g_varchar2
163 ,p_attribute16 in varchar2 default hr_api.g_varchar2
164 ,p_attribute17 in varchar2 default hr_api.g_varchar2
165 ,p_attribute18 in varchar2 default hr_api.g_varchar2
166 ,p_attribute19 in varchar2 default hr_api.g_varchar2
167 ,p_attribute20 in varchar2 default hr_api.g_varchar2
168 ,p_period_of_incapacity_id in number default hr_api.g_number
169 ,p_ssp1_issued in varchar2 default hr_api.g_varchar2
170 ,p_maternity_id in number default hr_api.g_number
171 ,p_sickness_start_date in date default hr_api.g_date
172 ,p_sickness_end_date in date default hr_api.g_date
173 ,p_pregnancy_related_illness in varchar2 default hr_api.g_varchar2
174 ,p_reason_for_notification_dela in varchar2 default hr_api.g_varchar2
175 ,p_accept_late_notification_fla in varchar2 default hr_api.g_varchar2
176 ,p_linked_absence_id in number default hr_api.g_number
177 ,p_object_version_number in out nocopy number
178 ,p_abs_information_category in varchar2 default null
179 ,p_abs_information1 in varchar2 default null
180 ,p_abs_information2 in varchar2 default null
181 ,p_abs_information3 in varchar2 default null
182 ,p_abs_information4 in varchar2 default null
183 ,p_abs_information5 in varchar2 default null
184 ,p_abs_information6 in varchar2 default null
185 ,p_abs_information7 in varchar2 default null
186 ,p_abs_information8 in varchar2 default null
187 ,p_abs_information9 in varchar2 default null
188 ,p_abs_information10 in varchar2 default null
189 ,p_abs_information11 in varchar2 default null
190 ,p_abs_information12 in varchar2 default null
191 ,p_abs_information13 in varchar2 default null
192 ,p_abs_information14 in varchar2 default null
193 ,p_abs_information15 in varchar2 default null
194 ,p_abs_information16 in varchar2 default null
195 ,p_abs_information17 in varchar2 default null
196 ,p_abs_information18 in varchar2 default null
197 ,p_abs_information19 in varchar2 default null
198 ,p_abs_information20 in varchar2 default null
199 ,p_abs_information21 in varchar2 default null
200 ,p_abs_information22 in varchar2 default null
201 ,p_abs_information23 in varchar2 default null
202 ,p_abs_information24 in varchar2 default null
203 ,p_abs_information25 in varchar2 default null
204 ,p_abs_information26 in varchar2 default null
205 ,p_abs_information27 in varchar2 default null
206 ,p_abs_information28 in varchar2 default null
207 ,p_abs_information29 in varchar2 default null
208 ,p_abs_information30 in varchar2 default null
212 ,p_exceeds_run_total_warning out nocopy number
209 ,p_dur_dys_less_warning out nocopy number
210 ,p_dur_hrs_less_warning out nocopy number
211 ,p_exceeds_pto_entit_warning out nocopy number
213 ,p_abs_overlap_warning out nocopy number
214 ,p_abs_day_after_warning out nocopy number
215 ,p_dur_overwritten_warning out nocopy number
216 ,p_del_element_entry_warning out nocopy number
217 );
218
219 /*
220 ||===========================================================================
221 || PROCEDURE: create_transaction
222 ||---------------------------------------------------------------------------
223 ||
224 || Description:
225 || This procedure will create a transaction for absence
226 || hr_api_transaction and hr_api_transaction_steps
227 ||
228 || Access Status:
229 || Public.
230 ||
231 ||===========================================================================
232 */
233 PROCEDURE create_transaction(
234 p_item_type IN WF_ITEMS.ITEM_TYPE%TYPE ,
235 p_item_key IN WF_ITEMS.ITEM_KEY%TYPE ,
236 p_act_id IN NUMBER ,
237 p_activity_name IN VARCHAR2,
238 p_transaction_id IN OUT NOCOPY NUMBER ,
239 p_transaction_step_id IN OUT NOCOPY NUMBER,
240 p_login_person_id IN NUMBER,
241 p_review_proc_call IN VARCHAR2
242 ) ;
243
244 /*
245 ||===========================================================================
246 || PROCEDURE: write_transaction
247 ||---------------------------------------------------------------------------
248 ||
249 || Description:
250 || This procedure will store absence information into
251 || hr_api_transaction_values
252 ||
253 || Access Status:
254 || Public.
255 ||
256 ||===========================================================================
257 */
258 PROCEDURE write_transaction (
259 p_transaction_step_id in NUMBER
260 ,p_validate in NUMBER default 0
261 ,p_effective_date in Date
262 ,p_person_id in NUMBER default NULL
263 ,p_business_group_id in NUMBER default NULL
264 ,p_absence_attendance_type_id in NUMBER default NULL
265 ,p_abs_attendance_reason_id in NUMBER default NULL
266 ,p_comments in clob -- Bug#13362792
267 ,p_date_notification in Date
268 ,p_projected_start_date in Date
269 ,p_projected_start_time in varchar2
270 ,p_projected_end_date in Date
271 ,p_projected_end_time in varchar2
272 ,p_start_date in Date
273 ,p_start_time in VARCHAR2
274 ,p_end_date in Date
275 ,p_end_time in VARCHAR2
276 ,p_days in VARCHAR2
277 ,p_hours in VARCHAR2
278 ,p_authorising_id in NUMBER default NULL
279 ,p_replacement_id in NUMBER default NULL
280 ,p_attribute_category in varchar2 default null
281 ,p_attribute1 in varchar2 default null
282 ,p_attribute2 in varchar2 default null
283 ,p_attribute3 in varchar2 default null
284 ,p_attribute4 in varchar2 default null
285 ,p_attribute5 in varchar2 default null
286 ,p_attribute6 in varchar2 default null
287 ,p_attribute7 in varchar2 default null
288 ,p_attribute8 in varchar2 default null
289 ,p_attribute9 in varchar2 default null
290 ,p_attribute10 in varchar2 default null
291 ,p_attribute11 in varchar2 default null
292 ,p_attribute12 in varchar2 default null
293 ,p_attribute13 in varchar2 default null
294 ,p_attribute14 in varchar2 default null
295 ,p_attribute15 in varchar2 default null
296 ,p_attribute16 in varchar2 default null
297 ,p_attribute17 in varchar2 default null
298 ,p_attribute18 in varchar2 default null
299 ,p_attribute19 in varchar2 default null
300 ,p_attribute20 in varchar2 default null
301 ,p_abs_information_category in varchar2 default null
302 ,p_abs_information1 in varchar2 default null
303 ,p_abs_information2 in varchar2 default null
304 ,p_abs_information3 in varchar2 default null
305 ,p_abs_information4 in varchar2 default null
306 ,p_abs_information5 in varchar2 default null
307 ,p_abs_information6 in varchar2 default null
308 ,p_abs_information7 in varchar2 default null
309 ,p_abs_information8 in varchar2 default null
310 ,p_abs_information9 in varchar2 default null
311 ,p_abs_information10 in varchar2 default null
312 ,p_abs_information11 in varchar2 default null
313 ,p_abs_information12 in varchar2 default null
314 ,p_abs_information13 in varchar2 default null
315 ,p_abs_information14 in varchar2 default null
316 ,p_abs_information15 in varchar2 default null
317 ,p_abs_information16 in varchar2 default null
318 ,p_abs_information17 in varchar2 default null
319 ,p_abs_information18 in varchar2 default null
320 ,p_abs_information19 in varchar2 default null
321 ,p_abs_information20 in varchar2 default null
322 ,p_abs_information21 in varchar2 default null
323 ,p_abs_information22 in varchar2 default null
324 ,p_abs_information23 in varchar2 default null
325 ,p_abs_information24 in varchar2 default null
326 ,p_abs_information25 in varchar2 default null
327 ,p_abs_information26 in varchar2 default null
331 ,p_abs_information30 in varchar2 default null
328 ,p_abs_information27 in varchar2 default null
329 ,p_abs_information28 in varchar2 default null
330 ,p_abs_information29 in varchar2 default null
332 );
333
334
335 /*
336 ||===========================================================================
337 || PROCEDURE: get_absence_transaction
338 ||---------------------------------------------------------------------------
339 ||
340 || Description:
341 || Reads Absence Transaction from transaction table
342 ||
343 || Access Status:
344 || Public.
345 ||
346 ||===========================================================================
347 */
348 procedure get_absence_transaction
349 (p_transaction_step_id IN VARCHAR2,
350 p_effective_date OUT NOCOPY VARCHAR2,
351 p_person_id OUT NOCOPY VARCHAR2,
352 p_absence_attendance_type_id OUT NOCOPY VARCHAR2,
353 p_abs_attendance_reason_id OUT NOCOPY VARCHAR2,
354 p_comments OUT NOCOPY VARCHAR2,
355 p_date_notification OUT NOCOPY VARCHAR2,
356 p_authorising_id OUT NOCOPY VARCHAR2,
357 p_replacement_id OUT NOCOPY VARCHAR2,
358 p_projected_start_date OUT NOCOPY VARCHAR2,
359 p_projected_start_time OUT NOCOPY VARCHAR2,
360 p_projected_end_date OUT NOCOPY VARCHAR2,
361 p_projected_end_time OUT NOCOPY VARCHAR2,
362 p_start_date OUT NOCOPY VARCHAR2,
363 p_start_time OUT NOCOPY VARCHAR2,
364 p_end_date OUT NOCOPY VARCHAR2,
365 p_end_time OUT NOCOPY VARCHAR2,
366 p_days OUT NOCOPY VARCHAR2,
367 p_hours OUT NOCOPY VARCHAR2,
368 p_start_ampm OUT NOCOPY VARCHAR2,
369 p_end_ampm OUT NOCOPY VARCHAR2,
370 p_attribute_category OUT NOCOPY VARCHAR2,
371 p_attribute1 OUT NOCOPY VARCHAR2,
372 p_attribute2 OUT NOCOPY VARCHAR2,
373 p_attribute3 OUT NOCOPY VARCHAR2,
374 p_attribute4 OUT NOCOPY VARCHAR2,
375 p_attribute5 OUT NOCOPY VARCHAR2,
376 p_attribute6 OUT NOCOPY VARCHAR2,
377 p_attribute7 OUT NOCOPY VARCHAR2,
378 p_attribute8 OUT NOCOPY VARCHAR2,
379 p_attribute9 OUT NOCOPY VARCHAR2,
380 p_attribute10 OUT NOCOPY VARCHAR2,
381 p_attribute11 OUT NOCOPY VARCHAR2,
382 p_attribute12 OUT NOCOPY VARCHAR2,
383 p_attribute13 OUT NOCOPY VARCHAR2,
384 p_attribute14 OUT NOCOPY VARCHAR2,
385 p_attribute15 OUT NOCOPY VARCHAR2,
386 p_attribute16 OUT NOCOPY VARCHAR2,
387 p_attribute17 OUT NOCOPY VARCHAR2,
388 p_attribute18 OUT NOCOPY VARCHAR2,
389 p_attribute19 OUT NOCOPY VARCHAR2,
390 p_attribute20 OUT NOCOPY VARCHAR2,
391 p_absence_attendance_id OUT NOCOPY VARCHAR2,
392 p_review_actid OUT NOCOPY VARCHAR2,
393 p_review_proc_call OUT NOCOPY VARCHAR2,
394 p_abs_information_category OUT NOCOPY VARCHAR2,
395 p_abs_information1 OUT NOCOPY VARCHAR2,
396 p_abs_information2 OUT NOCOPY VARCHAR2,
397 p_abs_information3 OUT NOCOPY VARCHAR2,
398 p_abs_information4 OUT NOCOPY VARCHAR2,
399 p_abs_information5 OUT NOCOPY VARCHAR2,
400 p_abs_information6 OUT NOCOPY VARCHAR2,
401 p_abs_information7 OUT NOCOPY VARCHAR2,
402 p_abs_information8 OUT NOCOPY VARCHAR2,
403 p_abs_information9 OUT NOCOPY VARCHAR2,
404 p_abs_information10 OUT NOCOPY VARCHAR2,
405 p_abs_information11 OUT NOCOPY VARCHAR2,
406 p_abs_information12 OUT NOCOPY VARCHAR2,
407 p_abs_information13 OUT NOCOPY VARCHAR2,
408 p_abs_information14 OUT NOCOPY VARCHAR2,
409 p_abs_information15 OUT NOCOPY VARCHAR2,
410 p_abs_information16 OUT NOCOPY VARCHAR2,
411 p_abs_information17 OUT NOCOPY VARCHAR2,
412 p_abs_information18 OUT NOCOPY VARCHAR2,
413 p_abs_information19 OUT NOCOPY VARCHAR2,
414 p_abs_information20 OUT NOCOPY VARCHAR2,
415 p_abs_information21 OUT NOCOPY VARCHAR2,
416 p_abs_information22 OUT NOCOPY VARCHAR2,
417 p_abs_information23 OUT NOCOPY VARCHAR2,
418 p_abs_information24 OUT NOCOPY VARCHAR2,
419 p_abs_information25 OUT NOCOPY VARCHAR2,
420 p_abs_information26 OUT NOCOPY VARCHAR2,
421 p_abs_information27 OUT NOCOPY VARCHAR2,
422 p_abs_information28 OUT NOCOPY VARCHAR2,
423 p_abs_information29 OUT NOCOPY VARCHAR2,
424 p_abs_information30 OUT NOCOPY VARCHAR2,
425 p_leave_status OUT NOCOPY VARCHAR2,
426 p_save_mode OUT NOCOPY VARCHAR2,
427 p_activity_name OUT NOCOPY VARCHAR2,
428 p_business_group_id OUT NOCOPY VARCHAR2,
429 p_object_version_number OUT NOCOPY VARCHAR2 --2793220
430 ) ;
431
432
433 /*
434 ||===========================================================================
435 || PROCEDURE: get_return_transaction
436 ||---------------------------------------------------------------------------
437 ||
438 || Description:
442 || Access Status:
439 || This procedure will retrieve confirm return information from
440 || trensaction table
441 ||
443 || Public.
444 ||
445 ||===========================================================================
446 */
447 procedure get_return_transaction
448 (p_transaction_step_id IN VARCHAR2
449 ,p_effective_date OUT NOCOPY VARCHAR2
450 ,p_start_date OUT NOCOPY VARCHAR2
451 ,p_start_time OUT NOCOPY VARCHAR2
452 ,p_end_date OUT NOCOPY VARCHAR2
453 ,p_end_time OUT NOCOPY VARCHAR2
454 ,p_days OUT NOCOPY VARCHAR2
455 ,p_hours OUT NOCOPY VARCHAR2
456 ,p_review_actid OUT NOCOPY VARCHAR2
457 ,p_review_proc_call OUT NOCOPY VARCHAR2
458 ,p_attribute_category OUT NOCOPY VARCHAR2
459 ,p_attribute1 OUT NOCOPY VARCHAR2
460 ,p_attribute2 OUT NOCOPY VARCHAR2
461 ,p_attribute3 OUT NOCOPY VARCHAR2
462 ,p_attribute4 OUT NOCOPY VARCHAR2
463 ,p_attribute5 OUT NOCOPY VARCHAR2
464 ,p_attribute6 OUT NOCOPY VARCHAR2
465 ,p_attribute7 OUT NOCOPY VARCHAR2
466 ,p_attribute8 OUT NOCOPY VARCHAR2
467 ,p_attribute9 OUT NOCOPY VARCHAR2
468 ,p_attribute10 OUT NOCOPY VARCHAR2
469 ,p_attribute11 OUT NOCOPY VARCHAR2
470 ,p_attribute12 OUT NOCOPY VARCHAR2
471 ,p_attribute13 OUT NOCOPY VARCHAR2
472 ,p_attribute14 OUT NOCOPY VARCHAR2
473 ,p_attribute15 OUT NOCOPY VARCHAR2
474 ,p_attribute16 OUT NOCOPY VARCHAR2
475 ,p_attribute17 OUT NOCOPY VARCHAR2
476 ,p_attribute18 OUT NOCOPY VARCHAR2
477 ,p_attribute19 OUT NOCOPY VARCHAR2
478 ,p_attribute20 OUT NOCOPY VARCHAR2
479 ,p_abs_information_category OUT NOCOPY VARCHAR2
480 ,p_abs_information1 OUT NOCOPY VARCHAR2
481 ,p_abs_information2 OUT NOCOPY VARCHAR2
482 ,p_abs_information3 OUT NOCOPY VARCHAR2
483 ,p_abs_information4 OUT NOCOPY VARCHAR2
484 ,p_abs_information5 OUT NOCOPY VARCHAR2
485 ,p_abs_information6 OUT NOCOPY VARCHAR2
486 ,p_abs_information7 OUT NOCOPY VARCHAR2
487 ,p_abs_information8 OUT NOCOPY VARCHAR2
488 ,p_abs_information9 OUT NOCOPY VARCHAR2
489 ,p_abs_information10 OUT NOCOPY VARCHAR2
490 ,p_abs_information11 OUT NOCOPY VARCHAR2
491 ,p_abs_information12 OUT NOCOPY VARCHAR2
492 ,p_abs_information13 OUT NOCOPY VARCHAR2
493 ,p_abs_information14 OUT NOCOPY VARCHAR2
494 ,p_abs_information15 OUT NOCOPY VARCHAR2
495 ,p_abs_information16 OUT NOCOPY VARCHAR2
496 ,p_abs_information17 OUT NOCOPY VARCHAR2
497 ,p_abs_information18 OUT NOCOPY VARCHAR2
498 ,p_abs_information19 OUT NOCOPY VARCHAR2
499 ,p_abs_information20 OUT NOCOPY VARCHAR2
500 ,p_abs_information21 OUT NOCOPY VARCHAR2
501 ,p_abs_information22 OUT NOCOPY VARCHAR2
502 ,p_abs_information23 OUT NOCOPY VARCHAR2
503 ,p_abs_information24 OUT NOCOPY VARCHAR2
504 ,p_abs_information25 OUT NOCOPY VARCHAR2
505 ,p_abs_information26 OUT NOCOPY VARCHAR2
506 ,p_abs_information27 OUT NOCOPY VARCHAR2
507 ,p_abs_information28 OUT NOCOPY VARCHAR2
508 ,p_abs_information29 OUT NOCOPY VARCHAR2
509 ,p_abs_information30 OUT NOCOPY VARCHAR2
510 ) ;
511
512
513 /*
514 ||===========================================================================
515 || PROCEDURE: get_update_transaction
516 ||---------------------------------------------------------------------------
517 ||
518 || Description:
519 || This procedure will retrieve update information from
520 || trensaction table
521 ||
522 || Access Status:
523 || Public.
524 ||
525 ||===========================================================================
526 */
527 procedure get_update_transaction
528 (p_transaction_step_id IN VARCHAR2
529 ,p_effective_date OUT NOCOPY VARCHAR2
530 ,p_projected_start_date OUT NOCOPY VARCHAR2
531 ,p_projected_start_time OUT NOCOPY VARCHAR2
532 ,p_projected_end_date OUT NOCOPY VARCHAR2
533 ,p_projected_end_time OUT NOCOPY VARCHAR2
534 ,p_days OUT NOCOPY VARCHAR2
535 ,p_hours OUT NOCOPY VARCHAR2
536 ,p_review_actid OUT NOCOPY VARCHAR2
537 ,p_review_proc_call OUT NOCOPY VARCHAR2
538 ,p_attribute_category OUT NOCOPY VARCHAR2
539 ,p_attribute1 OUT NOCOPY VARCHAR2
540 ,p_attribute2 OUT NOCOPY VARCHAR2
541 ,p_attribute3 OUT NOCOPY VARCHAR2
542 ,p_attribute4 OUT NOCOPY VARCHAR2
543 ,p_attribute5 OUT NOCOPY VARCHAR2
544 ,p_attribute6 OUT NOCOPY VARCHAR2
545 ,p_attribute7 OUT NOCOPY VARCHAR2
546 ,p_attribute8 OUT NOCOPY VARCHAR2
547 ,p_attribute9 OUT NOCOPY VARCHAR2
548 ,p_attribute10 OUT NOCOPY VARCHAR2
549 ,p_attribute11 OUT NOCOPY VARCHAR2
550 ,p_attribute12 OUT NOCOPY VARCHAR2
551 ,p_attribute13 OUT NOCOPY VARCHAR2
552 ,p_attribute14 OUT NOCOPY VARCHAR2
553 ,p_attribute15 OUT NOCOPY VARCHAR2
554 ,p_attribute16 OUT NOCOPY VARCHAR2
558 ,p_attribute20 OUT NOCOPY VARCHAR2
555 ,p_attribute17 OUT NOCOPY VARCHAR2
556 ,p_attribute18 OUT NOCOPY VARCHAR2
557 ,p_attribute19 OUT NOCOPY VARCHAR2
559 ,p_abs_information_category OUT NOCOPY VARCHAR2
560 ,p_abs_information1 OUT NOCOPY VARCHAR2
561 ,p_abs_information2 OUT NOCOPY VARCHAR2
562 ,p_abs_information3 OUT NOCOPY VARCHAR2
563 ,p_abs_information4 OUT NOCOPY VARCHAR2
564 ,p_abs_information5 OUT NOCOPY VARCHAR2
565 ,p_abs_information6 OUT NOCOPY VARCHAR2
566 ,p_abs_information7 OUT NOCOPY VARCHAR2
567 ,p_abs_information8 OUT NOCOPY VARCHAR2
568 ,p_abs_information9 OUT NOCOPY VARCHAR2
569 ,p_abs_information10 OUT NOCOPY VARCHAR2
570 ,p_abs_information11 OUT NOCOPY VARCHAR2
571 ,p_abs_information12 OUT NOCOPY VARCHAR2
572 ,p_abs_information13 OUT NOCOPY VARCHAR2
573 ,p_abs_information14 OUT NOCOPY VARCHAR2
574 ,p_abs_information15 OUT NOCOPY VARCHAR2
575 ,p_abs_information16 OUT NOCOPY VARCHAR2
576 ,p_abs_information17 OUT NOCOPY VARCHAR2
577 ,p_abs_information18 OUT NOCOPY VARCHAR2
578 ,p_abs_information19 OUT NOCOPY VARCHAR2
579 ,p_abs_information20 OUT NOCOPY VARCHAR2
580 ,p_abs_information21 OUT NOCOPY VARCHAR2
581 ,p_abs_information22 OUT NOCOPY VARCHAR2
582 ,p_abs_information23 OUT NOCOPY VARCHAR2
583 ,p_abs_information24 OUT NOCOPY VARCHAR2
584 ,p_abs_information25 OUT NOCOPY VARCHAR2
585 ,p_abs_information26 OUT NOCOPY VARCHAR2
586 ,p_abs_information27 OUT NOCOPY VARCHAR2
587 ,p_abs_information28 OUT NOCOPY VARCHAR2
588 ,p_abs_information29 OUT NOCOPY VARCHAR2
589 ,p_abs_information30 OUT NOCOPY VARCHAR2
590 ,p_comments OUT NOCOPY VARCHAR2
591 );
592
593 /*
594 ||===========================================================================
595 || PROCEDURE: get_abs_from_tt
596 ||---------------------------------------------------------------------------
597 ||
598 || Description:
599 || This recover absence date from transaction table
600 ||
601 || Access Status:
602 || Public.
603 ||
604 ||===========================================================================
605 */
606 procedure get_abs_from_tt(
607 p_transaction_step_id in number
608 ,p_absence_rec out nocopy per_absence_attendances%rowtype
609 );
610
611 /*
612 ||===========================================================================
613 || PROCEDURE: get_rtn_from_tt
614 ||---------------------------------------------------------------------------
615 ||
616 || Description:
617 || This recover absence date from transaction table
618 ||
619 || Access Status:
620 || Public.
621 ||
622 ||===========================================================================
623 */
624 procedure get_rtn_from_tt(
625 p_transaction_step_id in number
626 ,p_absence_rec out nocopy per_absence_attendances%rowtype
627 );
628
629 /*
630 ||===========================================================================
631 || PROCEDURE: get_upd_from_tt
632 ||---------------------------------------------------------------------------
633 ||
634 || Description:
635 || This recover absence date from transaction table
636 ||
637 || Access Status:
638 || Public.
639 ||
640 ||===========================================================================
641 */
642 procedure get_upd_from_tt(
643 p_transaction_step_id in number
644 ,p_absence_rec out nocopy per_absence_attendances%rowtype
645 );
646
647 /*
648 ||===========================================================================
649 || PROCEDURE: process_api
650 ||---------------------------------------------------------------------------
651 ||
652 || Description:
653 || This recover absence date from transaction table and
654 || Call create_absence_person
655 ||
656 || Access Status:
657 || Public.
658 ||
659 ||===========================================================================
660 */
661 procedure process_api
662 (p_validate in boolean default false
663 ,p_transaction_step_id in number
664 ,p_effective_date in varchar2 default null
665 );
666
667 /*
668 ||===========================================================================
669 || PROCEDURE: validate_api
670 ||---------------------------------------------------------------------------
671 ||
672 || Description:
673 || Call create_absence_person with validate mode
674 ||
675 || Access Status:
676 || Public.
677 ||
678 ||===========================================================================
679 */
680 procedure validate_api(
681 p_effective_date in date
682 ,p_person_id in number
683 ,p_business_group_id in number
684 ,p_absence_attendance_type_id in number
685 ,p_abs_attendance_reason_id in number default null
686 ,p_comments in clob default null -- Bug#13362792
687 ,p_date_notification in date default null
688 ,p_date_projected_start in date default null
692 ,p_date_start in date default null
689 ,p_time_projected_start in varchar2 default null
690 ,p_date_projected_end in date default null
691 ,p_time_projected_end in date default null
693 ,p_time_start in varchar2 default null
694 ,p_date_end in date default null
695 ,p_time_end in varchar2 default null
696 ,p_absence_days in out nocopy number
697 ,p_absence_hours in out nocopy number
698 -- ,p_authorising_person_id in number default null
699 -- ,p_replacement_person_id in number default null
700 ,p_authorising_person_id in varchar2 default null
701 ,p_replacement_person_id in varchar2 default null
702 ,p_attribute_category in varchar2 default null
703 ,p_attribute1 in varchar2 default null
704 ,p_attribute2 in varchar2 default null
705 ,p_attribute3 in varchar2 default null
706 ,p_attribute4 in varchar2 default null
707 ,p_attribute5 in varchar2 default null
708 ,p_attribute6 in varchar2 default null
709 ,p_attribute7 in varchar2 default null
710 ,p_attribute8 in varchar2 default null
711 ,p_attribute9 in varchar2 default null
712 ,p_attribute10 in varchar2 default null
713 ,p_attribute11 in varchar2 default null
714 ,p_attribute12 in varchar2 default null
715 ,p_attribute13 in varchar2 default null
716 ,p_attribute14 in varchar2 default null
717 ,p_attribute15 in varchar2 default null
718 ,p_attribute16 in varchar2 default null
719 ,p_attribute17 in varchar2 default null
720 ,p_attribute18 in varchar2 default null
721 ,p_attribute19 in varchar2 default null
722 ,p_attribute20 in varchar2 default null
723 ,p_abs_information_category in varchar2 default null
724 ,p_abs_information1 in varchar2 default null
725 ,p_abs_information2 in varchar2 default null
726 ,p_abs_information3 in varchar2 default null
727 ,p_abs_information4 in varchar2 default null
728 ,p_abs_information5 in varchar2 default null
729 ,p_abs_information6 in varchar2 default null
730 ,p_abs_information7 in varchar2 default null
731 ,p_abs_information8 in varchar2 default null
732 ,p_abs_information9 in varchar2 default null
733 ,p_abs_information10 in varchar2 default null
734 ,p_abs_information11 in varchar2 default null
735 ,p_abs_information12 in varchar2 default null
736 ,p_abs_information13 in varchar2 default null
737 ,p_abs_information14 in varchar2 default null
738 ,p_abs_information15 in varchar2 default null
739 ,p_abs_information16 in varchar2 default null
740 ,p_abs_information17 in varchar2 default null
741 ,p_abs_information18 in varchar2 default null
742 ,p_abs_information19 in varchar2 default null
743 ,p_abs_information20 in varchar2 default null
744 ,p_abs_information21 in varchar2 default null
745 ,p_abs_information22 in varchar2 default null
746 ,p_abs_information23 in varchar2 default null
747 ,p_abs_information24 in varchar2 default null
748 ,p_abs_information25 in varchar2 default null
749 ,p_abs_information26 in varchar2 default null
750 ,p_abs_information27 in varchar2 default null
751 ,p_abs_information28 in varchar2 default null
752 ,p_abs_information29 in varchar2 default null
753 ,p_abs_information30 in varchar2 default null
754 ,p_absence_attendance_id out nocopy number
755 ,p_object_version_number out nocopy number
756 ,p_occurrence out nocopy number
757 ,p_dur_dys_less_warning out nocopy number
758 ,p_dur_hrs_less_warning out nocopy number
759 ,p_exceeds_pto_entit_warning out nocopy number
760 ,p_exceeds_run_total_warning out nocopy number
761 ,p_abs_overlap_warning out nocopy number
762 ,p_abs_day_after_warning out nocopy number
763 ,p_dur_overwritten_warning out nocopy number
764 ) ;
765
766 /*
767 ||===========================================================================
768 || PROCEDURE: process_save
769 ||---------------------------------------------------------------------------
770 ||
771 || Description:
772 || Save creating absence data in transaction table
773 ||
774 || Access Status:
775 || Public.
776 ||
777 ||===========================================================================
778 */
779 procedure process_save(
780 p_item_type in WF_ITEMS.ITEM_TYPE%TYPE
781 ,p_item_key in WF_ITEMS.ITEM_KEY%TYPE
782 ,p_act_id in NUMBER
783 ,p_login_person_id in number
784 ,p_review_proc_call in varchar2
785 ,p_effective_date in date
786 ,p_person_id in number
790 ,p_comments in clob default null -- Bug#13362792
787 ,p_business_group_id in number
788 ,p_absence_attendance_type_id in number
789 ,p_abs_attendance_reason_id in number default null
791 ,p_date_notification in date default null
792 ,p_date_projected_start in date default null
793 ,p_time_projected_start in varchar2 default null
794 ,p_date_projected_end in date default null
795 ,p_time_projected_end in varchar2 default null
796 ,p_date_start in date default null
797 ,p_time_start in varchar2 default null
798 ,p_date_end in date default null
799 ,p_time_end in varchar2 default null
800 ,p_absence_days in out nocopy number
801 ,p_absence_hours in out nocopy number
802 ,p_authorising_person_id in number default null
803 ,p_replacement_person_id in number default null
804 ,p_attribute_category in varchar2 default null
805 ,p_attribute1 in varchar2 default null
806 ,p_attribute2 in varchar2 default null
807 ,p_attribute3 in varchar2 default null
808 ,p_attribute4 in varchar2 default null
809 ,p_attribute5 in varchar2 default null
810 ,p_attribute6 in varchar2 default null
811 ,p_attribute7 in varchar2 default null
812 ,p_attribute8 in varchar2 default null
813 ,p_attribute9 in varchar2 default null
814 ,p_attribute10 in varchar2 default null
815 ,p_attribute11 in varchar2 default null
816 ,p_attribute12 in varchar2 default null
817 ,p_attribute13 in varchar2 default null
818 ,p_attribute14 in varchar2 default null
819 ,p_attribute15 in varchar2 default null
820 ,p_attribute16 in varchar2 default null
821 ,p_attribute17 in varchar2 default null
822 ,p_attribute18 in varchar2 default null
823 ,p_attribute19 in varchar2 default null
824 ,p_attribute20 in varchar2 default null
825 ,p_start_ampm in varchar2 default null
826 ,p_end_ampm in varchar2 default null
827 ,p_save_mode in varchar2 default null
828 ,p_abs_information_category in varchar2 default null
829 ,p_abs_information1 in varchar2 default null
830 ,p_abs_information2 in varchar2 default null
831 ,p_abs_information3 in varchar2 default null
832 ,p_abs_information4 in varchar2 default null
833 ,p_abs_information5 in varchar2 default null
834 ,p_abs_information6 in varchar2 default null
835 ,p_abs_information7 in varchar2 default null
836 ,p_abs_information8 in varchar2 default null
837 ,p_abs_information9 in varchar2 default null
838 ,p_abs_information10 in varchar2 default null
839 ,p_abs_information11 in varchar2 default null
840 ,p_abs_information12 in varchar2 default null
841 ,p_abs_information13 in varchar2 default null
842 ,p_abs_information14 in varchar2 default null
843 ,p_abs_information15 in varchar2 default null
844 ,p_abs_information16 in varchar2 default null
845 ,p_abs_information17 in varchar2 default null
846 ,p_abs_information18 in varchar2 default null
847 ,p_abs_information19 in varchar2 default null
848 ,p_abs_information20 in varchar2 default null
849 ,p_abs_information21 in varchar2 default null
850 ,p_abs_information22 in varchar2 default null
851 ,p_abs_information23 in varchar2 default null
852 ,p_abs_information24 in varchar2 default null
853 ,p_abs_information25 in varchar2 default null
854 ,p_abs_information26 in varchar2 default null
855 ,p_abs_information27 in varchar2 default null
856 ,p_abs_information28 in varchar2 default null
857 ,p_abs_information29 in varchar2 default null
858 ,p_abs_information30 in varchar2 default null
859 ,p_leave_status in varchar2 default null
860 ,p_return_on_warning in varchar2 default null --2713296
861 ,p_absence_attendance_id out nocopy number
862 ,p_object_version_number out nocopy number
863 ,p_occurrence out nocopy number
864 ,p_dur_dys_less_warning out nocopy number
865 ,p_dur_hrs_less_warning out nocopy number
866 ,p_exceeds_pto_entit_warning out nocopy number
867 ,p_exceeds_run_total_warning out nocopy number
868 ,p_abs_overlap_warning out nocopy number
869 ,p_abs_day_after_warning out nocopy number
870 ,p_dur_overwritten_warning out nocopy number
871 ,p_transaction_step_id out nocopy number
872 ,p_page_error out nocopy varchar2
873 ,p_page_error_msg out nocopy varchar2
874 ,p_page_error_num out nocopy varchar2
875 ) ;
876
877 /*
878 ||===========================================================================
879 || PROCEDURE: process_txn_save
883 || Save infomration on create absence to transaction table
880 ||---------------------------------------------------------------------------
881 ||
882 || Description:
884 ||
885 || Access Status:
886 || Public.
887 ||
888 ||===========================================================================
889 */
890 procedure process_txn_save(
891 p_transaction_step_id in NUMBER
892 ,p_login_person_id in number
893 ,p_review_proc_call in varchar2
894 ,p_effective_date in date
895 ,p_person_id in number
896 ,p_business_group_id in number
897 ,p_absence_attendance_type_id in number
898 ,p_abs_attendance_reason_id in number default null
899 ,p_comments in clob default null -- Bug#13362792
900 ,p_date_notification in date default null
901 ,p_date_projected_start in date default null
902 ,p_time_projected_start in varchar2 default null
903 ,p_date_projected_end in date default null
904 ,p_time_projected_end in varchar2 default null
905 ,p_date_start in date default null
906 ,p_time_start in varchar2 default null
907 ,p_date_end in date default null
908 ,p_time_end in varchar2 default null
909 ,p_absence_days in out nocopy number
910 ,p_absence_hours in out nocopy number
911 ,p_authorising_person_id in number default null
912 ,p_replacement_person_id in number default null
913 ,p_attribute_category in varchar2 default null
914 ,p_attribute1 in varchar2 default null
915 ,p_attribute2 in varchar2 default null
916 ,p_attribute3 in varchar2 default null
917 ,p_attribute4 in varchar2 default null
918 ,p_attribute5 in varchar2 default null
919 ,p_attribute6 in varchar2 default null
920 ,p_attribute7 in varchar2 default null
921 ,p_attribute8 in varchar2 default null
922 ,p_attribute9 in varchar2 default null
923 ,p_attribute10 in varchar2 default null
924 ,p_attribute11 in varchar2 default null
925 ,p_attribute12 in varchar2 default null
926 ,p_attribute13 in varchar2 default null
927 ,p_attribute14 in varchar2 default null
928 ,p_attribute15 in varchar2 default null
929 ,p_attribute16 in varchar2 default null
930 ,p_attribute17 in varchar2 default null
931 ,p_attribute18 in varchar2 default null
932 ,p_attribute19 in varchar2 default null
933 ,p_attribute20 in varchar2 default null
934 ,p_start_ampm in varchar2 default null
935 ,p_end_ampm in varchar2 default null
936 ,p_save_mode in varchar2 default null
937 ,p_abs_information_category in varchar2 default null
938 ,p_abs_information1 in varchar2 default null
939 ,p_abs_information2 in varchar2 default null
940 ,p_abs_information3 in varchar2 default null
941 ,p_abs_information4 in varchar2 default null
942 ,p_abs_information5 in varchar2 default null
943 ,p_abs_information6 in varchar2 default null
944 ,p_abs_information7 in varchar2 default null
945 ,p_abs_information8 in varchar2 default null
946 ,p_abs_information9 in varchar2 default null
947 ,p_abs_information10 in varchar2 default null
948 ,p_abs_information11 in varchar2 default null
949 ,p_abs_information12 in varchar2 default null
950 ,p_abs_information13 in varchar2 default null
951 ,p_abs_information14 in varchar2 default null
952 ,p_abs_information15 in varchar2 default null
953 ,p_abs_information16 in varchar2 default null
954 ,p_abs_information17 in varchar2 default null
955 ,p_abs_information18 in varchar2 default null
956 ,p_abs_information19 in varchar2 default null
957 ,p_abs_information20 in varchar2 default null
958 ,p_abs_information21 in varchar2 default null
959 ,p_abs_information22 in varchar2 default null
960 ,p_abs_information23 in varchar2 default null
961 ,p_abs_information24 in varchar2 default null
962 ,p_abs_information25 in varchar2 default null
963 ,p_abs_information26 in varchar2 default null
964 ,p_abs_information27 in varchar2 default null
965 ,p_abs_information28 in varchar2 default null
966 ,p_abs_information29 in varchar2 default null
967 ,p_abs_information30 in varchar2 default null
968 ,p_leave_status in varchar2 default null
969 ,p_return_on_warning in varchar2 default null --2713296
970 ,p_absence_attendance_id out nocopy number
971 ,p_object_version_number out nocopy number
972 ,p_occurrence out nocopy number
973 ,p_dur_dys_less_warning out nocopy number
974 ,p_dur_hrs_less_warning out nocopy number
975 ,p_exceeds_pto_entit_warning out nocopy number
976 ,p_exceeds_run_total_warning out nocopy number
977 ,p_abs_overlap_warning out nocopy number
978 ,p_abs_day_after_warning out nocopy number
982 ,p_page_error_num out nocopy varchar2
979 ,p_dur_overwritten_warning out nocopy number
980 ,p_page_error out nocopy varchar2
981 ,p_page_error_msg out nocopy varchar2
983 ) ;
984
985 /*
986 ||===========================================================================
987 || PROCEDURE: process_update_save
988 ||---------------------------------------------------------------------------
989 ||
990 || Description:
991 || This procedure will call actual API with validate mode
992 || if there are no error, save date into transaction table
993 ||
994 || Access Status:
995 || Public.
996 ||
997 ||===========================================================================
998 */
999 procedure process_update_save(
1000 p_item_type in WF_ITEMS.ITEM_TYPE%TYPE
1001 ,p_item_key in WF_ITEMS.ITEM_KEY%TYPE
1002 ,p_act_id in NUMBER
1003 ,p_login_person_id in number
1004 ,p_review_proc_call in varchar2
1005 ,p_effective_date in date
1006 ,p_date_notification in date
1007 ,p_absence_attendance_id in per_absence_attendances.absence_attendance_id%type
1008 ,p_object_version_number in out nocopy number
1009 ,p_date_start in date default null
1010 ,p_time_start in varchar2 default null
1011 ,p_date_end in date default null
1012 ,p_time_end in varchar2 default null
1013 ,p_absence_days in out nocopy number
1014 ,p_absence_hours in out nocopy number
1015 ,p_replacement_person_id in number default null
1016 ,p_update_return in varchar2
1017 ,p_save_mode in varchar2
1018 ,p_attribute_category in varchar2 default null
1019 ,p_attribute1 in varchar2 default null
1020 ,p_attribute2 in varchar2 default null
1021 ,p_attribute3 in varchar2 default null
1022 ,p_attribute4 in varchar2 default null
1023 ,p_attribute5 in varchar2 default null
1024 ,p_attribute6 in varchar2 default null
1025 ,p_attribute7 in varchar2 default null
1026 ,p_attribute8 in varchar2 default null
1027 ,p_attribute9 in varchar2 default null
1028 ,p_attribute10 in varchar2 default null
1029 ,p_attribute11 in varchar2 default null
1030 ,p_attribute12 in varchar2 default null
1031 ,p_attribute13 in varchar2 default null
1032 ,p_attribute14 in varchar2 default null
1033 ,p_attribute15 in varchar2 default null
1034 ,p_attribute16 in varchar2 default null
1035 ,p_attribute17 in varchar2 default null
1036 ,p_attribute18 in varchar2 default null
1037 ,p_attribute19 in varchar2 default null
1038 ,p_attribute20 in varchar2 default null
1039 ,p_abs_information_category in varchar2 default null
1040 ,p_abs_information1 in varchar2 default null
1041 ,p_abs_information2 in varchar2 default null
1042 ,p_abs_information3 in varchar2 default null
1043 ,p_abs_information4 in varchar2 default null
1044 ,p_abs_information5 in varchar2 default null
1045 ,p_abs_information6 in varchar2 default null
1046 ,p_abs_information7 in varchar2 default null
1047 ,p_abs_information8 in varchar2 default null
1048 ,p_abs_information9 in varchar2 default null
1049 ,p_abs_information10 in varchar2 default null
1050 ,p_abs_information11 in varchar2 default null
1051 ,p_abs_information12 in varchar2 default null
1052 ,p_abs_information13 in varchar2 default null
1053 ,p_abs_information14 in varchar2 default null
1054 ,p_abs_information15 in varchar2 default null
1055 ,p_abs_information16 in varchar2 default null
1056 ,p_abs_information17 in varchar2 default null
1057 ,p_abs_information18 in varchar2 default null
1058 ,p_abs_information19 in varchar2 default null
1059 ,p_abs_information20 in varchar2 default null
1060 ,p_abs_information21 in varchar2 default null
1061 ,p_abs_information22 in varchar2 default null
1062 ,p_abs_information23 in varchar2 default null
1063 ,p_abs_information24 in varchar2 default null
1064 ,p_abs_information25 in varchar2 default null
1065 ,p_abs_information26 in varchar2 default null
1066 ,p_abs_information27 in varchar2 default null
1067 ,p_abs_information28 in varchar2 default null
1068 ,p_abs_information29 in varchar2 default null
1069 ,p_abs_information30 in varchar2 default null
1070 ,p_leave_status in varchar2 default null
1071 ,p_comments in varchar2 default null
1072 ,p_person_id in number
1073 ,p_absence_attendance_type_id in number
1074 ,p_abs_attendance_reason_id in number default null
1075 ,p_date_projected_start in date default null
1076 ,p_time_projected_start in varchar2 default null
1077 ,p_date_projected_end in date default null
1081 ,p_dur_hrs_less_warning out nocopy number
1078 ,p_time_projected_end in varchar2 default null
1079 ,p_return_on_warning in varchar2 default null --2713296
1080 ,p_dur_dys_less_warning out nocopy number
1082 ,p_exceeds_pto_entit_warning out nocopy number
1083 ,p_exceeds_run_total_warning out nocopy number
1084 ,p_abs_overlap_warning out nocopy number
1085 ,p_abs_day_after_warning out nocopy number
1086 ,p_dur_overwritten_warning out nocopy number
1087 ,p_transaction_step_id out nocopy number
1088 ,p_page_error out nocopy varchar2
1089 ,p_page_error_msg out nocopy varchar2
1090 ,p_page_error_num out nocopy varchar2
1091 ) ;
1092
1093
1094 /*
1095 ||===========================================================================
1096 || PROCEDURE: process_update_txn_save
1097 ||---------------------------------------------------------------------------
1098 ||
1099 || Description:
1100 || This procedure will call actual API with validate mode
1101 || if there are no error, save date into transaction table
1102 || when updating transaction table for update absence
1103 ||
1104 || Access Status:
1105 || Public.
1106 ||
1107 ||===========================================================================
1108 */
1109 procedure process_update_txn_save(
1110 p_transaction_step_id in number
1111 ,p_login_person_id in number
1112 ,p_effective_date in date
1113 --2713296 changes start
1114 ,p_person_id in number
1115 ,p_business_group_id in number
1116 ,p_absence_attendance_id in per_absence_attendances.absence_attendance_id%type
1117 ,p_object_version_number in number
1118 ,p_save_mode in varchar2 default null
1119 --2713296 changes end
1120 ,p_absence_attendance_type_id in number --2966372
1121 ,p_date_notification in date
1122 ,p_date_start in date default null
1123 ,p_time_start in varchar2 default null
1124 ,p_date_end in date default null
1125 ,p_time_end in varchar2 default null
1126 ,p_attribute_category in varchar2 default null
1127 ,p_attribute1 in varchar2 default null
1128 ,p_attribute2 in varchar2 default null
1129 ,p_attribute3 in varchar2 default null
1130 ,p_attribute4 in varchar2 default null
1131 ,p_attribute5 in varchar2 default null
1132 ,p_attribute6 in varchar2 default null
1133 ,p_attribute7 in varchar2 default null
1134 ,p_attribute8 in varchar2 default null
1135 ,p_attribute9 in varchar2 default null
1136 ,p_attribute10 in varchar2 default null
1137 ,p_attribute11 in varchar2 default null
1138 ,p_attribute12 in varchar2 default null
1139 ,p_attribute13 in varchar2 default null
1140 ,p_attribute14 in varchar2 default null
1141 ,p_attribute15 in varchar2 default null
1142 ,p_attribute16 in varchar2 default null
1143 ,p_attribute17 in varchar2 default null
1144 ,p_attribute18 in varchar2 default null
1145 ,p_attribute19 in varchar2 default null
1146 ,p_attribute20 in varchar2 default null
1147 ,p_abs_information_category in varchar2 default null
1148 ,p_abs_information1 in varchar2 default null
1149 ,p_abs_information2 in varchar2 default null
1150 ,p_abs_information3 in varchar2 default null
1151 ,p_abs_information4 in varchar2 default null
1152 ,p_abs_information5 in varchar2 default null
1153 ,p_abs_information6 in varchar2 default null
1154 ,p_abs_information7 in varchar2 default null
1155 ,p_abs_information8 in varchar2 default null
1156 ,p_abs_information9 in varchar2 default null
1157 ,p_abs_information10 in varchar2 default null
1158 ,p_abs_information11 in varchar2 default null
1159 ,p_abs_information12 in varchar2 default null
1160 ,p_abs_information13 in varchar2 default null
1161 ,p_abs_information14 in varchar2 default null
1162 ,p_abs_information15 in varchar2 default null
1163 ,p_abs_information16 in varchar2 default null
1164 ,p_abs_information17 in varchar2 default null
1165 ,p_abs_information18 in varchar2 default null
1166 ,p_abs_information19 in varchar2 default null
1167 ,p_abs_information20 in varchar2 default null
1168 ,p_abs_information21 in varchar2 default null
1169 ,p_abs_information22 in varchar2 default null
1170 ,p_abs_information23 in varchar2 default null
1171 ,p_abs_information24 in varchar2 default null
1172 ,p_abs_information25 in varchar2 default null
1173 ,p_abs_information26 in varchar2 default null
1174 ,p_abs_information27 in varchar2 default null
1175 ,p_abs_information28 in varchar2 default null
1176 ,p_abs_information29 in varchar2 default null
1177 ,p_abs_information30 in varchar2 default null
1178 ,p_leave_status in varchar2 default null
1182 ,p_replacement_person_id in number default null
1179 ,p_comments in varchar2 default null
1180 ,p_absence_days in out nocopy number
1181 ,p_absence_hours in out nocopy number
1183 ,p_date_projected_start in date default null
1184 ,p_time_projected_start in varchar2 default null
1185 ,p_date_projected_end in date default null
1186 ,p_time_projected_end in varchar2 default null
1187 --2713296 changes start
1188 ,p_return_on_warning in varchar2 default null
1189 ,p_dur_dys_less_warning out nocopy number
1190 ,p_dur_hrs_less_warning out nocopy number
1191 ,p_exceeds_pto_entit_warning out nocopy number
1192 ,p_exceeds_run_total_warning out nocopy number
1193 ,p_abs_overlap_warning out nocopy number
1194 ,p_abs_day_after_warning out nocopy number
1195 ,p_dur_overwritten_warning out nocopy number
1196 ,p_page_error out nocopy varchar2
1197 ,p_page_error_msg out nocopy varchar2
1198 ,p_page_error_num out nocopy varchar2
1199 --2713296 changes end
1200 );
1201
1202
1203 --
1204 -- ---------------------------------------------------------------------------
1205 -- |-----------------< calculate_absence_duration - OLD>--------------------|
1206 -- ---------------------------------------------------------------------------
1207 --
1208 -- Description:
1209 -- Calculates the absence duration in hours and / or days and sets
1210 -- the duration.
1211 --
1212 -- Pre-conditions:
1213 -- None.
1214 --
1215 -- In Arguments:
1216 -- p_absence_attendance_type_id
1217 -- p_object_version_number
1218 -- p_effective_date
1219 -- p_person_id
1220 -- p_date_start
1221 -- p_date_end
1222 -- p_time_start
1223 -- p_time_end
1224 --
1225 -- Out Arguments:
1226 -- p_absence_days
1227 -- p_absence_hours
1228 -- p_use_formula
1229 --
1230 -- Post Success:
1231 -- The absence duration in days and hours is returned.
1232 --
1233 -- Post Failure:
1234 -- If a failure occurs, an application error is raised and
1235 -- processing terminates.
1236 --
1237 -- Access Status:
1238 -- Internal Development Use Only.
1239 --
1240 -- {End Of Comments}
1241 -- ----------------------------------------------------------------------------
1242 procedure calculate_absence_duration
1243 (
1244 -- p_absence_attendance_id in number
1245 p_absence_attendance_type_id in number
1246 ,p_business_group_id in number
1247 -- ,p_object_version_number in number
1248 ,p_effective_date in date
1249 ,p_person_id in number
1250 ,p_date_start in date
1251 ,p_date_end in date
1252 ,p_time_start in varchar2
1253 ,p_time_end in varchar2
1254 ,p_absence_days out nocopy number
1255 ,p_absence_hours out nocopy number
1256 ,p_use_formula out nocopy number
1257 ,p_min_max_failure out nocopy varchar2 -- WWBUG #2602856
1258 ,p_warning_or_error out nocopy varchar2 -- WWBUG #2602856
1259 ,p_page_error_msg out nocopy varchar2 -- 2695922
1260 );
1261
1262 --
1263 -- ---------------------------------------------------------------------------
1264 -- |-----------------< calculate_absence_duration - NEW>--------------------|
1265 -- ---------------------------------------------------------------------------
1266 --
1267 -- Description:
1268 -- Calculates the absence duration in hours and / or days and sets
1269 -- the duration.
1270 --
1271 -- Pre-conditions:
1272 -- None.
1273 --
1274 -- In Arguments:
1275 -- p_absence_attendance_type_id
1276 -- p_object_version_number
1277 -- p_effective_date
1278 -- p_person_id
1279 -- p_date_start
1280 -- p_date_end
1281 -- p_time_start
1282 -- p_time_end
1283 -- p_ABS_INFORMATION_CATEGORY
1284 -- p_ABS_INFORMATION1
1285 -- p_ABS_INFORMATION2
1286 -- p_ABS_INFORMATION3
1287 -- p_ABS_INFORMATION4
1288 -- p_ABS_INFORMATION5
1289 -- p_ABS_INFORMATION6
1290 --
1291 -- Out Arguments:
1292 -- p_absence_days
1293 -- p_absence_hours
1294 -- p_use_formula
1295 --
1296 -- Post Success:
1297 -- The absence duration in days and hours is returned.
1298 --
1299 -- Post Failure:
1300 -- If a failure occurs, an application error is raised and
1301 -- processing terminates.
1302 --
1303 -- Access Status:
1304 -- Internal Development Use Only.
1305 --
1306 -- {End Of Comments}
1307 -- ----------------------------------------------------------------------------
1308 procedure calculate_absence_duration
1309 (
1310 --p_absence_attendance_id in number
1311 p_absence_attendance_type_id in number
1312 ,p_business_group_id in number
1313 -- ,p_object_version_number in number
1314 ,p_effective_date in date
1315 ,p_person_id in number
1316 ,p_date_start in date
1317 ,p_date_end in date
1318 ,p_time_start in varchar2
1319 ,p_time_end in varchar2
1320 ,p_abs_information_category in varchar2
1321 ,p_abs_information1 in varchar2
1322 ,p_abs_information2 in varchar2
1323 ,p_abs_information3 in varchar2
1324 ,p_abs_information4 in varchar2
1325 ,p_abs_information5 in varchar2
1326 ,p_abs_information6 in varchar2
1327 ,p_absence_days out nocopy number
1328 ,p_absence_hours out nocopy number
1329 ,p_use_formula out nocopy number
1330 ,p_min_max_failure out nocopy varchar2
1331 ,p_warning_or_error out nocopy varchar2
1332 ,p_page_error_msg out nocopy varchar2 --2695922
1333 );
1334 /*
1335 ||===========================================================================
1336 || PROCEDURE: delete_absence
1337 ||---------------------------------------------------------------------------
1338 ||
1339 || Description:
1340 || This procedure will delete absence record from
1341 || per_absence_attendances.
1342 ||
1343 || Access Status:
1344 || Public.
1345 ||
1346 ||===========================================================================
1347 */
1348 procedure delete_absence(
1349 p_absence_attendance_id IN NUMBER
1350 ,p_page_error_msg OUT NOCOPY VARCHAR2 --2782075
1351 );
1352
1353 /*
1354 ||===========================================================================
1355 || FUNCTION: chk_overlap
1356 ||---------------------------------------------------------------------------
1357 ||
1358 || Description:
1359 || This function will check overlap absence in transaction table
1360 ||
1361 || Access Status:
1362 || Public.
1363 ||
1364 ||===========================================================================
1365 */
1366 function chk_overlap(
1367 p_person_id IN NUMBER
1368 ,p_business_group_id IN NUMBER
1369 ,p_date_start IN DATE
1370 ,p_date_end IN DATE
1371 ,p_time_start IN VARCHAR2 default null
1372 ,p_time_end IN VARCHAR2 default null
1373 ) return boolean;
1374
1375 /*
1376 ||===========================================================================
1377 || FUNCTION: is_gb_leg_and_category_s
1378 ||---------------------------------------------------------------------------
1379 ||
1380 || Description:
1381 || This function will return true if the absence category is 'Sickness'
1382 || and the legislation is 'GB' , else will return false.
1383 ||
1384 || Access Status:
1385 || Public.
1386 ||
1387 ||===========================================================================
1388 */
1389 function is_gb_leg_and_category_s(p_absence_attendance_type_id IN NUMBER ,
1390 p_business_group_id IN NUMBER)
1391 return boolean;
1392 END HR_LOA_SS;