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_CPO_BUS dependencies on PER_CPO_SHD

Line 187: ,p_rec in per_cpo_shd.g_rec_type

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

Line 197: IF NOT per_cpo_shd.api_updating

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');

Line 249: l_api_updating := per_cpo_shd.api_updating

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

Line 256: <> per_cpo_shd.g_old_rec.outcome_id) then

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');

Line 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

Line 270: per_cpo_shd.constraint_error('PER_COMPETENCE_OUTCOMES_PK');

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;

Line 349: l_api_updating := per_cpo_shd.api_updating

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:

Line 355: (per_cpo_shd.g_old_rec.competence_id <> p_competence_id)) or

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

Line 367: per_cpo_shd.constraint_error

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;

Line 469: l_api_updating := per_cpo_shd.api_updating

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:

Line 475: (per_cpo_shd.g_old_rec.outcome_number <> p_outcome_number or

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

Line 476: per_cpo_shd.g_old_rec.date_from <> p_date_from or

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

Line 477: nvl(per_cpo_shd.g_old_rec.date_to,hr_api.g_eot) <>

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

Line 593: l_api_updating := per_cpo_shd.api_updating

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:

Line 599: per_cpo_shd.g_old_rec.name <> p_name or

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

Line 600: per_cpo_shd.g_old_rec.date_from <> p_date_from or

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

Line 601: nvl(per_cpo_shd.g_old_rec.date_to,hr_api.g_eot) <>

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

Line 692: l_api_updating := per_cpo_shd.api_updating

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

Line 697: (nvl(per_cpo_shd.g_old_rec.date_to,hr_api.g_eot) <>

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

Line 699: (per_cpo_shd.g_old_rec.date_from <> p_date_from)) or

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

Line 810: (p_rec in per_cpo_shd.g_rec_type

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

Line 819: nvl(per_cpo_shd.g_old_rec.information_category, hr_api.g_varchar2) <>

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) <>

Line 821: nvl(per_cpo_shd.g_old_rec.information1, 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) <>

Line 823: nvl(per_cpo_shd.g_old_rec.information2, 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) <>

Line 825: nvl(per_cpo_shd.g_old_rec.information3, 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) <>

Line 827: nvl(per_cpo_shd.g_old_rec.information4, 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) <>

Line 829: nvl(per_cpo_shd.g_old_rec.information5, 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) <>

Line 831: nvl(per_cpo_shd.g_old_rec.information6, 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) <>

Line 833: nvl(per_cpo_shd.g_old_rec.information7, 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) <>

Line 835: nvl(per_cpo_shd.g_old_rec.information8, 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) <>

Line 837: nvl(per_cpo_shd.g_old_rec.information9, 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) <>

Line 839: nvl(per_cpo_shd.g_old_rec.information10, 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) <>

Line 841: nvl(per_cpo_shd.g_old_rec.information11, 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) <>

Line 843: nvl(per_cpo_shd.g_old_rec.information13, 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) <>

Line 845: nvl(per_cpo_shd.g_old_rec.information14, 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) <>

Line 847: nvl(per_cpo_shd.g_old_rec.information15, 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) <>

Line 849: nvl(per_cpo_shd.g_old_rec.information16, 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) <>

Line 851: nvl(per_cpo_shd.g_old_rec.information17, 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) <>

Line 853: nvl(per_cpo_shd.g_old_rec.information18, 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) <>

Line 855: nvl(per_cpo_shd.g_old_rec.information19, 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

Line 857: nvl(per_cpo_shd.g_old_rec.information20, hr_api.g_varchar2) <>

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:

Line 945: (p_rec in per_cpo_shd.g_rec_type

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

Line 954: nvl(per_cpo_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

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) <>

Line 956: nvl(per_cpo_shd.g_old_rec.attribute2, 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) <>

Line 958: nvl(per_cpo_shd.g_old_rec.attribute3, 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) <>

Line 960: nvl(per_cpo_shd.g_old_rec.attribute4, 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) <>

Line 962: nvl(per_cpo_shd.g_old_rec.attribute5, 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) <>

Line 964: nvl(per_cpo_shd.g_old_rec.attribute6, 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) <>

Line 966: nvl(per_cpo_shd.g_old_rec.attribute7, 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) <>

Line 968: nvl(per_cpo_shd.g_old_rec.attribute8, 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) <>

Line 970: nvl(per_cpo_shd.g_old_rec.attribute9, 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) <>

Line 972: nvl(per_cpo_shd.g_old_rec.attribute10, 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) <>

Line 974: nvl(per_cpo_shd.g_old_rec.attribute11, 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) <>

Line 976: nvl(per_cpo_shd.g_old_rec.attribute12, 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) <>

Line 978: nvl(per_cpo_shd.g_old_rec.attribute13, 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) <>

Line 980: nvl(per_cpo_shd.g_old_rec.attribute14, 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) <>

Line 982: nvl(per_cpo_shd.g_old_rec.attribute15, 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) <>

Line 984: nvl(per_cpo_shd.g_old_rec.attribute16, 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) <>

Line 986: nvl(per_cpo_shd.g_old_rec.attribute17, 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) <>

Line 988: nvl(per_cpo_shd.g_old_rec.attribute18, 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) <>

Line 990: nvl(per_cpo_shd.g_old_rec.attribute19, 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

Line 992: nvl(per_cpo_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

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:

Line 1057: ,p_rec in per_cpo_shd.g_rec_type

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

Line 1156: ,p_rec in per_cpo_shd.g_rec_type

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

Line 1258: (p_rec in per_cpo_shd.g_rec_type

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