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

APPS.PER_ABS_BUS dependencies on HR_API

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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 1160: = nvl(p_date_start, hr_api.g_date)

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)
1164: = nvl(p_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 1162: = nvl(p_date_end, hr_api.g_date)

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)
1166: = nvl(p_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 1164: = nvl(p_time_start, hr_api.g_varchar2)

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)
1168: = nvl(p_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 1166: = nvl(p_time_end, hr_api.g_varchar2)

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)
1170: = nvl(p_absence_hours, hr_api.g_number)) then

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 1168: = nvl(p_absence_days, hr_api.g_number)

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;
1172: end if;

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 1170: = nvl(p_absence_hours, hr_api.g_number)) then

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:
1174: hr_utility.set_location(l_proc, 15);

Line 1195: l_legislation_code := hr_api.return_legislation_code

1191: l_assignment_id := hr_person_absence_api.get_primary_assignment
1192: (p_person_id => p_person_id
1193: ,p_effective_date => p_effective_date);
1194:
1195: l_legislation_code := hr_api.return_legislation_code
1196: (p_business_group_id => p_business_group_id);
1197:
1198: open c_get_absence_info;
1199: fetch c_get_absence_info into l_hours_or_days,

Line 1758: hr_api.mandatory_arg_error

1754: begin
1755:
1756: hr_utility.set_location('Entering:'|| l_proc, 10);
1757: --
1758: hr_api.mandatory_arg_error
1759: (p_api_name => l_proc
1760: ,p_argument => 'p_person_id'
1761: ,p_argument_value => p_person_id
1762: );

Line 1763: hr_api.mandatory_arg_error

1759: (p_api_name => l_proc
1760: ,p_argument => 'p_person_id'
1761: ,p_argument_value => p_person_id
1762: );
1763: hr_api.mandatory_arg_error
1764: (p_api_name => l_proc
1765: ,p_argument => 'p_business_group_id'
1766: ,p_argument_value => p_business_group_id
1767: );

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 1780: = nvl(p_date_projected_start, hr_api.g_date)

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)
1784: = nvl(p_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 1782: = nvl(p_date_projected_end, hr_api.g_date)

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)
1786: = nvl(p_date_end, hr_api.g_date)) then

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 1784: = nvl(p_date_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;
1788: end if;

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 1786: = nvl(p_date_end, hr_api.g_date)) then

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

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

1862: from per_absence_attendance_types abt
1863: where abt.absence_attendance_type_id = p_absence_attendance_type_id
1864: and abt.business_group_id = p_business_group_id
1865: and (p_date_projected_start is null or p_date_projected_start
1866: between abt.date_effective and nvl(abt.date_end,hr_api.g_eot))
1867: and (p_date_projected_end is null or p_date_projected_end
1868: between abt.date_effective and nvl(abt.date_end,hr_api.g_eot))
1869: and (p_date_start is null or p_date_start
1870: between abt.date_effective and nvl(abt.date_end,hr_api.g_eot))

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

1864: and abt.business_group_id = p_business_group_id
1865: and (p_date_projected_start is null or p_date_projected_start
1866: between abt.date_effective and nvl(abt.date_end,hr_api.g_eot))
1867: and (p_date_projected_end is null or p_date_projected_end
1868: between abt.date_effective and nvl(abt.date_end,hr_api.g_eot))
1869: and (p_date_start is null or p_date_start
1870: between abt.date_effective and nvl(abt.date_end,hr_api.g_eot))
1871: and (p_date_end is null or p_date_end
1872: between abt.date_effective and nvl(abt.date_end,hr_api.g_eot));

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

1866: between abt.date_effective and nvl(abt.date_end,hr_api.g_eot))
1867: and (p_date_projected_end is null or p_date_projected_end
1868: between abt.date_effective and nvl(abt.date_end,hr_api.g_eot))
1869: and (p_date_start is null or p_date_start
1870: between abt.date_effective and nvl(abt.date_end,hr_api.g_eot))
1871: and (p_date_end is null or p_date_end
1872: between abt.date_effective and nvl(abt.date_end,hr_api.g_eot));
1873:
1874: --

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

1868: between abt.date_effective and nvl(abt.date_end,hr_api.g_eot))
1869: and (p_date_start is null or p_date_start
1870: between abt.date_effective and nvl(abt.date_end,hr_api.g_eot))
1871: and (p_date_end is null or p_date_end
1872: between abt.date_effective and nvl(abt.date_end,hr_api.g_eot));
1873:
1874: --
1875: begin
1876:

Line 1882: hr_api.mandatory_arg_error

1878: --
1879: --
1880: -- Check mandatory parameters have been set
1881: --
1882: hr_api.mandatory_arg_error
1883: (p_api_name => l_proc
1884: ,p_argument => 'p_absence_attendance_type_id'
1885: ,p_argument_value => p_absence_attendance_type_id
1886: );

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 1899: = nvl(p_date_projected_start, hr_api.g_date)

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)
1903: = nvl(p_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 1901: = nvl(p_date_projected_end, hr_api.g_date)

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)
1905: = nvl(p_date_end, hr_api.g_date)) then

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 1903: = nvl(p_date_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;
1907: end if;

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 1905: = nvl(p_date_end, hr_api.g_date)) then

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:
1909: hr_utility.set_location(l_proc, 15);

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

1987: and abr.abs_attendance_reason_id = p_abs_attendance_reason_id
1988: and abr.name = hrl.lookup_code
1989: and hrl.lookup_type = 'ABSENCE_REASON'
1990: and p_effective_date between
1991: nvl(hrl.start_date_active,hr_api.g_sot)
1992: and nvl(hrl.end_date_active,hr_api.g_eot)
1993: and hrl.enabled_flag = 'Y';
1994: --
1995: begin

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

1988: and abr.name = hrl.lookup_code
1989: and hrl.lookup_type = 'ABSENCE_REASON'
1990: and p_effective_date between
1991: nvl(hrl.start_date_active,hr_api.g_sot)
1992: and nvl(hrl.end_date_active,hr_api.g_eot)
1993: and hrl.enabled_flag = 'Y';
1994: --
1995: begin
1996:

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

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:
2017: open csr_valid_abs_reason;

Line 2285: and (abs.date_start between p_date_start AND nvl(p_date_end,hr_api.g_eot)

2281: and (p_absence_attendance_id is null or
2282: p_absence_attendance_id <> abs.absence_attendance_id)
2283: and abs.date_start is not null
2284: and p_date_start is not null
2285: and (abs.date_start between p_date_start AND nvl(p_date_end,hr_api.g_eot)
2286: OR
2287: p_date_start between abs.date_start and nvl(abs.date_end,hr_api.g_eot) )
2288: order by 1;
2289: -- Added for Bug11902652

Line 2287: p_date_start between abs.date_start and nvl(abs.date_end,hr_api.g_eot) )

2283: and abs.date_start is not null
2284: and p_date_start is not null
2285: and (abs.date_start between p_date_start AND nvl(p_date_end,hr_api.g_eot)
2286: OR
2287: p_date_start between abs.date_start and nvl(abs.date_end,hr_api.g_eot) )
2288: order by 1;
2289: -- Added for Bug11902652
2290:
2291: cursor c_abs_day_after_another is

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 2400: = nvl(p_date_projected_start, hr_api.g_date)

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)
2404: = nvl(p_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 2402: = nvl(p_time_projected_start, hr_api.g_varchar2)

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)
2406: = nvl(p_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 2404: = nvl(p_date_projected_end, 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)
2408: = nvl(p_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 2406: = nvl(p_time_projected_end, 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)
2410: = nvl(p_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 2408: = nvl(p_date_start, 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)
2412: = nvl(p_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 2410: = nvl(p_time_start, 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)
2414: = nvl(p_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 2412: = nvl(p_date_end, 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)
2416: = nvl(p_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 2414: = nvl(p_time_end, 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)
2418: = nvl(p_absence_hours, hr_api.g_number)) then

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 2416: = nvl(p_absence_days, hr_api.g_number)

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;
2420: end if;

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 2418: = nvl(p_absence_hours, hr_api.g_number)) then

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

Line 3038: hr_api.mandatory_arg_error

3034: begin
3035:
3036: hr_utility.set_location('Entering:'|| l_proc, 10);
3037: --
3038: hr_api.mandatory_arg_error
3039: (p_api_name => l_proc
3040: ,p_argument => 'p_business_group_id'
3041: ,p_argument_value => p_business_group_id
3042: );

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 3055: = nvl(p_replacement_person_id, hr_api.g_number)

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)
3059: = nvl(p_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 3057: = nvl(p_date_projected_start, hr_api.g_date)

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)
3061: = nvl(p_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 3059: = nvl(p_date_projected_end, hr_api.g_date)

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)
3063: = nvl(p_date_end, hr_api.g_date)) then

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 3061: = nvl(p_date_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;
3065: end if;

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 3063: = nvl(p_date_end, hr_api.g_date)) then

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:
3067: if p_replacement_person_id is not null then

Line 3141: hr_api.mandatory_arg_error

3137: begin
3138:
3139: hr_utility.set_location('Entering:'|| l_proc, 10);
3140: --
3141: hr_api.mandatory_arg_error
3142: (p_api_name => l_proc
3143: ,p_argument => 'p_business_group_id'
3144: ,p_argument_value => p_business_group_id
3145: );

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 3158: = nvl(p_authorising_person_id, hr_api.g_number)

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)
3162: = nvl(p_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 3160: = nvl(p_date_projected_start, hr_api.g_date)

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)
3164: = nvl(p_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 3162: = nvl(p_date_projected_end, hr_api.g_date)

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)
3166: = nvl(p_date_end, hr_api.g_date)) then

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 3164: = nvl(p_date_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;
3168: end if;

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 3166: = nvl(p_date_end, hr_api.g_date)) then

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:
3170: if p_authorising_person_id is not null then

Line 3223: hr_api.mandatory_arg_error

3219: hr_utility.set_location('Entering:'|| l_proc, 10);
3220: --
3221: -- Ensure that all the mandatory parameter are not null
3222: --
3223: hr_api.mandatory_arg_error
3224: (p_api_name => l_proc
3225: ,p_argument => 'absence_attendance_id'
3226: ,p_argument_value => p_absence_attendance_id
3227: );

Line 3246: hr_api.set_security_group_id

3242: close csr_sec_grp;
3243: --
3244: -- Set the security_group_id in CLIENT_INFO
3245: --
3246: hr_api.set_security_group_id
3247: (p_security_group_id => l_security_group_id
3248: );
3249: --
3250: hr_utility.set_location(' Leaving:'|| l_proc, 20);

Line 3283: hr_api.mandatory_arg_error

3279: hr_utility.set_location('Entering:'|| l_proc, 10);
3280: --
3281: -- Ensure that all the mandatory parameter are not null
3282: --
3283: hr_api.mandatory_arg_error
3284: (p_api_name => l_proc
3285: ,p_argument => 'absence_attendance_id'
3286: ,p_argument_value => p_absence_attendance_id
3287: );

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

3285: ,p_argument => 'absence_attendance_id'
3286: ,p_argument_value => p_absence_attendance_id
3287: );
3288: --
3289: if ( nvl(per_abs_bus.g_absence_attendance_id, hr_api.g_number)
3290: = p_absence_attendance_id) then
3291: --
3292: -- The legislation code has already been found with a previous
3293: -- call to this function. Just return the value in the global

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 3367: nvl(p_rec.abs_information_category, hr_api.g_varchar2) or

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) <>
3371: nvl(p_rec.abs_information2, hr_api.g_varchar2) or

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 3369: nvl(p_rec.abs_information1, hr_api.g_varchar2) or

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) <>
3373: nvl(p_rec.abs_information3, hr_api.g_varchar2) or

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 3371: nvl(p_rec.abs_information2, hr_api.g_varchar2) or

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) <>
3375: nvl(p_rec.abs_information4, hr_api.g_varchar2) or

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 3373: nvl(p_rec.abs_information3, hr_api.g_varchar2) or

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) <>
3377: nvl(p_rec.abs_information5, hr_api.g_varchar2) or

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 3375: nvl(p_rec.abs_information4, hr_api.g_varchar2) or

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) <>
3379: nvl(p_rec.abs_information6, hr_api.g_varchar2) or

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 3377: nvl(p_rec.abs_information5, hr_api.g_varchar2) or

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) <>
3381: nvl(p_rec.abs_information7, hr_api.g_varchar2) or

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 3379: nvl(p_rec.abs_information6, hr_api.g_varchar2) or

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) <>
3383: nvl(p_rec.abs_information8, hr_api.g_varchar2) or

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 3381: nvl(p_rec.abs_information7, hr_api.g_varchar2) or

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) <>
3385: nvl(p_rec.abs_information9, hr_api.g_varchar2) or

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 3383: nvl(p_rec.abs_information8, hr_api.g_varchar2) or

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) <>
3387: nvl(p_rec.abs_information10, hr_api.g_varchar2) or

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 3385: nvl(p_rec.abs_information9, hr_api.g_varchar2) or

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) <>
3389: nvl(p_rec.abs_information11, hr_api.g_varchar2) or

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 3387: nvl(p_rec.abs_information10, hr_api.g_varchar2) or

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) <>
3391: nvl(p_rec.abs_information12, hr_api.g_varchar2) or

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 3389: nvl(p_rec.abs_information11, hr_api.g_varchar2) or

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) <>
3393: nvl(p_rec.abs_information13, hr_api.g_varchar2) or

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 3391: nvl(p_rec.abs_information12, hr_api.g_varchar2) or

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) <>
3395: nvl(p_rec.abs_information14, hr_api.g_varchar2) or

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 3393: nvl(p_rec.abs_information13, hr_api.g_varchar2) or

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) <>
3397: nvl(p_rec.abs_information15, hr_api.g_varchar2) or

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 3395: nvl(p_rec.abs_information14, hr_api.g_varchar2) or

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) <>
3399: nvl(p_rec.abs_information16, hr_api.g_varchar2) or

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 3397: nvl(p_rec.abs_information15, hr_api.g_varchar2) or

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) <>
3401: nvl(p_rec.abs_information17, hr_api.g_varchar2) or

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 3399: nvl(p_rec.abs_information16, hr_api.g_varchar2) or

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) <>
3403: nvl(p_rec.abs_information18, hr_api.g_varchar2) or

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 3401: nvl(p_rec.abs_information17, hr_api.g_varchar2) or

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) <>
3405: nvl(p_rec.abs_information19, hr_api.g_varchar2) or

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 3403: nvl(p_rec.abs_information18, hr_api.g_varchar2) or

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) <>
3407: nvl(p_rec.abs_information20, hr_api.g_varchar2) or

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 3405: nvl(p_rec.abs_information19, hr_api.g_varchar2) or

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) <>
3409: nvl(p_rec.abs_information21, hr_api.g_varchar2) or

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 3407: nvl(p_rec.abs_information20, hr_api.g_varchar2) or

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) <>
3411: nvl(p_rec.abs_information22, hr_api.g_varchar2) or

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 3409: nvl(p_rec.abs_information21, hr_api.g_varchar2) or

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) <>
3413: nvl(p_rec.abs_information23, hr_api.g_varchar2) or

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 3411: nvl(p_rec.abs_information22, hr_api.g_varchar2) or

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) <>
3415: nvl(p_rec.abs_information24, hr_api.g_varchar2) or

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 3413: nvl(p_rec.abs_information23, hr_api.g_varchar2) or

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) <>
3417: nvl(p_rec.abs_information25, hr_api.g_varchar2) or

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 3415: nvl(p_rec.abs_information24, hr_api.g_varchar2) or

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) <>
3419: nvl(p_rec.abs_information26, hr_api.g_varchar2) or

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 3417: nvl(p_rec.abs_information25, hr_api.g_varchar2) or

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) <>
3421: nvl(p_rec.abs_information27, hr_api.g_varchar2) or

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 3419: nvl(p_rec.abs_information26, hr_api.g_varchar2) or

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) <>
3423: nvl(p_rec.abs_information28, hr_api.g_varchar2) or

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 3421: nvl(p_rec.abs_information27, hr_api.g_varchar2) or

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) <>
3425: nvl(p_rec.abs_information29, hr_api.g_varchar2) or

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 3423: nvl(p_rec.abs_information28, hr_api.g_varchar2) or

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) <>
3427: nvl(p_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 3425: nvl(p_rec.abs_information29, hr_api.g_varchar2) or

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

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 3427: nvl(p_rec.abs_information30, 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:
3431: -- a) During update, the structure column value or any

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 3545: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

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) <>
3549: nvl(p_rec.attribute2, hr_api.g_varchar2) or

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 3547: nvl(p_rec.attribute1, hr_api.g_varchar2) or

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) <>
3551: nvl(p_rec.attribute3, hr_api.g_varchar2) or

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 3549: nvl(p_rec.attribute2, hr_api.g_varchar2) or

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) <>
3553: nvl(p_rec.attribute4, hr_api.g_varchar2) or

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 3551: nvl(p_rec.attribute3, hr_api.g_varchar2) or

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) <>
3555: nvl(p_rec.attribute5, hr_api.g_varchar2) or

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 3553: nvl(p_rec.attribute4, hr_api.g_varchar2) or

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) <>
3557: nvl(p_rec.attribute6, hr_api.g_varchar2) or

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 3555: nvl(p_rec.attribute5, hr_api.g_varchar2) or

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) <>
3559: nvl(p_rec.attribute7, hr_api.g_varchar2) or

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 3557: nvl(p_rec.attribute6, hr_api.g_varchar2) or

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) <>
3561: nvl(p_rec.attribute8, hr_api.g_varchar2) or

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 3559: nvl(p_rec.attribute7, hr_api.g_varchar2) or

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) <>
3563: nvl(p_rec.attribute9, hr_api.g_varchar2) or

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 3561: nvl(p_rec.attribute8, hr_api.g_varchar2) or

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) <>
3565: nvl(p_rec.attribute10, hr_api.g_varchar2) or

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 3563: nvl(p_rec.attribute9, hr_api.g_varchar2) or

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) <>
3567: nvl(p_rec.attribute11, hr_api.g_varchar2) or

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 3565: nvl(p_rec.attribute10, hr_api.g_varchar2) or

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) <>
3569: nvl(p_rec.attribute12, hr_api.g_varchar2) or

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 3567: nvl(p_rec.attribute11, hr_api.g_varchar2) or

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) <>
3571: nvl(p_rec.attribute13, hr_api.g_varchar2) or

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 3569: nvl(p_rec.attribute12, hr_api.g_varchar2) or

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) <>
3573: nvl(p_rec.attribute14, hr_api.g_varchar2) or

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 3571: nvl(p_rec.attribute13, hr_api.g_varchar2) or

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) <>
3575: nvl(p_rec.attribute15, hr_api.g_varchar2) or

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 3573: nvl(p_rec.attribute14, hr_api.g_varchar2) or

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) <>
3577: nvl(p_rec.attribute16, hr_api.g_varchar2) or

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 3575: nvl(p_rec.attribute15, hr_api.g_varchar2) or

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) <>
3579: nvl(p_rec.attribute17, hr_api.g_varchar2) or

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 3577: nvl(p_rec.attribute16, hr_api.g_varchar2) or

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) <>
3581: nvl(p_rec.attribute18, hr_api.g_varchar2) or

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 3579: nvl(p_rec.attribute17, hr_api.g_varchar2) or

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) <>
3583: nvl(p_rec.attribute19, hr_api.g_varchar2) or

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 3581: nvl(p_rec.attribute18, hr_api.g_varchar2) or

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) <>
3585: nvl(p_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 3583: nvl(p_rec.attribute19, hr_api.g_varchar2) or

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

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 3585: nvl(p_rec.attribute20, 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:
3589: -- a) During update, the structure column value or any

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

3691: fnd_message.raise_error;
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;

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

3698: raise l_error;
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;

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

3705: raise l_error;
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;

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

3712: raise l_error;
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;

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

3719: raise l_error;
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;

Line 3731: hr_api.argument_changed_error

3727: end if;
3728: --
3729: EXCEPTION
3730: WHEN l_error THEN
3731: hr_api.argument_changed_error
3732: (p_api_name => l_proc
3733: ,p_argument => l_argument);
3734: WHEN OTHERS THEN
3735: RAISE;

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

3782: -- Fix for bug 3371960 ends here.
3783: --
3784: -- Check the business group id.
3785: --
3786: hr_api.validate_bus_grp_id(p_rec.business_group_id);
3787:
3788: hr_utility.set_location(l_proc, 10);
3789:
3790: ----Check the gender of the person in case of maternity leave bug# 6505054

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

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
3957: (p_effective_date => p_effective_date
3958: ,p_rec => p_rec