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_ABB_BUS dependencies on HR_API

Line 46: hr_api.mandatory_arg_error

42: hr_utility.set_location('Entering:'|| l_proc, 10);
43: --
44: -- Ensure that all the mandatory parameter are not null
45: --
46: hr_api.mandatory_arg_error
47: (p_api_name => l_proc
48: ,p_argument => 'absence_attendance_type_id'
49: ,p_argument_value => p_absence_attendance_type_id
50: );

Line 52: if ( nvl(per_abb_bus.g_absence_attendance_type_id, hr_api.g_number)

48: ,p_argument => 'absence_attendance_type_id'
49: ,p_argument_value => p_absence_attendance_type_id
50: );
51: --
52: if ( nvl(per_abb_bus.g_absence_attendance_type_id, hr_api.g_number)
53: = p_absence_attendance_type_id) then
54: --
55: -- The legislation code has already been found with a previous
56: -- call to this function. Just return the value in the global

Line 145: hr_api.mandatory_arg_error

141: hr_utility.set_location('Entering:'||l_proc,10);
142: --
143: -- Check mandatory parameters have been set
144: --
145: hr_api.mandatory_arg_error
146: (p_api_name => l_proc
147: ,p_argument => 'date_effective'
148: ,p_argument_value => p_date_effective
149: );

Line 163: if p_date_effective > nvl (p_date_end,hr_api.g_eot) then

159: if ( (l_api_updating and (p_date_effective <> per_abb_shd.g_old_rec.date_effective
160: or p_date_end <> per_abb_shd.g_old_rec.date_end))
161: or not l_api_updating) then
162: --
163: if p_date_effective > nvl (p_date_end,hr_api.g_eot) then
164: fnd_message.set_name('PER','PER_7003_ALL_DATE_FROM_TO');
165: fnd_message.raise_error;
166: end if;
167: --

Line 265: and nvl(l_date_end,hr_api.g_eot) between

261: and p_date_effective between piv1.effective_start_date and piv1.effective_end_date
262: and exists (select 1
263: from pay_input_values_f piv2
264: where piv1.input_value_id = piv2.input_value_id
265: and nvl(l_date_end,hr_api.g_eot) between
266: piv2.effective_start_date and piv2.effective_end_date);
267: --
268: cursor csr_valid_input_value_uom is
269: select 1

Line 306: or nvl(per_abb_shd.g_old_rec.date_end,hr_api.g_eot) <>

302: --
303: if ( (l_api_updating and
304: ( nvl(per_abb_shd.g_old_rec.input_value_id,-1) <> nvl(p_input_value_id,-1)
305: or per_abb_shd.g_old_rec.date_effective <> p_date_effective
306: or nvl(per_abb_shd.g_old_rec.date_end,hr_api.g_eot) <>
307: nvl(p_date_end,hr_api.g_eot)))
308: or not l_api_updating)
309: then
310: --

Line 307: nvl(p_date_end,hr_api.g_eot)))

303: if ( (l_api_updating and
304: ( nvl(per_abb_shd.g_old_rec.input_value_id,-1) <> nvl(p_input_value_id,-1)
305: or per_abb_shd.g_old_rec.date_effective <> p_date_effective
306: or nvl(per_abb_shd.g_old_rec.date_end,hr_api.g_eot) <>
307: nvl(p_date_end,hr_api.g_eot)))
308: or not l_api_updating)
309: then
310: --
311: hr_utility.set_location(l_proc,20);

Line 352: and l_input_end < hr_api.g_eot then

348: fetch csr_input_end into l_input_end;
349: close csr_input_end;
350: --
351: if p_date_end is null
352: and l_input_end < hr_api.g_eot then
353: l_date_end := l_input_end; --auto-populate date_end if input has end date
354: elsif p_date_end is not null
355: and p_date_end > l_input_end then
356: fnd_message.set_name('PER','PER_7800_DEF_ABS_ELEMENT_ENDS');

Line 550: ( nvl(per_abb_shd.g_old_rec.increasing_or_decreasing_flag,hr_api.g_varchar2) <>

546: -- a) rec is being inserted or
547: -- b) rec is updating and the g_old_rec is not current value
548: --
549: if (l_api_updating and
550: ( nvl(per_abb_shd.g_old_rec.increasing_or_decreasing_flag,hr_api.g_varchar2) <>
551: nvl(p_inc_or_dec_flag,hr_api.g_varchar2)
552: or nvl(per_abb_shd.g_old_rec.input_value_id,-1) <> nvl(p_input_value_id,-1))
553: or not l_api_updating)
554: then

Line 551: nvl(p_inc_or_dec_flag,hr_api.g_varchar2)

547: -- b) rec is updating and the g_old_rec is not current value
548: --
549: if (l_api_updating and
550: ( nvl(per_abb_shd.g_old_rec.increasing_or_decreasing_flag,hr_api.g_varchar2) <>
551: nvl(p_inc_or_dec_flag,hr_api.g_varchar2)
552: or nvl(per_abb_shd.g_old_rec.input_value_id,-1) <> nvl(p_input_value_id,-1))
553: or not l_api_updating)
554: then
555: --

Line 567: if nvl(p_inc_or_dec_flag,hr_api.g_varchar2) not in ('I','D') then

563: --
564: else
565: -- input_value_id is not null so inc_or_dec_flag must be specified
566: --
567: if nvl(p_inc_or_dec_flag,hr_api.g_varchar2) not in ('I','D') then
568: fnd_message.set_name('PER','HR_7583_ALL_MAN_INC_FIELD');
569: fnd_message.raise_error;
570: end if;
571: --

Line 576: and nvl(p_inc_or_dec_flag,hr_api.g_varchar2) <>

572: hr_utility.set_location(l_proc,30);
573: --
574: if l_api_updating
575: and per_abb_shd.g_old_rec.increasing_or_decreasing_flag is not null
576: and nvl(p_inc_or_dec_flag,hr_api.g_varchar2) <>
577: per_abb_shd.g_old_rec.increasing_or_decreasing_flag then
578: --
579: --flag must not be changed once it is not null
580: --

Line 659: ( nvl(per_abb_shd.g_old_rec.hours_or_days,hr_api.g_varchar2) <>

655: -- a) rec is being inserted or
656: -- b) rec is updating and the g_old_rec is not current value
657: --
658: if (l_api_updating and
659: ( nvl(per_abb_shd.g_old_rec.hours_or_days,hr_api.g_varchar2) <>
660: nvl(p_hours_or_days,hr_api.g_varchar2)
661: or nvl(per_abb_shd.g_old_rec.input_value_id,-1) <> nvl(p_input_value_id,-1))
662: or not l_api_updating)
663: then

Line 660: nvl(p_hours_or_days,hr_api.g_varchar2)

656: -- b) rec is updating and the g_old_rec is not current value
657: --
658: if (l_api_updating and
659: ( nvl(per_abb_shd.g_old_rec.hours_or_days,hr_api.g_varchar2) <>
660: nvl(p_hours_or_days,hr_api.g_varchar2)
661: or nvl(per_abb_shd.g_old_rec.input_value_id,-1) <> nvl(p_input_value_id,-1))
662: or not l_api_updating)
663: then
664: --

Line 676: and nvl(p_hours_or_days,hr_api.g_varchar2) <>

672: hr_utility.set_location(l_proc,20);
673: --
674: if l_api_updating
675: and per_abb_shd.g_old_rec.hours_or_days is not null
676: and nvl(p_hours_or_days,hr_api.g_varchar2) <>
677: per_abb_shd.g_old_rec.hours_or_days then
678: --
679: --flag must not be changed once it is not null
680: --

Line 772: (nvl(per_abb_shd.g_old_rec.absence_category,hr_api.g_varchar2) <> nvl(p_absence_category,hr_api.g_varchar2))

768: -- a) rec is being inserted or
769: -- b) rec is updating and the g_old_rec is not current value
770: --
771: if (l_api_updating and
772: (nvl(per_abb_shd.g_old_rec.absence_category,hr_api.g_varchar2) <> nvl(p_absence_category,hr_api.g_varchar2))
773: or not l_api_updating)
774: then
775: --
776: hr_utility.set_location(l_proc,20);

Line 779: and hr_api.not_exists_in_leg_lookups

775: --
776: hr_utility.set_location(l_proc,20);
777: --
778: if p_absence_category is not null
779: and hr_api.not_exists_in_leg_lookups
780: (p_effective_date => p_date_effective
781: ,p_lookup_type => 'ABSENCE_CATEGORY'
782: ,p_lookup_code => p_absence_category
783: )

Line 799: nvl(p_absence_category,hr_api.g_varchar2)

795: --
796: if csr_absence_attendance%found
797: and per_abb_shd.g_old_rec.absence_category is not null
798: and per_abb_shd.g_old_rec.absence_category <>
799: nvl(p_absence_category,hr_api.g_varchar2)
800: then
801: close csr_absence_attendance;
802: fnd_message.set_name('PER','HR_6383_ABS_DET_NO_CHANGE');
803: fnd_message.raise_error;

Line 897: (nvl(per_abb_shd.g_old_rec.information_category,hr_api.g_varchar2) <> nvl(p_information_category,hr_api.g_varchar2))

893: -- a) rec is being inserted or
894: -- b) rec is updating and the g_old_rec is not current value
895: --
896: if (l_api_updating and
897: (nvl(per_abb_shd.g_old_rec.information_category,hr_api.g_varchar2) <> nvl(p_information_category,hr_api.g_varchar2))
898: or not l_api_updating)
899: then
900: --
901: hr_utility.set_location(l_proc,10);

Line 1069: nvl(per_abb_shd.g_old_rec.information_category, hr_api.g_varchar2) <>

1065: begin
1066: hr_utility.set_location('Entering:'||l_proc,10);
1067: --
1068: if ((p_rec.absence_attendance_type_id is not null) and (
1069: nvl(per_abb_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
1070: nvl(p_rec.information_category, hr_api.g_varchar2) or
1071: nvl(per_abb_shd.g_old_rec.information1, hr_api.g_varchar2) <>
1072: nvl(p_rec.information1, hr_api.g_varchar2) or
1073: nvl(per_abb_shd.g_old_rec.information2, hr_api.g_varchar2) <>

Line 1070: nvl(p_rec.information_category, hr_api.g_varchar2) or

1066: hr_utility.set_location('Entering:'||l_proc,10);
1067: --
1068: if ((p_rec.absence_attendance_type_id is not null) and (
1069: nvl(per_abb_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
1070: nvl(p_rec.information_category, hr_api.g_varchar2) or
1071: nvl(per_abb_shd.g_old_rec.information1, hr_api.g_varchar2) <>
1072: nvl(p_rec.information1, hr_api.g_varchar2) or
1073: nvl(per_abb_shd.g_old_rec.information2, hr_api.g_varchar2) <>
1074: nvl(p_rec.information2, hr_api.g_varchar2) or

Line 1071: nvl(per_abb_shd.g_old_rec.information1, hr_api.g_varchar2) <>

1067: --
1068: if ((p_rec.absence_attendance_type_id is not null) and (
1069: nvl(per_abb_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
1070: nvl(p_rec.information_category, hr_api.g_varchar2) or
1071: nvl(per_abb_shd.g_old_rec.information1, hr_api.g_varchar2) <>
1072: nvl(p_rec.information1, hr_api.g_varchar2) or
1073: nvl(per_abb_shd.g_old_rec.information2, hr_api.g_varchar2) <>
1074: nvl(p_rec.information2, hr_api.g_varchar2) or
1075: nvl(per_abb_shd.g_old_rec.information3, hr_api.g_varchar2) <>

Line 1072: nvl(p_rec.information1, hr_api.g_varchar2) or

1068: if ((p_rec.absence_attendance_type_id is not null) and (
1069: nvl(per_abb_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
1070: nvl(p_rec.information_category, hr_api.g_varchar2) or
1071: nvl(per_abb_shd.g_old_rec.information1, hr_api.g_varchar2) <>
1072: nvl(p_rec.information1, hr_api.g_varchar2) or
1073: nvl(per_abb_shd.g_old_rec.information2, hr_api.g_varchar2) <>
1074: nvl(p_rec.information2, hr_api.g_varchar2) or
1075: nvl(per_abb_shd.g_old_rec.information3, hr_api.g_varchar2) <>
1076: nvl(p_rec.information3, hr_api.g_varchar2) or

Line 1073: nvl(per_abb_shd.g_old_rec.information2, hr_api.g_varchar2) <>

1069: nvl(per_abb_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
1070: nvl(p_rec.information_category, hr_api.g_varchar2) or
1071: nvl(per_abb_shd.g_old_rec.information1, hr_api.g_varchar2) <>
1072: nvl(p_rec.information1, hr_api.g_varchar2) or
1073: nvl(per_abb_shd.g_old_rec.information2, hr_api.g_varchar2) <>
1074: nvl(p_rec.information2, hr_api.g_varchar2) or
1075: nvl(per_abb_shd.g_old_rec.information3, hr_api.g_varchar2) <>
1076: nvl(p_rec.information3, hr_api.g_varchar2) or
1077: nvl(per_abb_shd.g_old_rec.information4, hr_api.g_varchar2) <>

Line 1074: nvl(p_rec.information2, hr_api.g_varchar2) or

1070: nvl(p_rec.information_category, hr_api.g_varchar2) or
1071: nvl(per_abb_shd.g_old_rec.information1, hr_api.g_varchar2) <>
1072: nvl(p_rec.information1, hr_api.g_varchar2) or
1073: nvl(per_abb_shd.g_old_rec.information2, hr_api.g_varchar2) <>
1074: nvl(p_rec.information2, hr_api.g_varchar2) or
1075: nvl(per_abb_shd.g_old_rec.information3, hr_api.g_varchar2) <>
1076: nvl(p_rec.information3, hr_api.g_varchar2) or
1077: nvl(per_abb_shd.g_old_rec.information4, hr_api.g_varchar2) <>
1078: nvl(p_rec.information4, hr_api.g_varchar2) or

Line 1075: nvl(per_abb_shd.g_old_rec.information3, hr_api.g_varchar2) <>

1071: nvl(per_abb_shd.g_old_rec.information1, hr_api.g_varchar2) <>
1072: nvl(p_rec.information1, hr_api.g_varchar2) or
1073: nvl(per_abb_shd.g_old_rec.information2, hr_api.g_varchar2) <>
1074: nvl(p_rec.information2, hr_api.g_varchar2) or
1075: nvl(per_abb_shd.g_old_rec.information3, hr_api.g_varchar2) <>
1076: nvl(p_rec.information3, hr_api.g_varchar2) or
1077: nvl(per_abb_shd.g_old_rec.information4, hr_api.g_varchar2) <>
1078: nvl(p_rec.information4, hr_api.g_varchar2) or
1079: nvl(per_abb_shd.g_old_rec.information5, hr_api.g_varchar2) <>

Line 1076: nvl(p_rec.information3, hr_api.g_varchar2) or

1072: nvl(p_rec.information1, hr_api.g_varchar2) or
1073: nvl(per_abb_shd.g_old_rec.information2, hr_api.g_varchar2) <>
1074: nvl(p_rec.information2, hr_api.g_varchar2) or
1075: nvl(per_abb_shd.g_old_rec.information3, hr_api.g_varchar2) <>
1076: nvl(p_rec.information3, hr_api.g_varchar2) or
1077: nvl(per_abb_shd.g_old_rec.information4, hr_api.g_varchar2) <>
1078: nvl(p_rec.information4, hr_api.g_varchar2) or
1079: nvl(per_abb_shd.g_old_rec.information5, hr_api.g_varchar2) <>
1080: nvl(p_rec.information5, hr_api.g_varchar2) or

Line 1077: nvl(per_abb_shd.g_old_rec.information4, hr_api.g_varchar2) <>

1073: nvl(per_abb_shd.g_old_rec.information2, hr_api.g_varchar2) <>
1074: nvl(p_rec.information2, hr_api.g_varchar2) or
1075: nvl(per_abb_shd.g_old_rec.information3, hr_api.g_varchar2) <>
1076: nvl(p_rec.information3, hr_api.g_varchar2) or
1077: nvl(per_abb_shd.g_old_rec.information4, hr_api.g_varchar2) <>
1078: nvl(p_rec.information4, hr_api.g_varchar2) or
1079: nvl(per_abb_shd.g_old_rec.information5, hr_api.g_varchar2) <>
1080: nvl(p_rec.information5, hr_api.g_varchar2) or
1081: nvl(per_abb_shd.g_old_rec.information6, hr_api.g_varchar2) <>

Line 1078: nvl(p_rec.information4, hr_api.g_varchar2) or

1074: nvl(p_rec.information2, hr_api.g_varchar2) or
1075: nvl(per_abb_shd.g_old_rec.information3, hr_api.g_varchar2) <>
1076: nvl(p_rec.information3, hr_api.g_varchar2) or
1077: nvl(per_abb_shd.g_old_rec.information4, hr_api.g_varchar2) <>
1078: nvl(p_rec.information4, hr_api.g_varchar2) or
1079: nvl(per_abb_shd.g_old_rec.information5, hr_api.g_varchar2) <>
1080: nvl(p_rec.information5, hr_api.g_varchar2) or
1081: nvl(per_abb_shd.g_old_rec.information6, hr_api.g_varchar2) <>
1082: nvl(p_rec.information6, hr_api.g_varchar2) or

Line 1079: nvl(per_abb_shd.g_old_rec.information5, hr_api.g_varchar2) <>

1075: nvl(per_abb_shd.g_old_rec.information3, hr_api.g_varchar2) <>
1076: nvl(p_rec.information3, hr_api.g_varchar2) or
1077: nvl(per_abb_shd.g_old_rec.information4, hr_api.g_varchar2) <>
1078: nvl(p_rec.information4, hr_api.g_varchar2) or
1079: nvl(per_abb_shd.g_old_rec.information5, hr_api.g_varchar2) <>
1080: nvl(p_rec.information5, hr_api.g_varchar2) or
1081: nvl(per_abb_shd.g_old_rec.information6, hr_api.g_varchar2) <>
1082: nvl(p_rec.information6, hr_api.g_varchar2) or
1083: nvl(per_abb_shd.g_old_rec.information7, hr_api.g_varchar2) <>

Line 1080: nvl(p_rec.information5, hr_api.g_varchar2) or

1076: nvl(p_rec.information3, hr_api.g_varchar2) or
1077: nvl(per_abb_shd.g_old_rec.information4, hr_api.g_varchar2) <>
1078: nvl(p_rec.information4, hr_api.g_varchar2) or
1079: nvl(per_abb_shd.g_old_rec.information5, hr_api.g_varchar2) <>
1080: nvl(p_rec.information5, hr_api.g_varchar2) or
1081: nvl(per_abb_shd.g_old_rec.information6, hr_api.g_varchar2) <>
1082: nvl(p_rec.information6, hr_api.g_varchar2) or
1083: nvl(per_abb_shd.g_old_rec.information7, hr_api.g_varchar2) <>
1084: nvl(p_rec.information7, hr_api.g_varchar2) or

Line 1081: nvl(per_abb_shd.g_old_rec.information6, hr_api.g_varchar2) <>

1077: nvl(per_abb_shd.g_old_rec.information4, hr_api.g_varchar2) <>
1078: nvl(p_rec.information4, hr_api.g_varchar2) or
1079: nvl(per_abb_shd.g_old_rec.information5, hr_api.g_varchar2) <>
1080: nvl(p_rec.information5, hr_api.g_varchar2) or
1081: nvl(per_abb_shd.g_old_rec.information6, hr_api.g_varchar2) <>
1082: nvl(p_rec.information6, hr_api.g_varchar2) or
1083: nvl(per_abb_shd.g_old_rec.information7, hr_api.g_varchar2) <>
1084: nvl(p_rec.information7, hr_api.g_varchar2) or
1085: nvl(per_abb_shd.g_old_rec.information8, hr_api.g_varchar2) <>

Line 1082: nvl(p_rec.information6, hr_api.g_varchar2) or

1078: nvl(p_rec.information4, hr_api.g_varchar2) or
1079: nvl(per_abb_shd.g_old_rec.information5, hr_api.g_varchar2) <>
1080: nvl(p_rec.information5, hr_api.g_varchar2) or
1081: nvl(per_abb_shd.g_old_rec.information6, hr_api.g_varchar2) <>
1082: nvl(p_rec.information6, hr_api.g_varchar2) or
1083: nvl(per_abb_shd.g_old_rec.information7, hr_api.g_varchar2) <>
1084: nvl(p_rec.information7, hr_api.g_varchar2) or
1085: nvl(per_abb_shd.g_old_rec.information8, hr_api.g_varchar2) <>
1086: nvl(p_rec.information8, hr_api.g_varchar2) or

Line 1083: nvl(per_abb_shd.g_old_rec.information7, hr_api.g_varchar2) <>

1079: nvl(per_abb_shd.g_old_rec.information5, hr_api.g_varchar2) <>
1080: nvl(p_rec.information5, hr_api.g_varchar2) or
1081: nvl(per_abb_shd.g_old_rec.information6, hr_api.g_varchar2) <>
1082: nvl(p_rec.information6, hr_api.g_varchar2) or
1083: nvl(per_abb_shd.g_old_rec.information7, hr_api.g_varchar2) <>
1084: nvl(p_rec.information7, hr_api.g_varchar2) or
1085: nvl(per_abb_shd.g_old_rec.information8, hr_api.g_varchar2) <>
1086: nvl(p_rec.information8, hr_api.g_varchar2) or
1087: nvl(per_abb_shd.g_old_rec.information9, hr_api.g_varchar2) <>

Line 1084: nvl(p_rec.information7, hr_api.g_varchar2) or

1080: nvl(p_rec.information5, hr_api.g_varchar2) or
1081: nvl(per_abb_shd.g_old_rec.information6, hr_api.g_varchar2) <>
1082: nvl(p_rec.information6, hr_api.g_varchar2) or
1083: nvl(per_abb_shd.g_old_rec.information7, hr_api.g_varchar2) <>
1084: nvl(p_rec.information7, hr_api.g_varchar2) or
1085: nvl(per_abb_shd.g_old_rec.information8, hr_api.g_varchar2) <>
1086: nvl(p_rec.information8, hr_api.g_varchar2) or
1087: nvl(per_abb_shd.g_old_rec.information9, hr_api.g_varchar2) <>
1088: nvl(p_rec.information9, hr_api.g_varchar2) or

Line 1085: nvl(per_abb_shd.g_old_rec.information8, hr_api.g_varchar2) <>

1081: nvl(per_abb_shd.g_old_rec.information6, hr_api.g_varchar2) <>
1082: nvl(p_rec.information6, hr_api.g_varchar2) or
1083: nvl(per_abb_shd.g_old_rec.information7, hr_api.g_varchar2) <>
1084: nvl(p_rec.information7, hr_api.g_varchar2) or
1085: nvl(per_abb_shd.g_old_rec.information8, hr_api.g_varchar2) <>
1086: nvl(p_rec.information8, hr_api.g_varchar2) or
1087: nvl(per_abb_shd.g_old_rec.information9, hr_api.g_varchar2) <>
1088: nvl(p_rec.information9, hr_api.g_varchar2) or
1089: nvl(per_abb_shd.g_old_rec.information10, hr_api.g_varchar2) <>

Line 1086: nvl(p_rec.information8, hr_api.g_varchar2) or

1082: nvl(p_rec.information6, hr_api.g_varchar2) or
1083: nvl(per_abb_shd.g_old_rec.information7, hr_api.g_varchar2) <>
1084: nvl(p_rec.information7, hr_api.g_varchar2) or
1085: nvl(per_abb_shd.g_old_rec.information8, hr_api.g_varchar2) <>
1086: nvl(p_rec.information8, hr_api.g_varchar2) or
1087: nvl(per_abb_shd.g_old_rec.information9, hr_api.g_varchar2) <>
1088: nvl(p_rec.information9, hr_api.g_varchar2) or
1089: nvl(per_abb_shd.g_old_rec.information10, hr_api.g_varchar2) <>
1090: nvl(p_rec.information10, hr_api.g_varchar2) or

Line 1087: nvl(per_abb_shd.g_old_rec.information9, hr_api.g_varchar2) <>

1083: nvl(per_abb_shd.g_old_rec.information7, hr_api.g_varchar2) <>
1084: nvl(p_rec.information7, hr_api.g_varchar2) or
1085: nvl(per_abb_shd.g_old_rec.information8, hr_api.g_varchar2) <>
1086: nvl(p_rec.information8, hr_api.g_varchar2) or
1087: nvl(per_abb_shd.g_old_rec.information9, hr_api.g_varchar2) <>
1088: nvl(p_rec.information9, hr_api.g_varchar2) or
1089: nvl(per_abb_shd.g_old_rec.information10, hr_api.g_varchar2) <>
1090: nvl(p_rec.information10, hr_api.g_varchar2) or
1091: nvl(per_abb_shd.g_old_rec.information11, hr_api.g_varchar2) <>

Line 1088: nvl(p_rec.information9, hr_api.g_varchar2) or

1084: nvl(p_rec.information7, hr_api.g_varchar2) or
1085: nvl(per_abb_shd.g_old_rec.information8, hr_api.g_varchar2) <>
1086: nvl(p_rec.information8, hr_api.g_varchar2) or
1087: nvl(per_abb_shd.g_old_rec.information9, hr_api.g_varchar2) <>
1088: nvl(p_rec.information9, hr_api.g_varchar2) or
1089: nvl(per_abb_shd.g_old_rec.information10, hr_api.g_varchar2) <>
1090: nvl(p_rec.information10, hr_api.g_varchar2) or
1091: nvl(per_abb_shd.g_old_rec.information11, hr_api.g_varchar2) <>
1092: nvl(p_rec.information11, hr_api.g_varchar2) or

Line 1089: nvl(per_abb_shd.g_old_rec.information10, hr_api.g_varchar2) <>

1085: nvl(per_abb_shd.g_old_rec.information8, hr_api.g_varchar2) <>
1086: nvl(p_rec.information8, hr_api.g_varchar2) or
1087: nvl(per_abb_shd.g_old_rec.information9, hr_api.g_varchar2) <>
1088: nvl(p_rec.information9, hr_api.g_varchar2) or
1089: nvl(per_abb_shd.g_old_rec.information10, hr_api.g_varchar2) <>
1090: nvl(p_rec.information10, hr_api.g_varchar2) or
1091: nvl(per_abb_shd.g_old_rec.information11, hr_api.g_varchar2) <>
1092: nvl(p_rec.information11, hr_api.g_varchar2) or
1093: nvl(per_abb_shd.g_old_rec.information12, hr_api.g_varchar2) <>

Line 1090: nvl(p_rec.information10, hr_api.g_varchar2) or

1086: nvl(p_rec.information8, hr_api.g_varchar2) or
1087: nvl(per_abb_shd.g_old_rec.information9, hr_api.g_varchar2) <>
1088: nvl(p_rec.information9, hr_api.g_varchar2) or
1089: nvl(per_abb_shd.g_old_rec.information10, hr_api.g_varchar2) <>
1090: nvl(p_rec.information10, hr_api.g_varchar2) or
1091: nvl(per_abb_shd.g_old_rec.information11, hr_api.g_varchar2) <>
1092: nvl(p_rec.information11, hr_api.g_varchar2) or
1093: nvl(per_abb_shd.g_old_rec.information12, hr_api.g_varchar2) <>
1094: nvl(p_rec.information12, hr_api.g_varchar2) or

Line 1091: nvl(per_abb_shd.g_old_rec.information11, hr_api.g_varchar2) <>

1087: nvl(per_abb_shd.g_old_rec.information9, hr_api.g_varchar2) <>
1088: nvl(p_rec.information9, hr_api.g_varchar2) or
1089: nvl(per_abb_shd.g_old_rec.information10, hr_api.g_varchar2) <>
1090: nvl(p_rec.information10, hr_api.g_varchar2) or
1091: nvl(per_abb_shd.g_old_rec.information11, hr_api.g_varchar2) <>
1092: nvl(p_rec.information11, hr_api.g_varchar2) or
1093: nvl(per_abb_shd.g_old_rec.information12, hr_api.g_varchar2) <>
1094: nvl(p_rec.information12, hr_api.g_varchar2) or
1095: nvl(per_abb_shd.g_old_rec.information13, hr_api.g_varchar2) <>

Line 1092: nvl(p_rec.information11, hr_api.g_varchar2) or

1088: nvl(p_rec.information9, hr_api.g_varchar2) or
1089: nvl(per_abb_shd.g_old_rec.information10, hr_api.g_varchar2) <>
1090: nvl(p_rec.information10, hr_api.g_varchar2) or
1091: nvl(per_abb_shd.g_old_rec.information11, hr_api.g_varchar2) <>
1092: nvl(p_rec.information11, hr_api.g_varchar2) or
1093: nvl(per_abb_shd.g_old_rec.information12, hr_api.g_varchar2) <>
1094: nvl(p_rec.information12, hr_api.g_varchar2) or
1095: nvl(per_abb_shd.g_old_rec.information13, hr_api.g_varchar2) <>
1096: nvl(p_rec.information13, hr_api.g_varchar2) or

Line 1093: nvl(per_abb_shd.g_old_rec.information12, hr_api.g_varchar2) <>

1089: nvl(per_abb_shd.g_old_rec.information10, hr_api.g_varchar2) <>
1090: nvl(p_rec.information10, hr_api.g_varchar2) or
1091: nvl(per_abb_shd.g_old_rec.information11, hr_api.g_varchar2) <>
1092: nvl(p_rec.information11, hr_api.g_varchar2) or
1093: nvl(per_abb_shd.g_old_rec.information12, hr_api.g_varchar2) <>
1094: nvl(p_rec.information12, hr_api.g_varchar2) or
1095: nvl(per_abb_shd.g_old_rec.information13, hr_api.g_varchar2) <>
1096: nvl(p_rec.information13, hr_api.g_varchar2) or
1097: nvl(per_abb_shd.g_old_rec.information14, hr_api.g_varchar2) <>

Line 1094: nvl(p_rec.information12, hr_api.g_varchar2) or

1090: nvl(p_rec.information10, hr_api.g_varchar2) or
1091: nvl(per_abb_shd.g_old_rec.information11, hr_api.g_varchar2) <>
1092: nvl(p_rec.information11, hr_api.g_varchar2) or
1093: nvl(per_abb_shd.g_old_rec.information12, hr_api.g_varchar2) <>
1094: nvl(p_rec.information12, hr_api.g_varchar2) or
1095: nvl(per_abb_shd.g_old_rec.information13, hr_api.g_varchar2) <>
1096: nvl(p_rec.information13, hr_api.g_varchar2) or
1097: nvl(per_abb_shd.g_old_rec.information14, hr_api.g_varchar2) <>
1098: nvl(p_rec.information14, hr_api.g_varchar2) or

Line 1095: nvl(per_abb_shd.g_old_rec.information13, hr_api.g_varchar2) <>

1091: nvl(per_abb_shd.g_old_rec.information11, hr_api.g_varchar2) <>
1092: nvl(p_rec.information11, hr_api.g_varchar2) or
1093: nvl(per_abb_shd.g_old_rec.information12, hr_api.g_varchar2) <>
1094: nvl(p_rec.information12, hr_api.g_varchar2) or
1095: nvl(per_abb_shd.g_old_rec.information13, hr_api.g_varchar2) <>
1096: nvl(p_rec.information13, hr_api.g_varchar2) or
1097: nvl(per_abb_shd.g_old_rec.information14, hr_api.g_varchar2) <>
1098: nvl(p_rec.information14, hr_api.g_varchar2) or
1099: nvl(per_abb_shd.g_old_rec.information15, hr_api.g_varchar2) <>

Line 1096: nvl(p_rec.information13, hr_api.g_varchar2) or

1092: nvl(p_rec.information11, hr_api.g_varchar2) or
1093: nvl(per_abb_shd.g_old_rec.information12, hr_api.g_varchar2) <>
1094: nvl(p_rec.information12, hr_api.g_varchar2) or
1095: nvl(per_abb_shd.g_old_rec.information13, hr_api.g_varchar2) <>
1096: nvl(p_rec.information13, hr_api.g_varchar2) or
1097: nvl(per_abb_shd.g_old_rec.information14, hr_api.g_varchar2) <>
1098: nvl(p_rec.information14, hr_api.g_varchar2) or
1099: nvl(per_abb_shd.g_old_rec.information15, hr_api.g_varchar2) <>
1100: nvl(p_rec.information15, hr_api.g_varchar2) or

Line 1097: nvl(per_abb_shd.g_old_rec.information14, hr_api.g_varchar2) <>

1093: nvl(per_abb_shd.g_old_rec.information12, hr_api.g_varchar2) <>
1094: nvl(p_rec.information12, hr_api.g_varchar2) or
1095: nvl(per_abb_shd.g_old_rec.information13, hr_api.g_varchar2) <>
1096: nvl(p_rec.information13, hr_api.g_varchar2) or
1097: nvl(per_abb_shd.g_old_rec.information14, hr_api.g_varchar2) <>
1098: nvl(p_rec.information14, hr_api.g_varchar2) or
1099: nvl(per_abb_shd.g_old_rec.information15, hr_api.g_varchar2) <>
1100: nvl(p_rec.information15, hr_api.g_varchar2) or
1101: nvl(per_abb_shd.g_old_rec.information16, hr_api.g_varchar2) <>

Line 1098: nvl(p_rec.information14, hr_api.g_varchar2) or

1094: nvl(p_rec.information12, hr_api.g_varchar2) or
1095: nvl(per_abb_shd.g_old_rec.information13, hr_api.g_varchar2) <>
1096: nvl(p_rec.information13, hr_api.g_varchar2) or
1097: nvl(per_abb_shd.g_old_rec.information14, hr_api.g_varchar2) <>
1098: nvl(p_rec.information14, hr_api.g_varchar2) or
1099: nvl(per_abb_shd.g_old_rec.information15, hr_api.g_varchar2) <>
1100: nvl(p_rec.information15, hr_api.g_varchar2) or
1101: nvl(per_abb_shd.g_old_rec.information16, hr_api.g_varchar2) <>
1102: nvl(p_rec.information16, hr_api.g_varchar2) or

Line 1099: nvl(per_abb_shd.g_old_rec.information15, hr_api.g_varchar2) <>

1095: nvl(per_abb_shd.g_old_rec.information13, hr_api.g_varchar2) <>
1096: nvl(p_rec.information13, hr_api.g_varchar2) or
1097: nvl(per_abb_shd.g_old_rec.information14, hr_api.g_varchar2) <>
1098: nvl(p_rec.information14, hr_api.g_varchar2) or
1099: nvl(per_abb_shd.g_old_rec.information15, hr_api.g_varchar2) <>
1100: nvl(p_rec.information15, hr_api.g_varchar2) or
1101: nvl(per_abb_shd.g_old_rec.information16, hr_api.g_varchar2) <>
1102: nvl(p_rec.information16, hr_api.g_varchar2) or
1103: nvl(per_abb_shd.g_old_rec.information17, hr_api.g_varchar2) <>

Line 1100: nvl(p_rec.information15, hr_api.g_varchar2) or

1096: nvl(p_rec.information13, hr_api.g_varchar2) or
1097: nvl(per_abb_shd.g_old_rec.information14, hr_api.g_varchar2) <>
1098: nvl(p_rec.information14, hr_api.g_varchar2) or
1099: nvl(per_abb_shd.g_old_rec.information15, hr_api.g_varchar2) <>
1100: nvl(p_rec.information15, hr_api.g_varchar2) or
1101: nvl(per_abb_shd.g_old_rec.information16, hr_api.g_varchar2) <>
1102: nvl(p_rec.information16, hr_api.g_varchar2) or
1103: nvl(per_abb_shd.g_old_rec.information17, hr_api.g_varchar2) <>
1104: nvl(p_rec.information17, hr_api.g_varchar2) or

Line 1101: nvl(per_abb_shd.g_old_rec.information16, hr_api.g_varchar2) <>

1097: nvl(per_abb_shd.g_old_rec.information14, hr_api.g_varchar2) <>
1098: nvl(p_rec.information14, hr_api.g_varchar2) or
1099: nvl(per_abb_shd.g_old_rec.information15, hr_api.g_varchar2) <>
1100: nvl(p_rec.information15, hr_api.g_varchar2) or
1101: nvl(per_abb_shd.g_old_rec.information16, hr_api.g_varchar2) <>
1102: nvl(p_rec.information16, hr_api.g_varchar2) or
1103: nvl(per_abb_shd.g_old_rec.information17, hr_api.g_varchar2) <>
1104: nvl(p_rec.information17, hr_api.g_varchar2) or
1105: nvl(per_abb_shd.g_old_rec.information18, hr_api.g_varchar2) <>

Line 1102: nvl(p_rec.information16, hr_api.g_varchar2) or

1098: nvl(p_rec.information14, hr_api.g_varchar2) or
1099: nvl(per_abb_shd.g_old_rec.information15, hr_api.g_varchar2) <>
1100: nvl(p_rec.information15, hr_api.g_varchar2) or
1101: nvl(per_abb_shd.g_old_rec.information16, hr_api.g_varchar2) <>
1102: nvl(p_rec.information16, hr_api.g_varchar2) or
1103: nvl(per_abb_shd.g_old_rec.information17, hr_api.g_varchar2) <>
1104: nvl(p_rec.information17, hr_api.g_varchar2) or
1105: nvl(per_abb_shd.g_old_rec.information18, hr_api.g_varchar2) <>
1106: nvl(p_rec.information18, hr_api.g_varchar2) or

Line 1103: nvl(per_abb_shd.g_old_rec.information17, hr_api.g_varchar2) <>

1099: nvl(per_abb_shd.g_old_rec.information15, hr_api.g_varchar2) <>
1100: nvl(p_rec.information15, hr_api.g_varchar2) or
1101: nvl(per_abb_shd.g_old_rec.information16, hr_api.g_varchar2) <>
1102: nvl(p_rec.information16, hr_api.g_varchar2) or
1103: nvl(per_abb_shd.g_old_rec.information17, hr_api.g_varchar2) <>
1104: nvl(p_rec.information17, hr_api.g_varchar2) or
1105: nvl(per_abb_shd.g_old_rec.information18, hr_api.g_varchar2) <>
1106: nvl(p_rec.information18, hr_api.g_varchar2) or
1107: nvl(per_abb_shd.g_old_rec.information19, hr_api.g_varchar2) <>

Line 1104: nvl(p_rec.information17, hr_api.g_varchar2) or

1100: nvl(p_rec.information15, hr_api.g_varchar2) or
1101: nvl(per_abb_shd.g_old_rec.information16, hr_api.g_varchar2) <>
1102: nvl(p_rec.information16, hr_api.g_varchar2) or
1103: nvl(per_abb_shd.g_old_rec.information17, hr_api.g_varchar2) <>
1104: nvl(p_rec.information17, hr_api.g_varchar2) or
1105: nvl(per_abb_shd.g_old_rec.information18, hr_api.g_varchar2) <>
1106: nvl(p_rec.information18, hr_api.g_varchar2) or
1107: nvl(per_abb_shd.g_old_rec.information19, hr_api.g_varchar2) <>
1108: nvl(p_rec.information19, hr_api.g_varchar2) or

Line 1105: nvl(per_abb_shd.g_old_rec.information18, hr_api.g_varchar2) <>

1101: nvl(per_abb_shd.g_old_rec.information16, hr_api.g_varchar2) <>
1102: nvl(p_rec.information16, hr_api.g_varchar2) or
1103: nvl(per_abb_shd.g_old_rec.information17, hr_api.g_varchar2) <>
1104: nvl(p_rec.information17, hr_api.g_varchar2) or
1105: nvl(per_abb_shd.g_old_rec.information18, hr_api.g_varchar2) <>
1106: nvl(p_rec.information18, hr_api.g_varchar2) or
1107: nvl(per_abb_shd.g_old_rec.information19, hr_api.g_varchar2) <>
1108: nvl(p_rec.information19, hr_api.g_varchar2) or
1109: nvl(per_abb_shd.g_old_rec.information20, hr_api.g_varchar2) <>

Line 1106: nvl(p_rec.information18, hr_api.g_varchar2) or

1102: nvl(p_rec.information16, hr_api.g_varchar2) or
1103: nvl(per_abb_shd.g_old_rec.information17, hr_api.g_varchar2) <>
1104: nvl(p_rec.information17, hr_api.g_varchar2) or
1105: nvl(per_abb_shd.g_old_rec.information18, hr_api.g_varchar2) <>
1106: nvl(p_rec.information18, hr_api.g_varchar2) or
1107: nvl(per_abb_shd.g_old_rec.information19, hr_api.g_varchar2) <>
1108: nvl(p_rec.information19, hr_api.g_varchar2) or
1109: nvl(per_abb_shd.g_old_rec.information20, hr_api.g_varchar2) <>
1110: nvl(p_rec.information20, hr_api.g_varchar2) ))

Line 1107: nvl(per_abb_shd.g_old_rec.information19, hr_api.g_varchar2) <>

1103: nvl(per_abb_shd.g_old_rec.information17, hr_api.g_varchar2) <>
1104: nvl(p_rec.information17, hr_api.g_varchar2) or
1105: nvl(per_abb_shd.g_old_rec.information18, hr_api.g_varchar2) <>
1106: nvl(p_rec.information18, hr_api.g_varchar2) or
1107: nvl(per_abb_shd.g_old_rec.information19, hr_api.g_varchar2) <>
1108: nvl(p_rec.information19, hr_api.g_varchar2) or
1109: nvl(per_abb_shd.g_old_rec.information20, hr_api.g_varchar2) <>
1110: nvl(p_rec.information20, hr_api.g_varchar2) ))
1111: or (p_rec.absence_attendance_type_id is null) then

Line 1108: nvl(p_rec.information19, hr_api.g_varchar2) or

1104: nvl(p_rec.information17, hr_api.g_varchar2) or
1105: nvl(per_abb_shd.g_old_rec.information18, hr_api.g_varchar2) <>
1106: nvl(p_rec.information18, hr_api.g_varchar2) or
1107: nvl(per_abb_shd.g_old_rec.information19, hr_api.g_varchar2) <>
1108: nvl(p_rec.information19, hr_api.g_varchar2) or
1109: nvl(per_abb_shd.g_old_rec.information20, hr_api.g_varchar2) <>
1110: nvl(p_rec.information20, hr_api.g_varchar2) ))
1111: or (p_rec.absence_attendance_type_id is null) then
1112: --

Line 1109: nvl(per_abb_shd.g_old_rec.information20, hr_api.g_varchar2) <>

1105: nvl(per_abb_shd.g_old_rec.information18, hr_api.g_varchar2) <>
1106: nvl(p_rec.information18, hr_api.g_varchar2) or
1107: nvl(per_abb_shd.g_old_rec.information19, hr_api.g_varchar2) <>
1108: nvl(p_rec.information19, hr_api.g_varchar2) or
1109: nvl(per_abb_shd.g_old_rec.information20, hr_api.g_varchar2) <>
1110: nvl(p_rec.information20, hr_api.g_varchar2) ))
1111: or (p_rec.absence_attendance_type_id is null) then
1112: --
1113: -- Only execute the validation if absolutely necessary:

Line 1110: nvl(p_rec.information20, hr_api.g_varchar2) ))

1106: nvl(p_rec.information18, hr_api.g_varchar2) or
1107: nvl(per_abb_shd.g_old_rec.information19, hr_api.g_varchar2) <>
1108: nvl(p_rec.information19, hr_api.g_varchar2) or
1109: nvl(per_abb_shd.g_old_rec.information20, hr_api.g_varchar2) <>
1110: nvl(p_rec.information20, hr_api.g_varchar2) ))
1111: or (p_rec.absence_attendance_type_id is null) then
1112: --
1113: -- Only execute the validation if absolutely necessary:
1114: -- a) During update, the structure column value or any

Line 1206: nvl(per_abb_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

1202: begin
1203: hr_utility.set_location('Entering:'||l_proc,10);
1204: --
1205: if ((p_rec.absence_attendance_type_id is not null) and (
1206: nvl(per_abb_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1207: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1208: nvl(per_abb_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1209: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1210: nvl(per_abb_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

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

1203: hr_utility.set_location('Entering:'||l_proc,10);
1204: --
1205: if ((p_rec.absence_attendance_type_id is not null) and (
1206: nvl(per_abb_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1207: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1208: nvl(per_abb_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1209: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1210: nvl(per_abb_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1211: nvl(p_rec.attribute2, hr_api.g_varchar2) or

Line 1208: nvl(per_abb_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

1204: --
1205: if ((p_rec.absence_attendance_type_id is not null) and (
1206: nvl(per_abb_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1207: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1208: nvl(per_abb_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1209: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1210: nvl(per_abb_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1211: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1212: nvl(per_abb_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

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

1205: if ((p_rec.absence_attendance_type_id is not null) and (
1206: nvl(per_abb_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1207: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1208: nvl(per_abb_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1209: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1210: nvl(per_abb_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1211: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1212: nvl(per_abb_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1213: nvl(p_rec.attribute3, hr_api.g_varchar2) or

Line 1210: nvl(per_abb_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

1206: nvl(per_abb_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1207: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1208: nvl(per_abb_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1209: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1210: nvl(per_abb_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1211: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1212: nvl(per_abb_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1213: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1214: nvl(per_abb_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

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

1207: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1208: nvl(per_abb_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1209: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1210: nvl(per_abb_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1211: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1212: nvl(per_abb_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1213: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1214: nvl(per_abb_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1215: nvl(p_rec.attribute4, hr_api.g_varchar2) or

Line 1212: nvl(per_abb_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

1208: nvl(per_abb_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1209: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1210: nvl(per_abb_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1211: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1212: nvl(per_abb_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1213: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1214: nvl(per_abb_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1215: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1216: nvl(per_abb_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

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

1209: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1210: nvl(per_abb_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1211: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1212: nvl(per_abb_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1213: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1214: nvl(per_abb_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1215: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1216: nvl(per_abb_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1217: nvl(p_rec.attribute5, hr_api.g_varchar2) or

Line 1214: nvl(per_abb_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

1210: nvl(per_abb_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1211: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1212: nvl(per_abb_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1213: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1214: nvl(per_abb_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1215: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1216: nvl(per_abb_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1217: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1218: nvl(per_abb_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

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

1211: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1212: nvl(per_abb_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1213: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1214: nvl(per_abb_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1215: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1216: nvl(per_abb_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1217: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1218: nvl(per_abb_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1219: nvl(p_rec.attribute6, hr_api.g_varchar2) or

Line 1216: nvl(per_abb_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

1212: nvl(per_abb_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1213: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1214: nvl(per_abb_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1215: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1216: nvl(per_abb_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1217: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1218: nvl(per_abb_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1219: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1220: nvl(per_abb_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

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

1213: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1214: nvl(per_abb_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1215: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1216: nvl(per_abb_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1217: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1218: nvl(per_abb_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1219: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1220: nvl(per_abb_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1221: nvl(p_rec.attribute7, hr_api.g_varchar2) or

Line 1218: nvl(per_abb_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

1214: nvl(per_abb_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1215: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1216: nvl(per_abb_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1217: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1218: nvl(per_abb_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1219: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1220: nvl(per_abb_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1221: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1222: nvl(per_abb_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

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

1215: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1216: nvl(per_abb_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1217: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1218: nvl(per_abb_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1219: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1220: nvl(per_abb_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1221: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1222: nvl(per_abb_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1223: nvl(p_rec.attribute8, hr_api.g_varchar2) or

Line 1220: nvl(per_abb_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

1216: nvl(per_abb_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1217: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1218: nvl(per_abb_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1219: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1220: nvl(per_abb_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1221: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1222: nvl(per_abb_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1223: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1224: nvl(per_abb_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

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

1217: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1218: nvl(per_abb_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1219: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1220: nvl(per_abb_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1221: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1222: nvl(per_abb_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1223: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1224: nvl(per_abb_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1225: nvl(p_rec.attribute9, hr_api.g_varchar2) or

Line 1222: nvl(per_abb_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

1218: nvl(per_abb_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1219: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1220: nvl(per_abb_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1221: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1222: nvl(per_abb_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1223: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1224: nvl(per_abb_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1225: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1226: nvl(per_abb_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

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

1219: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1220: nvl(per_abb_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1221: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1222: nvl(per_abb_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1223: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1224: nvl(per_abb_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1225: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1226: nvl(per_abb_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1227: nvl(p_rec.attribute10, hr_api.g_varchar2) or

Line 1224: nvl(per_abb_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

1220: nvl(per_abb_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1221: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1222: nvl(per_abb_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1223: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1224: nvl(per_abb_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1225: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1226: nvl(per_abb_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1227: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1228: nvl(per_abb_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

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

1221: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1222: nvl(per_abb_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1223: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1224: nvl(per_abb_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1225: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1226: nvl(per_abb_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1227: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1228: nvl(per_abb_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1229: nvl(p_rec.attribute11, hr_api.g_varchar2) or

Line 1226: nvl(per_abb_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

1222: nvl(per_abb_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1223: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1224: nvl(per_abb_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1225: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1226: nvl(per_abb_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1227: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1228: nvl(per_abb_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1229: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1230: nvl(per_abb_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

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

1223: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1224: nvl(per_abb_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1225: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1226: nvl(per_abb_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1227: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1228: nvl(per_abb_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1229: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1230: nvl(per_abb_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1231: nvl(p_rec.attribute12, hr_api.g_varchar2) or

Line 1228: nvl(per_abb_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

1224: nvl(per_abb_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1225: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1226: nvl(per_abb_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1227: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1228: nvl(per_abb_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1229: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1230: nvl(per_abb_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1231: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1232: nvl(per_abb_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

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

1225: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1226: nvl(per_abb_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1227: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1228: nvl(per_abb_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1229: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1230: nvl(per_abb_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1231: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1232: nvl(per_abb_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1233: nvl(p_rec.attribute13, hr_api.g_varchar2) or

Line 1230: nvl(per_abb_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

1226: nvl(per_abb_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1227: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1228: nvl(per_abb_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1229: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1230: nvl(per_abb_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1231: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1232: nvl(per_abb_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1233: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1234: nvl(per_abb_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

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

1227: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1228: nvl(per_abb_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1229: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1230: nvl(per_abb_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1231: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1232: nvl(per_abb_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1233: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1234: nvl(per_abb_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1235: nvl(p_rec.attribute14, hr_api.g_varchar2) or

Line 1232: nvl(per_abb_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

1228: nvl(per_abb_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1229: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1230: nvl(per_abb_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1231: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1232: nvl(per_abb_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1233: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1234: nvl(per_abb_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1235: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1236: nvl(per_abb_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

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

1229: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1230: nvl(per_abb_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1231: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1232: nvl(per_abb_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1233: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1234: nvl(per_abb_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1235: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1236: nvl(per_abb_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1237: nvl(p_rec.attribute15, hr_api.g_varchar2) or

Line 1234: nvl(per_abb_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

1230: nvl(per_abb_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1231: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1232: nvl(per_abb_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1233: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1234: nvl(per_abb_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1235: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1236: nvl(per_abb_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1237: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1238: nvl(per_abb_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

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

1231: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1232: nvl(per_abb_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1233: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1234: nvl(per_abb_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1235: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1236: nvl(per_abb_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1237: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1238: nvl(per_abb_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1239: nvl(p_rec.attribute16, hr_api.g_varchar2) or

Line 1236: nvl(per_abb_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

1232: nvl(per_abb_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1233: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1234: nvl(per_abb_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1235: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1236: nvl(per_abb_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1237: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1238: nvl(per_abb_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1239: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1240: nvl(per_abb_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

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

1233: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1234: nvl(per_abb_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1235: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1236: nvl(per_abb_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1237: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1238: nvl(per_abb_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1239: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1240: nvl(per_abb_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1241: nvl(p_rec.attribute17, hr_api.g_varchar2) or

Line 1238: nvl(per_abb_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

1234: nvl(per_abb_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1235: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1236: nvl(per_abb_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1237: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1238: nvl(per_abb_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1239: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1240: nvl(per_abb_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1241: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1242: nvl(per_abb_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

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

1235: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1236: nvl(per_abb_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1237: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1238: nvl(per_abb_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1239: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1240: nvl(per_abb_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1241: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1242: nvl(per_abb_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1243: nvl(p_rec.attribute18, hr_api.g_varchar2) or

Line 1240: nvl(per_abb_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

1236: nvl(per_abb_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1237: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1238: nvl(per_abb_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1239: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1240: nvl(per_abb_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1241: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1242: nvl(per_abb_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1243: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1244: nvl(per_abb_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

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

1237: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1238: nvl(per_abb_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1239: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1240: nvl(per_abb_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1241: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1242: nvl(per_abb_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1243: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1244: nvl(per_abb_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1245: nvl(p_rec.attribute19, hr_api.g_varchar2) or

Line 1242: nvl(per_abb_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

1238: nvl(per_abb_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1239: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1240: nvl(per_abb_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1241: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1242: nvl(per_abb_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1243: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1244: nvl(per_abb_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1245: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1246: nvl(per_abb_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

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

1239: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1240: nvl(per_abb_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1241: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1242: nvl(per_abb_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1243: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1244: nvl(per_abb_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1245: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1246: nvl(per_abb_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1247: nvl(p_rec.attribute20, hr_api.g_varchar2) ))

Line 1244: nvl(per_abb_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

1240: nvl(per_abb_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1241: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1242: nvl(per_abb_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1243: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1244: nvl(per_abb_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1245: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1246: nvl(per_abb_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1247: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
1248: or (p_rec.absence_attendance_type_id is null) then

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

1241: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1242: nvl(per_abb_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1243: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1244: nvl(per_abb_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1245: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1246: nvl(per_abb_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1247: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
1248: or (p_rec.absence_attendance_type_id is null) then
1249: --

Line 1246: nvl(per_abb_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

1242: nvl(per_abb_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1243: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1244: nvl(per_abb_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1245: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1246: nvl(per_abb_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1247: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
1248: or (p_rec.absence_attendance_type_id is null) then
1249: --
1250: -- Only execute the validation if absolutely necessary:

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

1243: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1244: nvl(per_abb_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1245: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1246: nvl(per_abb_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1247: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
1248: or (p_rec.absence_attendance_type_id is null) then
1249: --
1250: -- Only execute the validation if absolutely necessary:
1251: -- a) During update, the structure column value or any

Line 1366: if nvl(per_abb_shd.g_old_rec.information_category,hr_api.g_varchar2) <>

1362: end if;
1363: --
1364: hr_utility.set_location(l_proc, 20);
1365: --
1366: if nvl(per_abb_shd.g_old_rec.information_category,hr_api.g_varchar2) <>
1367: nvl(p_rec.information_category,hr_api.g_varchar2) then
1368: l_argument := 'information_category';
1369: raise l_error;
1370: end if;

Line 1367: nvl(p_rec.information_category,hr_api.g_varchar2) then

1363: --
1364: hr_utility.set_location(l_proc, 20);
1365: --
1366: if nvl(per_abb_shd.g_old_rec.information_category,hr_api.g_varchar2) <>
1367: nvl(p_rec.information_category,hr_api.g_varchar2) then
1368: l_argument := 'information_category';
1369: raise l_error;
1370: end if;
1371: --

Line 1385: hr_api.argument_changed_error

1381: hr_utility.set_location(' Leaving:'||l_proc, 40);
1382: --
1383: exception
1384: when l_error then
1385: hr_api.argument_changed_error
1386: (p_api_name => l_proc
1387: ,p_argument => l_argument);
1388: when others then
1389: raise;

Line 1408: hr_api.validate_bus_grp_id

1404: --
1405: -- Call all supporting business operations
1406: --
1407: if p_rec.business_group_id is not null then
1408: hr_api.validate_bus_grp_id
1409: (p_business_group_id => p_rec.business_group_id
1410: );
1411: end if;
1412: --

Line 1492: hr_api.validate_bus_grp_id

1488: --
1489: -- Call all supporting business operations
1490: --
1491: if p_rec.business_group_id is not null then
1492: hr_api.validate_bus_grp_id
1493: (p_business_group_id => p_rec.business_group_id
1494: );
1495: end if;
1496: --