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

1150: -- Only proceed with validation if :
1151: -- a) The current g_old_rec is current and
1152: -- b) The date values have changed
1153: --
1154: l_api_updating := per_abs_shd.api_updating
1155: (p_absence_attendance_id => p_absence_attendance_id
1156: ,p_object_version_number => p_object_version_number);
1157: --
1158: if (l_api_updating

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

1155: (p_absence_attendance_id => p_absence_attendance_id
1156: ,p_object_version_number => p_object_version_number);
1157: --
1158: if (l_api_updating
1159: and nvl(per_abs_shd.g_old_rec.date_start, hr_api.g_date)
1160: = nvl(p_date_start, hr_api.g_date)
1161: and nvl(per_abs_shd.g_old_rec.date_end, hr_api.g_date)
1162: = nvl(p_date_end, hr_api.g_date)
1163: and nvl(per_abs_shd.g_old_rec.time_start, hr_api.g_varchar2)

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

1157: --
1158: if (l_api_updating
1159: and nvl(per_abs_shd.g_old_rec.date_start, hr_api.g_date)
1160: = nvl(p_date_start, hr_api.g_date)
1161: and nvl(per_abs_shd.g_old_rec.date_end, hr_api.g_date)
1162: = nvl(p_date_end, hr_api.g_date)
1163: and nvl(per_abs_shd.g_old_rec.time_start, hr_api.g_varchar2)
1164: = nvl(p_time_start, hr_api.g_varchar2)
1165: and nvl(per_abs_shd.g_old_rec.time_end, hr_api.g_varchar2)

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

1159: and nvl(per_abs_shd.g_old_rec.date_start, hr_api.g_date)
1160: = nvl(p_date_start, hr_api.g_date)
1161: and nvl(per_abs_shd.g_old_rec.date_end, hr_api.g_date)
1162: = nvl(p_date_end, hr_api.g_date)
1163: and nvl(per_abs_shd.g_old_rec.time_start, hr_api.g_varchar2)
1164: = nvl(p_time_start, hr_api.g_varchar2)
1165: and nvl(per_abs_shd.g_old_rec.time_end, hr_api.g_varchar2)
1166: = nvl(p_time_end, hr_api.g_varchar2)
1167: and nvl(per_abs_shd.g_old_rec.absence_days, hr_api.g_number)

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

1161: and nvl(per_abs_shd.g_old_rec.date_end, hr_api.g_date)
1162: = nvl(p_date_end, hr_api.g_date)
1163: and nvl(per_abs_shd.g_old_rec.time_start, hr_api.g_varchar2)
1164: = nvl(p_time_start, hr_api.g_varchar2)
1165: and nvl(per_abs_shd.g_old_rec.time_end, hr_api.g_varchar2)
1166: = nvl(p_time_end, hr_api.g_varchar2)
1167: and nvl(per_abs_shd.g_old_rec.absence_days, hr_api.g_number)
1168: = nvl(p_absence_days, hr_api.g_number)
1169: and nvl(per_abs_shd.g_old_rec.absence_hours, hr_api.g_number)

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

1163: and nvl(per_abs_shd.g_old_rec.time_start, hr_api.g_varchar2)
1164: = nvl(p_time_start, hr_api.g_varchar2)
1165: and nvl(per_abs_shd.g_old_rec.time_end, hr_api.g_varchar2)
1166: = nvl(p_time_end, hr_api.g_varchar2)
1167: and nvl(per_abs_shd.g_old_rec.absence_days, hr_api.g_number)
1168: = nvl(p_absence_days, hr_api.g_number)
1169: and nvl(per_abs_shd.g_old_rec.absence_hours, hr_api.g_number)
1170: = nvl(p_absence_hours, hr_api.g_number)) then
1171: return;

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

1165: and nvl(per_abs_shd.g_old_rec.time_end, hr_api.g_varchar2)
1166: = nvl(p_time_end, hr_api.g_varchar2)
1167: and nvl(per_abs_shd.g_old_rec.absence_days, hr_api.g_number)
1168: = nvl(p_absence_days, hr_api.g_number)
1169: and nvl(per_abs_shd.g_old_rec.absence_hours, hr_api.g_number)
1170: = nvl(p_absence_hours, hr_api.g_number)) then
1171: return;
1172: end if;
1173:

Line 1774: l_api_updating := per_abs_shd.api_updating

1770: -- Only proceed with validation if :
1771: -- a) The current g_old_rec is current and
1772: -- b) The date values have changed
1773: --
1774: l_api_updating := per_abs_shd.api_updating
1775: (p_absence_attendance_id => p_absence_attendance_id
1776: ,p_object_version_number => p_object_version_number);
1777: --
1778: if (l_api_updating

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

1775: (p_absence_attendance_id => p_absence_attendance_id
1776: ,p_object_version_number => p_object_version_number);
1777: --
1778: if (l_api_updating
1779: and nvl(per_abs_shd.g_old_rec.date_projected_start, hr_api.g_date)
1780: = nvl(p_date_projected_start, hr_api.g_date)
1781: and nvl(per_abs_shd.g_old_rec.date_projected_end, hr_api.g_date)
1782: = nvl(p_date_projected_end, hr_api.g_date)
1783: and nvl(per_abs_shd.g_old_rec.date_start, hr_api.g_date)

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

1777: --
1778: if (l_api_updating
1779: and nvl(per_abs_shd.g_old_rec.date_projected_start, hr_api.g_date)
1780: = nvl(p_date_projected_start, hr_api.g_date)
1781: and nvl(per_abs_shd.g_old_rec.date_projected_end, hr_api.g_date)
1782: = nvl(p_date_projected_end, hr_api.g_date)
1783: and nvl(per_abs_shd.g_old_rec.date_start, hr_api.g_date)
1784: = nvl(p_date_start, hr_api.g_date)
1785: and nvl(per_abs_shd.g_old_rec.date_end, hr_api.g_date)

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

1779: and nvl(per_abs_shd.g_old_rec.date_projected_start, hr_api.g_date)
1780: = nvl(p_date_projected_start, hr_api.g_date)
1781: and nvl(per_abs_shd.g_old_rec.date_projected_end, hr_api.g_date)
1782: = nvl(p_date_projected_end, hr_api.g_date)
1783: and nvl(per_abs_shd.g_old_rec.date_start, hr_api.g_date)
1784: = nvl(p_date_start, hr_api.g_date)
1785: and nvl(per_abs_shd.g_old_rec.date_end, hr_api.g_date)
1786: = nvl(p_date_end, hr_api.g_date)) then
1787: return;

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

1781: and nvl(per_abs_shd.g_old_rec.date_projected_end, hr_api.g_date)
1782: = nvl(p_date_projected_end, hr_api.g_date)
1783: and nvl(per_abs_shd.g_old_rec.date_start, hr_api.g_date)
1784: = nvl(p_date_start, hr_api.g_date)
1785: and nvl(per_abs_shd.g_old_rec.date_end, hr_api.g_date)
1786: = nvl(p_date_end, hr_api.g_date)) then
1787: return;
1788: end if;
1789:

Line 1893: l_api_updating := per_abs_shd.api_updating

1889: -- Only proceed with validation if :
1890: -- a) The current g_old_rec is current and
1891: -- b) The date values have changed
1892: --
1893: l_api_updating := per_abs_shd.api_updating
1894: (p_absence_attendance_id => p_absence_attendance_id
1895: ,p_object_version_number => p_object_version_number);
1896: --
1897: if (l_api_updating

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

1894: (p_absence_attendance_id => p_absence_attendance_id
1895: ,p_object_version_number => p_object_version_number);
1896: --
1897: if (l_api_updating
1898: and nvl(per_abs_shd.g_old_rec.date_projected_start, hr_api.g_date)
1899: = nvl(p_date_projected_start, hr_api.g_date)
1900: and nvl(per_abs_shd.g_old_rec.date_projected_end, hr_api.g_date)
1901: = nvl(p_date_projected_end, hr_api.g_date)
1902: and nvl(per_abs_shd.g_old_rec.date_start, hr_api.g_date)

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

1896: --
1897: if (l_api_updating
1898: and nvl(per_abs_shd.g_old_rec.date_projected_start, hr_api.g_date)
1899: = nvl(p_date_projected_start, hr_api.g_date)
1900: and nvl(per_abs_shd.g_old_rec.date_projected_end, hr_api.g_date)
1901: = nvl(p_date_projected_end, hr_api.g_date)
1902: and nvl(per_abs_shd.g_old_rec.date_start, hr_api.g_date)
1903: = nvl(p_date_start, hr_api.g_date)
1904: and nvl(per_abs_shd.g_old_rec.date_end, hr_api.g_date)

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

1898: and nvl(per_abs_shd.g_old_rec.date_projected_start, hr_api.g_date)
1899: = nvl(p_date_projected_start, hr_api.g_date)
1900: and nvl(per_abs_shd.g_old_rec.date_projected_end, hr_api.g_date)
1901: = nvl(p_date_projected_end, hr_api.g_date)
1902: and nvl(per_abs_shd.g_old_rec.date_start, hr_api.g_date)
1903: = nvl(p_date_start, hr_api.g_date)
1904: and nvl(per_abs_shd.g_old_rec.date_end, hr_api.g_date)
1905: = nvl(p_date_end, hr_api.g_date)) then
1906: return;

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

1900: and nvl(per_abs_shd.g_old_rec.date_projected_end, hr_api.g_date)
1901: = nvl(p_date_projected_end, hr_api.g_date)
1902: and nvl(per_abs_shd.g_old_rec.date_start, hr_api.g_date)
1903: = nvl(p_date_start, hr_api.g_date)
1904: and nvl(per_abs_shd.g_old_rec.date_end, hr_api.g_date)
1905: = nvl(p_date_end, hr_api.g_date)) then
1906: return;
1907: end if;
1908:

Line 2008: l_api_updating := per_abs_shd.api_updating

2004: -- Only proceed with validation if :
2005: -- a) The current g_old_rec is current and
2006: -- b) The value for abs_attendance_reason_id has changed
2007: --
2008: l_api_updating := per_abs_shd.api_updating
2009: (p_absence_attendance_id => p_absence_attendance_id
2010: ,p_object_version_number => p_object_version_number);
2011: --
2012: if (l_api_updating and nvl(per_abs_shd.g_old_rec.abs_attendance_reason_id,

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

2008: l_api_updating := per_abs_shd.api_updating
2009: (p_absence_attendance_id => p_absence_attendance_id
2010: ,p_object_version_number => p_object_version_number);
2011: --
2012: if (l_api_updating and nvl(per_abs_shd.g_old_rec.abs_attendance_reason_id,
2013: hr_api.g_number) = nvl(p_abs_attendance_reason_id, hr_api.g_number)) then
2014: return;
2015: end if;
2016:

Line 2170: ,p_absence_days => per_abs_shd.g_absence_days

2166: ,p_ABS_INFORMATION3 => NULL
2167: ,p_ABS_INFORMATION4 => NULL
2168: ,p_ABS_INFORMATION5 => NULL
2169: ,p_ABS_INFORMATION6 => NULL
2170: ,p_absence_days => per_abs_shd.g_absence_days
2171: ,p_absence_hours => per_abs_shd.g_absence_hours
2172: ,p_dur_dys_less_warning => p_dur_dys_less_warning
2173: ,p_dur_hrs_less_warning => p_dur_hrs_less_warning
2174: ,p_exceeds_pto_entit_warning => p_exceeds_pto_entit_warning

Line 2171: ,p_absence_hours => per_abs_shd.g_absence_hours

2167: ,p_ABS_INFORMATION4 => NULL
2168: ,p_ABS_INFORMATION5 => NULL
2169: ,p_ABS_INFORMATION6 => NULL
2170: ,p_absence_days => per_abs_shd.g_absence_days
2171: ,p_absence_hours => per_abs_shd.g_absence_hours
2172: ,p_dur_dys_less_warning => p_dur_dys_less_warning
2173: ,p_dur_hrs_less_warning => p_dur_hrs_less_warning
2174: ,p_exceeds_pto_entit_warning => p_exceeds_pto_entit_warning
2175: ,p_exceeds_run_total_warning => p_exceeds_run_total_warning

Line 2394: l_api_updating := per_abs_shd.api_updating

2390: -- Only proceed with validation if :
2391: -- a) The current g_old_rec is current and
2392: -- b) The date and time values have changed
2393: --
2394: l_api_updating := per_abs_shd.api_updating
2395: (p_absence_attendance_id => p_absence_attendance_id
2396: ,p_object_version_number => p_object_version_number);
2397: --
2398: if (l_api_updating

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

2395: (p_absence_attendance_id => p_absence_attendance_id
2396: ,p_object_version_number => p_object_version_number);
2397: --
2398: if (l_api_updating
2399: and nvl(per_abs_shd.g_old_rec.date_projected_start, hr_api.g_date)
2400: = nvl(p_date_projected_start, hr_api.g_date)
2401: and nvl(per_abs_shd.g_old_rec.time_projected_start, hr_api.g_varchar2)
2402: = nvl(p_time_projected_start, hr_api.g_varchar2)
2403: and nvl(per_abs_shd.g_old_rec.date_projected_end, hr_api.g_date)

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

2397: --
2398: if (l_api_updating
2399: and nvl(per_abs_shd.g_old_rec.date_projected_start, hr_api.g_date)
2400: = nvl(p_date_projected_start, hr_api.g_date)
2401: and nvl(per_abs_shd.g_old_rec.time_projected_start, hr_api.g_varchar2)
2402: = nvl(p_time_projected_start, hr_api.g_varchar2)
2403: and nvl(per_abs_shd.g_old_rec.date_projected_end, hr_api.g_date)
2404: = nvl(p_date_projected_end, hr_api.g_date)
2405: and nvl(per_abs_shd.g_old_rec.time_projected_end, hr_api.g_varchar2)

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

2399: and nvl(per_abs_shd.g_old_rec.date_projected_start, hr_api.g_date)
2400: = nvl(p_date_projected_start, hr_api.g_date)
2401: and nvl(per_abs_shd.g_old_rec.time_projected_start, hr_api.g_varchar2)
2402: = nvl(p_time_projected_start, hr_api.g_varchar2)
2403: and nvl(per_abs_shd.g_old_rec.date_projected_end, hr_api.g_date)
2404: = nvl(p_date_projected_end, hr_api.g_date)
2405: and nvl(per_abs_shd.g_old_rec.time_projected_end, hr_api.g_varchar2)
2406: = nvl(p_time_projected_end, hr_api.g_varchar2)
2407: and nvl(per_abs_shd.g_old_rec.date_start, hr_api.g_date)

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

2401: and nvl(per_abs_shd.g_old_rec.time_projected_start, hr_api.g_varchar2)
2402: = nvl(p_time_projected_start, hr_api.g_varchar2)
2403: and nvl(per_abs_shd.g_old_rec.date_projected_end, hr_api.g_date)
2404: = nvl(p_date_projected_end, hr_api.g_date)
2405: and nvl(per_abs_shd.g_old_rec.time_projected_end, hr_api.g_varchar2)
2406: = nvl(p_time_projected_end, hr_api.g_varchar2)
2407: and nvl(per_abs_shd.g_old_rec.date_start, hr_api.g_date)
2408: = nvl(p_date_start, hr_api.g_date)
2409: and nvl(per_abs_shd.g_old_rec.time_start, hr_api.g_varchar2)

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

2403: and nvl(per_abs_shd.g_old_rec.date_projected_end, hr_api.g_date)
2404: = nvl(p_date_projected_end, hr_api.g_date)
2405: and nvl(per_abs_shd.g_old_rec.time_projected_end, hr_api.g_varchar2)
2406: = nvl(p_time_projected_end, hr_api.g_varchar2)
2407: and nvl(per_abs_shd.g_old_rec.date_start, hr_api.g_date)
2408: = nvl(p_date_start, hr_api.g_date)
2409: and nvl(per_abs_shd.g_old_rec.time_start, hr_api.g_varchar2)
2410: = nvl(p_time_start, hr_api.g_varchar2)
2411: and nvl(per_abs_shd.g_old_rec.date_end, hr_api.g_date)

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

2405: and nvl(per_abs_shd.g_old_rec.time_projected_end, hr_api.g_varchar2)
2406: = nvl(p_time_projected_end, hr_api.g_varchar2)
2407: and nvl(per_abs_shd.g_old_rec.date_start, hr_api.g_date)
2408: = nvl(p_date_start, hr_api.g_date)
2409: and nvl(per_abs_shd.g_old_rec.time_start, hr_api.g_varchar2)
2410: = nvl(p_time_start, hr_api.g_varchar2)
2411: and nvl(per_abs_shd.g_old_rec.date_end, hr_api.g_date)
2412: = nvl(p_date_end, hr_api.g_date)
2413: and nvl(per_abs_shd.g_old_rec.time_end, hr_api.g_varchar2)

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

2407: and nvl(per_abs_shd.g_old_rec.date_start, hr_api.g_date)
2408: = nvl(p_date_start, hr_api.g_date)
2409: and nvl(per_abs_shd.g_old_rec.time_start, hr_api.g_varchar2)
2410: = nvl(p_time_start, hr_api.g_varchar2)
2411: and nvl(per_abs_shd.g_old_rec.date_end, hr_api.g_date)
2412: = nvl(p_date_end, hr_api.g_date)
2413: and nvl(per_abs_shd.g_old_rec.time_end, hr_api.g_varchar2)
2414: = nvl(p_time_end, hr_api.g_varchar2)
2415: and nvl(per_abs_shd.g_old_rec.absence_days, hr_api.g_number)

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

2409: and nvl(per_abs_shd.g_old_rec.time_start, hr_api.g_varchar2)
2410: = nvl(p_time_start, hr_api.g_varchar2)
2411: and nvl(per_abs_shd.g_old_rec.date_end, hr_api.g_date)
2412: = nvl(p_date_end, hr_api.g_date)
2413: and nvl(per_abs_shd.g_old_rec.time_end, hr_api.g_varchar2)
2414: = nvl(p_time_end, hr_api.g_varchar2)
2415: and nvl(per_abs_shd.g_old_rec.absence_days, hr_api.g_number)
2416: = nvl(p_absence_days, hr_api.g_number)
2417: and nvl(per_abs_shd.g_old_rec.absence_hours, hr_api.g_number)

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

2411: and nvl(per_abs_shd.g_old_rec.date_end, hr_api.g_date)
2412: = nvl(p_date_end, hr_api.g_date)
2413: and nvl(per_abs_shd.g_old_rec.time_end, hr_api.g_varchar2)
2414: = nvl(p_time_end, hr_api.g_varchar2)
2415: and nvl(per_abs_shd.g_old_rec.absence_days, hr_api.g_number)
2416: = nvl(p_absence_days, hr_api.g_number)
2417: and nvl(per_abs_shd.g_old_rec.absence_hours, hr_api.g_number)
2418: = nvl(p_absence_hours, hr_api.g_number)) then
2419: return;

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

2413: and nvl(per_abs_shd.g_old_rec.time_end, hr_api.g_varchar2)
2414: = nvl(p_time_end, hr_api.g_varchar2)
2415: and nvl(per_abs_shd.g_old_rec.absence_days, hr_api.g_number)
2416: = nvl(p_absence_days, hr_api.g_number)
2417: and nvl(per_abs_shd.g_old_rec.absence_hours, hr_api.g_number)
2418: = nvl(p_absence_hours, hr_api.g_number)) then
2419: return;
2420: end if;
2421:

Line 2601: hr_utility.set_location('per_abs_shd.g_absence_days '||per_abs_shd.g_absence_days, 36);

2597:
2598: -- Bug 14659075
2599: IF l_auto_overwrite ='N' THEN
2600:
2601: hr_utility.set_location('per_abs_shd.g_absence_days '||per_abs_shd.g_absence_days, 36);
2602: hr_utility.set_location('per_abs_shd.g_absence_hours '||per_abs_shd.g_absence_hours, 36);
2603:
2604: p_absence_days :=per_abs_shd.g_absence_days;
2605: p_absence_hours:=per_abs_shd.g_absence_hours;

Line 2602: hr_utility.set_location('per_abs_shd.g_absence_hours '||per_abs_shd.g_absence_hours, 36);

2598: -- Bug 14659075
2599: IF l_auto_overwrite ='N' THEN
2600:
2601: hr_utility.set_location('per_abs_shd.g_absence_days '||per_abs_shd.g_absence_days, 36);
2602: hr_utility.set_location('per_abs_shd.g_absence_hours '||per_abs_shd.g_absence_hours, 36);
2603:
2604: p_absence_days :=per_abs_shd.g_absence_days;
2605: p_absence_hours:=per_abs_shd.g_absence_hours;
2606: p_dur_overwritten_warning := TRUE;

Line 2604: p_absence_days :=per_abs_shd.g_absence_days;

2600:
2601: hr_utility.set_location('per_abs_shd.g_absence_days '||per_abs_shd.g_absence_days, 36);
2602: hr_utility.set_location('per_abs_shd.g_absence_hours '||per_abs_shd.g_absence_hours, 36);
2603:
2604: p_absence_days :=per_abs_shd.g_absence_days;
2605: p_absence_hours:=per_abs_shd.g_absence_hours;
2606: p_dur_overwritten_warning := TRUE;
2607:
2608: END IF;

Line 2605: p_absence_hours:=per_abs_shd.g_absence_hours;

2601: hr_utility.set_location('per_abs_shd.g_absence_days '||per_abs_shd.g_absence_days, 36);
2602: hr_utility.set_location('per_abs_shd.g_absence_hours '||per_abs_shd.g_absence_hours, 36);
2603:
2604: p_absence_days :=per_abs_shd.g_absence_days;
2605: p_absence_hours:=per_abs_shd.g_absence_hours;
2606: p_dur_overwritten_warning := TRUE;
2607:
2608: END IF;
2609: --

Line 2842: + nvl(per_abs_shd.g_old_rec.absence_hours, 0)

2838: -- included the absence in the calculation of the net entitlement).
2839: --
2840: if l_hours_or_days = 'H' then
2841: l_net_entitlement := l_net_entitlement
2842: + nvl(per_abs_shd.g_old_rec.absence_hours, 0)
2843: - p_absence_hours;
2844:
2845: elsif l_hours_or_days = 'D' then
2846: l_net_entitlement := l_net_entitlement

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

2843: - p_absence_hours;
2844:
2845: elsif l_hours_or_days = 'D' then
2846: l_net_entitlement := l_net_entitlement
2847: + nvl(per_abs_shd.g_old_rec.absence_days, 0)
2848: - p_absence_days;
2849: end if;
2850:
2851: --

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

2912: -- being double counted (this would occur during update only).
2913: --
2914: if l_increasing_or_decreasing = 'D'
2915: and (l_running_total_hours +
2916: nvl(per_abs_shd.g_old_rec.absence_hours, 0) - p_absence_hours < 0
2917: or l_running_total_days +
2918: nvl(per_abs_shd.g_old_rec.absence_days, 0) - p_absence_days < 0)
2919: then
2920:

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

2914: if l_increasing_or_decreasing = 'D'
2915: and (l_running_total_hours +
2916: nvl(per_abs_shd.g_old_rec.absence_hours, 0) - p_absence_hours < 0
2917: or l_running_total_days +
2918: nvl(per_abs_shd.g_old_rec.absence_days, 0) - p_absence_days < 0)
2919: then
2920:
2921: -- code change for 7688779 starts here
2922: if (nvl(fnd_profile.value('HR_ALLOW_NEG_ABS_BAL'),'Y') = 'N') then

Line 3049: l_api_updating := per_abs_shd.api_updating

3045: -- Only proceed with validation if :
3046: -- a) The current g_old_rec is current and
3047: -- b) The date values have changed
3048: --
3049: l_api_updating := per_abs_shd.api_updating
3050: (p_absence_attendance_id => p_absence_attendance_id
3051: ,p_object_version_number => p_object_version_number);
3052: --
3053: if (l_api_updating

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

3050: (p_absence_attendance_id => p_absence_attendance_id
3051: ,p_object_version_number => p_object_version_number);
3052: --
3053: if (l_api_updating
3054: and nvl(per_abs_shd.g_old_rec.replacement_person_id, hr_api.g_number)
3055: = nvl(p_replacement_person_id, hr_api.g_number)
3056: and nvl(per_abs_shd.g_old_rec.date_projected_start, hr_api.g_date)
3057: = nvl(p_date_projected_start, hr_api.g_date)
3058: and nvl(per_abs_shd.g_old_rec.date_projected_end, hr_api.g_date)

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

3052: --
3053: if (l_api_updating
3054: and nvl(per_abs_shd.g_old_rec.replacement_person_id, hr_api.g_number)
3055: = nvl(p_replacement_person_id, hr_api.g_number)
3056: and nvl(per_abs_shd.g_old_rec.date_projected_start, hr_api.g_date)
3057: = nvl(p_date_projected_start, hr_api.g_date)
3058: and nvl(per_abs_shd.g_old_rec.date_projected_end, hr_api.g_date)
3059: = nvl(p_date_projected_end, hr_api.g_date)
3060: and nvl(per_abs_shd.g_old_rec.date_start, hr_api.g_date)

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

3054: and nvl(per_abs_shd.g_old_rec.replacement_person_id, hr_api.g_number)
3055: = nvl(p_replacement_person_id, hr_api.g_number)
3056: and nvl(per_abs_shd.g_old_rec.date_projected_start, hr_api.g_date)
3057: = nvl(p_date_projected_start, hr_api.g_date)
3058: and nvl(per_abs_shd.g_old_rec.date_projected_end, hr_api.g_date)
3059: = nvl(p_date_projected_end, hr_api.g_date)
3060: and nvl(per_abs_shd.g_old_rec.date_start, hr_api.g_date)
3061: = nvl(p_date_start, hr_api.g_date)
3062: and nvl(per_abs_shd.g_old_rec.date_end, hr_api.g_date)

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

3056: and nvl(per_abs_shd.g_old_rec.date_projected_start, hr_api.g_date)
3057: = nvl(p_date_projected_start, hr_api.g_date)
3058: and nvl(per_abs_shd.g_old_rec.date_projected_end, hr_api.g_date)
3059: = nvl(p_date_projected_end, hr_api.g_date)
3060: and nvl(per_abs_shd.g_old_rec.date_start, hr_api.g_date)
3061: = nvl(p_date_start, hr_api.g_date)
3062: and nvl(per_abs_shd.g_old_rec.date_end, hr_api.g_date)
3063: = nvl(p_date_end, hr_api.g_date)) then
3064: return;

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

3058: and nvl(per_abs_shd.g_old_rec.date_projected_end, hr_api.g_date)
3059: = nvl(p_date_projected_end, hr_api.g_date)
3060: and nvl(per_abs_shd.g_old_rec.date_start, hr_api.g_date)
3061: = nvl(p_date_start, hr_api.g_date)
3062: and nvl(per_abs_shd.g_old_rec.date_end, hr_api.g_date)
3063: = nvl(p_date_end, hr_api.g_date)) then
3064: return;
3065: end if;
3066:

Line 3152: l_api_updating := per_abs_shd.api_updating

3148: -- Only proceed with validation if :
3149: -- a) The current g_old_rec is current and
3150: -- b) The date values have changed
3151: --
3152: l_api_updating := per_abs_shd.api_updating
3153: (p_absence_attendance_id => p_absence_attendance_id
3154: ,p_object_version_number => p_object_version_number);
3155: --
3156: if (l_api_updating

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

3153: (p_absence_attendance_id => p_absence_attendance_id
3154: ,p_object_version_number => p_object_version_number);
3155: --
3156: if (l_api_updating
3157: and nvl(per_abs_shd.g_old_rec.authorising_person_id, hr_api.g_number)
3158: = nvl(p_authorising_person_id, hr_api.g_number)
3159: and nvl(per_abs_shd.g_old_rec.date_projected_start, hr_api.g_date)
3160: = nvl(p_date_projected_start, hr_api.g_date)
3161: and nvl(per_abs_shd.g_old_rec.date_projected_end, hr_api.g_date)

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

3155: --
3156: if (l_api_updating
3157: and nvl(per_abs_shd.g_old_rec.authorising_person_id, hr_api.g_number)
3158: = nvl(p_authorising_person_id, hr_api.g_number)
3159: and nvl(per_abs_shd.g_old_rec.date_projected_start, hr_api.g_date)
3160: = nvl(p_date_projected_start, hr_api.g_date)
3161: and nvl(per_abs_shd.g_old_rec.date_projected_end, hr_api.g_date)
3162: = nvl(p_date_projected_end, hr_api.g_date)
3163: and nvl(per_abs_shd.g_old_rec.date_start, hr_api.g_date)

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

3157: and nvl(per_abs_shd.g_old_rec.authorising_person_id, hr_api.g_number)
3158: = nvl(p_authorising_person_id, hr_api.g_number)
3159: and nvl(per_abs_shd.g_old_rec.date_projected_start, hr_api.g_date)
3160: = nvl(p_date_projected_start, hr_api.g_date)
3161: and nvl(per_abs_shd.g_old_rec.date_projected_end, hr_api.g_date)
3162: = nvl(p_date_projected_end, hr_api.g_date)
3163: and nvl(per_abs_shd.g_old_rec.date_start, hr_api.g_date)
3164: = nvl(p_date_start, hr_api.g_date)
3165: and nvl(per_abs_shd.g_old_rec.date_end, hr_api.g_date)

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

3159: and nvl(per_abs_shd.g_old_rec.date_projected_start, hr_api.g_date)
3160: = nvl(p_date_projected_start, hr_api.g_date)
3161: and nvl(per_abs_shd.g_old_rec.date_projected_end, hr_api.g_date)
3162: = nvl(p_date_projected_end, hr_api.g_date)
3163: and nvl(per_abs_shd.g_old_rec.date_start, hr_api.g_date)
3164: = nvl(p_date_start, hr_api.g_date)
3165: and nvl(per_abs_shd.g_old_rec.date_end, hr_api.g_date)
3166: = nvl(p_date_end, hr_api.g_date)) then
3167: return;

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

3161: and nvl(per_abs_shd.g_old_rec.date_projected_end, hr_api.g_date)
3162: = nvl(p_date_projected_end, hr_api.g_date)
3163: and nvl(per_abs_shd.g_old_rec.date_start, hr_api.g_date)
3164: = nvl(p_date_start, hr_api.g_date)
3165: and nvl(per_abs_shd.g_old_rec.date_end, hr_api.g_date)
3166: = nvl(p_date_end, hr_api.g_date)) then
3167: return;
3168: end if;
3169:

Line 3357: (p_rec in per_abs_shd.g_rec_type

3353: --
3354: -- ----------------------------------------------------------------------------
3355: --
3356: procedure chk_ddf
3357: (p_rec in per_abs_shd.g_rec_type
3358: ) is
3359: --
3360: l_proc varchar2(72) := g_package || 'chk_ddf';
3361: --

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

3362: begin
3363: hr_utility.set_location('Entering:'||l_proc,10);
3364: --
3365: if ((p_rec.absence_attendance_id is not null) and (
3366: nvl(per_abs_shd.g_old_rec.abs_information_category, hr_api.g_varchar2) <>
3367: nvl(p_rec.abs_information_category, hr_api.g_varchar2) or
3368: nvl(per_abs_shd.g_old_rec.abs_information1, hr_api.g_varchar2) <>
3369: nvl(p_rec.abs_information1, hr_api.g_varchar2) or
3370: nvl(per_abs_shd.g_old_rec.abs_information2, hr_api.g_varchar2) <>

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

3364: --
3365: if ((p_rec.absence_attendance_id is not null) and (
3366: nvl(per_abs_shd.g_old_rec.abs_information_category, hr_api.g_varchar2) <>
3367: nvl(p_rec.abs_information_category, hr_api.g_varchar2) or
3368: nvl(per_abs_shd.g_old_rec.abs_information1, hr_api.g_varchar2) <>
3369: nvl(p_rec.abs_information1, hr_api.g_varchar2) or
3370: nvl(per_abs_shd.g_old_rec.abs_information2, hr_api.g_varchar2) <>
3371: nvl(p_rec.abs_information2, hr_api.g_varchar2) or
3372: nvl(per_abs_shd.g_old_rec.abs_information3, hr_api.g_varchar2) <>

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

3366: nvl(per_abs_shd.g_old_rec.abs_information_category, hr_api.g_varchar2) <>
3367: nvl(p_rec.abs_information_category, hr_api.g_varchar2) or
3368: nvl(per_abs_shd.g_old_rec.abs_information1, hr_api.g_varchar2) <>
3369: nvl(p_rec.abs_information1, hr_api.g_varchar2) or
3370: nvl(per_abs_shd.g_old_rec.abs_information2, hr_api.g_varchar2) <>
3371: nvl(p_rec.abs_information2, hr_api.g_varchar2) or
3372: nvl(per_abs_shd.g_old_rec.abs_information3, hr_api.g_varchar2) <>
3373: nvl(p_rec.abs_information3, hr_api.g_varchar2) or
3374: nvl(per_abs_shd.g_old_rec.abs_information4, hr_api.g_varchar2) <>

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

3368: nvl(per_abs_shd.g_old_rec.abs_information1, hr_api.g_varchar2) <>
3369: nvl(p_rec.abs_information1, hr_api.g_varchar2) or
3370: nvl(per_abs_shd.g_old_rec.abs_information2, hr_api.g_varchar2) <>
3371: nvl(p_rec.abs_information2, hr_api.g_varchar2) or
3372: nvl(per_abs_shd.g_old_rec.abs_information3, hr_api.g_varchar2) <>
3373: nvl(p_rec.abs_information3, hr_api.g_varchar2) or
3374: nvl(per_abs_shd.g_old_rec.abs_information4, hr_api.g_varchar2) <>
3375: nvl(p_rec.abs_information4, hr_api.g_varchar2) or
3376: nvl(per_abs_shd.g_old_rec.abs_information5, hr_api.g_varchar2) <>

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

3370: nvl(per_abs_shd.g_old_rec.abs_information2, hr_api.g_varchar2) <>
3371: nvl(p_rec.abs_information2, hr_api.g_varchar2) or
3372: nvl(per_abs_shd.g_old_rec.abs_information3, hr_api.g_varchar2) <>
3373: nvl(p_rec.abs_information3, hr_api.g_varchar2) or
3374: nvl(per_abs_shd.g_old_rec.abs_information4, hr_api.g_varchar2) <>
3375: nvl(p_rec.abs_information4, hr_api.g_varchar2) or
3376: nvl(per_abs_shd.g_old_rec.abs_information5, hr_api.g_varchar2) <>
3377: nvl(p_rec.abs_information5, hr_api.g_varchar2) or
3378: nvl(per_abs_shd.g_old_rec.abs_information6, hr_api.g_varchar2) <>

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

3372: nvl(per_abs_shd.g_old_rec.abs_information3, hr_api.g_varchar2) <>
3373: nvl(p_rec.abs_information3, hr_api.g_varchar2) or
3374: nvl(per_abs_shd.g_old_rec.abs_information4, hr_api.g_varchar2) <>
3375: nvl(p_rec.abs_information4, hr_api.g_varchar2) or
3376: nvl(per_abs_shd.g_old_rec.abs_information5, hr_api.g_varchar2) <>
3377: nvl(p_rec.abs_information5, hr_api.g_varchar2) or
3378: nvl(per_abs_shd.g_old_rec.abs_information6, hr_api.g_varchar2) <>
3379: nvl(p_rec.abs_information6, hr_api.g_varchar2) or
3380: nvl(per_abs_shd.g_old_rec.abs_information7, hr_api.g_varchar2) <>

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

3374: nvl(per_abs_shd.g_old_rec.abs_information4, hr_api.g_varchar2) <>
3375: nvl(p_rec.abs_information4, hr_api.g_varchar2) or
3376: nvl(per_abs_shd.g_old_rec.abs_information5, hr_api.g_varchar2) <>
3377: nvl(p_rec.abs_information5, hr_api.g_varchar2) or
3378: nvl(per_abs_shd.g_old_rec.abs_information6, hr_api.g_varchar2) <>
3379: nvl(p_rec.abs_information6, hr_api.g_varchar2) or
3380: nvl(per_abs_shd.g_old_rec.abs_information7, hr_api.g_varchar2) <>
3381: nvl(p_rec.abs_information7, hr_api.g_varchar2) or
3382: nvl(per_abs_shd.g_old_rec.abs_information8, hr_api.g_varchar2) <>

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

3376: nvl(per_abs_shd.g_old_rec.abs_information5, hr_api.g_varchar2) <>
3377: nvl(p_rec.abs_information5, hr_api.g_varchar2) or
3378: nvl(per_abs_shd.g_old_rec.abs_information6, hr_api.g_varchar2) <>
3379: nvl(p_rec.abs_information6, hr_api.g_varchar2) or
3380: nvl(per_abs_shd.g_old_rec.abs_information7, hr_api.g_varchar2) <>
3381: nvl(p_rec.abs_information7, hr_api.g_varchar2) or
3382: nvl(per_abs_shd.g_old_rec.abs_information8, hr_api.g_varchar2) <>
3383: nvl(p_rec.abs_information8, hr_api.g_varchar2) or
3384: nvl(per_abs_shd.g_old_rec.abs_information9, hr_api.g_varchar2) <>

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

3378: nvl(per_abs_shd.g_old_rec.abs_information6, hr_api.g_varchar2) <>
3379: nvl(p_rec.abs_information6, hr_api.g_varchar2) or
3380: nvl(per_abs_shd.g_old_rec.abs_information7, hr_api.g_varchar2) <>
3381: nvl(p_rec.abs_information7, hr_api.g_varchar2) or
3382: nvl(per_abs_shd.g_old_rec.abs_information8, hr_api.g_varchar2) <>
3383: nvl(p_rec.abs_information8, hr_api.g_varchar2) or
3384: nvl(per_abs_shd.g_old_rec.abs_information9, hr_api.g_varchar2) <>
3385: nvl(p_rec.abs_information9, hr_api.g_varchar2) or
3386: nvl(per_abs_shd.g_old_rec.abs_information10, hr_api.g_varchar2) <>

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

3380: nvl(per_abs_shd.g_old_rec.abs_information7, hr_api.g_varchar2) <>
3381: nvl(p_rec.abs_information7, hr_api.g_varchar2) or
3382: nvl(per_abs_shd.g_old_rec.abs_information8, hr_api.g_varchar2) <>
3383: nvl(p_rec.abs_information8, hr_api.g_varchar2) or
3384: nvl(per_abs_shd.g_old_rec.abs_information9, hr_api.g_varchar2) <>
3385: nvl(p_rec.abs_information9, hr_api.g_varchar2) or
3386: nvl(per_abs_shd.g_old_rec.abs_information10, hr_api.g_varchar2) <>
3387: nvl(p_rec.abs_information10, hr_api.g_varchar2) or
3388: nvl(per_abs_shd.g_old_rec.abs_information11, hr_api.g_varchar2) <>

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

3382: nvl(per_abs_shd.g_old_rec.abs_information8, hr_api.g_varchar2) <>
3383: nvl(p_rec.abs_information8, hr_api.g_varchar2) or
3384: nvl(per_abs_shd.g_old_rec.abs_information9, hr_api.g_varchar2) <>
3385: nvl(p_rec.abs_information9, hr_api.g_varchar2) or
3386: nvl(per_abs_shd.g_old_rec.abs_information10, hr_api.g_varchar2) <>
3387: nvl(p_rec.abs_information10, hr_api.g_varchar2) or
3388: nvl(per_abs_shd.g_old_rec.abs_information11, hr_api.g_varchar2) <>
3389: nvl(p_rec.abs_information11, hr_api.g_varchar2) or
3390: nvl(per_abs_shd.g_old_rec.abs_information12, hr_api.g_varchar2) <>

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

3384: nvl(per_abs_shd.g_old_rec.abs_information9, hr_api.g_varchar2) <>
3385: nvl(p_rec.abs_information9, hr_api.g_varchar2) or
3386: nvl(per_abs_shd.g_old_rec.abs_information10, hr_api.g_varchar2) <>
3387: nvl(p_rec.abs_information10, hr_api.g_varchar2) or
3388: nvl(per_abs_shd.g_old_rec.abs_information11, hr_api.g_varchar2) <>
3389: nvl(p_rec.abs_information11, hr_api.g_varchar2) or
3390: nvl(per_abs_shd.g_old_rec.abs_information12, hr_api.g_varchar2) <>
3391: nvl(p_rec.abs_information12, hr_api.g_varchar2) or
3392: nvl(per_abs_shd.g_old_rec.abs_information13, hr_api.g_varchar2) <>

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

3386: nvl(per_abs_shd.g_old_rec.abs_information10, hr_api.g_varchar2) <>
3387: nvl(p_rec.abs_information10, hr_api.g_varchar2) or
3388: nvl(per_abs_shd.g_old_rec.abs_information11, hr_api.g_varchar2) <>
3389: nvl(p_rec.abs_information11, hr_api.g_varchar2) or
3390: nvl(per_abs_shd.g_old_rec.abs_information12, hr_api.g_varchar2) <>
3391: nvl(p_rec.abs_information12, hr_api.g_varchar2) or
3392: nvl(per_abs_shd.g_old_rec.abs_information13, hr_api.g_varchar2) <>
3393: nvl(p_rec.abs_information13, hr_api.g_varchar2) or
3394: nvl(per_abs_shd.g_old_rec.abs_information14, hr_api.g_varchar2) <>

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

3388: nvl(per_abs_shd.g_old_rec.abs_information11, hr_api.g_varchar2) <>
3389: nvl(p_rec.abs_information11, hr_api.g_varchar2) or
3390: nvl(per_abs_shd.g_old_rec.abs_information12, hr_api.g_varchar2) <>
3391: nvl(p_rec.abs_information12, hr_api.g_varchar2) or
3392: nvl(per_abs_shd.g_old_rec.abs_information13, hr_api.g_varchar2) <>
3393: nvl(p_rec.abs_information13, hr_api.g_varchar2) or
3394: nvl(per_abs_shd.g_old_rec.abs_information14, hr_api.g_varchar2) <>
3395: nvl(p_rec.abs_information14, hr_api.g_varchar2) or
3396: nvl(per_abs_shd.g_old_rec.abs_information15, hr_api.g_varchar2) <>

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

3390: nvl(per_abs_shd.g_old_rec.abs_information12, hr_api.g_varchar2) <>
3391: nvl(p_rec.abs_information12, hr_api.g_varchar2) or
3392: nvl(per_abs_shd.g_old_rec.abs_information13, hr_api.g_varchar2) <>
3393: nvl(p_rec.abs_information13, hr_api.g_varchar2) or
3394: nvl(per_abs_shd.g_old_rec.abs_information14, hr_api.g_varchar2) <>
3395: nvl(p_rec.abs_information14, hr_api.g_varchar2) or
3396: nvl(per_abs_shd.g_old_rec.abs_information15, hr_api.g_varchar2) <>
3397: nvl(p_rec.abs_information15, hr_api.g_varchar2) or
3398: nvl(per_abs_shd.g_old_rec.abs_information16, hr_api.g_varchar2) <>

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

3392: nvl(per_abs_shd.g_old_rec.abs_information13, hr_api.g_varchar2) <>
3393: nvl(p_rec.abs_information13, hr_api.g_varchar2) or
3394: nvl(per_abs_shd.g_old_rec.abs_information14, hr_api.g_varchar2) <>
3395: nvl(p_rec.abs_information14, hr_api.g_varchar2) or
3396: nvl(per_abs_shd.g_old_rec.abs_information15, hr_api.g_varchar2) <>
3397: nvl(p_rec.abs_information15, hr_api.g_varchar2) or
3398: nvl(per_abs_shd.g_old_rec.abs_information16, hr_api.g_varchar2) <>
3399: nvl(p_rec.abs_information16, hr_api.g_varchar2) or
3400: nvl(per_abs_shd.g_old_rec.abs_information17, hr_api.g_varchar2) <>

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

3394: nvl(per_abs_shd.g_old_rec.abs_information14, hr_api.g_varchar2) <>
3395: nvl(p_rec.abs_information14, hr_api.g_varchar2) or
3396: nvl(per_abs_shd.g_old_rec.abs_information15, hr_api.g_varchar2) <>
3397: nvl(p_rec.abs_information15, hr_api.g_varchar2) or
3398: nvl(per_abs_shd.g_old_rec.abs_information16, hr_api.g_varchar2) <>
3399: nvl(p_rec.abs_information16, hr_api.g_varchar2) or
3400: nvl(per_abs_shd.g_old_rec.abs_information17, hr_api.g_varchar2) <>
3401: nvl(p_rec.abs_information17, hr_api.g_varchar2) or
3402: nvl(per_abs_shd.g_old_rec.abs_information18, hr_api.g_varchar2) <>

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

3396: nvl(per_abs_shd.g_old_rec.abs_information15, hr_api.g_varchar2) <>
3397: nvl(p_rec.abs_information15, hr_api.g_varchar2) or
3398: nvl(per_abs_shd.g_old_rec.abs_information16, hr_api.g_varchar2) <>
3399: nvl(p_rec.abs_information16, hr_api.g_varchar2) or
3400: nvl(per_abs_shd.g_old_rec.abs_information17, hr_api.g_varchar2) <>
3401: nvl(p_rec.abs_information17, hr_api.g_varchar2) or
3402: nvl(per_abs_shd.g_old_rec.abs_information18, hr_api.g_varchar2) <>
3403: nvl(p_rec.abs_information18, hr_api.g_varchar2) or
3404: nvl(per_abs_shd.g_old_rec.abs_information19, hr_api.g_varchar2) <>

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

3398: nvl(per_abs_shd.g_old_rec.abs_information16, hr_api.g_varchar2) <>
3399: nvl(p_rec.abs_information16, hr_api.g_varchar2) or
3400: nvl(per_abs_shd.g_old_rec.abs_information17, hr_api.g_varchar2) <>
3401: nvl(p_rec.abs_information17, hr_api.g_varchar2) or
3402: nvl(per_abs_shd.g_old_rec.abs_information18, hr_api.g_varchar2) <>
3403: nvl(p_rec.abs_information18, hr_api.g_varchar2) or
3404: nvl(per_abs_shd.g_old_rec.abs_information19, hr_api.g_varchar2) <>
3405: nvl(p_rec.abs_information19, hr_api.g_varchar2) or
3406: nvl(per_abs_shd.g_old_rec.abs_information20, hr_api.g_varchar2) <>

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

3400: nvl(per_abs_shd.g_old_rec.abs_information17, hr_api.g_varchar2) <>
3401: nvl(p_rec.abs_information17, hr_api.g_varchar2) or
3402: nvl(per_abs_shd.g_old_rec.abs_information18, hr_api.g_varchar2) <>
3403: nvl(p_rec.abs_information18, hr_api.g_varchar2) or
3404: nvl(per_abs_shd.g_old_rec.abs_information19, hr_api.g_varchar2) <>
3405: nvl(p_rec.abs_information19, hr_api.g_varchar2) or
3406: nvl(per_abs_shd.g_old_rec.abs_information20, hr_api.g_varchar2) <>
3407: nvl(p_rec.abs_information20, hr_api.g_varchar2) or
3408: nvl(per_abs_shd.g_old_rec.abs_information21, hr_api.g_varchar2) <>

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

3402: nvl(per_abs_shd.g_old_rec.abs_information18, hr_api.g_varchar2) <>
3403: nvl(p_rec.abs_information18, hr_api.g_varchar2) or
3404: nvl(per_abs_shd.g_old_rec.abs_information19, hr_api.g_varchar2) <>
3405: nvl(p_rec.abs_information19, hr_api.g_varchar2) or
3406: nvl(per_abs_shd.g_old_rec.abs_information20, hr_api.g_varchar2) <>
3407: nvl(p_rec.abs_information20, hr_api.g_varchar2) or
3408: nvl(per_abs_shd.g_old_rec.abs_information21, hr_api.g_varchar2) <>
3409: nvl(p_rec.abs_information21, hr_api.g_varchar2) or
3410: nvl(per_abs_shd.g_old_rec.abs_information22, hr_api.g_varchar2) <>

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

3404: nvl(per_abs_shd.g_old_rec.abs_information19, hr_api.g_varchar2) <>
3405: nvl(p_rec.abs_information19, hr_api.g_varchar2) or
3406: nvl(per_abs_shd.g_old_rec.abs_information20, hr_api.g_varchar2) <>
3407: nvl(p_rec.abs_information20, hr_api.g_varchar2) or
3408: nvl(per_abs_shd.g_old_rec.abs_information21, hr_api.g_varchar2) <>
3409: nvl(p_rec.abs_information21, hr_api.g_varchar2) or
3410: nvl(per_abs_shd.g_old_rec.abs_information22, hr_api.g_varchar2) <>
3411: nvl(p_rec.abs_information22, hr_api.g_varchar2) or
3412: nvl(per_abs_shd.g_old_rec.abs_information23, hr_api.g_varchar2) <>

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

3406: nvl(per_abs_shd.g_old_rec.abs_information20, hr_api.g_varchar2) <>
3407: nvl(p_rec.abs_information20, hr_api.g_varchar2) or
3408: nvl(per_abs_shd.g_old_rec.abs_information21, hr_api.g_varchar2) <>
3409: nvl(p_rec.abs_information21, hr_api.g_varchar2) or
3410: nvl(per_abs_shd.g_old_rec.abs_information22, hr_api.g_varchar2) <>
3411: nvl(p_rec.abs_information22, hr_api.g_varchar2) or
3412: nvl(per_abs_shd.g_old_rec.abs_information23, hr_api.g_varchar2) <>
3413: nvl(p_rec.abs_information23, hr_api.g_varchar2) or
3414: nvl(per_abs_shd.g_old_rec.abs_information24, hr_api.g_varchar2) <>

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

3408: nvl(per_abs_shd.g_old_rec.abs_information21, hr_api.g_varchar2) <>
3409: nvl(p_rec.abs_information21, hr_api.g_varchar2) or
3410: nvl(per_abs_shd.g_old_rec.abs_information22, hr_api.g_varchar2) <>
3411: nvl(p_rec.abs_information22, hr_api.g_varchar2) or
3412: nvl(per_abs_shd.g_old_rec.abs_information23, hr_api.g_varchar2) <>
3413: nvl(p_rec.abs_information23, hr_api.g_varchar2) or
3414: nvl(per_abs_shd.g_old_rec.abs_information24, hr_api.g_varchar2) <>
3415: nvl(p_rec.abs_information24, hr_api.g_varchar2) or
3416: nvl(per_abs_shd.g_old_rec.abs_information25, hr_api.g_varchar2) <>

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

3410: nvl(per_abs_shd.g_old_rec.abs_information22, hr_api.g_varchar2) <>
3411: nvl(p_rec.abs_information22, hr_api.g_varchar2) or
3412: nvl(per_abs_shd.g_old_rec.abs_information23, hr_api.g_varchar2) <>
3413: nvl(p_rec.abs_information23, hr_api.g_varchar2) or
3414: nvl(per_abs_shd.g_old_rec.abs_information24, hr_api.g_varchar2) <>
3415: nvl(p_rec.abs_information24, hr_api.g_varchar2) or
3416: nvl(per_abs_shd.g_old_rec.abs_information25, hr_api.g_varchar2) <>
3417: nvl(p_rec.abs_information25, hr_api.g_varchar2) or
3418: nvl(per_abs_shd.g_old_rec.abs_information26, hr_api.g_varchar2) <>

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

3412: nvl(per_abs_shd.g_old_rec.abs_information23, hr_api.g_varchar2) <>
3413: nvl(p_rec.abs_information23, hr_api.g_varchar2) or
3414: nvl(per_abs_shd.g_old_rec.abs_information24, hr_api.g_varchar2) <>
3415: nvl(p_rec.abs_information24, hr_api.g_varchar2) or
3416: nvl(per_abs_shd.g_old_rec.abs_information25, hr_api.g_varchar2) <>
3417: nvl(p_rec.abs_information25, hr_api.g_varchar2) or
3418: nvl(per_abs_shd.g_old_rec.abs_information26, hr_api.g_varchar2) <>
3419: nvl(p_rec.abs_information26, hr_api.g_varchar2) or
3420: nvl(per_abs_shd.g_old_rec.abs_information27, hr_api.g_varchar2) <>

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

3414: nvl(per_abs_shd.g_old_rec.abs_information24, hr_api.g_varchar2) <>
3415: nvl(p_rec.abs_information24, hr_api.g_varchar2) or
3416: nvl(per_abs_shd.g_old_rec.abs_information25, hr_api.g_varchar2) <>
3417: nvl(p_rec.abs_information25, hr_api.g_varchar2) or
3418: nvl(per_abs_shd.g_old_rec.abs_information26, hr_api.g_varchar2) <>
3419: nvl(p_rec.abs_information26, hr_api.g_varchar2) or
3420: nvl(per_abs_shd.g_old_rec.abs_information27, hr_api.g_varchar2) <>
3421: nvl(p_rec.abs_information27, hr_api.g_varchar2) or
3422: nvl(per_abs_shd.g_old_rec.abs_information28, hr_api.g_varchar2) <>

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

3416: nvl(per_abs_shd.g_old_rec.abs_information25, hr_api.g_varchar2) <>
3417: nvl(p_rec.abs_information25, hr_api.g_varchar2) or
3418: nvl(per_abs_shd.g_old_rec.abs_information26, hr_api.g_varchar2) <>
3419: nvl(p_rec.abs_information26, hr_api.g_varchar2) or
3420: nvl(per_abs_shd.g_old_rec.abs_information27, hr_api.g_varchar2) <>
3421: nvl(p_rec.abs_information27, hr_api.g_varchar2) or
3422: nvl(per_abs_shd.g_old_rec.abs_information28, hr_api.g_varchar2) <>
3423: nvl(p_rec.abs_information28, hr_api.g_varchar2) or
3424: nvl(per_abs_shd.g_old_rec.abs_information29, hr_api.g_varchar2) <>

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

3418: nvl(per_abs_shd.g_old_rec.abs_information26, hr_api.g_varchar2) <>
3419: nvl(p_rec.abs_information26, hr_api.g_varchar2) or
3420: nvl(per_abs_shd.g_old_rec.abs_information27, hr_api.g_varchar2) <>
3421: nvl(p_rec.abs_information27, hr_api.g_varchar2) or
3422: nvl(per_abs_shd.g_old_rec.abs_information28, hr_api.g_varchar2) <>
3423: nvl(p_rec.abs_information28, hr_api.g_varchar2) or
3424: nvl(per_abs_shd.g_old_rec.abs_information29, hr_api.g_varchar2) <>
3425: nvl(p_rec.abs_information29, hr_api.g_varchar2) or
3426: nvl(per_abs_shd.g_old_rec.abs_information30, hr_api.g_varchar2) <>

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

3420: nvl(per_abs_shd.g_old_rec.abs_information27, hr_api.g_varchar2) <>
3421: nvl(p_rec.abs_information27, hr_api.g_varchar2) or
3422: nvl(per_abs_shd.g_old_rec.abs_information28, hr_api.g_varchar2) <>
3423: nvl(p_rec.abs_information28, hr_api.g_varchar2) or
3424: nvl(per_abs_shd.g_old_rec.abs_information29, hr_api.g_varchar2) <>
3425: nvl(p_rec.abs_information29, hr_api.g_varchar2) or
3426: nvl(per_abs_shd.g_old_rec.abs_information30, hr_api.g_varchar2) <>
3427: nvl(p_rec.abs_information30, hr_api.g_varchar2) ))
3428: or (p_rec.absence_attendance_id is null) then

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

3422: nvl(per_abs_shd.g_old_rec.abs_information28, hr_api.g_varchar2) <>
3423: nvl(p_rec.abs_information28, hr_api.g_varchar2) or
3424: nvl(per_abs_shd.g_old_rec.abs_information29, hr_api.g_varchar2) <>
3425: nvl(p_rec.abs_information29, hr_api.g_varchar2) or
3426: nvl(per_abs_shd.g_old_rec.abs_information30, hr_api.g_varchar2) <>
3427: nvl(p_rec.abs_information30, hr_api.g_varchar2) ))
3428: or (p_rec.absence_attendance_id is null) then
3429: --
3430: -- Only execute the validation if absolutely necessary:

Line 3535: (p_rec in per_abs_shd.g_rec_type

3531: --
3532: -- ----------------------------------------------------------------------------
3533: --
3534: procedure chk_df
3535: (p_rec in per_abs_shd.g_rec_type
3536: ) is
3537: --
3538: l_proc varchar2(72) := g_package || 'chk_df';
3539: --

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

3540: begin
3541: hr_utility.set_location('Entering:'||l_proc,10);
3542: --
3543: if ((p_rec.absence_attendance_id is not null) and (
3544: nvl(per_abs_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
3545: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
3546: nvl(per_abs_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
3547: nvl(p_rec.attribute1, hr_api.g_varchar2) or
3548: nvl(per_abs_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

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

3542: --
3543: if ((p_rec.absence_attendance_id is not null) and (
3544: nvl(per_abs_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
3545: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
3546: nvl(per_abs_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
3547: nvl(p_rec.attribute1, hr_api.g_varchar2) or
3548: nvl(per_abs_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
3549: nvl(p_rec.attribute2, hr_api.g_varchar2) or
3550: nvl(per_abs_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

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

3544: nvl(per_abs_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
3545: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
3546: nvl(per_abs_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
3547: nvl(p_rec.attribute1, hr_api.g_varchar2) or
3548: nvl(per_abs_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
3549: nvl(p_rec.attribute2, hr_api.g_varchar2) or
3550: nvl(per_abs_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
3551: nvl(p_rec.attribute3, hr_api.g_varchar2) or
3552: nvl(per_abs_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

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

3546: nvl(per_abs_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
3547: nvl(p_rec.attribute1, hr_api.g_varchar2) or
3548: nvl(per_abs_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
3549: nvl(p_rec.attribute2, hr_api.g_varchar2) or
3550: nvl(per_abs_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
3551: nvl(p_rec.attribute3, hr_api.g_varchar2) or
3552: nvl(per_abs_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
3553: nvl(p_rec.attribute4, hr_api.g_varchar2) or
3554: nvl(per_abs_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

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

3548: nvl(per_abs_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
3549: nvl(p_rec.attribute2, hr_api.g_varchar2) or
3550: nvl(per_abs_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
3551: nvl(p_rec.attribute3, hr_api.g_varchar2) or
3552: nvl(per_abs_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
3553: nvl(p_rec.attribute4, hr_api.g_varchar2) or
3554: nvl(per_abs_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
3555: nvl(p_rec.attribute5, hr_api.g_varchar2) or
3556: nvl(per_abs_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

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

3550: nvl(per_abs_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
3551: nvl(p_rec.attribute3, hr_api.g_varchar2) or
3552: nvl(per_abs_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
3553: nvl(p_rec.attribute4, hr_api.g_varchar2) or
3554: nvl(per_abs_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
3555: nvl(p_rec.attribute5, hr_api.g_varchar2) or
3556: nvl(per_abs_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
3557: nvl(p_rec.attribute6, hr_api.g_varchar2) or
3558: nvl(per_abs_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

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

3552: nvl(per_abs_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
3553: nvl(p_rec.attribute4, hr_api.g_varchar2) or
3554: nvl(per_abs_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
3555: nvl(p_rec.attribute5, hr_api.g_varchar2) or
3556: nvl(per_abs_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
3557: nvl(p_rec.attribute6, hr_api.g_varchar2) or
3558: nvl(per_abs_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
3559: nvl(p_rec.attribute7, hr_api.g_varchar2) or
3560: nvl(per_abs_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

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

3554: nvl(per_abs_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
3555: nvl(p_rec.attribute5, hr_api.g_varchar2) or
3556: nvl(per_abs_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
3557: nvl(p_rec.attribute6, hr_api.g_varchar2) or
3558: nvl(per_abs_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
3559: nvl(p_rec.attribute7, hr_api.g_varchar2) or
3560: nvl(per_abs_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
3561: nvl(p_rec.attribute8, hr_api.g_varchar2) or
3562: nvl(per_abs_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

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

3556: nvl(per_abs_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
3557: nvl(p_rec.attribute6, hr_api.g_varchar2) or
3558: nvl(per_abs_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
3559: nvl(p_rec.attribute7, hr_api.g_varchar2) or
3560: nvl(per_abs_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
3561: nvl(p_rec.attribute8, hr_api.g_varchar2) or
3562: nvl(per_abs_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
3563: nvl(p_rec.attribute9, hr_api.g_varchar2) or
3564: nvl(per_abs_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

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

3558: nvl(per_abs_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
3559: nvl(p_rec.attribute7, hr_api.g_varchar2) or
3560: nvl(per_abs_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
3561: nvl(p_rec.attribute8, hr_api.g_varchar2) or
3562: nvl(per_abs_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
3563: nvl(p_rec.attribute9, hr_api.g_varchar2) or
3564: nvl(per_abs_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
3565: nvl(p_rec.attribute10, hr_api.g_varchar2) or
3566: nvl(per_abs_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

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

3560: nvl(per_abs_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
3561: nvl(p_rec.attribute8, hr_api.g_varchar2) or
3562: nvl(per_abs_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
3563: nvl(p_rec.attribute9, hr_api.g_varchar2) or
3564: nvl(per_abs_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
3565: nvl(p_rec.attribute10, hr_api.g_varchar2) or
3566: nvl(per_abs_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
3567: nvl(p_rec.attribute11, hr_api.g_varchar2) or
3568: nvl(per_abs_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

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

3562: nvl(per_abs_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
3563: nvl(p_rec.attribute9, hr_api.g_varchar2) or
3564: nvl(per_abs_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
3565: nvl(p_rec.attribute10, hr_api.g_varchar2) or
3566: nvl(per_abs_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
3567: nvl(p_rec.attribute11, hr_api.g_varchar2) or
3568: nvl(per_abs_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
3569: nvl(p_rec.attribute12, hr_api.g_varchar2) or
3570: nvl(per_abs_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

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

3564: nvl(per_abs_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
3565: nvl(p_rec.attribute10, hr_api.g_varchar2) or
3566: nvl(per_abs_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
3567: nvl(p_rec.attribute11, hr_api.g_varchar2) or
3568: nvl(per_abs_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
3569: nvl(p_rec.attribute12, hr_api.g_varchar2) or
3570: nvl(per_abs_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
3571: nvl(p_rec.attribute13, hr_api.g_varchar2) or
3572: nvl(per_abs_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

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

3566: nvl(per_abs_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
3567: nvl(p_rec.attribute11, hr_api.g_varchar2) or
3568: nvl(per_abs_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
3569: nvl(p_rec.attribute12, hr_api.g_varchar2) or
3570: nvl(per_abs_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
3571: nvl(p_rec.attribute13, hr_api.g_varchar2) or
3572: nvl(per_abs_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
3573: nvl(p_rec.attribute14, hr_api.g_varchar2) or
3574: nvl(per_abs_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

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

3568: nvl(per_abs_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
3569: nvl(p_rec.attribute12, hr_api.g_varchar2) or
3570: nvl(per_abs_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
3571: nvl(p_rec.attribute13, hr_api.g_varchar2) or
3572: nvl(per_abs_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
3573: nvl(p_rec.attribute14, hr_api.g_varchar2) or
3574: nvl(per_abs_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
3575: nvl(p_rec.attribute15, hr_api.g_varchar2) or
3576: nvl(per_abs_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

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

3570: nvl(per_abs_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
3571: nvl(p_rec.attribute13, hr_api.g_varchar2) or
3572: nvl(per_abs_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
3573: nvl(p_rec.attribute14, hr_api.g_varchar2) or
3574: nvl(per_abs_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
3575: nvl(p_rec.attribute15, hr_api.g_varchar2) or
3576: nvl(per_abs_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
3577: nvl(p_rec.attribute16, hr_api.g_varchar2) or
3578: nvl(per_abs_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

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

3572: nvl(per_abs_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
3573: nvl(p_rec.attribute14, hr_api.g_varchar2) or
3574: nvl(per_abs_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
3575: nvl(p_rec.attribute15, hr_api.g_varchar2) or
3576: nvl(per_abs_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
3577: nvl(p_rec.attribute16, hr_api.g_varchar2) or
3578: nvl(per_abs_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
3579: nvl(p_rec.attribute17, hr_api.g_varchar2) or
3580: nvl(per_abs_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

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

3574: nvl(per_abs_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
3575: nvl(p_rec.attribute15, hr_api.g_varchar2) or
3576: nvl(per_abs_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
3577: nvl(p_rec.attribute16, hr_api.g_varchar2) or
3578: nvl(per_abs_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
3579: nvl(p_rec.attribute17, hr_api.g_varchar2) or
3580: nvl(per_abs_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
3581: nvl(p_rec.attribute18, hr_api.g_varchar2) or
3582: nvl(per_abs_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

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

3576: nvl(per_abs_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
3577: nvl(p_rec.attribute16, hr_api.g_varchar2) or
3578: nvl(per_abs_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
3579: nvl(p_rec.attribute17, hr_api.g_varchar2) or
3580: nvl(per_abs_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
3581: nvl(p_rec.attribute18, hr_api.g_varchar2) or
3582: nvl(per_abs_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
3583: nvl(p_rec.attribute19, hr_api.g_varchar2) or
3584: nvl(per_abs_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

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

3578: nvl(per_abs_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
3579: nvl(p_rec.attribute17, hr_api.g_varchar2) or
3580: nvl(per_abs_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
3581: nvl(p_rec.attribute18, hr_api.g_varchar2) or
3582: nvl(per_abs_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
3583: nvl(p_rec.attribute19, hr_api.g_varchar2) or
3584: nvl(per_abs_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
3585: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
3586: or (p_rec.absence_attendance_id is null) then

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

3580: nvl(per_abs_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
3581: nvl(p_rec.attribute18, hr_api.g_varchar2) or
3582: nvl(per_abs_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
3583: nvl(p_rec.attribute19, hr_api.g_varchar2) or
3584: nvl(per_abs_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
3585: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
3586: or (p_rec.absence_attendance_id is null) then
3587: --
3588: -- Only execute the validation if absolutely necessary:

Line 3672: ,p_rec in per_abs_shd.g_rec_type

3668: -- {End Of Comments}
3669: -- ----------------------------------------------------------------------------
3670: Procedure chk_non_updateable_args
3671: (p_effective_date in date
3672: ,p_rec in per_abs_shd.g_rec_type
3673: ) IS
3674: --
3675: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
3676: l_error EXCEPTION;

Line 3684: IF NOT per_abs_shd.api_updating

3680: --
3681: -- Only proceed with the validation if a row exists for the current
3682: -- record in the HR Schema.
3683: --
3684: IF NOT per_abs_shd.api_updating
3685: (p_absence_attendance_id => p_rec.absence_attendance_id
3686: ,p_object_version_number => p_rec.object_version_number
3687: ) THEN
3688: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 3696: per_abs_shd.g_old_rec.absence_attendance_id then

3692: END IF;
3693: --
3694: hr_utility.set_location(l_proc, 2);
3695: if nvl(p_rec.absence_attendance_id,hr_api.g_number) <>
3696: per_abs_shd.g_old_rec.absence_attendance_id then
3697: l_argument := 'absence_attendance_id';
3698: raise l_error;
3699: end if;
3700: --

Line 3703: per_abs_shd.g_old_rec.business_group_id then

3699: end if;
3700: --
3701: hr_utility.set_location(l_proc, 3);
3702: if nvl(p_rec.business_group_id, hr_api.g_number) <>
3703: per_abs_shd.g_old_rec.business_group_id then
3704: l_argument := 'business_group_id';
3705: raise l_error;
3706: end if;
3707: --

Line 3710: per_abs_shd.g_old_rec.person_id then

3706: end if;
3707: --
3708: hr_utility.set_location(l_proc, 4);
3709: if nvl(p_rec.person_id, hr_api.g_number) <>
3710: per_abs_shd.g_old_rec.person_id then
3711: l_argument := 'person_id';
3712: raise l_error;
3713: end if;
3714: --

Line 3717: per_abs_shd.g_old_rec.absence_attendance_type_id then

3713: end if;
3714: --
3715: hr_utility.set_location(l_proc, 5);
3716: if nvl(p_rec.absence_attendance_type_id,hr_api.g_number) <>
3717: per_abs_shd.g_old_rec.absence_attendance_type_id then
3718: l_argument := 'absence_attendance_type_id';
3719: raise l_error;
3720: end if;
3721: --

Line 3724: per_abs_shd.g_old_rec.occurrence then

3720: end if;
3721: --
3722: hr_utility.set_location(l_proc, 6);
3723: if nvl(p_rec.occurrence,hr_api.g_number) <>
3724: per_abs_shd.g_old_rec.occurrence then
3725: l_argument := 'occurrence';
3726: raise l_error;
3727: end if;
3728: --

Line 3743: ,p_rec in per_abs_shd.g_rec_type

3739: -- |---------------------------< insert_validate >----------------------------|
3740: -- ----------------------------------------------------------------------------
3741: Procedure insert_validate
3742: (p_effective_date in date
3743: ,p_rec in per_abs_shd.g_rec_type
3744: ,p_dur_dys_less_warning out nocopy boolean
3745: ,p_dur_hrs_less_warning out nocopy boolean
3746: ,p_exceeds_pto_entit_warning out nocopy boolean
3747: ,p_exceeds_run_total_warning out nocopy boolean

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

3769:
3770: --
3771: -- Assign the durations to the global variables.
3772: --
3773: per_abs_shd.g_absence_days := p_rec.absence_days;
3774: per_abs_shd.g_absence_hours := p_rec.absence_hours;
3775:
3776: --
3777: -- Fix for bug 3371960 starts here. Use the l_effective_date

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

3770: --
3771: -- Assign the durations to the global variables.
3772: --
3773: per_abs_shd.g_absence_days := p_rec.absence_days;
3774: per_abs_shd.g_absence_hours := p_rec.absence_hours;
3775:
3776: --
3777: -- Fix for bug 3371960 starts here. Use the l_effective_date
3778: -- in chk procedures.

Line 3874: ,p_absence_days => per_abs_shd.g_absence_days

3870: ,p_ABS_INFORMATION3 =>p_rec.ABS_INFORMATION3
3871: ,p_ABS_INFORMATION4 =>p_rec.ABS_INFORMATION4
3872: ,p_ABS_INFORMATION5 =>p_rec.ABS_INFORMATION5
3873: ,p_ABS_INFORMATION6 =>p_rec.ABS_INFORMATION6
3874: ,p_absence_days => per_abs_shd.g_absence_days
3875: ,p_absence_hours => per_abs_shd.g_absence_hours
3876: ,p_dur_dys_less_warning => p_dur_dys_less_warning
3877: ,p_dur_hrs_less_warning => p_dur_hrs_less_warning
3878: ,p_exceeds_pto_entit_warning => p_exceeds_pto_entit_warning

Line 3875: ,p_absence_hours => per_abs_shd.g_absence_hours

3871: ,p_ABS_INFORMATION4 =>p_rec.ABS_INFORMATION4
3872: ,p_ABS_INFORMATION5 =>p_rec.ABS_INFORMATION5
3873: ,p_ABS_INFORMATION6 =>p_rec.ABS_INFORMATION6
3874: ,p_absence_days => per_abs_shd.g_absence_days
3875: ,p_absence_hours => per_abs_shd.g_absence_hours
3876: ,p_dur_dys_less_warning => p_dur_dys_less_warning
3877: ,p_dur_hrs_less_warning => p_dur_hrs_less_warning
3878: ,p_exceeds_pto_entit_warning => p_exceeds_pto_entit_warning
3879: ,p_exceeds_run_total_warning => p_exceeds_run_total_warning

Line 3925: ,p_rec in per_abs_shd.g_rec_type

3921: -- |---------------------------< update_validate >----------------------------|
3922: -- ----------------------------------------------------------------------------
3923: Procedure update_validate
3924: (p_effective_date in date
3925: ,p_rec in per_abs_shd.g_rec_type
3926: ,p_dur_dys_less_warning out nocopy boolean
3927: ,p_dur_hrs_less_warning out nocopy boolean
3928: ,p_exceeds_pto_entit_warning out nocopy boolean
3929: ,p_exceeds_run_total_warning out nocopy boolean

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

3947: -- Fix for bug 3371960 ends here.
3948: --
3949: -- Assign the durations to the global variables.
3950: --
3951: per_abs_shd.g_absence_days := p_rec.absence_days;
3952: per_abs_shd.g_absence_hours := p_rec.absence_hours;
3953:
3954: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
3955: --

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

3948: --
3949: -- Assign the durations to the global variables.
3950: --
3951: per_abs_shd.g_absence_days := p_rec.absence_days;
3952: per_abs_shd.g_absence_hours := p_rec.absence_hours;
3953:
3954: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
3955: --
3956: chk_non_updateable_args

Line 4035: ,p_absence_days => per_abs_shd.g_absence_days

4031: ,p_ABS_INFORMATION3 =>p_rec.ABS_INFORMATION3
4032: ,p_ABS_INFORMATION4 =>p_rec.ABS_INFORMATION4
4033: ,p_ABS_INFORMATION5 =>p_rec.ABS_INFORMATION5
4034: ,p_ABS_INFORMATION6 =>p_rec.ABS_INFORMATION6
4035: ,p_absence_days => per_abs_shd.g_absence_days
4036: ,p_absence_hours => per_abs_shd.g_absence_hours
4037: ,p_dur_dys_less_warning => p_dur_dys_less_warning
4038: ,p_dur_hrs_less_warning => p_dur_hrs_less_warning
4039: ,p_exceeds_pto_entit_warning => p_exceeds_pto_entit_warning

Line 4036: ,p_absence_hours => per_abs_shd.g_absence_hours

4032: ,p_ABS_INFORMATION4 =>p_rec.ABS_INFORMATION4
4033: ,p_ABS_INFORMATION5 =>p_rec.ABS_INFORMATION5
4034: ,p_ABS_INFORMATION6 =>p_rec.ABS_INFORMATION6
4035: ,p_absence_days => per_abs_shd.g_absence_days
4036: ,p_absence_hours => per_abs_shd.g_absence_hours
4037: ,p_dur_dys_less_warning => p_dur_dys_less_warning
4038: ,p_dur_hrs_less_warning => p_dur_hrs_less_warning
4039: ,p_exceeds_pto_entit_warning => p_exceeds_pto_entit_warning
4040: ,p_exceeds_run_total_warning => p_exceeds_run_total_warning

Line 4086: (p_rec in per_abs_shd.g_rec_type

4082: -- ----------------------------------------------------------------------------
4083: -- |---------------------------< delete_validate >----------------------------|
4084: -- ----------------------------------------------------------------------------
4085: Procedure delete_validate
4086: (p_rec in per_abs_shd.g_rec_type
4087: ) is
4088: --
4089: l_proc varchar2(72) := g_package||'delete_validate';
4090: --