APPS.PER_ROL_BUS dependencies on PER_ROL_SHD

Line 546: (p_rec in per_rol_shd.g_rec_type

542: -- Internal Row Handler Use Only.
543: --
544: -- ----------------------------------------------------------------------------
545: procedure chk_ddf
546: (p_rec in per_rol_shd.g_rec_type
547: ) is
548: --
549: l_proc varchar2(72) := g_package || 'chk_ddf';
550: --

Line 555: nvl(per_rol_shd.g_old_rec.role_information_category, hr_api.g_varchar2) <>

551: begin
552: hr_utility.set_location('Entering:'||l_proc,10);
553: --
554: if ((p_rec.role_id is not null) and (
555: nvl(per_rol_shd.g_old_rec.role_information_category, hr_api.g_varchar2) <>
556: nvl(p_rec.role_information_category, hr_api.g_varchar2) or
557: nvl(per_rol_shd.g_old_rec.role_information1, hr_api.g_varchar2) <>
558: nvl(p_rec.role_information1, hr_api.g_varchar2) or
559: nvl(per_rol_shd.g_old_rec.role_information2, hr_api.g_varchar2) <>

Line 557: nvl(per_rol_shd.g_old_rec.role_information1, hr_api.g_varchar2) <>

553: --
554: if ((p_rec.role_id is not null) and (
555: nvl(per_rol_shd.g_old_rec.role_information_category, hr_api.g_varchar2) <>
556: nvl(p_rec.role_information_category, hr_api.g_varchar2) or
557: nvl(per_rol_shd.g_old_rec.role_information1, hr_api.g_varchar2) <>
558: nvl(p_rec.role_information1, hr_api.g_varchar2) or
559: nvl(per_rol_shd.g_old_rec.role_information2, hr_api.g_varchar2) <>
560: nvl(p_rec.role_information2, hr_api.g_varchar2) or
561: nvl(per_rol_shd.g_old_rec.role_information3, hr_api.g_varchar2) <>

Line 559: nvl(per_rol_shd.g_old_rec.role_information2, hr_api.g_varchar2) <>

555: nvl(per_rol_shd.g_old_rec.role_information_category, hr_api.g_varchar2) <>
556: nvl(p_rec.role_information_category, hr_api.g_varchar2) or
557: nvl(per_rol_shd.g_old_rec.role_information1, hr_api.g_varchar2) <>
558: nvl(p_rec.role_information1, hr_api.g_varchar2) or
559: nvl(per_rol_shd.g_old_rec.role_information2, hr_api.g_varchar2) <>
560: nvl(p_rec.role_information2, hr_api.g_varchar2) or
561: nvl(per_rol_shd.g_old_rec.role_information3, hr_api.g_varchar2) <>
562: nvl(p_rec.role_information3, hr_api.g_varchar2) or
563: nvl(per_rol_shd.g_old_rec.role_information4, hr_api.g_varchar2) <>

Line 561: nvl(per_rol_shd.g_old_rec.role_information3, hr_api.g_varchar2) <>

557: nvl(per_rol_shd.g_old_rec.role_information1, hr_api.g_varchar2) <>
558: nvl(p_rec.role_information1, hr_api.g_varchar2) or
559: nvl(per_rol_shd.g_old_rec.role_information2, hr_api.g_varchar2) <>
560: nvl(p_rec.role_information2, hr_api.g_varchar2) or
561: nvl(per_rol_shd.g_old_rec.role_information3, hr_api.g_varchar2) <>
562: nvl(p_rec.role_information3, hr_api.g_varchar2) or
563: nvl(per_rol_shd.g_old_rec.role_information4, hr_api.g_varchar2) <>
564: nvl(p_rec.role_information4, hr_api.g_varchar2) or
565: nvl(per_rol_shd.g_old_rec.role_information5, hr_api.g_varchar2) <>

Line 563: nvl(per_rol_shd.g_old_rec.role_information4, hr_api.g_varchar2) <>

559: nvl(per_rol_shd.g_old_rec.role_information2, hr_api.g_varchar2) <>
560: nvl(p_rec.role_information2, hr_api.g_varchar2) or
561: nvl(per_rol_shd.g_old_rec.role_information3, hr_api.g_varchar2) <>
562: nvl(p_rec.role_information3, hr_api.g_varchar2) or
563: nvl(per_rol_shd.g_old_rec.role_information4, hr_api.g_varchar2) <>
564: nvl(p_rec.role_information4, hr_api.g_varchar2) or
565: nvl(per_rol_shd.g_old_rec.role_information5, hr_api.g_varchar2) <>
566: nvl(p_rec.role_information5, hr_api.g_varchar2) or
567: nvl(per_rol_shd.g_old_rec.role_information6, hr_api.g_varchar2) <>

Line 565: nvl(per_rol_shd.g_old_rec.role_information5, hr_api.g_varchar2) <>

561: nvl(per_rol_shd.g_old_rec.role_information3, hr_api.g_varchar2) <>
562: nvl(p_rec.role_information3, hr_api.g_varchar2) or
563: nvl(per_rol_shd.g_old_rec.role_information4, hr_api.g_varchar2) <>
564: nvl(p_rec.role_information4, hr_api.g_varchar2) or
565: nvl(per_rol_shd.g_old_rec.role_information5, hr_api.g_varchar2) <>
566: nvl(p_rec.role_information5, hr_api.g_varchar2) or
567: nvl(per_rol_shd.g_old_rec.role_information6, hr_api.g_varchar2) <>
568: nvl(p_rec.role_information6, hr_api.g_varchar2) or
569: nvl(per_rol_shd.g_old_rec.role_information7, hr_api.g_varchar2) <>

Line 567: nvl(per_rol_shd.g_old_rec.role_information6, hr_api.g_varchar2) <>

563: nvl(per_rol_shd.g_old_rec.role_information4, hr_api.g_varchar2) <>
564: nvl(p_rec.role_information4, hr_api.g_varchar2) or
565: nvl(per_rol_shd.g_old_rec.role_information5, hr_api.g_varchar2) <>
566: nvl(p_rec.role_information5, hr_api.g_varchar2) or
567: nvl(per_rol_shd.g_old_rec.role_information6, hr_api.g_varchar2) <>
568: nvl(p_rec.role_information6, hr_api.g_varchar2) or
569: nvl(per_rol_shd.g_old_rec.role_information7, hr_api.g_varchar2) <>
570: nvl(p_rec.role_information7, hr_api.g_varchar2) or
571: nvl(per_rol_shd.g_old_rec.role_information8, hr_api.g_varchar2) <>

Line 569: nvl(per_rol_shd.g_old_rec.role_information7, hr_api.g_varchar2) <>

565: nvl(per_rol_shd.g_old_rec.role_information5, hr_api.g_varchar2) <>
566: nvl(p_rec.role_information5, hr_api.g_varchar2) or
567: nvl(per_rol_shd.g_old_rec.role_information6, hr_api.g_varchar2) <>
568: nvl(p_rec.role_information6, hr_api.g_varchar2) or
569: nvl(per_rol_shd.g_old_rec.role_information7, hr_api.g_varchar2) <>
570: nvl(p_rec.role_information7, hr_api.g_varchar2) or
571: nvl(per_rol_shd.g_old_rec.role_information8, hr_api.g_varchar2) <>
572: nvl(p_rec.role_information8, hr_api.g_varchar2) or
573: nvl(per_rol_shd.g_old_rec.role_information9, hr_api.g_varchar2) <>

Line 571: nvl(per_rol_shd.g_old_rec.role_information8, hr_api.g_varchar2) <>

567: nvl(per_rol_shd.g_old_rec.role_information6, hr_api.g_varchar2) <>
568: nvl(p_rec.role_information6, hr_api.g_varchar2) or
569: nvl(per_rol_shd.g_old_rec.role_information7, hr_api.g_varchar2) <>
570: nvl(p_rec.role_information7, hr_api.g_varchar2) or
571: nvl(per_rol_shd.g_old_rec.role_information8, hr_api.g_varchar2) <>
572: nvl(p_rec.role_information8, hr_api.g_varchar2) or
573: nvl(per_rol_shd.g_old_rec.role_information9, hr_api.g_varchar2) <>
574: nvl(p_rec.role_information9, hr_api.g_varchar2) or
575: nvl(per_rol_shd.g_old_rec.role_information10, hr_api.g_varchar2) <>

Line 573: nvl(per_rol_shd.g_old_rec.role_information9, hr_api.g_varchar2) <>

569: nvl(per_rol_shd.g_old_rec.role_information7, hr_api.g_varchar2) <>
570: nvl(p_rec.role_information7, hr_api.g_varchar2) or
571: nvl(per_rol_shd.g_old_rec.role_information8, hr_api.g_varchar2) <>
572: nvl(p_rec.role_information8, hr_api.g_varchar2) or
573: nvl(per_rol_shd.g_old_rec.role_information9, hr_api.g_varchar2) <>
574: nvl(p_rec.role_information9, hr_api.g_varchar2) or
575: nvl(per_rol_shd.g_old_rec.role_information10, hr_api.g_varchar2) <>
576: nvl(p_rec.role_information10, hr_api.g_varchar2) or
577: nvl(per_rol_shd.g_old_rec.role_information11, hr_api.g_varchar2) <>

Line 575: nvl(per_rol_shd.g_old_rec.role_information10, hr_api.g_varchar2) <>

571: nvl(per_rol_shd.g_old_rec.role_information8, hr_api.g_varchar2) <>
572: nvl(p_rec.role_information8, hr_api.g_varchar2) or
573: nvl(per_rol_shd.g_old_rec.role_information9, hr_api.g_varchar2) <>
574: nvl(p_rec.role_information9, hr_api.g_varchar2) or
575: nvl(per_rol_shd.g_old_rec.role_information10, hr_api.g_varchar2) <>
576: nvl(p_rec.role_information10, hr_api.g_varchar2) or
577: nvl(per_rol_shd.g_old_rec.role_information11, hr_api.g_varchar2) <>
578: nvl(p_rec.role_information11, hr_api.g_varchar2) or
579: nvl(per_rol_shd.g_old_rec.role_information12, hr_api.g_varchar2) <>

Line 577: nvl(per_rol_shd.g_old_rec.role_information11, hr_api.g_varchar2) <>

573: nvl(per_rol_shd.g_old_rec.role_information9, hr_api.g_varchar2) <>
574: nvl(p_rec.role_information9, hr_api.g_varchar2) or
575: nvl(per_rol_shd.g_old_rec.role_information10, hr_api.g_varchar2) <>
576: nvl(p_rec.role_information10, hr_api.g_varchar2) or
577: nvl(per_rol_shd.g_old_rec.role_information11, hr_api.g_varchar2) <>
578: nvl(p_rec.role_information11, hr_api.g_varchar2) or
579: nvl(per_rol_shd.g_old_rec.role_information12, hr_api.g_varchar2) <>
580: nvl(p_rec.role_information12, hr_api.g_varchar2) or
581: nvl(per_rol_shd.g_old_rec.role_information13, hr_api.g_varchar2) <>

Line 579: nvl(per_rol_shd.g_old_rec.role_information12, hr_api.g_varchar2) <>

575: nvl(per_rol_shd.g_old_rec.role_information10, hr_api.g_varchar2) <>
576: nvl(p_rec.role_information10, hr_api.g_varchar2) or
577: nvl(per_rol_shd.g_old_rec.role_information11, hr_api.g_varchar2) <>
578: nvl(p_rec.role_information11, hr_api.g_varchar2) or
579: nvl(per_rol_shd.g_old_rec.role_information12, hr_api.g_varchar2) <>
580: nvl(p_rec.role_information12, hr_api.g_varchar2) or
581: nvl(per_rol_shd.g_old_rec.role_information13, hr_api.g_varchar2) <>
582: nvl(p_rec.role_information13, hr_api.g_varchar2) or
583: nvl(per_rol_shd.g_old_rec.role_information14, hr_api.g_varchar2) <>

Line 581: nvl(per_rol_shd.g_old_rec.role_information13, hr_api.g_varchar2) <>

577: nvl(per_rol_shd.g_old_rec.role_information11, hr_api.g_varchar2) <>
578: nvl(p_rec.role_information11, hr_api.g_varchar2) or
579: nvl(per_rol_shd.g_old_rec.role_information12, hr_api.g_varchar2) <>
580: nvl(p_rec.role_information12, hr_api.g_varchar2) or
581: nvl(per_rol_shd.g_old_rec.role_information13, hr_api.g_varchar2) <>
582: nvl(p_rec.role_information13, hr_api.g_varchar2) or
583: nvl(per_rol_shd.g_old_rec.role_information14, hr_api.g_varchar2) <>
584: nvl(p_rec.role_information14, hr_api.g_varchar2) or
585: nvl(per_rol_shd.g_old_rec.role_information15, hr_api.g_varchar2) <>

Line 583: nvl(per_rol_shd.g_old_rec.role_information14, hr_api.g_varchar2) <>

579: nvl(per_rol_shd.g_old_rec.role_information12, hr_api.g_varchar2) <>
580: nvl(p_rec.role_information12, hr_api.g_varchar2) or
581: nvl(per_rol_shd.g_old_rec.role_information13, hr_api.g_varchar2) <>
582: nvl(p_rec.role_information13, hr_api.g_varchar2) or
583: nvl(per_rol_shd.g_old_rec.role_information14, hr_api.g_varchar2) <>
584: nvl(p_rec.role_information14, hr_api.g_varchar2) or
585: nvl(per_rol_shd.g_old_rec.role_information15, hr_api.g_varchar2) <>
586: nvl(p_rec.role_information15, hr_api.g_varchar2) or
587: nvl(per_rol_shd.g_old_rec.role_information16, hr_api.g_varchar2) <>

Line 585: nvl(per_rol_shd.g_old_rec.role_information15, hr_api.g_varchar2) <>

581: nvl(per_rol_shd.g_old_rec.role_information13, hr_api.g_varchar2) <>
582: nvl(p_rec.role_information13, hr_api.g_varchar2) or
583: nvl(per_rol_shd.g_old_rec.role_information14, hr_api.g_varchar2) <>
584: nvl(p_rec.role_information14, hr_api.g_varchar2) or
585: nvl(per_rol_shd.g_old_rec.role_information15, hr_api.g_varchar2) <>
586: nvl(p_rec.role_information15, hr_api.g_varchar2) or
587: nvl(per_rol_shd.g_old_rec.role_information16, hr_api.g_varchar2) <>
588: nvl(p_rec.role_information16, hr_api.g_varchar2) or
589: nvl(per_rol_shd.g_old_rec.role_information17, hr_api.g_varchar2) <>

Line 587: nvl(per_rol_shd.g_old_rec.role_information16, hr_api.g_varchar2) <>

583: nvl(per_rol_shd.g_old_rec.role_information14, hr_api.g_varchar2) <>
584: nvl(p_rec.role_information14, hr_api.g_varchar2) or
585: nvl(per_rol_shd.g_old_rec.role_information15, hr_api.g_varchar2) <>
586: nvl(p_rec.role_information15, hr_api.g_varchar2) or
587: nvl(per_rol_shd.g_old_rec.role_information16, hr_api.g_varchar2) <>
588: nvl(p_rec.role_information16, hr_api.g_varchar2) or
589: nvl(per_rol_shd.g_old_rec.role_information17, hr_api.g_varchar2) <>
590: nvl(p_rec.role_information17, hr_api.g_varchar2) or
591: nvl(per_rol_shd.g_old_rec.role_information18, hr_api.g_varchar2) <>

Line 589: nvl(per_rol_shd.g_old_rec.role_information17, hr_api.g_varchar2) <>

585: nvl(per_rol_shd.g_old_rec.role_information15, hr_api.g_varchar2) <>
586: nvl(p_rec.role_information15, hr_api.g_varchar2) or
587: nvl(per_rol_shd.g_old_rec.role_information16, hr_api.g_varchar2) <>
588: nvl(p_rec.role_information16, hr_api.g_varchar2) or
589: nvl(per_rol_shd.g_old_rec.role_information17, hr_api.g_varchar2) <>
590: nvl(p_rec.role_information17, hr_api.g_varchar2) or
591: nvl(per_rol_shd.g_old_rec.role_information18, hr_api.g_varchar2) <>
592: nvl(p_rec.role_information18, hr_api.g_varchar2) or
593: nvl(per_rol_shd.g_old_rec.role_information19, hr_api.g_varchar2) <>

Line 591: nvl(per_rol_shd.g_old_rec.role_information18, hr_api.g_varchar2) <>

587: nvl(per_rol_shd.g_old_rec.role_information16, hr_api.g_varchar2) <>
588: nvl(p_rec.role_information16, hr_api.g_varchar2) or
589: nvl(per_rol_shd.g_old_rec.role_information17, hr_api.g_varchar2) <>
590: nvl(p_rec.role_information17, hr_api.g_varchar2) or
591: nvl(per_rol_shd.g_old_rec.role_information18, hr_api.g_varchar2) <>
592: nvl(p_rec.role_information18, hr_api.g_varchar2) or
593: nvl(per_rol_shd.g_old_rec.role_information19, hr_api.g_varchar2) <>
594: nvl(p_rec.role_information19, hr_api.g_varchar2) or
595: nvl(per_rol_shd.g_old_rec.role_information20, hr_api.g_varchar2) <>

Line 593: nvl(per_rol_shd.g_old_rec.role_information19, hr_api.g_varchar2) <>

589: nvl(per_rol_shd.g_old_rec.role_information17, hr_api.g_varchar2) <>
590: nvl(p_rec.role_information17, hr_api.g_varchar2) or
591: nvl(per_rol_shd.g_old_rec.role_information18, hr_api.g_varchar2) <>
592: nvl(p_rec.role_information18, hr_api.g_varchar2) or
593: nvl(per_rol_shd.g_old_rec.role_information19, hr_api.g_varchar2) <>
594: nvl(p_rec.role_information19, hr_api.g_varchar2) or
595: nvl(per_rol_shd.g_old_rec.role_information20, hr_api.g_varchar2) <>
596: nvl(p_rec.role_information20, hr_api.g_varchar2) ))
597: or (p_rec.role_id is null) then

Line 595: nvl(per_rol_shd.g_old_rec.role_information20, hr_api.g_varchar2) <>

591: nvl(per_rol_shd.g_old_rec.role_information18, hr_api.g_varchar2) <>
592: nvl(p_rec.role_information18, hr_api.g_varchar2) or
593: nvl(per_rol_shd.g_old_rec.role_information19, hr_api.g_varchar2) <>
594: nvl(p_rec.role_information19, hr_api.g_varchar2) or
595: nvl(per_rol_shd.g_old_rec.role_information20, hr_api.g_varchar2) <>
596: nvl(p_rec.role_information20, hr_api.g_varchar2) ))
597: or (p_rec.role_id is null) then
598: --
599: -- Only execute the validation if absolutely necessary:

Line 683: (p_rec in per_rol_shd.g_rec_type

679: -- Internal Row Handler Use Only.
680: --
681: -- ----------------------------------------------------------------------------
682: procedure chk_df
683: (p_rec in per_rol_shd.g_rec_type
684: ) is
685: --
686: l_proc varchar2(72) := g_package || 'chk_df';
687: --

Line 692: nvl(per_rol_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

688: begin
689: hr_utility.set_location('Entering:'||l_proc,10);
690: --
691: if ((p_rec.role_id is not null) and (
692: nvl(per_rol_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
693: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
694: nvl(per_rol_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
695: nvl(p_rec.attribute1, hr_api.g_varchar2) or
696: nvl(per_rol_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

Line 694: nvl(per_rol_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

690: --
691: if ((p_rec.role_id is not null) and (
692: nvl(per_rol_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
693: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
694: nvl(per_rol_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
695: nvl(p_rec.attribute1, hr_api.g_varchar2) or
696: nvl(per_rol_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
697: nvl(p_rec.attribute2, hr_api.g_varchar2) or
698: nvl(per_rol_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

Line 696: nvl(per_rol_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

692: nvl(per_rol_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
693: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
694: nvl(per_rol_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
695: nvl(p_rec.attribute1, hr_api.g_varchar2) or
696: nvl(per_rol_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
697: nvl(p_rec.attribute2, hr_api.g_varchar2) or
698: nvl(per_rol_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
699: nvl(p_rec.attribute3, hr_api.g_varchar2) or
700: nvl(per_rol_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

Line 698: nvl(per_rol_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

694: nvl(per_rol_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
695: nvl(p_rec.attribute1, hr_api.g_varchar2) or
696: nvl(per_rol_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
697: nvl(p_rec.attribute2, hr_api.g_varchar2) or
698: nvl(per_rol_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
699: nvl(p_rec.attribute3, hr_api.g_varchar2) or
700: nvl(per_rol_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
701: nvl(p_rec.attribute4, hr_api.g_varchar2) or
702: nvl(per_rol_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

Line 700: nvl(per_rol_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

696: nvl(per_rol_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
697: nvl(p_rec.attribute2, hr_api.g_varchar2) or
698: nvl(per_rol_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
699: nvl(p_rec.attribute3, hr_api.g_varchar2) or
700: nvl(per_rol_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
701: nvl(p_rec.attribute4, hr_api.g_varchar2) or
702: nvl(per_rol_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
703: nvl(p_rec.attribute5, hr_api.g_varchar2) or
704: nvl(per_rol_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

Line 702: nvl(per_rol_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

698: nvl(per_rol_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
699: nvl(p_rec.attribute3, hr_api.g_varchar2) or
700: nvl(per_rol_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
701: nvl(p_rec.attribute4, hr_api.g_varchar2) or
702: nvl(per_rol_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
703: nvl(p_rec.attribute5, hr_api.g_varchar2) or
704: nvl(per_rol_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
705: nvl(p_rec.attribute6, hr_api.g_varchar2) or
706: nvl(per_rol_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

Line 704: nvl(per_rol_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

700: nvl(per_rol_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
701: nvl(p_rec.attribute4, hr_api.g_varchar2) or
702: nvl(per_rol_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
703: nvl(p_rec.attribute5, hr_api.g_varchar2) or
704: nvl(per_rol_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
705: nvl(p_rec.attribute6, hr_api.g_varchar2) or
706: nvl(per_rol_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
707: nvl(p_rec.attribute7, hr_api.g_varchar2) or
708: nvl(per_rol_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

Line 706: nvl(per_rol_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

702: nvl(per_rol_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
703: nvl(p_rec.attribute5, hr_api.g_varchar2) or
704: nvl(per_rol_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
705: nvl(p_rec.attribute6, hr_api.g_varchar2) or
706: nvl(per_rol_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
707: nvl(p_rec.attribute7, hr_api.g_varchar2) or
708: nvl(per_rol_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
709: nvl(p_rec.attribute8, hr_api.g_varchar2) or
710: nvl(per_rol_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

Line 708: nvl(per_rol_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

704: nvl(per_rol_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
705: nvl(p_rec.attribute6, hr_api.g_varchar2) or
706: nvl(per_rol_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
707: nvl(p_rec.attribute7, hr_api.g_varchar2) or
708: nvl(per_rol_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
709: nvl(p_rec.attribute8, hr_api.g_varchar2) or
710: nvl(per_rol_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
711: nvl(p_rec.attribute9, hr_api.g_varchar2) or
712: nvl(per_rol_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

Line 710: nvl(per_rol_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

706: nvl(per_rol_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
707: nvl(p_rec.attribute7, hr_api.g_varchar2) or
708: nvl(per_rol_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
709: nvl(p_rec.attribute8, hr_api.g_varchar2) or
710: nvl(per_rol_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
711: nvl(p_rec.attribute9, hr_api.g_varchar2) or
712: nvl(per_rol_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
713: nvl(p_rec.attribute10, hr_api.g_varchar2) or
714: nvl(per_rol_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

Line 712: nvl(per_rol_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

708: nvl(per_rol_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
709: nvl(p_rec.attribute8, hr_api.g_varchar2) or
710: nvl(per_rol_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
711: nvl(p_rec.attribute9, hr_api.g_varchar2) or
712: nvl(per_rol_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
713: nvl(p_rec.attribute10, hr_api.g_varchar2) or
714: nvl(per_rol_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
715: nvl(p_rec.attribute11, hr_api.g_varchar2) or
716: nvl(per_rol_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

Line 714: nvl(per_rol_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

710: nvl(per_rol_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
711: nvl(p_rec.attribute9, hr_api.g_varchar2) or
712: nvl(per_rol_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
713: nvl(p_rec.attribute10, hr_api.g_varchar2) or
714: nvl(per_rol_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
715: nvl(p_rec.attribute11, hr_api.g_varchar2) or
716: nvl(per_rol_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
717: nvl(p_rec.attribute12, hr_api.g_varchar2) or
718: nvl(per_rol_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

Line 716: nvl(per_rol_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

712: nvl(per_rol_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
713: nvl(p_rec.attribute10, hr_api.g_varchar2) or
714: nvl(per_rol_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
715: nvl(p_rec.attribute11, hr_api.g_varchar2) or
716: nvl(per_rol_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
717: nvl(p_rec.attribute12, hr_api.g_varchar2) or
718: nvl(per_rol_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
719: nvl(p_rec.attribute13, hr_api.g_varchar2) or
720: nvl(per_rol_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

Line 718: nvl(per_rol_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

714: nvl(per_rol_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
715: nvl(p_rec.attribute11, hr_api.g_varchar2) or
716: nvl(per_rol_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
717: nvl(p_rec.attribute12, hr_api.g_varchar2) or
718: nvl(per_rol_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
719: nvl(p_rec.attribute13, hr_api.g_varchar2) or
720: nvl(per_rol_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
721: nvl(p_rec.attribute14, hr_api.g_varchar2) or
722: nvl(per_rol_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

Line 720: nvl(per_rol_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

716: nvl(per_rol_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
717: nvl(p_rec.attribute12, hr_api.g_varchar2) or
718: nvl(per_rol_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
719: nvl(p_rec.attribute13, hr_api.g_varchar2) or
720: nvl(per_rol_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
721: nvl(p_rec.attribute14, hr_api.g_varchar2) or
722: nvl(per_rol_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
723: nvl(p_rec.attribute15, hr_api.g_varchar2) or
724: nvl(per_rol_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

Line 722: nvl(per_rol_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

718: nvl(per_rol_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
719: nvl(p_rec.attribute13, hr_api.g_varchar2) or
720: nvl(per_rol_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
721: nvl(p_rec.attribute14, hr_api.g_varchar2) or
722: nvl(per_rol_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
723: nvl(p_rec.attribute15, hr_api.g_varchar2) or
724: nvl(per_rol_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
725: nvl(p_rec.attribute16, hr_api.g_varchar2) or
726: nvl(per_rol_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

Line 724: nvl(per_rol_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

720: nvl(per_rol_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
721: nvl(p_rec.attribute14, hr_api.g_varchar2) or
722: nvl(per_rol_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
723: nvl(p_rec.attribute15, hr_api.g_varchar2) or
724: nvl(per_rol_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
725: nvl(p_rec.attribute16, hr_api.g_varchar2) or
726: nvl(per_rol_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
727: nvl(p_rec.attribute17, hr_api.g_varchar2) or
728: nvl(per_rol_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

Line 726: nvl(per_rol_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

722: nvl(per_rol_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
723: nvl(p_rec.attribute15, hr_api.g_varchar2) or
724: nvl(per_rol_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
725: nvl(p_rec.attribute16, hr_api.g_varchar2) or
726: nvl(per_rol_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
727: nvl(p_rec.attribute17, hr_api.g_varchar2) or
728: nvl(per_rol_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
729: nvl(p_rec.attribute18, hr_api.g_varchar2) or
730: nvl(per_rol_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

Line 728: nvl(per_rol_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

724: nvl(per_rol_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
725: nvl(p_rec.attribute16, hr_api.g_varchar2) or
726: nvl(per_rol_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
727: nvl(p_rec.attribute17, hr_api.g_varchar2) or
728: nvl(per_rol_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
729: nvl(p_rec.attribute18, hr_api.g_varchar2) or
730: nvl(per_rol_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
731: nvl(p_rec.attribute19, hr_api.g_varchar2) or
732: nvl(per_rol_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

Line 730: nvl(per_rol_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

726: nvl(per_rol_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
727: nvl(p_rec.attribute17, hr_api.g_varchar2) or
728: nvl(per_rol_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
729: nvl(p_rec.attribute18, hr_api.g_varchar2) or
730: nvl(per_rol_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
731: nvl(p_rec.attribute19, hr_api.g_varchar2) or
732: nvl(per_rol_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
733: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
734: or (p_rec.role_id is null) then

Line 732: nvl(per_rol_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

728: nvl(per_rol_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
729: nvl(p_rec.attribute18, hr_api.g_varchar2) or
730: nvl(per_rol_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
731: nvl(p_rec.attribute19, hr_api.g_varchar2) or
732: nvl(per_rol_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
733: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
734: or (p_rec.role_id is null) then
735: --
736: -- Only execute the validation if absolutely necessary:

Line 820: ,p_rec in per_rol_shd.g_rec_type

816: -- {End Of Comments}
817: -- ----------------------------------------------------------------------------
818: Procedure chk_non_updateable_args
819: (p_effective_date in date
820: ,p_rec in per_rol_shd.g_rec_type
821: ) IS
822: --
823: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
824: l_error EXCEPTION;

Line 832: IF NOT per_rol_shd.api_updating

828: --
829: -- Only proceed with the validation if a row exists for the current
830: -- record in the HR Schema.
831: --
832: IF NOT per_rol_shd.api_updating
833: (p_role_id => p_rec.role_id
834: ,p_object_version_number => p_rec.object_version_number
835: ) THEN
836: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 843: nvl(per_rol_shd.g_old_rec.person_id, hr_api.g_number) then

839: fnd_message.raise_error;
840: END IF;
841: --
842: IF nvl(p_rec.person_id, hr_api.g_number) <>
843: nvl(per_rol_shd.g_old_rec.person_id, hr_api.g_number) then
844: l_argument := 'person_id';
845: raise l_error;
846: END IF;
847: --

Line 862: ,p_rec in per_rol_shd.g_rec_type

858: -- |---------------------------< insert_validate >----------------------------|
859: -- ----------------------------------------------------------------------------
860: Procedure insert_validate
861: (p_effective_date in date
862: ,p_rec in per_rol_shd.g_rec_type
863: ) is
864: --
865: l_proc varchar2(72) := g_package||'insert_validate';
866: --

Line 908: ,p_rec in per_rol_shd.g_rec_type

904: -- |---------------------------< update_validate >----------------------------|
905: -- ----------------------------------------------------------------------------
906: Procedure update_validate
907: (p_effective_date in date
908: ,p_rec in per_rol_shd.g_rec_type
909: ) is
910: --
911: l_proc varchar2(72) := g_package||'update_validate';
912: --

Line 958: (p_rec in per_rol_shd.g_rec_type

954: -- ----------------------------------------------------------------------------
955: -- |---------------------------< delete_validate >----------------------------|
956: -- ----------------------------------------------------------------------------
957: Procedure delete_validate
958: (p_rec in per_rol_shd.g_rec_type
959: ) is
960: --
961: l_proc varchar2(72) := g_package||'delete_validate';
962: --