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_ECA_BUS dependencies on PER_ECA_SHD

Line 176: (p_rec in per_eca_shd.g_rec_type

172: --
173: -- {End Of Comments}
174: -- ----------------------------------------------------------------------------
175: Procedure chk_non_updateable_args
176: (p_rec in per_eca_shd.g_rec_type
177: ) IS
178: --
179: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
180: l_error EXCEPTION;

Line 188: IF NOT per_eca_shd.api_updating

184: --
185: -- Only proceed with the validation if a row exists for the current
186: -- record in the HR Schema.
187: --
188: IF NOT per_eca_shd.api_updating
189: (p_election_candidate_id => p_rec.election_candidate_id
190: ,p_object_version_number => p_rec.object_version_number
191: ) THEN
192: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 284: (p_rec in per_eca_shd.g_rec_type

280: -- ----------------------------------------------------------------------------
281: -- |---------------------------< delete_validate >----------------------------|
282: -- ----------------------------------------------------------------------------
283: Procedure delete_validate
284: (p_rec in per_eca_shd.g_rec_type
285: ) is
286: --
287: l_proc varchar2(72) := g_package||'delete_validate';
288: --

Line 618: (p_rec in per_eca_shd.g_rec_type

614: -- Internal Row Handler Use Only.
615: --
616: -- ----------------------------------------------------------------------------
617: procedure chk_df
618: (p_rec in per_eca_shd.g_rec_type
619: ) is
620: --
621: l_proc varchar2(72) := g_package || 'chk_df';
622: --

Line 627: nvl(per_eca_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

623: begin
624: hr_utility.set_location('Entering:'||l_proc,10);
625: --
626: if ((p_rec.election_candidate_id is not null) and (
627: nvl(per_eca_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
628: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
629: nvl(per_eca_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
630: nvl(p_rec.attribute1, hr_api.g_varchar2) or
631: nvl(per_eca_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

Line 629: nvl(per_eca_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

625: --
626: if ((p_rec.election_candidate_id is not null) and (
627: nvl(per_eca_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
628: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
629: nvl(per_eca_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
630: nvl(p_rec.attribute1, hr_api.g_varchar2) or
631: nvl(per_eca_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
632: nvl(p_rec.attribute2, hr_api.g_varchar2) or
633: nvl(per_eca_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

Line 631: nvl(per_eca_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

627: nvl(per_eca_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
628: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
629: nvl(per_eca_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
630: nvl(p_rec.attribute1, hr_api.g_varchar2) or
631: nvl(per_eca_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
632: nvl(p_rec.attribute2, hr_api.g_varchar2) or
633: nvl(per_eca_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
634: nvl(p_rec.attribute3, hr_api.g_varchar2) or
635: nvl(per_eca_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

Line 633: nvl(per_eca_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

629: nvl(per_eca_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
630: nvl(p_rec.attribute1, hr_api.g_varchar2) or
631: nvl(per_eca_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
632: nvl(p_rec.attribute2, hr_api.g_varchar2) or
633: nvl(per_eca_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
634: nvl(p_rec.attribute3, hr_api.g_varchar2) or
635: nvl(per_eca_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
636: nvl(p_rec.attribute4, hr_api.g_varchar2) or
637: nvl(per_eca_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

Line 635: nvl(per_eca_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

631: nvl(per_eca_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
632: nvl(p_rec.attribute2, hr_api.g_varchar2) or
633: nvl(per_eca_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
634: nvl(p_rec.attribute3, hr_api.g_varchar2) or
635: nvl(per_eca_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
636: nvl(p_rec.attribute4, hr_api.g_varchar2) or
637: nvl(per_eca_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
638: nvl(p_rec.attribute5, hr_api.g_varchar2) or
639: nvl(per_eca_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

Line 637: nvl(per_eca_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

633: nvl(per_eca_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
634: nvl(p_rec.attribute3, hr_api.g_varchar2) or
635: nvl(per_eca_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
636: nvl(p_rec.attribute4, hr_api.g_varchar2) or
637: nvl(per_eca_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
638: nvl(p_rec.attribute5, hr_api.g_varchar2) or
639: nvl(per_eca_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
640: nvl(p_rec.attribute6, hr_api.g_varchar2) or
641: nvl(per_eca_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

Line 639: nvl(per_eca_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

635: nvl(per_eca_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
636: nvl(p_rec.attribute4, hr_api.g_varchar2) or
637: nvl(per_eca_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
638: nvl(p_rec.attribute5, hr_api.g_varchar2) or
639: nvl(per_eca_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
640: nvl(p_rec.attribute6, hr_api.g_varchar2) or
641: nvl(per_eca_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
642: nvl(p_rec.attribute7, hr_api.g_varchar2) or
643: nvl(per_eca_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

Line 641: nvl(per_eca_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

637: nvl(per_eca_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
638: nvl(p_rec.attribute5, hr_api.g_varchar2) or
639: nvl(per_eca_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
640: nvl(p_rec.attribute6, hr_api.g_varchar2) or
641: nvl(per_eca_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
642: nvl(p_rec.attribute7, hr_api.g_varchar2) or
643: nvl(per_eca_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
644: nvl(p_rec.attribute8, hr_api.g_varchar2) or
645: nvl(per_eca_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

Line 643: nvl(per_eca_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

639: nvl(per_eca_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
640: nvl(p_rec.attribute6, hr_api.g_varchar2) or
641: nvl(per_eca_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
642: nvl(p_rec.attribute7, hr_api.g_varchar2) or
643: nvl(per_eca_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
644: nvl(p_rec.attribute8, hr_api.g_varchar2) or
645: nvl(per_eca_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
646: nvl(p_rec.attribute9, hr_api.g_varchar2) or
647: nvl(per_eca_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

Line 645: nvl(per_eca_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

641: nvl(per_eca_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
642: nvl(p_rec.attribute7, hr_api.g_varchar2) or
643: nvl(per_eca_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
644: nvl(p_rec.attribute8, hr_api.g_varchar2) or
645: nvl(per_eca_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
646: nvl(p_rec.attribute9, hr_api.g_varchar2) or
647: nvl(per_eca_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
648: nvl(p_rec.attribute10, hr_api.g_varchar2) or
649: nvl(per_eca_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

Line 647: nvl(per_eca_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

643: nvl(per_eca_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
644: nvl(p_rec.attribute8, hr_api.g_varchar2) or
645: nvl(per_eca_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
646: nvl(p_rec.attribute9, hr_api.g_varchar2) or
647: nvl(per_eca_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
648: nvl(p_rec.attribute10, hr_api.g_varchar2) or
649: nvl(per_eca_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
650: nvl(p_rec.attribute11, hr_api.g_varchar2) or
651: nvl(per_eca_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

Line 649: nvl(per_eca_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

645: nvl(per_eca_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
646: nvl(p_rec.attribute9, hr_api.g_varchar2) or
647: nvl(per_eca_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
648: nvl(p_rec.attribute10, hr_api.g_varchar2) or
649: nvl(per_eca_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
650: nvl(p_rec.attribute11, hr_api.g_varchar2) or
651: nvl(per_eca_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
652: nvl(p_rec.attribute12, hr_api.g_varchar2) or
653: nvl(per_eca_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

Line 651: nvl(per_eca_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

647: nvl(per_eca_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
648: nvl(p_rec.attribute10, hr_api.g_varchar2) or
649: nvl(per_eca_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
650: nvl(p_rec.attribute11, hr_api.g_varchar2) or
651: nvl(per_eca_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
652: nvl(p_rec.attribute12, hr_api.g_varchar2) or
653: nvl(per_eca_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
654: nvl(p_rec.attribute13, hr_api.g_varchar2) or
655: nvl(per_eca_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

Line 653: nvl(per_eca_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

649: nvl(per_eca_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
650: nvl(p_rec.attribute11, hr_api.g_varchar2) or
651: nvl(per_eca_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
652: nvl(p_rec.attribute12, hr_api.g_varchar2) or
653: nvl(per_eca_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
654: nvl(p_rec.attribute13, hr_api.g_varchar2) or
655: nvl(per_eca_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
656: nvl(p_rec.attribute14, hr_api.g_varchar2) or
657: nvl(per_eca_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

Line 655: nvl(per_eca_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

651: nvl(per_eca_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
652: nvl(p_rec.attribute12, hr_api.g_varchar2) or
653: nvl(per_eca_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
654: nvl(p_rec.attribute13, hr_api.g_varchar2) or
655: nvl(per_eca_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
656: nvl(p_rec.attribute14, hr_api.g_varchar2) or
657: nvl(per_eca_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
658: nvl(p_rec.attribute15, hr_api.g_varchar2) or
659: nvl(per_eca_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

Line 657: nvl(per_eca_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

653: nvl(per_eca_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
654: nvl(p_rec.attribute13, hr_api.g_varchar2) or
655: nvl(per_eca_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
656: nvl(p_rec.attribute14, hr_api.g_varchar2) or
657: nvl(per_eca_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
658: nvl(p_rec.attribute15, hr_api.g_varchar2) or
659: nvl(per_eca_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
660: nvl(p_rec.attribute16, hr_api.g_varchar2) or
661: nvl(per_eca_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

Line 659: nvl(per_eca_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

655: nvl(per_eca_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
656: nvl(p_rec.attribute14, hr_api.g_varchar2) or
657: nvl(per_eca_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
658: nvl(p_rec.attribute15, hr_api.g_varchar2) or
659: nvl(per_eca_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
660: nvl(p_rec.attribute16, hr_api.g_varchar2) or
661: nvl(per_eca_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
662: nvl(p_rec.attribute17, hr_api.g_varchar2) or
663: nvl(per_eca_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

Line 661: nvl(per_eca_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

657: nvl(per_eca_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
658: nvl(p_rec.attribute15, hr_api.g_varchar2) or
659: nvl(per_eca_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
660: nvl(p_rec.attribute16, hr_api.g_varchar2) or
661: nvl(per_eca_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
662: nvl(p_rec.attribute17, hr_api.g_varchar2) or
663: nvl(per_eca_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
664: nvl(p_rec.attribute18, hr_api.g_varchar2) or
665: nvl(per_eca_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

Line 663: nvl(per_eca_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

659: nvl(per_eca_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
660: nvl(p_rec.attribute16, hr_api.g_varchar2) or
661: nvl(per_eca_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
662: nvl(p_rec.attribute17, hr_api.g_varchar2) or
663: nvl(per_eca_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
664: nvl(p_rec.attribute18, hr_api.g_varchar2) or
665: nvl(per_eca_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
666: nvl(p_rec.attribute19, hr_api.g_varchar2) or
667: nvl(per_eca_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

Line 665: nvl(per_eca_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

661: nvl(per_eca_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
662: nvl(p_rec.attribute17, hr_api.g_varchar2) or
663: nvl(per_eca_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
664: nvl(p_rec.attribute18, hr_api.g_varchar2) or
665: nvl(per_eca_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
666: nvl(p_rec.attribute19, hr_api.g_varchar2) or
667: nvl(per_eca_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
668: nvl(p_rec.attribute20, hr_api.g_varchar2) or
669: nvl(per_eca_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>

Line 667: nvl(per_eca_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

663: nvl(per_eca_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
664: nvl(p_rec.attribute18, hr_api.g_varchar2) or
665: nvl(per_eca_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
666: nvl(p_rec.attribute19, hr_api.g_varchar2) or
667: nvl(per_eca_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
668: nvl(p_rec.attribute20, hr_api.g_varchar2) or
669: nvl(per_eca_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
670: nvl(p_rec.attribute21, hr_api.g_varchar2) or
671: nvl(per_eca_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>

Line 669: nvl(per_eca_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>

665: nvl(per_eca_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
666: nvl(p_rec.attribute19, hr_api.g_varchar2) or
667: nvl(per_eca_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
668: nvl(p_rec.attribute20, hr_api.g_varchar2) or
669: nvl(per_eca_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
670: nvl(p_rec.attribute21, hr_api.g_varchar2) or
671: nvl(per_eca_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
672: nvl(p_rec.attribute22, hr_api.g_varchar2) or
673: nvl(per_eca_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>

Line 671: nvl(per_eca_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>

667: nvl(per_eca_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
668: nvl(p_rec.attribute20, hr_api.g_varchar2) or
669: nvl(per_eca_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
670: nvl(p_rec.attribute21, hr_api.g_varchar2) or
671: nvl(per_eca_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
672: nvl(p_rec.attribute22, hr_api.g_varchar2) or
673: nvl(per_eca_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
674: nvl(p_rec.attribute23, hr_api.g_varchar2) or
675: nvl(per_eca_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>

Line 673: nvl(per_eca_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>

669: nvl(per_eca_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
670: nvl(p_rec.attribute21, hr_api.g_varchar2) or
671: nvl(per_eca_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
672: nvl(p_rec.attribute22, hr_api.g_varchar2) or
673: nvl(per_eca_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
674: nvl(p_rec.attribute23, hr_api.g_varchar2) or
675: nvl(per_eca_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
676: nvl(p_rec.attribute24, hr_api.g_varchar2) or
677: nvl(per_eca_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>

Line 675: nvl(per_eca_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>

671: nvl(per_eca_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
672: nvl(p_rec.attribute22, hr_api.g_varchar2) or
673: nvl(per_eca_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
674: nvl(p_rec.attribute23, hr_api.g_varchar2) or
675: nvl(per_eca_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
676: nvl(p_rec.attribute24, hr_api.g_varchar2) or
677: nvl(per_eca_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
678: nvl(p_rec.attribute25, hr_api.g_varchar2) or
679: nvl(per_eca_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>

Line 677: nvl(per_eca_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>

673: nvl(per_eca_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
674: nvl(p_rec.attribute23, hr_api.g_varchar2) or
675: nvl(per_eca_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
676: nvl(p_rec.attribute24, hr_api.g_varchar2) or
677: nvl(per_eca_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
678: nvl(p_rec.attribute25, hr_api.g_varchar2) or
679: nvl(per_eca_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
680: nvl(p_rec.attribute26, hr_api.g_varchar2) or
681: nvl(per_eca_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>

Line 679: nvl(per_eca_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>

675: nvl(per_eca_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
676: nvl(p_rec.attribute24, hr_api.g_varchar2) or
677: nvl(per_eca_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
678: nvl(p_rec.attribute25, hr_api.g_varchar2) or
679: nvl(per_eca_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
680: nvl(p_rec.attribute26, hr_api.g_varchar2) or
681: nvl(per_eca_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
682: nvl(p_rec.attribute27, hr_api.g_varchar2) or
683: nvl(per_eca_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>

Line 681: nvl(per_eca_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>

677: nvl(per_eca_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
678: nvl(p_rec.attribute25, hr_api.g_varchar2) or
679: nvl(per_eca_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
680: nvl(p_rec.attribute26, hr_api.g_varchar2) or
681: nvl(per_eca_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
682: nvl(p_rec.attribute27, hr_api.g_varchar2) or
683: nvl(per_eca_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
684: nvl(p_rec.attribute28, hr_api.g_varchar2) or
685: nvl(per_eca_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>

Line 683: nvl(per_eca_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>

679: nvl(per_eca_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
680: nvl(p_rec.attribute26, hr_api.g_varchar2) or
681: nvl(per_eca_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
682: nvl(p_rec.attribute27, hr_api.g_varchar2) or
683: nvl(per_eca_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
684: nvl(p_rec.attribute28, hr_api.g_varchar2) or
685: nvl(per_eca_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
686: nvl(p_rec.attribute29, hr_api.g_varchar2) or
687: nvl(per_eca_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>

Line 685: nvl(per_eca_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>

681: nvl(per_eca_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
682: nvl(p_rec.attribute27, hr_api.g_varchar2) or
683: nvl(per_eca_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
684: nvl(p_rec.attribute28, hr_api.g_varchar2) or
685: nvl(per_eca_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
686: nvl(p_rec.attribute29, hr_api.g_varchar2) or
687: nvl(per_eca_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
688: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
689: or (p_rec.election_candidate_id is null) then

Line 687: nvl(per_eca_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>

683: nvl(per_eca_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
684: nvl(p_rec.attribute28, hr_api.g_varchar2) or
685: nvl(per_eca_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
686: nvl(p_rec.attribute29, hr_api.g_varchar2) or
687: nvl(per_eca_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
688: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
689: or (p_rec.election_candidate_id is null) then
690: --
691: -- Only execute the validation if absolutely necessary:

Line 797: (p_rec in per_eca_shd.g_rec_type

793: -- Internal Row Handler Use Only.
794: --
795: -- ----------------------------------------------------------------------------
796: procedure chk_ddf
797: (p_rec in per_eca_shd.g_rec_type
798: ) is
799: --
800: l_proc varchar2(72) := g_package || 'chk_ddf';
801: --

Line 806: nvl(per_eca_shd.g_old_rec.candidate_info_category, hr_api.g_varchar2) <>

802: begin
803: hr_utility.set_location('Entering:'||l_proc,10);
804: --
805: if ((p_rec.election_candidate_id is not null) and (
806: nvl(per_eca_shd.g_old_rec.candidate_info_category, hr_api.g_varchar2) <>
807: nvl(p_rec.candidate_info_category, hr_api.g_varchar2) or
808: nvl(per_eca_shd.g_old_rec.candidate_information1, hr_api.g_varchar2) <>
809: nvl(p_rec.candidate_information1, hr_api.g_varchar2) or
810: nvl(per_eca_shd.g_old_rec.candidate_information2, hr_api.g_varchar2) <>

Line 808: nvl(per_eca_shd.g_old_rec.candidate_information1, hr_api.g_varchar2) <>

804: --
805: if ((p_rec.election_candidate_id is not null) and (
806: nvl(per_eca_shd.g_old_rec.candidate_info_category, hr_api.g_varchar2) <>
807: nvl(p_rec.candidate_info_category, hr_api.g_varchar2) or
808: nvl(per_eca_shd.g_old_rec.candidate_information1, hr_api.g_varchar2) <>
809: nvl(p_rec.candidate_information1, hr_api.g_varchar2) or
810: nvl(per_eca_shd.g_old_rec.candidate_information2, hr_api.g_varchar2) <>
811: nvl(p_rec.candidate_information2, hr_api.g_varchar2) or
812: nvl(per_eca_shd.g_old_rec.candidate_information3, hr_api.g_varchar2) <>

Line 810: nvl(per_eca_shd.g_old_rec.candidate_information2, hr_api.g_varchar2) <>

806: nvl(per_eca_shd.g_old_rec.candidate_info_category, hr_api.g_varchar2) <>
807: nvl(p_rec.candidate_info_category, hr_api.g_varchar2) or
808: nvl(per_eca_shd.g_old_rec.candidate_information1, hr_api.g_varchar2) <>
809: nvl(p_rec.candidate_information1, hr_api.g_varchar2) or
810: nvl(per_eca_shd.g_old_rec.candidate_information2, hr_api.g_varchar2) <>
811: nvl(p_rec.candidate_information2, hr_api.g_varchar2) or
812: nvl(per_eca_shd.g_old_rec.candidate_information3, hr_api.g_varchar2) <>
813: nvl(p_rec.candidate_information3, hr_api.g_varchar2) or
814: nvl(per_eca_shd.g_old_rec.candidate_information4, hr_api.g_varchar2) <>

Line 812: nvl(per_eca_shd.g_old_rec.candidate_information3, hr_api.g_varchar2) <>

808: nvl(per_eca_shd.g_old_rec.candidate_information1, hr_api.g_varchar2) <>
809: nvl(p_rec.candidate_information1, hr_api.g_varchar2) or
810: nvl(per_eca_shd.g_old_rec.candidate_information2, hr_api.g_varchar2) <>
811: nvl(p_rec.candidate_information2, hr_api.g_varchar2) or
812: nvl(per_eca_shd.g_old_rec.candidate_information3, hr_api.g_varchar2) <>
813: nvl(p_rec.candidate_information3, hr_api.g_varchar2) or
814: nvl(per_eca_shd.g_old_rec.candidate_information4, hr_api.g_varchar2) <>
815: nvl(p_rec.candidate_information4, hr_api.g_varchar2) or
816: nvl(per_eca_shd.g_old_rec.candidate_information5, hr_api.g_varchar2) <>

Line 814: nvl(per_eca_shd.g_old_rec.candidate_information4, hr_api.g_varchar2) <>

810: nvl(per_eca_shd.g_old_rec.candidate_information2, hr_api.g_varchar2) <>
811: nvl(p_rec.candidate_information2, hr_api.g_varchar2) or
812: nvl(per_eca_shd.g_old_rec.candidate_information3, hr_api.g_varchar2) <>
813: nvl(p_rec.candidate_information3, hr_api.g_varchar2) or
814: nvl(per_eca_shd.g_old_rec.candidate_information4, hr_api.g_varchar2) <>
815: nvl(p_rec.candidate_information4, hr_api.g_varchar2) or
816: nvl(per_eca_shd.g_old_rec.candidate_information5, hr_api.g_varchar2) <>
817: nvl(p_rec.candidate_information5, hr_api.g_varchar2) or
818: nvl(per_eca_shd.g_old_rec.candidate_information6, hr_api.g_varchar2) <>

Line 816: nvl(per_eca_shd.g_old_rec.candidate_information5, hr_api.g_varchar2) <>

812: nvl(per_eca_shd.g_old_rec.candidate_information3, hr_api.g_varchar2) <>
813: nvl(p_rec.candidate_information3, hr_api.g_varchar2) or
814: nvl(per_eca_shd.g_old_rec.candidate_information4, hr_api.g_varchar2) <>
815: nvl(p_rec.candidate_information4, hr_api.g_varchar2) or
816: nvl(per_eca_shd.g_old_rec.candidate_information5, hr_api.g_varchar2) <>
817: nvl(p_rec.candidate_information5, hr_api.g_varchar2) or
818: nvl(per_eca_shd.g_old_rec.candidate_information6, hr_api.g_varchar2) <>
819: nvl(p_rec.candidate_information6, hr_api.g_varchar2) or
820: nvl(per_eca_shd.g_old_rec.candidate_information7, hr_api.g_varchar2) <>

Line 818: nvl(per_eca_shd.g_old_rec.candidate_information6, hr_api.g_varchar2) <>

814: nvl(per_eca_shd.g_old_rec.candidate_information4, hr_api.g_varchar2) <>
815: nvl(p_rec.candidate_information4, hr_api.g_varchar2) or
816: nvl(per_eca_shd.g_old_rec.candidate_information5, hr_api.g_varchar2) <>
817: nvl(p_rec.candidate_information5, hr_api.g_varchar2) or
818: nvl(per_eca_shd.g_old_rec.candidate_information6, hr_api.g_varchar2) <>
819: nvl(p_rec.candidate_information6, hr_api.g_varchar2) or
820: nvl(per_eca_shd.g_old_rec.candidate_information7, hr_api.g_varchar2) <>
821: nvl(p_rec.candidate_information7, hr_api.g_varchar2) or
822: nvl(per_eca_shd.g_old_rec.candidate_information8, hr_api.g_varchar2) <>

Line 820: nvl(per_eca_shd.g_old_rec.candidate_information7, hr_api.g_varchar2) <>

816: nvl(per_eca_shd.g_old_rec.candidate_information5, hr_api.g_varchar2) <>
817: nvl(p_rec.candidate_information5, hr_api.g_varchar2) or
818: nvl(per_eca_shd.g_old_rec.candidate_information6, hr_api.g_varchar2) <>
819: nvl(p_rec.candidate_information6, hr_api.g_varchar2) or
820: nvl(per_eca_shd.g_old_rec.candidate_information7, hr_api.g_varchar2) <>
821: nvl(p_rec.candidate_information7, hr_api.g_varchar2) or
822: nvl(per_eca_shd.g_old_rec.candidate_information8, hr_api.g_varchar2) <>
823: nvl(p_rec.candidate_information8, hr_api.g_varchar2) or
824: nvl(per_eca_shd.g_old_rec.candidate_information9, hr_api.g_varchar2) <>

Line 822: nvl(per_eca_shd.g_old_rec.candidate_information8, hr_api.g_varchar2) <>

818: nvl(per_eca_shd.g_old_rec.candidate_information6, hr_api.g_varchar2) <>
819: nvl(p_rec.candidate_information6, hr_api.g_varchar2) or
820: nvl(per_eca_shd.g_old_rec.candidate_information7, hr_api.g_varchar2) <>
821: nvl(p_rec.candidate_information7, hr_api.g_varchar2) or
822: nvl(per_eca_shd.g_old_rec.candidate_information8, hr_api.g_varchar2) <>
823: nvl(p_rec.candidate_information8, hr_api.g_varchar2) or
824: nvl(per_eca_shd.g_old_rec.candidate_information9, hr_api.g_varchar2) <>
825: nvl(p_rec.candidate_information9, hr_api.g_varchar2) or
826: nvl(per_eca_shd.g_old_rec.candidate_information10, hr_api.g_varchar2) <>

Line 824: nvl(per_eca_shd.g_old_rec.candidate_information9, hr_api.g_varchar2) <>

820: nvl(per_eca_shd.g_old_rec.candidate_information7, hr_api.g_varchar2) <>
821: nvl(p_rec.candidate_information7, hr_api.g_varchar2) or
822: nvl(per_eca_shd.g_old_rec.candidate_information8, hr_api.g_varchar2) <>
823: nvl(p_rec.candidate_information8, hr_api.g_varchar2) or
824: nvl(per_eca_shd.g_old_rec.candidate_information9, hr_api.g_varchar2) <>
825: nvl(p_rec.candidate_information9, hr_api.g_varchar2) or
826: nvl(per_eca_shd.g_old_rec.candidate_information10, hr_api.g_varchar2) <>
827: nvl(p_rec.candidate_information10, hr_api.g_varchar2) or
828: nvl(per_eca_shd.g_old_rec.candidate_information11, hr_api.g_varchar2) <>

Line 826: nvl(per_eca_shd.g_old_rec.candidate_information10, hr_api.g_varchar2) <>

822: nvl(per_eca_shd.g_old_rec.candidate_information8, hr_api.g_varchar2) <>
823: nvl(p_rec.candidate_information8, hr_api.g_varchar2) or
824: nvl(per_eca_shd.g_old_rec.candidate_information9, hr_api.g_varchar2) <>
825: nvl(p_rec.candidate_information9, hr_api.g_varchar2) or
826: nvl(per_eca_shd.g_old_rec.candidate_information10, hr_api.g_varchar2) <>
827: nvl(p_rec.candidate_information10, hr_api.g_varchar2) or
828: nvl(per_eca_shd.g_old_rec.candidate_information11, hr_api.g_varchar2) <>
829: nvl(p_rec.candidate_information11, hr_api.g_varchar2) or
830: nvl(per_eca_shd.g_old_rec.candidate_information12, hr_api.g_varchar2) <>

Line 828: nvl(per_eca_shd.g_old_rec.candidate_information11, hr_api.g_varchar2) <>

824: nvl(per_eca_shd.g_old_rec.candidate_information9, hr_api.g_varchar2) <>
825: nvl(p_rec.candidate_information9, hr_api.g_varchar2) or
826: nvl(per_eca_shd.g_old_rec.candidate_information10, hr_api.g_varchar2) <>
827: nvl(p_rec.candidate_information10, hr_api.g_varchar2) or
828: nvl(per_eca_shd.g_old_rec.candidate_information11, hr_api.g_varchar2) <>
829: nvl(p_rec.candidate_information11, hr_api.g_varchar2) or
830: nvl(per_eca_shd.g_old_rec.candidate_information12, hr_api.g_varchar2) <>
831: nvl(p_rec.candidate_information12, hr_api.g_varchar2) or
832: nvl(per_eca_shd.g_old_rec.candidate_information13, hr_api.g_varchar2) <>

Line 830: nvl(per_eca_shd.g_old_rec.candidate_information12, hr_api.g_varchar2) <>

826: nvl(per_eca_shd.g_old_rec.candidate_information10, hr_api.g_varchar2) <>
827: nvl(p_rec.candidate_information10, hr_api.g_varchar2) or
828: nvl(per_eca_shd.g_old_rec.candidate_information11, hr_api.g_varchar2) <>
829: nvl(p_rec.candidate_information11, hr_api.g_varchar2) or
830: nvl(per_eca_shd.g_old_rec.candidate_information12, hr_api.g_varchar2) <>
831: nvl(p_rec.candidate_information12, hr_api.g_varchar2) or
832: nvl(per_eca_shd.g_old_rec.candidate_information13, hr_api.g_varchar2) <>
833: nvl(p_rec.candidate_information13, hr_api.g_varchar2) or
834: nvl(per_eca_shd.g_old_rec.candidate_information14, hr_api.g_varchar2) <>

Line 832: nvl(per_eca_shd.g_old_rec.candidate_information13, hr_api.g_varchar2) <>

828: nvl(per_eca_shd.g_old_rec.candidate_information11, hr_api.g_varchar2) <>
829: nvl(p_rec.candidate_information11, hr_api.g_varchar2) or
830: nvl(per_eca_shd.g_old_rec.candidate_information12, hr_api.g_varchar2) <>
831: nvl(p_rec.candidate_information12, hr_api.g_varchar2) or
832: nvl(per_eca_shd.g_old_rec.candidate_information13, hr_api.g_varchar2) <>
833: nvl(p_rec.candidate_information13, hr_api.g_varchar2) or
834: nvl(per_eca_shd.g_old_rec.candidate_information14, hr_api.g_varchar2) <>
835: nvl(p_rec.candidate_information14, hr_api.g_varchar2) or
836: nvl(per_eca_shd.g_old_rec.candidate_information15, hr_api.g_varchar2) <>

Line 834: nvl(per_eca_shd.g_old_rec.candidate_information14, hr_api.g_varchar2) <>

830: nvl(per_eca_shd.g_old_rec.candidate_information12, hr_api.g_varchar2) <>
831: nvl(p_rec.candidate_information12, hr_api.g_varchar2) or
832: nvl(per_eca_shd.g_old_rec.candidate_information13, hr_api.g_varchar2) <>
833: nvl(p_rec.candidate_information13, hr_api.g_varchar2) or
834: nvl(per_eca_shd.g_old_rec.candidate_information14, hr_api.g_varchar2) <>
835: nvl(p_rec.candidate_information14, hr_api.g_varchar2) or
836: nvl(per_eca_shd.g_old_rec.candidate_information15, hr_api.g_varchar2) <>
837: nvl(p_rec.candidate_information15, hr_api.g_varchar2) or
838: nvl(per_eca_shd.g_old_rec.candidate_information16, hr_api.g_varchar2) <>

Line 836: nvl(per_eca_shd.g_old_rec.candidate_information15, hr_api.g_varchar2) <>

832: nvl(per_eca_shd.g_old_rec.candidate_information13, hr_api.g_varchar2) <>
833: nvl(p_rec.candidate_information13, hr_api.g_varchar2) or
834: nvl(per_eca_shd.g_old_rec.candidate_information14, hr_api.g_varchar2) <>
835: nvl(p_rec.candidate_information14, hr_api.g_varchar2) or
836: nvl(per_eca_shd.g_old_rec.candidate_information15, hr_api.g_varchar2) <>
837: nvl(p_rec.candidate_information15, hr_api.g_varchar2) or
838: nvl(per_eca_shd.g_old_rec.candidate_information16, hr_api.g_varchar2) <>
839: nvl(p_rec.candidate_information16, hr_api.g_varchar2) or
840: nvl(per_eca_shd.g_old_rec.candidate_information17, hr_api.g_varchar2) <>

Line 838: nvl(per_eca_shd.g_old_rec.candidate_information16, hr_api.g_varchar2) <>

834: nvl(per_eca_shd.g_old_rec.candidate_information14, hr_api.g_varchar2) <>
835: nvl(p_rec.candidate_information14, hr_api.g_varchar2) or
836: nvl(per_eca_shd.g_old_rec.candidate_information15, hr_api.g_varchar2) <>
837: nvl(p_rec.candidate_information15, hr_api.g_varchar2) or
838: nvl(per_eca_shd.g_old_rec.candidate_information16, hr_api.g_varchar2) <>
839: nvl(p_rec.candidate_information16, hr_api.g_varchar2) or
840: nvl(per_eca_shd.g_old_rec.candidate_information17, hr_api.g_varchar2) <>
841: nvl(p_rec.candidate_information17, hr_api.g_varchar2) or
842: nvl(per_eca_shd.g_old_rec.candidate_information18, hr_api.g_varchar2) <>

Line 840: nvl(per_eca_shd.g_old_rec.candidate_information17, hr_api.g_varchar2) <>

836: nvl(per_eca_shd.g_old_rec.candidate_information15, hr_api.g_varchar2) <>
837: nvl(p_rec.candidate_information15, hr_api.g_varchar2) or
838: nvl(per_eca_shd.g_old_rec.candidate_information16, hr_api.g_varchar2) <>
839: nvl(p_rec.candidate_information16, hr_api.g_varchar2) or
840: nvl(per_eca_shd.g_old_rec.candidate_information17, hr_api.g_varchar2) <>
841: nvl(p_rec.candidate_information17, hr_api.g_varchar2) or
842: nvl(per_eca_shd.g_old_rec.candidate_information18, hr_api.g_varchar2) <>
843: nvl(p_rec.candidate_information18, hr_api.g_varchar2) or
844: nvl(per_eca_shd.g_old_rec.candidate_information19, hr_api.g_varchar2) <>

Line 842: nvl(per_eca_shd.g_old_rec.candidate_information18, hr_api.g_varchar2) <>

838: nvl(per_eca_shd.g_old_rec.candidate_information16, hr_api.g_varchar2) <>
839: nvl(p_rec.candidate_information16, hr_api.g_varchar2) or
840: nvl(per_eca_shd.g_old_rec.candidate_information17, hr_api.g_varchar2) <>
841: nvl(p_rec.candidate_information17, hr_api.g_varchar2) or
842: nvl(per_eca_shd.g_old_rec.candidate_information18, hr_api.g_varchar2) <>
843: nvl(p_rec.candidate_information18, hr_api.g_varchar2) or
844: nvl(per_eca_shd.g_old_rec.candidate_information19, hr_api.g_varchar2) <>
845: nvl(p_rec.candidate_information19, hr_api.g_varchar2) or
846: nvl(per_eca_shd.g_old_rec.candidate_information20, hr_api.g_varchar2) <>

Line 844: nvl(per_eca_shd.g_old_rec.candidate_information19, hr_api.g_varchar2) <>

840: nvl(per_eca_shd.g_old_rec.candidate_information17, hr_api.g_varchar2) <>
841: nvl(p_rec.candidate_information17, hr_api.g_varchar2) or
842: nvl(per_eca_shd.g_old_rec.candidate_information18, hr_api.g_varchar2) <>
843: nvl(p_rec.candidate_information18, hr_api.g_varchar2) or
844: nvl(per_eca_shd.g_old_rec.candidate_information19, hr_api.g_varchar2) <>
845: nvl(p_rec.candidate_information19, hr_api.g_varchar2) or
846: nvl(per_eca_shd.g_old_rec.candidate_information20, hr_api.g_varchar2) <>
847: nvl(p_rec.candidate_information20, hr_api.g_varchar2) or
848: nvl(per_eca_shd.g_old_rec.candidate_information21, hr_api.g_varchar2) <>

Line 846: nvl(per_eca_shd.g_old_rec.candidate_information20, hr_api.g_varchar2) <>

842: nvl(per_eca_shd.g_old_rec.candidate_information18, hr_api.g_varchar2) <>
843: nvl(p_rec.candidate_information18, hr_api.g_varchar2) or
844: nvl(per_eca_shd.g_old_rec.candidate_information19, hr_api.g_varchar2) <>
845: nvl(p_rec.candidate_information19, hr_api.g_varchar2) or
846: nvl(per_eca_shd.g_old_rec.candidate_information20, hr_api.g_varchar2) <>
847: nvl(p_rec.candidate_information20, hr_api.g_varchar2) or
848: nvl(per_eca_shd.g_old_rec.candidate_information21, hr_api.g_varchar2) <>
849: nvl(p_rec.candidate_information21, hr_api.g_varchar2) or
850: nvl(per_eca_shd.g_old_rec.candidate_information22, hr_api.g_varchar2) <>

Line 848: nvl(per_eca_shd.g_old_rec.candidate_information21, hr_api.g_varchar2) <>

844: nvl(per_eca_shd.g_old_rec.candidate_information19, hr_api.g_varchar2) <>
845: nvl(p_rec.candidate_information19, hr_api.g_varchar2) or
846: nvl(per_eca_shd.g_old_rec.candidate_information20, hr_api.g_varchar2) <>
847: nvl(p_rec.candidate_information20, hr_api.g_varchar2) or
848: nvl(per_eca_shd.g_old_rec.candidate_information21, hr_api.g_varchar2) <>
849: nvl(p_rec.candidate_information21, hr_api.g_varchar2) or
850: nvl(per_eca_shd.g_old_rec.candidate_information22, hr_api.g_varchar2) <>
851: nvl(p_rec.candidate_information22, hr_api.g_varchar2) or
852: nvl(per_eca_shd.g_old_rec.candidate_information23, hr_api.g_varchar2) <>

Line 850: nvl(per_eca_shd.g_old_rec.candidate_information22, hr_api.g_varchar2) <>

846: nvl(per_eca_shd.g_old_rec.candidate_information20, hr_api.g_varchar2) <>
847: nvl(p_rec.candidate_information20, hr_api.g_varchar2) or
848: nvl(per_eca_shd.g_old_rec.candidate_information21, hr_api.g_varchar2) <>
849: nvl(p_rec.candidate_information21, hr_api.g_varchar2) or
850: nvl(per_eca_shd.g_old_rec.candidate_information22, hr_api.g_varchar2) <>
851: nvl(p_rec.candidate_information22, hr_api.g_varchar2) or
852: nvl(per_eca_shd.g_old_rec.candidate_information23, hr_api.g_varchar2) <>
853: nvl(p_rec.candidate_information23, hr_api.g_varchar2) or
854: nvl(per_eca_shd.g_old_rec.candidate_information24, hr_api.g_varchar2) <>

Line 852: nvl(per_eca_shd.g_old_rec.candidate_information23, hr_api.g_varchar2) <>

848: nvl(per_eca_shd.g_old_rec.candidate_information21, hr_api.g_varchar2) <>
849: nvl(p_rec.candidate_information21, hr_api.g_varchar2) or
850: nvl(per_eca_shd.g_old_rec.candidate_information22, hr_api.g_varchar2) <>
851: nvl(p_rec.candidate_information22, hr_api.g_varchar2) or
852: nvl(per_eca_shd.g_old_rec.candidate_information23, hr_api.g_varchar2) <>
853: nvl(p_rec.candidate_information23, hr_api.g_varchar2) or
854: nvl(per_eca_shd.g_old_rec.candidate_information24, hr_api.g_varchar2) <>
855: nvl(p_rec.candidate_information24, hr_api.g_varchar2) or
856: nvl(per_eca_shd.g_old_rec.candidate_information25, hr_api.g_varchar2) <>

Line 854: nvl(per_eca_shd.g_old_rec.candidate_information24, hr_api.g_varchar2) <>

850: nvl(per_eca_shd.g_old_rec.candidate_information22, hr_api.g_varchar2) <>
851: nvl(p_rec.candidate_information22, hr_api.g_varchar2) or
852: nvl(per_eca_shd.g_old_rec.candidate_information23, hr_api.g_varchar2) <>
853: nvl(p_rec.candidate_information23, hr_api.g_varchar2) or
854: nvl(per_eca_shd.g_old_rec.candidate_information24, hr_api.g_varchar2) <>
855: nvl(p_rec.candidate_information24, hr_api.g_varchar2) or
856: nvl(per_eca_shd.g_old_rec.candidate_information25, hr_api.g_varchar2) <>
857: nvl(p_rec.candidate_information25, hr_api.g_varchar2) or
858: nvl(per_eca_shd.g_old_rec.candidate_information26, hr_api.g_varchar2) <>

Line 856: nvl(per_eca_shd.g_old_rec.candidate_information25, hr_api.g_varchar2) <>

852: nvl(per_eca_shd.g_old_rec.candidate_information23, hr_api.g_varchar2) <>
853: nvl(p_rec.candidate_information23, hr_api.g_varchar2) or
854: nvl(per_eca_shd.g_old_rec.candidate_information24, hr_api.g_varchar2) <>
855: nvl(p_rec.candidate_information24, hr_api.g_varchar2) or
856: nvl(per_eca_shd.g_old_rec.candidate_information25, hr_api.g_varchar2) <>
857: nvl(p_rec.candidate_information25, hr_api.g_varchar2) or
858: nvl(per_eca_shd.g_old_rec.candidate_information26, hr_api.g_varchar2) <>
859: nvl(p_rec.candidate_information26, hr_api.g_varchar2) or
860: nvl(per_eca_shd.g_old_rec.candidate_information27, hr_api.g_varchar2) <>

Line 858: nvl(per_eca_shd.g_old_rec.candidate_information26, hr_api.g_varchar2) <>

854: nvl(per_eca_shd.g_old_rec.candidate_information24, hr_api.g_varchar2) <>
855: nvl(p_rec.candidate_information24, hr_api.g_varchar2) or
856: nvl(per_eca_shd.g_old_rec.candidate_information25, hr_api.g_varchar2) <>
857: nvl(p_rec.candidate_information25, hr_api.g_varchar2) or
858: nvl(per_eca_shd.g_old_rec.candidate_information26, hr_api.g_varchar2) <>
859: nvl(p_rec.candidate_information26, hr_api.g_varchar2) or
860: nvl(per_eca_shd.g_old_rec.candidate_information27, hr_api.g_varchar2) <>
861: nvl(p_rec.candidate_information27, hr_api.g_varchar2) or
862: nvl(per_eca_shd.g_old_rec.candidate_information28, hr_api.g_varchar2) <>

Line 860: nvl(per_eca_shd.g_old_rec.candidate_information27, hr_api.g_varchar2) <>

856: nvl(per_eca_shd.g_old_rec.candidate_information25, hr_api.g_varchar2) <>
857: nvl(p_rec.candidate_information25, hr_api.g_varchar2) or
858: nvl(per_eca_shd.g_old_rec.candidate_information26, hr_api.g_varchar2) <>
859: nvl(p_rec.candidate_information26, hr_api.g_varchar2) or
860: nvl(per_eca_shd.g_old_rec.candidate_information27, hr_api.g_varchar2) <>
861: nvl(p_rec.candidate_information27, hr_api.g_varchar2) or
862: nvl(per_eca_shd.g_old_rec.candidate_information28, hr_api.g_varchar2) <>
863: nvl(p_rec.candidate_information28, hr_api.g_varchar2) or
864: nvl(per_eca_shd.g_old_rec.candidate_information29, hr_api.g_varchar2) <>

Line 862: nvl(per_eca_shd.g_old_rec.candidate_information28, hr_api.g_varchar2) <>

858: nvl(per_eca_shd.g_old_rec.candidate_information26, hr_api.g_varchar2) <>
859: nvl(p_rec.candidate_information26, hr_api.g_varchar2) or
860: nvl(per_eca_shd.g_old_rec.candidate_information27, hr_api.g_varchar2) <>
861: nvl(p_rec.candidate_information27, hr_api.g_varchar2) or
862: nvl(per_eca_shd.g_old_rec.candidate_information28, hr_api.g_varchar2) <>
863: nvl(p_rec.candidate_information28, hr_api.g_varchar2) or
864: nvl(per_eca_shd.g_old_rec.candidate_information29, hr_api.g_varchar2) <>
865: nvl(p_rec.candidate_information29, hr_api.g_varchar2) or
866: nvl(per_eca_shd.g_old_rec.candidate_information30, hr_api.g_varchar2) <>

Line 864: nvl(per_eca_shd.g_old_rec.candidate_information29, hr_api.g_varchar2) <>

860: nvl(per_eca_shd.g_old_rec.candidate_information27, hr_api.g_varchar2) <>
861: nvl(p_rec.candidate_information27, hr_api.g_varchar2) or
862: nvl(per_eca_shd.g_old_rec.candidate_information28, hr_api.g_varchar2) <>
863: nvl(p_rec.candidate_information28, hr_api.g_varchar2) or
864: nvl(per_eca_shd.g_old_rec.candidate_information29, hr_api.g_varchar2) <>
865: nvl(p_rec.candidate_information29, hr_api.g_varchar2) or
866: nvl(per_eca_shd.g_old_rec.candidate_information30, hr_api.g_varchar2) <>
867: nvl(p_rec.candidate_information30, hr_api.g_varchar2) ))
868: or (p_rec.election_candidate_id is null) then

Line 866: nvl(per_eca_shd.g_old_rec.candidate_information30, hr_api.g_varchar2) <>

862: nvl(per_eca_shd.g_old_rec.candidate_information28, hr_api.g_varchar2) <>
863: nvl(p_rec.candidate_information28, hr_api.g_varchar2) or
864: nvl(per_eca_shd.g_old_rec.candidate_information29, hr_api.g_varchar2) <>
865: nvl(p_rec.candidate_information29, hr_api.g_varchar2) or
866: nvl(per_eca_shd.g_old_rec.candidate_information30, hr_api.g_varchar2) <>
867: nvl(p_rec.candidate_information30, hr_api.g_varchar2) ))
868: or (p_rec.election_candidate_id is null) then
869: --
870: -- Only execute the validation if absolutely necessary:

Line 949: (p_rec in per_eca_shd.g_rec_type

945: -- ----------------------------------------------------------------------------
946: -- |---------------------------< insert_validate >----------------------------|
947: -- ----------------------------------------------------------------------------
948: Procedure insert_validate
949: (p_rec in per_eca_shd.g_rec_type
950: ) is
951: --
952: l_proc varchar2(72) := g_package||'insert_validate';
953: --

Line 1005: (p_rec in per_eca_shd.g_rec_type

1001: -- ----------------------------------------------------------------------------
1002: -- |---------------------------< update_validate >----------------------------|
1003: -- ----------------------------------------------------------------------------
1004: Procedure update_validate
1005: (p_rec in per_eca_shd.g_rec_type
1006: ) is
1007: --
1008: l_proc varchar2(72) := g_package||'insert_validate';
1009: --