183: -- {End Of Comments}
184: -- ----------------------------------------------------------------------------
185: Procedure chk_non_updateable_args
186: (p_effective_date in date
187: ,p_rec in per_cpo_shd.g_rec_type
188: ) IS
189: --
190: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
191: --
193: --
194: -- Only proceed with the validation if a row exists for the current
195: -- record in the HR Schema.
196: --
197: IF NOT per_cpo_shd.api_updating
198: (p_outcome_id => p_rec.outcome_id
199: ,p_object_version_number => p_rec.object_version_number
200: ) THEN
201: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
245: --
246: Begin
247: hr_utility.set_location('Entering:'||l_proc, 5);
248: --
249: l_api_updating := per_cpo_shd.api_updating
250: (p_outcome_id => p_outcome_id
251: ,p_object_version_number => p_object_version_number
252: );
253: --
252: );
253: --
254: if (l_api_updating
255: and nvl(p_outcome_id,hr_api.g_number)
256: <> per_cpo_shd.g_old_rec.outcome_id) then
257: --
258: -- raise error as PK has changed
259: --
260: per_cpo_shd.constraint_error('PER_COMPETENCE_OUTCOMES_PK');
256: <> per_cpo_shd.g_old_rec.outcome_id) then
257: --
258: -- raise error as PK has changed
259: --
260: per_cpo_shd.constraint_error('PER_COMPETENCE_OUTCOMES_PK');
261: --
262: elsif not l_api_updating then
263: --
264: -- check if PK is null
266: if p_outcome_id is not null then
267: --
268: -- raise error as PK is not null
269: --
270: per_cpo_shd.constraint_error('PER_COMPETENCE_OUTCOMES_PK');
271: --
272: end if;
273: --
274: end if;
345: -- Only proceed with validation if :
346: -- a) The current g_old_rec is current and
347: -- b) The date_end value has changed
348: --
349: l_api_updating := per_cpo_shd.api_updating
350: (p_outcome_id => p_outcome_id
351: ,p_object_version_number => p_object_version_number);
352: --
353:
351: ,p_object_version_number => p_object_version_number);
352: --
353:
354: if ((l_api_updating and
355: (per_cpo_shd.g_old_rec.competence_id <> p_competence_id)) or
356: (NOT l_api_updating)) then
357:
358: --
359: -- Check that competence_id is a foreign key
363: open csr_competence;
364: fetch csr_competence into l_exists;
365: if csr_competence%NOTFOUND then
366: close csr_competence;
367: per_cpo_shd.constraint_error
368: (
369: p_constraint_name => 'PER_COMPETENCE_OUTCOME_FK1'
370: );
371: end if;
465: -- Only proceed with validation if :
466: -- a) The current g_old_rec is current and
467: -- b) The date_end value has changed
468: --
469: l_api_updating := per_cpo_shd.api_updating
470: (p_outcome_id => p_outcome_id
471: ,p_object_version_number => p_object_version_number);
472: --
473:
471: ,p_object_version_number => p_object_version_number);
472: --
473:
474: if (l_api_updating and
475: (per_cpo_shd.g_old_rec.outcome_number <> p_outcome_number or
476: per_cpo_shd.g_old_rec.date_from <> p_date_from or
477: nvl(per_cpo_shd.g_old_rec.date_to,hr_api.g_eot) <>
478: nvl(p_date_to,hr_api.g_eot)))
479: then
472: --
473:
474: if (l_api_updating and
475: (per_cpo_shd.g_old_rec.outcome_number <> p_outcome_number or
476: per_cpo_shd.g_old_rec.date_from <> p_date_from or
477: nvl(per_cpo_shd.g_old_rec.date_to,hr_api.g_eot) <>
478: nvl(p_date_to,hr_api.g_eot)))
479: then
480: --
473:
474: if (l_api_updating and
475: (per_cpo_shd.g_old_rec.outcome_number <> p_outcome_number or
476: per_cpo_shd.g_old_rec.date_from <> p_date_from or
477: nvl(per_cpo_shd.g_old_rec.date_to,hr_api.g_eot) <>
478: nvl(p_date_to,hr_api.g_eot)))
479: then
480: --
481: -- Check that outcome_number is unique
589: -- Only proceed with validation if :
590: -- a) The current g_old_rec is current and
591: -- b) The date_end value has changed
592:
593: l_api_updating := per_cpo_shd.api_updating
594: (p_outcome_id => p_outcome_id
595: ,p_object_version_number => p_object_version_number);
596: --
597:
595: ,p_object_version_number => p_object_version_number);
596: --
597:
598: if (l_api_updating and
599: per_cpo_shd.g_old_rec.name <> p_name or
600: per_cpo_shd.g_old_rec.date_from <> p_date_from or
601: nvl(per_cpo_shd.g_old_rec.date_to,hr_api.g_eot) <>
602: nvl(p_date_to,hr_api.g_eot))
603: then
596: --
597:
598: if (l_api_updating and
599: per_cpo_shd.g_old_rec.name <> p_name or
600: per_cpo_shd.g_old_rec.date_from <> p_date_from or
601: nvl(per_cpo_shd.g_old_rec.date_to,hr_api.g_eot) <>
602: nvl(p_date_to,hr_api.g_eot))
603: then
604: --
597:
598: if (l_api_updating and
599: per_cpo_shd.g_old_rec.name <> p_name or
600: per_cpo_shd.g_old_rec.date_from <> p_date_from or
601: nvl(per_cpo_shd.g_old_rec.date_to,hr_api.g_eot) <>
602: nvl(p_date_to,hr_api.g_eot))
603: then
604: --
605: -- Check that outcome_number is unique
688: -- Only proceed with validation if :
689: -- a) The current g_old_rec is current and
690: -- b) The date_end value has changed
691: --
692: l_api_updating := per_cpo_shd.api_updating
693: (p_outcome_id => p_outcome_id
694: ,p_object_version_number => p_object_version_number);
695: --
696: if (((l_api_updating and
693: (p_outcome_id => p_outcome_id
694: ,p_object_version_number => p_object_version_number);
695: --
696: if (((l_api_updating and
697: (nvl(per_cpo_shd.g_old_rec.date_to,hr_api.g_eot) <>
698: nvl(p_date_to,hr_api.g_eot)) or
699: (per_cpo_shd.g_old_rec.date_from <> p_date_from)) or
700: (NOT l_api_updating))) then
701: --
695: --
696: if (((l_api_updating and
697: (nvl(per_cpo_shd.g_old_rec.date_to,hr_api.g_eot) <>
698: nvl(p_date_to,hr_api.g_eot)) or
699: (per_cpo_shd.g_old_rec.date_from <> p_date_from)) or
700: (NOT l_api_updating))) then
701: --
702: -- Check that date_from <= date_to
703: --
806: -- Internal Row Handler Use Only.
807: --
808: -- ----------------------------------------------------------------------------
809: procedure chk_ddf
810: (p_rec in per_cpo_shd.g_rec_type
811: ) is
812: --
813: l_proc varchar2(72) := g_package || 'chk_ddf';
814: --
815: begin
816: hr_utility.set_location('Entering:'||l_proc,10);
817: --
818: if ((p_rec.outcome_id is not null) and (
819: nvl(per_cpo_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
820: nvl(p_rec.information_category, hr_api.g_varchar2) or
821: nvl(per_cpo_shd.g_old_rec.information1, hr_api.g_varchar2) <>
822: nvl(p_rec.information1, hr_api.g_varchar2) or
823: nvl(per_cpo_shd.g_old_rec.information2, hr_api.g_varchar2) <>
817: --
818: if ((p_rec.outcome_id is not null) and (
819: nvl(per_cpo_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
820: nvl(p_rec.information_category, hr_api.g_varchar2) or
821: nvl(per_cpo_shd.g_old_rec.information1, hr_api.g_varchar2) <>
822: nvl(p_rec.information1, hr_api.g_varchar2) or
823: nvl(per_cpo_shd.g_old_rec.information2, hr_api.g_varchar2) <>
824: nvl(p_rec.information2, hr_api.g_varchar2) or
825: nvl(per_cpo_shd.g_old_rec.information3, hr_api.g_varchar2) <>
819: nvl(per_cpo_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
820: nvl(p_rec.information_category, hr_api.g_varchar2) or
821: nvl(per_cpo_shd.g_old_rec.information1, hr_api.g_varchar2) <>
822: nvl(p_rec.information1, hr_api.g_varchar2) or
823: nvl(per_cpo_shd.g_old_rec.information2, hr_api.g_varchar2) <>
824: nvl(p_rec.information2, hr_api.g_varchar2) or
825: nvl(per_cpo_shd.g_old_rec.information3, hr_api.g_varchar2) <>
826: nvl(p_rec.information3, hr_api.g_varchar2) or
827: nvl(per_cpo_shd.g_old_rec.information4, hr_api.g_varchar2) <>
821: nvl(per_cpo_shd.g_old_rec.information1, hr_api.g_varchar2) <>
822: nvl(p_rec.information1, hr_api.g_varchar2) or
823: nvl(per_cpo_shd.g_old_rec.information2, hr_api.g_varchar2) <>
824: nvl(p_rec.information2, hr_api.g_varchar2) or
825: nvl(per_cpo_shd.g_old_rec.information3, hr_api.g_varchar2) <>
826: nvl(p_rec.information3, hr_api.g_varchar2) or
827: nvl(per_cpo_shd.g_old_rec.information4, hr_api.g_varchar2) <>
828: nvl(p_rec.information4, hr_api.g_varchar2) or
829: nvl(per_cpo_shd.g_old_rec.information5, hr_api.g_varchar2) <>
823: nvl(per_cpo_shd.g_old_rec.information2, hr_api.g_varchar2) <>
824: nvl(p_rec.information2, hr_api.g_varchar2) or
825: nvl(per_cpo_shd.g_old_rec.information3, hr_api.g_varchar2) <>
826: nvl(p_rec.information3, hr_api.g_varchar2) or
827: nvl(per_cpo_shd.g_old_rec.information4, hr_api.g_varchar2) <>
828: nvl(p_rec.information4, hr_api.g_varchar2) or
829: nvl(per_cpo_shd.g_old_rec.information5, hr_api.g_varchar2) <>
830: nvl(p_rec.information5, hr_api.g_varchar2) or
831: nvl(per_cpo_shd.g_old_rec.information6, hr_api.g_varchar2) <>
825: nvl(per_cpo_shd.g_old_rec.information3, hr_api.g_varchar2) <>
826: nvl(p_rec.information3, hr_api.g_varchar2) or
827: nvl(per_cpo_shd.g_old_rec.information4, hr_api.g_varchar2) <>
828: nvl(p_rec.information4, hr_api.g_varchar2) or
829: nvl(per_cpo_shd.g_old_rec.information5, hr_api.g_varchar2) <>
830: nvl(p_rec.information5, hr_api.g_varchar2) or
831: nvl(per_cpo_shd.g_old_rec.information6, hr_api.g_varchar2) <>
832: nvl(p_rec.information6, hr_api.g_varchar2) or
833: nvl(per_cpo_shd.g_old_rec.information7, hr_api.g_varchar2) <>
827: nvl(per_cpo_shd.g_old_rec.information4, hr_api.g_varchar2) <>
828: nvl(p_rec.information4, hr_api.g_varchar2) or
829: nvl(per_cpo_shd.g_old_rec.information5, hr_api.g_varchar2) <>
830: nvl(p_rec.information5, hr_api.g_varchar2) or
831: nvl(per_cpo_shd.g_old_rec.information6, hr_api.g_varchar2) <>
832: nvl(p_rec.information6, hr_api.g_varchar2) or
833: nvl(per_cpo_shd.g_old_rec.information7, hr_api.g_varchar2) <>
834: nvl(p_rec.information7, hr_api.g_varchar2) or
835: nvl(per_cpo_shd.g_old_rec.information8, hr_api.g_varchar2) <>
829: nvl(per_cpo_shd.g_old_rec.information5, hr_api.g_varchar2) <>
830: nvl(p_rec.information5, hr_api.g_varchar2) or
831: nvl(per_cpo_shd.g_old_rec.information6, hr_api.g_varchar2) <>
832: nvl(p_rec.information6, hr_api.g_varchar2) or
833: nvl(per_cpo_shd.g_old_rec.information7, hr_api.g_varchar2) <>
834: nvl(p_rec.information7, hr_api.g_varchar2) or
835: nvl(per_cpo_shd.g_old_rec.information8, hr_api.g_varchar2) <>
836: nvl(p_rec.information8, hr_api.g_varchar2) or
837: nvl(per_cpo_shd.g_old_rec.information9, hr_api.g_varchar2) <>
831: nvl(per_cpo_shd.g_old_rec.information6, hr_api.g_varchar2) <>
832: nvl(p_rec.information6, hr_api.g_varchar2) or
833: nvl(per_cpo_shd.g_old_rec.information7, hr_api.g_varchar2) <>
834: nvl(p_rec.information7, hr_api.g_varchar2) or
835: nvl(per_cpo_shd.g_old_rec.information8, hr_api.g_varchar2) <>
836: nvl(p_rec.information8, hr_api.g_varchar2) or
837: nvl(per_cpo_shd.g_old_rec.information9, hr_api.g_varchar2) <>
838: nvl(p_rec.information9, hr_api.g_varchar2) or
839: nvl(per_cpo_shd.g_old_rec.information10, hr_api.g_varchar2) <>
833: nvl(per_cpo_shd.g_old_rec.information7, hr_api.g_varchar2) <>
834: nvl(p_rec.information7, hr_api.g_varchar2) or
835: nvl(per_cpo_shd.g_old_rec.information8, hr_api.g_varchar2) <>
836: nvl(p_rec.information8, hr_api.g_varchar2) or
837: nvl(per_cpo_shd.g_old_rec.information9, hr_api.g_varchar2) <>
838: nvl(p_rec.information9, hr_api.g_varchar2) or
839: nvl(per_cpo_shd.g_old_rec.information10, hr_api.g_varchar2) <>
840: nvl(p_rec.information10, hr_api.g_varchar2) or
841: nvl(per_cpo_shd.g_old_rec.information11, hr_api.g_varchar2) <>
835: nvl(per_cpo_shd.g_old_rec.information8, hr_api.g_varchar2) <>
836: nvl(p_rec.information8, hr_api.g_varchar2) or
837: nvl(per_cpo_shd.g_old_rec.information9, hr_api.g_varchar2) <>
838: nvl(p_rec.information9, hr_api.g_varchar2) or
839: nvl(per_cpo_shd.g_old_rec.information10, hr_api.g_varchar2) <>
840: nvl(p_rec.information10, hr_api.g_varchar2) or
841: nvl(per_cpo_shd.g_old_rec.information11, hr_api.g_varchar2) <>
842: nvl(p_rec.information11, hr_api.g_varchar2) or
843: nvl(per_cpo_shd.g_old_rec.information13, hr_api.g_varchar2) <>
837: nvl(per_cpo_shd.g_old_rec.information9, hr_api.g_varchar2) <>
838: nvl(p_rec.information9, hr_api.g_varchar2) or
839: nvl(per_cpo_shd.g_old_rec.information10, hr_api.g_varchar2) <>
840: nvl(p_rec.information10, hr_api.g_varchar2) or
841: nvl(per_cpo_shd.g_old_rec.information11, hr_api.g_varchar2) <>
842: nvl(p_rec.information11, hr_api.g_varchar2) or
843: nvl(per_cpo_shd.g_old_rec.information13, hr_api.g_varchar2) <>
844: nvl(p_rec.information13, hr_api.g_varchar2) or
845: nvl(per_cpo_shd.g_old_rec.information14, hr_api.g_varchar2) <>
839: nvl(per_cpo_shd.g_old_rec.information10, hr_api.g_varchar2) <>
840: nvl(p_rec.information10, hr_api.g_varchar2) or
841: nvl(per_cpo_shd.g_old_rec.information11, hr_api.g_varchar2) <>
842: nvl(p_rec.information11, hr_api.g_varchar2) or
843: nvl(per_cpo_shd.g_old_rec.information13, hr_api.g_varchar2) <>
844: nvl(p_rec.information13, hr_api.g_varchar2) or
845: nvl(per_cpo_shd.g_old_rec.information14, hr_api.g_varchar2) <>
846: nvl(p_rec.information14, hr_api.g_varchar2) or
847: nvl(per_cpo_shd.g_old_rec.information15, hr_api.g_varchar2) <>
841: nvl(per_cpo_shd.g_old_rec.information11, hr_api.g_varchar2) <>
842: nvl(p_rec.information11, hr_api.g_varchar2) or
843: nvl(per_cpo_shd.g_old_rec.information13, hr_api.g_varchar2) <>
844: nvl(p_rec.information13, hr_api.g_varchar2) or
845: nvl(per_cpo_shd.g_old_rec.information14, hr_api.g_varchar2) <>
846: nvl(p_rec.information14, hr_api.g_varchar2) or
847: nvl(per_cpo_shd.g_old_rec.information15, hr_api.g_varchar2) <>
848: nvl(p_rec.information15, hr_api.g_varchar2) or
849: nvl(per_cpo_shd.g_old_rec.information16, hr_api.g_varchar2) <>
843: nvl(per_cpo_shd.g_old_rec.information13, hr_api.g_varchar2) <>
844: nvl(p_rec.information13, hr_api.g_varchar2) or
845: nvl(per_cpo_shd.g_old_rec.information14, hr_api.g_varchar2) <>
846: nvl(p_rec.information14, hr_api.g_varchar2) or
847: nvl(per_cpo_shd.g_old_rec.information15, hr_api.g_varchar2) <>
848: nvl(p_rec.information15, hr_api.g_varchar2) or
849: nvl(per_cpo_shd.g_old_rec.information16, hr_api.g_varchar2) <>
850: nvl(p_rec.information16, hr_api.g_varchar2) or
851: nvl(per_cpo_shd.g_old_rec.information17, hr_api.g_varchar2) <>
845: nvl(per_cpo_shd.g_old_rec.information14, hr_api.g_varchar2) <>
846: nvl(p_rec.information14, hr_api.g_varchar2) or
847: nvl(per_cpo_shd.g_old_rec.information15, hr_api.g_varchar2) <>
848: nvl(p_rec.information15, hr_api.g_varchar2) or
849: nvl(per_cpo_shd.g_old_rec.information16, hr_api.g_varchar2) <>
850: nvl(p_rec.information16, hr_api.g_varchar2) or
851: nvl(per_cpo_shd.g_old_rec.information17, hr_api.g_varchar2) <>
852: nvl(p_rec.information17, hr_api.g_varchar2) or
853: nvl(per_cpo_shd.g_old_rec.information18, hr_api.g_varchar2) <>
847: nvl(per_cpo_shd.g_old_rec.information15, hr_api.g_varchar2) <>
848: nvl(p_rec.information15, hr_api.g_varchar2) or
849: nvl(per_cpo_shd.g_old_rec.information16, hr_api.g_varchar2) <>
850: nvl(p_rec.information16, hr_api.g_varchar2) or
851: nvl(per_cpo_shd.g_old_rec.information17, hr_api.g_varchar2) <>
852: nvl(p_rec.information17, hr_api.g_varchar2) or
853: nvl(per_cpo_shd.g_old_rec.information18, hr_api.g_varchar2) <>
854: nvl(p_rec.information18, hr_api.g_varchar2) or
855: nvl(per_cpo_shd.g_old_rec.information19, hr_api.g_varchar2) <>
849: nvl(per_cpo_shd.g_old_rec.information16, hr_api.g_varchar2) <>
850: nvl(p_rec.information16, hr_api.g_varchar2) or
851: nvl(per_cpo_shd.g_old_rec.information17, hr_api.g_varchar2) <>
852: nvl(p_rec.information17, hr_api.g_varchar2) or
853: nvl(per_cpo_shd.g_old_rec.information18, hr_api.g_varchar2) <>
854: nvl(p_rec.information18, hr_api.g_varchar2) or
855: nvl(per_cpo_shd.g_old_rec.information19, hr_api.g_varchar2) <>
856: nvl(p_rec.information19, hr_api.g_varchar2) or
857: nvl(per_cpo_shd.g_old_rec.information20, hr_api.g_varchar2) <>
851: nvl(per_cpo_shd.g_old_rec.information17, hr_api.g_varchar2) <>
852: nvl(p_rec.information17, hr_api.g_varchar2) or
853: nvl(per_cpo_shd.g_old_rec.information18, hr_api.g_varchar2) <>
854: nvl(p_rec.information18, hr_api.g_varchar2) or
855: nvl(per_cpo_shd.g_old_rec.information19, hr_api.g_varchar2) <>
856: nvl(p_rec.information19, hr_api.g_varchar2) or
857: nvl(per_cpo_shd.g_old_rec.information20, hr_api.g_varchar2) <>
858: nvl(p_rec.information20, hr_api.g_varchar2) ))
859: or (p_rec.outcome_id is null) then
853: nvl(per_cpo_shd.g_old_rec.information18, hr_api.g_varchar2) <>
854: nvl(p_rec.information18, hr_api.g_varchar2) or
855: nvl(per_cpo_shd.g_old_rec.information19, hr_api.g_varchar2) <>
856: nvl(p_rec.information19, hr_api.g_varchar2) or
857: nvl(per_cpo_shd.g_old_rec.information20, hr_api.g_varchar2) <>
858: nvl(p_rec.information20, hr_api.g_varchar2) ))
859: or (p_rec.outcome_id is null) then
860: --
861: -- Only execute the validation if absolutely necessary:
941: -- Internal Row Handler Use Only.
942: --
943: -- ----------------------------------------------------------------------------
944: procedure chk_df
945: (p_rec in per_cpo_shd.g_rec_type
946: ) is
947: --
948: l_proc varchar2(72) := g_package || 'chk_df';
949: --
950: begin
951: hr_utility.set_location('Entering:'||l_proc,10);
952: --
953: if ((p_rec.outcome_id is not null) and (
954: nvl(per_cpo_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
955: nvl(p_rec.attribute1, hr_api.g_varchar2) or
956: nvl(per_cpo_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
957: nvl(p_rec.attribute2, hr_api.g_varchar2) or
958: nvl(per_cpo_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
952: --
953: if ((p_rec.outcome_id is not null) and (
954: nvl(per_cpo_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
955: nvl(p_rec.attribute1, hr_api.g_varchar2) or
956: nvl(per_cpo_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
957: nvl(p_rec.attribute2, hr_api.g_varchar2) or
958: nvl(per_cpo_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
959: nvl(p_rec.attribute3, hr_api.g_varchar2) or
960: nvl(per_cpo_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
954: nvl(per_cpo_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
955: nvl(p_rec.attribute1, hr_api.g_varchar2) or
956: nvl(per_cpo_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
957: nvl(p_rec.attribute2, hr_api.g_varchar2) or
958: nvl(per_cpo_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
959: nvl(p_rec.attribute3, hr_api.g_varchar2) or
960: nvl(per_cpo_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
961: nvl(p_rec.attribute4, hr_api.g_varchar2) or
962: nvl(per_cpo_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
956: nvl(per_cpo_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
957: nvl(p_rec.attribute2, hr_api.g_varchar2) or
958: nvl(per_cpo_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
959: nvl(p_rec.attribute3, hr_api.g_varchar2) or
960: nvl(per_cpo_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
961: nvl(p_rec.attribute4, hr_api.g_varchar2) or
962: nvl(per_cpo_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
963: nvl(p_rec.attribute5, hr_api.g_varchar2) or
964: nvl(per_cpo_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
958: nvl(per_cpo_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
959: nvl(p_rec.attribute3, hr_api.g_varchar2) or
960: nvl(per_cpo_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
961: nvl(p_rec.attribute4, hr_api.g_varchar2) or
962: nvl(per_cpo_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
963: nvl(p_rec.attribute5, hr_api.g_varchar2) or
964: nvl(per_cpo_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
965: nvl(p_rec.attribute6, hr_api.g_varchar2) or
966: nvl(per_cpo_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
960: nvl(per_cpo_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
961: nvl(p_rec.attribute4, hr_api.g_varchar2) or
962: nvl(per_cpo_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
963: nvl(p_rec.attribute5, hr_api.g_varchar2) or
964: nvl(per_cpo_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
965: nvl(p_rec.attribute6, hr_api.g_varchar2) or
966: nvl(per_cpo_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
967: nvl(p_rec.attribute7, hr_api.g_varchar2) or
968: nvl(per_cpo_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
962: nvl(per_cpo_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
963: nvl(p_rec.attribute5, hr_api.g_varchar2) or
964: nvl(per_cpo_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
965: nvl(p_rec.attribute6, hr_api.g_varchar2) or
966: nvl(per_cpo_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
967: nvl(p_rec.attribute7, hr_api.g_varchar2) or
968: nvl(per_cpo_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
969: nvl(p_rec.attribute8, hr_api.g_varchar2) or
970: nvl(per_cpo_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
964: nvl(per_cpo_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
965: nvl(p_rec.attribute6, hr_api.g_varchar2) or
966: nvl(per_cpo_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
967: nvl(p_rec.attribute7, hr_api.g_varchar2) or
968: nvl(per_cpo_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
969: nvl(p_rec.attribute8, hr_api.g_varchar2) or
970: nvl(per_cpo_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
971: nvl(p_rec.attribute9, hr_api.g_varchar2) or
972: nvl(per_cpo_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
966: nvl(per_cpo_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
967: nvl(p_rec.attribute7, hr_api.g_varchar2) or
968: nvl(per_cpo_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
969: nvl(p_rec.attribute8, hr_api.g_varchar2) or
970: nvl(per_cpo_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
971: nvl(p_rec.attribute9, hr_api.g_varchar2) or
972: nvl(per_cpo_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
973: nvl(p_rec.attribute10, hr_api.g_varchar2) or
974: nvl(per_cpo_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
968: nvl(per_cpo_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
969: nvl(p_rec.attribute8, hr_api.g_varchar2) or
970: nvl(per_cpo_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
971: nvl(p_rec.attribute9, hr_api.g_varchar2) or
972: nvl(per_cpo_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
973: nvl(p_rec.attribute10, hr_api.g_varchar2) or
974: nvl(per_cpo_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
975: nvl(p_rec.attribute11, hr_api.g_varchar2) or
976: nvl(per_cpo_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
970: nvl(per_cpo_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
971: nvl(p_rec.attribute9, hr_api.g_varchar2) or
972: nvl(per_cpo_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
973: nvl(p_rec.attribute10, hr_api.g_varchar2) or
974: nvl(per_cpo_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
975: nvl(p_rec.attribute11, hr_api.g_varchar2) or
976: nvl(per_cpo_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
977: nvl(p_rec.attribute12, hr_api.g_varchar2) or
978: nvl(per_cpo_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
972: nvl(per_cpo_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
973: nvl(p_rec.attribute10, hr_api.g_varchar2) or
974: nvl(per_cpo_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
975: nvl(p_rec.attribute11, hr_api.g_varchar2) or
976: nvl(per_cpo_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
977: nvl(p_rec.attribute12, hr_api.g_varchar2) or
978: nvl(per_cpo_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
979: nvl(p_rec.attribute13, hr_api.g_varchar2) or
980: nvl(per_cpo_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
974: nvl(per_cpo_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
975: nvl(p_rec.attribute11, hr_api.g_varchar2) or
976: nvl(per_cpo_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
977: nvl(p_rec.attribute12, hr_api.g_varchar2) or
978: nvl(per_cpo_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
979: nvl(p_rec.attribute13, hr_api.g_varchar2) or
980: nvl(per_cpo_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
981: nvl(p_rec.attribute14, hr_api.g_varchar2) or
982: nvl(per_cpo_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
976: nvl(per_cpo_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
977: nvl(p_rec.attribute12, hr_api.g_varchar2) or
978: nvl(per_cpo_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
979: nvl(p_rec.attribute13, hr_api.g_varchar2) or
980: nvl(per_cpo_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
981: nvl(p_rec.attribute14, hr_api.g_varchar2) or
982: nvl(per_cpo_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
983: nvl(p_rec.attribute15, hr_api.g_varchar2) or
984: nvl(per_cpo_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
978: nvl(per_cpo_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
979: nvl(p_rec.attribute13, hr_api.g_varchar2) or
980: nvl(per_cpo_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
981: nvl(p_rec.attribute14, hr_api.g_varchar2) or
982: nvl(per_cpo_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
983: nvl(p_rec.attribute15, hr_api.g_varchar2) or
984: nvl(per_cpo_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
985: nvl(p_rec.attribute16, hr_api.g_varchar2) or
986: nvl(per_cpo_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
980: nvl(per_cpo_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
981: nvl(p_rec.attribute14, hr_api.g_varchar2) or
982: nvl(per_cpo_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
983: nvl(p_rec.attribute15, hr_api.g_varchar2) or
984: nvl(per_cpo_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
985: nvl(p_rec.attribute16, hr_api.g_varchar2) or
986: nvl(per_cpo_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
987: nvl(p_rec.attribute17, hr_api.g_varchar2) or
988: nvl(per_cpo_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
982: nvl(per_cpo_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
983: nvl(p_rec.attribute15, hr_api.g_varchar2) or
984: nvl(per_cpo_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
985: nvl(p_rec.attribute16, hr_api.g_varchar2) or
986: nvl(per_cpo_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
987: nvl(p_rec.attribute17, hr_api.g_varchar2) or
988: nvl(per_cpo_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
989: nvl(p_rec.attribute18, hr_api.g_varchar2) or
990: nvl(per_cpo_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
984: nvl(per_cpo_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
985: nvl(p_rec.attribute16, hr_api.g_varchar2) or
986: nvl(per_cpo_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
987: nvl(p_rec.attribute17, hr_api.g_varchar2) or
988: nvl(per_cpo_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
989: nvl(p_rec.attribute18, hr_api.g_varchar2) or
990: nvl(per_cpo_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
991: nvl(p_rec.attribute19, hr_api.g_varchar2) or
992: nvl(per_cpo_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
986: nvl(per_cpo_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
987: nvl(p_rec.attribute17, hr_api.g_varchar2) or
988: nvl(per_cpo_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
989: nvl(p_rec.attribute18, hr_api.g_varchar2) or
990: nvl(per_cpo_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
991: nvl(p_rec.attribute19, hr_api.g_varchar2) or
992: nvl(per_cpo_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
993: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
994: or (p_rec.outcome_id is null) then
988: nvl(per_cpo_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
989: nvl(p_rec.attribute18, hr_api.g_varchar2) or
990: nvl(per_cpo_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
991: nvl(p_rec.attribute19, hr_api.g_varchar2) or
992: nvl(per_cpo_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
993: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
994: or (p_rec.outcome_id is null) then
995: --
996: -- Only execute the validation if absolutely necessary:
1053: -- |---------------------------< insert_validate >----------------------------|
1054: -- ----------------------------------------------------------------------------
1055: Procedure insert_validate
1056: (p_effective_date in date
1057: ,p_rec in per_cpo_shd.g_rec_type
1058: ) is
1059: --
1060: l_proc varchar2(72) := g_package||'insert_validate';
1061: --
1152: -- |---------------------------< update_validate >----------------------------|
1153: -- ----------------------------------------------------------------------------
1154: Procedure update_validate
1155: (p_effective_date in date
1156: ,p_rec in per_cpo_shd.g_rec_type
1157: ) is
1158: --
1159: l_proc varchar2(72) := g_package||'update_validate';
1160: --
1254: -- ----------------------------------------------------------------------------
1255: -- |---------------------------< delete_validate >----------------------------|
1256: -- ----------------------------------------------------------------------------
1257: Procedure delete_validate
1258: (p_rec in per_cpo_shd.g_rec_type
1259: ) is
1260: --
1261: l_proc varchar2(72) := g_package||'delete_validate';
1262: --