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 PER_ABS_SHD

Line 985: l_api_updating := per_abs_shd.api_updating

981: -- Only proceed with validation if :
982: -- a) The current g_old_rec is current and
983: -- b) The date values have changed
984: --
985: l_api_updating := per_abs_shd.api_updating
986: (p_absence_attendance_id => p_absence_attendance_id
987: ,p_object_version_number => p_object_version_number);
988: --
989: if (l_api_updating

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 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 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 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 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 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 1587: l_api_updating := per_abs_shd.api_updating

1583: -- Only proceed with validation if :
1584: -- a) The current g_old_rec is current and
1585: -- b) The date values have changed
1586: --
1587: l_api_updating := per_abs_shd.api_updating
1588: (p_absence_attendance_id => p_absence_attendance_id
1589: ,p_object_version_number => p_object_version_number);
1590: --
1591: if (l_api_updating

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 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 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 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 1706: l_api_updating := per_abs_shd.api_updating

1702: -- Only proceed with validation if :
1703: -- a) The current g_old_rec is current and
1704: -- b) The date values have changed
1705: --
1706: l_api_updating := per_abs_shd.api_updating
1707: (p_absence_attendance_id => p_absence_attendance_id
1708: ,p_object_version_number => p_object_version_number);
1709: --
1710: if (l_api_updating

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 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 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 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 1821: l_api_updating := per_abs_shd.api_updating

1817: -- Only proceed with validation if :
1818: -- a) The current g_old_rec is current and
1819: -- b) The value for abs_attendance_reason_id has changed
1820: --
1821: l_api_updating := per_abs_shd.api_updating
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,

Line 1825: if (l_api_updating and nvl(per_abs_shd.g_old_rec.abs_attendance_reason_id,

1821: l_api_updating := per_abs_shd.api_updating
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:

Line 2035: l_api_updating := per_abs_shd.api_updating

2031: -- Only proceed with validation if :
2032: -- a) The current g_old_rec is current and
2033: -- b) The date and time values have changed
2034: --
2035: l_api_updating := per_abs_shd.api_updating
2036: (p_absence_attendance_id => p_absence_attendance_id
2037: ,p_object_version_number => p_object_version_number);
2038: --
2039: if (l_api_updating

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 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 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 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 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 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 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 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 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 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 2447: + nvl(per_abs_shd.g_old_rec.absence_hours, 0)

2443: -- included the absence in the calculation of the net entitlement).
2444: --
2445: if l_hours_or_days = 'H' then
2446: l_net_entitlement := l_net_entitlement
2447: + nvl(per_abs_shd.g_old_rec.absence_hours, 0)
2448: - p_absence_hours;
2449:
2450: elsif l_hours_or_days = 'D' then
2451: l_net_entitlement := l_net_entitlement

Line 2452: + nvl(per_abs_shd.g_old_rec.absence_days, 0)

2448: - p_absence_hours;
2449:
2450: elsif l_hours_or_days = 'D' then
2451: l_net_entitlement := l_net_entitlement
2452: + nvl(per_abs_shd.g_old_rec.absence_days, 0)
2453: - p_absence_days;
2454: end if;
2455:
2456: --

Line 2507: nvl(per_abs_shd.g_old_rec.absence_hours, 0) - p_absence_hours < 0

2503: -- being double counted (this would occur during update only).
2504: --
2505: if l_increasing_or_decreasing = 'D'
2506: and (l_running_total_hours +
2507: nvl(per_abs_shd.g_old_rec.absence_hours, 0) - p_absence_hours < 0
2508: or l_running_total_days +
2509: nvl(per_abs_shd.g_old_rec.absence_days, 0) - p_absence_days < 0)
2510: then
2511:

Line 2509: nvl(per_abs_shd.g_old_rec.absence_days, 0) - p_absence_days < 0)

2505: if l_increasing_or_decreasing = 'D'
2506: and (l_running_total_hours +
2507: nvl(per_abs_shd.g_old_rec.absence_hours, 0) - p_absence_hours < 0
2508: or l_running_total_days +
2509: nvl(per_abs_shd.g_old_rec.absence_days, 0) - p_absence_days < 0)
2510: then
2511:
2512: p_exceeds_run_total_warning := TRUE;
2513:

Line 2617: l_api_updating := per_abs_shd.api_updating

2613: -- Only proceed with validation if :
2614: -- a) The current g_old_rec is current and
2615: -- b) The date values have changed
2616: --
2617: l_api_updating := per_abs_shd.api_updating
2618: (p_absence_attendance_id => p_absence_attendance_id
2619: ,p_object_version_number => p_object_version_number);
2620: --
2621: if (l_api_updating

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 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 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 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 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 2720: l_api_updating := per_abs_shd.api_updating

2716: -- Only proceed with validation if :
2717: -- a) The current g_old_rec is current and
2718: -- b) The date values have changed
2719: --
2720: l_api_updating := per_abs_shd.api_updating
2721: (p_absence_attendance_id => p_absence_attendance_id
2722: ,p_object_version_number => p_object_version_number);
2723: --
2724: if (l_api_updating

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 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 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 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 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 2925: (p_rec in per_abs_shd.g_rec_type

2921: --
2922: -- ----------------------------------------------------------------------------
2923: --
2924: procedure chk_ddf
2925: (p_rec in per_abs_shd.g_rec_type
2926: ) is
2927: --
2928: l_proc varchar2(72) := g_package || 'chk_ddf';
2929: --

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 3103: (p_rec in per_abs_shd.g_rec_type

3099: --
3100: -- ----------------------------------------------------------------------------
3101: --
3102: procedure chk_df
3103: (p_rec in per_abs_shd.g_rec_type
3104: ) is
3105: --
3106: l_proc varchar2(72) := g_package || 'chk_df';
3107: --

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 3240: ,p_rec in per_abs_shd.g_rec_type

3236: -- {End Of Comments}
3237: -- ----------------------------------------------------------------------------
3238: Procedure chk_non_updateable_args
3239: (p_effective_date in date
3240: ,p_rec in per_abs_shd.g_rec_type
3241: ) IS
3242: --
3243: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
3244: l_error EXCEPTION;

Line 3252: IF NOT per_abs_shd.api_updating

3248: --
3249: -- Only proceed with the validation if a row exists for the current
3250: -- record in the HR Schema.
3251: --
3252: IF NOT per_abs_shd.api_updating
3253: (p_absence_attendance_id => p_rec.absence_attendance_id
3254: ,p_object_version_number => p_rec.object_version_number
3255: ) THEN
3256: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 3264: per_abs_shd.g_old_rec.absence_attendance_id then

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

Line 3271: per_abs_shd.g_old_rec.business_group_id then

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

Line 3278: per_abs_shd.g_old_rec.person_id then

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

Line 3285: per_abs_shd.g_old_rec.absence_attendance_type_id then

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

Line 3292: per_abs_shd.g_old_rec.occurrence then

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

Line 3311: ,p_rec in per_abs_shd.g_rec_type

3307: -- |---------------------------< insert_validate >----------------------------|
3308: -- ----------------------------------------------------------------------------
3309: Procedure insert_validate
3310: (p_effective_date in date
3311: ,p_rec in per_abs_shd.g_rec_type
3312: ,p_dur_dys_less_warning out nocopy boolean
3313: ,p_dur_hrs_less_warning out nocopy boolean
3314: ,p_exceeds_pto_entit_warning out nocopy boolean
3315: ,p_exceeds_run_total_warning out nocopy boolean

Line 3341: per_abs_shd.g_absence_days := p_rec.absence_days;

3337:
3338: --
3339: -- Assign the durations to the global variables.
3340: --
3341: per_abs_shd.g_absence_days := p_rec.absence_days;
3342: per_abs_shd.g_absence_hours := p_rec.absence_hours;
3343:
3344: --
3345: -- Fix for bug 3371960 starts here. Use the l_effective_date

Line 3342: per_abs_shd.g_absence_hours := p_rec.absence_hours;

3338: --
3339: -- Assign the durations to the global variables.
3340: --
3341: per_abs_shd.g_absence_days := p_rec.absence_days;
3342: per_abs_shd.g_absence_hours := p_rec.absence_hours;
3343:
3344: --
3345: -- Fix for bug 3371960 starts here. Use the l_effective_date
3346: -- in chk procedures.

Line 3435: ,p_absence_days => per_abs_shd.g_absence_days

3431: ,p_date_start => p_rec.date_start
3432: ,p_time_start => p_rec.time_start
3433: ,p_date_end => p_rec.date_end
3434: ,p_time_end => p_rec.time_end
3435: ,p_absence_days => per_abs_shd.g_absence_days
3436: ,p_absence_hours => per_abs_shd.g_absence_hours
3437: ,p_dur_dys_less_warning => p_dur_dys_less_warning
3438: ,p_dur_hrs_less_warning => p_dur_hrs_less_warning
3439: ,p_exceeds_pto_entit_warning => p_exceeds_pto_entit_warning

Line 3436: ,p_absence_hours => per_abs_shd.g_absence_hours

3432: ,p_time_start => p_rec.time_start
3433: ,p_date_end => p_rec.date_end
3434: ,p_time_end => p_rec.time_end
3435: ,p_absence_days => per_abs_shd.g_absence_days
3436: ,p_absence_hours => per_abs_shd.g_absence_hours
3437: ,p_dur_dys_less_warning => p_dur_dys_less_warning
3438: ,p_dur_hrs_less_warning => p_dur_hrs_less_warning
3439: ,p_exceeds_pto_entit_warning => p_exceeds_pto_entit_warning
3440: ,p_exceeds_run_total_warning => p_exceeds_run_total_warning

Line 3486: ,p_rec in per_abs_shd.g_rec_type

3482: -- |---------------------------< update_validate >----------------------------|
3483: -- ----------------------------------------------------------------------------
3484: Procedure update_validate
3485: (p_effective_date in date
3486: ,p_rec in per_abs_shd.g_rec_type
3487: ,p_dur_dys_less_warning out nocopy boolean
3488: ,p_dur_hrs_less_warning out nocopy boolean
3489: ,p_exceeds_pto_entit_warning out nocopy boolean
3490: ,p_exceeds_run_total_warning out nocopy boolean

Line 3512: per_abs_shd.g_absence_days := p_rec.absence_days;

3508: -- Fix for bug 3371960 ends here.
3509: --
3510: -- Assign the durations to the global variables.
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: --

Line 3513: per_abs_shd.g_absence_hours := p_rec.absence_hours;

3509: --
3510: -- Assign the durations to the global variables.
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

Line 3589: ,p_absence_days => per_abs_shd.g_absence_days

3585: ,p_date_start => p_rec.date_start
3586: ,p_time_start => p_rec.time_start
3587: ,p_date_end => p_rec.date_end
3588: ,p_time_end => p_rec.time_end
3589: ,p_absence_days => per_abs_shd.g_absence_days
3590: ,p_absence_hours => per_abs_shd.g_absence_hours
3591: ,p_dur_dys_less_warning => p_dur_dys_less_warning
3592: ,p_dur_hrs_less_warning => p_dur_hrs_less_warning
3593: ,p_exceeds_pto_entit_warning => p_exceeds_pto_entit_warning

Line 3590: ,p_absence_hours => per_abs_shd.g_absence_hours

3586: ,p_time_start => p_rec.time_start
3587: ,p_date_end => p_rec.date_end
3588: ,p_time_end => p_rec.time_end
3589: ,p_absence_days => per_abs_shd.g_absence_days
3590: ,p_absence_hours => per_abs_shd.g_absence_hours
3591: ,p_dur_dys_less_warning => p_dur_dys_less_warning
3592: ,p_dur_hrs_less_warning => p_dur_hrs_less_warning
3593: ,p_exceeds_pto_entit_warning => p_exceeds_pto_entit_warning
3594: ,p_exceeds_run_total_warning => p_exceeds_run_total_warning

Line 3639: (p_rec in per_abs_shd.g_rec_type

3635: -- ----------------------------------------------------------------------------
3636: -- |---------------------------< delete_validate >----------------------------|
3637: -- ----------------------------------------------------------------------------
3638: Procedure delete_validate
3639: (p_rec in per_abs_shd.g_rec_type
3640: ) is
3641: --
3642: l_proc varchar2(72) := g_package||'delete_validate';
3643: --