eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_LOA_SS dependencies on HR_API

Line 349: (p_effective_date in date default hr_api.g_date

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 clob default hr_api.g_varchar2 -- Bug#13362792
353: ,p_date_notification in date default hr_api.g_date

Line 350: ,p_absence_attendance_id in number default hr_api.g_number

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 clob default hr_api.g_varchar2 -- Bug#13362792
353: ,p_date_notification in date default hr_api.g_date
354: ,p_date_projected_start in date default hr_api.g_date

Line 351: ,p_abs_attendance_reason_id in number default hr_api.g_number

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 clob default hr_api.g_varchar2 -- Bug#13362792
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

Line 352: ,p_comments in clob default hr_api.g_varchar2 -- Bug#13362792

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 clob default hr_api.g_varchar2 -- Bug#13362792
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

Line 353: ,p_date_notification 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 clob default hr_api.g_varchar2 -- Bug#13362792
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

Line 354: ,p_date_projected_start 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 clob default hr_api.g_varchar2 -- Bug#13362792
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

Line 355: ,p_time_projected_start in varchar2 default hr_api.g_varchar2

351: ,p_abs_attendance_reason_id in number default hr_api.g_number
352: ,p_comments in clob default hr_api.g_varchar2 -- Bug#13362792
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

Line 356: ,p_date_projected_end in date default hr_api.g_date

352: ,p_comments in clob default hr_api.g_varchar2 -- Bug#13362792
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

Line 357: ,p_time_projected_end in varchar2 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
361: ,p_time_end in varchar2 default hr_api.g_varchar2

Line 358: ,p_date_start 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
362: ,p_absence_days in number default hr_api.g_number

Line 359: ,p_time_start in varchar2 default hr_api.g_varchar2

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

Line 360: ,p_date_end in date default hr_api.g_date

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

Line 361: ,p_time_end in varchar2 default hr_api.g_varchar2

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

Line 362: ,p_absence_days 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

Line 363: ,p_absence_hours in number default hr_api.g_number

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

Line 364: ,p_authorising_person_id in number default hr_api.g_number

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

Line 365: ,p_replacement_person_id in number default hr_api.g_number

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

Line 366: ,p_attribute_category 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

Line 367: ,p_attribute1 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

Line 368: ,p_attribute2 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

Line 369: ,p_attribute3 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

Line 370: ,p_attribute4 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

Line 371: ,p_attribute5 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

Line 372: ,p_attribute6 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

Line 373: ,p_attribute7 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

Line 374: ,p_attribute8 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

Line 375: ,p_attribute9 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

Line 376: ,p_attribute10 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

Line 377: ,p_attribute11 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

Line 378: ,p_attribute12 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

Line 379: ,p_attribute13 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

Line 380: ,p_attribute14 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

Line 381: ,p_attribute15 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

Line 382: ,p_attribute16 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

Line 383: ,p_attribute17 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

Line 384: ,p_attribute18 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
388: ,p_ssp1_issued in varchar2 default hr_api.g_varchar2

Line 385: ,p_attribute19 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

Line 386: ,p_attribute20 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
390: ,p_sickness_start_date in date default hr_api.g_date

Line 387: ,p_absiod_of_incapacity_id in number default hr_api.g_number

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

Line 388: ,p_ssp1_issued 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
392: ,p_pregnancy_related_illness in varchar2 default hr_api.g_varchar2

Line 389: ,p_maternity_id in number default hr_api.g_number

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

Line 390: ,p_sickness_start_date in date default hr_api.g_date

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

Line 391: ,p_sickness_end_date in date default hr_api.g_date

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

Line 392: ,p_pregnancy_related_illness in varchar2 default hr_api.g_varchar2

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

Line 393: ,p_reason_for_notification_dela 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
397: ,p_abs_information_category in varchar2 default hr_api.g_varchar2

Line 394: ,p_accept_late_notification_fla 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

Line 395: ,p_linked_absence_id in number default hr_api.g_number

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

Line 396: ,p_batch_id in number default hr_api.g_number

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

Line 397: ,p_abs_information_category 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

Line 398: ,p_abs_information1 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

Line 399: ,p_abs_information2 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

Line 400: ,p_abs_information3 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

Line 401: ,p_abs_information4 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

Line 402: ,p_abs_information5 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

Line 403: ,p_abs_information6 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

Line 404: ,p_abs_information7 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

Line 405: ,p_abs_information8 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

Line 406: ,p_abs_information9 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

Line 407: ,p_abs_information10 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

Line 408: ,p_abs_information11 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

Line 409: ,p_abs_information12 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

Line 410: ,p_abs_information13 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

Line 411: ,p_abs_information14 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

Line 412: ,p_abs_information15 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

Line 413: ,p_abs_information16 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

Line 414: ,p_abs_information17 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

Line 415: ,p_abs_information18 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

Line 416: ,p_abs_information19 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

Line 417: ,p_abs_information20 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

Line 418: ,p_abs_information21 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

Line 419: ,p_abs_information22 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

Line 420: ,p_abs_information23 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

Line 421: ,p_abs_information24 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

Line 422: ,p_abs_information25 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

Line 423: ,p_abs_information26 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

Line 424: ,p_abs_information27 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

Line 425: ,p_abs_information28 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
429: )

Line 426: ,p_abs_information29 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: )
430: return boolean

Line 427: ,p_abs_information30 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
431: IS

Line 428: ,p_object_version_number in number default hr_api.g_number

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:

Line 456: -- NOTE: We need to use nvl(xxx attribute name, hr_api.g_xxxx) because the

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: ------------------------------------------------------------------------------

Line 461: IF p_date_projected_start <> hr_api.g_date OR p_date_projected_start IS NULL

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)

Line 464: IF nvl(p_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;

Line 465: nvl(l_cur_absence_row.date_projected_start, hr_api.g_date)

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;

Line 472: IF p_date_projected_end <> hr_api.g_date OR p_date_projected_end IS NULL

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

Line 474: IF nvl(p_date_projected_end, hr_api.g_date) <>

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;

Line 475: nvl(l_cur_absence_row.date_projected_end, hr_api.g_date)

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;

Line 482: IF p_time_projected_start <> hr_api.g_varchar2 OR p_time_projected_start IS NULL

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

Line 484: IF nvl(p_time_projected_start, hr_api.g_varchar2) <>

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;

Line 485: nvl(l_cur_absence_row.time_projected_start, hr_api.g_varchar2)

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;

Line 492: IF p_time_projected_end <> hr_api.g_varchar2 OR p_time_projected_end IS NULL

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

Line 494: IF nvl(p_time_projected_end, hr_api.g_varchar2) <>

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;

Line 495: nvl(l_cur_absence_row.time_projected_end, hr_api.g_varchar2)

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;

Line 502: IF p_date_start <> hr_api.g_date OR p_date_start IS NULL

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

Line 504: IF nvl(p_date_start, hr_api.g_date) <>

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;

Line 505: nvl(l_cur_absence_row.date_start, hr_api.g_date)

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;

Line 512: IF p_date_end <> hr_api.g_date OR p_date_end IS NULL

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

Line 514: IF nvl(p_date_end, hr_api.g_date) <>

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;

Line 515: nvl(l_cur_absence_row.date_end, hr_api.g_date)

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;

Line 522: IF p_time_start <> hr_api.g_varchar2 OR p_time_start IS NULL

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

Line 524: IF nvl(p_time_start, hr_api.g_varchar2) <>

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;

Line 525: nvl(l_cur_absence_row.time_start, hr_api.g_varchar2)

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;

Line 532: IF p_time_end <> hr_api.g_varchar2 OR p_time_end IS NULL

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

Line 534: IF nvl(p_time_end, hr_api.g_varchar2) <>

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;

Line 535: nvl(l_cur_absence_row.time_end, hr_api.g_varchar2)

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;

Line 542: IF p_absence_days <> hr_api.g_number OR p_absence_days IS NULL

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

Line 544: IF nvl(p_absence_days, hr_api.g_number) <>

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;

Line 545: nvl(l_cur_absence_row.absence_days, hr_api.g_number)

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;

Line 552: IF p_absence_hours <> hr_api.g_number OR p_absence_hours IS NULL

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

Line 554: IF nvl(p_absence_hours, hr_api.g_number) <>

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;

Line 555: nvl(l_cur_absence_row.absence_hours, hr_api.g_number)

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;

Line 562: IF p_replacement_person_id <> hr_api.g_number OR p_replacement_person_id IS NULL

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

Line 564: IF nvl(p_replacement_person_id, hr_api.g_number) <>

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;

Line 565: nvl(l_cur_absence_row.replacement_person_id, hr_api.g_number)

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;

Line 572: IF p_comments <> hr_api.g_varchar2 OR p_comments IS NULL

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

Line 574: IF nvl(p_comments, hr_api.g_varchar2) <>

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;

Line 575: nvl(l_cur_absence_row.comments, hr_api.g_varchar2)

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;

Line 582: IF p_attribute_category <> hr_api.g_varchar2 OR p_attribute_category IS NULL

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

Line 584: IF nvl(p_attribute_category, hr_api.g_varchar2) <>

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;

Line 585: nvl(l_cur_absence_row.attribute_category, hr_api.g_varchar2)

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;

Line 592: IF p_attribute1 <> hr_api.g_varchar2 OR p_attribute1 IS NULL

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

Line 594: IF nvl(p_attribute1, hr_api.g_varchar2) <>

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;

Line 595: nvl(l_cur_absence_row.attribute1, hr_api.g_varchar2)

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;

Line 602: IF p_attribute2 <> hr_api.g_varchar2 OR p_attribute2 IS NULL

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

Line 604: IF nvl(p_attribute2, hr_api.g_varchar2) <>

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;

Line 605: nvl(l_cur_absence_row.attribute2, hr_api.g_varchar2)

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;

Line 612: IF p_attribute3 <> hr_api.g_varchar2 OR p_attribute3 IS NULL

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

Line 614: IF nvl(p_attribute3, hr_api.g_varchar2) <>

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;

Line 615: nvl(l_cur_absence_row.attribute3, hr_api.g_varchar2)

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;

Line 622: IF p_attribute4 <> hr_api.g_varchar2 OR p_attribute4 IS NULL

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

Line 624: IF nvl(p_attribute4, hr_api.g_varchar2) <>

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;

Line 625: nvl(l_cur_absence_row.attribute4, hr_api.g_varchar2)

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;

Line 632: IF p_attribute5 <> hr_api.g_varchar2 OR p_attribute5 IS NULL

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

Line 634: IF nvl(p_attribute5, hr_api.g_varchar2) <>

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;

Line 635: nvl(l_cur_absence_row.attribute5, hr_api.g_varchar2)

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;

Line 642: IF p_attribute6 <> hr_api.g_varchar2 OR p_attribute6 IS NULL

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

Line 644: IF nvl(p_attribute6, hr_api.g_varchar2) <>

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;

Line 645: nvl(l_cur_absence_row.attribute6, hr_api.g_varchar2)

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;

Line 652: IF p_attribute7 <> hr_api.g_varchar2 OR p_attribute7 IS NULL

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

Line 654: IF nvl(p_attribute7, hr_api.g_varchar2) <>

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;

Line 655: nvl(l_cur_absence_row.attribute7, hr_api.g_varchar2)

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;

Line 662: IF p_attribute8 <> hr_api.g_varchar2 OR p_attribute8 IS NULL

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

Line 664: IF nvl(p_attribute8, hr_api.g_varchar2) <>

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;

Line 665: nvl(l_cur_absence_row.attribute8, hr_api.g_varchar2)

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;

Line 672: IF p_attribute9 <> hr_api.g_varchar2 OR p_attribute9 IS NULL

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

Line 674: IF nvl(p_attribute9, hr_api.g_varchar2) <>

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;

Line 675: nvl(l_cur_absence_row.attribute9, hr_api.g_varchar2)

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;

Line 682: IF p_attribute10 <> hr_api.g_varchar2 OR p_attribute10 IS NULL

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

Line 684: IF nvl(p_attribute10, hr_api.g_varchar2) <>

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;

Line 685: nvl(l_cur_absence_row.attribute10, hr_api.g_varchar2)

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;

Line 692: IF p_attribute11 <> hr_api.g_varchar2 OR p_attribute11 IS NULL

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

Line 694: IF nvl(p_attribute11, hr_api.g_varchar2) <>

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;

Line 695: nvl(l_cur_absence_row.attribute11, hr_api.g_varchar2)

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;

Line 702: IF p_attribute12 <> hr_api.g_varchar2 OR p_attribute12 IS NULL

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

Line 704: IF nvl(p_attribute12, hr_api.g_varchar2) <>

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;

Line 705: nvl(l_cur_absence_row.attribute12, hr_api.g_varchar2)

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;

Line 712: IF p_attribute13 <> hr_api.g_varchar2 OR p_attribute13 IS NULL

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

Line 714: IF nvl(p_attribute13, hr_api.g_varchar2) <>

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;

Line 715: nvl(l_cur_absence_row.attribute13, hr_api.g_varchar2)

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;

Line 722: IF p_attribute14 <> hr_api.g_varchar2 OR p_attribute14 IS NULL

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

Line 724: IF nvl(p_attribute14, hr_api.g_varchar2) <>

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;

Line 725: nvl(l_cur_absence_row.attribute14, hr_api.g_varchar2)

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;

Line 732: IF p_attribute15 <> hr_api.g_varchar2 OR p_attribute15 IS NULL

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

Line 734: IF nvl(p_attribute15, hr_api.g_varchar2) <>

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;

Line 735: nvl(l_cur_absence_row.attribute15, hr_api.g_varchar2)

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;

Line 742: IF p_attribute16 <> hr_api.g_varchar2 OR p_attribute16 IS NULL

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

Line 744: IF nvl(p_attribute16, hr_api.g_varchar2) <>

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;

Line 745: nvl(l_cur_absence_row.attribute16, hr_api.g_varchar2)

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;

Line 752: IF p_attribute17 <> hr_api.g_varchar2 OR p_attribute17 IS NULL

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

Line 754: IF nvl(p_attribute17, hr_api.g_varchar2) <>

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;

Line 755: nvl(l_cur_absence_row.attribute17, hr_api.g_varchar2)

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;

Line 762: IF p_attribute18 <> hr_api.g_varchar2 OR p_attribute18 IS NULL

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

Line 764: IF nvl(p_attribute18, hr_api.g_varchar2) <>

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;

Line 765: nvl(l_cur_absence_row.attribute18, hr_api.g_varchar2)

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;

Line 772: IF p_attribute19 <> hr_api.g_varchar2 OR p_attribute19 IS NULL

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

Line 774: IF nvl(p_attribute19, hr_api.g_varchar2) <>

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;

Line 775: nvl(l_cur_absence_row.attribute19, hr_api.g_varchar2)

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;

Line 782: IF p_attribute20 <> hr_api.g_varchar2 OR p_attribute20 IS NULL

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

Line 784: IF nvl(p_attribute20, hr_api.g_varchar2) <>

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;

Line 785: nvl(l_cur_absence_row.attribute20, hr_api.g_varchar2)

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;

Line 792: IF p_abs_information_category <> hr_api.g_varchar2 OR p_abs_information_category IS NULL

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

Line 794: IF nvl(p_abs_information_category, hr_api.g_varchar2) <>

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;

Line 795: nvl(l_cur_absence_row.abs_information_category, hr_api.g_varchar2)

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;

Line 802: IF p_abs_information1 <> hr_api.g_varchar2 OR p_abs_information1 IS NULL

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

Line 804: IF nvl(p_abs_information1, hr_api.g_varchar2) <>

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;

Line 805: nvl(l_cur_absence_row.abs_information1, hr_api.g_varchar2)

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;

Line 812: IF p_abs_information2 <> hr_api.g_varchar2 OR p_abs_information2 IS NULL

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

Line 814: IF nvl(p_abs_information2, hr_api.g_varchar2) <>

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;

Line 815: nvl(l_cur_absence_row.abs_information2, hr_api.g_varchar2)

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;

Line 822: IF p_abs_information3 <> hr_api.g_varchar2 OR p_abs_information3 IS NULL

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

Line 824: IF nvl(p_abs_information3, hr_api.g_varchar2) <>

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;

Line 825: nvl(l_cur_absence_row.abs_information3, hr_api.g_varchar2)

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;

Line 832: IF p_abs_information4 <> hr_api.g_varchar2 OR p_abs_information4 IS NULL

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

Line 834: IF nvl(p_abs_information4, hr_api.g_varchar2) <>

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;

Line 835: nvl(l_cur_absence_row.abs_information4, hr_api.g_varchar2)

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;

Line 842: IF p_abs_information5 <> hr_api.g_varchar2 OR p_abs_information5 IS NULL

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

Line 844: IF nvl(p_abs_information5, hr_api.g_varchar2) <>

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;

Line 845: nvl(l_cur_absence_row.abs_information5, hr_api.g_varchar2)

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;

Line 852: IF p_abs_information6 <> hr_api.g_varchar2 OR p_abs_information6 IS NULL

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

Line 854: IF nvl(p_abs_information6, hr_api.g_varchar2) <>

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;

Line 855: nvl(l_cur_absence_row.abs_information6, hr_api.g_varchar2)

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;

Line 862: IF p_abs_information7 <> hr_api.g_varchar2 OR p_abs_information7 IS NULL

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

Line 864: IF nvl(p_abs_information7, hr_api.g_varchar2) <>

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;

Line 865: nvl(l_cur_absence_row.abs_information7, hr_api.g_varchar2)

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;

Line 872: IF p_abs_information8 <> hr_api.g_varchar2 OR p_abs_information8 IS NULL

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

Line 874: IF nvl(p_abs_information8, hr_api.g_varchar2) <>

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;

Line 875: nvl(l_cur_absence_row.abs_information8, hr_api.g_varchar2)

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;

Line 882: IF p_abs_information9 <> hr_api.g_varchar2 OR p_abs_information9 IS NULL

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

Line 884: IF nvl(p_abs_information9, hr_api.g_varchar2) <>

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;

Line 885: nvl(l_cur_absence_row.abs_information9, hr_api.g_varchar2)

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;

Line 892: IF p_abs_information10 <> hr_api.g_varchar2 OR p_abs_information10 IS NULL

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

Line 894: IF nvl(p_abs_information10, hr_api.g_varchar2) <>

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;

Line 895: nvl(l_cur_absence_row.abs_information10, hr_api.g_varchar2)

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;

Line 902: IF p_abs_information11 <> hr_api.g_varchar2 OR p_abs_information11 IS NULL

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

Line 904: IF nvl(p_abs_information11, hr_api.g_varchar2) <>

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;

Line 905: nvl(l_cur_absence_row.abs_information11, hr_api.g_varchar2)

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;

Line 912: IF p_abs_information12 <> hr_api.g_varchar2 OR p_abs_information12 IS NULL

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

Line 914: IF nvl(p_abs_information12, hr_api.g_varchar2) <>

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;

Line 915: nvl(l_cur_absence_row.abs_information12, hr_api.g_varchar2)

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;

Line 922: IF p_abs_information13 <> hr_api.g_varchar2 OR p_abs_information13 IS NULL

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

Line 924: IF nvl(p_abs_information13, hr_api.g_varchar2) <>

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;

Line 925: nvl(l_cur_absence_row.abs_information13, hr_api.g_varchar2)

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;

Line 932: IF p_abs_information14 <> hr_api.g_varchar2 OR p_abs_information14 IS NULL

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

Line 934: IF nvl(p_abs_information14, hr_api.g_varchar2) <>

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;

Line 935: nvl(l_cur_absence_row.abs_information14, hr_api.g_varchar2)

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;

Line 942: IF p_abs_information15 <> hr_api.g_varchar2 OR p_abs_information15 IS NULL

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

Line 944: IF nvl(p_abs_information15, hr_api.g_varchar2) <>

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;

Line 945: nvl(l_cur_absence_row.abs_information15, hr_api.g_varchar2)

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;

Line 952: IF p_abs_information16 <> hr_api.g_varchar2 OR p_abs_information16 IS NULL

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

Line 954: IF nvl(p_abs_information16, hr_api.g_varchar2) <>

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;

Line 955: nvl(l_cur_absence_row.abs_information16, hr_api.g_varchar2)

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;

Line 962: IF p_abs_information17 <> hr_api.g_varchar2 OR p_abs_information17 IS NULL

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

Line 964: IF nvl(p_abs_information17, hr_api.g_varchar2) <>

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;

Line 965: nvl(l_cur_absence_row.abs_information17, hr_api.g_varchar2)

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;

Line 972: IF p_abs_information18 <> hr_api.g_varchar2 OR p_abs_information18 IS NULL

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

Line 974: IF nvl(p_abs_information18, hr_api.g_varchar2) <>

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;

Line 975: nvl(l_cur_absence_row.abs_information18, hr_api.g_varchar2)

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;

Line 982: IF p_abs_information19 <> hr_api.g_varchar2 OR p_abs_information19 IS NULL

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

Line 984: IF nvl(p_abs_information19, hr_api.g_varchar2) <>

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;

Line 985: nvl(l_cur_absence_row.abs_information19, hr_api.g_varchar2)

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;

Line 992: IF p_abs_information20 <> hr_api.g_varchar2 OR p_abs_information20 IS NULL

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

Line 994: IF nvl(p_abs_information20, hr_api.g_varchar2) <>

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;

Line 995: nvl(l_cur_absence_row.abs_information20, hr_api.g_varchar2)

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;

Line 1002: IF p_abs_information21 <> hr_api.g_varchar2 OR p_abs_information21 IS NULL

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

Line 1004: IF nvl(p_abs_information21, hr_api.g_varchar2) <>

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;

Line 1005: nvl(l_cur_absence_row.abs_information21, hr_api.g_varchar2)

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;

Line 1012: IF p_abs_information22 <> hr_api.g_varchar2 OR p_abs_information22 IS NULL

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

Line 1014: IF nvl(p_abs_information22, hr_api.g_varchar2) <>

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;

Line 1015: nvl(l_cur_absence_row.abs_information22, hr_api.g_varchar2)

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;

Line 1022: IF p_abs_information23 <> hr_api.g_varchar2 OR p_abs_information23 IS NULL

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

Line 1024: IF nvl(p_abs_information23, hr_api.g_varchar2) <>

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;

Line 1025: nvl(l_cur_absence_row.abs_information23, hr_api.g_varchar2)

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;

Line 1032: IF p_abs_information24 <> hr_api.g_varchar2 OR p_abs_information24 IS NULL

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

Line 1034: IF nvl(p_abs_information24, hr_api.g_varchar2) <>

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;

Line 1035: nvl(l_cur_absence_row.abs_information24, hr_api.g_varchar2)

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;

Line 1042: IF p_abs_information25 <> hr_api.g_varchar2 OR p_abs_information25 IS NULL

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

Line 1044: IF nvl(p_abs_information25, hr_api.g_varchar2) <>

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;

Line 1045: nvl(l_cur_absence_row.abs_information25, hr_api.g_varchar2)

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;

Line 1052: IF p_abs_information26 <> hr_api.g_varchar2 OR p_abs_information26 IS NULL

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

Line 1054: IF nvl(p_abs_information26, hr_api.g_varchar2) <>

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;

Line 1055: nvl(l_cur_absence_row.abs_information26, hr_api.g_varchar2)

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;

Line 1062: IF p_abs_information27 <> hr_api.g_varchar2 OR p_abs_information27 IS NULL

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

Line 1064: IF nvl(p_abs_information27, hr_api.g_varchar2) <>

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;

Line 1065: nvl(l_cur_absence_row.abs_information27, hr_api.g_varchar2)

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;

Line 1072: IF p_abs_information28 <> hr_api.g_varchar2 OR p_abs_information28 IS NULL

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

Line 1074: IF nvl(p_abs_information28, hr_api.g_varchar2) <>

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;

Line 1075: nvl(l_cur_absence_row.abs_information28, hr_api.g_varchar2)

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;

Line 1082: IF p_abs_information29 <> hr_api.g_varchar2 OR p_abs_information29 IS NULL

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

Line 1084: IF nvl(p_abs_information29, hr_api.g_varchar2) <>

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;

Line 1085: nvl(l_cur_absence_row.abs_information29, hr_api.g_varchar2)

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;

Line 1092: IF p_abs_information30 <> hr_api.g_varchar2 OR p_abs_information30 IS NULL

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

Line 1094: IF nvl(p_abs_information30, hr_api.g_varchar2) <>

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;

Line 1095: nvl(l_cur_absence_row.abs_information30, hr_api.g_varchar2)

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;

Line 1139: ,p_abs_attendance_reason_id in number default hr_api.g_number

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 clob default hr_api.g_varchar2 -- Bug#13362792
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

Line 1140: ,p_comments in clob default hr_api.g_varchar2 -- Bug#13362792

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 clob default hr_api.g_varchar2 -- Bug#13362792
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

Line 1141: ,p_date_notification 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 clob default hr_api.g_varchar2 -- Bug#13362792
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

Line 1142: ,p_date_projected_start in date default hr_api.g_date

1138: ,p_absence_attendance_id in number
1139: ,p_abs_attendance_reason_id in number default hr_api.g_number
1140: ,p_comments in clob default hr_api.g_varchar2 -- Bug#13362792
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

Line 1143: ,p_time_projected_start in varchar2 default hr_api.g_varchar2

1139: ,p_abs_attendance_reason_id in number default hr_api.g_number
1140: ,p_comments in clob default hr_api.g_varchar2 -- Bug#13362792
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

Line 1144: ,p_date_projected_end in date default hr_api.g_date

1140: ,p_comments in clob default hr_api.g_varchar2 -- Bug#13362792
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

Line 1145: ,p_time_projected_end in varchar2 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
1149: ,p_time_end in varchar2 default hr_api.g_varchar2

Line 1146: ,p_date_start 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
1150: ,p_absence_days in out nocopy number

Line 1147: ,p_time_start in varchar2 default hr_api.g_varchar2

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

Line 1148: ,p_date_end in date default hr_api.g_date

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

Line 1149: ,p_time_end in varchar2 default hr_api.g_varchar2

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

Line 1152: ,p_authorising_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

Line 1153: ,p_replacement_person_id in number default hr_api.g_number

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

Line 1154: ,p_attribute_category 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

Line 1155: ,p_attribute1 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

Line 1156: ,p_attribute2 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

Line 1157: ,p_attribute3 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

Line 1158: ,p_attribute4 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

Line 1159: ,p_attribute5 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

Line 1160: ,p_attribute6 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

Line 1161: ,p_attribute7 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

Line 1162: ,p_attribute8 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

Line 1163: ,p_attribute9 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

Line 1164: ,p_attribute10 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

Line 1165: ,p_attribute11 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

Line 1166: ,p_attribute12 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

Line 1167: ,p_attribute13 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

Line 1168: ,p_attribute14 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

Line 1169: ,p_attribute15 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

Line 1170: ,p_attribute16 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

Line 1171: ,p_attribute17 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

Line 1172: ,p_attribute18 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
1176: ,p_ssp1_issued in varchar2 default hr_api.g_varchar2

Line 1173: ,p_attribute19 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

Line 1174: ,p_attribute20 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
1178: ,p_sickness_start_date in date default hr_api.g_date

Line 1175: ,p_period_of_incapacity_id in number default hr_api.g_number

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

Line 1176: ,p_ssp1_issued 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
1180: ,p_pregnancy_related_illness in varchar2 default hr_api.g_varchar2

Line 1177: ,p_maternity_id in number default hr_api.g_number

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

Line 1178: ,p_sickness_start_date in date default hr_api.g_date

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

Line 1179: ,p_sickness_end_date in date default hr_api.g_date

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

Line 1180: ,p_pregnancy_related_illness in varchar2 default hr_api.g_varchar2

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

Line 1181: ,p_reason_for_notification_dela 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
1185: ,p_abs_information_category in varchar2 default null

Line 1182: ,p_accept_late_notification_fla in varchar2 default hr_api.g_varchar2

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

Line 1183: ,p_linked_absence_id in number default hr_api.g_number

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

Line 1389: ln_ovn hr_api_transaction_steps.object_version_number%TYPE;

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

Line 1523: || hr_api_transaction_vlues

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: ||

Line 4520: l_legislation_code := hr_api.return_legislation_code(p_business_group_id);

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;

Line 5666: FROM hr_api_transaction_values tv

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

Line 5667: ,hr_api_transaction_steps ts

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

Line 5668: ,hr_api_transaction_values tv1

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

Line 5669: ,hr_api_transaction_values tv2

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

Line 5670: ,hr_api_transaction_values tv3

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

Line 5671: ,hr_api_transaction_values tv4

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

Line 5672: ,hr_api_transaction_values tv5

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'

Line 5673: ,hr_api_transaction_values tv6

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

Line 5674: ,hr_api_transactions hat -- Fix 3191531

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

Line 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)

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

Line 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)

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:

Line 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)

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 ;

Line 5865: -- in all but current transaction step id records of hr_api_transaction_values.

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

Line 6492: FROM hr_api_transaction_values tv

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

Line 6493: ,hr_api_transaction_steps ts

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

Line 6494: ,hr_api_transaction_values tv1

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

Line 6495: ,hr_api_transaction_values tv2

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

Line 6496: ,hr_api_transaction_values tv3

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

Line 6497: ,hr_api_transaction_values tv4

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:

Line 6498: ,hr_api_transaction_values tv5

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

Line 6499: ,hr_api_transaction_values tv6

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'

Line 6500: ,hr_api_transactions hat -- Fix 3191531

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

Line 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)

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

Line 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)

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:

Line 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)

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 ;

Line 6706: -- in all but current transaction step id records of hr_api_transaction_values.

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

Line 7665: || This procedure will retrieve data from hr_api_transaction_values

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: ||

Line 8053: || This procedure will retrieve data from hr_api_transaction_values

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: ||

Line 8424: || This procedure will retrieve data from hr_api_transaction_values

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: ||

Line 9432: and nvl(per_abs_shd.g_old_rec.date_start, hr_api.g_date)

9428: (p_absence_attendance_id => p_absence_attendance_id
9429: ,p_object_version_number => p_object_version_number);
9430: --
9431: if (l_api_updating
9432: and nvl(per_abs_shd.g_old_rec.date_start, hr_api.g_date)
9433: = nvl(p_date_start, hr_api.g_date)
9434: and nvl(per_abs_shd.g_old_rec.date_end, hr_api.g_date)
9435: = nvl(p_date_end, hr_api.g_date)
9436: and nvl(per_abs_shd.g_old_rec.time_start, hr_api.g_varchar2)

Line 9433: = nvl(p_date_start, hr_api.g_date)

9429: ,p_object_version_number => p_object_version_number);
9430: --
9431: if (l_api_updating
9432: and nvl(per_abs_shd.g_old_rec.date_start, hr_api.g_date)
9433: = nvl(p_date_start, hr_api.g_date)
9434: and nvl(per_abs_shd.g_old_rec.date_end, hr_api.g_date)
9435: = nvl(p_date_end, hr_api.g_date)
9436: and nvl(per_abs_shd.g_old_rec.time_start, hr_api.g_varchar2)
9437: = nvl(p_time_start, hr_api.g_varchar2)

Line 9434: and nvl(per_abs_shd.g_old_rec.date_end, hr_api.g_date)

9430: --
9431: if (l_api_updating
9432: and nvl(per_abs_shd.g_old_rec.date_start, hr_api.g_date)
9433: = nvl(p_date_start, hr_api.g_date)
9434: and nvl(per_abs_shd.g_old_rec.date_end, hr_api.g_date)
9435: = nvl(p_date_end, hr_api.g_date)
9436: and nvl(per_abs_shd.g_old_rec.time_start, hr_api.g_varchar2)
9437: = nvl(p_time_start, hr_api.g_varchar2)
9438: and nvl(per_abs_shd.g_old_rec.time_end, hr_api.g_varchar2)

Line 9435: = nvl(p_date_end, hr_api.g_date)

9431: if (l_api_updating
9432: and nvl(per_abs_shd.g_old_rec.date_start, hr_api.g_date)
9433: = nvl(p_date_start, hr_api.g_date)
9434: and nvl(per_abs_shd.g_old_rec.date_end, hr_api.g_date)
9435: = nvl(p_date_end, hr_api.g_date)
9436: and nvl(per_abs_shd.g_old_rec.time_start, hr_api.g_varchar2)
9437: = nvl(p_time_start, hr_api.g_varchar2)
9438: and nvl(per_abs_shd.g_old_rec.time_end, hr_api.g_varchar2)
9439: = nvl(p_time_end, hr_api.g_varchar2)

Line 9436: and nvl(per_abs_shd.g_old_rec.time_start, hr_api.g_varchar2)

9432: and nvl(per_abs_shd.g_old_rec.date_start, hr_api.g_date)
9433: = nvl(p_date_start, hr_api.g_date)
9434: and nvl(per_abs_shd.g_old_rec.date_end, hr_api.g_date)
9435: = nvl(p_date_end, hr_api.g_date)
9436: and nvl(per_abs_shd.g_old_rec.time_start, hr_api.g_varchar2)
9437: = nvl(p_time_start, hr_api.g_varchar2)
9438: and nvl(per_abs_shd.g_old_rec.time_end, hr_api.g_varchar2)
9439: = nvl(p_time_end, hr_api.g_varchar2)
9440: and nvl(per_abs_shd.g_old_rec.absence_days, hr_api.g_number)

Line 9437: = nvl(p_time_start, hr_api.g_varchar2)

9433: = nvl(p_date_start, hr_api.g_date)
9434: and nvl(per_abs_shd.g_old_rec.date_end, hr_api.g_date)
9435: = nvl(p_date_end, hr_api.g_date)
9436: and nvl(per_abs_shd.g_old_rec.time_start, hr_api.g_varchar2)
9437: = nvl(p_time_start, hr_api.g_varchar2)
9438: and nvl(per_abs_shd.g_old_rec.time_end, hr_api.g_varchar2)
9439: = nvl(p_time_end, hr_api.g_varchar2)
9440: and nvl(per_abs_shd.g_old_rec.absence_days, hr_api.g_number)
9441: = nvl(p_absence_days, hr_api.g_number)

Line 9438: and nvl(per_abs_shd.g_old_rec.time_end, hr_api.g_varchar2)

9434: and nvl(per_abs_shd.g_old_rec.date_end, hr_api.g_date)
9435: = nvl(p_date_end, hr_api.g_date)
9436: and nvl(per_abs_shd.g_old_rec.time_start, hr_api.g_varchar2)
9437: = nvl(p_time_start, hr_api.g_varchar2)
9438: and nvl(per_abs_shd.g_old_rec.time_end, hr_api.g_varchar2)
9439: = nvl(p_time_end, hr_api.g_varchar2)
9440: and nvl(per_abs_shd.g_old_rec.absence_days, hr_api.g_number)
9441: = nvl(p_absence_days, hr_api.g_number)
9442: and nvl(per_abs_shd.g_old_rec.absence_hours, hr_api.g_number)

Line 9439: = nvl(p_time_end, hr_api.g_varchar2)

9435: = nvl(p_date_end, hr_api.g_date)
9436: and nvl(per_abs_shd.g_old_rec.time_start, hr_api.g_varchar2)
9437: = nvl(p_time_start, hr_api.g_varchar2)
9438: and nvl(per_abs_shd.g_old_rec.time_end, hr_api.g_varchar2)
9439: = nvl(p_time_end, hr_api.g_varchar2)
9440: and nvl(per_abs_shd.g_old_rec.absence_days, hr_api.g_number)
9441: = nvl(p_absence_days, hr_api.g_number)
9442: and nvl(per_abs_shd.g_old_rec.absence_hours, hr_api.g_number)
9443: = nvl(p_absence_hours, hr_api.g_number)) then

Line 9440: and nvl(per_abs_shd.g_old_rec.absence_days, hr_api.g_number)

9436: and nvl(per_abs_shd.g_old_rec.time_start, hr_api.g_varchar2)
9437: = nvl(p_time_start, hr_api.g_varchar2)
9438: and nvl(per_abs_shd.g_old_rec.time_end, hr_api.g_varchar2)
9439: = nvl(p_time_end, hr_api.g_varchar2)
9440: and nvl(per_abs_shd.g_old_rec.absence_days, hr_api.g_number)
9441: = nvl(p_absence_days, hr_api.g_number)
9442: and nvl(per_abs_shd.g_old_rec.absence_hours, hr_api.g_number)
9443: = nvl(p_absence_hours, hr_api.g_number)) then
9444: return;

Line 9441: = nvl(p_absence_days, hr_api.g_number)

9437: = nvl(p_time_start, hr_api.g_varchar2)
9438: and nvl(per_abs_shd.g_old_rec.time_end, hr_api.g_varchar2)
9439: = nvl(p_time_end, hr_api.g_varchar2)
9440: and nvl(per_abs_shd.g_old_rec.absence_days, hr_api.g_number)
9441: = nvl(p_absence_days, hr_api.g_number)
9442: and nvl(per_abs_shd.g_old_rec.absence_hours, hr_api.g_number)
9443: = nvl(p_absence_hours, hr_api.g_number)) then
9444: return;
9445: end if;

Line 9442: and nvl(per_abs_shd.g_old_rec.absence_hours, hr_api.g_number)

9438: and nvl(per_abs_shd.g_old_rec.time_end, hr_api.g_varchar2)
9439: = nvl(p_time_end, hr_api.g_varchar2)
9440: and nvl(per_abs_shd.g_old_rec.absence_days, hr_api.g_number)
9441: = nvl(p_absence_days, hr_api.g_number)
9442: and nvl(per_abs_shd.g_old_rec.absence_hours, hr_api.g_number)
9443: = nvl(p_absence_hours, hr_api.g_number)) then
9444: return;
9445: end if;
9446:

Line 9443: = nvl(p_absence_hours, hr_api.g_number)) then

9439: = nvl(p_time_end, hr_api.g_varchar2)
9440: and nvl(per_abs_shd.g_old_rec.absence_days, hr_api.g_number)
9441: = nvl(p_absence_days, hr_api.g_number)
9442: and nvl(per_abs_shd.g_old_rec.absence_hours, hr_api.g_number)
9443: = nvl(p_absence_hours, hr_api.g_number)) then
9444: return;
9445: end if;
9446:
9447: */

Line 9473: l_legislation_code := hr_api.return_legislation_code

9469: l_assignment_id := hr_person_absence_api.get_primary_assignment
9470: (p_person_id => p_person_id
9471: ,p_effective_date => p_effective_date);
9472:
9473: l_legislation_code := hr_api.return_legislation_code
9474: (p_business_group_id => p_business_group_id);
9475:
9476: open c_get_absence_info;
9477: fetch c_get_absence_info into l_hours_or_days,

Line 10067: FROM hr_api_transaction_values tv

10063: ,p_time_end IN VARCHAR2
10064: ) IS
10065:
10066: SELECT null
10067: FROM hr_api_transaction_values tv
10068: ,hr_api_transaction_steps ts
10069: ,hr_api_transaction_values tv1
10070: ,hr_api_transaction_values tv2
10071: ,hr_api_transaction_values tv3

Line 10068: ,hr_api_transaction_steps ts

10064: ) IS
10065:
10066: SELECT null
10067: FROM hr_api_transaction_values tv
10068: ,hr_api_transaction_steps ts
10069: ,hr_api_transaction_values tv1
10070: ,hr_api_transaction_values tv2
10071: ,hr_api_transaction_values tv3
10072: ,hr_api_transaction_values tv4

Line 10069: ,hr_api_transaction_values tv1

10065:
10066: SELECT null
10067: FROM hr_api_transaction_values tv
10068: ,hr_api_transaction_steps ts
10069: ,hr_api_transaction_values tv1
10070: ,hr_api_transaction_values tv2
10071: ,hr_api_transaction_values tv3
10072: ,hr_api_transaction_values tv4
10073: ,hr_api_transaction_values tv5

Line 10070: ,hr_api_transaction_values tv2

10066: SELECT null
10067: FROM hr_api_transaction_values tv
10068: ,hr_api_transaction_steps ts
10069: ,hr_api_transaction_values tv1
10070: ,hr_api_transaction_values tv2
10071: ,hr_api_transaction_values tv3
10072: ,hr_api_transaction_values tv4
10073: ,hr_api_transaction_values tv5
10074: ,hr_api_transaction_values tv6

Line 10071: ,hr_api_transaction_values tv3

10067: FROM hr_api_transaction_values tv
10068: ,hr_api_transaction_steps ts
10069: ,hr_api_transaction_values tv1
10070: ,hr_api_transaction_values tv2
10071: ,hr_api_transaction_values tv3
10072: ,hr_api_transaction_values tv4
10073: ,hr_api_transaction_values tv5
10074: ,hr_api_transaction_values tv6
10075: ,hr_api_transactions hat -- Fix 3191531

Line 10072: ,hr_api_transaction_values tv4

10068: ,hr_api_transaction_steps ts
10069: ,hr_api_transaction_values tv1
10070: ,hr_api_transaction_values tv2
10071: ,hr_api_transaction_values tv3
10072: ,hr_api_transaction_values tv4
10073: ,hr_api_transaction_values tv5
10074: ,hr_api_transaction_values tv6
10075: ,hr_api_transactions hat -- Fix 3191531
10076: WHERE

Line 10073: ,hr_api_transaction_values tv5

10069: ,hr_api_transaction_values tv1
10070: ,hr_api_transaction_values tv2
10071: ,hr_api_transaction_values tv3
10072: ,hr_api_transaction_values tv4
10073: ,hr_api_transaction_values tv5
10074: ,hr_api_transaction_values tv6
10075: ,hr_api_transactions hat -- Fix 3191531
10076: WHERE
10077: ts.api_name = 'HR_LOA_SS.PROCESS_API'

Line 10074: ,hr_api_transaction_values tv6

10070: ,hr_api_transaction_values tv2
10071: ,hr_api_transaction_values tv3
10072: ,hr_api_transaction_values tv4
10073: ,hr_api_transaction_values tv5
10074: ,hr_api_transaction_values tv6
10075: ,hr_api_transactions hat -- Fix 3191531
10076: WHERE
10077: ts.api_name = 'HR_LOA_SS.PROCESS_API'
10078: and ts.UPDATE_PERSON_ID = p_person_id

Line 10075: ,hr_api_transactions hat -- Fix 3191531

10071: ,hr_api_transaction_values tv3
10072: ,hr_api_transaction_values tv4
10073: ,hr_api_transaction_values tv5
10074: ,hr_api_transaction_values tv6
10075: ,hr_api_transactions hat -- Fix 3191531
10076: WHERE
10077: ts.api_name = 'HR_LOA_SS.PROCESS_API'
10078: and ts.UPDATE_PERSON_ID = p_person_id
10079: and p_date_start IS NOT NULL

Line 10102: 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)

10098: and tv3.date_value is NOT NULL
10099: and tv4.date_value is NOT NULL
10100: and (
10101: (
10102: 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)
10103: BETWEEN to_date (to_char(p_date_start, g_usr_date_fmt)||' ' || nvl(p_time_start,'00:00'),g_usr_day_time_fmt)
10104: AND to_date(to_char(p_date_end, g_usr_date_fmt) || ' '|| nvl(p_time_end,'00:00') , g_usr_day_time_fmt)
10105: )
10106: or

Line 10110: 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)

10106: or
10107: (
10108: to_date (to_char(p_date_start, g_usr_date_fmt) ||' ' || nvl(p_time_start,'00:00'),g_usr_day_time_fmt)
10109: BETWEEN
10110: 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)
10111: AND
10112: 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)
10113: )
10114:

Line 10112: 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)

10108: to_date (to_char(p_date_start, g_usr_date_fmt) ||' ' || nvl(p_time_start,'00:00'),g_usr_day_time_fmt)
10109: BETWEEN
10110: 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)
10111: AND
10112: 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)
10113: )
10114:
10115: );
10116: --