APPS.PER_CEO_BUS dependencies on PER_CEO_SHD

Line 187: ,p_rec in per_ceo_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_ceo_shd.g_rec_type
188: ) IS
189: --
190: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
191: --

Line 197: IF NOT per_ceo_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_ceo_shd.api_updating
198: (p_comp_element_outcome_id => p_rec.comp_element_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 250: l_api_updating := per_ceo_shd.api_updating

246: --
247: Begin
248: hr_utility.set_location('Entering:'||l_proc, 5);
249: --
250: l_api_updating := per_ceo_shd.api_updating
251: (p_comp_element_outcome_id => p_comp_element_outcome_id
252: ,p_object_version_number => p_object_version_number
253: );
254: --

Line 257: <> per_ceo_shd.g_old_rec.comp_element_outcome_id) then

253: );
254: --
255: if (l_api_updating
256: and nvl(p_comp_element_outcome_id,hr_api.g_number)
257: <> per_ceo_shd.g_old_rec.comp_element_outcome_id) then
258: --
259: -- raise error as PK has changed
260: --
261: per_ceo_shd.constraint_error('PER_COMP_ELEMENT_OUTCOMES_PK');

Line 261: per_ceo_shd.constraint_error('PER_COMP_ELEMENT_OUTCOMES_PK');

257: <> per_ceo_shd.g_old_rec.comp_element_outcome_id) then
258: --
259: -- raise error as PK has changed
260: --
261: per_ceo_shd.constraint_error('PER_COMP_ELEMENT_OUTCOMES_PK');
262: --
263: elsif not l_api_updating then
264: --
265: -- check if PK is null

Line 271: per_ceo_shd.constraint_error('PER_COMP_ELEMENT_OUTCOMES_PK');

267: if p_comp_element_outcome_id is not null then
268: --
269: -- raise error as PK is not null
270: --
271: per_ceo_shd.constraint_error('PER_COMP_ELEMENT_OUTCOMES_PK');
272: --
273: end if;
274: --
275: end if;

Line 350: l_api_updating := per_ceo_shd.api_updating

346: -- Only proceed with validation if :
347: -- a) The current g_old_rec is current and
348: -- b) The date_end value has changed
349: --
350: l_api_updating := per_ceo_shd.api_updating
351: (p_comp_element_outcome_id => p_comp_element_outcome_id
352: ,p_object_version_number => p_object_version_number);
353: --
354:

Line 356: (per_ceo_shd.g_old_rec.competence_element_id <>

352: ,p_object_version_number => p_object_version_number);
353: --
354:
355: if ((l_api_updating and
356: (per_ceo_shd.g_old_rec.competence_element_id <>
357: p_competence_element_id)) or
358: (NOT l_api_updating)) then
359:
360: --

Line 369: per_ceo_shd.constraint_error

365: open csr_competence_element;
366: fetch csr_competence_element into l_exists;
367: if csr_competence_element%NOTFOUND then
368: close csr_competence_element;
369: per_ceo_shd.constraint_error
370: (
371: p_constraint_name => 'PER_COMP_ELEMENT_OUTCOME_FK1'
372: );
373: end if;

Line 452: l_api_updating := per_ceo_shd.api_updating

448: -- Only proceed with validation if :
449: -- a) The current g_old_rec is current and
450: -- b) The date_end value has changed
451: --
452: l_api_updating := per_ceo_shd.api_updating
453: (p_comp_element_outcome_id => p_comp_element_outcome_id
454: ,p_object_version_number => p_object_version_number);
455: --
456:

Line 458: (per_ceo_shd.g_old_rec.outcome_id <> p_outcome_id)) or

454: ,p_object_version_number => p_object_version_number);
455: --
456:
457: if ((l_api_updating and
458: (per_ceo_shd.g_old_rec.outcome_id <> p_outcome_id)) or
459: (NOT l_api_updating)) then
460:
461: --
462: -- Check that outcome_id is a foreign key

Line 470: per_ceo_shd.constraint_error

466: open csr_competence_outcome;
467: fetch csr_competence_outcome into l_exists;
468: if csr_competence_outcome%NOTFOUND then
469: close csr_competence_outcome;
470: per_ceo_shd.constraint_error
471: (
472: p_constraint_name => 'PER_COMP_ELEMENT_OUTCOME_FK2'
473: );
474: end if;

Line 570: l_api_updating := per_ceo_shd.api_updating

566: -- Only proceed with validation if :
567: -- a) The current g_old_rec is current and
568: -- b) The date_end value has changed
569: --
570: l_api_updating := per_ceo_shd.api_updating
571: (p_comp_element_outcome_id => p_comp_element_outcome_id
572: ,p_object_version_number => p_object_version_number);
573: --
574:

Line 576: (per_ceo_shd.g_old_rec.competence_element_id <>

572: ,p_object_version_number => p_object_version_number);
573: --
574:
575: if (l_api_updating and
576: (per_ceo_shd.g_old_rec.competence_element_id <>
577: p_competence_element_id or
578: per_ceo_shd.g_old_rec.outcome_id <> p_outcome_id or
579: per_ceo_shd.g_old_rec.date_from <> p_date_from or
580: nvl(per_ceo_shd.g_old_rec.date_to,hr_api.g_eot) <>

Line 578: per_ceo_shd.g_old_rec.outcome_id <> p_outcome_id or

574:
575: if (l_api_updating and
576: (per_ceo_shd.g_old_rec.competence_element_id <>
577: p_competence_element_id or
578: per_ceo_shd.g_old_rec.outcome_id <> p_outcome_id or
579: per_ceo_shd.g_old_rec.date_from <> p_date_from or
580: nvl(per_ceo_shd.g_old_rec.date_to,hr_api.g_eot) <>
581: nvl(p_date_to,hr_api.g_eot))) then
582: --

Line 579: per_ceo_shd.g_old_rec.date_from <> p_date_from or

575: if (l_api_updating and
576: (per_ceo_shd.g_old_rec.competence_element_id <>
577: p_competence_element_id or
578: per_ceo_shd.g_old_rec.outcome_id <> p_outcome_id or
579: per_ceo_shd.g_old_rec.date_from <> p_date_from or
580: nvl(per_ceo_shd.g_old_rec.date_to,hr_api.g_eot) <>
581: nvl(p_date_to,hr_api.g_eot))) then
582: --
583: -- Check that a combination is unique

Line 580: nvl(per_ceo_shd.g_old_rec.date_to,hr_api.g_eot) <>

576: (per_ceo_shd.g_old_rec.competence_element_id <>
577: p_competence_element_id or
578: per_ceo_shd.g_old_rec.outcome_id <> p_outcome_id or
579: per_ceo_shd.g_old_rec.date_from <> p_date_from or
580: nvl(per_ceo_shd.g_old_rec.date_to,hr_api.g_eot) <>
581: nvl(p_date_to,hr_api.g_eot))) then
582: --
583: -- Check that a combination is unique
584: --

Line 694: l_api_updating := per_ceo_shd.api_updating

690: -- Only proceed with validation if :
691: -- a) The current g_old_rec is current and
692: -- b) The date_end value has changed
693: --
694: l_api_updating := per_ceo_shd.api_updating
695: (p_comp_element_outcome_id => p_comp_element_outcome_id
696: ,p_object_version_number => p_object_version_number);
697: --
698: if (((l_api_updating and

Line 699: (nvl(per_ceo_shd.g_old_rec.date_to,hr_api.g_eot) <>

695: (p_comp_element_outcome_id => p_comp_element_outcome_id
696: ,p_object_version_number => p_object_version_number);
697: --
698: if (((l_api_updating and
699: (nvl(per_ceo_shd.g_old_rec.date_to,hr_api.g_eot) <>
700: nvl(p_date_to,hr_api.g_eot)) or
701: (per_ceo_shd.g_old_rec.date_from <> p_date_from)) or
702: (NOT l_api_updating))) then
703: --

Line 701: (per_ceo_shd.g_old_rec.date_from <> p_date_from)) or

697: --
698: if (((l_api_updating and
699: (nvl(per_ceo_shd.g_old_rec.date_to,hr_api.g_eot) <>
700: nvl(p_date_to,hr_api.g_eot)) or
701: (per_ceo_shd.g_old_rec.date_from <> p_date_from)) or
702: (NOT l_api_updating))) then
703: --
704: -- Check that date_from <= date_to
705: --

Line 766: (p_rec in per_ceo_shd.g_rec_type

762: -- Internal Row Handler Use Only.
763: --
764: -- ----------------------------------------------------------------------------
765: procedure chk_ddf
766: (p_rec in per_ceo_shd.g_rec_type
767: ) is
768: --
769: l_proc varchar2(72) := g_package || 'chk_ddf';
770: --

Line 775: nvl(per_ceo_shd.g_old_rec.information_category, hr_api.g_varchar2) <>

771: begin
772: hr_utility.set_location('Entering:'||l_proc,10);
773: --
774: if ((p_rec.comp_element_outcome_id is not null) and (
775: nvl(per_ceo_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
776: nvl(p_rec.information_category, hr_api.g_varchar2) or
777: nvl(per_ceo_shd.g_old_rec.information1, hr_api.g_varchar2) <>
778: nvl(p_rec.information1, hr_api.g_varchar2) or
779: nvl(per_ceo_shd.g_old_rec.information2, hr_api.g_varchar2) <>

Line 777: nvl(per_ceo_shd.g_old_rec.information1, hr_api.g_varchar2) <>

773: --
774: if ((p_rec.comp_element_outcome_id is not null) and (
775: nvl(per_ceo_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
776: nvl(p_rec.information_category, hr_api.g_varchar2) or
777: nvl(per_ceo_shd.g_old_rec.information1, hr_api.g_varchar2) <>
778: nvl(p_rec.information1, hr_api.g_varchar2) or
779: nvl(per_ceo_shd.g_old_rec.information2, hr_api.g_varchar2) <>
780: nvl(p_rec.information2, hr_api.g_varchar2) or
781: nvl(per_ceo_shd.g_old_rec.information3, hr_api.g_varchar2) <>

Line 779: nvl(per_ceo_shd.g_old_rec.information2, hr_api.g_varchar2) <>

775: nvl(per_ceo_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
776: nvl(p_rec.information_category, hr_api.g_varchar2) or
777: nvl(per_ceo_shd.g_old_rec.information1, hr_api.g_varchar2) <>
778: nvl(p_rec.information1, hr_api.g_varchar2) or
779: nvl(per_ceo_shd.g_old_rec.information2, hr_api.g_varchar2) <>
780: nvl(p_rec.information2, hr_api.g_varchar2) or
781: nvl(per_ceo_shd.g_old_rec.information3, hr_api.g_varchar2) <>
782: nvl(p_rec.information3, hr_api.g_varchar2) or
783: nvl(per_ceo_shd.g_old_rec.information4, hr_api.g_varchar2) <>

Line 781: nvl(per_ceo_shd.g_old_rec.information3, hr_api.g_varchar2) <>

777: nvl(per_ceo_shd.g_old_rec.information1, hr_api.g_varchar2) <>
778: nvl(p_rec.information1, hr_api.g_varchar2) or
779: nvl(per_ceo_shd.g_old_rec.information2, hr_api.g_varchar2) <>
780: nvl(p_rec.information2, hr_api.g_varchar2) or
781: nvl(per_ceo_shd.g_old_rec.information3, hr_api.g_varchar2) <>
782: nvl(p_rec.information3, hr_api.g_varchar2) or
783: nvl(per_ceo_shd.g_old_rec.information4, hr_api.g_varchar2) <>
784: nvl(p_rec.information4, hr_api.g_varchar2) or
785: nvl(per_ceo_shd.g_old_rec.information5, hr_api.g_varchar2) <>

Line 783: nvl(per_ceo_shd.g_old_rec.information4, hr_api.g_varchar2) <>

779: nvl(per_ceo_shd.g_old_rec.information2, hr_api.g_varchar2) <>
780: nvl(p_rec.information2, hr_api.g_varchar2) or
781: nvl(per_ceo_shd.g_old_rec.information3, hr_api.g_varchar2) <>
782: nvl(p_rec.information3, hr_api.g_varchar2) or
783: nvl(per_ceo_shd.g_old_rec.information4, hr_api.g_varchar2) <>
784: nvl(p_rec.information4, hr_api.g_varchar2) or
785: nvl(per_ceo_shd.g_old_rec.information5, hr_api.g_varchar2) <>
786: nvl(p_rec.information5, hr_api.g_varchar2) or
787: nvl(per_ceo_shd.g_old_rec.information6, hr_api.g_varchar2) <>

Line 785: nvl(per_ceo_shd.g_old_rec.information5, hr_api.g_varchar2) <>

781: nvl(per_ceo_shd.g_old_rec.information3, hr_api.g_varchar2) <>
782: nvl(p_rec.information3, hr_api.g_varchar2) or
783: nvl(per_ceo_shd.g_old_rec.information4, hr_api.g_varchar2) <>
784: nvl(p_rec.information4, hr_api.g_varchar2) or
785: nvl(per_ceo_shd.g_old_rec.information5, hr_api.g_varchar2) <>
786: nvl(p_rec.information5, hr_api.g_varchar2) or
787: nvl(per_ceo_shd.g_old_rec.information6, hr_api.g_varchar2) <>
788: nvl(p_rec.information6, hr_api.g_varchar2) or
789: nvl(per_ceo_shd.g_old_rec.information7, hr_api.g_varchar2) <>

Line 787: nvl(per_ceo_shd.g_old_rec.information6, hr_api.g_varchar2) <>

783: nvl(per_ceo_shd.g_old_rec.information4, hr_api.g_varchar2) <>
784: nvl(p_rec.information4, hr_api.g_varchar2) or
785: nvl(per_ceo_shd.g_old_rec.information5, hr_api.g_varchar2) <>
786: nvl(p_rec.information5, hr_api.g_varchar2) or
787: nvl(per_ceo_shd.g_old_rec.information6, hr_api.g_varchar2) <>
788: nvl(p_rec.information6, hr_api.g_varchar2) or
789: nvl(per_ceo_shd.g_old_rec.information7, hr_api.g_varchar2) <>
790: nvl(p_rec.information7, hr_api.g_varchar2) or
791: nvl(per_ceo_shd.g_old_rec.information8, hr_api.g_varchar2) <>

Line 789: nvl(per_ceo_shd.g_old_rec.information7, hr_api.g_varchar2) <>

785: nvl(per_ceo_shd.g_old_rec.information5, hr_api.g_varchar2) <>
786: nvl(p_rec.information5, hr_api.g_varchar2) or
787: nvl(per_ceo_shd.g_old_rec.information6, hr_api.g_varchar2) <>
788: nvl(p_rec.information6, hr_api.g_varchar2) or
789: nvl(per_ceo_shd.g_old_rec.information7, hr_api.g_varchar2) <>
790: nvl(p_rec.information7, hr_api.g_varchar2) or
791: nvl(per_ceo_shd.g_old_rec.information8, hr_api.g_varchar2) <>
792: nvl(p_rec.information8, hr_api.g_varchar2) or
793: nvl(per_ceo_shd.g_old_rec.information9, hr_api.g_varchar2) <>

Line 791: nvl(per_ceo_shd.g_old_rec.information8, hr_api.g_varchar2) <>

787: nvl(per_ceo_shd.g_old_rec.information6, hr_api.g_varchar2) <>
788: nvl(p_rec.information6, hr_api.g_varchar2) or
789: nvl(per_ceo_shd.g_old_rec.information7, hr_api.g_varchar2) <>
790: nvl(p_rec.information7, hr_api.g_varchar2) or
791: nvl(per_ceo_shd.g_old_rec.information8, hr_api.g_varchar2) <>
792: nvl(p_rec.information8, hr_api.g_varchar2) or
793: nvl(per_ceo_shd.g_old_rec.information9, hr_api.g_varchar2) <>
794: nvl(p_rec.information9, hr_api.g_varchar2) or
795: nvl(per_ceo_shd.g_old_rec.information10, hr_api.g_varchar2) <>

Line 793: nvl(per_ceo_shd.g_old_rec.information9, hr_api.g_varchar2) <>

789: nvl(per_ceo_shd.g_old_rec.information7, hr_api.g_varchar2) <>
790: nvl(p_rec.information7, hr_api.g_varchar2) or
791: nvl(per_ceo_shd.g_old_rec.information8, hr_api.g_varchar2) <>
792: nvl(p_rec.information8, hr_api.g_varchar2) or
793: nvl(per_ceo_shd.g_old_rec.information9, hr_api.g_varchar2) <>
794: nvl(p_rec.information9, hr_api.g_varchar2) or
795: nvl(per_ceo_shd.g_old_rec.information10, hr_api.g_varchar2) <>
796: nvl(p_rec.information10, hr_api.g_varchar2) or
797: nvl(per_ceo_shd.g_old_rec.information11, hr_api.g_varchar2) <>

Line 795: nvl(per_ceo_shd.g_old_rec.information10, hr_api.g_varchar2) <>

791: nvl(per_ceo_shd.g_old_rec.information8, hr_api.g_varchar2) <>
792: nvl(p_rec.information8, hr_api.g_varchar2) or
793: nvl(per_ceo_shd.g_old_rec.information9, hr_api.g_varchar2) <>
794: nvl(p_rec.information9, hr_api.g_varchar2) or
795: nvl(per_ceo_shd.g_old_rec.information10, hr_api.g_varchar2) <>
796: nvl(p_rec.information10, hr_api.g_varchar2) or
797: nvl(per_ceo_shd.g_old_rec.information11, hr_api.g_varchar2) <>
798: nvl(p_rec.information11, hr_api.g_varchar2) or
799: nvl(per_ceo_shd.g_old_rec.information13, hr_api.g_varchar2) <>

Line 797: nvl(per_ceo_shd.g_old_rec.information11, hr_api.g_varchar2) <>

793: nvl(per_ceo_shd.g_old_rec.information9, hr_api.g_varchar2) <>
794: nvl(p_rec.information9, hr_api.g_varchar2) or
795: nvl(per_ceo_shd.g_old_rec.information10, hr_api.g_varchar2) <>
796: nvl(p_rec.information10, hr_api.g_varchar2) or
797: nvl(per_ceo_shd.g_old_rec.information11, hr_api.g_varchar2) <>
798: nvl(p_rec.information11, hr_api.g_varchar2) or
799: nvl(per_ceo_shd.g_old_rec.information13, hr_api.g_varchar2) <>
800: nvl(p_rec.information13, hr_api.g_varchar2) or
801: nvl(per_ceo_shd.g_old_rec.information14, hr_api.g_varchar2) <>

Line 799: nvl(per_ceo_shd.g_old_rec.information13, hr_api.g_varchar2) <>

795: nvl(per_ceo_shd.g_old_rec.information10, hr_api.g_varchar2) <>
796: nvl(p_rec.information10, hr_api.g_varchar2) or
797: nvl(per_ceo_shd.g_old_rec.information11, hr_api.g_varchar2) <>
798: nvl(p_rec.information11, hr_api.g_varchar2) or
799: nvl(per_ceo_shd.g_old_rec.information13, hr_api.g_varchar2) <>
800: nvl(p_rec.information13, hr_api.g_varchar2) or
801: nvl(per_ceo_shd.g_old_rec.information14, hr_api.g_varchar2) <>
802: nvl(p_rec.information14, hr_api.g_varchar2) or
803: nvl(per_ceo_shd.g_old_rec.information15, hr_api.g_varchar2) <>

Line 801: nvl(per_ceo_shd.g_old_rec.information14, hr_api.g_varchar2) <>

797: nvl(per_ceo_shd.g_old_rec.information11, hr_api.g_varchar2) <>
798: nvl(p_rec.information11, hr_api.g_varchar2) or
799: nvl(per_ceo_shd.g_old_rec.information13, hr_api.g_varchar2) <>
800: nvl(p_rec.information13, hr_api.g_varchar2) or
801: nvl(per_ceo_shd.g_old_rec.information14, hr_api.g_varchar2) <>
802: nvl(p_rec.information14, hr_api.g_varchar2) or
803: nvl(per_ceo_shd.g_old_rec.information15, hr_api.g_varchar2) <>
804: nvl(p_rec.information15, hr_api.g_varchar2) or
805: nvl(per_ceo_shd.g_old_rec.information16, hr_api.g_varchar2) <>

Line 803: nvl(per_ceo_shd.g_old_rec.information15, hr_api.g_varchar2) <>

799: nvl(per_ceo_shd.g_old_rec.information13, hr_api.g_varchar2) <>
800: nvl(p_rec.information13, hr_api.g_varchar2) or
801: nvl(per_ceo_shd.g_old_rec.information14, hr_api.g_varchar2) <>
802: nvl(p_rec.information14, hr_api.g_varchar2) or
803: nvl(per_ceo_shd.g_old_rec.information15, hr_api.g_varchar2) <>
804: nvl(p_rec.information15, hr_api.g_varchar2) or
805: nvl(per_ceo_shd.g_old_rec.information16, hr_api.g_varchar2) <>
806: nvl(p_rec.information16, hr_api.g_varchar2) or
807: nvl(per_ceo_shd.g_old_rec.information17, hr_api.g_varchar2) <>

Line 805: nvl(per_ceo_shd.g_old_rec.information16, hr_api.g_varchar2) <>

801: nvl(per_ceo_shd.g_old_rec.information14, hr_api.g_varchar2) <>
802: nvl(p_rec.information14, hr_api.g_varchar2) or
803: nvl(per_ceo_shd.g_old_rec.information15, hr_api.g_varchar2) <>
804: nvl(p_rec.information15, hr_api.g_varchar2) or
805: nvl(per_ceo_shd.g_old_rec.information16, hr_api.g_varchar2) <>
806: nvl(p_rec.information16, hr_api.g_varchar2) or
807: nvl(per_ceo_shd.g_old_rec.information17, hr_api.g_varchar2) <>
808: nvl(p_rec.information17, hr_api.g_varchar2) or
809: nvl(per_ceo_shd.g_old_rec.information18, hr_api.g_varchar2) <>

Line 807: nvl(per_ceo_shd.g_old_rec.information17, hr_api.g_varchar2) <>

803: nvl(per_ceo_shd.g_old_rec.information15, hr_api.g_varchar2) <>
804: nvl(p_rec.information15, hr_api.g_varchar2) or
805: nvl(per_ceo_shd.g_old_rec.information16, hr_api.g_varchar2) <>
806: nvl(p_rec.information16, hr_api.g_varchar2) or
807: nvl(per_ceo_shd.g_old_rec.information17, hr_api.g_varchar2) <>
808: nvl(p_rec.information17, hr_api.g_varchar2) or
809: nvl(per_ceo_shd.g_old_rec.information18, hr_api.g_varchar2) <>
810: nvl(p_rec.information18, hr_api.g_varchar2) or
811: nvl(per_ceo_shd.g_old_rec.information19, hr_api.g_varchar2) <>

Line 809: nvl(per_ceo_shd.g_old_rec.information18, hr_api.g_varchar2) <>

805: nvl(per_ceo_shd.g_old_rec.information16, hr_api.g_varchar2) <>
806: nvl(p_rec.information16, hr_api.g_varchar2) or
807: nvl(per_ceo_shd.g_old_rec.information17, hr_api.g_varchar2) <>
808: nvl(p_rec.information17, hr_api.g_varchar2) or
809: nvl(per_ceo_shd.g_old_rec.information18, hr_api.g_varchar2) <>
810: nvl(p_rec.information18, hr_api.g_varchar2) or
811: nvl(per_ceo_shd.g_old_rec.information19, hr_api.g_varchar2) <>
812: nvl(p_rec.information19, hr_api.g_varchar2) or
813: nvl(per_ceo_shd.g_old_rec.information20, hr_api.g_varchar2) <>

Line 811: nvl(per_ceo_shd.g_old_rec.information19, hr_api.g_varchar2) <>

807: nvl(per_ceo_shd.g_old_rec.information17, hr_api.g_varchar2) <>
808: nvl(p_rec.information17, hr_api.g_varchar2) or
809: nvl(per_ceo_shd.g_old_rec.information18, hr_api.g_varchar2) <>
810: nvl(p_rec.information18, hr_api.g_varchar2) or
811: nvl(per_ceo_shd.g_old_rec.information19, hr_api.g_varchar2) <>
812: nvl(p_rec.information19, hr_api.g_varchar2) or
813: nvl(per_ceo_shd.g_old_rec.information20, hr_api.g_varchar2) <>
814: nvl(p_rec.information20, hr_api.g_varchar2) ))
815: or (p_rec.comp_element_outcome_id is null) then

Line 813: nvl(per_ceo_shd.g_old_rec.information20, hr_api.g_varchar2) <>

809: nvl(per_ceo_shd.g_old_rec.information18, hr_api.g_varchar2) <>
810: nvl(p_rec.information18, hr_api.g_varchar2) or
811: nvl(per_ceo_shd.g_old_rec.information19, hr_api.g_varchar2) <>
812: nvl(p_rec.information19, hr_api.g_varchar2) or
813: nvl(per_ceo_shd.g_old_rec.information20, hr_api.g_varchar2) <>
814: nvl(p_rec.information20, hr_api.g_varchar2) ))
815: or (p_rec.comp_element_outcome_id is null) then
816: --
817: -- Only execute the validation if absolutely necessary:

Line 901: (p_rec in per_ceo_shd.g_rec_type

897: -- Internal Row Handler Use Only.
898: --
899: -- ----------------------------------------------------------------------------
900: procedure chk_df
901: (p_rec in per_ceo_shd.g_rec_type
902: ) is
903: --
904: l_proc varchar2(72) := g_package || 'chk_df';
905: --

Line 910: nvl(per_ceo_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

906: begin
907: hr_utility.set_location('Entering:'||l_proc,10);
908: --
909: if ((p_rec.comp_element_outcome_id is not null) and (
910: nvl(per_ceo_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
911: nvl(p_rec.attribute1, hr_api.g_varchar2) or
912: nvl(per_ceo_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
913: nvl(p_rec.attribute2, hr_api.g_varchar2) or
914: nvl(per_ceo_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

Line 912: nvl(per_ceo_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

908: --
909: if ((p_rec.comp_element_outcome_id is not null) and (
910: nvl(per_ceo_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
911: nvl(p_rec.attribute1, hr_api.g_varchar2) or
912: nvl(per_ceo_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
913: nvl(p_rec.attribute2, hr_api.g_varchar2) or
914: nvl(per_ceo_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
915: nvl(p_rec.attribute3, hr_api.g_varchar2) or
916: nvl(per_ceo_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

Line 914: nvl(per_ceo_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

910: nvl(per_ceo_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
911: nvl(p_rec.attribute1, hr_api.g_varchar2) or
912: nvl(per_ceo_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
913: nvl(p_rec.attribute2, hr_api.g_varchar2) or
914: nvl(per_ceo_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
915: nvl(p_rec.attribute3, hr_api.g_varchar2) or
916: nvl(per_ceo_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
917: nvl(p_rec.attribute4, hr_api.g_varchar2) or
918: nvl(per_ceo_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

Line 916: nvl(per_ceo_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

912: nvl(per_ceo_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
913: nvl(p_rec.attribute2, hr_api.g_varchar2) or
914: nvl(per_ceo_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
915: nvl(p_rec.attribute3, hr_api.g_varchar2) or
916: nvl(per_ceo_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
917: nvl(p_rec.attribute4, hr_api.g_varchar2) or
918: nvl(per_ceo_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
919: nvl(p_rec.attribute5, hr_api.g_varchar2) or
920: nvl(per_ceo_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

Line 918: nvl(per_ceo_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

914: nvl(per_ceo_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
915: nvl(p_rec.attribute3, hr_api.g_varchar2) or
916: nvl(per_ceo_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
917: nvl(p_rec.attribute4, hr_api.g_varchar2) or
918: nvl(per_ceo_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
919: nvl(p_rec.attribute5, hr_api.g_varchar2) or
920: nvl(per_ceo_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
921: nvl(p_rec.attribute6, hr_api.g_varchar2) or
922: nvl(per_ceo_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

Line 920: nvl(per_ceo_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

916: nvl(per_ceo_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
917: nvl(p_rec.attribute4, hr_api.g_varchar2) or
918: nvl(per_ceo_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
919: nvl(p_rec.attribute5, hr_api.g_varchar2) or
920: nvl(per_ceo_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
921: nvl(p_rec.attribute6, hr_api.g_varchar2) or
922: nvl(per_ceo_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
923: nvl(p_rec.attribute7, hr_api.g_varchar2) or
924: nvl(per_ceo_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

Line 922: nvl(per_ceo_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

918: nvl(per_ceo_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
919: nvl(p_rec.attribute5, hr_api.g_varchar2) or
920: nvl(per_ceo_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
921: nvl(p_rec.attribute6, hr_api.g_varchar2) or
922: nvl(per_ceo_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
923: nvl(p_rec.attribute7, hr_api.g_varchar2) or
924: nvl(per_ceo_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
925: nvl(p_rec.attribute8, hr_api.g_varchar2) or
926: nvl(per_ceo_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

Line 924: nvl(per_ceo_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

920: nvl(per_ceo_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
921: nvl(p_rec.attribute6, hr_api.g_varchar2) or
922: nvl(per_ceo_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
923: nvl(p_rec.attribute7, hr_api.g_varchar2) or
924: nvl(per_ceo_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
925: nvl(p_rec.attribute8, hr_api.g_varchar2) or
926: nvl(per_ceo_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
927: nvl(p_rec.attribute9, hr_api.g_varchar2) or
928: nvl(per_ceo_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

Line 926: nvl(per_ceo_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

922: nvl(per_ceo_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
923: nvl(p_rec.attribute7, hr_api.g_varchar2) or
924: nvl(per_ceo_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
925: nvl(p_rec.attribute8, hr_api.g_varchar2) or
926: nvl(per_ceo_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
927: nvl(p_rec.attribute9, hr_api.g_varchar2) or
928: nvl(per_ceo_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
929: nvl(p_rec.attribute10, hr_api.g_varchar2) or
930: nvl(per_ceo_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

Line 928: nvl(per_ceo_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

924: nvl(per_ceo_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
925: nvl(p_rec.attribute8, hr_api.g_varchar2) or
926: nvl(per_ceo_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
927: nvl(p_rec.attribute9, hr_api.g_varchar2) or
928: nvl(per_ceo_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
929: nvl(p_rec.attribute10, hr_api.g_varchar2) or
930: nvl(per_ceo_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
931: nvl(p_rec.attribute11, hr_api.g_varchar2) or
932: nvl(per_ceo_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

Line 930: nvl(per_ceo_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

926: nvl(per_ceo_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
927: nvl(p_rec.attribute9, hr_api.g_varchar2) or
928: nvl(per_ceo_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
929: nvl(p_rec.attribute10, hr_api.g_varchar2) or
930: nvl(per_ceo_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
931: nvl(p_rec.attribute11, hr_api.g_varchar2) or
932: nvl(per_ceo_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
933: nvl(p_rec.attribute12, hr_api.g_varchar2) or
934: nvl(per_ceo_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

Line 932: nvl(per_ceo_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

928: nvl(per_ceo_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
929: nvl(p_rec.attribute10, hr_api.g_varchar2) or
930: nvl(per_ceo_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
931: nvl(p_rec.attribute11, hr_api.g_varchar2) or
932: nvl(per_ceo_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
933: nvl(p_rec.attribute12, hr_api.g_varchar2) or
934: nvl(per_ceo_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
935: nvl(p_rec.attribute13, hr_api.g_varchar2) or
936: nvl(per_ceo_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

Line 934: nvl(per_ceo_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

930: nvl(per_ceo_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
931: nvl(p_rec.attribute11, hr_api.g_varchar2) or
932: nvl(per_ceo_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
933: nvl(p_rec.attribute12, hr_api.g_varchar2) or
934: nvl(per_ceo_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
935: nvl(p_rec.attribute13, hr_api.g_varchar2) or
936: nvl(per_ceo_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
937: nvl(p_rec.attribute14, hr_api.g_varchar2) or
938: nvl(per_ceo_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

Line 936: nvl(per_ceo_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

932: nvl(per_ceo_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
933: nvl(p_rec.attribute12, hr_api.g_varchar2) or
934: nvl(per_ceo_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
935: nvl(p_rec.attribute13, hr_api.g_varchar2) or
936: nvl(per_ceo_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
937: nvl(p_rec.attribute14, hr_api.g_varchar2) or
938: nvl(per_ceo_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
939: nvl(p_rec.attribute15, hr_api.g_varchar2) or
940: nvl(per_ceo_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

Line 938: nvl(per_ceo_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

934: nvl(per_ceo_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
935: nvl(p_rec.attribute13, hr_api.g_varchar2) or
936: nvl(per_ceo_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
937: nvl(p_rec.attribute14, hr_api.g_varchar2) or
938: nvl(per_ceo_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
939: nvl(p_rec.attribute15, hr_api.g_varchar2) or
940: nvl(per_ceo_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
941: nvl(p_rec.attribute16, hr_api.g_varchar2) or
942: nvl(per_ceo_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

Line 940: nvl(per_ceo_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

936: nvl(per_ceo_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
937: nvl(p_rec.attribute14, hr_api.g_varchar2) or
938: nvl(per_ceo_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
939: nvl(p_rec.attribute15, hr_api.g_varchar2) or
940: nvl(per_ceo_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
941: nvl(p_rec.attribute16, hr_api.g_varchar2) or
942: nvl(per_ceo_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
943: nvl(p_rec.attribute17, hr_api.g_varchar2) or
944: nvl(per_ceo_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

Line 942: nvl(per_ceo_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

938: nvl(per_ceo_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
939: nvl(p_rec.attribute15, hr_api.g_varchar2) or
940: nvl(per_ceo_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
941: nvl(p_rec.attribute16, hr_api.g_varchar2) or
942: nvl(per_ceo_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
943: nvl(p_rec.attribute17, hr_api.g_varchar2) or
944: nvl(per_ceo_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
945: nvl(p_rec.attribute18, hr_api.g_varchar2) or
946: nvl(per_ceo_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

Line 944: nvl(per_ceo_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

940: nvl(per_ceo_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
941: nvl(p_rec.attribute16, hr_api.g_varchar2) or
942: nvl(per_ceo_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
943: nvl(p_rec.attribute17, hr_api.g_varchar2) or
944: nvl(per_ceo_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
945: nvl(p_rec.attribute18, hr_api.g_varchar2) or
946: nvl(per_ceo_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
947: nvl(p_rec.attribute19, hr_api.g_varchar2) or
948: nvl(per_ceo_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

Line 946: nvl(per_ceo_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

942: nvl(per_ceo_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
943: nvl(p_rec.attribute17, hr_api.g_varchar2) or
944: nvl(per_ceo_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
945: nvl(p_rec.attribute18, hr_api.g_varchar2) or
946: nvl(per_ceo_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
947: nvl(p_rec.attribute19, hr_api.g_varchar2) or
948: nvl(per_ceo_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
949: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
950: or (p_rec.comp_element_outcome_id is null) then

Line 948: nvl(per_ceo_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

944: nvl(per_ceo_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
945: nvl(p_rec.attribute18, hr_api.g_varchar2) or
946: nvl(per_ceo_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
947: nvl(p_rec.attribute19, hr_api.g_varchar2) or
948: nvl(per_ceo_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
949: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
950: or (p_rec.comp_element_outcome_id is null) then
951: --
952: -- Only execute the validation if absolutely necessary:

Line 1013: ,p_rec in per_ceo_shd.g_rec_type

1009: -- |---------------------------< insert_validate >----------------------------|
1010: -- ----------------------------------------------------------------------------
1011: Procedure insert_validate
1012: (p_effective_date in date
1013: ,p_rec in per_ceo_shd.g_rec_type
1014: ) is
1015: --
1016: l_proc varchar2(72) := g_package||'insert_validate';
1017: --

Line 1091: ,p_rec in per_ceo_shd.g_rec_type

1087: -- |---------------------------< update_validate >----------------------------|
1088: -- ----------------------------------------------------------------------------
1089: Procedure update_validate
1090: (p_effective_date in date
1091: ,p_rec in per_ceo_shd.g_rec_type
1092: ) is
1093: --
1094: l_proc varchar2(72) := g_package||'update_validate';
1095: --

Line 1173: (p_rec in per_ceo_shd.g_rec_type

1169: -- ----------------------------------------------------------------------------
1170: -- |---------------------------< delete_validate >----------------------------|
1171: -- ----------------------------------------------------------------------------
1172: Procedure delete_validate
1173: (p_rec in per_ceo_shd.g_rec_type
1174: ) is
1175: --
1176: l_proc varchar2(72) := g_package||'delete_validate';
1177: --