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