eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_REI_BUS dependencies on PQH_REI_SHD

Line 431: Procedure chk_non_updateable_args (p_rec in pqh_rei_shd.g_rec_type) is

427: --
428: -- {End Of Comments}
429:
430: -- ----------------------------------------------------------------------------
431: Procedure chk_non_updateable_args (p_rec in pqh_rei_shd.g_rec_type) is
432:
433: --
434: l_proc varchar2(72) := g_package||'chk_non_updateable_args';
435: l_error exception;

Line 444: if not pqh_rei_shd.api_updating

440: --
441: -- Only proceed with validation if a row exists for
442: -- the current record in the HR Schema
443: --
444: if not pqh_rei_shd.api_updating
445: (p_role_extra_info_id => p_rec.role_extra_info_id
446: ,p_object_version_number => p_rec.object_version_number) then
447: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
448: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 455: nvl(pqh_rei_shd.g_old_rec.information_type, hr_api.g_varchar2) then

451: --
452: hr_utility.set_location(l_proc, 30);
453: --
454: if nvl(p_rec.information_type, hr_api.g_varchar2) <>
455: nvl(pqh_rei_shd.g_old_rec.information_type, hr_api.g_varchar2) then
456: l_argument := 'information_type';
457: raise l_error;
458: end if;
459: --

Line 463: nvl(pqh_rei_shd.g_old_rec.role_id, hr_api.g_number) then

459: --
460: hr_utility.set_location(l_proc, 40);
461: --
462: if nvl(p_rec.role_id, hr_api.g_number) <>
463: nvl(pqh_rei_shd.g_old_rec.role_id, hr_api.g_number) then
464: l_argument := 'role_id';
465: raise l_error;
466: end if;
467: --

Line 511: (p_rec in pqh_rei_shd.g_rec_type

507: -- Internal Row Handler Use Only.
508: --
509:
510: procedure chk_ddf
511: (p_rec in pqh_rei_shd.g_rec_type
512: ) is
513: --
514: l_proc varchar2(72) := g_package || 'chk_ddf';
515: --

Line 520: nvl(pqh_rei_shd.g_old_rec.information_type, hr_api.g_varchar2) <>

516: begin
517: hr_utility.set_location('Entering:'||l_proc,10);
518: --
519: if ((p_rec.role_extra_info_id is not null) and (
520: nvl(pqh_rei_shd.g_old_rec.information_type, hr_api.g_varchar2) <>
521: nvl(p_rec.information_type, hr_api.g_varchar2) or
522: nvl(pqh_rei_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
523: nvl(p_rec.information_category, hr_api.g_varchar2) or
524: nvl(pqh_rei_shd.g_old_rec.information1, hr_api.g_varchar2) <>

Line 522: nvl(pqh_rei_shd.g_old_rec.information_category, hr_api.g_varchar2) <>

518: --
519: if ((p_rec.role_extra_info_id is not null) and (
520: nvl(pqh_rei_shd.g_old_rec.information_type, hr_api.g_varchar2) <>
521: nvl(p_rec.information_type, hr_api.g_varchar2) or
522: nvl(pqh_rei_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
523: nvl(p_rec.information_category, hr_api.g_varchar2) or
524: nvl(pqh_rei_shd.g_old_rec.information1, hr_api.g_varchar2) <>
525: nvl(p_rec.information1, hr_api.g_varchar2) or
526: nvl(pqh_rei_shd.g_old_rec.information2, hr_api.g_varchar2) <>

Line 524: nvl(pqh_rei_shd.g_old_rec.information1, hr_api.g_varchar2) <>

520: nvl(pqh_rei_shd.g_old_rec.information_type, hr_api.g_varchar2) <>
521: nvl(p_rec.information_type, hr_api.g_varchar2) or
522: nvl(pqh_rei_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
523: nvl(p_rec.information_category, hr_api.g_varchar2) or
524: nvl(pqh_rei_shd.g_old_rec.information1, hr_api.g_varchar2) <>
525: nvl(p_rec.information1, hr_api.g_varchar2) or
526: nvl(pqh_rei_shd.g_old_rec.information2, hr_api.g_varchar2) <>
527: nvl(p_rec.information2, hr_api.g_varchar2) or
528: nvl(pqh_rei_shd.g_old_rec.information3, hr_api.g_varchar2) <>

Line 526: nvl(pqh_rei_shd.g_old_rec.information2, hr_api.g_varchar2) <>

522: nvl(pqh_rei_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
523: nvl(p_rec.information_category, hr_api.g_varchar2) or
524: nvl(pqh_rei_shd.g_old_rec.information1, hr_api.g_varchar2) <>
525: nvl(p_rec.information1, hr_api.g_varchar2) or
526: nvl(pqh_rei_shd.g_old_rec.information2, hr_api.g_varchar2) <>
527: nvl(p_rec.information2, hr_api.g_varchar2) or
528: nvl(pqh_rei_shd.g_old_rec.information3, hr_api.g_varchar2) <>
529: nvl(p_rec.information3, hr_api.g_varchar2) or
530: nvl(pqh_rei_shd.g_old_rec.information4, hr_api.g_varchar2) <>

Line 528: nvl(pqh_rei_shd.g_old_rec.information3, hr_api.g_varchar2) <>

524: nvl(pqh_rei_shd.g_old_rec.information1, hr_api.g_varchar2) <>
525: nvl(p_rec.information1, hr_api.g_varchar2) or
526: nvl(pqh_rei_shd.g_old_rec.information2, hr_api.g_varchar2) <>
527: nvl(p_rec.information2, hr_api.g_varchar2) or
528: nvl(pqh_rei_shd.g_old_rec.information3, hr_api.g_varchar2) <>
529: nvl(p_rec.information3, hr_api.g_varchar2) or
530: nvl(pqh_rei_shd.g_old_rec.information4, hr_api.g_varchar2) <>
531: nvl(p_rec.information4, hr_api.g_varchar2) or
532: nvl(pqh_rei_shd.g_old_rec.information5, hr_api.g_varchar2) <>

Line 530: nvl(pqh_rei_shd.g_old_rec.information4, hr_api.g_varchar2) <>

526: nvl(pqh_rei_shd.g_old_rec.information2, hr_api.g_varchar2) <>
527: nvl(p_rec.information2, hr_api.g_varchar2) or
528: nvl(pqh_rei_shd.g_old_rec.information3, hr_api.g_varchar2) <>
529: nvl(p_rec.information3, hr_api.g_varchar2) or
530: nvl(pqh_rei_shd.g_old_rec.information4, hr_api.g_varchar2) <>
531: nvl(p_rec.information4, hr_api.g_varchar2) or
532: nvl(pqh_rei_shd.g_old_rec.information5, hr_api.g_varchar2) <>
533: nvl(p_rec.information5, hr_api.g_varchar2) or
534: nvl(pqh_rei_shd.g_old_rec.information6, hr_api.g_varchar2) <>

Line 532: nvl(pqh_rei_shd.g_old_rec.information5, hr_api.g_varchar2) <>

528: nvl(pqh_rei_shd.g_old_rec.information3, hr_api.g_varchar2) <>
529: nvl(p_rec.information3, hr_api.g_varchar2) or
530: nvl(pqh_rei_shd.g_old_rec.information4, hr_api.g_varchar2) <>
531: nvl(p_rec.information4, hr_api.g_varchar2) or
532: nvl(pqh_rei_shd.g_old_rec.information5, hr_api.g_varchar2) <>
533: nvl(p_rec.information5, hr_api.g_varchar2) or
534: nvl(pqh_rei_shd.g_old_rec.information6, hr_api.g_varchar2) <>
535: nvl(p_rec.information6, hr_api.g_varchar2) or
536: nvl(pqh_rei_shd.g_old_rec.information7, hr_api.g_varchar2) <>

Line 534: nvl(pqh_rei_shd.g_old_rec.information6, hr_api.g_varchar2) <>

530: nvl(pqh_rei_shd.g_old_rec.information4, hr_api.g_varchar2) <>
531: nvl(p_rec.information4, hr_api.g_varchar2) or
532: nvl(pqh_rei_shd.g_old_rec.information5, hr_api.g_varchar2) <>
533: nvl(p_rec.information5, hr_api.g_varchar2) or
534: nvl(pqh_rei_shd.g_old_rec.information6, hr_api.g_varchar2) <>
535: nvl(p_rec.information6, hr_api.g_varchar2) or
536: nvl(pqh_rei_shd.g_old_rec.information7, hr_api.g_varchar2) <>
537: nvl(p_rec.information7, hr_api.g_varchar2) or
538: nvl(pqh_rei_shd.g_old_rec.information8, hr_api.g_varchar2) <>

Line 536: nvl(pqh_rei_shd.g_old_rec.information7, hr_api.g_varchar2) <>

532: nvl(pqh_rei_shd.g_old_rec.information5, hr_api.g_varchar2) <>
533: nvl(p_rec.information5, hr_api.g_varchar2) or
534: nvl(pqh_rei_shd.g_old_rec.information6, hr_api.g_varchar2) <>
535: nvl(p_rec.information6, hr_api.g_varchar2) or
536: nvl(pqh_rei_shd.g_old_rec.information7, hr_api.g_varchar2) <>
537: nvl(p_rec.information7, hr_api.g_varchar2) or
538: nvl(pqh_rei_shd.g_old_rec.information8, hr_api.g_varchar2) <>
539: nvl(p_rec.information8, hr_api.g_varchar2) or
540: nvl(pqh_rei_shd.g_old_rec.information9, hr_api.g_varchar2) <>

Line 538: nvl(pqh_rei_shd.g_old_rec.information8, hr_api.g_varchar2) <>

534: nvl(pqh_rei_shd.g_old_rec.information6, hr_api.g_varchar2) <>
535: nvl(p_rec.information6, hr_api.g_varchar2) or
536: nvl(pqh_rei_shd.g_old_rec.information7, hr_api.g_varchar2) <>
537: nvl(p_rec.information7, hr_api.g_varchar2) or
538: nvl(pqh_rei_shd.g_old_rec.information8, hr_api.g_varchar2) <>
539: nvl(p_rec.information8, hr_api.g_varchar2) or
540: nvl(pqh_rei_shd.g_old_rec.information9, hr_api.g_varchar2) <>
541: nvl(p_rec.information9, hr_api.g_varchar2) or
542: nvl(pqh_rei_shd.g_old_rec.information10, hr_api.g_varchar2) <>

Line 540: nvl(pqh_rei_shd.g_old_rec.information9, hr_api.g_varchar2) <>

536: nvl(pqh_rei_shd.g_old_rec.information7, hr_api.g_varchar2) <>
537: nvl(p_rec.information7, hr_api.g_varchar2) or
538: nvl(pqh_rei_shd.g_old_rec.information8, hr_api.g_varchar2) <>
539: nvl(p_rec.information8, hr_api.g_varchar2) or
540: nvl(pqh_rei_shd.g_old_rec.information9, hr_api.g_varchar2) <>
541: nvl(p_rec.information9, hr_api.g_varchar2) or
542: nvl(pqh_rei_shd.g_old_rec.information10, hr_api.g_varchar2) <>
543: nvl(p_rec.information10, hr_api.g_varchar2) or
544: nvl(pqh_rei_shd.g_old_rec.information11, hr_api.g_varchar2) <>

Line 542: nvl(pqh_rei_shd.g_old_rec.information10, hr_api.g_varchar2) <>

538: nvl(pqh_rei_shd.g_old_rec.information8, hr_api.g_varchar2) <>
539: nvl(p_rec.information8, hr_api.g_varchar2) or
540: nvl(pqh_rei_shd.g_old_rec.information9, hr_api.g_varchar2) <>
541: nvl(p_rec.information9, hr_api.g_varchar2) or
542: nvl(pqh_rei_shd.g_old_rec.information10, hr_api.g_varchar2) <>
543: nvl(p_rec.information10, hr_api.g_varchar2) or
544: nvl(pqh_rei_shd.g_old_rec.information11, hr_api.g_varchar2) <>
545: nvl(p_rec.information11, hr_api.g_varchar2) or
546: nvl(pqh_rei_shd.g_old_rec.information12, hr_api.g_varchar2) <>

Line 544: nvl(pqh_rei_shd.g_old_rec.information11, hr_api.g_varchar2) <>

540: nvl(pqh_rei_shd.g_old_rec.information9, hr_api.g_varchar2) <>
541: nvl(p_rec.information9, hr_api.g_varchar2) or
542: nvl(pqh_rei_shd.g_old_rec.information10, hr_api.g_varchar2) <>
543: nvl(p_rec.information10, hr_api.g_varchar2) or
544: nvl(pqh_rei_shd.g_old_rec.information11, hr_api.g_varchar2) <>
545: nvl(p_rec.information11, hr_api.g_varchar2) or
546: nvl(pqh_rei_shd.g_old_rec.information12, hr_api.g_varchar2) <>
547: nvl(p_rec.information12, hr_api.g_varchar2) or
548: nvl(pqh_rei_shd.g_old_rec.information13, hr_api.g_varchar2) <>

Line 546: nvl(pqh_rei_shd.g_old_rec.information12, hr_api.g_varchar2) <>

542: nvl(pqh_rei_shd.g_old_rec.information10, hr_api.g_varchar2) <>
543: nvl(p_rec.information10, hr_api.g_varchar2) or
544: nvl(pqh_rei_shd.g_old_rec.information11, hr_api.g_varchar2) <>
545: nvl(p_rec.information11, hr_api.g_varchar2) or
546: nvl(pqh_rei_shd.g_old_rec.information12, hr_api.g_varchar2) <>
547: nvl(p_rec.information12, hr_api.g_varchar2) or
548: nvl(pqh_rei_shd.g_old_rec.information13, hr_api.g_varchar2) <>
549: nvl(p_rec.information13, hr_api.g_varchar2) or
550: nvl(pqh_rei_shd.g_old_rec.information14, hr_api.g_varchar2) <>

Line 548: nvl(pqh_rei_shd.g_old_rec.information13, hr_api.g_varchar2) <>

544: nvl(pqh_rei_shd.g_old_rec.information11, hr_api.g_varchar2) <>
545: nvl(p_rec.information11, hr_api.g_varchar2) or
546: nvl(pqh_rei_shd.g_old_rec.information12, hr_api.g_varchar2) <>
547: nvl(p_rec.information12, hr_api.g_varchar2) or
548: nvl(pqh_rei_shd.g_old_rec.information13, hr_api.g_varchar2) <>
549: nvl(p_rec.information13, hr_api.g_varchar2) or
550: nvl(pqh_rei_shd.g_old_rec.information14, hr_api.g_varchar2) <>
551: nvl(p_rec.information14, hr_api.g_varchar2) or
552: nvl(pqh_rei_shd.g_old_rec.information15, hr_api.g_varchar2) <>

Line 550: nvl(pqh_rei_shd.g_old_rec.information14, hr_api.g_varchar2) <>

546: nvl(pqh_rei_shd.g_old_rec.information12, hr_api.g_varchar2) <>
547: nvl(p_rec.information12, hr_api.g_varchar2) or
548: nvl(pqh_rei_shd.g_old_rec.information13, hr_api.g_varchar2) <>
549: nvl(p_rec.information13, hr_api.g_varchar2) or
550: nvl(pqh_rei_shd.g_old_rec.information14, hr_api.g_varchar2) <>
551: nvl(p_rec.information14, hr_api.g_varchar2) or
552: nvl(pqh_rei_shd.g_old_rec.information15, hr_api.g_varchar2) <>
553: nvl(p_rec.information15, hr_api.g_varchar2) or
554: nvl(pqh_rei_shd.g_old_rec.information16, hr_api.g_varchar2) <>

Line 552: nvl(pqh_rei_shd.g_old_rec.information15, hr_api.g_varchar2) <>

548: nvl(pqh_rei_shd.g_old_rec.information13, hr_api.g_varchar2) <>
549: nvl(p_rec.information13, hr_api.g_varchar2) or
550: nvl(pqh_rei_shd.g_old_rec.information14, hr_api.g_varchar2) <>
551: nvl(p_rec.information14, hr_api.g_varchar2) or
552: nvl(pqh_rei_shd.g_old_rec.information15, hr_api.g_varchar2) <>
553: nvl(p_rec.information15, hr_api.g_varchar2) or
554: nvl(pqh_rei_shd.g_old_rec.information16, hr_api.g_varchar2) <>
555: nvl(p_rec.information16, hr_api.g_varchar2) or
556: nvl(pqh_rei_shd.g_old_rec.information17, hr_api.g_varchar2) <>

Line 554: nvl(pqh_rei_shd.g_old_rec.information16, hr_api.g_varchar2) <>

550: nvl(pqh_rei_shd.g_old_rec.information14, hr_api.g_varchar2) <>
551: nvl(p_rec.information14, hr_api.g_varchar2) or
552: nvl(pqh_rei_shd.g_old_rec.information15, hr_api.g_varchar2) <>
553: nvl(p_rec.information15, hr_api.g_varchar2) or
554: nvl(pqh_rei_shd.g_old_rec.information16, hr_api.g_varchar2) <>
555: nvl(p_rec.information16, hr_api.g_varchar2) or
556: nvl(pqh_rei_shd.g_old_rec.information17, hr_api.g_varchar2) <>
557: nvl(p_rec.information17, hr_api.g_varchar2) or
558: nvl(pqh_rei_shd.g_old_rec.information18, hr_api.g_varchar2) <>

Line 556: nvl(pqh_rei_shd.g_old_rec.information17, hr_api.g_varchar2) <>

552: nvl(pqh_rei_shd.g_old_rec.information15, hr_api.g_varchar2) <>
553: nvl(p_rec.information15, hr_api.g_varchar2) or
554: nvl(pqh_rei_shd.g_old_rec.information16, hr_api.g_varchar2) <>
555: nvl(p_rec.information16, hr_api.g_varchar2) or
556: nvl(pqh_rei_shd.g_old_rec.information17, hr_api.g_varchar2) <>
557: nvl(p_rec.information17, hr_api.g_varchar2) or
558: nvl(pqh_rei_shd.g_old_rec.information18, hr_api.g_varchar2) <>
559: nvl(p_rec.information18, hr_api.g_varchar2) or
560: nvl(pqh_rei_shd.g_old_rec.information19, hr_api.g_varchar2) <>

Line 558: nvl(pqh_rei_shd.g_old_rec.information18, hr_api.g_varchar2) <>

554: nvl(pqh_rei_shd.g_old_rec.information16, hr_api.g_varchar2) <>
555: nvl(p_rec.information16, hr_api.g_varchar2) or
556: nvl(pqh_rei_shd.g_old_rec.information17, hr_api.g_varchar2) <>
557: nvl(p_rec.information17, hr_api.g_varchar2) or
558: nvl(pqh_rei_shd.g_old_rec.information18, hr_api.g_varchar2) <>
559: nvl(p_rec.information18, hr_api.g_varchar2) or
560: nvl(pqh_rei_shd.g_old_rec.information19, hr_api.g_varchar2) <>
561: nvl(p_rec.information19, hr_api.g_varchar2) or
562: nvl(pqh_rei_shd.g_old_rec.information20, hr_api.g_varchar2) <>

Line 560: nvl(pqh_rei_shd.g_old_rec.information19, hr_api.g_varchar2) <>

556: nvl(pqh_rei_shd.g_old_rec.information17, hr_api.g_varchar2) <>
557: nvl(p_rec.information17, hr_api.g_varchar2) or
558: nvl(pqh_rei_shd.g_old_rec.information18, hr_api.g_varchar2) <>
559: nvl(p_rec.information18, hr_api.g_varchar2) or
560: nvl(pqh_rei_shd.g_old_rec.information19, hr_api.g_varchar2) <>
561: nvl(p_rec.information19, hr_api.g_varchar2) or
562: nvl(pqh_rei_shd.g_old_rec.information20, hr_api.g_varchar2) <>
563: nvl(p_rec.information20, hr_api.g_varchar2) or
564: nvl(pqh_rei_shd.g_old_rec.information21, hr_api.g_varchar2) <>

Line 562: nvl(pqh_rei_shd.g_old_rec.information20, hr_api.g_varchar2) <>

558: nvl(pqh_rei_shd.g_old_rec.information18, hr_api.g_varchar2) <>
559: nvl(p_rec.information18, hr_api.g_varchar2) or
560: nvl(pqh_rei_shd.g_old_rec.information19, hr_api.g_varchar2) <>
561: nvl(p_rec.information19, hr_api.g_varchar2) or
562: nvl(pqh_rei_shd.g_old_rec.information20, hr_api.g_varchar2) <>
563: nvl(p_rec.information20, hr_api.g_varchar2) or
564: nvl(pqh_rei_shd.g_old_rec.information21, hr_api.g_varchar2) <>
565: nvl(p_rec.information21, hr_api.g_varchar2) or
566: nvl(pqh_rei_shd.g_old_rec.information22, hr_api.g_varchar2) <>

Line 564: nvl(pqh_rei_shd.g_old_rec.information21, hr_api.g_varchar2) <>

560: nvl(pqh_rei_shd.g_old_rec.information19, hr_api.g_varchar2) <>
561: nvl(p_rec.information19, hr_api.g_varchar2) or
562: nvl(pqh_rei_shd.g_old_rec.information20, hr_api.g_varchar2) <>
563: nvl(p_rec.information20, hr_api.g_varchar2) or
564: nvl(pqh_rei_shd.g_old_rec.information21, hr_api.g_varchar2) <>
565: nvl(p_rec.information21, hr_api.g_varchar2) or
566: nvl(pqh_rei_shd.g_old_rec.information22, hr_api.g_varchar2) <>
567: nvl(p_rec.information22, hr_api.g_varchar2) or
568: nvl(pqh_rei_shd.g_old_rec.information23, hr_api.g_varchar2) <>

Line 566: nvl(pqh_rei_shd.g_old_rec.information22, hr_api.g_varchar2) <>

562: nvl(pqh_rei_shd.g_old_rec.information20, hr_api.g_varchar2) <>
563: nvl(p_rec.information20, hr_api.g_varchar2) or
564: nvl(pqh_rei_shd.g_old_rec.information21, hr_api.g_varchar2) <>
565: nvl(p_rec.information21, hr_api.g_varchar2) or
566: nvl(pqh_rei_shd.g_old_rec.information22, hr_api.g_varchar2) <>
567: nvl(p_rec.information22, hr_api.g_varchar2) or
568: nvl(pqh_rei_shd.g_old_rec.information23, hr_api.g_varchar2) <>
569: nvl(p_rec.information23, hr_api.g_varchar2) or
570: nvl(pqh_rei_shd.g_old_rec.information24, hr_api.g_varchar2) <>

Line 568: nvl(pqh_rei_shd.g_old_rec.information23, hr_api.g_varchar2) <>

564: nvl(pqh_rei_shd.g_old_rec.information21, hr_api.g_varchar2) <>
565: nvl(p_rec.information21, hr_api.g_varchar2) or
566: nvl(pqh_rei_shd.g_old_rec.information22, hr_api.g_varchar2) <>
567: nvl(p_rec.information22, hr_api.g_varchar2) or
568: nvl(pqh_rei_shd.g_old_rec.information23, hr_api.g_varchar2) <>
569: nvl(p_rec.information23, hr_api.g_varchar2) or
570: nvl(pqh_rei_shd.g_old_rec.information24, hr_api.g_varchar2) <>
571: nvl(p_rec.information24, hr_api.g_varchar2) or
572: nvl(pqh_rei_shd.g_old_rec.information25, hr_api.g_varchar2) <>

Line 570: nvl(pqh_rei_shd.g_old_rec.information24, hr_api.g_varchar2) <>

566: nvl(pqh_rei_shd.g_old_rec.information22, hr_api.g_varchar2) <>
567: nvl(p_rec.information22, hr_api.g_varchar2) or
568: nvl(pqh_rei_shd.g_old_rec.information23, hr_api.g_varchar2) <>
569: nvl(p_rec.information23, hr_api.g_varchar2) or
570: nvl(pqh_rei_shd.g_old_rec.information24, hr_api.g_varchar2) <>
571: nvl(p_rec.information24, hr_api.g_varchar2) or
572: nvl(pqh_rei_shd.g_old_rec.information25, hr_api.g_varchar2) <>
573: nvl(p_rec.information25, hr_api.g_varchar2) or
574: nvl(pqh_rei_shd.g_old_rec.information26, hr_api.g_varchar2) <>

Line 572: nvl(pqh_rei_shd.g_old_rec.information25, hr_api.g_varchar2) <>

568: nvl(pqh_rei_shd.g_old_rec.information23, hr_api.g_varchar2) <>
569: nvl(p_rec.information23, hr_api.g_varchar2) or
570: nvl(pqh_rei_shd.g_old_rec.information24, hr_api.g_varchar2) <>
571: nvl(p_rec.information24, hr_api.g_varchar2) or
572: nvl(pqh_rei_shd.g_old_rec.information25, hr_api.g_varchar2) <>
573: nvl(p_rec.information25, hr_api.g_varchar2) or
574: nvl(pqh_rei_shd.g_old_rec.information26, hr_api.g_varchar2) <>
575: nvl(p_rec.information26, hr_api.g_varchar2) or
576: nvl(pqh_rei_shd.g_old_rec.information27, hr_api.g_varchar2) <>

Line 574: nvl(pqh_rei_shd.g_old_rec.information26, hr_api.g_varchar2) <>

570: nvl(pqh_rei_shd.g_old_rec.information24, hr_api.g_varchar2) <>
571: nvl(p_rec.information24, hr_api.g_varchar2) or
572: nvl(pqh_rei_shd.g_old_rec.information25, hr_api.g_varchar2) <>
573: nvl(p_rec.information25, hr_api.g_varchar2) or
574: nvl(pqh_rei_shd.g_old_rec.information26, hr_api.g_varchar2) <>
575: nvl(p_rec.information26, hr_api.g_varchar2) or
576: nvl(pqh_rei_shd.g_old_rec.information27, hr_api.g_varchar2) <>
577: nvl(p_rec.information27, hr_api.g_varchar2) or
578: nvl(pqh_rei_shd.g_old_rec.information28, hr_api.g_varchar2) <>

Line 576: nvl(pqh_rei_shd.g_old_rec.information27, hr_api.g_varchar2) <>

572: nvl(pqh_rei_shd.g_old_rec.information25, hr_api.g_varchar2) <>
573: nvl(p_rec.information25, hr_api.g_varchar2) or
574: nvl(pqh_rei_shd.g_old_rec.information26, hr_api.g_varchar2) <>
575: nvl(p_rec.information26, hr_api.g_varchar2) or
576: nvl(pqh_rei_shd.g_old_rec.information27, hr_api.g_varchar2) <>
577: nvl(p_rec.information27, hr_api.g_varchar2) or
578: nvl(pqh_rei_shd.g_old_rec.information28, hr_api.g_varchar2) <>
579: nvl(p_rec.information28, hr_api.g_varchar2) or
580: nvl(pqh_rei_shd.g_old_rec.information29, hr_api.g_varchar2) <>

Line 578: nvl(pqh_rei_shd.g_old_rec.information28, hr_api.g_varchar2) <>

574: nvl(pqh_rei_shd.g_old_rec.information26, hr_api.g_varchar2) <>
575: nvl(p_rec.information26, hr_api.g_varchar2) or
576: nvl(pqh_rei_shd.g_old_rec.information27, hr_api.g_varchar2) <>
577: nvl(p_rec.information27, hr_api.g_varchar2) or
578: nvl(pqh_rei_shd.g_old_rec.information28, hr_api.g_varchar2) <>
579: nvl(p_rec.information28, hr_api.g_varchar2) or
580: nvl(pqh_rei_shd.g_old_rec.information29, hr_api.g_varchar2) <>
581: nvl(p_rec.information29, hr_api.g_varchar2) or
582: nvl(pqh_rei_shd.g_old_rec.information30, hr_api.g_varchar2) <>

Line 580: nvl(pqh_rei_shd.g_old_rec.information29, hr_api.g_varchar2) <>

576: nvl(pqh_rei_shd.g_old_rec.information27, hr_api.g_varchar2) <>
577: nvl(p_rec.information27, hr_api.g_varchar2) or
578: nvl(pqh_rei_shd.g_old_rec.information28, hr_api.g_varchar2) <>
579: nvl(p_rec.information28, hr_api.g_varchar2) or
580: nvl(pqh_rei_shd.g_old_rec.information29, hr_api.g_varchar2) <>
581: nvl(p_rec.information29, hr_api.g_varchar2) or
582: nvl(pqh_rei_shd.g_old_rec.information30, hr_api.g_varchar2) <>
583: nvl(p_rec.information30, hr_api.g_varchar2) )) or
584: (p_rec.role_extra_info_id is null) then

Line 582: nvl(pqh_rei_shd.g_old_rec.information30, hr_api.g_varchar2) <>

578: nvl(pqh_rei_shd.g_old_rec.information28, hr_api.g_varchar2) <>
579: nvl(p_rec.information28, hr_api.g_varchar2) or
580: nvl(pqh_rei_shd.g_old_rec.information29, hr_api.g_varchar2) <>
581: nvl(p_rec.information29, hr_api.g_varchar2) or
582: nvl(pqh_rei_shd.g_old_rec.information30, hr_api.g_varchar2) <>
583: nvl(p_rec.information30, hr_api.g_varchar2) )) or
584: (p_rec.role_extra_info_id is null) then
585: --
586: -- Only execute the validation if absolutely necessary:

Line 690: (p_rec in pqh_rei_shd.g_rec_type

686: -- Internal Row Handler Use Only.
687: --
688: -- ----------------------------------------------------------------------------
689: procedure chk_df
690: (p_rec in pqh_rei_shd.g_rec_type
691: ) is
692: --
693: l_proc varchar2(72) := g_package || 'chk_df';
694: --

Line 699: nvl(pqh_rei_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

695: begin
696: hr_utility.set_location('Entering:'||l_proc,10);
697: --
698: if ((p_rec.role_extra_info_id is not null) and (
699: nvl(pqh_rei_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
700: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
701: nvl(pqh_rei_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
702: nvl(p_rec.attribute1, hr_api.g_varchar2) or
703: nvl(pqh_rei_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

Line 701: nvl(pqh_rei_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

697: --
698: if ((p_rec.role_extra_info_id is not null) and (
699: nvl(pqh_rei_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
700: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
701: nvl(pqh_rei_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
702: nvl(p_rec.attribute1, hr_api.g_varchar2) or
703: nvl(pqh_rei_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
704: nvl(p_rec.attribute2, hr_api.g_varchar2) or
705: nvl(pqh_rei_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

Line 703: nvl(pqh_rei_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

699: nvl(pqh_rei_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
700: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
701: nvl(pqh_rei_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
702: nvl(p_rec.attribute1, hr_api.g_varchar2) or
703: nvl(pqh_rei_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
704: nvl(p_rec.attribute2, hr_api.g_varchar2) or
705: nvl(pqh_rei_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
706: nvl(p_rec.attribute3, hr_api.g_varchar2) or
707: nvl(pqh_rei_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

Line 705: nvl(pqh_rei_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

701: nvl(pqh_rei_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
702: nvl(p_rec.attribute1, hr_api.g_varchar2) or
703: nvl(pqh_rei_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
704: nvl(p_rec.attribute2, hr_api.g_varchar2) or
705: nvl(pqh_rei_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
706: nvl(p_rec.attribute3, hr_api.g_varchar2) or
707: nvl(pqh_rei_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
708: nvl(p_rec.attribute4, hr_api.g_varchar2) or
709: nvl(pqh_rei_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

Line 707: nvl(pqh_rei_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

703: nvl(pqh_rei_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
704: nvl(p_rec.attribute2, hr_api.g_varchar2) or
705: nvl(pqh_rei_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
706: nvl(p_rec.attribute3, hr_api.g_varchar2) or
707: nvl(pqh_rei_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
708: nvl(p_rec.attribute4, hr_api.g_varchar2) or
709: nvl(pqh_rei_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
710: nvl(p_rec.attribute5, hr_api.g_varchar2) or
711: nvl(pqh_rei_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

Line 709: nvl(pqh_rei_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

705: nvl(pqh_rei_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
706: nvl(p_rec.attribute3, hr_api.g_varchar2) or
707: nvl(pqh_rei_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
708: nvl(p_rec.attribute4, hr_api.g_varchar2) or
709: nvl(pqh_rei_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
710: nvl(p_rec.attribute5, hr_api.g_varchar2) or
711: nvl(pqh_rei_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
712: nvl(p_rec.attribute6, hr_api.g_varchar2) or
713: nvl(pqh_rei_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

Line 711: nvl(pqh_rei_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

707: nvl(pqh_rei_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
708: nvl(p_rec.attribute4, hr_api.g_varchar2) or
709: nvl(pqh_rei_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
710: nvl(p_rec.attribute5, hr_api.g_varchar2) or
711: nvl(pqh_rei_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
712: nvl(p_rec.attribute6, hr_api.g_varchar2) or
713: nvl(pqh_rei_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
714: nvl(p_rec.attribute7, hr_api.g_varchar2) or
715: nvl(pqh_rei_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

Line 713: nvl(pqh_rei_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

709: nvl(pqh_rei_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
710: nvl(p_rec.attribute5, hr_api.g_varchar2) or
711: nvl(pqh_rei_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
712: nvl(p_rec.attribute6, hr_api.g_varchar2) or
713: nvl(pqh_rei_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
714: nvl(p_rec.attribute7, hr_api.g_varchar2) or
715: nvl(pqh_rei_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
716: nvl(p_rec.attribute8, hr_api.g_varchar2) or
717: nvl(pqh_rei_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

Line 715: nvl(pqh_rei_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

711: nvl(pqh_rei_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
712: nvl(p_rec.attribute6, hr_api.g_varchar2) or
713: nvl(pqh_rei_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
714: nvl(p_rec.attribute7, hr_api.g_varchar2) or
715: nvl(pqh_rei_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
716: nvl(p_rec.attribute8, hr_api.g_varchar2) or
717: nvl(pqh_rei_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
718: nvl(p_rec.attribute9, hr_api.g_varchar2) or
719: nvl(pqh_rei_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

Line 717: nvl(pqh_rei_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

713: nvl(pqh_rei_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
714: nvl(p_rec.attribute7, hr_api.g_varchar2) or
715: nvl(pqh_rei_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
716: nvl(p_rec.attribute8, hr_api.g_varchar2) or
717: nvl(pqh_rei_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
718: nvl(p_rec.attribute9, hr_api.g_varchar2) or
719: nvl(pqh_rei_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
720: nvl(p_rec.attribute10, hr_api.g_varchar2) or
721: nvl(pqh_rei_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

Line 719: nvl(pqh_rei_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

715: nvl(pqh_rei_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
716: nvl(p_rec.attribute8, hr_api.g_varchar2) or
717: nvl(pqh_rei_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
718: nvl(p_rec.attribute9, hr_api.g_varchar2) or
719: nvl(pqh_rei_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
720: nvl(p_rec.attribute10, hr_api.g_varchar2) or
721: nvl(pqh_rei_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
722: nvl(p_rec.attribute11, hr_api.g_varchar2) or
723: nvl(pqh_rei_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

Line 721: nvl(pqh_rei_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

717: nvl(pqh_rei_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
718: nvl(p_rec.attribute9, hr_api.g_varchar2) or
719: nvl(pqh_rei_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
720: nvl(p_rec.attribute10, hr_api.g_varchar2) or
721: nvl(pqh_rei_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
722: nvl(p_rec.attribute11, hr_api.g_varchar2) or
723: nvl(pqh_rei_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
724: nvl(p_rec.attribute12, hr_api.g_varchar2) or
725: nvl(pqh_rei_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

Line 723: nvl(pqh_rei_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

719: nvl(pqh_rei_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
720: nvl(p_rec.attribute10, hr_api.g_varchar2) or
721: nvl(pqh_rei_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
722: nvl(p_rec.attribute11, hr_api.g_varchar2) or
723: nvl(pqh_rei_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
724: nvl(p_rec.attribute12, hr_api.g_varchar2) or
725: nvl(pqh_rei_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
726: nvl(p_rec.attribute13, hr_api.g_varchar2) or
727: nvl(pqh_rei_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

Line 725: nvl(pqh_rei_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

721: nvl(pqh_rei_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
722: nvl(p_rec.attribute11, hr_api.g_varchar2) or
723: nvl(pqh_rei_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
724: nvl(p_rec.attribute12, hr_api.g_varchar2) or
725: nvl(pqh_rei_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
726: nvl(p_rec.attribute13, hr_api.g_varchar2) or
727: nvl(pqh_rei_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
728: nvl(p_rec.attribute14, hr_api.g_varchar2) or
729: nvl(pqh_rei_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

Line 727: nvl(pqh_rei_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

723: nvl(pqh_rei_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
724: nvl(p_rec.attribute12, hr_api.g_varchar2) or
725: nvl(pqh_rei_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
726: nvl(p_rec.attribute13, hr_api.g_varchar2) or
727: nvl(pqh_rei_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
728: nvl(p_rec.attribute14, hr_api.g_varchar2) or
729: nvl(pqh_rei_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
730: nvl(p_rec.attribute15, hr_api.g_varchar2) or
731: nvl(pqh_rei_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

Line 729: nvl(pqh_rei_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

725: nvl(pqh_rei_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
726: nvl(p_rec.attribute13, hr_api.g_varchar2) or
727: nvl(pqh_rei_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
728: nvl(p_rec.attribute14, hr_api.g_varchar2) or
729: nvl(pqh_rei_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
730: nvl(p_rec.attribute15, hr_api.g_varchar2) or
731: nvl(pqh_rei_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
732: nvl(p_rec.attribute16, hr_api.g_varchar2) or
733: nvl(pqh_rei_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

Line 731: nvl(pqh_rei_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

727: nvl(pqh_rei_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
728: nvl(p_rec.attribute14, hr_api.g_varchar2) or
729: nvl(pqh_rei_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
730: nvl(p_rec.attribute15, hr_api.g_varchar2) or
731: nvl(pqh_rei_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
732: nvl(p_rec.attribute16, hr_api.g_varchar2) or
733: nvl(pqh_rei_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
734: nvl(p_rec.attribute17, hr_api.g_varchar2) or
735: nvl(pqh_rei_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

Line 733: nvl(pqh_rei_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

729: nvl(pqh_rei_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
730: nvl(p_rec.attribute15, hr_api.g_varchar2) or
731: nvl(pqh_rei_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
732: nvl(p_rec.attribute16, hr_api.g_varchar2) or
733: nvl(pqh_rei_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
734: nvl(p_rec.attribute17, hr_api.g_varchar2) or
735: nvl(pqh_rei_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
736: nvl(p_rec.attribute18, hr_api.g_varchar2) or
737: nvl(pqh_rei_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

Line 735: nvl(pqh_rei_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

731: nvl(pqh_rei_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
732: nvl(p_rec.attribute16, hr_api.g_varchar2) or
733: nvl(pqh_rei_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
734: nvl(p_rec.attribute17, hr_api.g_varchar2) or
735: nvl(pqh_rei_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
736: nvl(p_rec.attribute18, hr_api.g_varchar2) or
737: nvl(pqh_rei_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
738: nvl(p_rec.attribute19, hr_api.g_varchar2) or
739: nvl(pqh_rei_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

Line 737: nvl(pqh_rei_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

733: nvl(pqh_rei_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
734: nvl(p_rec.attribute17, hr_api.g_varchar2) or
735: nvl(pqh_rei_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
736: nvl(p_rec.attribute18, hr_api.g_varchar2) or
737: nvl(pqh_rei_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
738: nvl(p_rec.attribute19, hr_api.g_varchar2) or
739: nvl(pqh_rei_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
740: nvl(p_rec.attribute20, hr_api.g_varchar2) or
741: nvl(pqh_rei_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>

Line 739: nvl(pqh_rei_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

735: nvl(pqh_rei_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
736: nvl(p_rec.attribute18, hr_api.g_varchar2) or
737: nvl(pqh_rei_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
738: nvl(p_rec.attribute19, hr_api.g_varchar2) or
739: nvl(pqh_rei_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
740: nvl(p_rec.attribute20, hr_api.g_varchar2) or
741: nvl(pqh_rei_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
742: nvl(p_rec.attribute21, hr_api.g_varchar2) or
743: nvl(pqh_rei_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>

Line 741: nvl(pqh_rei_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>

737: nvl(pqh_rei_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
738: nvl(p_rec.attribute19, hr_api.g_varchar2) or
739: nvl(pqh_rei_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
740: nvl(p_rec.attribute20, hr_api.g_varchar2) or
741: nvl(pqh_rei_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
742: nvl(p_rec.attribute21, hr_api.g_varchar2) or
743: nvl(pqh_rei_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
744: nvl(p_rec.attribute22, hr_api.g_varchar2) or
745: nvl(pqh_rei_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>

Line 743: nvl(pqh_rei_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>

739: nvl(pqh_rei_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
740: nvl(p_rec.attribute20, hr_api.g_varchar2) or
741: nvl(pqh_rei_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
742: nvl(p_rec.attribute21, hr_api.g_varchar2) or
743: nvl(pqh_rei_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
744: nvl(p_rec.attribute22, hr_api.g_varchar2) or
745: nvl(pqh_rei_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
746: nvl(p_rec.attribute23, hr_api.g_varchar2) or
747: nvl(pqh_rei_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>

Line 745: nvl(pqh_rei_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>

741: nvl(pqh_rei_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
742: nvl(p_rec.attribute21, hr_api.g_varchar2) or
743: nvl(pqh_rei_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
744: nvl(p_rec.attribute22, hr_api.g_varchar2) or
745: nvl(pqh_rei_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
746: nvl(p_rec.attribute23, hr_api.g_varchar2) or
747: nvl(pqh_rei_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
748: nvl(p_rec.attribute24, hr_api.g_varchar2) or
749: nvl(pqh_rei_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>

Line 747: nvl(pqh_rei_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>

743: nvl(pqh_rei_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
744: nvl(p_rec.attribute22, hr_api.g_varchar2) or
745: nvl(pqh_rei_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
746: nvl(p_rec.attribute23, hr_api.g_varchar2) or
747: nvl(pqh_rei_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
748: nvl(p_rec.attribute24, hr_api.g_varchar2) or
749: nvl(pqh_rei_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
750: nvl(p_rec.attribute25, hr_api.g_varchar2) or
751: nvl(pqh_rei_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>

Line 749: nvl(pqh_rei_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>

745: nvl(pqh_rei_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
746: nvl(p_rec.attribute23, hr_api.g_varchar2) or
747: nvl(pqh_rei_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
748: nvl(p_rec.attribute24, hr_api.g_varchar2) or
749: nvl(pqh_rei_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
750: nvl(p_rec.attribute25, hr_api.g_varchar2) or
751: nvl(pqh_rei_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
752: nvl(p_rec.attribute26, hr_api.g_varchar2) or
753: nvl(pqh_rei_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>

Line 751: nvl(pqh_rei_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>

747: nvl(pqh_rei_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
748: nvl(p_rec.attribute24, hr_api.g_varchar2) or
749: nvl(pqh_rei_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
750: nvl(p_rec.attribute25, hr_api.g_varchar2) or
751: nvl(pqh_rei_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
752: nvl(p_rec.attribute26, hr_api.g_varchar2) or
753: nvl(pqh_rei_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
754: nvl(p_rec.attribute27, hr_api.g_varchar2) or
755: nvl(pqh_rei_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>

Line 753: nvl(pqh_rei_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>

749: nvl(pqh_rei_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
750: nvl(p_rec.attribute25, hr_api.g_varchar2) or
751: nvl(pqh_rei_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
752: nvl(p_rec.attribute26, hr_api.g_varchar2) or
753: nvl(pqh_rei_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
754: nvl(p_rec.attribute27, hr_api.g_varchar2) or
755: nvl(pqh_rei_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
756: nvl(p_rec.attribute28, hr_api.g_varchar2) or
757: nvl(pqh_rei_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>

Line 755: nvl(pqh_rei_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>

751: nvl(pqh_rei_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
752: nvl(p_rec.attribute26, hr_api.g_varchar2) or
753: nvl(pqh_rei_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
754: nvl(p_rec.attribute27, hr_api.g_varchar2) or
755: nvl(pqh_rei_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
756: nvl(p_rec.attribute28, hr_api.g_varchar2) or
757: nvl(pqh_rei_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
758: nvl(p_rec.attribute29, hr_api.g_varchar2) or
759: nvl(pqh_rei_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>

Line 757: nvl(pqh_rei_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>

753: nvl(pqh_rei_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
754: nvl(p_rec.attribute27, hr_api.g_varchar2) or
755: nvl(pqh_rei_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
756: nvl(p_rec.attribute28, hr_api.g_varchar2) or
757: nvl(pqh_rei_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
758: nvl(p_rec.attribute29, hr_api.g_varchar2) or
759: nvl(pqh_rei_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
760: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
761: or (p_rec.role_extra_info_id is null) then

Line 759: nvl(pqh_rei_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>

755: nvl(pqh_rei_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
756: nvl(p_rec.attribute28, hr_api.g_varchar2) or
757: nvl(pqh_rei_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
758: nvl(p_rec.attribute29, hr_api.g_varchar2) or
759: nvl(pqh_rei_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
760: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
761: or (p_rec.role_extra_info_id is null) then
762: --
763: -- Only execute the validation if absolutely necessary:

Line 842: (p_rec in pqh_rei_shd.g_rec_type

838: -- ----------------------------------------------------------------------------
839: -- |---------------------------< insert_validate >----------------------------|
840: -- ----------------------------------------------------------------------------
841: Procedure insert_validate
842: (p_rec in pqh_rei_shd.g_rec_type
843: ) is
844: --
845: l_proc varchar2(72) := g_package||'insert_validate';
846: --

Line 881: (p_rec in pqh_rei_shd.g_rec_type

877: -- ----------------------------------------------------------------------------
878: -- |---------------------------< update_validate >----------------------------|
879: -- ----------------------------------------------------------------------------
880: Procedure update_validate
881: (p_rec in pqh_rei_shd.g_rec_type
882: ) is
883: --
884: l_proc varchar2(72) := g_package||'update_validate';
885: --

Line 907: (p_rec in pqh_rei_shd.g_rec_type

903: -- ----------------------------------------------------------------------------
904: -- |---------------------------< delete_validate >----------------------------|
905: -- ----------------------------------------------------------------------------
906: Procedure delete_validate
907: (p_rec in pqh_rei_shd.g_rec_type
908: ) is
909: --
910: l_proc varchar2(72) := g_package||'delete_validate';
911: --