345: ||===========================================================================
346: */
347:
348: FUNCTION is_rec_changed
349: (p_effective_date in date default hr_api.g_date
350: ,p_absence_attendance_id in number default hr_api.g_number
351: ,p_abs_attendance_reason_id in number default hr_api.g_number
352: ,p_comments in long default hr_api.g_varchar2
353: ,p_date_notification in date default hr_api.g_date
346: */
347:
348: FUNCTION is_rec_changed
349: (p_effective_date in date default hr_api.g_date
350: ,p_absence_attendance_id in number default hr_api.g_number
351: ,p_abs_attendance_reason_id in number default hr_api.g_number
352: ,p_comments in long default hr_api.g_varchar2
353: ,p_date_notification in date default hr_api.g_date
354: ,p_date_projected_start in date default hr_api.g_date
347:
348: FUNCTION is_rec_changed
349: (p_effective_date in date default hr_api.g_date
350: ,p_absence_attendance_id in number default hr_api.g_number
351: ,p_abs_attendance_reason_id in number default hr_api.g_number
352: ,p_comments in long default hr_api.g_varchar2
353: ,p_date_notification in date default hr_api.g_date
354: ,p_date_projected_start in date default hr_api.g_date
355: ,p_time_projected_start in varchar2 default hr_api.g_varchar2
348: FUNCTION is_rec_changed
349: (p_effective_date in date default hr_api.g_date
350: ,p_absence_attendance_id in number default hr_api.g_number
351: ,p_abs_attendance_reason_id in number default hr_api.g_number
352: ,p_comments in long default hr_api.g_varchar2
353: ,p_date_notification in date default hr_api.g_date
354: ,p_date_projected_start in date default hr_api.g_date
355: ,p_time_projected_start in varchar2 default hr_api.g_varchar2
356: ,p_date_projected_end in date default hr_api.g_date
349: (p_effective_date in date default hr_api.g_date
350: ,p_absence_attendance_id in number default hr_api.g_number
351: ,p_abs_attendance_reason_id in number default hr_api.g_number
352: ,p_comments in long default hr_api.g_varchar2
353: ,p_date_notification in date default hr_api.g_date
354: ,p_date_projected_start in date default hr_api.g_date
355: ,p_time_projected_start in varchar2 default hr_api.g_varchar2
356: ,p_date_projected_end in date default hr_api.g_date
357: ,p_time_projected_end in varchar2 default hr_api.g_varchar2
350: ,p_absence_attendance_id in number default hr_api.g_number
351: ,p_abs_attendance_reason_id in number default hr_api.g_number
352: ,p_comments in long default hr_api.g_varchar2
353: ,p_date_notification in date default hr_api.g_date
354: ,p_date_projected_start in date default hr_api.g_date
355: ,p_time_projected_start in varchar2 default hr_api.g_varchar2
356: ,p_date_projected_end in date default hr_api.g_date
357: ,p_time_projected_end in varchar2 default hr_api.g_varchar2
358: ,p_date_start in date default hr_api.g_date
351: ,p_abs_attendance_reason_id in number default hr_api.g_number
352: ,p_comments in long default hr_api.g_varchar2
353: ,p_date_notification in date default hr_api.g_date
354: ,p_date_projected_start in date default hr_api.g_date
355: ,p_time_projected_start in varchar2 default hr_api.g_varchar2
356: ,p_date_projected_end in date default hr_api.g_date
357: ,p_time_projected_end in varchar2 default hr_api.g_varchar2
358: ,p_date_start in date default hr_api.g_date
359: ,p_time_start in varchar2 default hr_api.g_varchar2
352: ,p_comments in long default hr_api.g_varchar2
353: ,p_date_notification in date default hr_api.g_date
354: ,p_date_projected_start in date default hr_api.g_date
355: ,p_time_projected_start in varchar2 default hr_api.g_varchar2
356: ,p_date_projected_end in date default hr_api.g_date
357: ,p_time_projected_end in varchar2 default hr_api.g_varchar2
358: ,p_date_start in date default hr_api.g_date
359: ,p_time_start in varchar2 default hr_api.g_varchar2
360: ,p_date_end in date default hr_api.g_date
353: ,p_date_notification in date default hr_api.g_date
354: ,p_date_projected_start in date default hr_api.g_date
355: ,p_time_projected_start in varchar2 default hr_api.g_varchar2
356: ,p_date_projected_end in date default hr_api.g_date
357: ,p_time_projected_end in varchar2 default hr_api.g_varchar2
358: ,p_date_start in date default hr_api.g_date
359: ,p_time_start in varchar2 default hr_api.g_varchar2
360: ,p_date_end in date default hr_api.g_date
361: ,p_time_end in varchar2 default hr_api.g_varchar2
354: ,p_date_projected_start in date default hr_api.g_date
355: ,p_time_projected_start in varchar2 default hr_api.g_varchar2
356: ,p_date_projected_end in date default hr_api.g_date
357: ,p_time_projected_end in varchar2 default hr_api.g_varchar2
358: ,p_date_start in date default hr_api.g_date
359: ,p_time_start in varchar2 default hr_api.g_varchar2
360: ,p_date_end in date default hr_api.g_date
361: ,p_time_end in varchar2 default hr_api.g_varchar2
362: ,p_absence_days in number default hr_api.g_number
355: ,p_time_projected_start in varchar2 default hr_api.g_varchar2
356: ,p_date_projected_end in date default hr_api.g_date
357: ,p_time_projected_end in varchar2 default hr_api.g_varchar2
358: ,p_date_start in date default hr_api.g_date
359: ,p_time_start in varchar2 default hr_api.g_varchar2
360: ,p_date_end in date default hr_api.g_date
361: ,p_time_end in varchar2 default hr_api.g_varchar2
362: ,p_absence_days in number default hr_api.g_number
363: ,p_absence_hours in number default hr_api.g_number
356: ,p_date_projected_end in date default hr_api.g_date
357: ,p_time_projected_end in varchar2 default hr_api.g_varchar2
358: ,p_date_start in date default hr_api.g_date
359: ,p_time_start in varchar2 default hr_api.g_varchar2
360: ,p_date_end in date default hr_api.g_date
361: ,p_time_end in varchar2 default hr_api.g_varchar2
362: ,p_absence_days in number default hr_api.g_number
363: ,p_absence_hours in number default hr_api.g_number
364: ,p_authorising_person_id in number default hr_api.g_number
357: ,p_time_projected_end in varchar2 default hr_api.g_varchar2
358: ,p_date_start in date default hr_api.g_date
359: ,p_time_start in varchar2 default hr_api.g_varchar2
360: ,p_date_end in date default hr_api.g_date
361: ,p_time_end in varchar2 default hr_api.g_varchar2
362: ,p_absence_days in number default hr_api.g_number
363: ,p_absence_hours in number default hr_api.g_number
364: ,p_authorising_person_id in number default hr_api.g_number
365: ,p_replacement_person_id in number default hr_api.g_number
358: ,p_date_start in date default hr_api.g_date
359: ,p_time_start in varchar2 default hr_api.g_varchar2
360: ,p_date_end in date default hr_api.g_date
361: ,p_time_end in varchar2 default hr_api.g_varchar2
362: ,p_absence_days in number default hr_api.g_number
363: ,p_absence_hours in number default hr_api.g_number
364: ,p_authorising_person_id in number default hr_api.g_number
365: ,p_replacement_person_id in number default hr_api.g_number
366: ,p_attribute_category in varchar2 default hr_api.g_varchar2
359: ,p_time_start in varchar2 default hr_api.g_varchar2
360: ,p_date_end in date default hr_api.g_date
361: ,p_time_end in varchar2 default hr_api.g_varchar2
362: ,p_absence_days in number default hr_api.g_number
363: ,p_absence_hours in number default hr_api.g_number
364: ,p_authorising_person_id in number default hr_api.g_number
365: ,p_replacement_person_id in number default hr_api.g_number
366: ,p_attribute_category in varchar2 default hr_api.g_varchar2
367: ,p_attribute1 in varchar2 default hr_api.g_varchar2
360: ,p_date_end in date default hr_api.g_date
361: ,p_time_end in varchar2 default hr_api.g_varchar2
362: ,p_absence_days in number default hr_api.g_number
363: ,p_absence_hours in number default hr_api.g_number
364: ,p_authorising_person_id in number default hr_api.g_number
365: ,p_replacement_person_id in number default hr_api.g_number
366: ,p_attribute_category in varchar2 default hr_api.g_varchar2
367: ,p_attribute1 in varchar2 default hr_api.g_varchar2
368: ,p_attribute2 in varchar2 default hr_api.g_varchar2
361: ,p_time_end in varchar2 default hr_api.g_varchar2
362: ,p_absence_days in number default hr_api.g_number
363: ,p_absence_hours in number default hr_api.g_number
364: ,p_authorising_person_id in number default hr_api.g_number
365: ,p_replacement_person_id in number default hr_api.g_number
366: ,p_attribute_category in varchar2 default hr_api.g_varchar2
367: ,p_attribute1 in varchar2 default hr_api.g_varchar2
368: ,p_attribute2 in varchar2 default hr_api.g_varchar2
369: ,p_attribute3 in varchar2 default hr_api.g_varchar2
362: ,p_absence_days in number default hr_api.g_number
363: ,p_absence_hours in number default hr_api.g_number
364: ,p_authorising_person_id in number default hr_api.g_number
365: ,p_replacement_person_id in number default hr_api.g_number
366: ,p_attribute_category in varchar2 default hr_api.g_varchar2
367: ,p_attribute1 in varchar2 default hr_api.g_varchar2
368: ,p_attribute2 in varchar2 default hr_api.g_varchar2
369: ,p_attribute3 in varchar2 default hr_api.g_varchar2
370: ,p_attribute4 in varchar2 default hr_api.g_varchar2
363: ,p_absence_hours in number default hr_api.g_number
364: ,p_authorising_person_id in number default hr_api.g_number
365: ,p_replacement_person_id in number default hr_api.g_number
366: ,p_attribute_category in varchar2 default hr_api.g_varchar2
367: ,p_attribute1 in varchar2 default hr_api.g_varchar2
368: ,p_attribute2 in varchar2 default hr_api.g_varchar2
369: ,p_attribute3 in varchar2 default hr_api.g_varchar2
370: ,p_attribute4 in varchar2 default hr_api.g_varchar2
371: ,p_attribute5 in varchar2 default hr_api.g_varchar2
364: ,p_authorising_person_id in number default hr_api.g_number
365: ,p_replacement_person_id in number default hr_api.g_number
366: ,p_attribute_category in varchar2 default hr_api.g_varchar2
367: ,p_attribute1 in varchar2 default hr_api.g_varchar2
368: ,p_attribute2 in varchar2 default hr_api.g_varchar2
369: ,p_attribute3 in varchar2 default hr_api.g_varchar2
370: ,p_attribute4 in varchar2 default hr_api.g_varchar2
371: ,p_attribute5 in varchar2 default hr_api.g_varchar2
372: ,p_attribute6 in varchar2 default hr_api.g_varchar2
365: ,p_replacement_person_id in number default hr_api.g_number
366: ,p_attribute_category in varchar2 default hr_api.g_varchar2
367: ,p_attribute1 in varchar2 default hr_api.g_varchar2
368: ,p_attribute2 in varchar2 default hr_api.g_varchar2
369: ,p_attribute3 in varchar2 default hr_api.g_varchar2
370: ,p_attribute4 in varchar2 default hr_api.g_varchar2
371: ,p_attribute5 in varchar2 default hr_api.g_varchar2
372: ,p_attribute6 in varchar2 default hr_api.g_varchar2
373: ,p_attribute7 in varchar2 default hr_api.g_varchar2
366: ,p_attribute_category in varchar2 default hr_api.g_varchar2
367: ,p_attribute1 in varchar2 default hr_api.g_varchar2
368: ,p_attribute2 in varchar2 default hr_api.g_varchar2
369: ,p_attribute3 in varchar2 default hr_api.g_varchar2
370: ,p_attribute4 in varchar2 default hr_api.g_varchar2
371: ,p_attribute5 in varchar2 default hr_api.g_varchar2
372: ,p_attribute6 in varchar2 default hr_api.g_varchar2
373: ,p_attribute7 in varchar2 default hr_api.g_varchar2
374: ,p_attribute8 in varchar2 default hr_api.g_varchar2
367: ,p_attribute1 in varchar2 default hr_api.g_varchar2
368: ,p_attribute2 in varchar2 default hr_api.g_varchar2
369: ,p_attribute3 in varchar2 default hr_api.g_varchar2
370: ,p_attribute4 in varchar2 default hr_api.g_varchar2
371: ,p_attribute5 in varchar2 default hr_api.g_varchar2
372: ,p_attribute6 in varchar2 default hr_api.g_varchar2
373: ,p_attribute7 in varchar2 default hr_api.g_varchar2
374: ,p_attribute8 in varchar2 default hr_api.g_varchar2
375: ,p_attribute9 in varchar2 default hr_api.g_varchar2
368: ,p_attribute2 in varchar2 default hr_api.g_varchar2
369: ,p_attribute3 in varchar2 default hr_api.g_varchar2
370: ,p_attribute4 in varchar2 default hr_api.g_varchar2
371: ,p_attribute5 in varchar2 default hr_api.g_varchar2
372: ,p_attribute6 in varchar2 default hr_api.g_varchar2
373: ,p_attribute7 in varchar2 default hr_api.g_varchar2
374: ,p_attribute8 in varchar2 default hr_api.g_varchar2
375: ,p_attribute9 in varchar2 default hr_api.g_varchar2
376: ,p_attribute10 in varchar2 default hr_api.g_varchar2
369: ,p_attribute3 in varchar2 default hr_api.g_varchar2
370: ,p_attribute4 in varchar2 default hr_api.g_varchar2
371: ,p_attribute5 in varchar2 default hr_api.g_varchar2
372: ,p_attribute6 in varchar2 default hr_api.g_varchar2
373: ,p_attribute7 in varchar2 default hr_api.g_varchar2
374: ,p_attribute8 in varchar2 default hr_api.g_varchar2
375: ,p_attribute9 in varchar2 default hr_api.g_varchar2
376: ,p_attribute10 in varchar2 default hr_api.g_varchar2
377: ,p_attribute11 in varchar2 default hr_api.g_varchar2
370: ,p_attribute4 in varchar2 default hr_api.g_varchar2
371: ,p_attribute5 in varchar2 default hr_api.g_varchar2
372: ,p_attribute6 in varchar2 default hr_api.g_varchar2
373: ,p_attribute7 in varchar2 default hr_api.g_varchar2
374: ,p_attribute8 in varchar2 default hr_api.g_varchar2
375: ,p_attribute9 in varchar2 default hr_api.g_varchar2
376: ,p_attribute10 in varchar2 default hr_api.g_varchar2
377: ,p_attribute11 in varchar2 default hr_api.g_varchar2
378: ,p_attribute12 in varchar2 default hr_api.g_varchar2
371: ,p_attribute5 in varchar2 default hr_api.g_varchar2
372: ,p_attribute6 in varchar2 default hr_api.g_varchar2
373: ,p_attribute7 in varchar2 default hr_api.g_varchar2
374: ,p_attribute8 in varchar2 default hr_api.g_varchar2
375: ,p_attribute9 in varchar2 default hr_api.g_varchar2
376: ,p_attribute10 in varchar2 default hr_api.g_varchar2
377: ,p_attribute11 in varchar2 default hr_api.g_varchar2
378: ,p_attribute12 in varchar2 default hr_api.g_varchar2
379: ,p_attribute13 in varchar2 default hr_api.g_varchar2
372: ,p_attribute6 in varchar2 default hr_api.g_varchar2
373: ,p_attribute7 in varchar2 default hr_api.g_varchar2
374: ,p_attribute8 in varchar2 default hr_api.g_varchar2
375: ,p_attribute9 in varchar2 default hr_api.g_varchar2
376: ,p_attribute10 in varchar2 default hr_api.g_varchar2
377: ,p_attribute11 in varchar2 default hr_api.g_varchar2
378: ,p_attribute12 in varchar2 default hr_api.g_varchar2
379: ,p_attribute13 in varchar2 default hr_api.g_varchar2
380: ,p_attribute14 in varchar2 default hr_api.g_varchar2
373: ,p_attribute7 in varchar2 default hr_api.g_varchar2
374: ,p_attribute8 in varchar2 default hr_api.g_varchar2
375: ,p_attribute9 in varchar2 default hr_api.g_varchar2
376: ,p_attribute10 in varchar2 default hr_api.g_varchar2
377: ,p_attribute11 in varchar2 default hr_api.g_varchar2
378: ,p_attribute12 in varchar2 default hr_api.g_varchar2
379: ,p_attribute13 in varchar2 default hr_api.g_varchar2
380: ,p_attribute14 in varchar2 default hr_api.g_varchar2
381: ,p_attribute15 in varchar2 default hr_api.g_varchar2
374: ,p_attribute8 in varchar2 default hr_api.g_varchar2
375: ,p_attribute9 in varchar2 default hr_api.g_varchar2
376: ,p_attribute10 in varchar2 default hr_api.g_varchar2
377: ,p_attribute11 in varchar2 default hr_api.g_varchar2
378: ,p_attribute12 in varchar2 default hr_api.g_varchar2
379: ,p_attribute13 in varchar2 default hr_api.g_varchar2
380: ,p_attribute14 in varchar2 default hr_api.g_varchar2
381: ,p_attribute15 in varchar2 default hr_api.g_varchar2
382: ,p_attribute16 in varchar2 default hr_api.g_varchar2
375: ,p_attribute9 in varchar2 default hr_api.g_varchar2
376: ,p_attribute10 in varchar2 default hr_api.g_varchar2
377: ,p_attribute11 in varchar2 default hr_api.g_varchar2
378: ,p_attribute12 in varchar2 default hr_api.g_varchar2
379: ,p_attribute13 in varchar2 default hr_api.g_varchar2
380: ,p_attribute14 in varchar2 default hr_api.g_varchar2
381: ,p_attribute15 in varchar2 default hr_api.g_varchar2
382: ,p_attribute16 in varchar2 default hr_api.g_varchar2
383: ,p_attribute17 in varchar2 default hr_api.g_varchar2
376: ,p_attribute10 in varchar2 default hr_api.g_varchar2
377: ,p_attribute11 in varchar2 default hr_api.g_varchar2
378: ,p_attribute12 in varchar2 default hr_api.g_varchar2
379: ,p_attribute13 in varchar2 default hr_api.g_varchar2
380: ,p_attribute14 in varchar2 default hr_api.g_varchar2
381: ,p_attribute15 in varchar2 default hr_api.g_varchar2
382: ,p_attribute16 in varchar2 default hr_api.g_varchar2
383: ,p_attribute17 in varchar2 default hr_api.g_varchar2
384: ,p_attribute18 in varchar2 default hr_api.g_varchar2
377: ,p_attribute11 in varchar2 default hr_api.g_varchar2
378: ,p_attribute12 in varchar2 default hr_api.g_varchar2
379: ,p_attribute13 in varchar2 default hr_api.g_varchar2
380: ,p_attribute14 in varchar2 default hr_api.g_varchar2
381: ,p_attribute15 in varchar2 default hr_api.g_varchar2
382: ,p_attribute16 in varchar2 default hr_api.g_varchar2
383: ,p_attribute17 in varchar2 default hr_api.g_varchar2
384: ,p_attribute18 in varchar2 default hr_api.g_varchar2
385: ,p_attribute19 in varchar2 default hr_api.g_varchar2
378: ,p_attribute12 in varchar2 default hr_api.g_varchar2
379: ,p_attribute13 in varchar2 default hr_api.g_varchar2
380: ,p_attribute14 in varchar2 default hr_api.g_varchar2
381: ,p_attribute15 in varchar2 default hr_api.g_varchar2
382: ,p_attribute16 in varchar2 default hr_api.g_varchar2
383: ,p_attribute17 in varchar2 default hr_api.g_varchar2
384: ,p_attribute18 in varchar2 default hr_api.g_varchar2
385: ,p_attribute19 in varchar2 default hr_api.g_varchar2
386: ,p_attribute20 in varchar2 default hr_api.g_varchar2
379: ,p_attribute13 in varchar2 default hr_api.g_varchar2
380: ,p_attribute14 in varchar2 default hr_api.g_varchar2
381: ,p_attribute15 in varchar2 default hr_api.g_varchar2
382: ,p_attribute16 in varchar2 default hr_api.g_varchar2
383: ,p_attribute17 in varchar2 default hr_api.g_varchar2
384: ,p_attribute18 in varchar2 default hr_api.g_varchar2
385: ,p_attribute19 in varchar2 default hr_api.g_varchar2
386: ,p_attribute20 in varchar2 default hr_api.g_varchar2
387: ,p_absiod_of_incapacity_id in number default hr_api.g_number
380: ,p_attribute14 in varchar2 default hr_api.g_varchar2
381: ,p_attribute15 in varchar2 default hr_api.g_varchar2
382: ,p_attribute16 in varchar2 default hr_api.g_varchar2
383: ,p_attribute17 in varchar2 default hr_api.g_varchar2
384: ,p_attribute18 in varchar2 default hr_api.g_varchar2
385: ,p_attribute19 in varchar2 default hr_api.g_varchar2
386: ,p_attribute20 in varchar2 default hr_api.g_varchar2
387: ,p_absiod_of_incapacity_id in number default hr_api.g_number
388: ,p_ssp1_issued in varchar2 default hr_api.g_varchar2
381: ,p_attribute15 in varchar2 default hr_api.g_varchar2
382: ,p_attribute16 in varchar2 default hr_api.g_varchar2
383: ,p_attribute17 in varchar2 default hr_api.g_varchar2
384: ,p_attribute18 in varchar2 default hr_api.g_varchar2
385: ,p_attribute19 in varchar2 default hr_api.g_varchar2
386: ,p_attribute20 in varchar2 default hr_api.g_varchar2
387: ,p_absiod_of_incapacity_id in number default hr_api.g_number
388: ,p_ssp1_issued in varchar2 default hr_api.g_varchar2
389: ,p_maternity_id in number default hr_api.g_number
382: ,p_attribute16 in varchar2 default hr_api.g_varchar2
383: ,p_attribute17 in varchar2 default hr_api.g_varchar2
384: ,p_attribute18 in varchar2 default hr_api.g_varchar2
385: ,p_attribute19 in varchar2 default hr_api.g_varchar2
386: ,p_attribute20 in varchar2 default hr_api.g_varchar2
387: ,p_absiod_of_incapacity_id in number default hr_api.g_number
388: ,p_ssp1_issued in varchar2 default hr_api.g_varchar2
389: ,p_maternity_id in number default hr_api.g_number
390: ,p_sickness_start_date in date default hr_api.g_date
383: ,p_attribute17 in varchar2 default hr_api.g_varchar2
384: ,p_attribute18 in varchar2 default hr_api.g_varchar2
385: ,p_attribute19 in varchar2 default hr_api.g_varchar2
386: ,p_attribute20 in varchar2 default hr_api.g_varchar2
387: ,p_absiod_of_incapacity_id in number default hr_api.g_number
388: ,p_ssp1_issued in varchar2 default hr_api.g_varchar2
389: ,p_maternity_id in number default hr_api.g_number
390: ,p_sickness_start_date in date default hr_api.g_date
391: ,p_sickness_end_date in date default hr_api.g_date
384: ,p_attribute18 in varchar2 default hr_api.g_varchar2
385: ,p_attribute19 in varchar2 default hr_api.g_varchar2
386: ,p_attribute20 in varchar2 default hr_api.g_varchar2
387: ,p_absiod_of_incapacity_id in number default hr_api.g_number
388: ,p_ssp1_issued in varchar2 default hr_api.g_varchar2
389: ,p_maternity_id in number default hr_api.g_number
390: ,p_sickness_start_date in date default hr_api.g_date
391: ,p_sickness_end_date in date default hr_api.g_date
392: ,p_pregnancy_related_illness in varchar2 default hr_api.g_varchar2
385: ,p_attribute19 in varchar2 default hr_api.g_varchar2
386: ,p_attribute20 in varchar2 default hr_api.g_varchar2
387: ,p_absiod_of_incapacity_id in number default hr_api.g_number
388: ,p_ssp1_issued in varchar2 default hr_api.g_varchar2
389: ,p_maternity_id in number default hr_api.g_number
390: ,p_sickness_start_date in date default hr_api.g_date
391: ,p_sickness_end_date in date default hr_api.g_date
392: ,p_pregnancy_related_illness in varchar2 default hr_api.g_varchar2
393: ,p_reason_for_notification_dela in varchar2 default hr_api.g_varchar2
386: ,p_attribute20 in varchar2 default hr_api.g_varchar2
387: ,p_absiod_of_incapacity_id in number default hr_api.g_number
388: ,p_ssp1_issued in varchar2 default hr_api.g_varchar2
389: ,p_maternity_id in number default hr_api.g_number
390: ,p_sickness_start_date in date default hr_api.g_date
391: ,p_sickness_end_date in date default hr_api.g_date
392: ,p_pregnancy_related_illness in varchar2 default hr_api.g_varchar2
393: ,p_reason_for_notification_dela in varchar2 default hr_api.g_varchar2
394: ,p_accept_late_notification_fla in varchar2 default hr_api.g_varchar2
387: ,p_absiod_of_incapacity_id in number default hr_api.g_number
388: ,p_ssp1_issued in varchar2 default hr_api.g_varchar2
389: ,p_maternity_id in number default hr_api.g_number
390: ,p_sickness_start_date in date default hr_api.g_date
391: ,p_sickness_end_date in date default hr_api.g_date
392: ,p_pregnancy_related_illness in varchar2 default hr_api.g_varchar2
393: ,p_reason_for_notification_dela in varchar2 default hr_api.g_varchar2
394: ,p_accept_late_notification_fla in varchar2 default hr_api.g_varchar2
395: ,p_linked_absence_id in number default hr_api.g_number
388: ,p_ssp1_issued in varchar2 default hr_api.g_varchar2
389: ,p_maternity_id in number default hr_api.g_number
390: ,p_sickness_start_date in date default hr_api.g_date
391: ,p_sickness_end_date in date default hr_api.g_date
392: ,p_pregnancy_related_illness in varchar2 default hr_api.g_varchar2
393: ,p_reason_for_notification_dela in varchar2 default hr_api.g_varchar2
394: ,p_accept_late_notification_fla in varchar2 default hr_api.g_varchar2
395: ,p_linked_absence_id in number default hr_api.g_number
396: ,p_batch_id in number default hr_api.g_number
389: ,p_maternity_id in number default hr_api.g_number
390: ,p_sickness_start_date in date default hr_api.g_date
391: ,p_sickness_end_date in date default hr_api.g_date
392: ,p_pregnancy_related_illness in varchar2 default hr_api.g_varchar2
393: ,p_reason_for_notification_dela in varchar2 default hr_api.g_varchar2
394: ,p_accept_late_notification_fla in varchar2 default hr_api.g_varchar2
395: ,p_linked_absence_id in number default hr_api.g_number
396: ,p_batch_id in number default hr_api.g_number
397: ,p_abs_information_category in varchar2 default hr_api.g_varchar2
390: ,p_sickness_start_date in date default hr_api.g_date
391: ,p_sickness_end_date in date default hr_api.g_date
392: ,p_pregnancy_related_illness in varchar2 default hr_api.g_varchar2
393: ,p_reason_for_notification_dela in varchar2 default hr_api.g_varchar2
394: ,p_accept_late_notification_fla in varchar2 default hr_api.g_varchar2
395: ,p_linked_absence_id in number default hr_api.g_number
396: ,p_batch_id in number default hr_api.g_number
397: ,p_abs_information_category in varchar2 default hr_api.g_varchar2
398: ,p_abs_information1 in varchar2 default hr_api.g_varchar2
391: ,p_sickness_end_date in date default hr_api.g_date
392: ,p_pregnancy_related_illness in varchar2 default hr_api.g_varchar2
393: ,p_reason_for_notification_dela in varchar2 default hr_api.g_varchar2
394: ,p_accept_late_notification_fla in varchar2 default hr_api.g_varchar2
395: ,p_linked_absence_id in number default hr_api.g_number
396: ,p_batch_id in number default hr_api.g_number
397: ,p_abs_information_category in varchar2 default hr_api.g_varchar2
398: ,p_abs_information1 in varchar2 default hr_api.g_varchar2
399: ,p_abs_information2 in varchar2 default hr_api.g_varchar2
392: ,p_pregnancy_related_illness in varchar2 default hr_api.g_varchar2
393: ,p_reason_for_notification_dela in varchar2 default hr_api.g_varchar2
394: ,p_accept_late_notification_fla in varchar2 default hr_api.g_varchar2
395: ,p_linked_absence_id in number default hr_api.g_number
396: ,p_batch_id in number default hr_api.g_number
397: ,p_abs_information_category in varchar2 default hr_api.g_varchar2
398: ,p_abs_information1 in varchar2 default hr_api.g_varchar2
399: ,p_abs_information2 in varchar2 default hr_api.g_varchar2
400: ,p_abs_information3 in varchar2 default hr_api.g_varchar2
393: ,p_reason_for_notification_dela in varchar2 default hr_api.g_varchar2
394: ,p_accept_late_notification_fla in varchar2 default hr_api.g_varchar2
395: ,p_linked_absence_id in number default hr_api.g_number
396: ,p_batch_id in number default hr_api.g_number
397: ,p_abs_information_category in varchar2 default hr_api.g_varchar2
398: ,p_abs_information1 in varchar2 default hr_api.g_varchar2
399: ,p_abs_information2 in varchar2 default hr_api.g_varchar2
400: ,p_abs_information3 in varchar2 default hr_api.g_varchar2
401: ,p_abs_information4 in varchar2 default hr_api.g_varchar2
394: ,p_accept_late_notification_fla in varchar2 default hr_api.g_varchar2
395: ,p_linked_absence_id in number default hr_api.g_number
396: ,p_batch_id in number default hr_api.g_number
397: ,p_abs_information_category in varchar2 default hr_api.g_varchar2
398: ,p_abs_information1 in varchar2 default hr_api.g_varchar2
399: ,p_abs_information2 in varchar2 default hr_api.g_varchar2
400: ,p_abs_information3 in varchar2 default hr_api.g_varchar2
401: ,p_abs_information4 in varchar2 default hr_api.g_varchar2
402: ,p_abs_information5 in varchar2 default hr_api.g_varchar2
395: ,p_linked_absence_id in number default hr_api.g_number
396: ,p_batch_id in number default hr_api.g_number
397: ,p_abs_information_category in varchar2 default hr_api.g_varchar2
398: ,p_abs_information1 in varchar2 default hr_api.g_varchar2
399: ,p_abs_information2 in varchar2 default hr_api.g_varchar2
400: ,p_abs_information3 in varchar2 default hr_api.g_varchar2
401: ,p_abs_information4 in varchar2 default hr_api.g_varchar2
402: ,p_abs_information5 in varchar2 default hr_api.g_varchar2
403: ,p_abs_information6 in varchar2 default hr_api.g_varchar2
396: ,p_batch_id in number default hr_api.g_number
397: ,p_abs_information_category in varchar2 default hr_api.g_varchar2
398: ,p_abs_information1 in varchar2 default hr_api.g_varchar2
399: ,p_abs_information2 in varchar2 default hr_api.g_varchar2
400: ,p_abs_information3 in varchar2 default hr_api.g_varchar2
401: ,p_abs_information4 in varchar2 default hr_api.g_varchar2
402: ,p_abs_information5 in varchar2 default hr_api.g_varchar2
403: ,p_abs_information6 in varchar2 default hr_api.g_varchar2
404: ,p_abs_information7 in varchar2 default hr_api.g_varchar2
397: ,p_abs_information_category in varchar2 default hr_api.g_varchar2
398: ,p_abs_information1 in varchar2 default hr_api.g_varchar2
399: ,p_abs_information2 in varchar2 default hr_api.g_varchar2
400: ,p_abs_information3 in varchar2 default hr_api.g_varchar2
401: ,p_abs_information4 in varchar2 default hr_api.g_varchar2
402: ,p_abs_information5 in varchar2 default hr_api.g_varchar2
403: ,p_abs_information6 in varchar2 default hr_api.g_varchar2
404: ,p_abs_information7 in varchar2 default hr_api.g_varchar2
405: ,p_abs_information8 in varchar2 default hr_api.g_varchar2
398: ,p_abs_information1 in varchar2 default hr_api.g_varchar2
399: ,p_abs_information2 in varchar2 default hr_api.g_varchar2
400: ,p_abs_information3 in varchar2 default hr_api.g_varchar2
401: ,p_abs_information4 in varchar2 default hr_api.g_varchar2
402: ,p_abs_information5 in varchar2 default hr_api.g_varchar2
403: ,p_abs_information6 in varchar2 default hr_api.g_varchar2
404: ,p_abs_information7 in varchar2 default hr_api.g_varchar2
405: ,p_abs_information8 in varchar2 default hr_api.g_varchar2
406: ,p_abs_information9 in varchar2 default hr_api.g_varchar2
399: ,p_abs_information2 in varchar2 default hr_api.g_varchar2
400: ,p_abs_information3 in varchar2 default hr_api.g_varchar2
401: ,p_abs_information4 in varchar2 default hr_api.g_varchar2
402: ,p_abs_information5 in varchar2 default hr_api.g_varchar2
403: ,p_abs_information6 in varchar2 default hr_api.g_varchar2
404: ,p_abs_information7 in varchar2 default hr_api.g_varchar2
405: ,p_abs_information8 in varchar2 default hr_api.g_varchar2
406: ,p_abs_information9 in varchar2 default hr_api.g_varchar2
407: ,p_abs_information10 in varchar2 default hr_api.g_varchar2
400: ,p_abs_information3 in varchar2 default hr_api.g_varchar2
401: ,p_abs_information4 in varchar2 default hr_api.g_varchar2
402: ,p_abs_information5 in varchar2 default hr_api.g_varchar2
403: ,p_abs_information6 in varchar2 default hr_api.g_varchar2
404: ,p_abs_information7 in varchar2 default hr_api.g_varchar2
405: ,p_abs_information8 in varchar2 default hr_api.g_varchar2
406: ,p_abs_information9 in varchar2 default hr_api.g_varchar2
407: ,p_abs_information10 in varchar2 default hr_api.g_varchar2
408: ,p_abs_information11 in varchar2 default hr_api.g_varchar2
401: ,p_abs_information4 in varchar2 default hr_api.g_varchar2
402: ,p_abs_information5 in varchar2 default hr_api.g_varchar2
403: ,p_abs_information6 in varchar2 default hr_api.g_varchar2
404: ,p_abs_information7 in varchar2 default hr_api.g_varchar2
405: ,p_abs_information8 in varchar2 default hr_api.g_varchar2
406: ,p_abs_information9 in varchar2 default hr_api.g_varchar2
407: ,p_abs_information10 in varchar2 default hr_api.g_varchar2
408: ,p_abs_information11 in varchar2 default hr_api.g_varchar2
409: ,p_abs_information12 in varchar2 default hr_api.g_varchar2
402: ,p_abs_information5 in varchar2 default hr_api.g_varchar2
403: ,p_abs_information6 in varchar2 default hr_api.g_varchar2
404: ,p_abs_information7 in varchar2 default hr_api.g_varchar2
405: ,p_abs_information8 in varchar2 default hr_api.g_varchar2
406: ,p_abs_information9 in varchar2 default hr_api.g_varchar2
407: ,p_abs_information10 in varchar2 default hr_api.g_varchar2
408: ,p_abs_information11 in varchar2 default hr_api.g_varchar2
409: ,p_abs_information12 in varchar2 default hr_api.g_varchar2
410: ,p_abs_information13 in varchar2 default hr_api.g_varchar2
403: ,p_abs_information6 in varchar2 default hr_api.g_varchar2
404: ,p_abs_information7 in varchar2 default hr_api.g_varchar2
405: ,p_abs_information8 in varchar2 default hr_api.g_varchar2
406: ,p_abs_information9 in varchar2 default hr_api.g_varchar2
407: ,p_abs_information10 in varchar2 default hr_api.g_varchar2
408: ,p_abs_information11 in varchar2 default hr_api.g_varchar2
409: ,p_abs_information12 in varchar2 default hr_api.g_varchar2
410: ,p_abs_information13 in varchar2 default hr_api.g_varchar2
411: ,p_abs_information14 in varchar2 default hr_api.g_varchar2
404: ,p_abs_information7 in varchar2 default hr_api.g_varchar2
405: ,p_abs_information8 in varchar2 default hr_api.g_varchar2
406: ,p_abs_information9 in varchar2 default hr_api.g_varchar2
407: ,p_abs_information10 in varchar2 default hr_api.g_varchar2
408: ,p_abs_information11 in varchar2 default hr_api.g_varchar2
409: ,p_abs_information12 in varchar2 default hr_api.g_varchar2
410: ,p_abs_information13 in varchar2 default hr_api.g_varchar2
411: ,p_abs_information14 in varchar2 default hr_api.g_varchar2
412: ,p_abs_information15 in varchar2 default hr_api.g_varchar2
405: ,p_abs_information8 in varchar2 default hr_api.g_varchar2
406: ,p_abs_information9 in varchar2 default hr_api.g_varchar2
407: ,p_abs_information10 in varchar2 default hr_api.g_varchar2
408: ,p_abs_information11 in varchar2 default hr_api.g_varchar2
409: ,p_abs_information12 in varchar2 default hr_api.g_varchar2
410: ,p_abs_information13 in varchar2 default hr_api.g_varchar2
411: ,p_abs_information14 in varchar2 default hr_api.g_varchar2
412: ,p_abs_information15 in varchar2 default hr_api.g_varchar2
413: ,p_abs_information16 in varchar2 default hr_api.g_varchar2
406: ,p_abs_information9 in varchar2 default hr_api.g_varchar2
407: ,p_abs_information10 in varchar2 default hr_api.g_varchar2
408: ,p_abs_information11 in varchar2 default hr_api.g_varchar2
409: ,p_abs_information12 in varchar2 default hr_api.g_varchar2
410: ,p_abs_information13 in varchar2 default hr_api.g_varchar2
411: ,p_abs_information14 in varchar2 default hr_api.g_varchar2
412: ,p_abs_information15 in varchar2 default hr_api.g_varchar2
413: ,p_abs_information16 in varchar2 default hr_api.g_varchar2
414: ,p_abs_information17 in varchar2 default hr_api.g_varchar2
407: ,p_abs_information10 in varchar2 default hr_api.g_varchar2
408: ,p_abs_information11 in varchar2 default hr_api.g_varchar2
409: ,p_abs_information12 in varchar2 default hr_api.g_varchar2
410: ,p_abs_information13 in varchar2 default hr_api.g_varchar2
411: ,p_abs_information14 in varchar2 default hr_api.g_varchar2
412: ,p_abs_information15 in varchar2 default hr_api.g_varchar2
413: ,p_abs_information16 in varchar2 default hr_api.g_varchar2
414: ,p_abs_information17 in varchar2 default hr_api.g_varchar2
415: ,p_abs_information18 in varchar2 default hr_api.g_varchar2
408: ,p_abs_information11 in varchar2 default hr_api.g_varchar2
409: ,p_abs_information12 in varchar2 default hr_api.g_varchar2
410: ,p_abs_information13 in varchar2 default hr_api.g_varchar2
411: ,p_abs_information14 in varchar2 default hr_api.g_varchar2
412: ,p_abs_information15 in varchar2 default hr_api.g_varchar2
413: ,p_abs_information16 in varchar2 default hr_api.g_varchar2
414: ,p_abs_information17 in varchar2 default hr_api.g_varchar2
415: ,p_abs_information18 in varchar2 default hr_api.g_varchar2
416: ,p_abs_information19 in varchar2 default hr_api.g_varchar2
409: ,p_abs_information12 in varchar2 default hr_api.g_varchar2
410: ,p_abs_information13 in varchar2 default hr_api.g_varchar2
411: ,p_abs_information14 in varchar2 default hr_api.g_varchar2
412: ,p_abs_information15 in varchar2 default hr_api.g_varchar2
413: ,p_abs_information16 in varchar2 default hr_api.g_varchar2
414: ,p_abs_information17 in varchar2 default hr_api.g_varchar2
415: ,p_abs_information18 in varchar2 default hr_api.g_varchar2
416: ,p_abs_information19 in varchar2 default hr_api.g_varchar2
417: ,p_abs_information20 in varchar2 default hr_api.g_varchar2
410: ,p_abs_information13 in varchar2 default hr_api.g_varchar2
411: ,p_abs_information14 in varchar2 default hr_api.g_varchar2
412: ,p_abs_information15 in varchar2 default hr_api.g_varchar2
413: ,p_abs_information16 in varchar2 default hr_api.g_varchar2
414: ,p_abs_information17 in varchar2 default hr_api.g_varchar2
415: ,p_abs_information18 in varchar2 default hr_api.g_varchar2
416: ,p_abs_information19 in varchar2 default hr_api.g_varchar2
417: ,p_abs_information20 in varchar2 default hr_api.g_varchar2
418: ,p_abs_information21 in varchar2 default hr_api.g_varchar2
411: ,p_abs_information14 in varchar2 default hr_api.g_varchar2
412: ,p_abs_information15 in varchar2 default hr_api.g_varchar2
413: ,p_abs_information16 in varchar2 default hr_api.g_varchar2
414: ,p_abs_information17 in varchar2 default hr_api.g_varchar2
415: ,p_abs_information18 in varchar2 default hr_api.g_varchar2
416: ,p_abs_information19 in varchar2 default hr_api.g_varchar2
417: ,p_abs_information20 in varchar2 default hr_api.g_varchar2
418: ,p_abs_information21 in varchar2 default hr_api.g_varchar2
419: ,p_abs_information22 in varchar2 default hr_api.g_varchar2
412: ,p_abs_information15 in varchar2 default hr_api.g_varchar2
413: ,p_abs_information16 in varchar2 default hr_api.g_varchar2
414: ,p_abs_information17 in varchar2 default hr_api.g_varchar2
415: ,p_abs_information18 in varchar2 default hr_api.g_varchar2
416: ,p_abs_information19 in varchar2 default hr_api.g_varchar2
417: ,p_abs_information20 in varchar2 default hr_api.g_varchar2
418: ,p_abs_information21 in varchar2 default hr_api.g_varchar2
419: ,p_abs_information22 in varchar2 default hr_api.g_varchar2
420: ,p_abs_information23 in varchar2 default hr_api.g_varchar2
413: ,p_abs_information16 in varchar2 default hr_api.g_varchar2
414: ,p_abs_information17 in varchar2 default hr_api.g_varchar2
415: ,p_abs_information18 in varchar2 default hr_api.g_varchar2
416: ,p_abs_information19 in varchar2 default hr_api.g_varchar2
417: ,p_abs_information20 in varchar2 default hr_api.g_varchar2
418: ,p_abs_information21 in varchar2 default hr_api.g_varchar2
419: ,p_abs_information22 in varchar2 default hr_api.g_varchar2
420: ,p_abs_information23 in varchar2 default hr_api.g_varchar2
421: ,p_abs_information24 in varchar2 default hr_api.g_varchar2
414: ,p_abs_information17 in varchar2 default hr_api.g_varchar2
415: ,p_abs_information18 in varchar2 default hr_api.g_varchar2
416: ,p_abs_information19 in varchar2 default hr_api.g_varchar2
417: ,p_abs_information20 in varchar2 default hr_api.g_varchar2
418: ,p_abs_information21 in varchar2 default hr_api.g_varchar2
419: ,p_abs_information22 in varchar2 default hr_api.g_varchar2
420: ,p_abs_information23 in varchar2 default hr_api.g_varchar2
421: ,p_abs_information24 in varchar2 default hr_api.g_varchar2
422: ,p_abs_information25 in varchar2 default hr_api.g_varchar2
415: ,p_abs_information18 in varchar2 default hr_api.g_varchar2
416: ,p_abs_information19 in varchar2 default hr_api.g_varchar2
417: ,p_abs_information20 in varchar2 default hr_api.g_varchar2
418: ,p_abs_information21 in varchar2 default hr_api.g_varchar2
419: ,p_abs_information22 in varchar2 default hr_api.g_varchar2
420: ,p_abs_information23 in varchar2 default hr_api.g_varchar2
421: ,p_abs_information24 in varchar2 default hr_api.g_varchar2
422: ,p_abs_information25 in varchar2 default hr_api.g_varchar2
423: ,p_abs_information26 in varchar2 default hr_api.g_varchar2
416: ,p_abs_information19 in varchar2 default hr_api.g_varchar2
417: ,p_abs_information20 in varchar2 default hr_api.g_varchar2
418: ,p_abs_information21 in varchar2 default hr_api.g_varchar2
419: ,p_abs_information22 in varchar2 default hr_api.g_varchar2
420: ,p_abs_information23 in varchar2 default hr_api.g_varchar2
421: ,p_abs_information24 in varchar2 default hr_api.g_varchar2
422: ,p_abs_information25 in varchar2 default hr_api.g_varchar2
423: ,p_abs_information26 in varchar2 default hr_api.g_varchar2
424: ,p_abs_information27 in varchar2 default hr_api.g_varchar2
417: ,p_abs_information20 in varchar2 default hr_api.g_varchar2
418: ,p_abs_information21 in varchar2 default hr_api.g_varchar2
419: ,p_abs_information22 in varchar2 default hr_api.g_varchar2
420: ,p_abs_information23 in varchar2 default hr_api.g_varchar2
421: ,p_abs_information24 in varchar2 default hr_api.g_varchar2
422: ,p_abs_information25 in varchar2 default hr_api.g_varchar2
423: ,p_abs_information26 in varchar2 default hr_api.g_varchar2
424: ,p_abs_information27 in varchar2 default hr_api.g_varchar2
425: ,p_abs_information28 in varchar2 default hr_api.g_varchar2
418: ,p_abs_information21 in varchar2 default hr_api.g_varchar2
419: ,p_abs_information22 in varchar2 default hr_api.g_varchar2
420: ,p_abs_information23 in varchar2 default hr_api.g_varchar2
421: ,p_abs_information24 in varchar2 default hr_api.g_varchar2
422: ,p_abs_information25 in varchar2 default hr_api.g_varchar2
423: ,p_abs_information26 in varchar2 default hr_api.g_varchar2
424: ,p_abs_information27 in varchar2 default hr_api.g_varchar2
425: ,p_abs_information28 in varchar2 default hr_api.g_varchar2
426: ,p_abs_information29 in varchar2 default hr_api.g_varchar2
419: ,p_abs_information22 in varchar2 default hr_api.g_varchar2
420: ,p_abs_information23 in varchar2 default hr_api.g_varchar2
421: ,p_abs_information24 in varchar2 default hr_api.g_varchar2
422: ,p_abs_information25 in varchar2 default hr_api.g_varchar2
423: ,p_abs_information26 in varchar2 default hr_api.g_varchar2
424: ,p_abs_information27 in varchar2 default hr_api.g_varchar2
425: ,p_abs_information28 in varchar2 default hr_api.g_varchar2
426: ,p_abs_information29 in varchar2 default hr_api.g_varchar2
427: ,p_abs_information30 in varchar2 default hr_api.g_varchar2
420: ,p_abs_information23 in varchar2 default hr_api.g_varchar2
421: ,p_abs_information24 in varchar2 default hr_api.g_varchar2
422: ,p_abs_information25 in varchar2 default hr_api.g_varchar2
423: ,p_abs_information26 in varchar2 default hr_api.g_varchar2
424: ,p_abs_information27 in varchar2 default hr_api.g_varchar2
425: ,p_abs_information28 in varchar2 default hr_api.g_varchar2
426: ,p_abs_information29 in varchar2 default hr_api.g_varchar2
427: ,p_abs_information30 in varchar2 default hr_api.g_varchar2
428: ,p_object_version_number in number default hr_api.g_number
421: ,p_abs_information24 in varchar2 default hr_api.g_varchar2
422: ,p_abs_information25 in varchar2 default hr_api.g_varchar2
423: ,p_abs_information26 in varchar2 default hr_api.g_varchar2
424: ,p_abs_information27 in varchar2 default hr_api.g_varchar2
425: ,p_abs_information28 in varchar2 default hr_api.g_varchar2
426: ,p_abs_information29 in varchar2 default hr_api.g_varchar2
427: ,p_abs_information30 in varchar2 default hr_api.g_varchar2
428: ,p_object_version_number in number default hr_api.g_number
429: )
422: ,p_abs_information25 in varchar2 default hr_api.g_varchar2
423: ,p_abs_information26 in varchar2 default hr_api.g_varchar2
424: ,p_abs_information27 in varchar2 default hr_api.g_varchar2
425: ,p_abs_information28 in varchar2 default hr_api.g_varchar2
426: ,p_abs_information29 in varchar2 default hr_api.g_varchar2
427: ,p_abs_information30 in varchar2 default hr_api.g_varchar2
428: ,p_object_version_number in number default hr_api.g_number
429: )
430: return boolean
423: ,p_abs_information26 in varchar2 default hr_api.g_varchar2
424: ,p_abs_information27 in varchar2 default hr_api.g_varchar2
425: ,p_abs_information28 in varchar2 default hr_api.g_varchar2
426: ,p_abs_information29 in varchar2 default hr_api.g_varchar2
427: ,p_abs_information30 in varchar2 default hr_api.g_varchar2
428: ,p_object_version_number in number default hr_api.g_number
429: )
430: return boolean
431: IS
424: ,p_abs_information27 in varchar2 default hr_api.g_varchar2
425: ,p_abs_information28 in varchar2 default hr_api.g_varchar2
426: ,p_abs_information29 in varchar2 default hr_api.g_varchar2
427: ,p_abs_information30 in varchar2 default hr_api.g_varchar2
428: ,p_object_version_number in number default hr_api.g_number
429: )
430: return boolean
431: IS
432:
452: CLOSE gc_get_absence_row;
453: END IF;
454: --
455: ------------------------------------------------------------------------------
456: -- NOTE: We need to use nvl(xxx attribute name, hr_api.g_xxxx) because the
457: -- parameter coming in can be null. If we do not use nvl, then it will
458: -- never be equal to the database null value if the parameter value is
459: -- also null.
460: ------------------------------------------------------------------------------
457: -- parameter coming in can be null. If we do not use nvl, then it will
458: -- never be equal to the database null value if the parameter value is
459: -- also null.
460: ------------------------------------------------------------------------------
461: IF p_date_projected_start <> hr_api.g_date OR p_date_projected_start IS NULL
462: THEN
463: hr_utility.set_location(l_proc,20);
464: IF nvl(p_date_projected_start, hr_api.g_date) <>
465: nvl(l_cur_absence_row.date_projected_start, hr_api.g_date)
460: ------------------------------------------------------------------------------
461: IF p_date_projected_start <> hr_api.g_date OR p_date_projected_start IS NULL
462: THEN
463: hr_utility.set_location(l_proc,20);
464: IF nvl(p_date_projected_start, hr_api.g_date) <>
465: nvl(l_cur_absence_row.date_projected_start, hr_api.g_date)
466: THEN
467: hr_utility.set_location(' Leaving:' || l_proc,25);
468: return TRUE;
461: IF p_date_projected_start <> hr_api.g_date OR p_date_projected_start IS NULL
462: THEN
463: hr_utility.set_location(l_proc,20);
464: IF nvl(p_date_projected_start, hr_api.g_date) <>
465: nvl(l_cur_absence_row.date_projected_start, hr_api.g_date)
466: THEN
467: hr_utility.set_location(' Leaving:' || l_proc,25);
468: return TRUE;
469: END IF;
468: return TRUE;
469: END IF;
470: END IF;
471: --
472: IF p_date_projected_end <> hr_api.g_date OR p_date_projected_end IS NULL
473: THEN
474: IF nvl(p_date_projected_end, hr_api.g_date) <>
475: nvl(l_cur_absence_row.date_projected_end, hr_api.g_date)
476: THEN
470: END IF;
471: --
472: IF p_date_projected_end <> hr_api.g_date OR p_date_projected_end IS NULL
473: THEN
474: IF nvl(p_date_projected_end, hr_api.g_date) <>
475: nvl(l_cur_absence_row.date_projected_end, hr_api.g_date)
476: THEN
477: hr_utility.set_location(' Leaving:' || l_proc,30);
478: return TRUE;
471: --
472: IF p_date_projected_end <> hr_api.g_date OR p_date_projected_end IS NULL
473: THEN
474: IF nvl(p_date_projected_end, hr_api.g_date) <>
475: nvl(l_cur_absence_row.date_projected_end, hr_api.g_date)
476: THEN
477: hr_utility.set_location(' Leaving:' || l_proc,30);
478: return TRUE;
479: END IF;
478: return TRUE;
479: END IF;
480: END IF;
481: --
482: IF p_time_projected_start <> hr_api.g_varchar2 OR p_time_projected_start IS NULL
483: THEN
484: IF nvl(p_time_projected_start, hr_api.g_varchar2) <>
485: nvl(l_cur_absence_row.time_projected_start, hr_api.g_varchar2)
486: THEN
480: END IF;
481: --
482: IF p_time_projected_start <> hr_api.g_varchar2 OR p_time_projected_start IS NULL
483: THEN
484: IF nvl(p_time_projected_start, hr_api.g_varchar2) <>
485: nvl(l_cur_absence_row.time_projected_start, hr_api.g_varchar2)
486: THEN
487: hr_utility.set_location(' Leaving:' || l_proc,35);
488: return TRUE;
481: --
482: IF p_time_projected_start <> hr_api.g_varchar2 OR p_time_projected_start IS NULL
483: THEN
484: IF nvl(p_time_projected_start, hr_api.g_varchar2) <>
485: nvl(l_cur_absence_row.time_projected_start, hr_api.g_varchar2)
486: THEN
487: hr_utility.set_location(' Leaving:' || l_proc,35);
488: return TRUE;
489: END IF;
488: return TRUE;
489: END IF;
490: END IF;
491: --
492: IF p_time_projected_end <> hr_api.g_varchar2 OR p_time_projected_end IS NULL
493: THEN
494: IF nvl(p_time_projected_end, hr_api.g_varchar2) <>
495: nvl(l_cur_absence_row.time_projected_end, hr_api.g_varchar2)
496: THEN
490: END IF;
491: --
492: IF p_time_projected_end <> hr_api.g_varchar2 OR p_time_projected_end IS NULL
493: THEN
494: IF nvl(p_time_projected_end, hr_api.g_varchar2) <>
495: nvl(l_cur_absence_row.time_projected_end, hr_api.g_varchar2)
496: THEN
497: hr_utility.set_location(' Leaving:' || l_proc,40);
498: return TRUE;
491: --
492: IF p_time_projected_end <> hr_api.g_varchar2 OR p_time_projected_end IS NULL
493: THEN
494: IF nvl(p_time_projected_end, hr_api.g_varchar2) <>
495: nvl(l_cur_absence_row.time_projected_end, hr_api.g_varchar2)
496: THEN
497: hr_utility.set_location(' Leaving:' || l_proc,40);
498: return TRUE;
499: END IF;
498: return TRUE;
499: END IF;
500: END IF;
501: --
502: IF p_date_start <> hr_api.g_date OR p_date_start IS NULL
503: THEN
504: IF nvl(p_date_start, hr_api.g_date) <>
505: nvl(l_cur_absence_row.date_start, hr_api.g_date)
506: THEN
500: END IF;
501: --
502: IF p_date_start <> hr_api.g_date OR p_date_start IS NULL
503: THEN
504: IF nvl(p_date_start, hr_api.g_date) <>
505: nvl(l_cur_absence_row.date_start, hr_api.g_date)
506: THEN
507: hr_utility.set_location(' Leaving:' || l_proc,45);
508: return TRUE;
501: --
502: IF p_date_start <> hr_api.g_date OR p_date_start IS NULL
503: THEN
504: IF nvl(p_date_start, hr_api.g_date) <>
505: nvl(l_cur_absence_row.date_start, hr_api.g_date)
506: THEN
507: hr_utility.set_location(' Leaving:' || l_proc,45);
508: return TRUE;
509: END IF;
508: return TRUE;
509: END IF;
510: END IF;
511: --
512: IF p_date_end <> hr_api.g_date OR p_date_end IS NULL
513: THEN
514: IF nvl(p_date_end, hr_api.g_date) <>
515: nvl(l_cur_absence_row.date_end, hr_api.g_date)
516: THEN
510: END IF;
511: --
512: IF p_date_end <> hr_api.g_date OR p_date_end IS NULL
513: THEN
514: IF nvl(p_date_end, hr_api.g_date) <>
515: nvl(l_cur_absence_row.date_end, hr_api.g_date)
516: THEN
517: hr_utility.set_location(' Leaving:' || l_proc,50);
518: return TRUE;
511: --
512: IF p_date_end <> hr_api.g_date OR p_date_end IS NULL
513: THEN
514: IF nvl(p_date_end, hr_api.g_date) <>
515: nvl(l_cur_absence_row.date_end, hr_api.g_date)
516: THEN
517: hr_utility.set_location(' Leaving:' || l_proc,50);
518: return TRUE;
519: END IF;
518: return TRUE;
519: END IF;
520: END IF;
521: --
522: IF p_time_start <> hr_api.g_varchar2 OR p_time_start IS NULL
523: THEN
524: IF nvl(p_time_start, hr_api.g_varchar2) <>
525: nvl(l_cur_absence_row.time_start, hr_api.g_varchar2)
526: THEN
520: END IF;
521: --
522: IF p_time_start <> hr_api.g_varchar2 OR p_time_start IS NULL
523: THEN
524: IF nvl(p_time_start, hr_api.g_varchar2) <>
525: nvl(l_cur_absence_row.time_start, hr_api.g_varchar2)
526: THEN
527: hr_utility.set_location(' Leaving:' || l_proc,55);
528: return TRUE;
521: --
522: IF p_time_start <> hr_api.g_varchar2 OR p_time_start IS NULL
523: THEN
524: IF nvl(p_time_start, hr_api.g_varchar2) <>
525: nvl(l_cur_absence_row.time_start, hr_api.g_varchar2)
526: THEN
527: hr_utility.set_location(' Leaving:' || l_proc,55);
528: return TRUE;
529: END IF;
528: return TRUE;
529: END IF;
530: END IF;
531: --
532: IF p_time_end <> hr_api.g_varchar2 OR p_time_end IS NULL
533: THEN
534: IF nvl(p_time_end, hr_api.g_varchar2) <>
535: nvl(l_cur_absence_row.time_end, hr_api.g_varchar2)
536: THEN
530: END IF;
531: --
532: IF p_time_end <> hr_api.g_varchar2 OR p_time_end IS NULL
533: THEN
534: IF nvl(p_time_end, hr_api.g_varchar2) <>
535: nvl(l_cur_absence_row.time_end, hr_api.g_varchar2)
536: THEN
537: hr_utility.set_location(' Leaving:' || l_proc,60);
538: return TRUE;
531: --
532: IF p_time_end <> hr_api.g_varchar2 OR p_time_end IS NULL
533: THEN
534: IF nvl(p_time_end, hr_api.g_varchar2) <>
535: nvl(l_cur_absence_row.time_end, hr_api.g_varchar2)
536: THEN
537: hr_utility.set_location(' Leaving:' || l_proc,60);
538: return TRUE;
539: END IF;
538: return TRUE;
539: END IF;
540: END IF;
541: --
542: IF p_absence_days <> hr_api.g_number OR p_absence_days IS NULL
543: THEN
544: IF nvl(p_absence_days, hr_api.g_number) <>
545: nvl(l_cur_absence_row.absence_days, hr_api.g_number)
546: THEN
540: END IF;
541: --
542: IF p_absence_days <> hr_api.g_number OR p_absence_days IS NULL
543: THEN
544: IF nvl(p_absence_days, hr_api.g_number) <>
545: nvl(l_cur_absence_row.absence_days, hr_api.g_number)
546: THEN
547: hr_utility.set_location(' Leaving:' || l_proc,65);
548: return TRUE;
541: --
542: IF p_absence_days <> hr_api.g_number OR p_absence_days IS NULL
543: THEN
544: IF nvl(p_absence_days, hr_api.g_number) <>
545: nvl(l_cur_absence_row.absence_days, hr_api.g_number)
546: THEN
547: hr_utility.set_location(' Leaving:' || l_proc,65);
548: return TRUE;
549: END IF;
548: return TRUE;
549: END IF;
550: END IF;
551: --
552: IF p_absence_hours <> hr_api.g_number OR p_absence_hours IS NULL
553: THEN
554: IF nvl(p_absence_hours, hr_api.g_number) <>
555: nvl(l_cur_absence_row.absence_hours, hr_api.g_number)
556: THEN
550: END IF;
551: --
552: IF p_absence_hours <> hr_api.g_number OR p_absence_hours IS NULL
553: THEN
554: IF nvl(p_absence_hours, hr_api.g_number) <>
555: nvl(l_cur_absence_row.absence_hours, hr_api.g_number)
556: THEN
557: hr_utility.set_location(' Leaving:' || l_proc,70);
558: return TRUE;
551: --
552: IF p_absence_hours <> hr_api.g_number OR p_absence_hours IS NULL
553: THEN
554: IF nvl(p_absence_hours, hr_api.g_number) <>
555: nvl(l_cur_absence_row.absence_hours, hr_api.g_number)
556: THEN
557: hr_utility.set_location(' Leaving:' || l_proc,70);
558: return TRUE;
559: END IF;
558: return TRUE;
559: END IF;
560: END IF;
561: --
562: IF p_replacement_person_id <> hr_api.g_number OR p_replacement_person_id IS NULL
563: THEN
564: IF nvl(p_replacement_person_id, hr_api.g_number) <>
565: nvl(l_cur_absence_row.replacement_person_id, hr_api.g_number)
566: THEN
560: END IF;
561: --
562: IF p_replacement_person_id <> hr_api.g_number OR p_replacement_person_id IS NULL
563: THEN
564: IF nvl(p_replacement_person_id, hr_api.g_number) <>
565: nvl(l_cur_absence_row.replacement_person_id, hr_api.g_number)
566: THEN
567: hr_utility.set_location(' Leaving:' || l_proc,70);
568: return TRUE;
561: --
562: IF p_replacement_person_id <> hr_api.g_number OR p_replacement_person_id IS NULL
563: THEN
564: IF nvl(p_replacement_person_id, hr_api.g_number) <>
565: nvl(l_cur_absence_row.replacement_person_id, hr_api.g_number)
566: THEN
567: hr_utility.set_location(' Leaving:' || l_proc,70);
568: return TRUE;
569: END IF;
568: return TRUE;
569: END IF;
570: END IF;
571: --
572: IF p_comments <> hr_api.g_varchar2 OR p_comments IS NULL
573: THEN
574: IF nvl(p_comments, hr_api.g_varchar2) <>
575: nvl(l_cur_absence_row.comments, hr_api.g_varchar2)
576: THEN
570: END IF;
571: --
572: IF p_comments <> hr_api.g_varchar2 OR p_comments IS NULL
573: THEN
574: IF nvl(p_comments, hr_api.g_varchar2) <>
575: nvl(l_cur_absence_row.comments, hr_api.g_varchar2)
576: THEN
577: hr_utility.set_location(' Leaving:' || l_proc,75);
578: return TRUE;
571: --
572: IF p_comments <> hr_api.g_varchar2 OR p_comments IS NULL
573: THEN
574: IF nvl(p_comments, hr_api.g_varchar2) <>
575: nvl(l_cur_absence_row.comments, hr_api.g_varchar2)
576: THEN
577: hr_utility.set_location(' Leaving:' || l_proc,75);
578: return TRUE;
579: END IF;
578: return TRUE;
579: END IF;
580: END IF;
581: --
582: IF p_attribute_category <> hr_api.g_varchar2 OR p_attribute_category IS NULL
583: THEN
584: IF nvl(p_attribute_category, hr_api.g_varchar2) <>
585: nvl(l_cur_absence_row.attribute_category, hr_api.g_varchar2)
586: THEN
580: END IF;
581: --
582: IF p_attribute_category <> hr_api.g_varchar2 OR p_attribute_category IS NULL
583: THEN
584: IF nvl(p_attribute_category, hr_api.g_varchar2) <>
585: nvl(l_cur_absence_row.attribute_category, hr_api.g_varchar2)
586: THEN
587: hr_utility.set_location(' Leaving:' || l_proc,80);
588: return TRUE;
581: --
582: IF p_attribute_category <> hr_api.g_varchar2 OR p_attribute_category IS NULL
583: THEN
584: IF nvl(p_attribute_category, hr_api.g_varchar2) <>
585: nvl(l_cur_absence_row.attribute_category, hr_api.g_varchar2)
586: THEN
587: hr_utility.set_location(' Leaving:' || l_proc,80);
588: return TRUE;
589: END IF;
588: return TRUE;
589: END IF;
590: END IF;
591: --
592: IF p_attribute1 <> hr_api.g_varchar2 OR p_attribute1 IS NULL
593: THEN
594: IF nvl(p_attribute1, hr_api.g_varchar2) <>
595: nvl(l_cur_absence_row.attribute1, hr_api.g_varchar2)
596: THEN
590: END IF;
591: --
592: IF p_attribute1 <> hr_api.g_varchar2 OR p_attribute1 IS NULL
593: THEN
594: IF nvl(p_attribute1, hr_api.g_varchar2) <>
595: nvl(l_cur_absence_row.attribute1, hr_api.g_varchar2)
596: THEN
597: hr_utility.set_location(' Leaving:' || l_proc,85);
598: return TRUE;
591: --
592: IF p_attribute1 <> hr_api.g_varchar2 OR p_attribute1 IS NULL
593: THEN
594: IF nvl(p_attribute1, hr_api.g_varchar2) <>
595: nvl(l_cur_absence_row.attribute1, hr_api.g_varchar2)
596: THEN
597: hr_utility.set_location(' Leaving:' || l_proc,85);
598: return TRUE;
599: END IF;
598: return TRUE;
599: END IF;
600: END IF;
601: --
602: IF p_attribute2 <> hr_api.g_varchar2 OR p_attribute2 IS NULL
603: THEN
604: IF nvl(p_attribute2, hr_api.g_varchar2) <>
605: nvl(l_cur_absence_row.attribute2, hr_api.g_varchar2)
606: THEN
600: END IF;
601: --
602: IF p_attribute2 <> hr_api.g_varchar2 OR p_attribute2 IS NULL
603: THEN
604: IF nvl(p_attribute2, hr_api.g_varchar2) <>
605: nvl(l_cur_absence_row.attribute2, hr_api.g_varchar2)
606: THEN
607: hr_utility.set_location(' Leaving:' || l_proc,90);
608: return TRUE;
601: --
602: IF p_attribute2 <> hr_api.g_varchar2 OR p_attribute2 IS NULL
603: THEN
604: IF nvl(p_attribute2, hr_api.g_varchar2) <>
605: nvl(l_cur_absence_row.attribute2, hr_api.g_varchar2)
606: THEN
607: hr_utility.set_location(' Leaving:' || l_proc,90);
608: return TRUE;
609: END IF;
608: return TRUE;
609: END IF;
610: END IF;
611: --
612: IF p_attribute3 <> hr_api.g_varchar2 OR p_attribute3 IS NULL
613: THEN
614: IF nvl(p_attribute3, hr_api.g_varchar2) <>
615: nvl(l_cur_absence_row.attribute3, hr_api.g_varchar2)
616: THEN
610: END IF;
611: --
612: IF p_attribute3 <> hr_api.g_varchar2 OR p_attribute3 IS NULL
613: THEN
614: IF nvl(p_attribute3, hr_api.g_varchar2) <>
615: nvl(l_cur_absence_row.attribute3, hr_api.g_varchar2)
616: THEN
617: hr_utility.set_location(' Leaving:' || l_proc,95);
618: return TRUE;
611: --
612: IF p_attribute3 <> hr_api.g_varchar2 OR p_attribute3 IS NULL
613: THEN
614: IF nvl(p_attribute3, hr_api.g_varchar2) <>
615: nvl(l_cur_absence_row.attribute3, hr_api.g_varchar2)
616: THEN
617: hr_utility.set_location(' Leaving:' || l_proc,95);
618: return TRUE;
619: END IF;
618: return TRUE;
619: END IF;
620: END IF;
621: --
622: IF p_attribute4 <> hr_api.g_varchar2 OR p_attribute4 IS NULL
623: THEN
624: IF nvl(p_attribute4, hr_api.g_varchar2) <>
625: nvl(l_cur_absence_row.attribute4, hr_api.g_varchar2)
626: THEN
620: END IF;
621: --
622: IF p_attribute4 <> hr_api.g_varchar2 OR p_attribute4 IS NULL
623: THEN
624: IF nvl(p_attribute4, hr_api.g_varchar2) <>
625: nvl(l_cur_absence_row.attribute4, hr_api.g_varchar2)
626: THEN
627: hr_utility.set_location(' Leaving:' || l_proc,100);
628: return TRUE;
621: --
622: IF p_attribute4 <> hr_api.g_varchar2 OR p_attribute4 IS NULL
623: THEN
624: IF nvl(p_attribute4, hr_api.g_varchar2) <>
625: nvl(l_cur_absence_row.attribute4, hr_api.g_varchar2)
626: THEN
627: hr_utility.set_location(' Leaving:' || l_proc,100);
628: return TRUE;
629: END IF;
628: return TRUE;
629: END IF;
630: END IF;
631: --
632: IF p_attribute5 <> hr_api.g_varchar2 OR p_attribute5 IS NULL
633: THEN
634: IF nvl(p_attribute5, hr_api.g_varchar2) <>
635: nvl(l_cur_absence_row.attribute5, hr_api.g_varchar2)
636: THEN
630: END IF;
631: --
632: IF p_attribute5 <> hr_api.g_varchar2 OR p_attribute5 IS NULL
633: THEN
634: IF nvl(p_attribute5, hr_api.g_varchar2) <>
635: nvl(l_cur_absence_row.attribute5, hr_api.g_varchar2)
636: THEN
637: hr_utility.set_location(' Leaving:' || l_proc,105);
638: return TRUE;
631: --
632: IF p_attribute5 <> hr_api.g_varchar2 OR p_attribute5 IS NULL
633: THEN
634: IF nvl(p_attribute5, hr_api.g_varchar2) <>
635: nvl(l_cur_absence_row.attribute5, hr_api.g_varchar2)
636: THEN
637: hr_utility.set_location(' Leaving:' || l_proc,105);
638: return TRUE;
639: END IF;
638: return TRUE;
639: END IF;
640: END IF;
641: --
642: IF p_attribute6 <> hr_api.g_varchar2 OR p_attribute6 IS NULL
643: THEN
644: IF nvl(p_attribute6, hr_api.g_varchar2) <>
645: nvl(l_cur_absence_row.attribute6, hr_api.g_varchar2)
646: THEN
640: END IF;
641: --
642: IF p_attribute6 <> hr_api.g_varchar2 OR p_attribute6 IS NULL
643: THEN
644: IF nvl(p_attribute6, hr_api.g_varchar2) <>
645: nvl(l_cur_absence_row.attribute6, hr_api.g_varchar2)
646: THEN
647: hr_utility.set_location(' Leaving:' || l_proc,110);
648: return TRUE;
641: --
642: IF p_attribute6 <> hr_api.g_varchar2 OR p_attribute6 IS NULL
643: THEN
644: IF nvl(p_attribute6, hr_api.g_varchar2) <>
645: nvl(l_cur_absence_row.attribute6, hr_api.g_varchar2)
646: THEN
647: hr_utility.set_location(' Leaving:' || l_proc,110);
648: return TRUE;
649: END IF;
648: return TRUE;
649: END IF;
650: END IF;
651: --
652: IF p_attribute7 <> hr_api.g_varchar2 OR p_attribute7 IS NULL
653: THEN
654: IF nvl(p_attribute7, hr_api.g_varchar2) <>
655: nvl(l_cur_absence_row.attribute7, hr_api.g_varchar2)
656: THEN
650: END IF;
651: --
652: IF p_attribute7 <> hr_api.g_varchar2 OR p_attribute7 IS NULL
653: THEN
654: IF nvl(p_attribute7, hr_api.g_varchar2) <>
655: nvl(l_cur_absence_row.attribute7, hr_api.g_varchar2)
656: THEN
657: hr_utility.set_location(' Leaving:' || l_proc,115);
658: return TRUE;
651: --
652: IF p_attribute7 <> hr_api.g_varchar2 OR p_attribute7 IS NULL
653: THEN
654: IF nvl(p_attribute7, hr_api.g_varchar2) <>
655: nvl(l_cur_absence_row.attribute7, hr_api.g_varchar2)
656: THEN
657: hr_utility.set_location(' Leaving:' || l_proc,115);
658: return TRUE;
659: END IF;
658: return TRUE;
659: END IF;
660: END IF;
661: --
662: IF p_attribute8 <> hr_api.g_varchar2 OR p_attribute8 IS NULL
663: THEN
664: IF nvl(p_attribute8, hr_api.g_varchar2) <>
665: nvl(l_cur_absence_row.attribute8, hr_api.g_varchar2)
666: THEN
660: END IF;
661: --
662: IF p_attribute8 <> hr_api.g_varchar2 OR p_attribute8 IS NULL
663: THEN
664: IF nvl(p_attribute8, hr_api.g_varchar2) <>
665: nvl(l_cur_absence_row.attribute8, hr_api.g_varchar2)
666: THEN
667: hr_utility.set_location(' Leaving:' || l_proc,120);
668: return TRUE;
661: --
662: IF p_attribute8 <> hr_api.g_varchar2 OR p_attribute8 IS NULL
663: THEN
664: IF nvl(p_attribute8, hr_api.g_varchar2) <>
665: nvl(l_cur_absence_row.attribute8, hr_api.g_varchar2)
666: THEN
667: hr_utility.set_location(' Leaving:' || l_proc,120);
668: return TRUE;
669: END IF;
668: return TRUE;
669: END IF;
670: END IF;
671: --
672: IF p_attribute9 <> hr_api.g_varchar2 OR p_attribute9 IS NULL
673: THEN
674: IF nvl(p_attribute9, hr_api.g_varchar2) <>
675: nvl(l_cur_absence_row.attribute9, hr_api.g_varchar2)
676: THEN
670: END IF;
671: --
672: IF p_attribute9 <> hr_api.g_varchar2 OR p_attribute9 IS NULL
673: THEN
674: IF nvl(p_attribute9, hr_api.g_varchar2) <>
675: nvl(l_cur_absence_row.attribute9, hr_api.g_varchar2)
676: THEN
677: hr_utility.set_location(' Leaving:' || l_proc,125);
678: return TRUE;
671: --
672: IF p_attribute9 <> hr_api.g_varchar2 OR p_attribute9 IS NULL
673: THEN
674: IF nvl(p_attribute9, hr_api.g_varchar2) <>
675: nvl(l_cur_absence_row.attribute9, hr_api.g_varchar2)
676: THEN
677: hr_utility.set_location(' Leaving:' || l_proc,125);
678: return TRUE;
679: END IF;
678: return TRUE;
679: END IF;
680: END IF;
681: --
682: IF p_attribute10 <> hr_api.g_varchar2 OR p_attribute10 IS NULL
683: THEN
684: IF nvl(p_attribute10, hr_api.g_varchar2) <>
685: nvl(l_cur_absence_row.attribute10, hr_api.g_varchar2)
686: THEN
680: END IF;
681: --
682: IF p_attribute10 <> hr_api.g_varchar2 OR p_attribute10 IS NULL
683: THEN
684: IF nvl(p_attribute10, hr_api.g_varchar2) <>
685: nvl(l_cur_absence_row.attribute10, hr_api.g_varchar2)
686: THEN
687: hr_utility.set_location(' Leaving:' || l_proc,130);
688: return TRUE;
681: --
682: IF p_attribute10 <> hr_api.g_varchar2 OR p_attribute10 IS NULL
683: THEN
684: IF nvl(p_attribute10, hr_api.g_varchar2) <>
685: nvl(l_cur_absence_row.attribute10, hr_api.g_varchar2)
686: THEN
687: hr_utility.set_location(' Leaving:' || l_proc,130);
688: return TRUE;
689: END IF;
688: return TRUE;
689: END IF;
690: END IF;
691: --
692: IF p_attribute11 <> hr_api.g_varchar2 OR p_attribute11 IS NULL
693: THEN
694: IF nvl(p_attribute11, hr_api.g_varchar2) <>
695: nvl(l_cur_absence_row.attribute11, hr_api.g_varchar2)
696: THEN
690: END IF;
691: --
692: IF p_attribute11 <> hr_api.g_varchar2 OR p_attribute11 IS NULL
693: THEN
694: IF nvl(p_attribute11, hr_api.g_varchar2) <>
695: nvl(l_cur_absence_row.attribute11, hr_api.g_varchar2)
696: THEN
697: hr_utility.set_location(' Leaving:' || l_proc,135);
698: return TRUE;
691: --
692: IF p_attribute11 <> hr_api.g_varchar2 OR p_attribute11 IS NULL
693: THEN
694: IF nvl(p_attribute11, hr_api.g_varchar2) <>
695: nvl(l_cur_absence_row.attribute11, hr_api.g_varchar2)
696: THEN
697: hr_utility.set_location(' Leaving:' || l_proc,135);
698: return TRUE;
699: END IF;
698: return TRUE;
699: END IF;
700: END IF;
701: --
702: IF p_attribute12 <> hr_api.g_varchar2 OR p_attribute12 IS NULL
703: THEN
704: IF nvl(p_attribute12, hr_api.g_varchar2) <>
705: nvl(l_cur_absence_row.attribute12, hr_api.g_varchar2)
706: THEN
700: END IF;
701: --
702: IF p_attribute12 <> hr_api.g_varchar2 OR p_attribute12 IS NULL
703: THEN
704: IF nvl(p_attribute12, hr_api.g_varchar2) <>
705: nvl(l_cur_absence_row.attribute12, hr_api.g_varchar2)
706: THEN
707: hr_utility.set_location(' Leaving:' || l_proc,140);
708: return TRUE;
701: --
702: IF p_attribute12 <> hr_api.g_varchar2 OR p_attribute12 IS NULL
703: THEN
704: IF nvl(p_attribute12, hr_api.g_varchar2) <>
705: nvl(l_cur_absence_row.attribute12, hr_api.g_varchar2)
706: THEN
707: hr_utility.set_location(' Leaving:' || l_proc,140);
708: return TRUE;
709: END IF;
708: return TRUE;
709: END IF;
710: END IF;
711: --
712: IF p_attribute13 <> hr_api.g_varchar2 OR p_attribute13 IS NULL
713: THEN
714: IF nvl(p_attribute13, hr_api.g_varchar2) <>
715: nvl(l_cur_absence_row.attribute13, hr_api.g_varchar2)
716: THEN
710: END IF;
711: --
712: IF p_attribute13 <> hr_api.g_varchar2 OR p_attribute13 IS NULL
713: THEN
714: IF nvl(p_attribute13, hr_api.g_varchar2) <>
715: nvl(l_cur_absence_row.attribute13, hr_api.g_varchar2)
716: THEN
717: hr_utility.set_location(' Leaving:' || l_proc,145);
718: return TRUE;
711: --
712: IF p_attribute13 <> hr_api.g_varchar2 OR p_attribute13 IS NULL
713: THEN
714: IF nvl(p_attribute13, hr_api.g_varchar2) <>
715: nvl(l_cur_absence_row.attribute13, hr_api.g_varchar2)
716: THEN
717: hr_utility.set_location(' Leaving:' || l_proc,145);
718: return TRUE;
719: END IF;
718: return TRUE;
719: END IF;
720: END IF;
721: --
722: IF p_attribute14 <> hr_api.g_varchar2 OR p_attribute14 IS NULL
723: THEN
724: IF nvl(p_attribute14, hr_api.g_varchar2) <>
725: nvl(l_cur_absence_row.attribute14, hr_api.g_varchar2)
726: THEN
720: END IF;
721: --
722: IF p_attribute14 <> hr_api.g_varchar2 OR p_attribute14 IS NULL
723: THEN
724: IF nvl(p_attribute14, hr_api.g_varchar2) <>
725: nvl(l_cur_absence_row.attribute14, hr_api.g_varchar2)
726: THEN
727: hr_utility.set_location(' Leaving:' || l_proc,150);
728: return TRUE;
721: --
722: IF p_attribute14 <> hr_api.g_varchar2 OR p_attribute14 IS NULL
723: THEN
724: IF nvl(p_attribute14, hr_api.g_varchar2) <>
725: nvl(l_cur_absence_row.attribute14, hr_api.g_varchar2)
726: THEN
727: hr_utility.set_location(' Leaving:' || l_proc,150);
728: return TRUE;
729: END IF;
728: return TRUE;
729: END IF;
730: END IF;
731: --
732: IF p_attribute15 <> hr_api.g_varchar2 OR p_attribute15 IS NULL
733: THEN
734: IF nvl(p_attribute15, hr_api.g_varchar2) <>
735: nvl(l_cur_absence_row.attribute15, hr_api.g_varchar2)
736: THEN
730: END IF;
731: --
732: IF p_attribute15 <> hr_api.g_varchar2 OR p_attribute15 IS NULL
733: THEN
734: IF nvl(p_attribute15, hr_api.g_varchar2) <>
735: nvl(l_cur_absence_row.attribute15, hr_api.g_varchar2)
736: THEN
737: hr_utility.set_location(' Leaving:' || l_proc,155);
738: return TRUE;
731: --
732: IF p_attribute15 <> hr_api.g_varchar2 OR p_attribute15 IS NULL
733: THEN
734: IF nvl(p_attribute15, hr_api.g_varchar2) <>
735: nvl(l_cur_absence_row.attribute15, hr_api.g_varchar2)
736: THEN
737: hr_utility.set_location(' Leaving:' || l_proc,155);
738: return TRUE;
739: END IF;
738: return TRUE;
739: END IF;
740: END IF;
741: --
742: IF p_attribute16 <> hr_api.g_varchar2 OR p_attribute16 IS NULL
743: THEN
744: IF nvl(p_attribute16, hr_api.g_varchar2) <>
745: nvl(l_cur_absence_row.attribute16, hr_api.g_varchar2)
746: THEN
740: END IF;
741: --
742: IF p_attribute16 <> hr_api.g_varchar2 OR p_attribute16 IS NULL
743: THEN
744: IF nvl(p_attribute16, hr_api.g_varchar2) <>
745: nvl(l_cur_absence_row.attribute16, hr_api.g_varchar2)
746: THEN
747: hr_utility.set_location(' Leaving:' || l_proc,160);
748: return TRUE;
741: --
742: IF p_attribute16 <> hr_api.g_varchar2 OR p_attribute16 IS NULL
743: THEN
744: IF nvl(p_attribute16, hr_api.g_varchar2) <>
745: nvl(l_cur_absence_row.attribute16, hr_api.g_varchar2)
746: THEN
747: hr_utility.set_location(' Leaving:' || l_proc,160);
748: return TRUE;
749: END IF;
748: return TRUE;
749: END IF;
750: END IF;
751: --
752: IF p_attribute17 <> hr_api.g_varchar2 OR p_attribute17 IS NULL
753: THEN
754: IF nvl(p_attribute17, hr_api.g_varchar2) <>
755: nvl(l_cur_absence_row.attribute17, hr_api.g_varchar2)
756: THEN
750: END IF;
751: --
752: IF p_attribute17 <> hr_api.g_varchar2 OR p_attribute17 IS NULL
753: THEN
754: IF nvl(p_attribute17, hr_api.g_varchar2) <>
755: nvl(l_cur_absence_row.attribute17, hr_api.g_varchar2)
756: THEN
757: hr_utility.set_location(' Leaving:' || l_proc,165);
758: return TRUE;
751: --
752: IF p_attribute17 <> hr_api.g_varchar2 OR p_attribute17 IS NULL
753: THEN
754: IF nvl(p_attribute17, hr_api.g_varchar2) <>
755: nvl(l_cur_absence_row.attribute17, hr_api.g_varchar2)
756: THEN
757: hr_utility.set_location(' Leaving:' || l_proc,165);
758: return TRUE;
759: END IF;
758: return TRUE;
759: END IF;
760: END IF;
761: --
762: IF p_attribute18 <> hr_api.g_varchar2 OR p_attribute18 IS NULL
763: THEN
764: IF nvl(p_attribute18, hr_api.g_varchar2) <>
765: nvl(l_cur_absence_row.attribute18, hr_api.g_varchar2)
766: THEN
760: END IF;
761: --
762: IF p_attribute18 <> hr_api.g_varchar2 OR p_attribute18 IS NULL
763: THEN
764: IF nvl(p_attribute18, hr_api.g_varchar2) <>
765: nvl(l_cur_absence_row.attribute18, hr_api.g_varchar2)
766: THEN
767: hr_utility.set_location(' Leaving:' || l_proc,170);
768: return TRUE;
761: --
762: IF p_attribute18 <> hr_api.g_varchar2 OR p_attribute18 IS NULL
763: THEN
764: IF nvl(p_attribute18, hr_api.g_varchar2) <>
765: nvl(l_cur_absence_row.attribute18, hr_api.g_varchar2)
766: THEN
767: hr_utility.set_location(' Leaving:' || l_proc,170);
768: return TRUE;
769: END IF;
768: return TRUE;
769: END IF;
770: END IF;
771: --
772: IF p_attribute19 <> hr_api.g_varchar2 OR p_attribute19 IS NULL
773: THEN
774: IF nvl(p_attribute19, hr_api.g_varchar2) <>
775: nvl(l_cur_absence_row.attribute19, hr_api.g_varchar2)
776: THEN
770: END IF;
771: --
772: IF p_attribute19 <> hr_api.g_varchar2 OR p_attribute19 IS NULL
773: THEN
774: IF nvl(p_attribute19, hr_api.g_varchar2) <>
775: nvl(l_cur_absence_row.attribute19, hr_api.g_varchar2)
776: THEN
777: hr_utility.set_location(' Leaving:' || l_proc,175);
778: return TRUE;
771: --
772: IF p_attribute19 <> hr_api.g_varchar2 OR p_attribute19 IS NULL
773: THEN
774: IF nvl(p_attribute19, hr_api.g_varchar2) <>
775: nvl(l_cur_absence_row.attribute19, hr_api.g_varchar2)
776: THEN
777: hr_utility.set_location(' Leaving:' || l_proc,175);
778: return TRUE;
779: END IF;
778: return TRUE;
779: END IF;
780: END IF;
781: --
782: IF p_attribute20 <> hr_api.g_varchar2 OR p_attribute20 IS NULL
783: THEN
784: IF nvl(p_attribute20, hr_api.g_varchar2) <>
785: nvl(l_cur_absence_row.attribute20, hr_api.g_varchar2)
786: THEN
780: END IF;
781: --
782: IF p_attribute20 <> hr_api.g_varchar2 OR p_attribute20 IS NULL
783: THEN
784: IF nvl(p_attribute20, hr_api.g_varchar2) <>
785: nvl(l_cur_absence_row.attribute20, hr_api.g_varchar2)
786: THEN
787: hr_utility.set_location(' Leaving:' || l_proc,180);
788: return TRUE;
781: --
782: IF p_attribute20 <> hr_api.g_varchar2 OR p_attribute20 IS NULL
783: THEN
784: IF nvl(p_attribute20, hr_api.g_varchar2) <>
785: nvl(l_cur_absence_row.attribute20, hr_api.g_varchar2)
786: THEN
787: hr_utility.set_location(' Leaving:' || l_proc,180);
788: return TRUE;
789: END IF;
788: return TRUE;
789: END IF;
790: END IF;
791: --
792: IF p_abs_information_category <> hr_api.g_varchar2 OR p_abs_information_category IS NULL
793: THEN
794: IF nvl(p_abs_information_category, hr_api.g_varchar2) <>
795: nvl(l_cur_absence_row.abs_information_category, hr_api.g_varchar2)
796: THEN
790: END IF;
791: --
792: IF p_abs_information_category <> hr_api.g_varchar2 OR p_abs_information_category IS NULL
793: THEN
794: IF nvl(p_abs_information_category, hr_api.g_varchar2) <>
795: nvl(l_cur_absence_row.abs_information_category, hr_api.g_varchar2)
796: THEN
797: hr_utility.set_location(' Leaving:' || l_proc,185);
798: return TRUE;
791: --
792: IF p_abs_information_category <> hr_api.g_varchar2 OR p_abs_information_category IS NULL
793: THEN
794: IF nvl(p_abs_information_category, hr_api.g_varchar2) <>
795: nvl(l_cur_absence_row.abs_information_category, hr_api.g_varchar2)
796: THEN
797: hr_utility.set_location(' Leaving:' || l_proc,185);
798: return TRUE;
799: END IF;
798: return TRUE;
799: END IF;
800: END IF;
801: --
802: IF p_abs_information1 <> hr_api.g_varchar2 OR p_abs_information1 IS NULL
803: THEN
804: IF nvl(p_abs_information1, hr_api.g_varchar2) <>
805: nvl(l_cur_absence_row.abs_information1, hr_api.g_varchar2)
806: THEN
800: END IF;
801: --
802: IF p_abs_information1 <> hr_api.g_varchar2 OR p_abs_information1 IS NULL
803: THEN
804: IF nvl(p_abs_information1, hr_api.g_varchar2) <>
805: nvl(l_cur_absence_row.abs_information1, hr_api.g_varchar2)
806: THEN
807: hr_utility.set_location(' Leaving:' || l_proc,190);
808: return TRUE;
801: --
802: IF p_abs_information1 <> hr_api.g_varchar2 OR p_abs_information1 IS NULL
803: THEN
804: IF nvl(p_abs_information1, hr_api.g_varchar2) <>
805: nvl(l_cur_absence_row.abs_information1, hr_api.g_varchar2)
806: THEN
807: hr_utility.set_location(' Leaving:' || l_proc,190);
808: return TRUE;
809: END IF;
808: return TRUE;
809: END IF;
810: END IF;
811: --
812: IF p_abs_information2 <> hr_api.g_varchar2 OR p_abs_information2 IS NULL
813: THEN
814: IF nvl(p_abs_information2, hr_api.g_varchar2) <>
815: nvl(l_cur_absence_row.abs_information2, hr_api.g_varchar2)
816: THEN
810: END IF;
811: --
812: IF p_abs_information2 <> hr_api.g_varchar2 OR p_abs_information2 IS NULL
813: THEN
814: IF nvl(p_abs_information2, hr_api.g_varchar2) <>
815: nvl(l_cur_absence_row.abs_information2, hr_api.g_varchar2)
816: THEN
817: hr_utility.set_location(' Leaving:' || l_proc,195);
818: return TRUE;
811: --
812: IF p_abs_information2 <> hr_api.g_varchar2 OR p_abs_information2 IS NULL
813: THEN
814: IF nvl(p_abs_information2, hr_api.g_varchar2) <>
815: nvl(l_cur_absence_row.abs_information2, hr_api.g_varchar2)
816: THEN
817: hr_utility.set_location(' Leaving:' || l_proc,195);
818: return TRUE;
819: END IF;
818: return TRUE;
819: END IF;
820: END IF;
821: --
822: IF p_abs_information3 <> hr_api.g_varchar2 OR p_abs_information3 IS NULL
823: THEN
824: IF nvl(p_abs_information3, hr_api.g_varchar2) <>
825: nvl(l_cur_absence_row.abs_information3, hr_api.g_varchar2)
826: THEN
820: END IF;
821: --
822: IF p_abs_information3 <> hr_api.g_varchar2 OR p_abs_information3 IS NULL
823: THEN
824: IF nvl(p_abs_information3, hr_api.g_varchar2) <>
825: nvl(l_cur_absence_row.abs_information3, hr_api.g_varchar2)
826: THEN
827: hr_utility.set_location(' Leaving:' || l_proc,200);
828: return TRUE;
821: --
822: IF p_abs_information3 <> hr_api.g_varchar2 OR p_abs_information3 IS NULL
823: THEN
824: IF nvl(p_abs_information3, hr_api.g_varchar2) <>
825: nvl(l_cur_absence_row.abs_information3, hr_api.g_varchar2)
826: THEN
827: hr_utility.set_location(' Leaving:' || l_proc,200);
828: return TRUE;
829: END IF;
828: return TRUE;
829: END IF;
830: END IF;
831: --
832: IF p_abs_information4 <> hr_api.g_varchar2 OR p_abs_information4 IS NULL
833: THEN
834: IF nvl(p_abs_information4, hr_api.g_varchar2) <>
835: nvl(l_cur_absence_row.abs_information4, hr_api.g_varchar2)
836: THEN
830: END IF;
831: --
832: IF p_abs_information4 <> hr_api.g_varchar2 OR p_abs_information4 IS NULL
833: THEN
834: IF nvl(p_abs_information4, hr_api.g_varchar2) <>
835: nvl(l_cur_absence_row.abs_information4, hr_api.g_varchar2)
836: THEN
837: hr_utility.set_location(' Leaving:' || l_proc,205);
838: return TRUE;
831: --
832: IF p_abs_information4 <> hr_api.g_varchar2 OR p_abs_information4 IS NULL
833: THEN
834: IF nvl(p_abs_information4, hr_api.g_varchar2) <>
835: nvl(l_cur_absence_row.abs_information4, hr_api.g_varchar2)
836: THEN
837: hr_utility.set_location(' Leaving:' || l_proc,205);
838: return TRUE;
839: END IF;
838: return TRUE;
839: END IF;
840: END IF;
841: --
842: IF p_abs_information5 <> hr_api.g_varchar2 OR p_abs_information5 IS NULL
843: THEN
844: IF nvl(p_abs_information5, hr_api.g_varchar2) <>
845: nvl(l_cur_absence_row.abs_information5, hr_api.g_varchar2)
846: THEN
840: END IF;
841: --
842: IF p_abs_information5 <> hr_api.g_varchar2 OR p_abs_information5 IS NULL
843: THEN
844: IF nvl(p_abs_information5, hr_api.g_varchar2) <>
845: nvl(l_cur_absence_row.abs_information5, hr_api.g_varchar2)
846: THEN
847: hr_utility.set_location(' Leaving:' || l_proc,210);
848: return TRUE;
841: --
842: IF p_abs_information5 <> hr_api.g_varchar2 OR p_abs_information5 IS NULL
843: THEN
844: IF nvl(p_abs_information5, hr_api.g_varchar2) <>
845: nvl(l_cur_absence_row.abs_information5, hr_api.g_varchar2)
846: THEN
847: hr_utility.set_location(' Leaving:' || l_proc,210);
848: return TRUE;
849: END IF;
848: return TRUE;
849: END IF;
850: END IF;
851: --
852: IF p_abs_information6 <> hr_api.g_varchar2 OR p_abs_information6 IS NULL
853: THEN
854: IF nvl(p_abs_information6, hr_api.g_varchar2) <>
855: nvl(l_cur_absence_row.abs_information6, hr_api.g_varchar2)
856: THEN
850: END IF;
851: --
852: IF p_abs_information6 <> hr_api.g_varchar2 OR p_abs_information6 IS NULL
853: THEN
854: IF nvl(p_abs_information6, hr_api.g_varchar2) <>
855: nvl(l_cur_absence_row.abs_information6, hr_api.g_varchar2)
856: THEN
857: hr_utility.set_location(' Leaving:' || l_proc,215);
858: return TRUE;
851: --
852: IF p_abs_information6 <> hr_api.g_varchar2 OR p_abs_information6 IS NULL
853: THEN
854: IF nvl(p_abs_information6, hr_api.g_varchar2) <>
855: nvl(l_cur_absence_row.abs_information6, hr_api.g_varchar2)
856: THEN
857: hr_utility.set_location(' Leaving:' || l_proc,215);
858: return TRUE;
859: END IF;
858: return TRUE;
859: END IF;
860: END IF;
861: --
862: IF p_abs_information7 <> hr_api.g_varchar2 OR p_abs_information7 IS NULL
863: THEN
864: IF nvl(p_abs_information7, hr_api.g_varchar2) <>
865: nvl(l_cur_absence_row.abs_information7, hr_api.g_varchar2)
866: THEN
860: END IF;
861: --
862: IF p_abs_information7 <> hr_api.g_varchar2 OR p_abs_information7 IS NULL
863: THEN
864: IF nvl(p_abs_information7, hr_api.g_varchar2) <>
865: nvl(l_cur_absence_row.abs_information7, hr_api.g_varchar2)
866: THEN
867: hr_utility.set_location(' Leaving:' || l_proc,220);
868: return TRUE;
861: --
862: IF p_abs_information7 <> hr_api.g_varchar2 OR p_abs_information7 IS NULL
863: THEN
864: IF nvl(p_abs_information7, hr_api.g_varchar2) <>
865: nvl(l_cur_absence_row.abs_information7, hr_api.g_varchar2)
866: THEN
867: hr_utility.set_location(' Leaving:' || l_proc,220);
868: return TRUE;
869: END IF;
868: return TRUE;
869: END IF;
870: END IF;
871: --
872: IF p_abs_information8 <> hr_api.g_varchar2 OR p_abs_information8 IS NULL
873: THEN
874: IF nvl(p_abs_information8, hr_api.g_varchar2) <>
875: nvl(l_cur_absence_row.abs_information8, hr_api.g_varchar2)
876: THEN
870: END IF;
871: --
872: IF p_abs_information8 <> hr_api.g_varchar2 OR p_abs_information8 IS NULL
873: THEN
874: IF nvl(p_abs_information8, hr_api.g_varchar2) <>
875: nvl(l_cur_absence_row.abs_information8, hr_api.g_varchar2)
876: THEN
877: hr_utility.set_location(' Leaving:' || l_proc,225);
878: return TRUE;
871: --
872: IF p_abs_information8 <> hr_api.g_varchar2 OR p_abs_information8 IS NULL
873: THEN
874: IF nvl(p_abs_information8, hr_api.g_varchar2) <>
875: nvl(l_cur_absence_row.abs_information8, hr_api.g_varchar2)
876: THEN
877: hr_utility.set_location(' Leaving:' || l_proc,225);
878: return TRUE;
879: END IF;
878: return TRUE;
879: END IF;
880: END IF;
881: --
882: IF p_abs_information9 <> hr_api.g_varchar2 OR p_abs_information9 IS NULL
883: THEN
884: IF nvl(p_abs_information9, hr_api.g_varchar2) <>
885: nvl(l_cur_absence_row.abs_information9, hr_api.g_varchar2)
886: THEN
880: END IF;
881: --
882: IF p_abs_information9 <> hr_api.g_varchar2 OR p_abs_information9 IS NULL
883: THEN
884: IF nvl(p_abs_information9, hr_api.g_varchar2) <>
885: nvl(l_cur_absence_row.abs_information9, hr_api.g_varchar2)
886: THEN
887: hr_utility.set_location(' Leaving:' || l_proc,230);
888: return TRUE;
881: --
882: IF p_abs_information9 <> hr_api.g_varchar2 OR p_abs_information9 IS NULL
883: THEN
884: IF nvl(p_abs_information9, hr_api.g_varchar2) <>
885: nvl(l_cur_absence_row.abs_information9, hr_api.g_varchar2)
886: THEN
887: hr_utility.set_location(' Leaving:' || l_proc,230);
888: return TRUE;
889: END IF;
888: return TRUE;
889: END IF;
890: END IF;
891: --
892: IF p_abs_information10 <> hr_api.g_varchar2 OR p_abs_information10 IS NULL
893: THEN
894: IF nvl(p_abs_information10, hr_api.g_varchar2) <>
895: nvl(l_cur_absence_row.abs_information10, hr_api.g_varchar2)
896: THEN
890: END IF;
891: --
892: IF p_abs_information10 <> hr_api.g_varchar2 OR p_abs_information10 IS NULL
893: THEN
894: IF nvl(p_abs_information10, hr_api.g_varchar2) <>
895: nvl(l_cur_absence_row.abs_information10, hr_api.g_varchar2)
896: THEN
897: hr_utility.set_location(' Leaving:' || l_proc,235);
898: return TRUE;
891: --
892: IF p_abs_information10 <> hr_api.g_varchar2 OR p_abs_information10 IS NULL
893: THEN
894: IF nvl(p_abs_information10, hr_api.g_varchar2) <>
895: nvl(l_cur_absence_row.abs_information10, hr_api.g_varchar2)
896: THEN
897: hr_utility.set_location(' Leaving:' || l_proc,235);
898: return TRUE;
899: END IF;
898: return TRUE;
899: END IF;
900: END IF;
901: --
902: IF p_abs_information11 <> hr_api.g_varchar2 OR p_abs_information11 IS NULL
903: THEN
904: IF nvl(p_abs_information11, hr_api.g_varchar2) <>
905: nvl(l_cur_absence_row.abs_information11, hr_api.g_varchar2)
906: THEN
900: END IF;
901: --
902: IF p_abs_information11 <> hr_api.g_varchar2 OR p_abs_information11 IS NULL
903: THEN
904: IF nvl(p_abs_information11, hr_api.g_varchar2) <>
905: nvl(l_cur_absence_row.abs_information11, hr_api.g_varchar2)
906: THEN
907: hr_utility.set_location(' Leaving:' || l_proc,240);
908: return TRUE;
901: --
902: IF p_abs_information11 <> hr_api.g_varchar2 OR p_abs_information11 IS NULL
903: THEN
904: IF nvl(p_abs_information11, hr_api.g_varchar2) <>
905: nvl(l_cur_absence_row.abs_information11, hr_api.g_varchar2)
906: THEN
907: hr_utility.set_location(' Leaving:' || l_proc,240);
908: return TRUE;
909: END IF;
908: return TRUE;
909: END IF;
910: END IF;
911: --
912: IF p_abs_information12 <> hr_api.g_varchar2 OR p_abs_information12 IS NULL
913: THEN
914: IF nvl(p_abs_information12, hr_api.g_varchar2) <>
915: nvl(l_cur_absence_row.abs_information12, hr_api.g_varchar2)
916: THEN
910: END IF;
911: --
912: IF p_abs_information12 <> hr_api.g_varchar2 OR p_abs_information12 IS NULL
913: THEN
914: IF nvl(p_abs_information12, hr_api.g_varchar2) <>
915: nvl(l_cur_absence_row.abs_information12, hr_api.g_varchar2)
916: THEN
917: hr_utility.set_location(' Leaving:' || l_proc,245);
918: return TRUE;
911: --
912: IF p_abs_information12 <> hr_api.g_varchar2 OR p_abs_information12 IS NULL
913: THEN
914: IF nvl(p_abs_information12, hr_api.g_varchar2) <>
915: nvl(l_cur_absence_row.abs_information12, hr_api.g_varchar2)
916: THEN
917: hr_utility.set_location(' Leaving:' || l_proc,245);
918: return TRUE;
919: END IF;
918: return TRUE;
919: END IF;
920: END IF;
921: --
922: IF p_abs_information13 <> hr_api.g_varchar2 OR p_abs_information13 IS NULL
923: THEN
924: IF nvl(p_abs_information13, hr_api.g_varchar2) <>
925: nvl(l_cur_absence_row.abs_information13, hr_api.g_varchar2)
926: THEN
920: END IF;
921: --
922: IF p_abs_information13 <> hr_api.g_varchar2 OR p_abs_information13 IS NULL
923: THEN
924: IF nvl(p_abs_information13, hr_api.g_varchar2) <>
925: nvl(l_cur_absence_row.abs_information13, hr_api.g_varchar2)
926: THEN
927: hr_utility.set_location(' Leaving:' || l_proc,250);
928: return TRUE;
921: --
922: IF p_abs_information13 <> hr_api.g_varchar2 OR p_abs_information13 IS NULL
923: THEN
924: IF nvl(p_abs_information13, hr_api.g_varchar2) <>
925: nvl(l_cur_absence_row.abs_information13, hr_api.g_varchar2)
926: THEN
927: hr_utility.set_location(' Leaving:' || l_proc,250);
928: return TRUE;
929: END IF;
928: return TRUE;
929: END IF;
930: END IF;
931: --
932: IF p_abs_information14 <> hr_api.g_varchar2 OR p_abs_information14 IS NULL
933: THEN
934: IF nvl(p_abs_information14, hr_api.g_varchar2) <>
935: nvl(l_cur_absence_row.abs_information14, hr_api.g_varchar2)
936: THEN
930: END IF;
931: --
932: IF p_abs_information14 <> hr_api.g_varchar2 OR p_abs_information14 IS NULL
933: THEN
934: IF nvl(p_abs_information14, hr_api.g_varchar2) <>
935: nvl(l_cur_absence_row.abs_information14, hr_api.g_varchar2)
936: THEN
937: hr_utility.set_location(' Leaving:' || l_proc,255);
938: return TRUE;
931: --
932: IF p_abs_information14 <> hr_api.g_varchar2 OR p_abs_information14 IS NULL
933: THEN
934: IF nvl(p_abs_information14, hr_api.g_varchar2) <>
935: nvl(l_cur_absence_row.abs_information14, hr_api.g_varchar2)
936: THEN
937: hr_utility.set_location(' Leaving:' || l_proc,255);
938: return TRUE;
939: END IF;
938: return TRUE;
939: END IF;
940: END IF;
941: --
942: IF p_abs_information15 <> hr_api.g_varchar2 OR p_abs_information15 IS NULL
943: THEN
944: IF nvl(p_abs_information15, hr_api.g_varchar2) <>
945: nvl(l_cur_absence_row.abs_information15, hr_api.g_varchar2)
946: THEN
940: END IF;
941: --
942: IF p_abs_information15 <> hr_api.g_varchar2 OR p_abs_information15 IS NULL
943: THEN
944: IF nvl(p_abs_information15, hr_api.g_varchar2) <>
945: nvl(l_cur_absence_row.abs_information15, hr_api.g_varchar2)
946: THEN
947: hr_utility.set_location(' Leaving:' || l_proc,260);
948: return TRUE;
941: --
942: IF p_abs_information15 <> hr_api.g_varchar2 OR p_abs_information15 IS NULL
943: THEN
944: IF nvl(p_abs_information15, hr_api.g_varchar2) <>
945: nvl(l_cur_absence_row.abs_information15, hr_api.g_varchar2)
946: THEN
947: hr_utility.set_location(' Leaving:' || l_proc,260);
948: return TRUE;
949: END IF;
948: return TRUE;
949: END IF;
950: END IF;
951: --
952: IF p_abs_information16 <> hr_api.g_varchar2 OR p_abs_information16 IS NULL
953: THEN
954: IF nvl(p_abs_information16, hr_api.g_varchar2) <>
955: nvl(l_cur_absence_row.abs_information16, hr_api.g_varchar2)
956: THEN
950: END IF;
951: --
952: IF p_abs_information16 <> hr_api.g_varchar2 OR p_abs_information16 IS NULL
953: THEN
954: IF nvl(p_abs_information16, hr_api.g_varchar2) <>
955: nvl(l_cur_absence_row.abs_information16, hr_api.g_varchar2)
956: THEN
957: hr_utility.set_location(' Leaving:' || l_proc,265);
958: return TRUE;
951: --
952: IF p_abs_information16 <> hr_api.g_varchar2 OR p_abs_information16 IS NULL
953: THEN
954: IF nvl(p_abs_information16, hr_api.g_varchar2) <>
955: nvl(l_cur_absence_row.abs_information16, hr_api.g_varchar2)
956: THEN
957: hr_utility.set_location(' Leaving:' || l_proc,265);
958: return TRUE;
959: END IF;
958: return TRUE;
959: END IF;
960: END IF;
961: --
962: IF p_abs_information17 <> hr_api.g_varchar2 OR p_abs_information17 IS NULL
963: THEN
964: IF nvl(p_abs_information17, hr_api.g_varchar2) <>
965: nvl(l_cur_absence_row.abs_information17, hr_api.g_varchar2)
966: THEN
960: END IF;
961: --
962: IF p_abs_information17 <> hr_api.g_varchar2 OR p_abs_information17 IS NULL
963: THEN
964: IF nvl(p_abs_information17, hr_api.g_varchar2) <>
965: nvl(l_cur_absence_row.abs_information17, hr_api.g_varchar2)
966: THEN
967: hr_utility.set_location(' Leaving:' || l_proc,270);
968: return TRUE;
961: --
962: IF p_abs_information17 <> hr_api.g_varchar2 OR p_abs_information17 IS NULL
963: THEN
964: IF nvl(p_abs_information17, hr_api.g_varchar2) <>
965: nvl(l_cur_absence_row.abs_information17, hr_api.g_varchar2)
966: THEN
967: hr_utility.set_location(' Leaving:' || l_proc,270);
968: return TRUE;
969: END IF;
968: return TRUE;
969: END IF;
970: END IF;
971: --
972: IF p_abs_information18 <> hr_api.g_varchar2 OR p_abs_information18 IS NULL
973: THEN
974: IF nvl(p_abs_information18, hr_api.g_varchar2) <>
975: nvl(l_cur_absence_row.abs_information18, hr_api.g_varchar2)
976: THEN
970: END IF;
971: --
972: IF p_abs_information18 <> hr_api.g_varchar2 OR p_abs_information18 IS NULL
973: THEN
974: IF nvl(p_abs_information18, hr_api.g_varchar2) <>
975: nvl(l_cur_absence_row.abs_information18, hr_api.g_varchar2)
976: THEN
977: hr_utility.set_location(' Leaving:' || l_proc,275);
978: return TRUE;
971: --
972: IF p_abs_information18 <> hr_api.g_varchar2 OR p_abs_information18 IS NULL
973: THEN
974: IF nvl(p_abs_information18, hr_api.g_varchar2) <>
975: nvl(l_cur_absence_row.abs_information18, hr_api.g_varchar2)
976: THEN
977: hr_utility.set_location(' Leaving:' || l_proc,275);
978: return TRUE;
979: END IF;
978: return TRUE;
979: END IF;
980: END IF;
981: --
982: IF p_abs_information19 <> hr_api.g_varchar2 OR p_abs_information19 IS NULL
983: THEN
984: IF nvl(p_abs_information19, hr_api.g_varchar2) <>
985: nvl(l_cur_absence_row.abs_information19, hr_api.g_varchar2)
986: THEN
980: END IF;
981: --
982: IF p_abs_information19 <> hr_api.g_varchar2 OR p_abs_information19 IS NULL
983: THEN
984: IF nvl(p_abs_information19, hr_api.g_varchar2) <>
985: nvl(l_cur_absence_row.abs_information19, hr_api.g_varchar2)
986: THEN
987: hr_utility.set_location(' Leaving:' || l_proc,280);
988: return TRUE;
981: --
982: IF p_abs_information19 <> hr_api.g_varchar2 OR p_abs_information19 IS NULL
983: THEN
984: IF nvl(p_abs_information19, hr_api.g_varchar2) <>
985: nvl(l_cur_absence_row.abs_information19, hr_api.g_varchar2)
986: THEN
987: hr_utility.set_location(' Leaving:' || l_proc,280);
988: return TRUE;
989: END IF;
988: return TRUE;
989: END IF;
990: END IF;
991: --
992: IF p_abs_information20 <> hr_api.g_varchar2 OR p_abs_information20 IS NULL
993: THEN
994: IF nvl(p_abs_information20, hr_api.g_varchar2) <>
995: nvl(l_cur_absence_row.abs_information20, hr_api.g_varchar2)
996: THEN
990: END IF;
991: --
992: IF p_abs_information20 <> hr_api.g_varchar2 OR p_abs_information20 IS NULL
993: THEN
994: IF nvl(p_abs_information20, hr_api.g_varchar2) <>
995: nvl(l_cur_absence_row.abs_information20, hr_api.g_varchar2)
996: THEN
997: hr_utility.set_location(' Leaving:' || l_proc,285);
998: return TRUE;
991: --
992: IF p_abs_information20 <> hr_api.g_varchar2 OR p_abs_information20 IS NULL
993: THEN
994: IF nvl(p_abs_information20, hr_api.g_varchar2) <>
995: nvl(l_cur_absence_row.abs_information20, hr_api.g_varchar2)
996: THEN
997: hr_utility.set_location(' Leaving:' || l_proc,285);
998: return TRUE;
999: END IF;
998: return TRUE;
999: END IF;
1000: END IF;
1001: --
1002: IF p_abs_information21 <> hr_api.g_varchar2 OR p_abs_information21 IS NULL
1003: THEN
1004: IF nvl(p_abs_information21, hr_api.g_varchar2) <>
1005: nvl(l_cur_absence_row.abs_information21, hr_api.g_varchar2)
1006: THEN
1000: END IF;
1001: --
1002: IF p_abs_information21 <> hr_api.g_varchar2 OR p_abs_information21 IS NULL
1003: THEN
1004: IF nvl(p_abs_information21, hr_api.g_varchar2) <>
1005: nvl(l_cur_absence_row.abs_information21, hr_api.g_varchar2)
1006: THEN
1007: hr_utility.set_location(' Leaving:' || l_proc,290);
1008: return TRUE;
1001: --
1002: IF p_abs_information21 <> hr_api.g_varchar2 OR p_abs_information21 IS NULL
1003: THEN
1004: IF nvl(p_abs_information21, hr_api.g_varchar2) <>
1005: nvl(l_cur_absence_row.abs_information21, hr_api.g_varchar2)
1006: THEN
1007: hr_utility.set_location(' Leaving:' || l_proc,290);
1008: return TRUE;
1009: END IF;
1008: return TRUE;
1009: END IF;
1010: END IF;
1011: --
1012: IF p_abs_information22 <> hr_api.g_varchar2 OR p_abs_information22 IS NULL
1013: THEN
1014: IF nvl(p_abs_information22, hr_api.g_varchar2) <>
1015: nvl(l_cur_absence_row.abs_information22, hr_api.g_varchar2)
1016: THEN
1010: END IF;
1011: --
1012: IF p_abs_information22 <> hr_api.g_varchar2 OR p_abs_information22 IS NULL
1013: THEN
1014: IF nvl(p_abs_information22, hr_api.g_varchar2) <>
1015: nvl(l_cur_absence_row.abs_information22, hr_api.g_varchar2)
1016: THEN
1017: hr_utility.set_location(' Leaving:' || l_proc,295);
1018: return TRUE;
1011: --
1012: IF p_abs_information22 <> hr_api.g_varchar2 OR p_abs_information22 IS NULL
1013: THEN
1014: IF nvl(p_abs_information22, hr_api.g_varchar2) <>
1015: nvl(l_cur_absence_row.abs_information22, hr_api.g_varchar2)
1016: THEN
1017: hr_utility.set_location(' Leaving:' || l_proc,295);
1018: return TRUE;
1019: END IF;
1018: return TRUE;
1019: END IF;
1020: END IF;
1021: --
1022: IF p_abs_information23 <> hr_api.g_varchar2 OR p_abs_information23 IS NULL
1023: THEN
1024: IF nvl(p_abs_information23, hr_api.g_varchar2) <>
1025: nvl(l_cur_absence_row.abs_information23, hr_api.g_varchar2)
1026: THEN
1020: END IF;
1021: --
1022: IF p_abs_information23 <> hr_api.g_varchar2 OR p_abs_information23 IS NULL
1023: THEN
1024: IF nvl(p_abs_information23, hr_api.g_varchar2) <>
1025: nvl(l_cur_absence_row.abs_information23, hr_api.g_varchar2)
1026: THEN
1027: hr_utility.set_location(' Leaving:' || l_proc,300);
1028: return TRUE;
1021: --
1022: IF p_abs_information23 <> hr_api.g_varchar2 OR p_abs_information23 IS NULL
1023: THEN
1024: IF nvl(p_abs_information23, hr_api.g_varchar2) <>
1025: nvl(l_cur_absence_row.abs_information23, hr_api.g_varchar2)
1026: THEN
1027: hr_utility.set_location(' Leaving:' || l_proc,300);
1028: return TRUE;
1029: END IF;
1028: return TRUE;
1029: END IF;
1030: END IF;
1031: --
1032: IF p_abs_information24 <> hr_api.g_varchar2 OR p_abs_information24 IS NULL
1033: THEN
1034: IF nvl(p_abs_information24, hr_api.g_varchar2) <>
1035: nvl(l_cur_absence_row.abs_information24, hr_api.g_varchar2)
1036: THEN
1030: END IF;
1031: --
1032: IF p_abs_information24 <> hr_api.g_varchar2 OR p_abs_information24 IS NULL
1033: THEN
1034: IF nvl(p_abs_information24, hr_api.g_varchar2) <>
1035: nvl(l_cur_absence_row.abs_information24, hr_api.g_varchar2)
1036: THEN
1037: hr_utility.set_location(' Leaving:' || l_proc,305);
1038: return TRUE;
1031: --
1032: IF p_abs_information24 <> hr_api.g_varchar2 OR p_abs_information24 IS NULL
1033: THEN
1034: IF nvl(p_abs_information24, hr_api.g_varchar2) <>
1035: nvl(l_cur_absence_row.abs_information24, hr_api.g_varchar2)
1036: THEN
1037: hr_utility.set_location(' Leaving:' || l_proc,305);
1038: return TRUE;
1039: END IF;
1038: return TRUE;
1039: END IF;
1040: END IF;
1041: --
1042: IF p_abs_information25 <> hr_api.g_varchar2 OR p_abs_information25 IS NULL
1043: THEN
1044: IF nvl(p_abs_information25, hr_api.g_varchar2) <>
1045: nvl(l_cur_absence_row.abs_information25, hr_api.g_varchar2)
1046: THEN
1040: END IF;
1041: --
1042: IF p_abs_information25 <> hr_api.g_varchar2 OR p_abs_information25 IS NULL
1043: THEN
1044: IF nvl(p_abs_information25, hr_api.g_varchar2) <>
1045: nvl(l_cur_absence_row.abs_information25, hr_api.g_varchar2)
1046: THEN
1047: hr_utility.set_location(' Leaving:' || l_proc,310);
1048: return TRUE;
1041: --
1042: IF p_abs_information25 <> hr_api.g_varchar2 OR p_abs_information25 IS NULL
1043: THEN
1044: IF nvl(p_abs_information25, hr_api.g_varchar2) <>
1045: nvl(l_cur_absence_row.abs_information25, hr_api.g_varchar2)
1046: THEN
1047: hr_utility.set_location(' Leaving:' || l_proc,310);
1048: return TRUE;
1049: END IF;
1048: return TRUE;
1049: END IF;
1050: END IF;
1051: --
1052: IF p_abs_information26 <> hr_api.g_varchar2 OR p_abs_information26 IS NULL
1053: THEN
1054: IF nvl(p_abs_information26, hr_api.g_varchar2) <>
1055: nvl(l_cur_absence_row.abs_information26, hr_api.g_varchar2)
1056: THEN
1050: END IF;
1051: --
1052: IF p_abs_information26 <> hr_api.g_varchar2 OR p_abs_information26 IS NULL
1053: THEN
1054: IF nvl(p_abs_information26, hr_api.g_varchar2) <>
1055: nvl(l_cur_absence_row.abs_information26, hr_api.g_varchar2)
1056: THEN
1057: hr_utility.set_location(' Leaving:' || l_proc,315);
1058: return TRUE;
1051: --
1052: IF p_abs_information26 <> hr_api.g_varchar2 OR p_abs_information26 IS NULL
1053: THEN
1054: IF nvl(p_abs_information26, hr_api.g_varchar2) <>
1055: nvl(l_cur_absence_row.abs_information26, hr_api.g_varchar2)
1056: THEN
1057: hr_utility.set_location(' Leaving:' || l_proc,315);
1058: return TRUE;
1059: END IF;
1058: return TRUE;
1059: END IF;
1060: END IF;
1061: --
1062: IF p_abs_information27 <> hr_api.g_varchar2 OR p_abs_information27 IS NULL
1063: THEN
1064: IF nvl(p_abs_information27, hr_api.g_varchar2) <>
1065: nvl(l_cur_absence_row.abs_information27, hr_api.g_varchar2)
1066: THEN
1060: END IF;
1061: --
1062: IF p_abs_information27 <> hr_api.g_varchar2 OR p_abs_information27 IS NULL
1063: THEN
1064: IF nvl(p_abs_information27, hr_api.g_varchar2) <>
1065: nvl(l_cur_absence_row.abs_information27, hr_api.g_varchar2)
1066: THEN
1067: hr_utility.set_location(' Leaving:' || l_proc,320);
1068: return TRUE;
1061: --
1062: IF p_abs_information27 <> hr_api.g_varchar2 OR p_abs_information27 IS NULL
1063: THEN
1064: IF nvl(p_abs_information27, hr_api.g_varchar2) <>
1065: nvl(l_cur_absence_row.abs_information27, hr_api.g_varchar2)
1066: THEN
1067: hr_utility.set_location(' Leaving:' || l_proc,320);
1068: return TRUE;
1069: END IF;
1068: return TRUE;
1069: END IF;
1070: END IF;
1071: --
1072: IF p_abs_information28 <> hr_api.g_varchar2 OR p_abs_information28 IS NULL
1073: THEN
1074: IF nvl(p_abs_information28, hr_api.g_varchar2) <>
1075: nvl(l_cur_absence_row.abs_information28, hr_api.g_varchar2)
1076: THEN
1070: END IF;
1071: --
1072: IF p_abs_information28 <> hr_api.g_varchar2 OR p_abs_information28 IS NULL
1073: THEN
1074: IF nvl(p_abs_information28, hr_api.g_varchar2) <>
1075: nvl(l_cur_absence_row.abs_information28, hr_api.g_varchar2)
1076: THEN
1077: hr_utility.set_location(' Leaving:' || l_proc,325);
1078: return TRUE;
1071: --
1072: IF p_abs_information28 <> hr_api.g_varchar2 OR p_abs_information28 IS NULL
1073: THEN
1074: IF nvl(p_abs_information28, hr_api.g_varchar2) <>
1075: nvl(l_cur_absence_row.abs_information28, hr_api.g_varchar2)
1076: THEN
1077: hr_utility.set_location(' Leaving:' || l_proc,325);
1078: return TRUE;
1079: END IF;
1078: return TRUE;
1079: END IF;
1080: END IF;
1081: --
1082: IF p_abs_information29 <> hr_api.g_varchar2 OR p_abs_information29 IS NULL
1083: THEN
1084: IF nvl(p_abs_information29, hr_api.g_varchar2) <>
1085: nvl(l_cur_absence_row.abs_information29, hr_api.g_varchar2)
1086: THEN
1080: END IF;
1081: --
1082: IF p_abs_information29 <> hr_api.g_varchar2 OR p_abs_information29 IS NULL
1083: THEN
1084: IF nvl(p_abs_information29, hr_api.g_varchar2) <>
1085: nvl(l_cur_absence_row.abs_information29, hr_api.g_varchar2)
1086: THEN
1087: hr_utility.set_location(' Leaving:' || l_proc,330);
1088: return TRUE;
1081: --
1082: IF p_abs_information29 <> hr_api.g_varchar2 OR p_abs_information29 IS NULL
1083: THEN
1084: IF nvl(p_abs_information29, hr_api.g_varchar2) <>
1085: nvl(l_cur_absence_row.abs_information29, hr_api.g_varchar2)
1086: THEN
1087: hr_utility.set_location(' Leaving:' || l_proc,330);
1088: return TRUE;
1089: END IF;
1088: return TRUE;
1089: END IF;
1090: END IF;
1091: --
1092: IF p_abs_information30 <> hr_api.g_varchar2 OR p_abs_information30 IS NULL
1093: THEN
1094: IF nvl(p_abs_information30, hr_api.g_varchar2) <>
1095: nvl(l_cur_absence_row.abs_information30, hr_api.g_varchar2)
1096: THEN
1090: END IF;
1091: --
1092: IF p_abs_information30 <> hr_api.g_varchar2 OR p_abs_information30 IS NULL
1093: THEN
1094: IF nvl(p_abs_information30, hr_api.g_varchar2) <>
1095: nvl(l_cur_absence_row.abs_information30, hr_api.g_varchar2)
1096: THEN
1097: hr_utility.set_location(' Leaving:' || l_proc,335);
1098: return TRUE;
1091: --
1092: IF p_abs_information30 <> hr_api.g_varchar2 OR p_abs_information30 IS NULL
1093: THEN
1094: IF nvl(p_abs_information30, hr_api.g_varchar2) <>
1095: nvl(l_cur_absence_row.abs_information30, hr_api.g_varchar2)
1096: THEN
1097: hr_utility.set_location(' Leaving:' || l_proc,335);
1098: return TRUE;
1099: END IF;
1135: (p_validate in number default 0
1136: ,p_effective_date in date
1137: ,p_business_group_id in number
1138: ,p_absence_attendance_id in number
1139: ,p_abs_attendance_reason_id in number default hr_api.g_number
1140: ,p_comments in long default hr_api.g_varchar2
1141: ,p_date_notification in date default hr_api.g_date
1142: ,p_date_projected_start in date default hr_api.g_date
1143: ,p_time_projected_start in varchar2 default hr_api.g_varchar2
1136: ,p_effective_date in date
1137: ,p_business_group_id in number
1138: ,p_absence_attendance_id in number
1139: ,p_abs_attendance_reason_id in number default hr_api.g_number
1140: ,p_comments in long default hr_api.g_varchar2
1141: ,p_date_notification in date default hr_api.g_date
1142: ,p_date_projected_start in date default hr_api.g_date
1143: ,p_time_projected_start in varchar2 default hr_api.g_varchar2
1144: ,p_date_projected_end in date default hr_api.g_date
1137: ,p_business_group_id in number
1138: ,p_absence_attendance_id in number
1139: ,p_abs_attendance_reason_id in number default hr_api.g_number
1140: ,p_comments in long default hr_api.g_varchar2
1141: ,p_date_notification in date default hr_api.g_date
1142: ,p_date_projected_start in date default hr_api.g_date
1143: ,p_time_projected_start in varchar2 default hr_api.g_varchar2
1144: ,p_date_projected_end in date default hr_api.g_date
1145: ,p_time_projected_end in varchar2 default hr_api.g_varchar2
1138: ,p_absence_attendance_id in number
1139: ,p_abs_attendance_reason_id in number default hr_api.g_number
1140: ,p_comments in long default hr_api.g_varchar2
1141: ,p_date_notification in date default hr_api.g_date
1142: ,p_date_projected_start in date default hr_api.g_date
1143: ,p_time_projected_start in varchar2 default hr_api.g_varchar2
1144: ,p_date_projected_end in date default hr_api.g_date
1145: ,p_time_projected_end in varchar2 default hr_api.g_varchar2
1146: ,p_date_start in date default hr_api.g_date
1139: ,p_abs_attendance_reason_id in number default hr_api.g_number
1140: ,p_comments in long default hr_api.g_varchar2
1141: ,p_date_notification in date default hr_api.g_date
1142: ,p_date_projected_start in date default hr_api.g_date
1143: ,p_time_projected_start in varchar2 default hr_api.g_varchar2
1144: ,p_date_projected_end in date default hr_api.g_date
1145: ,p_time_projected_end in varchar2 default hr_api.g_varchar2
1146: ,p_date_start in date default hr_api.g_date
1147: ,p_time_start in varchar2 default hr_api.g_varchar2
1140: ,p_comments in long default hr_api.g_varchar2
1141: ,p_date_notification in date default hr_api.g_date
1142: ,p_date_projected_start in date default hr_api.g_date
1143: ,p_time_projected_start in varchar2 default hr_api.g_varchar2
1144: ,p_date_projected_end in date default hr_api.g_date
1145: ,p_time_projected_end in varchar2 default hr_api.g_varchar2
1146: ,p_date_start in date default hr_api.g_date
1147: ,p_time_start in varchar2 default hr_api.g_varchar2
1148: ,p_date_end in date default hr_api.g_date
1141: ,p_date_notification in date default hr_api.g_date
1142: ,p_date_projected_start in date default hr_api.g_date
1143: ,p_time_projected_start in varchar2 default hr_api.g_varchar2
1144: ,p_date_projected_end in date default hr_api.g_date
1145: ,p_time_projected_end in varchar2 default hr_api.g_varchar2
1146: ,p_date_start in date default hr_api.g_date
1147: ,p_time_start in varchar2 default hr_api.g_varchar2
1148: ,p_date_end in date default hr_api.g_date
1149: ,p_time_end in varchar2 default hr_api.g_varchar2
1142: ,p_date_projected_start in date default hr_api.g_date
1143: ,p_time_projected_start in varchar2 default hr_api.g_varchar2
1144: ,p_date_projected_end in date default hr_api.g_date
1145: ,p_time_projected_end in varchar2 default hr_api.g_varchar2
1146: ,p_date_start in date default hr_api.g_date
1147: ,p_time_start in varchar2 default hr_api.g_varchar2
1148: ,p_date_end in date default hr_api.g_date
1149: ,p_time_end in varchar2 default hr_api.g_varchar2
1150: ,p_absence_days in out nocopy number
1143: ,p_time_projected_start in varchar2 default hr_api.g_varchar2
1144: ,p_date_projected_end in date default hr_api.g_date
1145: ,p_time_projected_end in varchar2 default hr_api.g_varchar2
1146: ,p_date_start in date default hr_api.g_date
1147: ,p_time_start in varchar2 default hr_api.g_varchar2
1148: ,p_date_end in date default hr_api.g_date
1149: ,p_time_end in varchar2 default hr_api.g_varchar2
1150: ,p_absence_days in out nocopy number
1151: ,p_absence_hours in out nocopy number
1144: ,p_date_projected_end in date default hr_api.g_date
1145: ,p_time_projected_end in varchar2 default hr_api.g_varchar2
1146: ,p_date_start in date default hr_api.g_date
1147: ,p_time_start in varchar2 default hr_api.g_varchar2
1148: ,p_date_end in date default hr_api.g_date
1149: ,p_time_end in varchar2 default hr_api.g_varchar2
1150: ,p_absence_days in out nocopy number
1151: ,p_absence_hours in out nocopy number
1152: ,p_authorising_person_id in number default hr_api.g_number
1145: ,p_time_projected_end in varchar2 default hr_api.g_varchar2
1146: ,p_date_start in date default hr_api.g_date
1147: ,p_time_start in varchar2 default hr_api.g_varchar2
1148: ,p_date_end in date default hr_api.g_date
1149: ,p_time_end in varchar2 default hr_api.g_varchar2
1150: ,p_absence_days in out nocopy number
1151: ,p_absence_hours in out nocopy number
1152: ,p_authorising_person_id in number default hr_api.g_number
1153: ,p_replacement_person_id in number default hr_api.g_number
1148: ,p_date_end in date default hr_api.g_date
1149: ,p_time_end in varchar2 default hr_api.g_varchar2
1150: ,p_absence_days in out nocopy number
1151: ,p_absence_hours in out nocopy number
1152: ,p_authorising_person_id in number default hr_api.g_number
1153: ,p_replacement_person_id in number default hr_api.g_number
1154: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1155: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1156: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1149: ,p_time_end in varchar2 default hr_api.g_varchar2
1150: ,p_absence_days in out nocopy number
1151: ,p_absence_hours in out nocopy number
1152: ,p_authorising_person_id in number default hr_api.g_number
1153: ,p_replacement_person_id in number default hr_api.g_number
1154: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1155: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1156: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1157: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1150: ,p_absence_days in out nocopy number
1151: ,p_absence_hours in out nocopy number
1152: ,p_authorising_person_id in number default hr_api.g_number
1153: ,p_replacement_person_id in number default hr_api.g_number
1154: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1155: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1156: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1157: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1158: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1151: ,p_absence_hours in out nocopy number
1152: ,p_authorising_person_id in number default hr_api.g_number
1153: ,p_replacement_person_id in number default hr_api.g_number
1154: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1155: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1156: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1157: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1158: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1159: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1152: ,p_authorising_person_id in number default hr_api.g_number
1153: ,p_replacement_person_id in number default hr_api.g_number
1154: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1155: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1156: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1157: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1158: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1159: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1160: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1153: ,p_replacement_person_id in number default hr_api.g_number
1154: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1155: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1156: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1157: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1158: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1159: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1160: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1161: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1154: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1155: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1156: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1157: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1158: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1159: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1160: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1161: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1162: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1155: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1156: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1157: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1158: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1159: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1160: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1161: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1162: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1163: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1156: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1157: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1158: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1159: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1160: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1161: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1162: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1163: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1164: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1157: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1158: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1159: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1160: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1161: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1162: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1163: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1164: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1165: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1158: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1159: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1160: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1161: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1162: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1163: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1164: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1165: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1166: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1159: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1160: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1161: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1162: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1163: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1164: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1165: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1166: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1167: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1160: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1161: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1162: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1163: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1164: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1165: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1166: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1167: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1168: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1161: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1162: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1163: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1164: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1165: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1166: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1167: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1168: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1169: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1162: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1163: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1164: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1165: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1166: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1167: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1168: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1169: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1170: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1163: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1164: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1165: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1166: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1167: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1168: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1169: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1170: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1171: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1164: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1165: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1166: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1167: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1168: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1169: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1170: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1171: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1172: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1165: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1166: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1167: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1168: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1169: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1170: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1171: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1172: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1173: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1166: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1167: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1168: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1169: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1170: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1171: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1172: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1173: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1174: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1167: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1168: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1169: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1170: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1171: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1172: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1173: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1174: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1175: ,p_period_of_incapacity_id in number default hr_api.g_number
1168: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1169: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1170: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1171: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1172: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1173: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1174: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1175: ,p_period_of_incapacity_id in number default hr_api.g_number
1176: ,p_ssp1_issued in varchar2 default hr_api.g_varchar2
1169: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1170: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1171: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1172: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1173: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1174: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1175: ,p_period_of_incapacity_id in number default hr_api.g_number
1176: ,p_ssp1_issued in varchar2 default hr_api.g_varchar2
1177: ,p_maternity_id in number default hr_api.g_number
1170: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1171: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1172: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1173: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1174: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1175: ,p_period_of_incapacity_id in number default hr_api.g_number
1176: ,p_ssp1_issued in varchar2 default hr_api.g_varchar2
1177: ,p_maternity_id in number default hr_api.g_number
1178: ,p_sickness_start_date in date default hr_api.g_date
1171: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1172: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1173: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1174: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1175: ,p_period_of_incapacity_id in number default hr_api.g_number
1176: ,p_ssp1_issued in varchar2 default hr_api.g_varchar2
1177: ,p_maternity_id in number default hr_api.g_number
1178: ,p_sickness_start_date in date default hr_api.g_date
1179: ,p_sickness_end_date in date default hr_api.g_date
1172: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1173: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1174: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1175: ,p_period_of_incapacity_id in number default hr_api.g_number
1176: ,p_ssp1_issued in varchar2 default hr_api.g_varchar2
1177: ,p_maternity_id in number default hr_api.g_number
1178: ,p_sickness_start_date in date default hr_api.g_date
1179: ,p_sickness_end_date in date default hr_api.g_date
1180: ,p_pregnancy_related_illness in varchar2 default hr_api.g_varchar2
1173: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1174: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1175: ,p_period_of_incapacity_id in number default hr_api.g_number
1176: ,p_ssp1_issued in varchar2 default hr_api.g_varchar2
1177: ,p_maternity_id in number default hr_api.g_number
1178: ,p_sickness_start_date in date default hr_api.g_date
1179: ,p_sickness_end_date in date default hr_api.g_date
1180: ,p_pregnancy_related_illness in varchar2 default hr_api.g_varchar2
1181: ,p_reason_for_notification_dela in varchar2 default hr_api.g_varchar2
1174: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1175: ,p_period_of_incapacity_id in number default hr_api.g_number
1176: ,p_ssp1_issued in varchar2 default hr_api.g_varchar2
1177: ,p_maternity_id in number default hr_api.g_number
1178: ,p_sickness_start_date in date default hr_api.g_date
1179: ,p_sickness_end_date in date default hr_api.g_date
1180: ,p_pregnancy_related_illness in varchar2 default hr_api.g_varchar2
1181: ,p_reason_for_notification_dela in varchar2 default hr_api.g_varchar2
1182: ,p_accept_late_notification_fla in varchar2 default hr_api.g_varchar2
1175: ,p_period_of_incapacity_id in number default hr_api.g_number
1176: ,p_ssp1_issued in varchar2 default hr_api.g_varchar2
1177: ,p_maternity_id in number default hr_api.g_number
1178: ,p_sickness_start_date in date default hr_api.g_date
1179: ,p_sickness_end_date in date default hr_api.g_date
1180: ,p_pregnancy_related_illness in varchar2 default hr_api.g_varchar2
1181: ,p_reason_for_notification_dela in varchar2 default hr_api.g_varchar2
1182: ,p_accept_late_notification_fla in varchar2 default hr_api.g_varchar2
1183: ,p_linked_absence_id in number default hr_api.g_number
1176: ,p_ssp1_issued in varchar2 default hr_api.g_varchar2
1177: ,p_maternity_id in number default hr_api.g_number
1178: ,p_sickness_start_date in date default hr_api.g_date
1179: ,p_sickness_end_date in date default hr_api.g_date
1180: ,p_pregnancy_related_illness in varchar2 default hr_api.g_varchar2
1181: ,p_reason_for_notification_dela in varchar2 default hr_api.g_varchar2
1182: ,p_accept_late_notification_fla in varchar2 default hr_api.g_varchar2
1183: ,p_linked_absence_id in number default hr_api.g_number
1184: ,p_object_version_number in out nocopy number
1177: ,p_maternity_id in number default hr_api.g_number
1178: ,p_sickness_start_date in date default hr_api.g_date
1179: ,p_sickness_end_date in date default hr_api.g_date
1180: ,p_pregnancy_related_illness in varchar2 default hr_api.g_varchar2
1181: ,p_reason_for_notification_dela in varchar2 default hr_api.g_varchar2
1182: ,p_accept_late_notification_fla in varchar2 default hr_api.g_varchar2
1183: ,p_linked_absence_id in number default hr_api.g_number
1184: ,p_object_version_number in out nocopy number
1185: ,p_abs_information_category in varchar2 default null
1178: ,p_sickness_start_date in date default hr_api.g_date
1179: ,p_sickness_end_date in date default hr_api.g_date
1180: ,p_pregnancy_related_illness in varchar2 default hr_api.g_varchar2
1181: ,p_reason_for_notification_dela in varchar2 default hr_api.g_varchar2
1182: ,p_accept_late_notification_fla in varchar2 default hr_api.g_varchar2
1183: ,p_linked_absence_id in number default hr_api.g_number
1184: ,p_object_version_number in out nocopy number
1185: ,p_abs_information_category in varchar2 default null
1186: ,p_abs_information1 in varchar2 default null
1179: ,p_sickness_end_date in date default hr_api.g_date
1180: ,p_pregnancy_related_illness in varchar2 default hr_api.g_varchar2
1181: ,p_reason_for_notification_dela in varchar2 default hr_api.g_varchar2
1182: ,p_accept_late_notification_fla in varchar2 default hr_api.g_varchar2
1183: ,p_linked_absence_id in number default hr_api.g_number
1184: ,p_object_version_number in out nocopy number
1185: ,p_abs_information_category in varchar2 default null
1186: ,p_abs_information1 in varchar2 default null
1187: ,p_abs_information2 in varchar2 default null
1385: ltt_trans_obj_vers_num hr_util_web.g_varchar2_tab_type;
1386: lv_activity_name wf_item_activity_statuses_v.activity_name%TYPE;
1387: ln_trans_step_rows number default 0;
1388: ltt_trans_step_ids hr_util_web.g_varchar2_tab_type;
1389: ln_ovn hr_api_transaction_steps.object_version_number%TYPE;
1390: lv_creator_person_id per_all_people_f.person_id%TYPE;
1391:
1392:
1393: BEGIN
1519: ||---------------------------------------------------------------------------
1520: ||
1521: || Description:
1522: || This procedure will write transaction data into transaction table
1523: || hr_api_transaction_vlues
1524: ||
1525: || Access Status:
1526: || Public.
1527: ||
4516: fetch get_category_code into l_absence_category ;
4517: close get_category_code ;
4518:
4519: IF l_absence_category = 'S' THEN
4520: l_legislation_code := hr_api.return_legislation_code(p_business_group_id);
4521: IF l_legislation_code = 'GB' THEN
4522: hr_utility.set_location(l_proc,10);
4523:
4524: populate_sickness_dates := true;
5662: ,p_time_end IN VARCHAR2
5663: ) IS
5664:
5665: SELECT null
5666: FROM hr_api_transaction_values tv
5667: ,hr_api_transaction_steps ts
5668: ,hr_api_transaction_values tv1
5669: ,hr_api_transaction_values tv2
5670: ,hr_api_transaction_values tv3
5663: ) IS
5664:
5665: SELECT null
5666: FROM hr_api_transaction_values tv
5667: ,hr_api_transaction_steps ts
5668: ,hr_api_transaction_values tv1
5669: ,hr_api_transaction_values tv2
5670: ,hr_api_transaction_values tv3
5671: ,hr_api_transaction_values tv4
5664:
5665: SELECT null
5666: FROM hr_api_transaction_values tv
5667: ,hr_api_transaction_steps ts
5668: ,hr_api_transaction_values tv1
5669: ,hr_api_transaction_values tv2
5670: ,hr_api_transaction_values tv3
5671: ,hr_api_transaction_values tv4
5672: ,hr_api_transaction_values tv5
5665: SELECT null
5666: FROM hr_api_transaction_values tv
5667: ,hr_api_transaction_steps ts
5668: ,hr_api_transaction_values tv1
5669: ,hr_api_transaction_values tv2
5670: ,hr_api_transaction_values tv3
5671: ,hr_api_transaction_values tv4
5672: ,hr_api_transaction_values tv5
5673: ,hr_api_transaction_values tv6
5666: FROM hr_api_transaction_values tv
5667: ,hr_api_transaction_steps ts
5668: ,hr_api_transaction_values tv1
5669: ,hr_api_transaction_values tv2
5670: ,hr_api_transaction_values tv3
5671: ,hr_api_transaction_values tv4
5672: ,hr_api_transaction_values tv5
5673: ,hr_api_transaction_values tv6
5674: ,hr_api_transactions hat -- Fix 3191531
5667: ,hr_api_transaction_steps ts
5668: ,hr_api_transaction_values tv1
5669: ,hr_api_transaction_values tv2
5670: ,hr_api_transaction_values tv3
5671: ,hr_api_transaction_values tv4
5672: ,hr_api_transaction_values tv5
5673: ,hr_api_transaction_values tv6
5674: ,hr_api_transactions hat -- Fix 3191531
5675: WHERE
5668: ,hr_api_transaction_values tv1
5669: ,hr_api_transaction_values tv2
5670: ,hr_api_transaction_values tv3
5671: ,hr_api_transaction_values tv4
5672: ,hr_api_transaction_values tv5
5673: ,hr_api_transaction_values tv6
5674: ,hr_api_transactions hat -- Fix 3191531
5675: WHERE
5676: ts.api_name = 'HR_LOA_SS.PROCESS_API'
5669: ,hr_api_transaction_values tv2
5670: ,hr_api_transaction_values tv3
5671: ,hr_api_transaction_values tv4
5672: ,hr_api_transaction_values tv5
5673: ,hr_api_transaction_values tv6
5674: ,hr_api_transactions hat -- Fix 3191531
5675: WHERE
5676: ts.api_name = 'HR_LOA_SS.PROCESS_API'
5677: and ts.UPDATE_PERSON_ID = p_person_id
5670: ,hr_api_transaction_values tv3
5671: ,hr_api_transaction_values tv4
5672: ,hr_api_transaction_values tv5
5673: ,hr_api_transaction_values tv6
5674: ,hr_api_transactions hat -- Fix 3191531
5675: WHERE
5676: ts.api_name = 'HR_LOA_SS.PROCESS_API'
5677: and ts.UPDATE_PERSON_ID = p_person_id
5678: and p_date_start IS NOT NULL
5697: and tv3.date_value is NOT NULL
5698: and tv4.date_value is NOT NULL
5699: and (
5700: (
5701: to_date( to_char(nvl(tv3.date_value,hr_api.g_eot), g_usr_date_fmt) ||' ' || nvl(tv5.varchar2_value,'00:00'),g_usr_day_time_fmt)
5702: BETWEEN to_date (to_char(p_date_start, g_usr_date_fmt)||' ' || nvl(p_time_start,'00:00'),g_usr_day_time_fmt)
5703: AND to_date(to_char(p_date_end, g_usr_date_fmt) || ' '|| nvl(p_time_end,'00:00') , g_usr_day_time_fmt)
5704: )
5705: or
5705: or
5706: (
5707: to_date (to_char(p_date_start, g_usr_date_fmt) ||' ' || nvl(p_time_start,'00:00'),g_usr_day_time_fmt)
5708: BETWEEN
5709: to_date( to_char(nvl(tv3.date_value,hr_api.g_eot), g_usr_date_fmt) ||' ' || nvl(tv5.varchar2_value,'00:00'),g_usr_day_time_fmt)
5710: AND
5711: to_date( to_char(nvl(tv4.date_value,hr_api.g_eot), g_usr_date_fmt) ||' ' || nvl(tv6.varchar2_value,'00:00'),g_usr_day_time_fmt)
5712: )
5713:
5707: to_date (to_char(p_date_start, g_usr_date_fmt) ||' ' || nvl(p_time_start,'00:00'),g_usr_day_time_fmt)
5708: BETWEEN
5709: to_date( to_char(nvl(tv3.date_value,hr_api.g_eot), g_usr_date_fmt) ||' ' || nvl(tv5.varchar2_value,'00:00'),g_usr_day_time_fmt)
5710: AND
5711: to_date( to_char(nvl(tv4.date_value,hr_api.g_eot), g_usr_date_fmt) ||' ' || nvl(tv6.varchar2_value,'00:00'),g_usr_day_time_fmt)
5712: )
5713:
5714: )
5715: and ts.transaction_step_id <>p_transaction_step_id ;
5861: hr_utility.set_location(l_proc, 30);
5862: return;
5863: else
5864: -- Replaced call to chk_overlap function because we should check for overlapping
5865: -- in all but current transaction step id records of hr_api_transaction_values.
5866:
5867: -- Need to check for null otherwise, we may get invalid month error
5868: IF p_date_start IS NOT NULL AND p_date_end IS NOT NULL AND
5869: p_time_start IS NOT NULL and p_time_end IS NOT NULL AND p_transaction_step_id IS NOT NULL
6488: ,p_time_end IN VARCHAR2
6489: ) IS
6490:
6491: SELECT null
6492: FROM hr_api_transaction_values tv
6493: ,hr_api_transaction_steps ts
6494: ,hr_api_transaction_values tv1
6495: ,hr_api_transaction_values tv2
6496: ,hr_api_transaction_values tv3
6489: ) IS
6490:
6491: SELECT null
6492: FROM hr_api_transaction_values tv
6493: ,hr_api_transaction_steps ts
6494: ,hr_api_transaction_values tv1
6495: ,hr_api_transaction_values tv2
6496: ,hr_api_transaction_values tv3
6497: ,hr_api_transaction_values tv4
6490:
6491: SELECT null
6492: FROM hr_api_transaction_values tv
6493: ,hr_api_transaction_steps ts
6494: ,hr_api_transaction_values tv1
6495: ,hr_api_transaction_values tv2
6496: ,hr_api_transaction_values tv3
6497: ,hr_api_transaction_values tv4
6498: ,hr_api_transaction_values tv5
6491: SELECT null
6492: FROM hr_api_transaction_values tv
6493: ,hr_api_transaction_steps ts
6494: ,hr_api_transaction_values tv1
6495: ,hr_api_transaction_values tv2
6496: ,hr_api_transaction_values tv3
6497: ,hr_api_transaction_values tv4
6498: ,hr_api_transaction_values tv5
6499: ,hr_api_transaction_values tv6
6492: FROM hr_api_transaction_values tv
6493: ,hr_api_transaction_steps ts
6494: ,hr_api_transaction_values tv1
6495: ,hr_api_transaction_values tv2
6496: ,hr_api_transaction_values tv3
6497: ,hr_api_transaction_values tv4
6498: ,hr_api_transaction_values tv5
6499: ,hr_api_transaction_values tv6
6500: ,hr_api_transactions hat -- Fix 3191531
6493: ,hr_api_transaction_steps ts
6494: ,hr_api_transaction_values tv1
6495: ,hr_api_transaction_values tv2
6496: ,hr_api_transaction_values tv3
6497: ,hr_api_transaction_values tv4
6498: ,hr_api_transaction_values tv5
6499: ,hr_api_transaction_values tv6
6500: ,hr_api_transactions hat -- Fix 3191531
6501:
6494: ,hr_api_transaction_values tv1
6495: ,hr_api_transaction_values tv2
6496: ,hr_api_transaction_values tv3
6497: ,hr_api_transaction_values tv4
6498: ,hr_api_transaction_values tv5
6499: ,hr_api_transaction_values tv6
6500: ,hr_api_transactions hat -- Fix 3191531
6501:
6502: WHERE
6495: ,hr_api_transaction_values tv2
6496: ,hr_api_transaction_values tv3
6497: ,hr_api_transaction_values tv4
6498: ,hr_api_transaction_values tv5
6499: ,hr_api_transaction_values tv6
6500: ,hr_api_transactions hat -- Fix 3191531
6501:
6502: WHERE
6503: ts.api_name = 'HR_LOA_SS.PROCESS_API'
6496: ,hr_api_transaction_values tv3
6497: ,hr_api_transaction_values tv4
6498: ,hr_api_transaction_values tv5
6499: ,hr_api_transaction_values tv6
6500: ,hr_api_transactions hat -- Fix 3191531
6501:
6502: WHERE
6503: ts.api_name = 'HR_LOA_SS.PROCESS_API'
6504: and ts.UPDATE_PERSON_ID = p_person_id
6524: and tv3.date_value is NOT NULL
6525: and tv4.date_value is NOT NULL
6526: and (
6527: (
6528: to_date( to_char(nvl(tv3.date_value,hr_api.g_eot), g_usr_date_fmt) ||' ' || nvl(tv5.varchar2_value,'00:00'),g_usr_day_time_fmt)
6529: BETWEEN to_date (to_char(p_date_start, g_usr_date_fmt)||' ' || nvl(p_time_start,'00:00'),g_usr_day_time_fmt)
6530: AND to_date(to_char(p_date_end, g_usr_date_fmt) || ' '|| nvl(p_time_end,'00:00') , g_usr_day_time_fmt)
6531: )
6532: or
6532: or
6533: (
6534: to_date (to_char(p_date_start, g_usr_date_fmt) ||' ' || nvl(p_time_start,'00:00'),g_usr_day_time_fmt)
6535: BETWEEN
6536: to_date( to_char(nvl(tv3.date_value,hr_api.g_eot), g_usr_date_fmt) ||' ' || nvl(tv5.varchar2_value,'00:00'),g_usr_day_time_fmt)
6537: AND
6538: to_date( to_char(nvl(tv4.date_value,hr_api.g_eot), g_usr_date_fmt) ||' ' || nvl(tv6.varchar2_value,'00:00'),g_usr_day_time_fmt)
6539: )
6540:
6534: to_date (to_char(p_date_start, g_usr_date_fmt) ||' ' || nvl(p_time_start,'00:00'),g_usr_day_time_fmt)
6535: BETWEEN
6536: to_date( to_char(nvl(tv3.date_value,hr_api.g_eot), g_usr_date_fmt) ||' ' || nvl(tv5.varchar2_value,'00:00'),g_usr_day_time_fmt)
6537: AND
6538: to_date( to_char(nvl(tv4.date_value,hr_api.g_eot), g_usr_date_fmt) ||' ' || nvl(tv6.varchar2_value,'00:00'),g_usr_day_time_fmt)
6539: )
6540:
6541: )
6542: and ts.transaction_step_id <>p_transaction_step_id ;
6702:
6703:
6704: -- Fix 2666959 Start
6705: -- Replaced call to chk_overlap function because we should check for overlapping
6706: -- in all but current transaction step id records of hr_api_transaction_values.
6707:
6708: -- Need to check for null otherwise, we may get invalid month error
6709: IF p_date_start IS NOT NULL AND p_date_end IS NOT NULL AND
6710: p_time_start IS NOT NULL and p_time_end IS NOT NULL AND p_transaction_step_id IS NOT NULL
7661: || PROCEDURE: get_abs_from_tt
7662: ||---------------------------------------------------------------------------
7663: ||
7664: || Description:
7665: || This procedure will retrieve data from hr_api_transaction_values
7666: ||
7667: || Access Status:
7668: || Public.
7669: ||
8049: || PROCEDURE: get_rtn_from_tt
8050: ||---------------------------------------------------------------------------
8051: ||
8052: || Description:
8053: || This procedure will retrieve data from hr_api_transaction_values
8054: ||
8055: || Access Status:
8056: || Public.
8057: ||
8420: || PROCEDURE: get_upd_from_tt
8421: ||---------------------------------------------------------------------------
8422: ||
8423: || Description:
8424: || This procedure will retrieve data from hr_api_transaction_values
8425: ||
8426: || Access Status:
8427: || Public.
8428: ||
9209: (p_absence_attendance_id => p_absence_attendance_id
9210: ,p_object_version_number => p_object_version_number);
9211: --
9212: if (l_api_updating
9213: and nvl(per_abs_shd.g_old_rec.date_start, hr_api.g_date)
9214: = nvl(p_date_start, hr_api.g_date)
9215: and nvl(per_abs_shd.g_old_rec.date_end, hr_api.g_date)
9216: = nvl(p_date_end, hr_api.g_date)
9217: and nvl(per_abs_shd.g_old_rec.time_start, hr_api.g_varchar2)
9210: ,p_object_version_number => p_object_version_number);
9211: --
9212: if (l_api_updating
9213: and nvl(per_abs_shd.g_old_rec.date_start, hr_api.g_date)
9214: = nvl(p_date_start, hr_api.g_date)
9215: and nvl(per_abs_shd.g_old_rec.date_end, hr_api.g_date)
9216: = nvl(p_date_end, hr_api.g_date)
9217: and nvl(per_abs_shd.g_old_rec.time_start, hr_api.g_varchar2)
9218: = nvl(p_time_start, hr_api.g_varchar2)
9211: --
9212: if (l_api_updating
9213: and nvl(per_abs_shd.g_old_rec.date_start, hr_api.g_date)
9214: = nvl(p_date_start, hr_api.g_date)
9215: and nvl(per_abs_shd.g_old_rec.date_end, hr_api.g_date)
9216: = nvl(p_date_end, hr_api.g_date)
9217: and nvl(per_abs_shd.g_old_rec.time_start, hr_api.g_varchar2)
9218: = nvl(p_time_start, hr_api.g_varchar2)
9219: and nvl(per_abs_shd.g_old_rec.time_end, hr_api.g_varchar2)
9212: if (l_api_updating
9213: and nvl(per_abs_shd.g_old_rec.date_start, hr_api.g_date)
9214: = nvl(p_date_start, hr_api.g_date)
9215: and nvl(per_abs_shd.g_old_rec.date_end, hr_api.g_date)
9216: = nvl(p_date_end, hr_api.g_date)
9217: and nvl(per_abs_shd.g_old_rec.time_start, hr_api.g_varchar2)
9218: = nvl(p_time_start, hr_api.g_varchar2)
9219: and nvl(per_abs_shd.g_old_rec.time_end, hr_api.g_varchar2)
9220: = nvl(p_time_end, hr_api.g_varchar2)
9213: and nvl(per_abs_shd.g_old_rec.date_start, hr_api.g_date)
9214: = nvl(p_date_start, hr_api.g_date)
9215: and nvl(per_abs_shd.g_old_rec.date_end, hr_api.g_date)
9216: = nvl(p_date_end, hr_api.g_date)
9217: and nvl(per_abs_shd.g_old_rec.time_start, hr_api.g_varchar2)
9218: = nvl(p_time_start, hr_api.g_varchar2)
9219: and nvl(per_abs_shd.g_old_rec.time_end, hr_api.g_varchar2)
9220: = nvl(p_time_end, hr_api.g_varchar2)
9221: and nvl(per_abs_shd.g_old_rec.absence_days, hr_api.g_number)
9214: = nvl(p_date_start, hr_api.g_date)
9215: and nvl(per_abs_shd.g_old_rec.date_end, hr_api.g_date)
9216: = nvl(p_date_end, hr_api.g_date)
9217: and nvl(per_abs_shd.g_old_rec.time_start, hr_api.g_varchar2)
9218: = nvl(p_time_start, hr_api.g_varchar2)
9219: and nvl(per_abs_shd.g_old_rec.time_end, hr_api.g_varchar2)
9220: = nvl(p_time_end, hr_api.g_varchar2)
9221: and nvl(per_abs_shd.g_old_rec.absence_days, hr_api.g_number)
9222: = nvl(p_absence_days, hr_api.g_number)
9215: and nvl(per_abs_shd.g_old_rec.date_end, hr_api.g_date)
9216: = nvl(p_date_end, hr_api.g_date)
9217: and nvl(per_abs_shd.g_old_rec.time_start, hr_api.g_varchar2)
9218: = nvl(p_time_start, hr_api.g_varchar2)
9219: and nvl(per_abs_shd.g_old_rec.time_end, hr_api.g_varchar2)
9220: = nvl(p_time_end, hr_api.g_varchar2)
9221: and nvl(per_abs_shd.g_old_rec.absence_days, hr_api.g_number)
9222: = nvl(p_absence_days, hr_api.g_number)
9223: and nvl(per_abs_shd.g_old_rec.absence_hours, hr_api.g_number)
9216: = nvl(p_date_end, hr_api.g_date)
9217: and nvl(per_abs_shd.g_old_rec.time_start, hr_api.g_varchar2)
9218: = nvl(p_time_start, hr_api.g_varchar2)
9219: and nvl(per_abs_shd.g_old_rec.time_end, hr_api.g_varchar2)
9220: = nvl(p_time_end, hr_api.g_varchar2)
9221: and nvl(per_abs_shd.g_old_rec.absence_days, hr_api.g_number)
9222: = nvl(p_absence_days, hr_api.g_number)
9223: and nvl(per_abs_shd.g_old_rec.absence_hours, hr_api.g_number)
9224: = nvl(p_absence_hours, hr_api.g_number)) then
9217: and nvl(per_abs_shd.g_old_rec.time_start, hr_api.g_varchar2)
9218: = nvl(p_time_start, hr_api.g_varchar2)
9219: and nvl(per_abs_shd.g_old_rec.time_end, hr_api.g_varchar2)
9220: = nvl(p_time_end, hr_api.g_varchar2)
9221: and nvl(per_abs_shd.g_old_rec.absence_days, hr_api.g_number)
9222: = nvl(p_absence_days, hr_api.g_number)
9223: and nvl(per_abs_shd.g_old_rec.absence_hours, hr_api.g_number)
9224: = nvl(p_absence_hours, hr_api.g_number)) then
9225: return;
9218: = nvl(p_time_start, hr_api.g_varchar2)
9219: and nvl(per_abs_shd.g_old_rec.time_end, hr_api.g_varchar2)
9220: = nvl(p_time_end, hr_api.g_varchar2)
9221: and nvl(per_abs_shd.g_old_rec.absence_days, hr_api.g_number)
9222: = nvl(p_absence_days, hr_api.g_number)
9223: and nvl(per_abs_shd.g_old_rec.absence_hours, hr_api.g_number)
9224: = nvl(p_absence_hours, hr_api.g_number)) then
9225: return;
9226: end if;
9219: and nvl(per_abs_shd.g_old_rec.time_end, hr_api.g_varchar2)
9220: = nvl(p_time_end, hr_api.g_varchar2)
9221: and nvl(per_abs_shd.g_old_rec.absence_days, hr_api.g_number)
9222: = nvl(p_absence_days, hr_api.g_number)
9223: and nvl(per_abs_shd.g_old_rec.absence_hours, hr_api.g_number)
9224: = nvl(p_absence_hours, hr_api.g_number)) then
9225: return;
9226: end if;
9227:
9220: = nvl(p_time_end, hr_api.g_varchar2)
9221: and nvl(per_abs_shd.g_old_rec.absence_days, hr_api.g_number)
9222: = nvl(p_absence_days, hr_api.g_number)
9223: and nvl(per_abs_shd.g_old_rec.absence_hours, hr_api.g_number)
9224: = nvl(p_absence_hours, hr_api.g_number)) then
9225: return;
9226: end if;
9227:
9228: */
9247: l_assignment_id := hr_person_absence_api.get_primary_assignment
9248: (p_person_id => p_person_id
9249: ,p_effective_date => p_effective_date);
9250:
9251: l_legislation_code := hr_api.return_legislation_code
9252: (p_business_group_id => p_business_group_id);
9253:
9254: open c_get_absence_info;
9255: fetch c_get_absence_info into l_hours_or_days,
9827: ,p_time_end IN VARCHAR2
9828: ) IS
9829:
9830: SELECT null
9831: FROM hr_api_transaction_values tv
9832: ,hr_api_transaction_steps ts
9833: ,hr_api_transaction_values tv1
9834: ,hr_api_transaction_values tv2
9835: ,hr_api_transaction_values tv3
9828: ) IS
9829:
9830: SELECT null
9831: FROM hr_api_transaction_values tv
9832: ,hr_api_transaction_steps ts
9833: ,hr_api_transaction_values tv1
9834: ,hr_api_transaction_values tv2
9835: ,hr_api_transaction_values tv3
9836: ,hr_api_transaction_values tv4
9829:
9830: SELECT null
9831: FROM hr_api_transaction_values tv
9832: ,hr_api_transaction_steps ts
9833: ,hr_api_transaction_values tv1
9834: ,hr_api_transaction_values tv2
9835: ,hr_api_transaction_values tv3
9836: ,hr_api_transaction_values tv4
9837: ,hr_api_transaction_values tv5
9830: SELECT null
9831: FROM hr_api_transaction_values tv
9832: ,hr_api_transaction_steps ts
9833: ,hr_api_transaction_values tv1
9834: ,hr_api_transaction_values tv2
9835: ,hr_api_transaction_values tv3
9836: ,hr_api_transaction_values tv4
9837: ,hr_api_transaction_values tv5
9838: ,hr_api_transaction_values tv6
9831: FROM hr_api_transaction_values tv
9832: ,hr_api_transaction_steps ts
9833: ,hr_api_transaction_values tv1
9834: ,hr_api_transaction_values tv2
9835: ,hr_api_transaction_values tv3
9836: ,hr_api_transaction_values tv4
9837: ,hr_api_transaction_values tv5
9838: ,hr_api_transaction_values tv6
9839: ,hr_api_transactions hat -- Fix 3191531
9832: ,hr_api_transaction_steps ts
9833: ,hr_api_transaction_values tv1
9834: ,hr_api_transaction_values tv2
9835: ,hr_api_transaction_values tv3
9836: ,hr_api_transaction_values tv4
9837: ,hr_api_transaction_values tv5
9838: ,hr_api_transaction_values tv6
9839: ,hr_api_transactions hat -- Fix 3191531
9840: WHERE
9833: ,hr_api_transaction_values tv1
9834: ,hr_api_transaction_values tv2
9835: ,hr_api_transaction_values tv3
9836: ,hr_api_transaction_values tv4
9837: ,hr_api_transaction_values tv5
9838: ,hr_api_transaction_values tv6
9839: ,hr_api_transactions hat -- Fix 3191531
9840: WHERE
9841: ts.api_name = 'HR_LOA_SS.PROCESS_API'
9834: ,hr_api_transaction_values tv2
9835: ,hr_api_transaction_values tv3
9836: ,hr_api_transaction_values tv4
9837: ,hr_api_transaction_values tv5
9838: ,hr_api_transaction_values tv6
9839: ,hr_api_transactions hat -- Fix 3191531
9840: WHERE
9841: ts.api_name = 'HR_LOA_SS.PROCESS_API'
9842: and ts.UPDATE_PERSON_ID = p_person_id
9835: ,hr_api_transaction_values tv3
9836: ,hr_api_transaction_values tv4
9837: ,hr_api_transaction_values tv5
9838: ,hr_api_transaction_values tv6
9839: ,hr_api_transactions hat -- Fix 3191531
9840: WHERE
9841: ts.api_name = 'HR_LOA_SS.PROCESS_API'
9842: and ts.UPDATE_PERSON_ID = p_person_id
9843: and p_date_start IS NOT NULL
9862: and tv3.date_value is NOT NULL
9863: and tv4.date_value is NOT NULL
9864: and (
9865: (
9866: to_date( to_char(nvl(tv3.date_value,hr_api.g_eot), g_usr_date_fmt) ||' ' || nvl(tv5.varchar2_value,'00:00'),g_usr_day_time_fmt)
9867: BETWEEN to_date (to_char(p_date_start, g_usr_date_fmt)||' ' || nvl(p_time_start,'00:00'),g_usr_day_time_fmt)
9868: AND to_date(to_char(p_date_end, g_usr_date_fmt) || ' '|| nvl(p_time_end,'00:00') , g_usr_day_time_fmt)
9869: )
9870: or
9870: or
9871: (
9872: to_date (to_char(p_date_start, g_usr_date_fmt) ||' ' || nvl(p_time_start,'00:00'),g_usr_day_time_fmt)
9873: BETWEEN
9874: to_date( to_char(nvl(tv3.date_value,hr_api.g_eot), g_usr_date_fmt) ||' ' || nvl(tv5.varchar2_value,'00:00'),g_usr_day_time_fmt)
9875: AND
9876: to_date( to_char(nvl(tv4.date_value,hr_api.g_eot), g_usr_date_fmt) ||' ' || nvl(tv6.varchar2_value,'00:00'),g_usr_day_time_fmt)
9877: )
9878:
9872: to_date (to_char(p_date_start, g_usr_date_fmt) ||' ' || nvl(p_time_start,'00:00'),g_usr_day_time_fmt)
9873: BETWEEN
9874: to_date( to_char(nvl(tv3.date_value,hr_api.g_eot), g_usr_date_fmt) ||' ' || nvl(tv5.varchar2_value,'00:00'),g_usr_day_time_fmt)
9875: AND
9876: to_date( to_char(nvl(tv4.date_value,hr_api.g_eot), g_usr_date_fmt) ||' ' || nvl(tv6.varchar2_value,'00:00'),g_usr_day_time_fmt)
9877: )
9878:
9879: );
9880: --