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 PER_ABB_SHD

Line 151: l_api_updating := per_abb_shd.api_updating

147: ,p_argument => 'date_effective'
148: ,p_argument_value => p_date_effective
149: );
150: --
151: l_api_updating := per_abb_shd.api_updating
152: (p_absence_attendance_type_id => p_absence_attendance_type_id
153: ,p_object_version_number => p_object_version_number);
154: --
155: -- Only proceed with validation if:

Line 159: if ( (l_api_updating and (p_date_effective <> per_abb_shd.g_old_rec.date_effective

155: -- Only proceed with validation if:
156: -- a) rec is being inserted or
157: -- b) rec is updating and the g_old_rec is not current value
158: --
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

Line 160: or p_date_end <> per_abb_shd.g_old_rec.date_end))

156: -- a) rec is being inserted or
157: -- b) rec is updating and the g_old_rec is not current value
158: --
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');

Line 294: l_api_updating := per_abb_shd.api_updating

290: (p_check_column1 => 'PER_ABSENCE_ATTENDANCE_TYPES.DATE_EFFECTIVE'
291: ,p_check_column2 => 'PER_ABSENCE_ATTENDANCE_TYPES.DATE_END'
292: ) then
293: --
294: l_api_updating := per_abb_shd.api_updating
295: (p_absence_attendance_type_id => p_absence_attendance_type_id
296: ,p_object_version_number => p_object_version_number);
297: --
298: --

Line 304: ( nvl(per_abb_shd.g_old_rec.input_value_id,-1) <> nvl(p_input_value_id,-1)

300: -- a) rec is being inserted or
301: -- b) rec is updating and the g_old_rec is not current value
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)

Line 305: or per_abb_shd.g_old_rec.date_effective <> p_date_effective

301: -- b) rec is updating and the g_old_rec is not current value
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

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 326: and p_input_value_id <> nvl(per_abb_shd.g_old_rec.input_value_id,p_input_value_id))

322: --
323: -- input value cannot change once it is not null
324: --
325: if (p_input_value_id is not null
326: and p_input_value_id <> nvl(per_abb_shd.g_old_rec.input_value_id,p_input_value_id))
327: or (p_input_value_id is null and per_abb_shd.g_old_rec.input_value_id is not null)
328: then
329: fnd_message.set_name('PER','PER_449174_ABB_NO_CHANGE_INPUT');
330: fnd_message.raise_error;

Line 327: or (p_input_value_id is null and per_abb_shd.g_old_rec.input_value_id is not null)

323: -- input value cannot change once it is not null
324: --
325: if (p_input_value_id is not null
326: and p_input_value_id <> nvl(per_abb_shd.g_old_rec.input_value_id,p_input_value_id))
327: or (p_input_value_id is null and per_abb_shd.g_old_rec.input_value_id is not null)
328: then
329: fnd_message.set_name('PER','PER_449174_ABB_NO_CHANGE_INPUT');
330: fnd_message.raise_error;
331: end if;

Line 540: l_api_updating := per_abb_shd.api_updating

536: begin
537: --
538: hr_utility.set_location('Entering:'||l_proc,10);
539: --
540: l_api_updating := per_abb_shd.api_updating
541: (p_absence_attendance_type_id => p_absence_attendance_type_id
542: ,p_object_version_number => p_object_version_number);
543: --
544: --

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 552: or nvl(per_abb_shd.g_old_rec.input_value_id,-1) <> nvl(p_input_value_id,-1))

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: --
556: if p_input_value_id is null then

Line 575: and per_abb_shd.g_old_rec.increasing_or_decreasing_flag is not null

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

Line 577: per_abb_shd.g_old_rec.increasing_or_decreasing_flag then

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: --
581: fnd_message.set_name('PER','PER_449178_ABB_NO_CHANGE_INC');

Line 649: l_api_updating := per_abb_shd.api_updating

645: (p_check_column1 => 'PER_ABSENCE_ATTENDANCE_TYPES.INPUT_VALUE_ID'
646: ) then
647: --
648: --
649: l_api_updating := per_abb_shd.api_updating
650: (p_absence_attendance_type_id => p_absence_attendance_type_id
651: ,p_object_version_number => p_object_version_number);
652: --
653: --

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 661: or nvl(per_abb_shd.g_old_rec.input_value_id,-1) <> nvl(p_input_value_id,-1))

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: --
665: if p_input_value_id is null then

Line 675: and per_abb_shd.g_old_rec.hours_or_days is not null

671: else -- input_value_id is not null
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

Line 677: per_abb_shd.g_old_rec.hours_or_days then

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: --
681: fnd_message.set_name('PER','PER_449179_ABB_NO_CHANGE_HOURS');

Line 762: l_api_updating := per_abb_shd.api_updating

758: begin
759: --
760: hr_utility.set_location('Entering:'||l_proc,10);
761: --
762: l_api_updating := per_abb_shd.api_updating
763: (p_absence_attendance_type_id => p_absence_attendance_type_id
764: ,p_object_version_number => p_object_version_number);
765: --
766: --

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 797: and per_abb_shd.g_old_rec.absence_category is not null

793: open csr_absence_attendance;
794: fetch csr_absence_attendance into l_dummy;
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;

Line 798: and per_abb_shd.g_old_rec.absence_category <>

794: fetch csr_absence_attendance into l_dummy;
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');

Line 887: l_api_updating := per_abb_shd.api_updating

883: begin
884: --
885: hr_utility.set_location('Entering:'||l_proc,10);
886: --
887: l_api_updating := per_abb_shd.api_updating
888: (p_absence_attendance_type_id => p_absence_attendance_type_id
889: ,p_object_version_number => p_object_version_number);
890: --
891: --

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 1060: (p_rec in per_abb_shd.g_rec_type

1056: -- Internal Row Handler Use Only.
1057: --
1058: -- ----------------------------------------------------------------------------
1059: procedure chk_ddf
1060: (p_rec in per_abb_shd.g_rec_type
1061: ) is
1062: --
1063: l_proc varchar2(72) := g_package || 'chk_ddf';
1064: --

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 1197: (p_rec in per_abb_shd.g_rec_type

1193: -- Internal Row Handler Use Only.
1194: --
1195: -- ----------------------------------------------------------------------------
1196: procedure chk_df
1197: (p_rec in per_abb_shd.g_rec_type
1198: ) is
1199: --
1200: l_proc varchar2(72) := g_package || 'chk_df';
1201: --

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 1333: (p_rec in per_abb_shd.g_rec_type

1329: --
1330: -- {End Of Comments}
1331: -- ----------------------------------------------------------------------------
1332: Procedure chk_non_updateable_args
1333: (p_rec in per_abb_shd.g_rec_type
1334: ) IS
1335: --
1336: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
1337: l_error exception;

Line 1346: IF NOT per_abb_shd.api_updating

1342: --
1343: -- Only proceed with the validation if a row exists for the current
1344: -- record in the HR Schema.
1345: --
1346: IF NOT per_abb_shd.api_updating
1347: (p_absence_attendance_type_id => p_rec.absence_attendance_type_id
1348: ,p_object_version_number => p_rec.object_version_number
1349: ) THEN
1350: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 1358: if nvl(per_abb_shd.g_old_rec.business_group_id,-1) <>

1354: END IF;
1355: --
1356: hr_utility.set_location(l_proc, 10);
1357: --
1358: if nvl(per_abb_shd.g_old_rec.business_group_id,-1) <>
1359: nvl(p_rec.business_group_id,-1) then
1360: l_argument := 'business_group_id';
1361: raise l_error;
1362: end if;

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 1375: if per_abb_shd.g_old_rec.absence_attendance_type_id <>

1371: --
1372: --
1373: hr_utility.set_location(l_proc, 30);
1374: --
1375: if per_abb_shd.g_old_rec.absence_attendance_type_id <>
1376: p_rec.absence_attendance_type_id then
1377: l_argument := 'absence_attendance_type_id';
1378: raise l_error;
1379: end if;

Line 1397: (p_rec in out nocopy per_abb_shd.g_rec_type

1393: -- ----------------------------------------------------------------------------
1394: -- |---------------------------< insert_validate >----------------------------|
1395: -- ----------------------------------------------------------------------------
1396: Procedure insert_validate
1397: (p_rec in out nocopy per_abb_shd.g_rec_type
1398: ) is
1399: --
1400: l_proc varchar2(72) := g_package||'insert_validate';
1401: --

Line 1481: (p_rec in out nocopy per_abb_shd.g_rec_type

1477: -- ----------------------------------------------------------------------------
1478: -- |---------------------------< update_validate >----------------------------|
1479: -- ----------------------------------------------------------------------------
1480: Procedure update_validate
1481: (p_rec in out nocopy per_abb_shd.g_rec_type
1482: ) is
1483: --
1484: l_proc varchar2(72) := g_package||'update_validate';
1485: --

Line 1565: (p_rec in per_abb_shd.g_rec_type

1561: -- ----------------------------------------------------------------------------
1562: -- |---------------------------< delete_validate >----------------------------|
1563: -- ----------------------------------------------------------------------------
1564: Procedure delete_validate
1565: (p_rec in per_abb_shd.g_rec_type
1566: ) is
1567: --
1568: l_proc varchar2(72) := g_package||'delete_validate';
1569: --