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.PER_ABS_BUS dependencies on HR_API

Line 412: between pos.date_start and nvl(pos.actual_termination_date,hr_api.g_eot))

408: and ((nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'), 'N') = 'N' and
409: ppf.business_group_id = p_business_group_id)
410: or nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'), 'N') = 'Y')
411: and (p_date_projected_start is null or p_date_projected_start
412: between pos.date_start and nvl(pos.actual_termination_date,hr_api.g_eot))
413: and (p_date_projected_end is null or p_date_projected_end
414: between pos.date_start and nvl(pos.actual_termination_date,hr_api.g_eot))
415: and (p_date_start is null or p_date_start
416: between pos.date_start and nvl(pos.actual_termination_date,hr_api.g_eot))

Line 414: between pos.date_start and nvl(pos.actual_termination_date,hr_api.g_eot))

410: or nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'), 'N') = 'Y')
411: and (p_date_projected_start is null or p_date_projected_start
412: between pos.date_start and nvl(pos.actual_termination_date,hr_api.g_eot))
413: and (p_date_projected_end is null or p_date_projected_end
414: between pos.date_start and nvl(pos.actual_termination_date,hr_api.g_eot))
415: and (p_date_start is null or p_date_start
416: between pos.date_start and nvl(pos.actual_termination_date,hr_api.g_eot))
417: and (p_date_end is null or p_date_end
418: between pos.date_start and nvl(pos.actual_termination_date,hr_api.g_eot))

Line 416: between pos.date_start and nvl(pos.actual_termination_date,hr_api.g_eot))

412: between pos.date_start and nvl(pos.actual_termination_date,hr_api.g_eot))
413: and (p_date_projected_end is null or p_date_projected_end
414: between pos.date_start and nvl(pos.actual_termination_date,hr_api.g_eot))
415: and (p_date_start is null or p_date_start
416: between pos.date_start and nvl(pos.actual_termination_date,hr_api.g_eot))
417: and (p_date_end is null or p_date_end
418: between pos.date_start and nvl(pos.actual_termination_date,hr_api.g_eot))
419: union select null
420: from per_all_people_f ppf,

Line 418: between pos.date_start and nvl(pos.actual_termination_date,hr_api.g_eot))

414: between pos.date_start and nvl(pos.actual_termination_date,hr_api.g_eot))
415: and (p_date_start is null or p_date_start
416: between pos.date_start and nvl(pos.actual_termination_date,hr_api.g_eot))
417: and (p_date_end is null or p_date_end
418: between pos.date_start and nvl(pos.actual_termination_date,hr_api.g_eot))
419: union select null
420: from per_all_people_f ppf,
421: per_periods_of_placement pop,
422: per_all_workforce_v pawv

Line 431: between pop.date_start and nvl(pop.actual_termination_date,hr_api.g_eot))

427: and ((nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'), 'N') = 'N' and
428: ppf.business_group_id = p_business_group_id)
429: or nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'), 'N') = 'Y')
430: and (p_date_projected_start is null or p_date_projected_start
431: between pop.date_start and nvl(pop.actual_termination_date,hr_api.g_eot))
432: and (p_date_projected_end is null or p_date_projected_end
433: between pop.date_start and nvl(pop.actual_termination_date,hr_api.g_eot))
434: and (p_date_start is null or p_date_start
435: between pop.date_start and nvl(pop.actual_termination_date,hr_api.g_eot))

Line 433: between pop.date_start and nvl(pop.actual_termination_date,hr_api.g_eot))

429: or nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'), 'N') = 'Y')
430: and (p_date_projected_start is null or p_date_projected_start
431: between pop.date_start and nvl(pop.actual_termination_date,hr_api.g_eot))
432: and (p_date_projected_end is null or p_date_projected_end
433: between pop.date_start and nvl(pop.actual_termination_date,hr_api.g_eot))
434: and (p_date_start is null or p_date_start
435: between pop.date_start and nvl(pop.actual_termination_date,hr_api.g_eot))
436: and (p_date_end is null or p_date_end
437: between pop.date_start and nvl(pop.actual_termination_date,hr_api.g_eot));

Line 435: between pop.date_start and nvl(pop.actual_termination_date,hr_api.g_eot))

431: between pop.date_start and nvl(pop.actual_termination_date,hr_api.g_eot))
432: and (p_date_projected_end is null or p_date_projected_end
433: between pop.date_start and nvl(pop.actual_termination_date,hr_api.g_eot))
434: and (p_date_start is null or p_date_start
435: between pop.date_start and nvl(pop.actual_termination_date,hr_api.g_eot))
436: and (p_date_end is null or p_date_end
437: between pop.date_start and nvl(pop.actual_termination_date,hr_api.g_eot));
438:
439: --

Line 437: between pop.date_start and nvl(pop.actual_termination_date,hr_api.g_eot));

433: between pop.date_start and nvl(pop.actual_termination_date,hr_api.g_eot))
434: and (p_date_start is null or p_date_start
435: between pop.date_start and nvl(pop.actual_termination_date,hr_api.g_eot))
436: and (p_date_end is null or p_date_end
437: between pop.date_start and nvl(pop.actual_termination_date,hr_api.g_eot));
438:
439: --
440: l_proc varchar2(72) := g_package||'per_valid_for_absence';
441: l_exists varchar2(1);

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

986: (p_absence_attendance_id => p_absence_attendance_id
987: ,p_object_version_number => p_object_version_number);
988: --
989: if (l_api_updating
990: and nvl(per_abs_shd.g_old_rec.date_start, hr_api.g_date)
991: = nvl(p_date_start, hr_api.g_date)
992: and nvl(per_abs_shd.g_old_rec.date_end, hr_api.g_date)
993: = nvl(p_date_end, hr_api.g_date)
994: and nvl(per_abs_shd.g_old_rec.time_start, hr_api.g_varchar2)

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

987: ,p_object_version_number => p_object_version_number);
988: --
989: if (l_api_updating
990: and nvl(per_abs_shd.g_old_rec.date_start, hr_api.g_date)
991: = nvl(p_date_start, hr_api.g_date)
992: and nvl(per_abs_shd.g_old_rec.date_end, hr_api.g_date)
993: = nvl(p_date_end, hr_api.g_date)
994: and nvl(per_abs_shd.g_old_rec.time_start, hr_api.g_varchar2)
995: = nvl(p_time_start, hr_api.g_varchar2)

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

988: --
989: if (l_api_updating
990: and nvl(per_abs_shd.g_old_rec.date_start, hr_api.g_date)
991: = nvl(p_date_start, hr_api.g_date)
992: and nvl(per_abs_shd.g_old_rec.date_end, hr_api.g_date)
993: = nvl(p_date_end, hr_api.g_date)
994: and nvl(per_abs_shd.g_old_rec.time_start, hr_api.g_varchar2)
995: = nvl(p_time_start, hr_api.g_varchar2)
996: and nvl(per_abs_shd.g_old_rec.time_end, hr_api.g_varchar2)

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

989: if (l_api_updating
990: and nvl(per_abs_shd.g_old_rec.date_start, hr_api.g_date)
991: = nvl(p_date_start, hr_api.g_date)
992: and nvl(per_abs_shd.g_old_rec.date_end, hr_api.g_date)
993: = nvl(p_date_end, hr_api.g_date)
994: and nvl(per_abs_shd.g_old_rec.time_start, hr_api.g_varchar2)
995: = nvl(p_time_start, hr_api.g_varchar2)
996: and nvl(per_abs_shd.g_old_rec.time_end, hr_api.g_varchar2)
997: = nvl(p_time_end, hr_api.g_varchar2)

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

990: and nvl(per_abs_shd.g_old_rec.date_start, hr_api.g_date)
991: = nvl(p_date_start, hr_api.g_date)
992: and nvl(per_abs_shd.g_old_rec.date_end, hr_api.g_date)
993: = nvl(p_date_end, hr_api.g_date)
994: and nvl(per_abs_shd.g_old_rec.time_start, hr_api.g_varchar2)
995: = nvl(p_time_start, hr_api.g_varchar2)
996: and nvl(per_abs_shd.g_old_rec.time_end, hr_api.g_varchar2)
997: = nvl(p_time_end, hr_api.g_varchar2)
998: and nvl(per_abs_shd.g_old_rec.absence_days, hr_api.g_number)

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

991: = nvl(p_date_start, hr_api.g_date)
992: and nvl(per_abs_shd.g_old_rec.date_end, hr_api.g_date)
993: = nvl(p_date_end, hr_api.g_date)
994: and nvl(per_abs_shd.g_old_rec.time_start, hr_api.g_varchar2)
995: = nvl(p_time_start, hr_api.g_varchar2)
996: and nvl(per_abs_shd.g_old_rec.time_end, hr_api.g_varchar2)
997: = nvl(p_time_end, hr_api.g_varchar2)
998: and nvl(per_abs_shd.g_old_rec.absence_days, hr_api.g_number)
999: = nvl(p_absence_days, hr_api.g_number)

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

992: and nvl(per_abs_shd.g_old_rec.date_end, hr_api.g_date)
993: = nvl(p_date_end, hr_api.g_date)
994: and nvl(per_abs_shd.g_old_rec.time_start, hr_api.g_varchar2)
995: = nvl(p_time_start, hr_api.g_varchar2)
996: and nvl(per_abs_shd.g_old_rec.time_end, hr_api.g_varchar2)
997: = nvl(p_time_end, hr_api.g_varchar2)
998: and nvl(per_abs_shd.g_old_rec.absence_days, hr_api.g_number)
999: = nvl(p_absence_days, hr_api.g_number)
1000: and nvl(per_abs_shd.g_old_rec.absence_hours, hr_api.g_number)

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

993: = nvl(p_date_end, hr_api.g_date)
994: and nvl(per_abs_shd.g_old_rec.time_start, hr_api.g_varchar2)
995: = nvl(p_time_start, hr_api.g_varchar2)
996: and nvl(per_abs_shd.g_old_rec.time_end, hr_api.g_varchar2)
997: = nvl(p_time_end, hr_api.g_varchar2)
998: and nvl(per_abs_shd.g_old_rec.absence_days, hr_api.g_number)
999: = nvl(p_absence_days, hr_api.g_number)
1000: and nvl(per_abs_shd.g_old_rec.absence_hours, hr_api.g_number)
1001: = nvl(p_absence_hours, hr_api.g_number)) then

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

994: and nvl(per_abs_shd.g_old_rec.time_start, hr_api.g_varchar2)
995: = nvl(p_time_start, hr_api.g_varchar2)
996: and nvl(per_abs_shd.g_old_rec.time_end, hr_api.g_varchar2)
997: = nvl(p_time_end, hr_api.g_varchar2)
998: and nvl(per_abs_shd.g_old_rec.absence_days, hr_api.g_number)
999: = nvl(p_absence_days, hr_api.g_number)
1000: and nvl(per_abs_shd.g_old_rec.absence_hours, hr_api.g_number)
1001: = nvl(p_absence_hours, hr_api.g_number)) then
1002: return;

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

995: = nvl(p_time_start, hr_api.g_varchar2)
996: and nvl(per_abs_shd.g_old_rec.time_end, hr_api.g_varchar2)
997: = nvl(p_time_end, hr_api.g_varchar2)
998: and nvl(per_abs_shd.g_old_rec.absence_days, hr_api.g_number)
999: = nvl(p_absence_days, hr_api.g_number)
1000: and nvl(per_abs_shd.g_old_rec.absence_hours, hr_api.g_number)
1001: = nvl(p_absence_hours, hr_api.g_number)) then
1002: return;
1003: end if;

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

996: and nvl(per_abs_shd.g_old_rec.time_end, hr_api.g_varchar2)
997: = nvl(p_time_end, hr_api.g_varchar2)
998: and nvl(per_abs_shd.g_old_rec.absence_days, hr_api.g_number)
999: = nvl(p_absence_days, hr_api.g_number)
1000: and nvl(per_abs_shd.g_old_rec.absence_hours, hr_api.g_number)
1001: = nvl(p_absence_hours, hr_api.g_number)) then
1002: return;
1003: end if;
1004:

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

997: = nvl(p_time_end, hr_api.g_varchar2)
998: and nvl(per_abs_shd.g_old_rec.absence_days, hr_api.g_number)
999: = nvl(p_absence_days, hr_api.g_number)
1000: and nvl(per_abs_shd.g_old_rec.absence_hours, hr_api.g_number)
1001: = nvl(p_absence_hours, hr_api.g_number)) then
1002: return;
1003: end if;
1004:
1005: hr_utility.set_location(l_proc, 15);

Line 1026: l_legislation_code := hr_api.return_legislation_code

1022: l_assignment_id := hr_person_absence_api.get_primary_assignment
1023: (p_person_id => p_person_id
1024: ,p_effective_date => p_effective_date);
1025:
1026: l_legislation_code := hr_api.return_legislation_code
1027: (p_business_group_id => p_business_group_id);
1028:
1029: open c_get_absence_info;
1030: fetch c_get_absence_info into l_hours_or_days,

Line 1571: hr_api.mandatory_arg_error

1567: begin
1568:
1569: hr_utility.set_location('Entering:'|| l_proc, 10);
1570: --
1571: hr_api.mandatory_arg_error
1572: (p_api_name => l_proc
1573: ,p_argument => 'p_person_id'
1574: ,p_argument_value => p_person_id
1575: );

Line 1576: hr_api.mandatory_arg_error

1572: (p_api_name => l_proc
1573: ,p_argument => 'p_person_id'
1574: ,p_argument_value => p_person_id
1575: );
1576: hr_api.mandatory_arg_error
1577: (p_api_name => l_proc
1578: ,p_argument => 'p_business_group_id'
1579: ,p_argument_value => p_business_group_id
1580: );

Line 1592: and nvl(per_abs_shd.g_old_rec.date_projected_start, hr_api.g_date)

1588: (p_absence_attendance_id => p_absence_attendance_id
1589: ,p_object_version_number => p_object_version_number);
1590: --
1591: if (l_api_updating
1592: and nvl(per_abs_shd.g_old_rec.date_projected_start, hr_api.g_date)
1593: = nvl(p_date_projected_start, hr_api.g_date)
1594: and nvl(per_abs_shd.g_old_rec.date_projected_end, hr_api.g_date)
1595: = nvl(p_date_projected_end, hr_api.g_date)
1596: and nvl(per_abs_shd.g_old_rec.date_start, hr_api.g_date)

Line 1593: = nvl(p_date_projected_start, hr_api.g_date)

1589: ,p_object_version_number => p_object_version_number);
1590: --
1591: if (l_api_updating
1592: and nvl(per_abs_shd.g_old_rec.date_projected_start, hr_api.g_date)
1593: = nvl(p_date_projected_start, hr_api.g_date)
1594: and nvl(per_abs_shd.g_old_rec.date_projected_end, hr_api.g_date)
1595: = nvl(p_date_projected_end, hr_api.g_date)
1596: and nvl(per_abs_shd.g_old_rec.date_start, hr_api.g_date)
1597: = nvl(p_date_start, hr_api.g_date)

Line 1594: and nvl(per_abs_shd.g_old_rec.date_projected_end, hr_api.g_date)

1590: --
1591: if (l_api_updating
1592: and nvl(per_abs_shd.g_old_rec.date_projected_start, hr_api.g_date)
1593: = nvl(p_date_projected_start, hr_api.g_date)
1594: and nvl(per_abs_shd.g_old_rec.date_projected_end, hr_api.g_date)
1595: = nvl(p_date_projected_end, hr_api.g_date)
1596: and nvl(per_abs_shd.g_old_rec.date_start, hr_api.g_date)
1597: = nvl(p_date_start, hr_api.g_date)
1598: and nvl(per_abs_shd.g_old_rec.date_end, hr_api.g_date)

Line 1595: = nvl(p_date_projected_end, hr_api.g_date)

1591: if (l_api_updating
1592: and nvl(per_abs_shd.g_old_rec.date_projected_start, hr_api.g_date)
1593: = nvl(p_date_projected_start, hr_api.g_date)
1594: and nvl(per_abs_shd.g_old_rec.date_projected_end, hr_api.g_date)
1595: = nvl(p_date_projected_end, hr_api.g_date)
1596: and nvl(per_abs_shd.g_old_rec.date_start, hr_api.g_date)
1597: = nvl(p_date_start, hr_api.g_date)
1598: and nvl(per_abs_shd.g_old_rec.date_end, hr_api.g_date)
1599: = nvl(p_date_end, hr_api.g_date)) then

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

1592: and nvl(per_abs_shd.g_old_rec.date_projected_start, hr_api.g_date)
1593: = nvl(p_date_projected_start, hr_api.g_date)
1594: and nvl(per_abs_shd.g_old_rec.date_projected_end, hr_api.g_date)
1595: = nvl(p_date_projected_end, hr_api.g_date)
1596: and nvl(per_abs_shd.g_old_rec.date_start, hr_api.g_date)
1597: = nvl(p_date_start, hr_api.g_date)
1598: and nvl(per_abs_shd.g_old_rec.date_end, hr_api.g_date)
1599: = nvl(p_date_end, hr_api.g_date)) then
1600: return;

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

1593: = nvl(p_date_projected_start, hr_api.g_date)
1594: and nvl(per_abs_shd.g_old_rec.date_projected_end, hr_api.g_date)
1595: = nvl(p_date_projected_end, hr_api.g_date)
1596: and nvl(per_abs_shd.g_old_rec.date_start, hr_api.g_date)
1597: = nvl(p_date_start, hr_api.g_date)
1598: and nvl(per_abs_shd.g_old_rec.date_end, hr_api.g_date)
1599: = nvl(p_date_end, hr_api.g_date)) then
1600: return;
1601: end if;

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

1594: and nvl(per_abs_shd.g_old_rec.date_projected_end, hr_api.g_date)
1595: = nvl(p_date_projected_end, hr_api.g_date)
1596: and nvl(per_abs_shd.g_old_rec.date_start, hr_api.g_date)
1597: = nvl(p_date_start, hr_api.g_date)
1598: and nvl(per_abs_shd.g_old_rec.date_end, hr_api.g_date)
1599: = nvl(p_date_end, hr_api.g_date)) then
1600: return;
1601: end if;
1602:

Line 1599: = nvl(p_date_end, hr_api.g_date)) then

1595: = nvl(p_date_projected_end, hr_api.g_date)
1596: and nvl(per_abs_shd.g_old_rec.date_start, hr_api.g_date)
1597: = nvl(p_date_start, hr_api.g_date)
1598: and nvl(per_abs_shd.g_old_rec.date_end, hr_api.g_date)
1599: = nvl(p_date_end, hr_api.g_date)) then
1600: return;
1601: end if;
1602:
1603: --

Line 1679: between abt.date_effective and nvl(abt.date_end,hr_api.g_eot))

1675: from per_absence_attendance_types abt
1676: where abt.absence_attendance_type_id = p_absence_attendance_type_id
1677: and abt.business_group_id = p_business_group_id
1678: and (p_date_projected_start is null or p_date_projected_start
1679: between abt.date_effective and nvl(abt.date_end,hr_api.g_eot))
1680: and (p_date_projected_end is null or p_date_projected_end
1681: between abt.date_effective and nvl(abt.date_end,hr_api.g_eot))
1682: and (p_date_start is null or p_date_start
1683: between abt.date_effective and nvl(abt.date_end,hr_api.g_eot))

Line 1681: between abt.date_effective and nvl(abt.date_end,hr_api.g_eot))

1677: and abt.business_group_id = p_business_group_id
1678: and (p_date_projected_start is null or p_date_projected_start
1679: between abt.date_effective and nvl(abt.date_end,hr_api.g_eot))
1680: and (p_date_projected_end is null or p_date_projected_end
1681: between abt.date_effective and nvl(abt.date_end,hr_api.g_eot))
1682: and (p_date_start is null or p_date_start
1683: between abt.date_effective and nvl(abt.date_end,hr_api.g_eot))
1684: and (p_date_end is null or p_date_end
1685: between abt.date_effective and nvl(abt.date_end,hr_api.g_eot));

Line 1683: between abt.date_effective and nvl(abt.date_end,hr_api.g_eot))

1679: between abt.date_effective and nvl(abt.date_end,hr_api.g_eot))
1680: and (p_date_projected_end is null or p_date_projected_end
1681: between abt.date_effective and nvl(abt.date_end,hr_api.g_eot))
1682: and (p_date_start is null or p_date_start
1683: between abt.date_effective and nvl(abt.date_end,hr_api.g_eot))
1684: and (p_date_end is null or p_date_end
1685: between abt.date_effective and nvl(abt.date_end,hr_api.g_eot));
1686:
1687: --

Line 1685: between abt.date_effective and nvl(abt.date_end,hr_api.g_eot));

1681: between abt.date_effective and nvl(abt.date_end,hr_api.g_eot))
1682: and (p_date_start is null or p_date_start
1683: between abt.date_effective and nvl(abt.date_end,hr_api.g_eot))
1684: and (p_date_end is null or p_date_end
1685: between abt.date_effective and nvl(abt.date_end,hr_api.g_eot));
1686:
1687: --
1688: begin
1689:

Line 1695: hr_api.mandatory_arg_error

1691: --
1692: --
1693: -- Check mandatory parameters have been set
1694: --
1695: hr_api.mandatory_arg_error
1696: (p_api_name => l_proc
1697: ,p_argument => 'p_absence_attendance_type_id'
1698: ,p_argument_value => p_absence_attendance_type_id
1699: );

Line 1711: and nvl(per_abs_shd.g_old_rec.date_projected_start, hr_api.g_date)

1707: (p_absence_attendance_id => p_absence_attendance_id
1708: ,p_object_version_number => p_object_version_number);
1709: --
1710: if (l_api_updating
1711: and nvl(per_abs_shd.g_old_rec.date_projected_start, hr_api.g_date)
1712: = nvl(p_date_projected_start, hr_api.g_date)
1713: and nvl(per_abs_shd.g_old_rec.date_projected_end, hr_api.g_date)
1714: = nvl(p_date_projected_end, hr_api.g_date)
1715: and nvl(per_abs_shd.g_old_rec.date_start, hr_api.g_date)

Line 1712: = nvl(p_date_projected_start, hr_api.g_date)

1708: ,p_object_version_number => p_object_version_number);
1709: --
1710: if (l_api_updating
1711: and nvl(per_abs_shd.g_old_rec.date_projected_start, hr_api.g_date)
1712: = nvl(p_date_projected_start, hr_api.g_date)
1713: and nvl(per_abs_shd.g_old_rec.date_projected_end, hr_api.g_date)
1714: = nvl(p_date_projected_end, hr_api.g_date)
1715: and nvl(per_abs_shd.g_old_rec.date_start, hr_api.g_date)
1716: = nvl(p_date_start, hr_api.g_date)

Line 1713: and nvl(per_abs_shd.g_old_rec.date_projected_end, hr_api.g_date)

1709: --
1710: if (l_api_updating
1711: and nvl(per_abs_shd.g_old_rec.date_projected_start, hr_api.g_date)
1712: = nvl(p_date_projected_start, hr_api.g_date)
1713: and nvl(per_abs_shd.g_old_rec.date_projected_end, hr_api.g_date)
1714: = nvl(p_date_projected_end, hr_api.g_date)
1715: and nvl(per_abs_shd.g_old_rec.date_start, hr_api.g_date)
1716: = nvl(p_date_start, hr_api.g_date)
1717: and nvl(per_abs_shd.g_old_rec.date_end, hr_api.g_date)

Line 1714: = nvl(p_date_projected_end, hr_api.g_date)

1710: if (l_api_updating
1711: and nvl(per_abs_shd.g_old_rec.date_projected_start, hr_api.g_date)
1712: = nvl(p_date_projected_start, hr_api.g_date)
1713: and nvl(per_abs_shd.g_old_rec.date_projected_end, hr_api.g_date)
1714: = nvl(p_date_projected_end, hr_api.g_date)
1715: and nvl(per_abs_shd.g_old_rec.date_start, hr_api.g_date)
1716: = nvl(p_date_start, hr_api.g_date)
1717: and nvl(per_abs_shd.g_old_rec.date_end, hr_api.g_date)
1718: = nvl(p_date_end, hr_api.g_date)) then

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

1711: and nvl(per_abs_shd.g_old_rec.date_projected_start, hr_api.g_date)
1712: = nvl(p_date_projected_start, hr_api.g_date)
1713: and nvl(per_abs_shd.g_old_rec.date_projected_end, hr_api.g_date)
1714: = nvl(p_date_projected_end, hr_api.g_date)
1715: and nvl(per_abs_shd.g_old_rec.date_start, hr_api.g_date)
1716: = nvl(p_date_start, hr_api.g_date)
1717: and nvl(per_abs_shd.g_old_rec.date_end, hr_api.g_date)
1718: = nvl(p_date_end, hr_api.g_date)) then
1719: return;

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

1712: = nvl(p_date_projected_start, hr_api.g_date)
1713: and nvl(per_abs_shd.g_old_rec.date_projected_end, hr_api.g_date)
1714: = nvl(p_date_projected_end, hr_api.g_date)
1715: and nvl(per_abs_shd.g_old_rec.date_start, hr_api.g_date)
1716: = nvl(p_date_start, hr_api.g_date)
1717: and nvl(per_abs_shd.g_old_rec.date_end, hr_api.g_date)
1718: = nvl(p_date_end, hr_api.g_date)) then
1719: return;
1720: end if;

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

1713: and nvl(per_abs_shd.g_old_rec.date_projected_end, hr_api.g_date)
1714: = nvl(p_date_projected_end, hr_api.g_date)
1715: and nvl(per_abs_shd.g_old_rec.date_start, hr_api.g_date)
1716: = nvl(p_date_start, hr_api.g_date)
1717: and nvl(per_abs_shd.g_old_rec.date_end, hr_api.g_date)
1718: = nvl(p_date_end, hr_api.g_date)) then
1719: return;
1720: end if;
1721:

Line 1718: = nvl(p_date_end, hr_api.g_date)) then

1714: = nvl(p_date_projected_end, hr_api.g_date)
1715: and nvl(per_abs_shd.g_old_rec.date_start, hr_api.g_date)
1716: = nvl(p_date_start, hr_api.g_date)
1717: and nvl(per_abs_shd.g_old_rec.date_end, hr_api.g_date)
1718: = nvl(p_date_end, hr_api.g_date)) then
1719: return;
1720: end if;
1721:
1722: hr_utility.set_location(l_proc, 15);

Line 1804: nvl(hrl.start_date_active,hr_api.g_sot)

1800: and abr.abs_attendance_reason_id = p_abs_attendance_reason_id
1801: and abr.name = hrl.lookup_code
1802: and hrl.lookup_type = 'ABSENCE_REASON'
1803: and p_effective_date between
1804: nvl(hrl.start_date_active,hr_api.g_sot)
1805: and nvl(hrl.end_date_active,hr_api.g_eot)
1806: and hrl.enabled_flag = 'Y';
1807: --
1808: begin

Line 1805: and nvl(hrl.end_date_active,hr_api.g_eot)

1801: and abr.name = hrl.lookup_code
1802: and hrl.lookup_type = 'ABSENCE_REASON'
1803: and p_effective_date between
1804: nvl(hrl.start_date_active,hr_api.g_sot)
1805: and nvl(hrl.end_date_active,hr_api.g_eot)
1806: and hrl.enabled_flag = 'Y';
1807: --
1808: begin
1809:

Line 1826: hr_api.g_number) = nvl(p_abs_attendance_reason_id, hr_api.g_number)) then

1822: (p_absence_attendance_id => p_absence_attendance_id
1823: ,p_object_version_number => p_object_version_number);
1824: --
1825: if (l_api_updating and nvl(per_abs_shd.g_old_rec.abs_attendance_reason_id,
1826: hr_api.g_number) = nvl(p_abs_attendance_reason_id, hr_api.g_number)) then
1827: return;
1828: end if;
1829:
1830: open csr_valid_abs_reason;

Line 1930: to_date(to_char(nvl(abs.date_start,hr_api.g_eot),'YYYY-MM-DD')|| ' ' || -- Bug 4163165

1926: p_absence_attendance_id <> abs.absence_attendance_id)
1927: and abs.date_start is not null
1928: and p_date_start is not null
1929: and ((
1930: to_date(to_char(nvl(abs.date_start,hr_api.g_eot),'YYYY-MM-DD')|| ' ' || -- Bug 4163165
1931: nvl(abs.time_start,'00:00'),'YYYY-MM-DD HH24:MI:SS')
1932: between
1933: to_date(to_char(nvl(p_date_start,hr_api.g_eot),'YYYY-MM-DD')|| ' ' ||
1934: nvl(p_time_start,'00:00'),'YYYY-MM-DD HH24:MI:SS')

Line 1933: to_date(to_char(nvl(p_date_start,hr_api.g_eot),'YYYY-MM-DD')|| ' ' ||

1929: and ((
1930: to_date(to_char(nvl(abs.date_start,hr_api.g_eot),'YYYY-MM-DD')|| ' ' || -- Bug 4163165
1931: nvl(abs.time_start,'00:00'),'YYYY-MM-DD HH24:MI:SS')
1932: between
1933: to_date(to_char(nvl(p_date_start,hr_api.g_eot),'YYYY-MM-DD')|| ' ' ||
1934: nvl(p_time_start,'00:00'),'YYYY-MM-DD HH24:MI:SS')
1935: AND
1936: to_date(to_char(nvl(p_date_end,hr_api.g_eot),'YYYY-MM-DD')|| ' ' ||
1937: nvl(p_time_end,'23:59'),'YYYY-MM-DD HH24:MI:SS')) OR

Line 1936: to_date(to_char(nvl(p_date_end,hr_api.g_eot),'YYYY-MM-DD')|| ' ' ||

1932: between
1933: to_date(to_char(nvl(p_date_start,hr_api.g_eot),'YYYY-MM-DD')|| ' ' ||
1934: nvl(p_time_start,'00:00'),'YYYY-MM-DD HH24:MI:SS')
1935: AND
1936: to_date(to_char(nvl(p_date_end,hr_api.g_eot),'YYYY-MM-DD')|| ' ' ||
1937: nvl(p_time_end,'23:59'),'YYYY-MM-DD HH24:MI:SS')) OR
1938: (
1939: to_date(to_char(nvl(p_date_start,hr_api.g_eot),'YYYY-MM-DD')|| ' ' ||
1940: nvl(p_time_start,'00:00'),'YYYY-MM-DD HH24:MI:SS')

Line 1939: to_date(to_char(nvl(p_date_start,hr_api.g_eot),'YYYY-MM-DD')|| ' ' ||

1935: AND
1936: to_date(to_char(nvl(p_date_end,hr_api.g_eot),'YYYY-MM-DD')|| ' ' ||
1937: nvl(p_time_end,'23:59'),'YYYY-MM-DD HH24:MI:SS')) OR
1938: (
1939: to_date(to_char(nvl(p_date_start,hr_api.g_eot),'YYYY-MM-DD')|| ' ' ||
1940: nvl(p_time_start,'00:00'),'YYYY-MM-DD HH24:MI:SS')
1941: between
1942: to_date(to_char(nvl(abs.date_start,hr_api.g_eot),'YYYY-MM-DD')|| ' ' ||
1943: nvl(abs.time_start,'00:00'),'YYYY-MM-DD HH24:MI:SS')

Line 1942: to_date(to_char(nvl(abs.date_start,hr_api.g_eot),'YYYY-MM-DD')|| ' ' ||

1938: (
1939: to_date(to_char(nvl(p_date_start,hr_api.g_eot),'YYYY-MM-DD')|| ' ' ||
1940: nvl(p_time_start,'00:00'),'YYYY-MM-DD HH24:MI:SS')
1941: between
1942: to_date(to_char(nvl(abs.date_start,hr_api.g_eot),'YYYY-MM-DD')|| ' ' ||
1943: nvl(abs.time_start,'00:00'),'YYYY-MM-DD HH24:MI:SS')
1944: AND
1945: to_date(to_char(nvl(abs.date_end,hr_api.g_eot),'YYYY-MM-DD')|| ' ' ||
1946: nvl(abs.time_end,'23:59'),'YYYY-MM-DD HH24:MI:SS')

Line 1945: to_date(to_char(nvl(abs.date_end,hr_api.g_eot),'YYYY-MM-DD')|| ' ' ||

1941: between
1942: to_date(to_char(nvl(abs.date_start,hr_api.g_eot),'YYYY-MM-DD')|| ' ' ||
1943: nvl(abs.time_start,'00:00'),'YYYY-MM-DD HH24:MI:SS')
1944: AND
1945: to_date(to_char(nvl(abs.date_end,hr_api.g_eot),'YYYY-MM-DD')|| ' ' ||
1946: nvl(abs.time_end,'23:59'),'YYYY-MM-DD HH24:MI:SS')
1947: ));
1948:
1949: cursor c_abs_day_after_another is

Line 2040: and nvl(per_abs_shd.g_old_rec.date_projected_start, hr_api.g_date)

2036: (p_absence_attendance_id => p_absence_attendance_id
2037: ,p_object_version_number => p_object_version_number);
2038: --
2039: if (l_api_updating
2040: and nvl(per_abs_shd.g_old_rec.date_projected_start, hr_api.g_date)
2041: = nvl(p_date_projected_start, hr_api.g_date)
2042: and nvl(per_abs_shd.g_old_rec.time_projected_start, hr_api.g_varchar2)
2043: = nvl(p_time_projected_start, hr_api.g_varchar2)
2044: and nvl(per_abs_shd.g_old_rec.date_projected_end, hr_api.g_date)

Line 2041: = nvl(p_date_projected_start, hr_api.g_date)

2037: ,p_object_version_number => p_object_version_number);
2038: --
2039: if (l_api_updating
2040: and nvl(per_abs_shd.g_old_rec.date_projected_start, hr_api.g_date)
2041: = nvl(p_date_projected_start, hr_api.g_date)
2042: and nvl(per_abs_shd.g_old_rec.time_projected_start, hr_api.g_varchar2)
2043: = nvl(p_time_projected_start, hr_api.g_varchar2)
2044: and nvl(per_abs_shd.g_old_rec.date_projected_end, hr_api.g_date)
2045: = nvl(p_date_projected_end, hr_api.g_date)

Line 2042: and nvl(per_abs_shd.g_old_rec.time_projected_start, hr_api.g_varchar2)

2038: --
2039: if (l_api_updating
2040: and nvl(per_abs_shd.g_old_rec.date_projected_start, hr_api.g_date)
2041: = nvl(p_date_projected_start, hr_api.g_date)
2042: and nvl(per_abs_shd.g_old_rec.time_projected_start, hr_api.g_varchar2)
2043: = nvl(p_time_projected_start, hr_api.g_varchar2)
2044: and nvl(per_abs_shd.g_old_rec.date_projected_end, hr_api.g_date)
2045: = nvl(p_date_projected_end, hr_api.g_date)
2046: and nvl(per_abs_shd.g_old_rec.time_projected_end, hr_api.g_varchar2)

Line 2043: = nvl(p_time_projected_start, hr_api.g_varchar2)

2039: if (l_api_updating
2040: and nvl(per_abs_shd.g_old_rec.date_projected_start, hr_api.g_date)
2041: = nvl(p_date_projected_start, hr_api.g_date)
2042: and nvl(per_abs_shd.g_old_rec.time_projected_start, hr_api.g_varchar2)
2043: = nvl(p_time_projected_start, hr_api.g_varchar2)
2044: and nvl(per_abs_shd.g_old_rec.date_projected_end, hr_api.g_date)
2045: = nvl(p_date_projected_end, hr_api.g_date)
2046: and nvl(per_abs_shd.g_old_rec.time_projected_end, hr_api.g_varchar2)
2047: = nvl(p_time_projected_end, hr_api.g_varchar2)

Line 2044: and nvl(per_abs_shd.g_old_rec.date_projected_end, hr_api.g_date)

2040: and nvl(per_abs_shd.g_old_rec.date_projected_start, hr_api.g_date)
2041: = nvl(p_date_projected_start, hr_api.g_date)
2042: and nvl(per_abs_shd.g_old_rec.time_projected_start, hr_api.g_varchar2)
2043: = nvl(p_time_projected_start, hr_api.g_varchar2)
2044: and nvl(per_abs_shd.g_old_rec.date_projected_end, hr_api.g_date)
2045: = nvl(p_date_projected_end, hr_api.g_date)
2046: and nvl(per_abs_shd.g_old_rec.time_projected_end, hr_api.g_varchar2)
2047: = nvl(p_time_projected_end, hr_api.g_varchar2)
2048: and nvl(per_abs_shd.g_old_rec.date_start, hr_api.g_date)

Line 2045: = nvl(p_date_projected_end, hr_api.g_date)

2041: = nvl(p_date_projected_start, hr_api.g_date)
2042: and nvl(per_abs_shd.g_old_rec.time_projected_start, hr_api.g_varchar2)
2043: = nvl(p_time_projected_start, hr_api.g_varchar2)
2044: and nvl(per_abs_shd.g_old_rec.date_projected_end, hr_api.g_date)
2045: = nvl(p_date_projected_end, hr_api.g_date)
2046: and nvl(per_abs_shd.g_old_rec.time_projected_end, hr_api.g_varchar2)
2047: = nvl(p_time_projected_end, hr_api.g_varchar2)
2048: and nvl(per_abs_shd.g_old_rec.date_start, hr_api.g_date)
2049: = nvl(p_date_start, hr_api.g_date)

Line 2046: and nvl(per_abs_shd.g_old_rec.time_projected_end, hr_api.g_varchar2)

2042: and nvl(per_abs_shd.g_old_rec.time_projected_start, hr_api.g_varchar2)
2043: = nvl(p_time_projected_start, hr_api.g_varchar2)
2044: and nvl(per_abs_shd.g_old_rec.date_projected_end, hr_api.g_date)
2045: = nvl(p_date_projected_end, hr_api.g_date)
2046: and nvl(per_abs_shd.g_old_rec.time_projected_end, hr_api.g_varchar2)
2047: = nvl(p_time_projected_end, hr_api.g_varchar2)
2048: and nvl(per_abs_shd.g_old_rec.date_start, hr_api.g_date)
2049: = nvl(p_date_start, hr_api.g_date)
2050: and nvl(per_abs_shd.g_old_rec.time_start, hr_api.g_varchar2)

Line 2047: = nvl(p_time_projected_end, hr_api.g_varchar2)

2043: = nvl(p_time_projected_start, hr_api.g_varchar2)
2044: and nvl(per_abs_shd.g_old_rec.date_projected_end, hr_api.g_date)
2045: = nvl(p_date_projected_end, hr_api.g_date)
2046: and nvl(per_abs_shd.g_old_rec.time_projected_end, hr_api.g_varchar2)
2047: = nvl(p_time_projected_end, hr_api.g_varchar2)
2048: and nvl(per_abs_shd.g_old_rec.date_start, hr_api.g_date)
2049: = nvl(p_date_start, hr_api.g_date)
2050: and nvl(per_abs_shd.g_old_rec.time_start, hr_api.g_varchar2)
2051: = nvl(p_time_start, hr_api.g_varchar2)

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

2044: and nvl(per_abs_shd.g_old_rec.date_projected_end, hr_api.g_date)
2045: = nvl(p_date_projected_end, hr_api.g_date)
2046: and nvl(per_abs_shd.g_old_rec.time_projected_end, hr_api.g_varchar2)
2047: = nvl(p_time_projected_end, hr_api.g_varchar2)
2048: and nvl(per_abs_shd.g_old_rec.date_start, hr_api.g_date)
2049: = nvl(p_date_start, hr_api.g_date)
2050: and nvl(per_abs_shd.g_old_rec.time_start, hr_api.g_varchar2)
2051: = nvl(p_time_start, hr_api.g_varchar2)
2052: and nvl(per_abs_shd.g_old_rec.date_end, hr_api.g_date)

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

2045: = nvl(p_date_projected_end, hr_api.g_date)
2046: and nvl(per_abs_shd.g_old_rec.time_projected_end, hr_api.g_varchar2)
2047: = nvl(p_time_projected_end, hr_api.g_varchar2)
2048: and nvl(per_abs_shd.g_old_rec.date_start, hr_api.g_date)
2049: = nvl(p_date_start, hr_api.g_date)
2050: and nvl(per_abs_shd.g_old_rec.time_start, hr_api.g_varchar2)
2051: = nvl(p_time_start, hr_api.g_varchar2)
2052: and nvl(per_abs_shd.g_old_rec.date_end, hr_api.g_date)
2053: = nvl(p_date_end, hr_api.g_date)

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

2046: and nvl(per_abs_shd.g_old_rec.time_projected_end, hr_api.g_varchar2)
2047: = nvl(p_time_projected_end, hr_api.g_varchar2)
2048: and nvl(per_abs_shd.g_old_rec.date_start, hr_api.g_date)
2049: = nvl(p_date_start, hr_api.g_date)
2050: and nvl(per_abs_shd.g_old_rec.time_start, hr_api.g_varchar2)
2051: = nvl(p_time_start, hr_api.g_varchar2)
2052: and nvl(per_abs_shd.g_old_rec.date_end, hr_api.g_date)
2053: = nvl(p_date_end, hr_api.g_date)
2054: and nvl(per_abs_shd.g_old_rec.time_end, hr_api.g_varchar2)

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

2047: = nvl(p_time_projected_end, hr_api.g_varchar2)
2048: and nvl(per_abs_shd.g_old_rec.date_start, hr_api.g_date)
2049: = nvl(p_date_start, hr_api.g_date)
2050: and nvl(per_abs_shd.g_old_rec.time_start, hr_api.g_varchar2)
2051: = nvl(p_time_start, hr_api.g_varchar2)
2052: and nvl(per_abs_shd.g_old_rec.date_end, hr_api.g_date)
2053: = nvl(p_date_end, hr_api.g_date)
2054: and nvl(per_abs_shd.g_old_rec.time_end, hr_api.g_varchar2)
2055: = nvl(p_time_end, hr_api.g_varchar2)

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

2048: and nvl(per_abs_shd.g_old_rec.date_start, hr_api.g_date)
2049: = nvl(p_date_start, hr_api.g_date)
2050: and nvl(per_abs_shd.g_old_rec.time_start, hr_api.g_varchar2)
2051: = nvl(p_time_start, hr_api.g_varchar2)
2052: and nvl(per_abs_shd.g_old_rec.date_end, hr_api.g_date)
2053: = nvl(p_date_end, hr_api.g_date)
2054: and nvl(per_abs_shd.g_old_rec.time_end, hr_api.g_varchar2)
2055: = nvl(p_time_end, hr_api.g_varchar2)
2056: and nvl(per_abs_shd.g_old_rec.absence_days, hr_api.g_number)

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

2049: = nvl(p_date_start, hr_api.g_date)
2050: and nvl(per_abs_shd.g_old_rec.time_start, hr_api.g_varchar2)
2051: = nvl(p_time_start, hr_api.g_varchar2)
2052: and nvl(per_abs_shd.g_old_rec.date_end, hr_api.g_date)
2053: = nvl(p_date_end, hr_api.g_date)
2054: and nvl(per_abs_shd.g_old_rec.time_end, hr_api.g_varchar2)
2055: = nvl(p_time_end, hr_api.g_varchar2)
2056: and nvl(per_abs_shd.g_old_rec.absence_days, hr_api.g_number)
2057: = nvl(p_absence_days, hr_api.g_number)

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

2050: and nvl(per_abs_shd.g_old_rec.time_start, hr_api.g_varchar2)
2051: = nvl(p_time_start, hr_api.g_varchar2)
2052: and nvl(per_abs_shd.g_old_rec.date_end, hr_api.g_date)
2053: = nvl(p_date_end, hr_api.g_date)
2054: and nvl(per_abs_shd.g_old_rec.time_end, hr_api.g_varchar2)
2055: = nvl(p_time_end, hr_api.g_varchar2)
2056: and nvl(per_abs_shd.g_old_rec.absence_days, hr_api.g_number)
2057: = nvl(p_absence_days, hr_api.g_number)
2058: and nvl(per_abs_shd.g_old_rec.absence_hours, hr_api.g_number)

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

2051: = nvl(p_time_start, hr_api.g_varchar2)
2052: and nvl(per_abs_shd.g_old_rec.date_end, hr_api.g_date)
2053: = nvl(p_date_end, hr_api.g_date)
2054: and nvl(per_abs_shd.g_old_rec.time_end, hr_api.g_varchar2)
2055: = nvl(p_time_end, hr_api.g_varchar2)
2056: and nvl(per_abs_shd.g_old_rec.absence_days, hr_api.g_number)
2057: = nvl(p_absence_days, hr_api.g_number)
2058: and nvl(per_abs_shd.g_old_rec.absence_hours, hr_api.g_number)
2059: = nvl(p_absence_hours, hr_api.g_number)) then

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

2052: and nvl(per_abs_shd.g_old_rec.date_end, hr_api.g_date)
2053: = nvl(p_date_end, hr_api.g_date)
2054: and nvl(per_abs_shd.g_old_rec.time_end, hr_api.g_varchar2)
2055: = nvl(p_time_end, hr_api.g_varchar2)
2056: and nvl(per_abs_shd.g_old_rec.absence_days, hr_api.g_number)
2057: = nvl(p_absence_days, hr_api.g_number)
2058: and nvl(per_abs_shd.g_old_rec.absence_hours, hr_api.g_number)
2059: = nvl(p_absence_hours, hr_api.g_number)) then
2060: return;

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

2053: = nvl(p_date_end, hr_api.g_date)
2054: and nvl(per_abs_shd.g_old_rec.time_end, hr_api.g_varchar2)
2055: = nvl(p_time_end, hr_api.g_varchar2)
2056: and nvl(per_abs_shd.g_old_rec.absence_days, hr_api.g_number)
2057: = nvl(p_absence_days, hr_api.g_number)
2058: and nvl(per_abs_shd.g_old_rec.absence_hours, hr_api.g_number)
2059: = nvl(p_absence_hours, hr_api.g_number)) then
2060: return;
2061: end if;

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

2054: and nvl(per_abs_shd.g_old_rec.time_end, hr_api.g_varchar2)
2055: = nvl(p_time_end, hr_api.g_varchar2)
2056: and nvl(per_abs_shd.g_old_rec.absence_days, hr_api.g_number)
2057: = nvl(p_absence_days, hr_api.g_number)
2058: and nvl(per_abs_shd.g_old_rec.absence_hours, hr_api.g_number)
2059: = nvl(p_absence_hours, hr_api.g_number)) then
2060: return;
2061: end if;
2062:

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

2055: = nvl(p_time_end, hr_api.g_varchar2)
2056: and nvl(per_abs_shd.g_old_rec.absence_days, hr_api.g_number)
2057: = nvl(p_absence_days, hr_api.g_number)
2058: and nvl(per_abs_shd.g_old_rec.absence_hours, hr_api.g_number)
2059: = nvl(p_absence_hours, hr_api.g_number)) then
2060: return;
2061: end if;
2062:
2063: --

Line 2606: hr_api.mandatory_arg_error

2602: begin
2603:
2604: hr_utility.set_location('Entering:'|| l_proc, 10);
2605: --
2606: hr_api.mandatory_arg_error
2607: (p_api_name => l_proc
2608: ,p_argument => 'p_business_group_id'
2609: ,p_argument_value => p_business_group_id
2610: );

Line 2622: and nvl(per_abs_shd.g_old_rec.replacement_person_id, hr_api.g_number)

2618: (p_absence_attendance_id => p_absence_attendance_id
2619: ,p_object_version_number => p_object_version_number);
2620: --
2621: if (l_api_updating
2622: and nvl(per_abs_shd.g_old_rec.replacement_person_id, hr_api.g_number)
2623: = nvl(p_replacement_person_id, hr_api.g_number)
2624: and nvl(per_abs_shd.g_old_rec.date_projected_start, hr_api.g_date)
2625: = nvl(p_date_projected_start, hr_api.g_date)
2626: and nvl(per_abs_shd.g_old_rec.date_projected_end, hr_api.g_date)

Line 2623: = nvl(p_replacement_person_id, hr_api.g_number)

2619: ,p_object_version_number => p_object_version_number);
2620: --
2621: if (l_api_updating
2622: and nvl(per_abs_shd.g_old_rec.replacement_person_id, hr_api.g_number)
2623: = nvl(p_replacement_person_id, hr_api.g_number)
2624: and nvl(per_abs_shd.g_old_rec.date_projected_start, hr_api.g_date)
2625: = nvl(p_date_projected_start, hr_api.g_date)
2626: and nvl(per_abs_shd.g_old_rec.date_projected_end, hr_api.g_date)
2627: = nvl(p_date_projected_end, hr_api.g_date)

Line 2624: and nvl(per_abs_shd.g_old_rec.date_projected_start, hr_api.g_date)

2620: --
2621: if (l_api_updating
2622: and nvl(per_abs_shd.g_old_rec.replacement_person_id, hr_api.g_number)
2623: = nvl(p_replacement_person_id, hr_api.g_number)
2624: and nvl(per_abs_shd.g_old_rec.date_projected_start, hr_api.g_date)
2625: = nvl(p_date_projected_start, hr_api.g_date)
2626: and nvl(per_abs_shd.g_old_rec.date_projected_end, hr_api.g_date)
2627: = nvl(p_date_projected_end, hr_api.g_date)
2628: and nvl(per_abs_shd.g_old_rec.date_start, hr_api.g_date)

Line 2625: = nvl(p_date_projected_start, hr_api.g_date)

2621: if (l_api_updating
2622: and nvl(per_abs_shd.g_old_rec.replacement_person_id, hr_api.g_number)
2623: = nvl(p_replacement_person_id, hr_api.g_number)
2624: and nvl(per_abs_shd.g_old_rec.date_projected_start, hr_api.g_date)
2625: = nvl(p_date_projected_start, hr_api.g_date)
2626: and nvl(per_abs_shd.g_old_rec.date_projected_end, hr_api.g_date)
2627: = nvl(p_date_projected_end, hr_api.g_date)
2628: and nvl(per_abs_shd.g_old_rec.date_start, hr_api.g_date)
2629: = nvl(p_date_start, hr_api.g_date)

Line 2626: and nvl(per_abs_shd.g_old_rec.date_projected_end, hr_api.g_date)

2622: and nvl(per_abs_shd.g_old_rec.replacement_person_id, hr_api.g_number)
2623: = nvl(p_replacement_person_id, hr_api.g_number)
2624: and nvl(per_abs_shd.g_old_rec.date_projected_start, hr_api.g_date)
2625: = nvl(p_date_projected_start, hr_api.g_date)
2626: and nvl(per_abs_shd.g_old_rec.date_projected_end, hr_api.g_date)
2627: = nvl(p_date_projected_end, hr_api.g_date)
2628: and nvl(per_abs_shd.g_old_rec.date_start, hr_api.g_date)
2629: = nvl(p_date_start, hr_api.g_date)
2630: and nvl(per_abs_shd.g_old_rec.date_end, hr_api.g_date)

Line 2627: = nvl(p_date_projected_end, hr_api.g_date)

2623: = nvl(p_replacement_person_id, hr_api.g_number)
2624: and nvl(per_abs_shd.g_old_rec.date_projected_start, hr_api.g_date)
2625: = nvl(p_date_projected_start, hr_api.g_date)
2626: and nvl(per_abs_shd.g_old_rec.date_projected_end, hr_api.g_date)
2627: = nvl(p_date_projected_end, hr_api.g_date)
2628: and nvl(per_abs_shd.g_old_rec.date_start, hr_api.g_date)
2629: = nvl(p_date_start, hr_api.g_date)
2630: and nvl(per_abs_shd.g_old_rec.date_end, hr_api.g_date)
2631: = nvl(p_date_end, hr_api.g_date)) then

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

2624: and nvl(per_abs_shd.g_old_rec.date_projected_start, hr_api.g_date)
2625: = nvl(p_date_projected_start, hr_api.g_date)
2626: and nvl(per_abs_shd.g_old_rec.date_projected_end, hr_api.g_date)
2627: = nvl(p_date_projected_end, hr_api.g_date)
2628: and nvl(per_abs_shd.g_old_rec.date_start, hr_api.g_date)
2629: = nvl(p_date_start, hr_api.g_date)
2630: and nvl(per_abs_shd.g_old_rec.date_end, hr_api.g_date)
2631: = nvl(p_date_end, hr_api.g_date)) then
2632: return;

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

2625: = nvl(p_date_projected_start, hr_api.g_date)
2626: and nvl(per_abs_shd.g_old_rec.date_projected_end, hr_api.g_date)
2627: = nvl(p_date_projected_end, hr_api.g_date)
2628: and nvl(per_abs_shd.g_old_rec.date_start, hr_api.g_date)
2629: = nvl(p_date_start, hr_api.g_date)
2630: and nvl(per_abs_shd.g_old_rec.date_end, hr_api.g_date)
2631: = nvl(p_date_end, hr_api.g_date)) then
2632: return;
2633: end if;

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

2626: and nvl(per_abs_shd.g_old_rec.date_projected_end, hr_api.g_date)
2627: = nvl(p_date_projected_end, hr_api.g_date)
2628: and nvl(per_abs_shd.g_old_rec.date_start, hr_api.g_date)
2629: = nvl(p_date_start, hr_api.g_date)
2630: and nvl(per_abs_shd.g_old_rec.date_end, hr_api.g_date)
2631: = nvl(p_date_end, hr_api.g_date)) then
2632: return;
2633: end if;
2634:

Line 2631: = nvl(p_date_end, hr_api.g_date)) then

2627: = nvl(p_date_projected_end, hr_api.g_date)
2628: and nvl(per_abs_shd.g_old_rec.date_start, hr_api.g_date)
2629: = nvl(p_date_start, hr_api.g_date)
2630: and nvl(per_abs_shd.g_old_rec.date_end, hr_api.g_date)
2631: = nvl(p_date_end, hr_api.g_date)) then
2632: return;
2633: end if;
2634:
2635: if p_replacement_person_id is not null then

Line 2709: hr_api.mandatory_arg_error

2705: begin
2706:
2707: hr_utility.set_location('Entering:'|| l_proc, 10);
2708: --
2709: hr_api.mandatory_arg_error
2710: (p_api_name => l_proc
2711: ,p_argument => 'p_business_group_id'
2712: ,p_argument_value => p_business_group_id
2713: );

Line 2725: and nvl(per_abs_shd.g_old_rec.authorising_person_id, hr_api.g_number)

2721: (p_absence_attendance_id => p_absence_attendance_id
2722: ,p_object_version_number => p_object_version_number);
2723: --
2724: if (l_api_updating
2725: and nvl(per_abs_shd.g_old_rec.authorising_person_id, hr_api.g_number)
2726: = nvl(p_authorising_person_id, hr_api.g_number)
2727: and nvl(per_abs_shd.g_old_rec.date_projected_start, hr_api.g_date)
2728: = nvl(p_date_projected_start, hr_api.g_date)
2729: and nvl(per_abs_shd.g_old_rec.date_projected_end, hr_api.g_date)

Line 2726: = nvl(p_authorising_person_id, hr_api.g_number)

2722: ,p_object_version_number => p_object_version_number);
2723: --
2724: if (l_api_updating
2725: and nvl(per_abs_shd.g_old_rec.authorising_person_id, hr_api.g_number)
2726: = nvl(p_authorising_person_id, hr_api.g_number)
2727: and nvl(per_abs_shd.g_old_rec.date_projected_start, hr_api.g_date)
2728: = nvl(p_date_projected_start, hr_api.g_date)
2729: and nvl(per_abs_shd.g_old_rec.date_projected_end, hr_api.g_date)
2730: = nvl(p_date_projected_end, hr_api.g_date)

Line 2727: and nvl(per_abs_shd.g_old_rec.date_projected_start, hr_api.g_date)

2723: --
2724: if (l_api_updating
2725: and nvl(per_abs_shd.g_old_rec.authorising_person_id, hr_api.g_number)
2726: = nvl(p_authorising_person_id, hr_api.g_number)
2727: and nvl(per_abs_shd.g_old_rec.date_projected_start, hr_api.g_date)
2728: = nvl(p_date_projected_start, hr_api.g_date)
2729: and nvl(per_abs_shd.g_old_rec.date_projected_end, hr_api.g_date)
2730: = nvl(p_date_projected_end, hr_api.g_date)
2731: and nvl(per_abs_shd.g_old_rec.date_start, hr_api.g_date)

Line 2728: = nvl(p_date_projected_start, hr_api.g_date)

2724: if (l_api_updating
2725: and nvl(per_abs_shd.g_old_rec.authorising_person_id, hr_api.g_number)
2726: = nvl(p_authorising_person_id, hr_api.g_number)
2727: and nvl(per_abs_shd.g_old_rec.date_projected_start, hr_api.g_date)
2728: = nvl(p_date_projected_start, hr_api.g_date)
2729: and nvl(per_abs_shd.g_old_rec.date_projected_end, hr_api.g_date)
2730: = nvl(p_date_projected_end, hr_api.g_date)
2731: and nvl(per_abs_shd.g_old_rec.date_start, hr_api.g_date)
2732: = nvl(p_date_start, hr_api.g_date)

Line 2729: and nvl(per_abs_shd.g_old_rec.date_projected_end, hr_api.g_date)

2725: and nvl(per_abs_shd.g_old_rec.authorising_person_id, hr_api.g_number)
2726: = nvl(p_authorising_person_id, hr_api.g_number)
2727: and nvl(per_abs_shd.g_old_rec.date_projected_start, hr_api.g_date)
2728: = nvl(p_date_projected_start, hr_api.g_date)
2729: and nvl(per_abs_shd.g_old_rec.date_projected_end, hr_api.g_date)
2730: = nvl(p_date_projected_end, hr_api.g_date)
2731: and nvl(per_abs_shd.g_old_rec.date_start, hr_api.g_date)
2732: = nvl(p_date_start, hr_api.g_date)
2733: and nvl(per_abs_shd.g_old_rec.date_end, hr_api.g_date)

Line 2730: = nvl(p_date_projected_end, hr_api.g_date)

2726: = nvl(p_authorising_person_id, hr_api.g_number)
2727: and nvl(per_abs_shd.g_old_rec.date_projected_start, hr_api.g_date)
2728: = nvl(p_date_projected_start, hr_api.g_date)
2729: and nvl(per_abs_shd.g_old_rec.date_projected_end, hr_api.g_date)
2730: = nvl(p_date_projected_end, hr_api.g_date)
2731: and nvl(per_abs_shd.g_old_rec.date_start, hr_api.g_date)
2732: = nvl(p_date_start, hr_api.g_date)
2733: and nvl(per_abs_shd.g_old_rec.date_end, hr_api.g_date)
2734: = nvl(p_date_end, hr_api.g_date)) then

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

2727: and nvl(per_abs_shd.g_old_rec.date_projected_start, hr_api.g_date)
2728: = nvl(p_date_projected_start, hr_api.g_date)
2729: and nvl(per_abs_shd.g_old_rec.date_projected_end, hr_api.g_date)
2730: = nvl(p_date_projected_end, hr_api.g_date)
2731: and nvl(per_abs_shd.g_old_rec.date_start, hr_api.g_date)
2732: = nvl(p_date_start, hr_api.g_date)
2733: and nvl(per_abs_shd.g_old_rec.date_end, hr_api.g_date)
2734: = nvl(p_date_end, hr_api.g_date)) then
2735: return;

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

2728: = nvl(p_date_projected_start, hr_api.g_date)
2729: and nvl(per_abs_shd.g_old_rec.date_projected_end, hr_api.g_date)
2730: = nvl(p_date_projected_end, hr_api.g_date)
2731: and nvl(per_abs_shd.g_old_rec.date_start, hr_api.g_date)
2732: = nvl(p_date_start, hr_api.g_date)
2733: and nvl(per_abs_shd.g_old_rec.date_end, hr_api.g_date)
2734: = nvl(p_date_end, hr_api.g_date)) then
2735: return;
2736: end if;

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

2729: and nvl(per_abs_shd.g_old_rec.date_projected_end, hr_api.g_date)
2730: = nvl(p_date_projected_end, hr_api.g_date)
2731: and nvl(per_abs_shd.g_old_rec.date_start, hr_api.g_date)
2732: = nvl(p_date_start, hr_api.g_date)
2733: and nvl(per_abs_shd.g_old_rec.date_end, hr_api.g_date)
2734: = nvl(p_date_end, hr_api.g_date)) then
2735: return;
2736: end if;
2737:

Line 2734: = nvl(p_date_end, hr_api.g_date)) then

2730: = nvl(p_date_projected_end, hr_api.g_date)
2731: and nvl(per_abs_shd.g_old_rec.date_start, hr_api.g_date)
2732: = nvl(p_date_start, hr_api.g_date)
2733: and nvl(per_abs_shd.g_old_rec.date_end, hr_api.g_date)
2734: = nvl(p_date_end, hr_api.g_date)) then
2735: return;
2736: end if;
2737:
2738: if p_authorising_person_id is not null then

Line 2791: hr_api.mandatory_arg_error

2787: hr_utility.set_location('Entering:'|| l_proc, 10);
2788: --
2789: -- Ensure that all the mandatory parameter are not null
2790: --
2791: hr_api.mandatory_arg_error
2792: (p_api_name => l_proc
2793: ,p_argument => 'absence_attendance_id'
2794: ,p_argument_value => p_absence_attendance_id
2795: );

Line 2814: hr_api.set_security_group_id

2810: close csr_sec_grp;
2811: --
2812: -- Set the security_group_id in CLIENT_INFO
2813: --
2814: hr_api.set_security_group_id
2815: (p_security_group_id => l_security_group_id
2816: );
2817: --
2818: hr_utility.set_location(' Leaving:'|| l_proc, 20);

Line 2851: hr_api.mandatory_arg_error

2847: hr_utility.set_location('Entering:'|| l_proc, 10);
2848: --
2849: -- Ensure that all the mandatory parameter are not null
2850: --
2851: hr_api.mandatory_arg_error
2852: (p_api_name => l_proc
2853: ,p_argument => 'absence_attendance_id'
2854: ,p_argument_value => p_absence_attendance_id
2855: );

Line 2857: if ( nvl(per_abs_bus.g_absence_attendance_id, hr_api.g_number)

2853: ,p_argument => 'absence_attendance_id'
2854: ,p_argument_value => p_absence_attendance_id
2855: );
2856: --
2857: if ( nvl(per_abs_bus.g_absence_attendance_id, hr_api.g_number)
2858: = p_absence_attendance_id) then
2859: --
2860: -- The legislation code has already been found with a previous
2861: -- call to this function. Just return the value in the global

Line 2934: nvl(per_abs_shd.g_old_rec.abs_information_category, hr_api.g_varchar2) <>

2930: begin
2931: hr_utility.set_location('Entering:'||l_proc,10);
2932: --
2933: if ((p_rec.absence_attendance_id is not null) and (
2934: nvl(per_abs_shd.g_old_rec.abs_information_category, hr_api.g_varchar2) <>
2935: nvl(p_rec.abs_information_category, hr_api.g_varchar2) or
2936: nvl(per_abs_shd.g_old_rec.abs_information1, hr_api.g_varchar2) <>
2937: nvl(p_rec.abs_information1, hr_api.g_varchar2) or
2938: nvl(per_abs_shd.g_old_rec.abs_information2, hr_api.g_varchar2) <>

Line 2935: nvl(p_rec.abs_information_category, hr_api.g_varchar2) or

2931: hr_utility.set_location('Entering:'||l_proc,10);
2932: --
2933: if ((p_rec.absence_attendance_id is not null) and (
2934: nvl(per_abs_shd.g_old_rec.abs_information_category, hr_api.g_varchar2) <>
2935: nvl(p_rec.abs_information_category, hr_api.g_varchar2) or
2936: nvl(per_abs_shd.g_old_rec.abs_information1, hr_api.g_varchar2) <>
2937: nvl(p_rec.abs_information1, hr_api.g_varchar2) or
2938: nvl(per_abs_shd.g_old_rec.abs_information2, hr_api.g_varchar2) <>
2939: nvl(p_rec.abs_information2, hr_api.g_varchar2) or

Line 2936: nvl(per_abs_shd.g_old_rec.abs_information1, hr_api.g_varchar2) <>

2932: --
2933: if ((p_rec.absence_attendance_id is not null) and (
2934: nvl(per_abs_shd.g_old_rec.abs_information_category, hr_api.g_varchar2) <>
2935: nvl(p_rec.abs_information_category, hr_api.g_varchar2) or
2936: nvl(per_abs_shd.g_old_rec.abs_information1, hr_api.g_varchar2) <>
2937: nvl(p_rec.abs_information1, hr_api.g_varchar2) or
2938: nvl(per_abs_shd.g_old_rec.abs_information2, hr_api.g_varchar2) <>
2939: nvl(p_rec.abs_information2, hr_api.g_varchar2) or
2940: nvl(per_abs_shd.g_old_rec.abs_information3, hr_api.g_varchar2) <>

Line 2937: nvl(p_rec.abs_information1, hr_api.g_varchar2) or

2933: if ((p_rec.absence_attendance_id is not null) and (
2934: nvl(per_abs_shd.g_old_rec.abs_information_category, hr_api.g_varchar2) <>
2935: nvl(p_rec.abs_information_category, hr_api.g_varchar2) or
2936: nvl(per_abs_shd.g_old_rec.abs_information1, hr_api.g_varchar2) <>
2937: nvl(p_rec.abs_information1, hr_api.g_varchar2) or
2938: nvl(per_abs_shd.g_old_rec.abs_information2, hr_api.g_varchar2) <>
2939: nvl(p_rec.abs_information2, hr_api.g_varchar2) or
2940: nvl(per_abs_shd.g_old_rec.abs_information3, hr_api.g_varchar2) <>
2941: nvl(p_rec.abs_information3, hr_api.g_varchar2) or

Line 2938: nvl(per_abs_shd.g_old_rec.abs_information2, hr_api.g_varchar2) <>

2934: nvl(per_abs_shd.g_old_rec.abs_information_category, hr_api.g_varchar2) <>
2935: nvl(p_rec.abs_information_category, hr_api.g_varchar2) or
2936: nvl(per_abs_shd.g_old_rec.abs_information1, hr_api.g_varchar2) <>
2937: nvl(p_rec.abs_information1, hr_api.g_varchar2) or
2938: nvl(per_abs_shd.g_old_rec.abs_information2, hr_api.g_varchar2) <>
2939: nvl(p_rec.abs_information2, hr_api.g_varchar2) or
2940: nvl(per_abs_shd.g_old_rec.abs_information3, hr_api.g_varchar2) <>
2941: nvl(p_rec.abs_information3, hr_api.g_varchar2) or
2942: nvl(per_abs_shd.g_old_rec.abs_information4, hr_api.g_varchar2) <>

Line 2939: nvl(p_rec.abs_information2, hr_api.g_varchar2) or

2935: nvl(p_rec.abs_information_category, hr_api.g_varchar2) or
2936: nvl(per_abs_shd.g_old_rec.abs_information1, hr_api.g_varchar2) <>
2937: nvl(p_rec.abs_information1, hr_api.g_varchar2) or
2938: nvl(per_abs_shd.g_old_rec.abs_information2, hr_api.g_varchar2) <>
2939: nvl(p_rec.abs_information2, hr_api.g_varchar2) or
2940: nvl(per_abs_shd.g_old_rec.abs_information3, hr_api.g_varchar2) <>
2941: nvl(p_rec.abs_information3, hr_api.g_varchar2) or
2942: nvl(per_abs_shd.g_old_rec.abs_information4, hr_api.g_varchar2) <>
2943: nvl(p_rec.abs_information4, hr_api.g_varchar2) or

Line 2940: nvl(per_abs_shd.g_old_rec.abs_information3, hr_api.g_varchar2) <>

2936: nvl(per_abs_shd.g_old_rec.abs_information1, hr_api.g_varchar2) <>
2937: nvl(p_rec.abs_information1, hr_api.g_varchar2) or
2938: nvl(per_abs_shd.g_old_rec.abs_information2, hr_api.g_varchar2) <>
2939: nvl(p_rec.abs_information2, hr_api.g_varchar2) or
2940: nvl(per_abs_shd.g_old_rec.abs_information3, hr_api.g_varchar2) <>
2941: nvl(p_rec.abs_information3, hr_api.g_varchar2) or
2942: nvl(per_abs_shd.g_old_rec.abs_information4, hr_api.g_varchar2) <>
2943: nvl(p_rec.abs_information4, hr_api.g_varchar2) or
2944: nvl(per_abs_shd.g_old_rec.abs_information5, hr_api.g_varchar2) <>

Line 2941: nvl(p_rec.abs_information3, hr_api.g_varchar2) or

2937: nvl(p_rec.abs_information1, hr_api.g_varchar2) or
2938: nvl(per_abs_shd.g_old_rec.abs_information2, hr_api.g_varchar2) <>
2939: nvl(p_rec.abs_information2, hr_api.g_varchar2) or
2940: nvl(per_abs_shd.g_old_rec.abs_information3, hr_api.g_varchar2) <>
2941: nvl(p_rec.abs_information3, hr_api.g_varchar2) or
2942: nvl(per_abs_shd.g_old_rec.abs_information4, hr_api.g_varchar2) <>
2943: nvl(p_rec.abs_information4, hr_api.g_varchar2) or
2944: nvl(per_abs_shd.g_old_rec.abs_information5, hr_api.g_varchar2) <>
2945: nvl(p_rec.abs_information5, hr_api.g_varchar2) or

Line 2942: nvl(per_abs_shd.g_old_rec.abs_information4, hr_api.g_varchar2) <>

2938: nvl(per_abs_shd.g_old_rec.abs_information2, hr_api.g_varchar2) <>
2939: nvl(p_rec.abs_information2, hr_api.g_varchar2) or
2940: nvl(per_abs_shd.g_old_rec.abs_information3, hr_api.g_varchar2) <>
2941: nvl(p_rec.abs_information3, hr_api.g_varchar2) or
2942: nvl(per_abs_shd.g_old_rec.abs_information4, hr_api.g_varchar2) <>
2943: nvl(p_rec.abs_information4, hr_api.g_varchar2) or
2944: nvl(per_abs_shd.g_old_rec.abs_information5, hr_api.g_varchar2) <>
2945: nvl(p_rec.abs_information5, hr_api.g_varchar2) or
2946: nvl(per_abs_shd.g_old_rec.abs_information6, hr_api.g_varchar2) <>

Line 2943: nvl(p_rec.abs_information4, hr_api.g_varchar2) or

2939: nvl(p_rec.abs_information2, hr_api.g_varchar2) or
2940: nvl(per_abs_shd.g_old_rec.abs_information3, hr_api.g_varchar2) <>
2941: nvl(p_rec.abs_information3, hr_api.g_varchar2) or
2942: nvl(per_abs_shd.g_old_rec.abs_information4, hr_api.g_varchar2) <>
2943: nvl(p_rec.abs_information4, hr_api.g_varchar2) or
2944: nvl(per_abs_shd.g_old_rec.abs_information5, hr_api.g_varchar2) <>
2945: nvl(p_rec.abs_information5, hr_api.g_varchar2) or
2946: nvl(per_abs_shd.g_old_rec.abs_information6, hr_api.g_varchar2) <>
2947: nvl(p_rec.abs_information6, hr_api.g_varchar2) or

Line 2944: nvl(per_abs_shd.g_old_rec.abs_information5, hr_api.g_varchar2) <>

2940: nvl(per_abs_shd.g_old_rec.abs_information3, hr_api.g_varchar2) <>
2941: nvl(p_rec.abs_information3, hr_api.g_varchar2) or
2942: nvl(per_abs_shd.g_old_rec.abs_information4, hr_api.g_varchar2) <>
2943: nvl(p_rec.abs_information4, hr_api.g_varchar2) or
2944: nvl(per_abs_shd.g_old_rec.abs_information5, hr_api.g_varchar2) <>
2945: nvl(p_rec.abs_information5, hr_api.g_varchar2) or
2946: nvl(per_abs_shd.g_old_rec.abs_information6, hr_api.g_varchar2) <>
2947: nvl(p_rec.abs_information6, hr_api.g_varchar2) or
2948: nvl(per_abs_shd.g_old_rec.abs_information7, hr_api.g_varchar2) <>

Line 2945: nvl(p_rec.abs_information5, hr_api.g_varchar2) or

2941: nvl(p_rec.abs_information3, hr_api.g_varchar2) or
2942: nvl(per_abs_shd.g_old_rec.abs_information4, hr_api.g_varchar2) <>
2943: nvl(p_rec.abs_information4, hr_api.g_varchar2) or
2944: nvl(per_abs_shd.g_old_rec.abs_information5, hr_api.g_varchar2) <>
2945: nvl(p_rec.abs_information5, hr_api.g_varchar2) or
2946: nvl(per_abs_shd.g_old_rec.abs_information6, hr_api.g_varchar2) <>
2947: nvl(p_rec.abs_information6, hr_api.g_varchar2) or
2948: nvl(per_abs_shd.g_old_rec.abs_information7, hr_api.g_varchar2) <>
2949: nvl(p_rec.abs_information7, hr_api.g_varchar2) or

Line 2946: nvl(per_abs_shd.g_old_rec.abs_information6, hr_api.g_varchar2) <>

2942: nvl(per_abs_shd.g_old_rec.abs_information4, hr_api.g_varchar2) <>
2943: nvl(p_rec.abs_information4, hr_api.g_varchar2) or
2944: nvl(per_abs_shd.g_old_rec.abs_information5, hr_api.g_varchar2) <>
2945: nvl(p_rec.abs_information5, hr_api.g_varchar2) or
2946: nvl(per_abs_shd.g_old_rec.abs_information6, hr_api.g_varchar2) <>
2947: nvl(p_rec.abs_information6, hr_api.g_varchar2) or
2948: nvl(per_abs_shd.g_old_rec.abs_information7, hr_api.g_varchar2) <>
2949: nvl(p_rec.abs_information7, hr_api.g_varchar2) or
2950: nvl(per_abs_shd.g_old_rec.abs_information8, hr_api.g_varchar2) <>

Line 2947: nvl(p_rec.abs_information6, hr_api.g_varchar2) or

2943: nvl(p_rec.abs_information4, hr_api.g_varchar2) or
2944: nvl(per_abs_shd.g_old_rec.abs_information5, hr_api.g_varchar2) <>
2945: nvl(p_rec.abs_information5, hr_api.g_varchar2) or
2946: nvl(per_abs_shd.g_old_rec.abs_information6, hr_api.g_varchar2) <>
2947: nvl(p_rec.abs_information6, hr_api.g_varchar2) or
2948: nvl(per_abs_shd.g_old_rec.abs_information7, hr_api.g_varchar2) <>
2949: nvl(p_rec.abs_information7, hr_api.g_varchar2) or
2950: nvl(per_abs_shd.g_old_rec.abs_information8, hr_api.g_varchar2) <>
2951: nvl(p_rec.abs_information8, hr_api.g_varchar2) or

Line 2948: nvl(per_abs_shd.g_old_rec.abs_information7, hr_api.g_varchar2) <>

2944: nvl(per_abs_shd.g_old_rec.abs_information5, hr_api.g_varchar2) <>
2945: nvl(p_rec.abs_information5, hr_api.g_varchar2) or
2946: nvl(per_abs_shd.g_old_rec.abs_information6, hr_api.g_varchar2) <>
2947: nvl(p_rec.abs_information6, hr_api.g_varchar2) or
2948: nvl(per_abs_shd.g_old_rec.abs_information7, hr_api.g_varchar2) <>
2949: nvl(p_rec.abs_information7, hr_api.g_varchar2) or
2950: nvl(per_abs_shd.g_old_rec.abs_information8, hr_api.g_varchar2) <>
2951: nvl(p_rec.abs_information8, hr_api.g_varchar2) or
2952: nvl(per_abs_shd.g_old_rec.abs_information9, hr_api.g_varchar2) <>

Line 2949: nvl(p_rec.abs_information7, hr_api.g_varchar2) or

2945: nvl(p_rec.abs_information5, hr_api.g_varchar2) or
2946: nvl(per_abs_shd.g_old_rec.abs_information6, hr_api.g_varchar2) <>
2947: nvl(p_rec.abs_information6, hr_api.g_varchar2) or
2948: nvl(per_abs_shd.g_old_rec.abs_information7, hr_api.g_varchar2) <>
2949: nvl(p_rec.abs_information7, hr_api.g_varchar2) or
2950: nvl(per_abs_shd.g_old_rec.abs_information8, hr_api.g_varchar2) <>
2951: nvl(p_rec.abs_information8, hr_api.g_varchar2) or
2952: nvl(per_abs_shd.g_old_rec.abs_information9, hr_api.g_varchar2) <>
2953: nvl(p_rec.abs_information9, hr_api.g_varchar2) or

Line 2950: nvl(per_abs_shd.g_old_rec.abs_information8, hr_api.g_varchar2) <>

2946: nvl(per_abs_shd.g_old_rec.abs_information6, hr_api.g_varchar2) <>
2947: nvl(p_rec.abs_information6, hr_api.g_varchar2) or
2948: nvl(per_abs_shd.g_old_rec.abs_information7, hr_api.g_varchar2) <>
2949: nvl(p_rec.abs_information7, hr_api.g_varchar2) or
2950: nvl(per_abs_shd.g_old_rec.abs_information8, hr_api.g_varchar2) <>
2951: nvl(p_rec.abs_information8, hr_api.g_varchar2) or
2952: nvl(per_abs_shd.g_old_rec.abs_information9, hr_api.g_varchar2) <>
2953: nvl(p_rec.abs_information9, hr_api.g_varchar2) or
2954: nvl(per_abs_shd.g_old_rec.abs_information10, hr_api.g_varchar2) <>

Line 2951: nvl(p_rec.abs_information8, hr_api.g_varchar2) or

2947: nvl(p_rec.abs_information6, hr_api.g_varchar2) or
2948: nvl(per_abs_shd.g_old_rec.abs_information7, hr_api.g_varchar2) <>
2949: nvl(p_rec.abs_information7, hr_api.g_varchar2) or
2950: nvl(per_abs_shd.g_old_rec.abs_information8, hr_api.g_varchar2) <>
2951: nvl(p_rec.abs_information8, hr_api.g_varchar2) or
2952: nvl(per_abs_shd.g_old_rec.abs_information9, hr_api.g_varchar2) <>
2953: nvl(p_rec.abs_information9, hr_api.g_varchar2) or
2954: nvl(per_abs_shd.g_old_rec.abs_information10, hr_api.g_varchar2) <>
2955: nvl(p_rec.abs_information10, hr_api.g_varchar2) or

Line 2952: nvl(per_abs_shd.g_old_rec.abs_information9, hr_api.g_varchar2) <>

2948: nvl(per_abs_shd.g_old_rec.abs_information7, hr_api.g_varchar2) <>
2949: nvl(p_rec.abs_information7, hr_api.g_varchar2) or
2950: nvl(per_abs_shd.g_old_rec.abs_information8, hr_api.g_varchar2) <>
2951: nvl(p_rec.abs_information8, hr_api.g_varchar2) or
2952: nvl(per_abs_shd.g_old_rec.abs_information9, hr_api.g_varchar2) <>
2953: nvl(p_rec.abs_information9, hr_api.g_varchar2) or
2954: nvl(per_abs_shd.g_old_rec.abs_information10, hr_api.g_varchar2) <>
2955: nvl(p_rec.abs_information10, hr_api.g_varchar2) or
2956: nvl(per_abs_shd.g_old_rec.abs_information11, hr_api.g_varchar2) <>

Line 2953: nvl(p_rec.abs_information9, hr_api.g_varchar2) or

2949: nvl(p_rec.abs_information7, hr_api.g_varchar2) or
2950: nvl(per_abs_shd.g_old_rec.abs_information8, hr_api.g_varchar2) <>
2951: nvl(p_rec.abs_information8, hr_api.g_varchar2) or
2952: nvl(per_abs_shd.g_old_rec.abs_information9, hr_api.g_varchar2) <>
2953: nvl(p_rec.abs_information9, hr_api.g_varchar2) or
2954: nvl(per_abs_shd.g_old_rec.abs_information10, hr_api.g_varchar2) <>
2955: nvl(p_rec.abs_information10, hr_api.g_varchar2) or
2956: nvl(per_abs_shd.g_old_rec.abs_information11, hr_api.g_varchar2) <>
2957: nvl(p_rec.abs_information11, hr_api.g_varchar2) or

Line 2954: nvl(per_abs_shd.g_old_rec.abs_information10, hr_api.g_varchar2) <>

2950: nvl(per_abs_shd.g_old_rec.abs_information8, hr_api.g_varchar2) <>
2951: nvl(p_rec.abs_information8, hr_api.g_varchar2) or
2952: nvl(per_abs_shd.g_old_rec.abs_information9, hr_api.g_varchar2) <>
2953: nvl(p_rec.abs_information9, hr_api.g_varchar2) or
2954: nvl(per_abs_shd.g_old_rec.abs_information10, hr_api.g_varchar2) <>
2955: nvl(p_rec.abs_information10, hr_api.g_varchar2) or
2956: nvl(per_abs_shd.g_old_rec.abs_information11, hr_api.g_varchar2) <>
2957: nvl(p_rec.abs_information11, hr_api.g_varchar2) or
2958: nvl(per_abs_shd.g_old_rec.abs_information12, hr_api.g_varchar2) <>

Line 2955: nvl(p_rec.abs_information10, hr_api.g_varchar2) or

2951: nvl(p_rec.abs_information8, hr_api.g_varchar2) or
2952: nvl(per_abs_shd.g_old_rec.abs_information9, hr_api.g_varchar2) <>
2953: nvl(p_rec.abs_information9, hr_api.g_varchar2) or
2954: nvl(per_abs_shd.g_old_rec.abs_information10, hr_api.g_varchar2) <>
2955: nvl(p_rec.abs_information10, hr_api.g_varchar2) or
2956: nvl(per_abs_shd.g_old_rec.abs_information11, hr_api.g_varchar2) <>
2957: nvl(p_rec.abs_information11, hr_api.g_varchar2) or
2958: nvl(per_abs_shd.g_old_rec.abs_information12, hr_api.g_varchar2) <>
2959: nvl(p_rec.abs_information12, hr_api.g_varchar2) or

Line 2956: nvl(per_abs_shd.g_old_rec.abs_information11, hr_api.g_varchar2) <>

2952: nvl(per_abs_shd.g_old_rec.abs_information9, hr_api.g_varchar2) <>
2953: nvl(p_rec.abs_information9, hr_api.g_varchar2) or
2954: nvl(per_abs_shd.g_old_rec.abs_information10, hr_api.g_varchar2) <>
2955: nvl(p_rec.abs_information10, hr_api.g_varchar2) or
2956: nvl(per_abs_shd.g_old_rec.abs_information11, hr_api.g_varchar2) <>
2957: nvl(p_rec.abs_information11, hr_api.g_varchar2) or
2958: nvl(per_abs_shd.g_old_rec.abs_information12, hr_api.g_varchar2) <>
2959: nvl(p_rec.abs_information12, hr_api.g_varchar2) or
2960: nvl(per_abs_shd.g_old_rec.abs_information13, hr_api.g_varchar2) <>

Line 2957: nvl(p_rec.abs_information11, hr_api.g_varchar2) or

2953: nvl(p_rec.abs_information9, hr_api.g_varchar2) or
2954: nvl(per_abs_shd.g_old_rec.abs_information10, hr_api.g_varchar2) <>
2955: nvl(p_rec.abs_information10, hr_api.g_varchar2) or
2956: nvl(per_abs_shd.g_old_rec.abs_information11, hr_api.g_varchar2) <>
2957: nvl(p_rec.abs_information11, hr_api.g_varchar2) or
2958: nvl(per_abs_shd.g_old_rec.abs_information12, hr_api.g_varchar2) <>
2959: nvl(p_rec.abs_information12, hr_api.g_varchar2) or
2960: nvl(per_abs_shd.g_old_rec.abs_information13, hr_api.g_varchar2) <>
2961: nvl(p_rec.abs_information13, hr_api.g_varchar2) or

Line 2958: nvl(per_abs_shd.g_old_rec.abs_information12, hr_api.g_varchar2) <>

2954: nvl(per_abs_shd.g_old_rec.abs_information10, hr_api.g_varchar2) <>
2955: nvl(p_rec.abs_information10, hr_api.g_varchar2) or
2956: nvl(per_abs_shd.g_old_rec.abs_information11, hr_api.g_varchar2) <>
2957: nvl(p_rec.abs_information11, hr_api.g_varchar2) or
2958: nvl(per_abs_shd.g_old_rec.abs_information12, hr_api.g_varchar2) <>
2959: nvl(p_rec.abs_information12, hr_api.g_varchar2) or
2960: nvl(per_abs_shd.g_old_rec.abs_information13, hr_api.g_varchar2) <>
2961: nvl(p_rec.abs_information13, hr_api.g_varchar2) or
2962: nvl(per_abs_shd.g_old_rec.abs_information14, hr_api.g_varchar2) <>

Line 2959: nvl(p_rec.abs_information12, hr_api.g_varchar2) or

2955: nvl(p_rec.abs_information10, hr_api.g_varchar2) or
2956: nvl(per_abs_shd.g_old_rec.abs_information11, hr_api.g_varchar2) <>
2957: nvl(p_rec.abs_information11, hr_api.g_varchar2) or
2958: nvl(per_abs_shd.g_old_rec.abs_information12, hr_api.g_varchar2) <>
2959: nvl(p_rec.abs_information12, hr_api.g_varchar2) or
2960: nvl(per_abs_shd.g_old_rec.abs_information13, hr_api.g_varchar2) <>
2961: nvl(p_rec.abs_information13, hr_api.g_varchar2) or
2962: nvl(per_abs_shd.g_old_rec.abs_information14, hr_api.g_varchar2) <>
2963: nvl(p_rec.abs_information14, hr_api.g_varchar2) or

Line 2960: nvl(per_abs_shd.g_old_rec.abs_information13, hr_api.g_varchar2) <>

2956: nvl(per_abs_shd.g_old_rec.abs_information11, hr_api.g_varchar2) <>
2957: nvl(p_rec.abs_information11, hr_api.g_varchar2) or
2958: nvl(per_abs_shd.g_old_rec.abs_information12, hr_api.g_varchar2) <>
2959: nvl(p_rec.abs_information12, hr_api.g_varchar2) or
2960: nvl(per_abs_shd.g_old_rec.abs_information13, hr_api.g_varchar2) <>
2961: nvl(p_rec.abs_information13, hr_api.g_varchar2) or
2962: nvl(per_abs_shd.g_old_rec.abs_information14, hr_api.g_varchar2) <>
2963: nvl(p_rec.abs_information14, hr_api.g_varchar2) or
2964: nvl(per_abs_shd.g_old_rec.abs_information15, hr_api.g_varchar2) <>

Line 2961: nvl(p_rec.abs_information13, hr_api.g_varchar2) or

2957: nvl(p_rec.abs_information11, hr_api.g_varchar2) or
2958: nvl(per_abs_shd.g_old_rec.abs_information12, hr_api.g_varchar2) <>
2959: nvl(p_rec.abs_information12, hr_api.g_varchar2) or
2960: nvl(per_abs_shd.g_old_rec.abs_information13, hr_api.g_varchar2) <>
2961: nvl(p_rec.abs_information13, hr_api.g_varchar2) or
2962: nvl(per_abs_shd.g_old_rec.abs_information14, hr_api.g_varchar2) <>
2963: nvl(p_rec.abs_information14, hr_api.g_varchar2) or
2964: nvl(per_abs_shd.g_old_rec.abs_information15, hr_api.g_varchar2) <>
2965: nvl(p_rec.abs_information15, hr_api.g_varchar2) or

Line 2962: nvl(per_abs_shd.g_old_rec.abs_information14, hr_api.g_varchar2) <>

2958: nvl(per_abs_shd.g_old_rec.abs_information12, hr_api.g_varchar2) <>
2959: nvl(p_rec.abs_information12, hr_api.g_varchar2) or
2960: nvl(per_abs_shd.g_old_rec.abs_information13, hr_api.g_varchar2) <>
2961: nvl(p_rec.abs_information13, hr_api.g_varchar2) or
2962: nvl(per_abs_shd.g_old_rec.abs_information14, hr_api.g_varchar2) <>
2963: nvl(p_rec.abs_information14, hr_api.g_varchar2) or
2964: nvl(per_abs_shd.g_old_rec.abs_information15, hr_api.g_varchar2) <>
2965: nvl(p_rec.abs_information15, hr_api.g_varchar2) or
2966: nvl(per_abs_shd.g_old_rec.abs_information16, hr_api.g_varchar2) <>

Line 2963: nvl(p_rec.abs_information14, hr_api.g_varchar2) or

2959: nvl(p_rec.abs_information12, hr_api.g_varchar2) or
2960: nvl(per_abs_shd.g_old_rec.abs_information13, hr_api.g_varchar2) <>
2961: nvl(p_rec.abs_information13, hr_api.g_varchar2) or
2962: nvl(per_abs_shd.g_old_rec.abs_information14, hr_api.g_varchar2) <>
2963: nvl(p_rec.abs_information14, hr_api.g_varchar2) or
2964: nvl(per_abs_shd.g_old_rec.abs_information15, hr_api.g_varchar2) <>
2965: nvl(p_rec.abs_information15, hr_api.g_varchar2) or
2966: nvl(per_abs_shd.g_old_rec.abs_information16, hr_api.g_varchar2) <>
2967: nvl(p_rec.abs_information16, hr_api.g_varchar2) or

Line 2964: nvl(per_abs_shd.g_old_rec.abs_information15, hr_api.g_varchar2) <>

2960: nvl(per_abs_shd.g_old_rec.abs_information13, hr_api.g_varchar2) <>
2961: nvl(p_rec.abs_information13, hr_api.g_varchar2) or
2962: nvl(per_abs_shd.g_old_rec.abs_information14, hr_api.g_varchar2) <>
2963: nvl(p_rec.abs_information14, hr_api.g_varchar2) or
2964: nvl(per_abs_shd.g_old_rec.abs_information15, hr_api.g_varchar2) <>
2965: nvl(p_rec.abs_information15, hr_api.g_varchar2) or
2966: nvl(per_abs_shd.g_old_rec.abs_information16, hr_api.g_varchar2) <>
2967: nvl(p_rec.abs_information16, hr_api.g_varchar2) or
2968: nvl(per_abs_shd.g_old_rec.abs_information17, hr_api.g_varchar2) <>

Line 2965: nvl(p_rec.abs_information15, hr_api.g_varchar2) or

2961: nvl(p_rec.abs_information13, hr_api.g_varchar2) or
2962: nvl(per_abs_shd.g_old_rec.abs_information14, hr_api.g_varchar2) <>
2963: nvl(p_rec.abs_information14, hr_api.g_varchar2) or
2964: nvl(per_abs_shd.g_old_rec.abs_information15, hr_api.g_varchar2) <>
2965: nvl(p_rec.abs_information15, hr_api.g_varchar2) or
2966: nvl(per_abs_shd.g_old_rec.abs_information16, hr_api.g_varchar2) <>
2967: nvl(p_rec.abs_information16, hr_api.g_varchar2) or
2968: nvl(per_abs_shd.g_old_rec.abs_information17, hr_api.g_varchar2) <>
2969: nvl(p_rec.abs_information17, hr_api.g_varchar2) or

Line 2966: nvl(per_abs_shd.g_old_rec.abs_information16, hr_api.g_varchar2) <>

2962: nvl(per_abs_shd.g_old_rec.abs_information14, hr_api.g_varchar2) <>
2963: nvl(p_rec.abs_information14, hr_api.g_varchar2) or
2964: nvl(per_abs_shd.g_old_rec.abs_information15, hr_api.g_varchar2) <>
2965: nvl(p_rec.abs_information15, hr_api.g_varchar2) or
2966: nvl(per_abs_shd.g_old_rec.abs_information16, hr_api.g_varchar2) <>
2967: nvl(p_rec.abs_information16, hr_api.g_varchar2) or
2968: nvl(per_abs_shd.g_old_rec.abs_information17, hr_api.g_varchar2) <>
2969: nvl(p_rec.abs_information17, hr_api.g_varchar2) or
2970: nvl(per_abs_shd.g_old_rec.abs_information18, hr_api.g_varchar2) <>

Line 2967: nvl(p_rec.abs_information16, hr_api.g_varchar2) or

2963: nvl(p_rec.abs_information14, hr_api.g_varchar2) or
2964: nvl(per_abs_shd.g_old_rec.abs_information15, hr_api.g_varchar2) <>
2965: nvl(p_rec.abs_information15, hr_api.g_varchar2) or
2966: nvl(per_abs_shd.g_old_rec.abs_information16, hr_api.g_varchar2) <>
2967: nvl(p_rec.abs_information16, hr_api.g_varchar2) or
2968: nvl(per_abs_shd.g_old_rec.abs_information17, hr_api.g_varchar2) <>
2969: nvl(p_rec.abs_information17, hr_api.g_varchar2) or
2970: nvl(per_abs_shd.g_old_rec.abs_information18, hr_api.g_varchar2) <>
2971: nvl(p_rec.abs_information18, hr_api.g_varchar2) or

Line 2968: nvl(per_abs_shd.g_old_rec.abs_information17, hr_api.g_varchar2) <>

2964: nvl(per_abs_shd.g_old_rec.abs_information15, hr_api.g_varchar2) <>
2965: nvl(p_rec.abs_information15, hr_api.g_varchar2) or
2966: nvl(per_abs_shd.g_old_rec.abs_information16, hr_api.g_varchar2) <>
2967: nvl(p_rec.abs_information16, hr_api.g_varchar2) or
2968: nvl(per_abs_shd.g_old_rec.abs_information17, hr_api.g_varchar2) <>
2969: nvl(p_rec.abs_information17, hr_api.g_varchar2) or
2970: nvl(per_abs_shd.g_old_rec.abs_information18, hr_api.g_varchar2) <>
2971: nvl(p_rec.abs_information18, hr_api.g_varchar2) or
2972: nvl(per_abs_shd.g_old_rec.abs_information19, hr_api.g_varchar2) <>

Line 2969: nvl(p_rec.abs_information17, hr_api.g_varchar2) or

2965: nvl(p_rec.abs_information15, hr_api.g_varchar2) or
2966: nvl(per_abs_shd.g_old_rec.abs_information16, hr_api.g_varchar2) <>
2967: nvl(p_rec.abs_information16, hr_api.g_varchar2) or
2968: nvl(per_abs_shd.g_old_rec.abs_information17, hr_api.g_varchar2) <>
2969: nvl(p_rec.abs_information17, hr_api.g_varchar2) or
2970: nvl(per_abs_shd.g_old_rec.abs_information18, hr_api.g_varchar2) <>
2971: nvl(p_rec.abs_information18, hr_api.g_varchar2) or
2972: nvl(per_abs_shd.g_old_rec.abs_information19, hr_api.g_varchar2) <>
2973: nvl(p_rec.abs_information19, hr_api.g_varchar2) or

Line 2970: nvl(per_abs_shd.g_old_rec.abs_information18, hr_api.g_varchar2) <>

2966: nvl(per_abs_shd.g_old_rec.abs_information16, hr_api.g_varchar2) <>
2967: nvl(p_rec.abs_information16, hr_api.g_varchar2) or
2968: nvl(per_abs_shd.g_old_rec.abs_information17, hr_api.g_varchar2) <>
2969: nvl(p_rec.abs_information17, hr_api.g_varchar2) or
2970: nvl(per_abs_shd.g_old_rec.abs_information18, hr_api.g_varchar2) <>
2971: nvl(p_rec.abs_information18, hr_api.g_varchar2) or
2972: nvl(per_abs_shd.g_old_rec.abs_information19, hr_api.g_varchar2) <>
2973: nvl(p_rec.abs_information19, hr_api.g_varchar2) or
2974: nvl(per_abs_shd.g_old_rec.abs_information20, hr_api.g_varchar2) <>

Line 2971: nvl(p_rec.abs_information18, hr_api.g_varchar2) or

2967: nvl(p_rec.abs_information16, hr_api.g_varchar2) or
2968: nvl(per_abs_shd.g_old_rec.abs_information17, hr_api.g_varchar2) <>
2969: nvl(p_rec.abs_information17, hr_api.g_varchar2) or
2970: nvl(per_abs_shd.g_old_rec.abs_information18, hr_api.g_varchar2) <>
2971: nvl(p_rec.abs_information18, hr_api.g_varchar2) or
2972: nvl(per_abs_shd.g_old_rec.abs_information19, hr_api.g_varchar2) <>
2973: nvl(p_rec.abs_information19, hr_api.g_varchar2) or
2974: nvl(per_abs_shd.g_old_rec.abs_information20, hr_api.g_varchar2) <>
2975: nvl(p_rec.abs_information20, hr_api.g_varchar2) or

Line 2972: nvl(per_abs_shd.g_old_rec.abs_information19, hr_api.g_varchar2) <>

2968: nvl(per_abs_shd.g_old_rec.abs_information17, hr_api.g_varchar2) <>
2969: nvl(p_rec.abs_information17, hr_api.g_varchar2) or
2970: nvl(per_abs_shd.g_old_rec.abs_information18, hr_api.g_varchar2) <>
2971: nvl(p_rec.abs_information18, hr_api.g_varchar2) or
2972: nvl(per_abs_shd.g_old_rec.abs_information19, hr_api.g_varchar2) <>
2973: nvl(p_rec.abs_information19, hr_api.g_varchar2) or
2974: nvl(per_abs_shd.g_old_rec.abs_information20, hr_api.g_varchar2) <>
2975: nvl(p_rec.abs_information20, hr_api.g_varchar2) or
2976: nvl(per_abs_shd.g_old_rec.abs_information21, hr_api.g_varchar2) <>

Line 2973: nvl(p_rec.abs_information19, hr_api.g_varchar2) or

2969: nvl(p_rec.abs_information17, hr_api.g_varchar2) or
2970: nvl(per_abs_shd.g_old_rec.abs_information18, hr_api.g_varchar2) <>
2971: nvl(p_rec.abs_information18, hr_api.g_varchar2) or
2972: nvl(per_abs_shd.g_old_rec.abs_information19, hr_api.g_varchar2) <>
2973: nvl(p_rec.abs_information19, hr_api.g_varchar2) or
2974: nvl(per_abs_shd.g_old_rec.abs_information20, hr_api.g_varchar2) <>
2975: nvl(p_rec.abs_information20, hr_api.g_varchar2) or
2976: nvl(per_abs_shd.g_old_rec.abs_information21, hr_api.g_varchar2) <>
2977: nvl(p_rec.abs_information21, hr_api.g_varchar2) or

Line 2974: nvl(per_abs_shd.g_old_rec.abs_information20, hr_api.g_varchar2) <>

2970: nvl(per_abs_shd.g_old_rec.abs_information18, hr_api.g_varchar2) <>
2971: nvl(p_rec.abs_information18, hr_api.g_varchar2) or
2972: nvl(per_abs_shd.g_old_rec.abs_information19, hr_api.g_varchar2) <>
2973: nvl(p_rec.abs_information19, hr_api.g_varchar2) or
2974: nvl(per_abs_shd.g_old_rec.abs_information20, hr_api.g_varchar2) <>
2975: nvl(p_rec.abs_information20, hr_api.g_varchar2) or
2976: nvl(per_abs_shd.g_old_rec.abs_information21, hr_api.g_varchar2) <>
2977: nvl(p_rec.abs_information21, hr_api.g_varchar2) or
2978: nvl(per_abs_shd.g_old_rec.abs_information22, hr_api.g_varchar2) <>

Line 2975: nvl(p_rec.abs_information20, hr_api.g_varchar2) or

2971: nvl(p_rec.abs_information18, hr_api.g_varchar2) or
2972: nvl(per_abs_shd.g_old_rec.abs_information19, hr_api.g_varchar2) <>
2973: nvl(p_rec.abs_information19, hr_api.g_varchar2) or
2974: nvl(per_abs_shd.g_old_rec.abs_information20, hr_api.g_varchar2) <>
2975: nvl(p_rec.abs_information20, hr_api.g_varchar2) or
2976: nvl(per_abs_shd.g_old_rec.abs_information21, hr_api.g_varchar2) <>
2977: nvl(p_rec.abs_information21, hr_api.g_varchar2) or
2978: nvl(per_abs_shd.g_old_rec.abs_information22, hr_api.g_varchar2) <>
2979: nvl(p_rec.abs_information22, hr_api.g_varchar2) or

Line 2976: nvl(per_abs_shd.g_old_rec.abs_information21, hr_api.g_varchar2) <>

2972: nvl(per_abs_shd.g_old_rec.abs_information19, hr_api.g_varchar2) <>
2973: nvl(p_rec.abs_information19, hr_api.g_varchar2) or
2974: nvl(per_abs_shd.g_old_rec.abs_information20, hr_api.g_varchar2) <>
2975: nvl(p_rec.abs_information20, hr_api.g_varchar2) or
2976: nvl(per_abs_shd.g_old_rec.abs_information21, hr_api.g_varchar2) <>
2977: nvl(p_rec.abs_information21, hr_api.g_varchar2) or
2978: nvl(per_abs_shd.g_old_rec.abs_information22, hr_api.g_varchar2) <>
2979: nvl(p_rec.abs_information22, hr_api.g_varchar2) or
2980: nvl(per_abs_shd.g_old_rec.abs_information23, hr_api.g_varchar2) <>

Line 2977: nvl(p_rec.abs_information21, hr_api.g_varchar2) or

2973: nvl(p_rec.abs_information19, hr_api.g_varchar2) or
2974: nvl(per_abs_shd.g_old_rec.abs_information20, hr_api.g_varchar2) <>
2975: nvl(p_rec.abs_information20, hr_api.g_varchar2) or
2976: nvl(per_abs_shd.g_old_rec.abs_information21, hr_api.g_varchar2) <>
2977: nvl(p_rec.abs_information21, hr_api.g_varchar2) or
2978: nvl(per_abs_shd.g_old_rec.abs_information22, hr_api.g_varchar2) <>
2979: nvl(p_rec.abs_information22, hr_api.g_varchar2) or
2980: nvl(per_abs_shd.g_old_rec.abs_information23, hr_api.g_varchar2) <>
2981: nvl(p_rec.abs_information23, hr_api.g_varchar2) or

Line 2978: nvl(per_abs_shd.g_old_rec.abs_information22, hr_api.g_varchar2) <>

2974: nvl(per_abs_shd.g_old_rec.abs_information20, hr_api.g_varchar2) <>
2975: nvl(p_rec.abs_information20, hr_api.g_varchar2) or
2976: nvl(per_abs_shd.g_old_rec.abs_information21, hr_api.g_varchar2) <>
2977: nvl(p_rec.abs_information21, hr_api.g_varchar2) or
2978: nvl(per_abs_shd.g_old_rec.abs_information22, hr_api.g_varchar2) <>
2979: nvl(p_rec.abs_information22, hr_api.g_varchar2) or
2980: nvl(per_abs_shd.g_old_rec.abs_information23, hr_api.g_varchar2) <>
2981: nvl(p_rec.abs_information23, hr_api.g_varchar2) or
2982: nvl(per_abs_shd.g_old_rec.abs_information24, hr_api.g_varchar2) <>

Line 2979: nvl(p_rec.abs_information22, hr_api.g_varchar2) or

2975: nvl(p_rec.abs_information20, hr_api.g_varchar2) or
2976: nvl(per_abs_shd.g_old_rec.abs_information21, hr_api.g_varchar2) <>
2977: nvl(p_rec.abs_information21, hr_api.g_varchar2) or
2978: nvl(per_abs_shd.g_old_rec.abs_information22, hr_api.g_varchar2) <>
2979: nvl(p_rec.abs_information22, hr_api.g_varchar2) or
2980: nvl(per_abs_shd.g_old_rec.abs_information23, hr_api.g_varchar2) <>
2981: nvl(p_rec.abs_information23, hr_api.g_varchar2) or
2982: nvl(per_abs_shd.g_old_rec.abs_information24, hr_api.g_varchar2) <>
2983: nvl(p_rec.abs_information24, hr_api.g_varchar2) or

Line 2980: nvl(per_abs_shd.g_old_rec.abs_information23, hr_api.g_varchar2) <>

2976: nvl(per_abs_shd.g_old_rec.abs_information21, hr_api.g_varchar2) <>
2977: nvl(p_rec.abs_information21, hr_api.g_varchar2) or
2978: nvl(per_abs_shd.g_old_rec.abs_information22, hr_api.g_varchar2) <>
2979: nvl(p_rec.abs_information22, hr_api.g_varchar2) or
2980: nvl(per_abs_shd.g_old_rec.abs_information23, hr_api.g_varchar2) <>
2981: nvl(p_rec.abs_information23, hr_api.g_varchar2) or
2982: nvl(per_abs_shd.g_old_rec.abs_information24, hr_api.g_varchar2) <>
2983: nvl(p_rec.abs_information24, hr_api.g_varchar2) or
2984: nvl(per_abs_shd.g_old_rec.abs_information25, hr_api.g_varchar2) <>

Line 2981: nvl(p_rec.abs_information23, hr_api.g_varchar2) or

2977: nvl(p_rec.abs_information21, hr_api.g_varchar2) or
2978: nvl(per_abs_shd.g_old_rec.abs_information22, hr_api.g_varchar2) <>
2979: nvl(p_rec.abs_information22, hr_api.g_varchar2) or
2980: nvl(per_abs_shd.g_old_rec.abs_information23, hr_api.g_varchar2) <>
2981: nvl(p_rec.abs_information23, hr_api.g_varchar2) or
2982: nvl(per_abs_shd.g_old_rec.abs_information24, hr_api.g_varchar2) <>
2983: nvl(p_rec.abs_information24, hr_api.g_varchar2) or
2984: nvl(per_abs_shd.g_old_rec.abs_information25, hr_api.g_varchar2) <>
2985: nvl(p_rec.abs_information25, hr_api.g_varchar2) or

Line 2982: nvl(per_abs_shd.g_old_rec.abs_information24, hr_api.g_varchar2) <>

2978: nvl(per_abs_shd.g_old_rec.abs_information22, hr_api.g_varchar2) <>
2979: nvl(p_rec.abs_information22, hr_api.g_varchar2) or
2980: nvl(per_abs_shd.g_old_rec.abs_information23, hr_api.g_varchar2) <>
2981: nvl(p_rec.abs_information23, hr_api.g_varchar2) or
2982: nvl(per_abs_shd.g_old_rec.abs_information24, hr_api.g_varchar2) <>
2983: nvl(p_rec.abs_information24, hr_api.g_varchar2) or
2984: nvl(per_abs_shd.g_old_rec.abs_information25, hr_api.g_varchar2) <>
2985: nvl(p_rec.abs_information25, hr_api.g_varchar2) or
2986: nvl(per_abs_shd.g_old_rec.abs_information26, hr_api.g_varchar2) <>

Line 2983: nvl(p_rec.abs_information24, hr_api.g_varchar2) or

2979: nvl(p_rec.abs_information22, hr_api.g_varchar2) or
2980: nvl(per_abs_shd.g_old_rec.abs_information23, hr_api.g_varchar2) <>
2981: nvl(p_rec.abs_information23, hr_api.g_varchar2) or
2982: nvl(per_abs_shd.g_old_rec.abs_information24, hr_api.g_varchar2) <>
2983: nvl(p_rec.abs_information24, hr_api.g_varchar2) or
2984: nvl(per_abs_shd.g_old_rec.abs_information25, hr_api.g_varchar2) <>
2985: nvl(p_rec.abs_information25, hr_api.g_varchar2) or
2986: nvl(per_abs_shd.g_old_rec.abs_information26, hr_api.g_varchar2) <>
2987: nvl(p_rec.abs_information26, hr_api.g_varchar2) or

Line 2984: nvl(per_abs_shd.g_old_rec.abs_information25, hr_api.g_varchar2) <>

2980: nvl(per_abs_shd.g_old_rec.abs_information23, hr_api.g_varchar2) <>
2981: nvl(p_rec.abs_information23, hr_api.g_varchar2) or
2982: nvl(per_abs_shd.g_old_rec.abs_information24, hr_api.g_varchar2) <>
2983: nvl(p_rec.abs_information24, hr_api.g_varchar2) or
2984: nvl(per_abs_shd.g_old_rec.abs_information25, hr_api.g_varchar2) <>
2985: nvl(p_rec.abs_information25, hr_api.g_varchar2) or
2986: nvl(per_abs_shd.g_old_rec.abs_information26, hr_api.g_varchar2) <>
2987: nvl(p_rec.abs_information26, hr_api.g_varchar2) or
2988: nvl(per_abs_shd.g_old_rec.abs_information27, hr_api.g_varchar2) <>

Line 2985: nvl(p_rec.abs_information25, hr_api.g_varchar2) or

2981: nvl(p_rec.abs_information23, hr_api.g_varchar2) or
2982: nvl(per_abs_shd.g_old_rec.abs_information24, hr_api.g_varchar2) <>
2983: nvl(p_rec.abs_information24, hr_api.g_varchar2) or
2984: nvl(per_abs_shd.g_old_rec.abs_information25, hr_api.g_varchar2) <>
2985: nvl(p_rec.abs_information25, hr_api.g_varchar2) or
2986: nvl(per_abs_shd.g_old_rec.abs_information26, hr_api.g_varchar2) <>
2987: nvl(p_rec.abs_information26, hr_api.g_varchar2) or
2988: nvl(per_abs_shd.g_old_rec.abs_information27, hr_api.g_varchar2) <>
2989: nvl(p_rec.abs_information27, hr_api.g_varchar2) or

Line 2986: nvl(per_abs_shd.g_old_rec.abs_information26, hr_api.g_varchar2) <>

2982: nvl(per_abs_shd.g_old_rec.abs_information24, hr_api.g_varchar2) <>
2983: nvl(p_rec.abs_information24, hr_api.g_varchar2) or
2984: nvl(per_abs_shd.g_old_rec.abs_information25, hr_api.g_varchar2) <>
2985: nvl(p_rec.abs_information25, hr_api.g_varchar2) or
2986: nvl(per_abs_shd.g_old_rec.abs_information26, hr_api.g_varchar2) <>
2987: nvl(p_rec.abs_information26, hr_api.g_varchar2) or
2988: nvl(per_abs_shd.g_old_rec.abs_information27, hr_api.g_varchar2) <>
2989: nvl(p_rec.abs_information27, hr_api.g_varchar2) or
2990: nvl(per_abs_shd.g_old_rec.abs_information28, hr_api.g_varchar2) <>

Line 2987: nvl(p_rec.abs_information26, hr_api.g_varchar2) or

2983: nvl(p_rec.abs_information24, hr_api.g_varchar2) or
2984: nvl(per_abs_shd.g_old_rec.abs_information25, hr_api.g_varchar2) <>
2985: nvl(p_rec.abs_information25, hr_api.g_varchar2) or
2986: nvl(per_abs_shd.g_old_rec.abs_information26, hr_api.g_varchar2) <>
2987: nvl(p_rec.abs_information26, hr_api.g_varchar2) or
2988: nvl(per_abs_shd.g_old_rec.abs_information27, hr_api.g_varchar2) <>
2989: nvl(p_rec.abs_information27, hr_api.g_varchar2) or
2990: nvl(per_abs_shd.g_old_rec.abs_information28, hr_api.g_varchar2) <>
2991: nvl(p_rec.abs_information28, hr_api.g_varchar2) or

Line 2988: nvl(per_abs_shd.g_old_rec.abs_information27, hr_api.g_varchar2) <>

2984: nvl(per_abs_shd.g_old_rec.abs_information25, hr_api.g_varchar2) <>
2985: nvl(p_rec.abs_information25, hr_api.g_varchar2) or
2986: nvl(per_abs_shd.g_old_rec.abs_information26, hr_api.g_varchar2) <>
2987: nvl(p_rec.abs_information26, hr_api.g_varchar2) or
2988: nvl(per_abs_shd.g_old_rec.abs_information27, hr_api.g_varchar2) <>
2989: nvl(p_rec.abs_information27, hr_api.g_varchar2) or
2990: nvl(per_abs_shd.g_old_rec.abs_information28, hr_api.g_varchar2) <>
2991: nvl(p_rec.abs_information28, hr_api.g_varchar2) or
2992: nvl(per_abs_shd.g_old_rec.abs_information29, hr_api.g_varchar2) <>

Line 2989: nvl(p_rec.abs_information27, hr_api.g_varchar2) or

2985: nvl(p_rec.abs_information25, hr_api.g_varchar2) or
2986: nvl(per_abs_shd.g_old_rec.abs_information26, hr_api.g_varchar2) <>
2987: nvl(p_rec.abs_information26, hr_api.g_varchar2) or
2988: nvl(per_abs_shd.g_old_rec.abs_information27, hr_api.g_varchar2) <>
2989: nvl(p_rec.abs_information27, hr_api.g_varchar2) or
2990: nvl(per_abs_shd.g_old_rec.abs_information28, hr_api.g_varchar2) <>
2991: nvl(p_rec.abs_information28, hr_api.g_varchar2) or
2992: nvl(per_abs_shd.g_old_rec.abs_information29, hr_api.g_varchar2) <>
2993: nvl(p_rec.abs_information29, hr_api.g_varchar2) or

Line 2990: nvl(per_abs_shd.g_old_rec.abs_information28, hr_api.g_varchar2) <>

2986: nvl(per_abs_shd.g_old_rec.abs_information26, hr_api.g_varchar2) <>
2987: nvl(p_rec.abs_information26, hr_api.g_varchar2) or
2988: nvl(per_abs_shd.g_old_rec.abs_information27, hr_api.g_varchar2) <>
2989: nvl(p_rec.abs_information27, hr_api.g_varchar2) or
2990: nvl(per_abs_shd.g_old_rec.abs_information28, hr_api.g_varchar2) <>
2991: nvl(p_rec.abs_information28, hr_api.g_varchar2) or
2992: nvl(per_abs_shd.g_old_rec.abs_information29, hr_api.g_varchar2) <>
2993: nvl(p_rec.abs_information29, hr_api.g_varchar2) or
2994: nvl(per_abs_shd.g_old_rec.abs_information30, hr_api.g_varchar2) <>

Line 2991: nvl(p_rec.abs_information28, hr_api.g_varchar2) or

2987: nvl(p_rec.abs_information26, hr_api.g_varchar2) or
2988: nvl(per_abs_shd.g_old_rec.abs_information27, hr_api.g_varchar2) <>
2989: nvl(p_rec.abs_information27, hr_api.g_varchar2) or
2990: nvl(per_abs_shd.g_old_rec.abs_information28, hr_api.g_varchar2) <>
2991: nvl(p_rec.abs_information28, hr_api.g_varchar2) or
2992: nvl(per_abs_shd.g_old_rec.abs_information29, hr_api.g_varchar2) <>
2993: nvl(p_rec.abs_information29, hr_api.g_varchar2) or
2994: nvl(per_abs_shd.g_old_rec.abs_information30, hr_api.g_varchar2) <>
2995: nvl(p_rec.abs_information30, hr_api.g_varchar2) ))

Line 2992: nvl(per_abs_shd.g_old_rec.abs_information29, hr_api.g_varchar2) <>

2988: nvl(per_abs_shd.g_old_rec.abs_information27, hr_api.g_varchar2) <>
2989: nvl(p_rec.abs_information27, hr_api.g_varchar2) or
2990: nvl(per_abs_shd.g_old_rec.abs_information28, hr_api.g_varchar2) <>
2991: nvl(p_rec.abs_information28, hr_api.g_varchar2) or
2992: nvl(per_abs_shd.g_old_rec.abs_information29, hr_api.g_varchar2) <>
2993: nvl(p_rec.abs_information29, hr_api.g_varchar2) or
2994: nvl(per_abs_shd.g_old_rec.abs_information30, hr_api.g_varchar2) <>
2995: nvl(p_rec.abs_information30, hr_api.g_varchar2) ))
2996: or (p_rec.absence_attendance_id is null) then

Line 2993: nvl(p_rec.abs_information29, hr_api.g_varchar2) or

2989: nvl(p_rec.abs_information27, hr_api.g_varchar2) or
2990: nvl(per_abs_shd.g_old_rec.abs_information28, hr_api.g_varchar2) <>
2991: nvl(p_rec.abs_information28, hr_api.g_varchar2) or
2992: nvl(per_abs_shd.g_old_rec.abs_information29, hr_api.g_varchar2) <>
2993: nvl(p_rec.abs_information29, hr_api.g_varchar2) or
2994: nvl(per_abs_shd.g_old_rec.abs_information30, hr_api.g_varchar2) <>
2995: nvl(p_rec.abs_information30, hr_api.g_varchar2) ))
2996: or (p_rec.absence_attendance_id is null) then
2997: --

Line 2994: nvl(per_abs_shd.g_old_rec.abs_information30, hr_api.g_varchar2) <>

2990: nvl(per_abs_shd.g_old_rec.abs_information28, hr_api.g_varchar2) <>
2991: nvl(p_rec.abs_information28, hr_api.g_varchar2) or
2992: nvl(per_abs_shd.g_old_rec.abs_information29, hr_api.g_varchar2) <>
2993: nvl(p_rec.abs_information29, hr_api.g_varchar2) or
2994: nvl(per_abs_shd.g_old_rec.abs_information30, hr_api.g_varchar2) <>
2995: nvl(p_rec.abs_information30, hr_api.g_varchar2) ))
2996: or (p_rec.absence_attendance_id is null) then
2997: --
2998: -- Only execute the validation if absolutely necessary:

Line 2995: nvl(p_rec.abs_information30, hr_api.g_varchar2) ))

2991: nvl(p_rec.abs_information28, hr_api.g_varchar2) or
2992: nvl(per_abs_shd.g_old_rec.abs_information29, hr_api.g_varchar2) <>
2993: nvl(p_rec.abs_information29, hr_api.g_varchar2) or
2994: nvl(per_abs_shd.g_old_rec.abs_information30, hr_api.g_varchar2) <>
2995: nvl(p_rec.abs_information30, hr_api.g_varchar2) ))
2996: or (p_rec.absence_attendance_id is null) then
2997: --
2998: -- Only execute the validation if absolutely necessary:
2999: -- a) During update, the structure column value or any

Line 3112: nvl(per_abs_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

3108: begin
3109: hr_utility.set_location('Entering:'||l_proc,10);
3110: --
3111: if ((p_rec.absence_attendance_id is not null) and (
3112: nvl(per_abs_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
3113: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
3114: nvl(per_abs_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
3115: nvl(p_rec.attribute1, hr_api.g_varchar2) or
3116: nvl(per_abs_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

Line 3113: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

3109: hr_utility.set_location('Entering:'||l_proc,10);
3110: --
3111: if ((p_rec.absence_attendance_id is not null) and (
3112: nvl(per_abs_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
3113: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
3114: nvl(per_abs_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
3115: nvl(p_rec.attribute1, hr_api.g_varchar2) or
3116: nvl(per_abs_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
3117: nvl(p_rec.attribute2, hr_api.g_varchar2) or

Line 3114: nvl(per_abs_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

3110: --
3111: if ((p_rec.absence_attendance_id is not null) and (
3112: nvl(per_abs_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
3113: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
3114: nvl(per_abs_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
3115: nvl(p_rec.attribute1, hr_api.g_varchar2) or
3116: nvl(per_abs_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
3117: nvl(p_rec.attribute2, hr_api.g_varchar2) or
3118: nvl(per_abs_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

Line 3115: nvl(p_rec.attribute1, hr_api.g_varchar2) or

3111: if ((p_rec.absence_attendance_id is not null) and (
3112: nvl(per_abs_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
3113: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
3114: nvl(per_abs_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
3115: nvl(p_rec.attribute1, hr_api.g_varchar2) or
3116: nvl(per_abs_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
3117: nvl(p_rec.attribute2, hr_api.g_varchar2) or
3118: nvl(per_abs_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
3119: nvl(p_rec.attribute3, hr_api.g_varchar2) or

Line 3116: nvl(per_abs_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

3112: nvl(per_abs_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
3113: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
3114: nvl(per_abs_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
3115: nvl(p_rec.attribute1, hr_api.g_varchar2) or
3116: nvl(per_abs_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
3117: nvl(p_rec.attribute2, hr_api.g_varchar2) or
3118: nvl(per_abs_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
3119: nvl(p_rec.attribute3, hr_api.g_varchar2) or
3120: nvl(per_abs_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

Line 3117: nvl(p_rec.attribute2, hr_api.g_varchar2) or

3113: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
3114: nvl(per_abs_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
3115: nvl(p_rec.attribute1, hr_api.g_varchar2) or
3116: nvl(per_abs_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
3117: nvl(p_rec.attribute2, hr_api.g_varchar2) or
3118: nvl(per_abs_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
3119: nvl(p_rec.attribute3, hr_api.g_varchar2) or
3120: nvl(per_abs_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
3121: nvl(p_rec.attribute4, hr_api.g_varchar2) or

Line 3118: nvl(per_abs_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

3114: nvl(per_abs_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
3115: nvl(p_rec.attribute1, hr_api.g_varchar2) or
3116: nvl(per_abs_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
3117: nvl(p_rec.attribute2, hr_api.g_varchar2) or
3118: nvl(per_abs_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
3119: nvl(p_rec.attribute3, hr_api.g_varchar2) or
3120: nvl(per_abs_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
3121: nvl(p_rec.attribute4, hr_api.g_varchar2) or
3122: nvl(per_abs_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

Line 3119: nvl(p_rec.attribute3, hr_api.g_varchar2) or

3115: nvl(p_rec.attribute1, hr_api.g_varchar2) or
3116: nvl(per_abs_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
3117: nvl(p_rec.attribute2, hr_api.g_varchar2) or
3118: nvl(per_abs_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
3119: nvl(p_rec.attribute3, hr_api.g_varchar2) or
3120: nvl(per_abs_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
3121: nvl(p_rec.attribute4, hr_api.g_varchar2) or
3122: nvl(per_abs_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
3123: nvl(p_rec.attribute5, hr_api.g_varchar2) or

Line 3120: nvl(per_abs_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

3116: nvl(per_abs_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
3117: nvl(p_rec.attribute2, hr_api.g_varchar2) or
3118: nvl(per_abs_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
3119: nvl(p_rec.attribute3, hr_api.g_varchar2) or
3120: nvl(per_abs_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
3121: nvl(p_rec.attribute4, hr_api.g_varchar2) or
3122: nvl(per_abs_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
3123: nvl(p_rec.attribute5, hr_api.g_varchar2) or
3124: nvl(per_abs_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

Line 3121: nvl(p_rec.attribute4, hr_api.g_varchar2) or

3117: nvl(p_rec.attribute2, hr_api.g_varchar2) or
3118: nvl(per_abs_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
3119: nvl(p_rec.attribute3, hr_api.g_varchar2) or
3120: nvl(per_abs_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
3121: nvl(p_rec.attribute4, hr_api.g_varchar2) or
3122: nvl(per_abs_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
3123: nvl(p_rec.attribute5, hr_api.g_varchar2) or
3124: nvl(per_abs_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
3125: nvl(p_rec.attribute6, hr_api.g_varchar2) or

Line 3122: nvl(per_abs_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

3118: nvl(per_abs_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
3119: nvl(p_rec.attribute3, hr_api.g_varchar2) or
3120: nvl(per_abs_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
3121: nvl(p_rec.attribute4, hr_api.g_varchar2) or
3122: nvl(per_abs_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
3123: nvl(p_rec.attribute5, hr_api.g_varchar2) or
3124: nvl(per_abs_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
3125: nvl(p_rec.attribute6, hr_api.g_varchar2) or
3126: nvl(per_abs_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

Line 3123: nvl(p_rec.attribute5, hr_api.g_varchar2) or

3119: nvl(p_rec.attribute3, hr_api.g_varchar2) or
3120: nvl(per_abs_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
3121: nvl(p_rec.attribute4, hr_api.g_varchar2) or
3122: nvl(per_abs_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
3123: nvl(p_rec.attribute5, hr_api.g_varchar2) or
3124: nvl(per_abs_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
3125: nvl(p_rec.attribute6, hr_api.g_varchar2) or
3126: nvl(per_abs_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
3127: nvl(p_rec.attribute7, hr_api.g_varchar2) or

Line 3124: nvl(per_abs_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

3120: nvl(per_abs_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
3121: nvl(p_rec.attribute4, hr_api.g_varchar2) or
3122: nvl(per_abs_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
3123: nvl(p_rec.attribute5, hr_api.g_varchar2) or
3124: nvl(per_abs_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
3125: nvl(p_rec.attribute6, hr_api.g_varchar2) or
3126: nvl(per_abs_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
3127: nvl(p_rec.attribute7, hr_api.g_varchar2) or
3128: nvl(per_abs_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

Line 3125: nvl(p_rec.attribute6, hr_api.g_varchar2) or

3121: nvl(p_rec.attribute4, hr_api.g_varchar2) or
3122: nvl(per_abs_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
3123: nvl(p_rec.attribute5, hr_api.g_varchar2) or
3124: nvl(per_abs_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
3125: nvl(p_rec.attribute6, hr_api.g_varchar2) or
3126: nvl(per_abs_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
3127: nvl(p_rec.attribute7, hr_api.g_varchar2) or
3128: nvl(per_abs_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
3129: nvl(p_rec.attribute8, hr_api.g_varchar2) or

Line 3126: nvl(per_abs_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

3122: nvl(per_abs_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
3123: nvl(p_rec.attribute5, hr_api.g_varchar2) or
3124: nvl(per_abs_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
3125: nvl(p_rec.attribute6, hr_api.g_varchar2) or
3126: nvl(per_abs_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
3127: nvl(p_rec.attribute7, hr_api.g_varchar2) or
3128: nvl(per_abs_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
3129: nvl(p_rec.attribute8, hr_api.g_varchar2) or
3130: nvl(per_abs_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

Line 3127: nvl(p_rec.attribute7, hr_api.g_varchar2) or

3123: nvl(p_rec.attribute5, hr_api.g_varchar2) or
3124: nvl(per_abs_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
3125: nvl(p_rec.attribute6, hr_api.g_varchar2) or
3126: nvl(per_abs_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
3127: nvl(p_rec.attribute7, hr_api.g_varchar2) or
3128: nvl(per_abs_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
3129: nvl(p_rec.attribute8, hr_api.g_varchar2) or
3130: nvl(per_abs_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
3131: nvl(p_rec.attribute9, hr_api.g_varchar2) or

Line 3128: nvl(per_abs_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

3124: nvl(per_abs_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
3125: nvl(p_rec.attribute6, hr_api.g_varchar2) or
3126: nvl(per_abs_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
3127: nvl(p_rec.attribute7, hr_api.g_varchar2) or
3128: nvl(per_abs_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
3129: nvl(p_rec.attribute8, hr_api.g_varchar2) or
3130: nvl(per_abs_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
3131: nvl(p_rec.attribute9, hr_api.g_varchar2) or
3132: nvl(per_abs_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

Line 3129: nvl(p_rec.attribute8, hr_api.g_varchar2) or

3125: nvl(p_rec.attribute6, hr_api.g_varchar2) or
3126: nvl(per_abs_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
3127: nvl(p_rec.attribute7, hr_api.g_varchar2) or
3128: nvl(per_abs_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
3129: nvl(p_rec.attribute8, hr_api.g_varchar2) or
3130: nvl(per_abs_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
3131: nvl(p_rec.attribute9, hr_api.g_varchar2) or
3132: nvl(per_abs_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
3133: nvl(p_rec.attribute10, hr_api.g_varchar2) or

Line 3130: nvl(per_abs_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

3126: nvl(per_abs_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
3127: nvl(p_rec.attribute7, hr_api.g_varchar2) or
3128: nvl(per_abs_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
3129: nvl(p_rec.attribute8, hr_api.g_varchar2) or
3130: nvl(per_abs_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
3131: nvl(p_rec.attribute9, hr_api.g_varchar2) or
3132: nvl(per_abs_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
3133: nvl(p_rec.attribute10, hr_api.g_varchar2) or
3134: nvl(per_abs_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

Line 3131: nvl(p_rec.attribute9, hr_api.g_varchar2) or

3127: nvl(p_rec.attribute7, hr_api.g_varchar2) or
3128: nvl(per_abs_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
3129: nvl(p_rec.attribute8, hr_api.g_varchar2) or
3130: nvl(per_abs_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
3131: nvl(p_rec.attribute9, hr_api.g_varchar2) or
3132: nvl(per_abs_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
3133: nvl(p_rec.attribute10, hr_api.g_varchar2) or
3134: nvl(per_abs_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
3135: nvl(p_rec.attribute11, hr_api.g_varchar2) or

Line 3132: nvl(per_abs_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

3128: nvl(per_abs_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
3129: nvl(p_rec.attribute8, hr_api.g_varchar2) or
3130: nvl(per_abs_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
3131: nvl(p_rec.attribute9, hr_api.g_varchar2) or
3132: nvl(per_abs_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
3133: nvl(p_rec.attribute10, hr_api.g_varchar2) or
3134: nvl(per_abs_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
3135: nvl(p_rec.attribute11, hr_api.g_varchar2) or
3136: nvl(per_abs_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

Line 3133: nvl(p_rec.attribute10, hr_api.g_varchar2) or

3129: nvl(p_rec.attribute8, hr_api.g_varchar2) or
3130: nvl(per_abs_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
3131: nvl(p_rec.attribute9, hr_api.g_varchar2) or
3132: nvl(per_abs_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
3133: nvl(p_rec.attribute10, hr_api.g_varchar2) or
3134: nvl(per_abs_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
3135: nvl(p_rec.attribute11, hr_api.g_varchar2) or
3136: nvl(per_abs_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
3137: nvl(p_rec.attribute12, hr_api.g_varchar2) or

Line 3134: nvl(per_abs_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

3130: nvl(per_abs_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
3131: nvl(p_rec.attribute9, hr_api.g_varchar2) or
3132: nvl(per_abs_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
3133: nvl(p_rec.attribute10, hr_api.g_varchar2) or
3134: nvl(per_abs_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
3135: nvl(p_rec.attribute11, hr_api.g_varchar2) or
3136: nvl(per_abs_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
3137: nvl(p_rec.attribute12, hr_api.g_varchar2) or
3138: nvl(per_abs_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

Line 3135: nvl(p_rec.attribute11, hr_api.g_varchar2) or

3131: nvl(p_rec.attribute9, hr_api.g_varchar2) or
3132: nvl(per_abs_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
3133: nvl(p_rec.attribute10, hr_api.g_varchar2) or
3134: nvl(per_abs_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
3135: nvl(p_rec.attribute11, hr_api.g_varchar2) or
3136: nvl(per_abs_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
3137: nvl(p_rec.attribute12, hr_api.g_varchar2) or
3138: nvl(per_abs_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
3139: nvl(p_rec.attribute13, hr_api.g_varchar2) or

Line 3136: nvl(per_abs_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

3132: nvl(per_abs_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
3133: nvl(p_rec.attribute10, hr_api.g_varchar2) or
3134: nvl(per_abs_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
3135: nvl(p_rec.attribute11, hr_api.g_varchar2) or
3136: nvl(per_abs_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
3137: nvl(p_rec.attribute12, hr_api.g_varchar2) or
3138: nvl(per_abs_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
3139: nvl(p_rec.attribute13, hr_api.g_varchar2) or
3140: nvl(per_abs_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

Line 3137: nvl(p_rec.attribute12, hr_api.g_varchar2) or

3133: nvl(p_rec.attribute10, hr_api.g_varchar2) or
3134: nvl(per_abs_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
3135: nvl(p_rec.attribute11, hr_api.g_varchar2) or
3136: nvl(per_abs_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
3137: nvl(p_rec.attribute12, hr_api.g_varchar2) or
3138: nvl(per_abs_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
3139: nvl(p_rec.attribute13, hr_api.g_varchar2) or
3140: nvl(per_abs_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
3141: nvl(p_rec.attribute14, hr_api.g_varchar2) or

Line 3138: nvl(per_abs_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

3134: nvl(per_abs_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
3135: nvl(p_rec.attribute11, hr_api.g_varchar2) or
3136: nvl(per_abs_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
3137: nvl(p_rec.attribute12, hr_api.g_varchar2) or
3138: nvl(per_abs_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
3139: nvl(p_rec.attribute13, hr_api.g_varchar2) or
3140: nvl(per_abs_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
3141: nvl(p_rec.attribute14, hr_api.g_varchar2) or
3142: nvl(per_abs_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

Line 3139: nvl(p_rec.attribute13, hr_api.g_varchar2) or

3135: nvl(p_rec.attribute11, hr_api.g_varchar2) or
3136: nvl(per_abs_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
3137: nvl(p_rec.attribute12, hr_api.g_varchar2) or
3138: nvl(per_abs_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
3139: nvl(p_rec.attribute13, hr_api.g_varchar2) or
3140: nvl(per_abs_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
3141: nvl(p_rec.attribute14, hr_api.g_varchar2) or
3142: nvl(per_abs_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
3143: nvl(p_rec.attribute15, hr_api.g_varchar2) or

Line 3140: nvl(per_abs_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

3136: nvl(per_abs_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
3137: nvl(p_rec.attribute12, hr_api.g_varchar2) or
3138: nvl(per_abs_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
3139: nvl(p_rec.attribute13, hr_api.g_varchar2) or
3140: nvl(per_abs_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
3141: nvl(p_rec.attribute14, hr_api.g_varchar2) or
3142: nvl(per_abs_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
3143: nvl(p_rec.attribute15, hr_api.g_varchar2) or
3144: nvl(per_abs_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

Line 3141: nvl(p_rec.attribute14, hr_api.g_varchar2) or

3137: nvl(p_rec.attribute12, hr_api.g_varchar2) or
3138: nvl(per_abs_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
3139: nvl(p_rec.attribute13, hr_api.g_varchar2) or
3140: nvl(per_abs_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
3141: nvl(p_rec.attribute14, hr_api.g_varchar2) or
3142: nvl(per_abs_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
3143: nvl(p_rec.attribute15, hr_api.g_varchar2) or
3144: nvl(per_abs_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
3145: nvl(p_rec.attribute16, hr_api.g_varchar2) or

Line 3142: nvl(per_abs_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

3138: nvl(per_abs_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
3139: nvl(p_rec.attribute13, hr_api.g_varchar2) or
3140: nvl(per_abs_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
3141: nvl(p_rec.attribute14, hr_api.g_varchar2) or
3142: nvl(per_abs_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
3143: nvl(p_rec.attribute15, hr_api.g_varchar2) or
3144: nvl(per_abs_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
3145: nvl(p_rec.attribute16, hr_api.g_varchar2) or
3146: nvl(per_abs_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

Line 3143: nvl(p_rec.attribute15, hr_api.g_varchar2) or

3139: nvl(p_rec.attribute13, hr_api.g_varchar2) or
3140: nvl(per_abs_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
3141: nvl(p_rec.attribute14, hr_api.g_varchar2) or
3142: nvl(per_abs_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
3143: nvl(p_rec.attribute15, hr_api.g_varchar2) or
3144: nvl(per_abs_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
3145: nvl(p_rec.attribute16, hr_api.g_varchar2) or
3146: nvl(per_abs_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
3147: nvl(p_rec.attribute17, hr_api.g_varchar2) or

Line 3144: nvl(per_abs_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

3140: nvl(per_abs_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
3141: nvl(p_rec.attribute14, hr_api.g_varchar2) or
3142: nvl(per_abs_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
3143: nvl(p_rec.attribute15, hr_api.g_varchar2) or
3144: nvl(per_abs_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
3145: nvl(p_rec.attribute16, hr_api.g_varchar2) or
3146: nvl(per_abs_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
3147: nvl(p_rec.attribute17, hr_api.g_varchar2) or
3148: nvl(per_abs_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

Line 3145: nvl(p_rec.attribute16, hr_api.g_varchar2) or

3141: nvl(p_rec.attribute14, hr_api.g_varchar2) or
3142: nvl(per_abs_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
3143: nvl(p_rec.attribute15, hr_api.g_varchar2) or
3144: nvl(per_abs_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
3145: nvl(p_rec.attribute16, hr_api.g_varchar2) or
3146: nvl(per_abs_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
3147: nvl(p_rec.attribute17, hr_api.g_varchar2) or
3148: nvl(per_abs_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
3149: nvl(p_rec.attribute18, hr_api.g_varchar2) or

Line 3146: nvl(per_abs_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

3142: nvl(per_abs_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
3143: nvl(p_rec.attribute15, hr_api.g_varchar2) or
3144: nvl(per_abs_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
3145: nvl(p_rec.attribute16, hr_api.g_varchar2) or
3146: nvl(per_abs_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
3147: nvl(p_rec.attribute17, hr_api.g_varchar2) or
3148: nvl(per_abs_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
3149: nvl(p_rec.attribute18, hr_api.g_varchar2) or
3150: nvl(per_abs_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

Line 3147: nvl(p_rec.attribute17, hr_api.g_varchar2) or

3143: nvl(p_rec.attribute15, hr_api.g_varchar2) or
3144: nvl(per_abs_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
3145: nvl(p_rec.attribute16, hr_api.g_varchar2) or
3146: nvl(per_abs_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
3147: nvl(p_rec.attribute17, hr_api.g_varchar2) or
3148: nvl(per_abs_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
3149: nvl(p_rec.attribute18, hr_api.g_varchar2) or
3150: nvl(per_abs_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
3151: nvl(p_rec.attribute19, hr_api.g_varchar2) or

Line 3148: nvl(per_abs_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

3144: nvl(per_abs_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
3145: nvl(p_rec.attribute16, hr_api.g_varchar2) or
3146: nvl(per_abs_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
3147: nvl(p_rec.attribute17, hr_api.g_varchar2) or
3148: nvl(per_abs_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
3149: nvl(p_rec.attribute18, hr_api.g_varchar2) or
3150: nvl(per_abs_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
3151: nvl(p_rec.attribute19, hr_api.g_varchar2) or
3152: nvl(per_abs_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

Line 3149: nvl(p_rec.attribute18, hr_api.g_varchar2) or

3145: nvl(p_rec.attribute16, hr_api.g_varchar2) or
3146: nvl(per_abs_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
3147: nvl(p_rec.attribute17, hr_api.g_varchar2) or
3148: nvl(per_abs_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
3149: nvl(p_rec.attribute18, hr_api.g_varchar2) or
3150: nvl(per_abs_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
3151: nvl(p_rec.attribute19, hr_api.g_varchar2) or
3152: nvl(per_abs_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
3153: nvl(p_rec.attribute20, hr_api.g_varchar2) ))

Line 3150: nvl(per_abs_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

3146: nvl(per_abs_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
3147: nvl(p_rec.attribute17, hr_api.g_varchar2) or
3148: nvl(per_abs_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
3149: nvl(p_rec.attribute18, hr_api.g_varchar2) or
3150: nvl(per_abs_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
3151: nvl(p_rec.attribute19, hr_api.g_varchar2) or
3152: nvl(per_abs_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
3153: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
3154: or (p_rec.absence_attendance_id is null) then

Line 3151: nvl(p_rec.attribute19, hr_api.g_varchar2) or

3147: nvl(p_rec.attribute17, hr_api.g_varchar2) or
3148: nvl(per_abs_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
3149: nvl(p_rec.attribute18, hr_api.g_varchar2) or
3150: nvl(per_abs_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
3151: nvl(p_rec.attribute19, hr_api.g_varchar2) or
3152: nvl(per_abs_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
3153: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
3154: or (p_rec.absence_attendance_id is null) then
3155: --

Line 3152: nvl(per_abs_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

3148: nvl(per_abs_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
3149: nvl(p_rec.attribute18, hr_api.g_varchar2) or
3150: nvl(per_abs_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
3151: nvl(p_rec.attribute19, hr_api.g_varchar2) or
3152: nvl(per_abs_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
3153: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
3154: or (p_rec.absence_attendance_id is null) then
3155: --
3156: -- Only execute the validation if absolutely necessary:

Line 3153: nvl(p_rec.attribute20, hr_api.g_varchar2) ))

3149: nvl(p_rec.attribute18, hr_api.g_varchar2) or
3150: nvl(per_abs_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
3151: nvl(p_rec.attribute19, hr_api.g_varchar2) or
3152: nvl(per_abs_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
3153: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
3154: or (p_rec.absence_attendance_id is null) then
3155: --
3156: -- Only execute the validation if absolutely necessary:
3157: -- a) During update, the structure column value or any

Line 3263: if nvl(p_rec.absence_attendance_id,hr_api.g_number) <>

3259: fnd_message.raise_error;
3260: END IF;
3261: --
3262: hr_utility.set_location(l_proc, 2);
3263: if nvl(p_rec.absence_attendance_id,hr_api.g_number) <>
3264: per_abs_shd.g_old_rec.absence_attendance_id then
3265: l_argument := 'absence_attendance_id';
3266: raise l_error;
3267: end if;

Line 3270: if nvl(p_rec.business_group_id, hr_api.g_number) <>

3266: raise l_error;
3267: end if;
3268: --
3269: hr_utility.set_location(l_proc, 3);
3270: if nvl(p_rec.business_group_id, hr_api.g_number) <>
3271: per_abs_shd.g_old_rec.business_group_id then
3272: l_argument := 'business_group_id';
3273: raise l_error;
3274: end if;

Line 3277: if nvl(p_rec.person_id, hr_api.g_number) <>

3273: raise l_error;
3274: end if;
3275: --
3276: hr_utility.set_location(l_proc, 4);
3277: if nvl(p_rec.person_id, hr_api.g_number) <>
3278: per_abs_shd.g_old_rec.person_id then
3279: l_argument := 'person_id';
3280: raise l_error;
3281: end if;

Line 3284: if nvl(p_rec.absence_attendance_type_id,hr_api.g_number) <>

3280: raise l_error;
3281: end if;
3282: --
3283: hr_utility.set_location(l_proc, 5);
3284: if nvl(p_rec.absence_attendance_type_id,hr_api.g_number) <>
3285: per_abs_shd.g_old_rec.absence_attendance_type_id then
3286: l_argument := 'absence_attendance_type_id';
3287: raise l_error;
3288: end if;

Line 3291: if nvl(p_rec.occurrence,hr_api.g_number) <>

3287: raise l_error;
3288: end if;
3289: --
3290: hr_utility.set_location(l_proc, 6);
3291: if nvl(p_rec.occurrence,hr_api.g_number) <>
3292: per_abs_shd.g_old_rec.occurrence then
3293: l_argument := 'occurrence';
3294: raise l_error;
3295: end if;

Line 3299: hr_api.argument_changed_error

3295: end if;
3296: --
3297: EXCEPTION
3298: WHEN l_error THEN
3299: hr_api.argument_changed_error
3300: (p_api_name => l_proc
3301: ,p_argument => l_argument);
3302: WHEN OTHERS THEN
3303: RAISE;

Line 3354: hr_api.validate_bus_grp_id(p_rec.business_group_id);

3350: -- Fix for bug 3371960 ends here.
3351: --
3352: -- Check the business group id.
3353: --
3354: hr_api.validate_bus_grp_id(p_rec.business_group_id);
3355:
3356: hr_utility.set_location(l_proc, 10);
3357:
3358: ----Check the gender of the person in case of maternity leave bug# 6505054

Line 3515: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

3511: --
3512: per_abs_shd.g_absence_days := p_rec.absence_days;
3513: per_abs_shd.g_absence_hours := p_rec.absence_hours;
3514:
3515: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
3516: --
3517: chk_non_updateable_args
3518: (p_effective_date => p_effective_date
3519: ,p_rec => p_rec