418: -- Internal Table Handler Use Only.
419: --
420: -- {End Of Comments}
421: -- ----------------------------------------------------------------------------
422: Procedure chk_non_updateable_args (p_rec in pe_aei_shd.g_rec_type) is
423: --
424: l_proc varchar2(72) := g_package||'chk_non_updateable_args';
425: l_error exception;
426: l_argument varchar2(30);
430: --
431: -- Only proceed with validation if a row exists for
432: -- the current record in the HR Schema
433: --
434: if not pe_aei_shd.api_updating
435: (p_assignment_extra_info_id => p_rec.assignment_extra_info_id
436: ,p_object_version_number => p_rec.object_version_number) then
437: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
438: hr_utility.set_message_token('PROCEDURE', l_proc);
441: --
442: hr_utility.set_location(l_proc, 30);
443: --
444: if nvl(p_rec.information_type, hr_api.g_varchar2) <>
445: nvl(pe_aei_shd.g_old_rec.information_type, hr_api.g_varchar2) then
446: l_argument := 'information_type';
447: raise l_error;
448: end if;
449: --
449: --
450: hr_utility.set_location(l_proc, 40);
451: --
452: if nvl(p_rec.assignment_id, hr_api.g_number) <>
453: nvl(pe_aei_shd.g_old_rec.assignment_id, hr_api.g_number) then
454: l_argument := 'assignment_id';
455: raise l_error;
456: end if;
457: --
498: -- {End Of Comments}
499: -- ----------------------------------------------------------------------------
500: --
501: procedure chk_df
502: (p_rec in pe_aei_shd.g_rec_type) is
503: --
504: l_proc varchar2(72) := g_package||'chk_df';
505: --
506: begin
506: begin
507: hr_utility.set_location('Entering:'||l_proc, 10);
508: --
509: if ((p_rec.assignment_extra_info_id is not null) and (
510: nvl(pe_aei_shd.g_old_rec.aei_attribute_category, hr_api.g_varchar2) <>
511: nvl(p_rec.aei_attribute_category, hr_api.g_varchar2) or
512: nvl(pe_aei_shd.g_old_rec.aei_attribute1, hr_api.g_varchar2) <>
513: nvl(p_rec.aei_attribute1, hr_api.g_varchar2) or
514: nvl(pe_aei_shd.g_old_rec.aei_attribute2, hr_api.g_varchar2) <>
508: --
509: if ((p_rec.assignment_extra_info_id is not null) and (
510: nvl(pe_aei_shd.g_old_rec.aei_attribute_category, hr_api.g_varchar2) <>
511: nvl(p_rec.aei_attribute_category, hr_api.g_varchar2) or
512: nvl(pe_aei_shd.g_old_rec.aei_attribute1, hr_api.g_varchar2) <>
513: nvl(p_rec.aei_attribute1, hr_api.g_varchar2) or
514: nvl(pe_aei_shd.g_old_rec.aei_attribute2, hr_api.g_varchar2) <>
515: nvl(p_rec.aei_attribute2, hr_api.g_varchar2) or
516: nvl(pe_aei_shd.g_old_rec.aei_attribute3, hr_api.g_varchar2) <>
510: nvl(pe_aei_shd.g_old_rec.aei_attribute_category, hr_api.g_varchar2) <>
511: nvl(p_rec.aei_attribute_category, hr_api.g_varchar2) or
512: nvl(pe_aei_shd.g_old_rec.aei_attribute1, hr_api.g_varchar2) <>
513: nvl(p_rec.aei_attribute1, hr_api.g_varchar2) or
514: nvl(pe_aei_shd.g_old_rec.aei_attribute2, hr_api.g_varchar2) <>
515: nvl(p_rec.aei_attribute2, hr_api.g_varchar2) or
516: nvl(pe_aei_shd.g_old_rec.aei_attribute3, hr_api.g_varchar2) <>
517: nvl(p_rec.aei_attribute3, hr_api.g_varchar2) or
518: nvl(pe_aei_shd.g_old_rec.aei_attribute4, hr_api.g_varchar2) <>
512: nvl(pe_aei_shd.g_old_rec.aei_attribute1, hr_api.g_varchar2) <>
513: nvl(p_rec.aei_attribute1, hr_api.g_varchar2) or
514: nvl(pe_aei_shd.g_old_rec.aei_attribute2, hr_api.g_varchar2) <>
515: nvl(p_rec.aei_attribute2, hr_api.g_varchar2) or
516: nvl(pe_aei_shd.g_old_rec.aei_attribute3, hr_api.g_varchar2) <>
517: nvl(p_rec.aei_attribute3, hr_api.g_varchar2) or
518: nvl(pe_aei_shd.g_old_rec.aei_attribute4, hr_api.g_varchar2) <>
519: nvl(p_rec.aei_attribute4, hr_api.g_varchar2) or
520: nvl(pe_aei_shd.g_old_rec.aei_attribute5, hr_api.g_varchar2) <>
514: nvl(pe_aei_shd.g_old_rec.aei_attribute2, hr_api.g_varchar2) <>
515: nvl(p_rec.aei_attribute2, hr_api.g_varchar2) or
516: nvl(pe_aei_shd.g_old_rec.aei_attribute3, hr_api.g_varchar2) <>
517: nvl(p_rec.aei_attribute3, hr_api.g_varchar2) or
518: nvl(pe_aei_shd.g_old_rec.aei_attribute4, hr_api.g_varchar2) <>
519: nvl(p_rec.aei_attribute4, hr_api.g_varchar2) or
520: nvl(pe_aei_shd.g_old_rec.aei_attribute5, hr_api.g_varchar2) <>
521: nvl(p_rec.aei_attribute5, hr_api.g_varchar2) or
522: nvl(pe_aei_shd.g_old_rec.aei_attribute6, hr_api.g_varchar2) <>
516: nvl(pe_aei_shd.g_old_rec.aei_attribute3, hr_api.g_varchar2) <>
517: nvl(p_rec.aei_attribute3, hr_api.g_varchar2) or
518: nvl(pe_aei_shd.g_old_rec.aei_attribute4, hr_api.g_varchar2) <>
519: nvl(p_rec.aei_attribute4, hr_api.g_varchar2) or
520: nvl(pe_aei_shd.g_old_rec.aei_attribute5, hr_api.g_varchar2) <>
521: nvl(p_rec.aei_attribute5, hr_api.g_varchar2) or
522: nvl(pe_aei_shd.g_old_rec.aei_attribute6, hr_api.g_varchar2) <>
523: nvl(p_rec.aei_attribute6, hr_api.g_varchar2) or
524: nvl(pe_aei_shd.g_old_rec.aei_attribute7, hr_api.g_varchar2) <>
518: nvl(pe_aei_shd.g_old_rec.aei_attribute4, hr_api.g_varchar2) <>
519: nvl(p_rec.aei_attribute4, hr_api.g_varchar2) or
520: nvl(pe_aei_shd.g_old_rec.aei_attribute5, hr_api.g_varchar2) <>
521: nvl(p_rec.aei_attribute5, hr_api.g_varchar2) or
522: nvl(pe_aei_shd.g_old_rec.aei_attribute6, hr_api.g_varchar2) <>
523: nvl(p_rec.aei_attribute6, hr_api.g_varchar2) or
524: nvl(pe_aei_shd.g_old_rec.aei_attribute7, hr_api.g_varchar2) <>
525: nvl(p_rec.aei_attribute7, hr_api.g_varchar2) or
526: nvl(pe_aei_shd.g_old_rec.aei_attribute8, hr_api.g_varchar2) <>
520: nvl(pe_aei_shd.g_old_rec.aei_attribute5, hr_api.g_varchar2) <>
521: nvl(p_rec.aei_attribute5, hr_api.g_varchar2) or
522: nvl(pe_aei_shd.g_old_rec.aei_attribute6, hr_api.g_varchar2) <>
523: nvl(p_rec.aei_attribute6, hr_api.g_varchar2) or
524: nvl(pe_aei_shd.g_old_rec.aei_attribute7, hr_api.g_varchar2) <>
525: nvl(p_rec.aei_attribute7, hr_api.g_varchar2) or
526: nvl(pe_aei_shd.g_old_rec.aei_attribute8, hr_api.g_varchar2) <>
527: nvl(p_rec.aei_attribute8, hr_api.g_varchar2) or
528: nvl(pe_aei_shd.g_old_rec.aei_attribute9, hr_api.g_varchar2) <>
522: nvl(pe_aei_shd.g_old_rec.aei_attribute6, hr_api.g_varchar2) <>
523: nvl(p_rec.aei_attribute6, hr_api.g_varchar2) or
524: nvl(pe_aei_shd.g_old_rec.aei_attribute7, hr_api.g_varchar2) <>
525: nvl(p_rec.aei_attribute7, hr_api.g_varchar2) or
526: nvl(pe_aei_shd.g_old_rec.aei_attribute8, hr_api.g_varchar2) <>
527: nvl(p_rec.aei_attribute8, hr_api.g_varchar2) or
528: nvl(pe_aei_shd.g_old_rec.aei_attribute9, hr_api.g_varchar2) <>
529: nvl(p_rec.aei_attribute9, hr_api.g_varchar2) or
530: nvl(pe_aei_shd.g_old_rec.aei_attribute10, hr_api.g_varchar2) <>
524: nvl(pe_aei_shd.g_old_rec.aei_attribute7, hr_api.g_varchar2) <>
525: nvl(p_rec.aei_attribute7, hr_api.g_varchar2) or
526: nvl(pe_aei_shd.g_old_rec.aei_attribute8, hr_api.g_varchar2) <>
527: nvl(p_rec.aei_attribute8, hr_api.g_varchar2) or
528: nvl(pe_aei_shd.g_old_rec.aei_attribute9, hr_api.g_varchar2) <>
529: nvl(p_rec.aei_attribute9, hr_api.g_varchar2) or
530: nvl(pe_aei_shd.g_old_rec.aei_attribute10, hr_api.g_varchar2) <>
531: nvl(p_rec.aei_attribute10, hr_api.g_varchar2) or
532: nvl(pe_aei_shd.g_old_rec.aei_attribute11, hr_api.g_varchar2) <>
526: nvl(pe_aei_shd.g_old_rec.aei_attribute8, hr_api.g_varchar2) <>
527: nvl(p_rec.aei_attribute8, hr_api.g_varchar2) or
528: nvl(pe_aei_shd.g_old_rec.aei_attribute9, hr_api.g_varchar2) <>
529: nvl(p_rec.aei_attribute9, hr_api.g_varchar2) or
530: nvl(pe_aei_shd.g_old_rec.aei_attribute10, hr_api.g_varchar2) <>
531: nvl(p_rec.aei_attribute10, hr_api.g_varchar2) or
532: nvl(pe_aei_shd.g_old_rec.aei_attribute11, hr_api.g_varchar2) <>
533: nvl(p_rec.aei_attribute11, hr_api.g_varchar2) or
534: nvl(pe_aei_shd.g_old_rec.aei_attribute12, hr_api.g_varchar2) <>
528: nvl(pe_aei_shd.g_old_rec.aei_attribute9, hr_api.g_varchar2) <>
529: nvl(p_rec.aei_attribute9, hr_api.g_varchar2) or
530: nvl(pe_aei_shd.g_old_rec.aei_attribute10, hr_api.g_varchar2) <>
531: nvl(p_rec.aei_attribute10, hr_api.g_varchar2) or
532: nvl(pe_aei_shd.g_old_rec.aei_attribute11, hr_api.g_varchar2) <>
533: nvl(p_rec.aei_attribute11, hr_api.g_varchar2) or
534: nvl(pe_aei_shd.g_old_rec.aei_attribute12, hr_api.g_varchar2) <>
535: nvl(p_rec.aei_attribute12, hr_api.g_varchar2) or
536: nvl(pe_aei_shd.g_old_rec.aei_attribute13, hr_api.g_varchar2) <>
530: nvl(pe_aei_shd.g_old_rec.aei_attribute10, hr_api.g_varchar2) <>
531: nvl(p_rec.aei_attribute10, hr_api.g_varchar2) or
532: nvl(pe_aei_shd.g_old_rec.aei_attribute11, hr_api.g_varchar2) <>
533: nvl(p_rec.aei_attribute11, hr_api.g_varchar2) or
534: nvl(pe_aei_shd.g_old_rec.aei_attribute12, hr_api.g_varchar2) <>
535: nvl(p_rec.aei_attribute12, hr_api.g_varchar2) or
536: nvl(pe_aei_shd.g_old_rec.aei_attribute13, hr_api.g_varchar2) <>
537: nvl(p_rec.aei_attribute13, hr_api.g_varchar2) or
538: nvl(pe_aei_shd.g_old_rec.aei_attribute14, hr_api.g_varchar2) <>
532: nvl(pe_aei_shd.g_old_rec.aei_attribute11, hr_api.g_varchar2) <>
533: nvl(p_rec.aei_attribute11, hr_api.g_varchar2) or
534: nvl(pe_aei_shd.g_old_rec.aei_attribute12, hr_api.g_varchar2) <>
535: nvl(p_rec.aei_attribute12, hr_api.g_varchar2) or
536: nvl(pe_aei_shd.g_old_rec.aei_attribute13, hr_api.g_varchar2) <>
537: nvl(p_rec.aei_attribute13, hr_api.g_varchar2) or
538: nvl(pe_aei_shd.g_old_rec.aei_attribute14, hr_api.g_varchar2) <>
539: nvl(p_rec.aei_attribute14, hr_api.g_varchar2) or
540: nvl(pe_aei_shd.g_old_rec.aei_attribute15, hr_api.g_varchar2) <>
534: nvl(pe_aei_shd.g_old_rec.aei_attribute12, hr_api.g_varchar2) <>
535: nvl(p_rec.aei_attribute12, hr_api.g_varchar2) or
536: nvl(pe_aei_shd.g_old_rec.aei_attribute13, hr_api.g_varchar2) <>
537: nvl(p_rec.aei_attribute13, hr_api.g_varchar2) or
538: nvl(pe_aei_shd.g_old_rec.aei_attribute14, hr_api.g_varchar2) <>
539: nvl(p_rec.aei_attribute14, hr_api.g_varchar2) or
540: nvl(pe_aei_shd.g_old_rec.aei_attribute15, hr_api.g_varchar2) <>
541: nvl(p_rec.aei_attribute15, hr_api.g_varchar2) or
542: nvl(pe_aei_shd.g_old_rec.aei_attribute16, hr_api.g_varchar2) <>
536: nvl(pe_aei_shd.g_old_rec.aei_attribute13, hr_api.g_varchar2) <>
537: nvl(p_rec.aei_attribute13, hr_api.g_varchar2) or
538: nvl(pe_aei_shd.g_old_rec.aei_attribute14, hr_api.g_varchar2) <>
539: nvl(p_rec.aei_attribute14, hr_api.g_varchar2) or
540: nvl(pe_aei_shd.g_old_rec.aei_attribute15, hr_api.g_varchar2) <>
541: nvl(p_rec.aei_attribute15, hr_api.g_varchar2) or
542: nvl(pe_aei_shd.g_old_rec.aei_attribute16, hr_api.g_varchar2) <>
543: nvl(p_rec.aei_attribute16, hr_api.g_varchar2) or
544: nvl(pe_aei_shd.g_old_rec.aei_attribute17, hr_api.g_varchar2) <>
538: nvl(pe_aei_shd.g_old_rec.aei_attribute14, hr_api.g_varchar2) <>
539: nvl(p_rec.aei_attribute14, hr_api.g_varchar2) or
540: nvl(pe_aei_shd.g_old_rec.aei_attribute15, hr_api.g_varchar2) <>
541: nvl(p_rec.aei_attribute15, hr_api.g_varchar2) or
542: nvl(pe_aei_shd.g_old_rec.aei_attribute16, hr_api.g_varchar2) <>
543: nvl(p_rec.aei_attribute16, hr_api.g_varchar2) or
544: nvl(pe_aei_shd.g_old_rec.aei_attribute17, hr_api.g_varchar2) <>
545: nvl(p_rec.aei_attribute17, hr_api.g_varchar2) or
546: nvl(pe_aei_shd.g_old_rec.aei_attribute18, hr_api.g_varchar2) <>
540: nvl(pe_aei_shd.g_old_rec.aei_attribute15, hr_api.g_varchar2) <>
541: nvl(p_rec.aei_attribute15, hr_api.g_varchar2) or
542: nvl(pe_aei_shd.g_old_rec.aei_attribute16, hr_api.g_varchar2) <>
543: nvl(p_rec.aei_attribute16, hr_api.g_varchar2) or
544: nvl(pe_aei_shd.g_old_rec.aei_attribute17, hr_api.g_varchar2) <>
545: nvl(p_rec.aei_attribute17, hr_api.g_varchar2) or
546: nvl(pe_aei_shd.g_old_rec.aei_attribute18, hr_api.g_varchar2) <>
547: nvl(p_rec.aei_attribute18, hr_api.g_varchar2) or
548: nvl(pe_aei_shd.g_old_rec.aei_attribute19, hr_api.g_varchar2) <>
542: nvl(pe_aei_shd.g_old_rec.aei_attribute16, hr_api.g_varchar2) <>
543: nvl(p_rec.aei_attribute16, hr_api.g_varchar2) or
544: nvl(pe_aei_shd.g_old_rec.aei_attribute17, hr_api.g_varchar2) <>
545: nvl(p_rec.aei_attribute17, hr_api.g_varchar2) or
546: nvl(pe_aei_shd.g_old_rec.aei_attribute18, hr_api.g_varchar2) <>
547: nvl(p_rec.aei_attribute18, hr_api.g_varchar2) or
548: nvl(pe_aei_shd.g_old_rec.aei_attribute19, hr_api.g_varchar2) <>
549: nvl(p_rec.aei_attribute19, hr_api.g_varchar2) or
550: nvl(pe_aei_shd.g_old_rec.aei_attribute20, hr_api.g_varchar2) <>
544: nvl(pe_aei_shd.g_old_rec.aei_attribute17, hr_api.g_varchar2) <>
545: nvl(p_rec.aei_attribute17, hr_api.g_varchar2) or
546: nvl(pe_aei_shd.g_old_rec.aei_attribute18, hr_api.g_varchar2) <>
547: nvl(p_rec.aei_attribute18, hr_api.g_varchar2) or
548: nvl(pe_aei_shd.g_old_rec.aei_attribute19, hr_api.g_varchar2) <>
549: nvl(p_rec.aei_attribute19, hr_api.g_varchar2) or
550: nvl(pe_aei_shd.g_old_rec.aei_attribute20, hr_api.g_varchar2) <>
551: nvl(p_rec.aei_attribute20, hr_api.g_varchar2)))
552: or
546: nvl(pe_aei_shd.g_old_rec.aei_attribute18, hr_api.g_varchar2) <>
547: nvl(p_rec.aei_attribute18, hr_api.g_varchar2) or
548: nvl(pe_aei_shd.g_old_rec.aei_attribute19, hr_api.g_varchar2) <>
549: nvl(p_rec.aei_attribute19, hr_api.g_varchar2) or
550: nvl(pe_aei_shd.g_old_rec.aei_attribute20, hr_api.g_varchar2) <>
551: nvl(p_rec.aei_attribute20, hr_api.g_varchar2)))
552: or
553: (p_rec.assignment_extra_info_id is null) then
554: --
637: -- {End Of Comments}
638: -- ----------------------------------------------------------------------------
639: --
640: procedure chk_ddf
641: (p_rec in pe_aei_shd.g_rec_type) is
642: --
643: l_proc varchar2(72) := g_package||'chk_ddf';
644: l_error exception;
645: --
651: --
652: if (p_rec.assignment_extra_info_id is null)
653: or ((p_rec.assignment_extra_info_id is not null)
654: and
655: nvl(pe_aei_shd.g_old_rec.aei_attribute_category, hr_api.g_varchar2) <>
656: nvl(p_rec.aei_information_category, hr_api.g_varchar2) or
657: nvl(pe_aei_shd.g_old_rec.aei_information1, hr_api.g_varchar2) <>
658: nvl(p_rec.aei_information1, hr_api.g_varchar2) or
659: nvl(pe_aei_shd.g_old_rec.aei_information2, hr_api.g_varchar2) <>
653: or ((p_rec.assignment_extra_info_id is not null)
654: and
655: nvl(pe_aei_shd.g_old_rec.aei_attribute_category, hr_api.g_varchar2) <>
656: nvl(p_rec.aei_information_category, hr_api.g_varchar2) or
657: nvl(pe_aei_shd.g_old_rec.aei_information1, hr_api.g_varchar2) <>
658: nvl(p_rec.aei_information1, hr_api.g_varchar2) or
659: nvl(pe_aei_shd.g_old_rec.aei_information2, hr_api.g_varchar2) <>
660: nvl(p_rec.aei_information2, hr_api.g_varchar2) or
661: nvl(pe_aei_shd.g_old_rec.aei_information3, hr_api.g_varchar2) <>
655: nvl(pe_aei_shd.g_old_rec.aei_attribute_category, hr_api.g_varchar2) <>
656: nvl(p_rec.aei_information_category, hr_api.g_varchar2) or
657: nvl(pe_aei_shd.g_old_rec.aei_information1, hr_api.g_varchar2) <>
658: nvl(p_rec.aei_information1, hr_api.g_varchar2) or
659: nvl(pe_aei_shd.g_old_rec.aei_information2, hr_api.g_varchar2) <>
660: nvl(p_rec.aei_information2, hr_api.g_varchar2) or
661: nvl(pe_aei_shd.g_old_rec.aei_information3, hr_api.g_varchar2) <>
662: nvl(p_rec.aei_information3, hr_api.g_varchar2) or
663: nvl(pe_aei_shd.g_old_rec.aei_information4, hr_api.g_varchar2) <>
657: nvl(pe_aei_shd.g_old_rec.aei_information1, hr_api.g_varchar2) <>
658: nvl(p_rec.aei_information1, hr_api.g_varchar2) or
659: nvl(pe_aei_shd.g_old_rec.aei_information2, hr_api.g_varchar2) <>
660: nvl(p_rec.aei_information2, hr_api.g_varchar2) or
661: nvl(pe_aei_shd.g_old_rec.aei_information3, hr_api.g_varchar2) <>
662: nvl(p_rec.aei_information3, hr_api.g_varchar2) or
663: nvl(pe_aei_shd.g_old_rec.aei_information4, hr_api.g_varchar2) <>
664: nvl(p_rec.aei_information4, hr_api.g_varchar2) or
665: nvl(pe_aei_shd.g_old_rec.aei_information5, hr_api.g_varchar2) <>
659: nvl(pe_aei_shd.g_old_rec.aei_information2, hr_api.g_varchar2) <>
660: nvl(p_rec.aei_information2, hr_api.g_varchar2) or
661: nvl(pe_aei_shd.g_old_rec.aei_information3, hr_api.g_varchar2) <>
662: nvl(p_rec.aei_information3, hr_api.g_varchar2) or
663: nvl(pe_aei_shd.g_old_rec.aei_information4, hr_api.g_varchar2) <>
664: nvl(p_rec.aei_information4, hr_api.g_varchar2) or
665: nvl(pe_aei_shd.g_old_rec.aei_information5, hr_api.g_varchar2) <>
666: nvl(p_rec.aei_information5, hr_api.g_varchar2) or
667: nvl(pe_aei_shd.g_old_rec.aei_information6, hr_api.g_varchar2) <>
661: nvl(pe_aei_shd.g_old_rec.aei_information3, hr_api.g_varchar2) <>
662: nvl(p_rec.aei_information3, hr_api.g_varchar2) or
663: nvl(pe_aei_shd.g_old_rec.aei_information4, hr_api.g_varchar2) <>
664: nvl(p_rec.aei_information4, hr_api.g_varchar2) or
665: nvl(pe_aei_shd.g_old_rec.aei_information5, hr_api.g_varchar2) <>
666: nvl(p_rec.aei_information5, hr_api.g_varchar2) or
667: nvl(pe_aei_shd.g_old_rec.aei_information6, hr_api.g_varchar2) <>
668: nvl(p_rec.aei_information6, hr_api.g_varchar2) or
669: nvl(pe_aei_shd.g_old_rec.aei_information7, hr_api.g_varchar2) <>
663: nvl(pe_aei_shd.g_old_rec.aei_information4, hr_api.g_varchar2) <>
664: nvl(p_rec.aei_information4, hr_api.g_varchar2) or
665: nvl(pe_aei_shd.g_old_rec.aei_information5, hr_api.g_varchar2) <>
666: nvl(p_rec.aei_information5, hr_api.g_varchar2) or
667: nvl(pe_aei_shd.g_old_rec.aei_information6, hr_api.g_varchar2) <>
668: nvl(p_rec.aei_information6, hr_api.g_varchar2) or
669: nvl(pe_aei_shd.g_old_rec.aei_information7, hr_api.g_varchar2) <>
670: nvl(p_rec.aei_information7, hr_api.g_varchar2) or
671: nvl(pe_aei_shd.g_old_rec.aei_information8, hr_api.g_varchar2) <>
665: nvl(pe_aei_shd.g_old_rec.aei_information5, hr_api.g_varchar2) <>
666: nvl(p_rec.aei_information5, hr_api.g_varchar2) or
667: nvl(pe_aei_shd.g_old_rec.aei_information6, hr_api.g_varchar2) <>
668: nvl(p_rec.aei_information6, hr_api.g_varchar2) or
669: nvl(pe_aei_shd.g_old_rec.aei_information7, hr_api.g_varchar2) <>
670: nvl(p_rec.aei_information7, hr_api.g_varchar2) or
671: nvl(pe_aei_shd.g_old_rec.aei_information8, hr_api.g_varchar2) <>
672: nvl(p_rec.aei_information8, hr_api.g_varchar2) or
673: nvl(pe_aei_shd.g_old_rec.aei_information9, hr_api.g_varchar2) <>
667: nvl(pe_aei_shd.g_old_rec.aei_information6, hr_api.g_varchar2) <>
668: nvl(p_rec.aei_information6, hr_api.g_varchar2) or
669: nvl(pe_aei_shd.g_old_rec.aei_information7, hr_api.g_varchar2) <>
670: nvl(p_rec.aei_information7, hr_api.g_varchar2) or
671: nvl(pe_aei_shd.g_old_rec.aei_information8, hr_api.g_varchar2) <>
672: nvl(p_rec.aei_information8, hr_api.g_varchar2) or
673: nvl(pe_aei_shd.g_old_rec.aei_information9, hr_api.g_varchar2) <>
674: nvl(p_rec.aei_information9, hr_api.g_varchar2) or
675: nvl(pe_aei_shd.g_old_rec.aei_information10, hr_api.g_varchar2) <>
669: nvl(pe_aei_shd.g_old_rec.aei_information7, hr_api.g_varchar2) <>
670: nvl(p_rec.aei_information7, hr_api.g_varchar2) or
671: nvl(pe_aei_shd.g_old_rec.aei_information8, hr_api.g_varchar2) <>
672: nvl(p_rec.aei_information8, hr_api.g_varchar2) or
673: nvl(pe_aei_shd.g_old_rec.aei_information9, hr_api.g_varchar2) <>
674: nvl(p_rec.aei_information9, hr_api.g_varchar2) or
675: nvl(pe_aei_shd.g_old_rec.aei_information10, hr_api.g_varchar2) <>
676: nvl(p_rec.aei_information10, hr_api.g_varchar2) or
677: nvl(pe_aei_shd.g_old_rec.aei_information11, hr_api.g_varchar2) <>
671: nvl(pe_aei_shd.g_old_rec.aei_information8, hr_api.g_varchar2) <>
672: nvl(p_rec.aei_information8, hr_api.g_varchar2) or
673: nvl(pe_aei_shd.g_old_rec.aei_information9, hr_api.g_varchar2) <>
674: nvl(p_rec.aei_information9, hr_api.g_varchar2) or
675: nvl(pe_aei_shd.g_old_rec.aei_information10, hr_api.g_varchar2) <>
676: nvl(p_rec.aei_information10, hr_api.g_varchar2) or
677: nvl(pe_aei_shd.g_old_rec.aei_information11, hr_api.g_varchar2) <>
678: nvl(p_rec.aei_information11, hr_api.g_varchar2) or
679: nvl(pe_aei_shd.g_old_rec.aei_information12, hr_api.g_varchar2) <>
673: nvl(pe_aei_shd.g_old_rec.aei_information9, hr_api.g_varchar2) <>
674: nvl(p_rec.aei_information9, hr_api.g_varchar2) or
675: nvl(pe_aei_shd.g_old_rec.aei_information10, hr_api.g_varchar2) <>
676: nvl(p_rec.aei_information10, hr_api.g_varchar2) or
677: nvl(pe_aei_shd.g_old_rec.aei_information11, hr_api.g_varchar2) <>
678: nvl(p_rec.aei_information11, hr_api.g_varchar2) or
679: nvl(pe_aei_shd.g_old_rec.aei_information12, hr_api.g_varchar2) <>
680: nvl(p_rec.aei_information12, hr_api.g_varchar2) or
681: nvl(pe_aei_shd.g_old_rec.aei_information13, hr_api.g_varchar2) <>
675: nvl(pe_aei_shd.g_old_rec.aei_information10, hr_api.g_varchar2) <>
676: nvl(p_rec.aei_information10, hr_api.g_varchar2) or
677: nvl(pe_aei_shd.g_old_rec.aei_information11, hr_api.g_varchar2) <>
678: nvl(p_rec.aei_information11, hr_api.g_varchar2) or
679: nvl(pe_aei_shd.g_old_rec.aei_information12, hr_api.g_varchar2) <>
680: nvl(p_rec.aei_information12, hr_api.g_varchar2) or
681: nvl(pe_aei_shd.g_old_rec.aei_information13, hr_api.g_varchar2) <>
682: nvl(p_rec.aei_information13, hr_api.g_varchar2) or
683: nvl(pe_aei_shd.g_old_rec.aei_information14, hr_api.g_varchar2) <>
677: nvl(pe_aei_shd.g_old_rec.aei_information11, hr_api.g_varchar2) <>
678: nvl(p_rec.aei_information11, hr_api.g_varchar2) or
679: nvl(pe_aei_shd.g_old_rec.aei_information12, hr_api.g_varchar2) <>
680: nvl(p_rec.aei_information12, hr_api.g_varchar2) or
681: nvl(pe_aei_shd.g_old_rec.aei_information13, hr_api.g_varchar2) <>
682: nvl(p_rec.aei_information13, hr_api.g_varchar2) or
683: nvl(pe_aei_shd.g_old_rec.aei_information14, hr_api.g_varchar2) <>
684: nvl(p_rec.aei_information14, hr_api.g_varchar2) or
685: nvl(pe_aei_shd.g_old_rec.aei_information15, hr_api.g_varchar2) <>
679: nvl(pe_aei_shd.g_old_rec.aei_information12, hr_api.g_varchar2) <>
680: nvl(p_rec.aei_information12, hr_api.g_varchar2) or
681: nvl(pe_aei_shd.g_old_rec.aei_information13, hr_api.g_varchar2) <>
682: nvl(p_rec.aei_information13, hr_api.g_varchar2) or
683: nvl(pe_aei_shd.g_old_rec.aei_information14, hr_api.g_varchar2) <>
684: nvl(p_rec.aei_information14, hr_api.g_varchar2) or
685: nvl(pe_aei_shd.g_old_rec.aei_information15, hr_api.g_varchar2) <>
686: nvl(p_rec.aei_information15, hr_api.g_varchar2) or
687: nvl(pe_aei_shd.g_old_rec.aei_information16, hr_api.g_varchar2) <>
681: nvl(pe_aei_shd.g_old_rec.aei_information13, hr_api.g_varchar2) <>
682: nvl(p_rec.aei_information13, hr_api.g_varchar2) or
683: nvl(pe_aei_shd.g_old_rec.aei_information14, hr_api.g_varchar2) <>
684: nvl(p_rec.aei_information14, hr_api.g_varchar2) or
685: nvl(pe_aei_shd.g_old_rec.aei_information15, hr_api.g_varchar2) <>
686: nvl(p_rec.aei_information15, hr_api.g_varchar2) or
687: nvl(pe_aei_shd.g_old_rec.aei_information16, hr_api.g_varchar2) <>
688: nvl(p_rec.aei_information16, hr_api.g_varchar2) or
689: nvl(pe_aei_shd.g_old_rec.aei_information17, hr_api.g_varchar2) <>
683: nvl(pe_aei_shd.g_old_rec.aei_information14, hr_api.g_varchar2) <>
684: nvl(p_rec.aei_information14, hr_api.g_varchar2) or
685: nvl(pe_aei_shd.g_old_rec.aei_information15, hr_api.g_varchar2) <>
686: nvl(p_rec.aei_information15, hr_api.g_varchar2) or
687: nvl(pe_aei_shd.g_old_rec.aei_information16, hr_api.g_varchar2) <>
688: nvl(p_rec.aei_information16, hr_api.g_varchar2) or
689: nvl(pe_aei_shd.g_old_rec.aei_information17, hr_api.g_varchar2) <>
690: nvl(p_rec.aei_information17, hr_api.g_varchar2) or
691: nvl(pe_aei_shd.g_old_rec.aei_information18, hr_api.g_varchar2) <>
685: nvl(pe_aei_shd.g_old_rec.aei_information15, hr_api.g_varchar2) <>
686: nvl(p_rec.aei_information15, hr_api.g_varchar2) or
687: nvl(pe_aei_shd.g_old_rec.aei_information16, hr_api.g_varchar2) <>
688: nvl(p_rec.aei_information16, hr_api.g_varchar2) or
689: nvl(pe_aei_shd.g_old_rec.aei_information17, hr_api.g_varchar2) <>
690: nvl(p_rec.aei_information17, hr_api.g_varchar2) or
691: nvl(pe_aei_shd.g_old_rec.aei_information18, hr_api.g_varchar2) <>
692: nvl(p_rec.aei_information18, hr_api.g_varchar2) or
693: nvl(pe_aei_shd.g_old_rec.aei_information19, hr_api.g_varchar2) <>
687: nvl(pe_aei_shd.g_old_rec.aei_information16, hr_api.g_varchar2) <>
688: nvl(p_rec.aei_information16, hr_api.g_varchar2) or
689: nvl(pe_aei_shd.g_old_rec.aei_information17, hr_api.g_varchar2) <>
690: nvl(p_rec.aei_information17, hr_api.g_varchar2) or
691: nvl(pe_aei_shd.g_old_rec.aei_information18, hr_api.g_varchar2) <>
692: nvl(p_rec.aei_information18, hr_api.g_varchar2) or
693: nvl(pe_aei_shd.g_old_rec.aei_information19, hr_api.g_varchar2) <>
694: nvl(p_rec.aei_information19, hr_api.g_varchar2) or
695: nvl(pe_aei_shd.g_old_rec.aei_information20, hr_api.g_varchar2) <>
689: nvl(pe_aei_shd.g_old_rec.aei_information17, hr_api.g_varchar2) <>
690: nvl(p_rec.aei_information17, hr_api.g_varchar2) or
691: nvl(pe_aei_shd.g_old_rec.aei_information18, hr_api.g_varchar2) <>
692: nvl(p_rec.aei_information18, hr_api.g_varchar2) or
693: nvl(pe_aei_shd.g_old_rec.aei_information19, hr_api.g_varchar2) <>
694: nvl(p_rec.aei_information19, hr_api.g_varchar2) or
695: nvl(pe_aei_shd.g_old_rec.aei_information20, hr_api.g_varchar2) <>
696: nvl(p_rec.aei_information20, hr_api.g_varchar2) or
697: nvl(pe_aei_shd.g_old_rec.aei_information21, hr_api.g_varchar2) <>
691: nvl(pe_aei_shd.g_old_rec.aei_information18, hr_api.g_varchar2) <>
692: nvl(p_rec.aei_information18, hr_api.g_varchar2) or
693: nvl(pe_aei_shd.g_old_rec.aei_information19, hr_api.g_varchar2) <>
694: nvl(p_rec.aei_information19, hr_api.g_varchar2) or
695: nvl(pe_aei_shd.g_old_rec.aei_information20, hr_api.g_varchar2) <>
696: nvl(p_rec.aei_information20, hr_api.g_varchar2) or
697: nvl(pe_aei_shd.g_old_rec.aei_information21, hr_api.g_varchar2) <>
698: nvl(p_rec.aei_information21, hr_api.g_varchar2) or
699: nvl(pe_aei_shd.g_old_rec.aei_information22, hr_api.g_varchar2) <>
693: nvl(pe_aei_shd.g_old_rec.aei_information19, hr_api.g_varchar2) <>
694: nvl(p_rec.aei_information19, hr_api.g_varchar2) or
695: nvl(pe_aei_shd.g_old_rec.aei_information20, hr_api.g_varchar2) <>
696: nvl(p_rec.aei_information20, hr_api.g_varchar2) or
697: nvl(pe_aei_shd.g_old_rec.aei_information21, hr_api.g_varchar2) <>
698: nvl(p_rec.aei_information21, hr_api.g_varchar2) or
699: nvl(pe_aei_shd.g_old_rec.aei_information22, hr_api.g_varchar2) <>
700: nvl(p_rec.aei_information22, hr_api.g_varchar2) or
701: nvl(pe_aei_shd.g_old_rec.aei_information23, hr_api.g_varchar2) <>
695: nvl(pe_aei_shd.g_old_rec.aei_information20, hr_api.g_varchar2) <>
696: nvl(p_rec.aei_information20, hr_api.g_varchar2) or
697: nvl(pe_aei_shd.g_old_rec.aei_information21, hr_api.g_varchar2) <>
698: nvl(p_rec.aei_information21, hr_api.g_varchar2) or
699: nvl(pe_aei_shd.g_old_rec.aei_information22, hr_api.g_varchar2) <>
700: nvl(p_rec.aei_information22, hr_api.g_varchar2) or
701: nvl(pe_aei_shd.g_old_rec.aei_information23, hr_api.g_varchar2) <>
702: nvl(p_rec.aei_information23, hr_api.g_varchar2) or
703: nvl(pe_aei_shd.g_old_rec.aei_information24, hr_api.g_varchar2) <>
697: nvl(pe_aei_shd.g_old_rec.aei_information21, hr_api.g_varchar2) <>
698: nvl(p_rec.aei_information21, hr_api.g_varchar2) or
699: nvl(pe_aei_shd.g_old_rec.aei_information22, hr_api.g_varchar2) <>
700: nvl(p_rec.aei_information22, hr_api.g_varchar2) or
701: nvl(pe_aei_shd.g_old_rec.aei_information23, hr_api.g_varchar2) <>
702: nvl(p_rec.aei_information23, hr_api.g_varchar2) or
703: nvl(pe_aei_shd.g_old_rec.aei_information24, hr_api.g_varchar2) <>
704: nvl(p_rec.aei_information24, hr_api.g_varchar2) or
705: nvl(pe_aei_shd.g_old_rec.aei_information25, hr_api.g_varchar2) <>
699: nvl(pe_aei_shd.g_old_rec.aei_information22, hr_api.g_varchar2) <>
700: nvl(p_rec.aei_information22, hr_api.g_varchar2) or
701: nvl(pe_aei_shd.g_old_rec.aei_information23, hr_api.g_varchar2) <>
702: nvl(p_rec.aei_information23, hr_api.g_varchar2) or
703: nvl(pe_aei_shd.g_old_rec.aei_information24, hr_api.g_varchar2) <>
704: nvl(p_rec.aei_information24, hr_api.g_varchar2) or
705: nvl(pe_aei_shd.g_old_rec.aei_information25, hr_api.g_varchar2) <>
706: nvl(p_rec.aei_information25, hr_api.g_varchar2) or
707: nvl(pe_aei_shd.g_old_rec.aei_information26, hr_api.g_varchar2) <>
701: nvl(pe_aei_shd.g_old_rec.aei_information23, hr_api.g_varchar2) <>
702: nvl(p_rec.aei_information23, hr_api.g_varchar2) or
703: nvl(pe_aei_shd.g_old_rec.aei_information24, hr_api.g_varchar2) <>
704: nvl(p_rec.aei_information24, hr_api.g_varchar2) or
705: nvl(pe_aei_shd.g_old_rec.aei_information25, hr_api.g_varchar2) <>
706: nvl(p_rec.aei_information25, hr_api.g_varchar2) or
707: nvl(pe_aei_shd.g_old_rec.aei_information26, hr_api.g_varchar2) <>
708: nvl(p_rec.aei_information26, hr_api.g_varchar2) or
709: nvl(pe_aei_shd.g_old_rec.aei_information27, hr_api.g_varchar2) <>
703: nvl(pe_aei_shd.g_old_rec.aei_information24, hr_api.g_varchar2) <>
704: nvl(p_rec.aei_information24, hr_api.g_varchar2) or
705: nvl(pe_aei_shd.g_old_rec.aei_information25, hr_api.g_varchar2) <>
706: nvl(p_rec.aei_information25, hr_api.g_varchar2) or
707: nvl(pe_aei_shd.g_old_rec.aei_information26, hr_api.g_varchar2) <>
708: nvl(p_rec.aei_information26, hr_api.g_varchar2) or
709: nvl(pe_aei_shd.g_old_rec.aei_information27, hr_api.g_varchar2) <>
710: nvl(p_rec.aei_information27, hr_api.g_varchar2) or
711: nvl(pe_aei_shd.g_old_rec.aei_information28, hr_api.g_varchar2) <>
705: nvl(pe_aei_shd.g_old_rec.aei_information25, hr_api.g_varchar2) <>
706: nvl(p_rec.aei_information25, hr_api.g_varchar2) or
707: nvl(pe_aei_shd.g_old_rec.aei_information26, hr_api.g_varchar2) <>
708: nvl(p_rec.aei_information26, hr_api.g_varchar2) or
709: nvl(pe_aei_shd.g_old_rec.aei_information27, hr_api.g_varchar2) <>
710: nvl(p_rec.aei_information27, hr_api.g_varchar2) or
711: nvl(pe_aei_shd.g_old_rec.aei_information28, hr_api.g_varchar2) <>
712: nvl(p_rec.aei_information28, hr_api.g_varchar2) or
713: nvl(pe_aei_shd.g_old_rec.aei_information29, hr_api.g_varchar2) <>
707: nvl(pe_aei_shd.g_old_rec.aei_information26, hr_api.g_varchar2) <>
708: nvl(p_rec.aei_information26, hr_api.g_varchar2) or
709: nvl(pe_aei_shd.g_old_rec.aei_information27, hr_api.g_varchar2) <>
710: nvl(p_rec.aei_information27, hr_api.g_varchar2) or
711: nvl(pe_aei_shd.g_old_rec.aei_information28, hr_api.g_varchar2) <>
712: nvl(p_rec.aei_information28, hr_api.g_varchar2) or
713: nvl(pe_aei_shd.g_old_rec.aei_information29, hr_api.g_varchar2) <>
714: nvl(p_rec.aei_information29, hr_api.g_varchar2) or
715: nvl(pe_aei_shd.g_old_rec.aei_information30, hr_api.g_varchar2) <>
709: nvl(pe_aei_shd.g_old_rec.aei_information27, hr_api.g_varchar2) <>
710: nvl(p_rec.aei_information27, hr_api.g_varchar2) or
711: nvl(pe_aei_shd.g_old_rec.aei_information28, hr_api.g_varchar2) <>
712: nvl(p_rec.aei_information28, hr_api.g_varchar2) or
713: nvl(pe_aei_shd.g_old_rec.aei_information29, hr_api.g_varchar2) <>
714: nvl(p_rec.aei_information29, hr_api.g_varchar2) or
715: nvl(pe_aei_shd.g_old_rec.aei_information30, hr_api.g_varchar2) <>
716: nvl(p_rec.aei_information30, hr_api.g_varchar2))
717: then
711: nvl(pe_aei_shd.g_old_rec.aei_information28, hr_api.g_varchar2) <>
712: nvl(p_rec.aei_information28, hr_api.g_varchar2) or
713: nvl(pe_aei_shd.g_old_rec.aei_information29, hr_api.g_varchar2) <>
714: nvl(p_rec.aei_information29, hr_api.g_varchar2) or
715: nvl(pe_aei_shd.g_old_rec.aei_information30, hr_api.g_varchar2) <>
716: nvl(p_rec.aei_information30, hr_api.g_varchar2))
717: then
718: --
719: hr_dflex_utility.ins_or_upd_descflex_attribs
789: --
790: -- ----------------------------------------------------------------------------
791: -- |---------------------------< insert_validate >----------------------------|
792: -- ----------------------------------------------------------------------------
793: Procedure insert_validate(p_rec in pe_aei_shd.g_rec_type) is
794: --
795: l_proc varchar2(72) := g_package||'insert_validate';
796: --
797: Begin
820: (p_information_type => p_rec.information_type
821: ,p_assignment_id => p_rec.assignment_id
822: );
823: --
824: if pe_aei_shd.g_called_from_form = FALSE then
825: --
826: hr_utility.set_location(l_proc, 10);
827: --
828: -- Call ddf procedure to validation Developer Descriptive Flexfields
842: --
843: -- ----------------------------------------------------------------------------
844: -- |---------------------------< update_validate >----------------------------|
845: -- ----------------------------------------------------------------------------
846: Procedure update_validate(p_rec in pe_aei_shd.g_rec_type) is
847: --
848: l_proc varchar2(72) := g_package||'update_validate';
849: --
850: Begin
861: chk_non_updateable_args (p_rec => p_rec);
862: --
863: hr_utility.set_location(l_proc, 15);
864: --
865: if pe_aei_shd.g_called_from_form = FALSE then
866: --
867: hr_utility.set_location(l_proc, 20);
868: --
869: -- Call ddf procedure to validate Developer Descriptive Flexfields
884: --
885: -- ----------------------------------------------------------------------------
886: -- |---------------------------< delete_validate >----------------------------|
887: -- ----------------------------------------------------------------------------
888: Procedure delete_validate(p_rec in pe_aei_shd.g_rec_type) is
889: --
890: l_proc varchar2(72) := g_package||'delete_validate';
891: --
892: Begin