DBA Data[Home] [Help]

APPS.PE_AEI_BUS dependencies on PE_AEI_SHD

Line 422: Procedure chk_non_updateable_args (p_rec in pe_aei_shd.g_rec_type) is

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

Line 434: if not pe_aei_shd.api_updating

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

Line 445: nvl(pe_aei_shd.g_old_rec.information_type, hr_api.g_varchar2) then

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: --

Line 453: nvl(pe_aei_shd.g_old_rec.assignment_id, hr_api.g_number) then

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: --

Line 502: (p_rec in pe_aei_shd.g_rec_type) is

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

Line 510: nvl(pe_aei_shd.g_old_rec.aei_attribute_category, hr_api.g_varchar2) <>

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) <>

Line 512: nvl(pe_aei_shd.g_old_rec.aei_attribute1, 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) <>

Line 514: nvl(pe_aei_shd.g_old_rec.aei_attribute2, 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) <>

Line 516: nvl(pe_aei_shd.g_old_rec.aei_attribute3, 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) <>

Line 518: nvl(pe_aei_shd.g_old_rec.aei_attribute4, 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) <>

Line 520: nvl(pe_aei_shd.g_old_rec.aei_attribute5, 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) <>

Line 522: nvl(pe_aei_shd.g_old_rec.aei_attribute6, 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) <>

Line 524: nvl(pe_aei_shd.g_old_rec.aei_attribute7, 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) <>

Line 526: nvl(pe_aei_shd.g_old_rec.aei_attribute8, 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) <>

Line 528: nvl(pe_aei_shd.g_old_rec.aei_attribute9, 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) <>

Line 530: nvl(pe_aei_shd.g_old_rec.aei_attribute10, 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) <>

Line 532: nvl(pe_aei_shd.g_old_rec.aei_attribute11, 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) <>

Line 534: nvl(pe_aei_shd.g_old_rec.aei_attribute12, 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) <>

Line 536: nvl(pe_aei_shd.g_old_rec.aei_attribute13, 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) <>

Line 538: nvl(pe_aei_shd.g_old_rec.aei_attribute14, 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) <>

Line 540: nvl(pe_aei_shd.g_old_rec.aei_attribute15, 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) <>

Line 542: nvl(pe_aei_shd.g_old_rec.aei_attribute16, 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) <>

Line 544: nvl(pe_aei_shd.g_old_rec.aei_attribute17, 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) <>

Line 546: nvl(pe_aei_shd.g_old_rec.aei_attribute18, 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) <>

Line 548: nvl(pe_aei_shd.g_old_rec.aei_attribute19, 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

Line 550: nvl(pe_aei_shd.g_old_rec.aei_attribute20, hr_api.g_varchar2) <>

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: --

Line 641: (p_rec in pe_aei_shd.g_rec_type) is

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: --

Line 655: nvl(pe_aei_shd.g_old_rec.aei_attribute_category, hr_api.g_varchar2) <>

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) <>

Line 657: nvl(pe_aei_shd.g_old_rec.aei_information1, 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) <>

Line 659: nvl(pe_aei_shd.g_old_rec.aei_information2, 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) <>

Line 661: nvl(pe_aei_shd.g_old_rec.aei_information3, 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) <>

Line 663: nvl(pe_aei_shd.g_old_rec.aei_information4, 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) <>

Line 665: nvl(pe_aei_shd.g_old_rec.aei_information5, 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) <>

Line 667: nvl(pe_aei_shd.g_old_rec.aei_information6, 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) <>

Line 669: nvl(pe_aei_shd.g_old_rec.aei_information7, 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) <>

Line 671: nvl(pe_aei_shd.g_old_rec.aei_information8, 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) <>

Line 673: nvl(pe_aei_shd.g_old_rec.aei_information9, 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) <>

Line 675: nvl(pe_aei_shd.g_old_rec.aei_information10, 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) <>

Line 677: nvl(pe_aei_shd.g_old_rec.aei_information11, 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) <>

Line 679: nvl(pe_aei_shd.g_old_rec.aei_information12, 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) <>

Line 681: nvl(pe_aei_shd.g_old_rec.aei_information13, 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) <>

Line 683: nvl(pe_aei_shd.g_old_rec.aei_information14, 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) <>

Line 685: nvl(pe_aei_shd.g_old_rec.aei_information15, 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) <>

Line 687: nvl(pe_aei_shd.g_old_rec.aei_information16, 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) <>

Line 689: nvl(pe_aei_shd.g_old_rec.aei_information17, 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) <>

Line 691: nvl(pe_aei_shd.g_old_rec.aei_information18, 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) <>

Line 693: nvl(pe_aei_shd.g_old_rec.aei_information19, 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) <>

Line 695: nvl(pe_aei_shd.g_old_rec.aei_information20, 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) <>

Line 697: nvl(pe_aei_shd.g_old_rec.aei_information21, 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) <>

Line 699: nvl(pe_aei_shd.g_old_rec.aei_information22, 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) <>

Line 701: nvl(pe_aei_shd.g_old_rec.aei_information23, 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) <>

Line 703: nvl(pe_aei_shd.g_old_rec.aei_information24, 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) <>

Line 705: nvl(pe_aei_shd.g_old_rec.aei_information25, 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) <>

Line 707: nvl(pe_aei_shd.g_old_rec.aei_information26, 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) <>

Line 709: nvl(pe_aei_shd.g_old_rec.aei_information27, 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) <>

Line 711: nvl(pe_aei_shd.g_old_rec.aei_information28, 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) <>

Line 713: nvl(pe_aei_shd.g_old_rec.aei_information29, 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

Line 715: nvl(pe_aei_shd.g_old_rec.aei_information30, hr_api.g_varchar2) <>

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

Line 793: Procedure insert_validate(p_rec in pe_aei_shd.g_rec_type) is

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

Line 824: if pe_aei_shd.g_called_from_form = FALSE then

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

Line 846: Procedure update_validate(p_rec in pe_aei_shd.g_rec_type) is

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

Line 865: if pe_aei_shd.g_called_from_form = FALSE then

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

Line 888: Procedure delete_validate(p_rec in pe_aei_shd.g_rec_type) is

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