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.PE_POI_BUS dependencies on PE_POI_SHD

Line 442: Procedure chk_non_updateable_args (p_rec in pe_poi_shd.g_rec_type) is

438: -- Internal Table Handler Use Only.
439: --
440: -- {End Of Comments}
441: -- ----------------------------------------------------------------------------
442: Procedure chk_non_updateable_args (p_rec in pe_poi_shd.g_rec_type) is
443: --
444: l_proc varchar2(72) := g_package||'chk_non_updateable_args';
445: l_error exception;
446: l_argument varchar2(30);

Line 454: if not pe_poi_shd.api_updating

450: --
451: -- Only proceed with validation if a row exists for
452: -- the current record in the HR Schema
453: --
454: if not pe_poi_shd.api_updating
455: (p_position_extra_info_id => p_rec.position_extra_info_id
456: ,p_object_version_number => p_rec.object_version_number) then
457: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
458: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 465: nvl(pe_poi_shd.g_old_rec.information_type, hr_api.g_varchar2) then

461: --
462: hr_utility.set_location(l_proc, 30);
463: --
464: if nvl(p_rec.information_type, hr_api.g_varchar2) <>
465: nvl(pe_poi_shd.g_old_rec.information_type, hr_api.g_varchar2) then
466: l_argument := 'information_type';
467: raise l_error;
468: end if;
469: --

Line 473: nvl(pe_poi_shd.g_old_rec.position_id, hr_api.g_number) then

469: --
470: hr_utility.set_location(l_proc, 40);
471: --
472: if nvl(p_rec.position_id, hr_api.g_number) <>
473: nvl(pe_poi_shd.g_old_rec.position_id, hr_api.g_number) then
474: l_argument := 'position_id';
475: raise l_error;
476: end if;
477: --

Line 519: (p_rec in pe_poi_shd.g_rec_type) is

515: -- Access Status:
516: -- Internal Row Handler Use Only.
517: --
518: procedure chk_df
519: (p_rec in pe_poi_shd.g_rec_type) is
520: --
521: l_proc varchar2(72) := g_package||'chk_df';
522: --
523: begin

Line 527: nvl(pe_poi_shd.g_old_rec.poei_attribute_category, hr_api.g_varchar2) <>

523: begin
524: hr_utility.set_location('Entering:'||l_proc, 10);
525: --
526: if ((p_rec.position_extra_info_id is not null) and (
527: nvl(pe_poi_shd.g_old_rec.poei_attribute_category, hr_api.g_varchar2) <>
528: nvl(p_rec.poei_attribute_category, hr_api.g_varchar2) or
529: nvl(pe_poi_shd.g_old_rec.poei_attribute1, hr_api.g_varchar2) <>
530: nvl(p_rec.poei_attribute1, hr_api.g_varchar2) or
531: nvl(pe_poi_shd.g_old_rec.poei_attribute2, hr_api.g_varchar2) <>

Line 529: nvl(pe_poi_shd.g_old_rec.poei_attribute1, hr_api.g_varchar2) <>

525: --
526: if ((p_rec.position_extra_info_id is not null) and (
527: nvl(pe_poi_shd.g_old_rec.poei_attribute_category, hr_api.g_varchar2) <>
528: nvl(p_rec.poei_attribute_category, hr_api.g_varchar2) or
529: nvl(pe_poi_shd.g_old_rec.poei_attribute1, hr_api.g_varchar2) <>
530: nvl(p_rec.poei_attribute1, hr_api.g_varchar2) or
531: nvl(pe_poi_shd.g_old_rec.poei_attribute2, hr_api.g_varchar2) <>
532: nvl(p_rec.poei_attribute2, hr_api.g_varchar2) or
533: nvl(pe_poi_shd.g_old_rec.poei_attribute3, hr_api.g_varchar2) <>

Line 531: nvl(pe_poi_shd.g_old_rec.poei_attribute2, hr_api.g_varchar2) <>

527: nvl(pe_poi_shd.g_old_rec.poei_attribute_category, hr_api.g_varchar2) <>
528: nvl(p_rec.poei_attribute_category, hr_api.g_varchar2) or
529: nvl(pe_poi_shd.g_old_rec.poei_attribute1, hr_api.g_varchar2) <>
530: nvl(p_rec.poei_attribute1, hr_api.g_varchar2) or
531: nvl(pe_poi_shd.g_old_rec.poei_attribute2, hr_api.g_varchar2) <>
532: nvl(p_rec.poei_attribute2, hr_api.g_varchar2) or
533: nvl(pe_poi_shd.g_old_rec.poei_attribute3, hr_api.g_varchar2) <>
534: nvl(p_rec.poei_attribute3, hr_api.g_varchar2) or
535: nvl(pe_poi_shd.g_old_rec.poei_attribute4, hr_api.g_varchar2) <>

Line 533: nvl(pe_poi_shd.g_old_rec.poei_attribute3, hr_api.g_varchar2) <>

529: nvl(pe_poi_shd.g_old_rec.poei_attribute1, hr_api.g_varchar2) <>
530: nvl(p_rec.poei_attribute1, hr_api.g_varchar2) or
531: nvl(pe_poi_shd.g_old_rec.poei_attribute2, hr_api.g_varchar2) <>
532: nvl(p_rec.poei_attribute2, hr_api.g_varchar2) or
533: nvl(pe_poi_shd.g_old_rec.poei_attribute3, hr_api.g_varchar2) <>
534: nvl(p_rec.poei_attribute3, hr_api.g_varchar2) or
535: nvl(pe_poi_shd.g_old_rec.poei_attribute4, hr_api.g_varchar2) <>
536: nvl(p_rec.poei_attribute4, hr_api.g_varchar2) or
537: nvl(pe_poi_shd.g_old_rec.poei_attribute5, hr_api.g_varchar2) <>

Line 535: nvl(pe_poi_shd.g_old_rec.poei_attribute4, hr_api.g_varchar2) <>

531: nvl(pe_poi_shd.g_old_rec.poei_attribute2, hr_api.g_varchar2) <>
532: nvl(p_rec.poei_attribute2, hr_api.g_varchar2) or
533: nvl(pe_poi_shd.g_old_rec.poei_attribute3, hr_api.g_varchar2) <>
534: nvl(p_rec.poei_attribute3, hr_api.g_varchar2) or
535: nvl(pe_poi_shd.g_old_rec.poei_attribute4, hr_api.g_varchar2) <>
536: nvl(p_rec.poei_attribute4, hr_api.g_varchar2) or
537: nvl(pe_poi_shd.g_old_rec.poei_attribute5, hr_api.g_varchar2) <>
538: nvl(p_rec.poei_attribute5, hr_api.g_varchar2) or
539: nvl(pe_poi_shd.g_old_rec.poei_attribute6, hr_api.g_varchar2) <>

Line 537: nvl(pe_poi_shd.g_old_rec.poei_attribute5, hr_api.g_varchar2) <>

533: nvl(pe_poi_shd.g_old_rec.poei_attribute3, hr_api.g_varchar2) <>
534: nvl(p_rec.poei_attribute3, hr_api.g_varchar2) or
535: nvl(pe_poi_shd.g_old_rec.poei_attribute4, hr_api.g_varchar2) <>
536: nvl(p_rec.poei_attribute4, hr_api.g_varchar2) or
537: nvl(pe_poi_shd.g_old_rec.poei_attribute5, hr_api.g_varchar2) <>
538: nvl(p_rec.poei_attribute5, hr_api.g_varchar2) or
539: nvl(pe_poi_shd.g_old_rec.poei_attribute6, hr_api.g_varchar2) <>
540: nvl(p_rec.poei_attribute6, hr_api.g_varchar2) or
541: nvl(pe_poi_shd.g_old_rec.poei_attribute7, hr_api.g_varchar2) <>

Line 539: nvl(pe_poi_shd.g_old_rec.poei_attribute6, hr_api.g_varchar2) <>

535: nvl(pe_poi_shd.g_old_rec.poei_attribute4, hr_api.g_varchar2) <>
536: nvl(p_rec.poei_attribute4, hr_api.g_varchar2) or
537: nvl(pe_poi_shd.g_old_rec.poei_attribute5, hr_api.g_varchar2) <>
538: nvl(p_rec.poei_attribute5, hr_api.g_varchar2) or
539: nvl(pe_poi_shd.g_old_rec.poei_attribute6, hr_api.g_varchar2) <>
540: nvl(p_rec.poei_attribute6, hr_api.g_varchar2) or
541: nvl(pe_poi_shd.g_old_rec.poei_attribute7, hr_api.g_varchar2) <>
542: nvl(p_rec.poei_attribute7, hr_api.g_varchar2) or
543: nvl(pe_poi_shd.g_old_rec.poei_attribute8, hr_api.g_varchar2) <>

Line 541: nvl(pe_poi_shd.g_old_rec.poei_attribute7, hr_api.g_varchar2) <>

537: nvl(pe_poi_shd.g_old_rec.poei_attribute5, hr_api.g_varchar2) <>
538: nvl(p_rec.poei_attribute5, hr_api.g_varchar2) or
539: nvl(pe_poi_shd.g_old_rec.poei_attribute6, hr_api.g_varchar2) <>
540: nvl(p_rec.poei_attribute6, hr_api.g_varchar2) or
541: nvl(pe_poi_shd.g_old_rec.poei_attribute7, hr_api.g_varchar2) <>
542: nvl(p_rec.poei_attribute7, hr_api.g_varchar2) or
543: nvl(pe_poi_shd.g_old_rec.poei_attribute8, hr_api.g_varchar2) <>
544: nvl(p_rec.poei_attribute8, hr_api.g_varchar2) or
545: nvl(pe_poi_shd.g_old_rec.poei_attribute9, hr_api.g_varchar2) <>

Line 543: nvl(pe_poi_shd.g_old_rec.poei_attribute8, hr_api.g_varchar2) <>

539: nvl(pe_poi_shd.g_old_rec.poei_attribute6, hr_api.g_varchar2) <>
540: nvl(p_rec.poei_attribute6, hr_api.g_varchar2) or
541: nvl(pe_poi_shd.g_old_rec.poei_attribute7, hr_api.g_varchar2) <>
542: nvl(p_rec.poei_attribute7, hr_api.g_varchar2) or
543: nvl(pe_poi_shd.g_old_rec.poei_attribute8, hr_api.g_varchar2) <>
544: nvl(p_rec.poei_attribute8, hr_api.g_varchar2) or
545: nvl(pe_poi_shd.g_old_rec.poei_attribute9, hr_api.g_varchar2) <>
546: nvl(p_rec.poei_attribute9, hr_api.g_varchar2) or
547: nvl(pe_poi_shd.g_old_rec.poei_attribute10, hr_api.g_varchar2) <>

Line 545: nvl(pe_poi_shd.g_old_rec.poei_attribute9, hr_api.g_varchar2) <>

541: nvl(pe_poi_shd.g_old_rec.poei_attribute7, hr_api.g_varchar2) <>
542: nvl(p_rec.poei_attribute7, hr_api.g_varchar2) or
543: nvl(pe_poi_shd.g_old_rec.poei_attribute8, hr_api.g_varchar2) <>
544: nvl(p_rec.poei_attribute8, hr_api.g_varchar2) or
545: nvl(pe_poi_shd.g_old_rec.poei_attribute9, hr_api.g_varchar2) <>
546: nvl(p_rec.poei_attribute9, hr_api.g_varchar2) or
547: nvl(pe_poi_shd.g_old_rec.poei_attribute10, hr_api.g_varchar2) <>
548: nvl(p_rec.poei_attribute10, hr_api.g_varchar2) or
549: nvl(pe_poi_shd.g_old_rec.poei_attribute11, hr_api.g_varchar2) <>

Line 547: nvl(pe_poi_shd.g_old_rec.poei_attribute10, hr_api.g_varchar2) <>

543: nvl(pe_poi_shd.g_old_rec.poei_attribute8, hr_api.g_varchar2) <>
544: nvl(p_rec.poei_attribute8, hr_api.g_varchar2) or
545: nvl(pe_poi_shd.g_old_rec.poei_attribute9, hr_api.g_varchar2) <>
546: nvl(p_rec.poei_attribute9, hr_api.g_varchar2) or
547: nvl(pe_poi_shd.g_old_rec.poei_attribute10, hr_api.g_varchar2) <>
548: nvl(p_rec.poei_attribute10, hr_api.g_varchar2) or
549: nvl(pe_poi_shd.g_old_rec.poei_attribute11, hr_api.g_varchar2) <>
550: nvl(p_rec.poei_attribute11, hr_api.g_varchar2) or
551: nvl(pe_poi_shd.g_old_rec.poei_attribute12, hr_api.g_varchar2) <>

Line 549: nvl(pe_poi_shd.g_old_rec.poei_attribute11, hr_api.g_varchar2) <>

545: nvl(pe_poi_shd.g_old_rec.poei_attribute9, hr_api.g_varchar2) <>
546: nvl(p_rec.poei_attribute9, hr_api.g_varchar2) or
547: nvl(pe_poi_shd.g_old_rec.poei_attribute10, hr_api.g_varchar2) <>
548: nvl(p_rec.poei_attribute10, hr_api.g_varchar2) or
549: nvl(pe_poi_shd.g_old_rec.poei_attribute11, hr_api.g_varchar2) <>
550: nvl(p_rec.poei_attribute11, hr_api.g_varchar2) or
551: nvl(pe_poi_shd.g_old_rec.poei_attribute12, hr_api.g_varchar2) <>
552: nvl(p_rec.poei_attribute12, hr_api.g_varchar2) or
553: nvl(pe_poi_shd.g_old_rec.poei_attribute13, hr_api.g_varchar2) <>

Line 551: nvl(pe_poi_shd.g_old_rec.poei_attribute12, hr_api.g_varchar2) <>

547: nvl(pe_poi_shd.g_old_rec.poei_attribute10, hr_api.g_varchar2) <>
548: nvl(p_rec.poei_attribute10, hr_api.g_varchar2) or
549: nvl(pe_poi_shd.g_old_rec.poei_attribute11, hr_api.g_varchar2) <>
550: nvl(p_rec.poei_attribute11, hr_api.g_varchar2) or
551: nvl(pe_poi_shd.g_old_rec.poei_attribute12, hr_api.g_varchar2) <>
552: nvl(p_rec.poei_attribute12, hr_api.g_varchar2) or
553: nvl(pe_poi_shd.g_old_rec.poei_attribute13, hr_api.g_varchar2) <>
554: nvl(p_rec.poei_attribute13, hr_api.g_varchar2) or
555: nvl(pe_poi_shd.g_old_rec.poei_attribute14, hr_api.g_varchar2) <>

Line 553: nvl(pe_poi_shd.g_old_rec.poei_attribute13, hr_api.g_varchar2) <>

549: nvl(pe_poi_shd.g_old_rec.poei_attribute11, hr_api.g_varchar2) <>
550: nvl(p_rec.poei_attribute11, hr_api.g_varchar2) or
551: nvl(pe_poi_shd.g_old_rec.poei_attribute12, hr_api.g_varchar2) <>
552: nvl(p_rec.poei_attribute12, hr_api.g_varchar2) or
553: nvl(pe_poi_shd.g_old_rec.poei_attribute13, hr_api.g_varchar2) <>
554: nvl(p_rec.poei_attribute13, hr_api.g_varchar2) or
555: nvl(pe_poi_shd.g_old_rec.poei_attribute14, hr_api.g_varchar2) <>
556: nvl(p_rec.poei_attribute14, hr_api.g_varchar2) or
557: nvl(pe_poi_shd.g_old_rec.poei_attribute15, hr_api.g_varchar2) <>

Line 555: nvl(pe_poi_shd.g_old_rec.poei_attribute14, hr_api.g_varchar2) <>

551: nvl(pe_poi_shd.g_old_rec.poei_attribute12, hr_api.g_varchar2) <>
552: nvl(p_rec.poei_attribute12, hr_api.g_varchar2) or
553: nvl(pe_poi_shd.g_old_rec.poei_attribute13, hr_api.g_varchar2) <>
554: nvl(p_rec.poei_attribute13, hr_api.g_varchar2) or
555: nvl(pe_poi_shd.g_old_rec.poei_attribute14, hr_api.g_varchar2) <>
556: nvl(p_rec.poei_attribute14, hr_api.g_varchar2) or
557: nvl(pe_poi_shd.g_old_rec.poei_attribute15, hr_api.g_varchar2) <>
558: nvl(p_rec.poei_attribute15, hr_api.g_varchar2) or
559: nvl(pe_poi_shd.g_old_rec.poei_attribute16, hr_api.g_varchar2) <>

Line 557: nvl(pe_poi_shd.g_old_rec.poei_attribute15, hr_api.g_varchar2) <>

553: nvl(pe_poi_shd.g_old_rec.poei_attribute13, hr_api.g_varchar2) <>
554: nvl(p_rec.poei_attribute13, hr_api.g_varchar2) or
555: nvl(pe_poi_shd.g_old_rec.poei_attribute14, hr_api.g_varchar2) <>
556: nvl(p_rec.poei_attribute14, hr_api.g_varchar2) or
557: nvl(pe_poi_shd.g_old_rec.poei_attribute15, hr_api.g_varchar2) <>
558: nvl(p_rec.poei_attribute15, hr_api.g_varchar2) or
559: nvl(pe_poi_shd.g_old_rec.poei_attribute16, hr_api.g_varchar2) <>
560: nvl(p_rec.poei_attribute16, hr_api.g_varchar2) or
561: nvl(pe_poi_shd.g_old_rec.poei_attribute17, hr_api.g_varchar2) <>

Line 559: nvl(pe_poi_shd.g_old_rec.poei_attribute16, hr_api.g_varchar2) <>

555: nvl(pe_poi_shd.g_old_rec.poei_attribute14, hr_api.g_varchar2) <>
556: nvl(p_rec.poei_attribute14, hr_api.g_varchar2) or
557: nvl(pe_poi_shd.g_old_rec.poei_attribute15, hr_api.g_varchar2) <>
558: nvl(p_rec.poei_attribute15, hr_api.g_varchar2) or
559: nvl(pe_poi_shd.g_old_rec.poei_attribute16, hr_api.g_varchar2) <>
560: nvl(p_rec.poei_attribute16, hr_api.g_varchar2) or
561: nvl(pe_poi_shd.g_old_rec.poei_attribute17, hr_api.g_varchar2) <>
562: nvl(p_rec.poei_attribute17, hr_api.g_varchar2) or
563: nvl(pe_poi_shd.g_old_rec.poei_attribute18, hr_api.g_varchar2) <>

Line 561: nvl(pe_poi_shd.g_old_rec.poei_attribute17, hr_api.g_varchar2) <>

557: nvl(pe_poi_shd.g_old_rec.poei_attribute15, hr_api.g_varchar2) <>
558: nvl(p_rec.poei_attribute15, hr_api.g_varchar2) or
559: nvl(pe_poi_shd.g_old_rec.poei_attribute16, hr_api.g_varchar2) <>
560: nvl(p_rec.poei_attribute16, hr_api.g_varchar2) or
561: nvl(pe_poi_shd.g_old_rec.poei_attribute17, hr_api.g_varchar2) <>
562: nvl(p_rec.poei_attribute17, hr_api.g_varchar2) or
563: nvl(pe_poi_shd.g_old_rec.poei_attribute18, hr_api.g_varchar2) <>
564: nvl(p_rec.poei_attribute18, hr_api.g_varchar2) or
565: nvl(pe_poi_shd.g_old_rec.poei_attribute19, hr_api.g_varchar2) <>

Line 563: nvl(pe_poi_shd.g_old_rec.poei_attribute18, hr_api.g_varchar2) <>

559: nvl(pe_poi_shd.g_old_rec.poei_attribute16, hr_api.g_varchar2) <>
560: nvl(p_rec.poei_attribute16, hr_api.g_varchar2) or
561: nvl(pe_poi_shd.g_old_rec.poei_attribute17, hr_api.g_varchar2) <>
562: nvl(p_rec.poei_attribute17, hr_api.g_varchar2) or
563: nvl(pe_poi_shd.g_old_rec.poei_attribute18, hr_api.g_varchar2) <>
564: nvl(p_rec.poei_attribute18, hr_api.g_varchar2) or
565: nvl(pe_poi_shd.g_old_rec.poei_attribute19, hr_api.g_varchar2) <>
566: nvl(p_rec.poei_attribute19, hr_api.g_varchar2) or
567: nvl(pe_poi_shd.g_old_rec.poei_attribute20, hr_api.g_varchar2) <>

Line 565: nvl(pe_poi_shd.g_old_rec.poei_attribute19, hr_api.g_varchar2) <>

561: nvl(pe_poi_shd.g_old_rec.poei_attribute17, hr_api.g_varchar2) <>
562: nvl(p_rec.poei_attribute17, hr_api.g_varchar2) or
563: nvl(pe_poi_shd.g_old_rec.poei_attribute18, hr_api.g_varchar2) <>
564: nvl(p_rec.poei_attribute18, hr_api.g_varchar2) or
565: nvl(pe_poi_shd.g_old_rec.poei_attribute19, hr_api.g_varchar2) <>
566: nvl(p_rec.poei_attribute19, hr_api.g_varchar2) or
567: nvl(pe_poi_shd.g_old_rec.poei_attribute20, hr_api.g_varchar2) <>
568: nvl(p_rec.poei_attribute20, hr_api.g_varchar2)))
569: or

Line 567: nvl(pe_poi_shd.g_old_rec.poei_attribute20, hr_api.g_varchar2) <>

563: nvl(pe_poi_shd.g_old_rec.poei_attribute18, hr_api.g_varchar2) <>
564: nvl(p_rec.poei_attribute18, hr_api.g_varchar2) or
565: nvl(pe_poi_shd.g_old_rec.poei_attribute19, hr_api.g_varchar2) <>
566: nvl(p_rec.poei_attribute19, hr_api.g_varchar2) or
567: nvl(pe_poi_shd.g_old_rec.poei_attribute20, hr_api.g_varchar2) <>
568: nvl(p_rec.poei_attribute20, hr_api.g_varchar2)))
569: or
570: (p_rec.position_extra_info_id is null) then
571: --

Line 658: (p_rec in pe_poi_shd.g_rec_type) is

654: -- {End Of Comments}
655: -- ----------------------------------------------------------------------------
656: --
657: procedure chk_ddf
658: (p_rec in pe_poi_shd.g_rec_type) is
659: --
660: l_proc varchar2(72) := g_package||'chk_ddf';
661: l_error exception;
662: --

Line 672: nvl(pe_poi_shd.g_old_rec.poei_attribute_category, hr_api.g_varchar2) <>

668: --
669: if (p_rec.position_extra_info_id is null)
670: or ((p_rec.position_extra_info_id is not null)
671: and
672: nvl(pe_poi_shd.g_old_rec.poei_attribute_category, hr_api.g_varchar2) <>
673: nvl(p_rec.poei_information_category, hr_api.g_varchar2) or
674: nvl(pe_poi_shd.g_old_rec.poei_information1, hr_api.g_varchar2) <>
675: nvl(p_rec.poei_information1, hr_api.g_varchar2) or
676: nvl(pe_poi_shd.g_old_rec.poei_information2, hr_api.g_varchar2) <>

Line 674: nvl(pe_poi_shd.g_old_rec.poei_information1, hr_api.g_varchar2) <>

670: or ((p_rec.position_extra_info_id is not null)
671: and
672: nvl(pe_poi_shd.g_old_rec.poei_attribute_category, hr_api.g_varchar2) <>
673: nvl(p_rec.poei_information_category, hr_api.g_varchar2) or
674: nvl(pe_poi_shd.g_old_rec.poei_information1, hr_api.g_varchar2) <>
675: nvl(p_rec.poei_information1, hr_api.g_varchar2) or
676: nvl(pe_poi_shd.g_old_rec.poei_information2, hr_api.g_varchar2) <>
677: nvl(p_rec.poei_information2, hr_api.g_varchar2) or
678: nvl(pe_poi_shd.g_old_rec.poei_information3, hr_api.g_varchar2) <>

Line 676: nvl(pe_poi_shd.g_old_rec.poei_information2, hr_api.g_varchar2) <>

672: nvl(pe_poi_shd.g_old_rec.poei_attribute_category, hr_api.g_varchar2) <>
673: nvl(p_rec.poei_information_category, hr_api.g_varchar2) or
674: nvl(pe_poi_shd.g_old_rec.poei_information1, hr_api.g_varchar2) <>
675: nvl(p_rec.poei_information1, hr_api.g_varchar2) or
676: nvl(pe_poi_shd.g_old_rec.poei_information2, hr_api.g_varchar2) <>
677: nvl(p_rec.poei_information2, hr_api.g_varchar2) or
678: nvl(pe_poi_shd.g_old_rec.poei_information3, hr_api.g_varchar2) <>
679: nvl(p_rec.poei_information3, hr_api.g_varchar2) or
680: nvl(pe_poi_shd.g_old_rec.poei_information4, hr_api.g_varchar2) <>

Line 678: nvl(pe_poi_shd.g_old_rec.poei_information3, hr_api.g_varchar2) <>

674: nvl(pe_poi_shd.g_old_rec.poei_information1, hr_api.g_varchar2) <>
675: nvl(p_rec.poei_information1, hr_api.g_varchar2) or
676: nvl(pe_poi_shd.g_old_rec.poei_information2, hr_api.g_varchar2) <>
677: nvl(p_rec.poei_information2, hr_api.g_varchar2) or
678: nvl(pe_poi_shd.g_old_rec.poei_information3, hr_api.g_varchar2) <>
679: nvl(p_rec.poei_information3, hr_api.g_varchar2) or
680: nvl(pe_poi_shd.g_old_rec.poei_information4, hr_api.g_varchar2) <>
681: nvl(p_rec.poei_information4, hr_api.g_varchar2) or
682: nvl(pe_poi_shd.g_old_rec.poei_information5, hr_api.g_varchar2) <>

Line 680: nvl(pe_poi_shd.g_old_rec.poei_information4, hr_api.g_varchar2) <>

676: nvl(pe_poi_shd.g_old_rec.poei_information2, hr_api.g_varchar2) <>
677: nvl(p_rec.poei_information2, hr_api.g_varchar2) or
678: nvl(pe_poi_shd.g_old_rec.poei_information3, hr_api.g_varchar2) <>
679: nvl(p_rec.poei_information3, hr_api.g_varchar2) or
680: nvl(pe_poi_shd.g_old_rec.poei_information4, hr_api.g_varchar2) <>
681: nvl(p_rec.poei_information4, hr_api.g_varchar2) or
682: nvl(pe_poi_shd.g_old_rec.poei_information5, hr_api.g_varchar2) <>
683: nvl(p_rec.poei_information5, hr_api.g_varchar2) or
684: nvl(pe_poi_shd.g_old_rec.poei_information6, hr_api.g_varchar2) <>

Line 682: nvl(pe_poi_shd.g_old_rec.poei_information5, hr_api.g_varchar2) <>

678: nvl(pe_poi_shd.g_old_rec.poei_information3, hr_api.g_varchar2) <>
679: nvl(p_rec.poei_information3, hr_api.g_varchar2) or
680: nvl(pe_poi_shd.g_old_rec.poei_information4, hr_api.g_varchar2) <>
681: nvl(p_rec.poei_information4, hr_api.g_varchar2) or
682: nvl(pe_poi_shd.g_old_rec.poei_information5, hr_api.g_varchar2) <>
683: nvl(p_rec.poei_information5, hr_api.g_varchar2) or
684: nvl(pe_poi_shd.g_old_rec.poei_information6, hr_api.g_varchar2) <>
685: nvl(p_rec.poei_information6, hr_api.g_varchar2) or
686: nvl(pe_poi_shd.g_old_rec.poei_information7, hr_api.g_varchar2) <>

Line 684: nvl(pe_poi_shd.g_old_rec.poei_information6, hr_api.g_varchar2) <>

680: nvl(pe_poi_shd.g_old_rec.poei_information4, hr_api.g_varchar2) <>
681: nvl(p_rec.poei_information4, hr_api.g_varchar2) or
682: nvl(pe_poi_shd.g_old_rec.poei_information5, hr_api.g_varchar2) <>
683: nvl(p_rec.poei_information5, hr_api.g_varchar2) or
684: nvl(pe_poi_shd.g_old_rec.poei_information6, hr_api.g_varchar2) <>
685: nvl(p_rec.poei_information6, hr_api.g_varchar2) or
686: nvl(pe_poi_shd.g_old_rec.poei_information7, hr_api.g_varchar2) <>
687: nvl(p_rec.poei_information7, hr_api.g_varchar2) or
688: nvl(pe_poi_shd.g_old_rec.poei_information8, hr_api.g_varchar2) <>

Line 686: nvl(pe_poi_shd.g_old_rec.poei_information7, hr_api.g_varchar2) <>

682: nvl(pe_poi_shd.g_old_rec.poei_information5, hr_api.g_varchar2) <>
683: nvl(p_rec.poei_information5, hr_api.g_varchar2) or
684: nvl(pe_poi_shd.g_old_rec.poei_information6, hr_api.g_varchar2) <>
685: nvl(p_rec.poei_information6, hr_api.g_varchar2) or
686: nvl(pe_poi_shd.g_old_rec.poei_information7, hr_api.g_varchar2) <>
687: nvl(p_rec.poei_information7, hr_api.g_varchar2) or
688: nvl(pe_poi_shd.g_old_rec.poei_information8, hr_api.g_varchar2) <>
689: nvl(p_rec.poei_information8, hr_api.g_varchar2) or
690: nvl(pe_poi_shd.g_old_rec.poei_information9, hr_api.g_varchar2) <>

Line 688: nvl(pe_poi_shd.g_old_rec.poei_information8, hr_api.g_varchar2) <>

684: nvl(pe_poi_shd.g_old_rec.poei_information6, hr_api.g_varchar2) <>
685: nvl(p_rec.poei_information6, hr_api.g_varchar2) or
686: nvl(pe_poi_shd.g_old_rec.poei_information7, hr_api.g_varchar2) <>
687: nvl(p_rec.poei_information7, hr_api.g_varchar2) or
688: nvl(pe_poi_shd.g_old_rec.poei_information8, hr_api.g_varchar2) <>
689: nvl(p_rec.poei_information8, hr_api.g_varchar2) or
690: nvl(pe_poi_shd.g_old_rec.poei_information9, hr_api.g_varchar2) <>
691: nvl(p_rec.poei_information9, hr_api.g_varchar2) or
692: nvl(pe_poi_shd.g_old_rec.poei_information10, hr_api.g_varchar2) <>

Line 690: nvl(pe_poi_shd.g_old_rec.poei_information9, hr_api.g_varchar2) <>

686: nvl(pe_poi_shd.g_old_rec.poei_information7, hr_api.g_varchar2) <>
687: nvl(p_rec.poei_information7, hr_api.g_varchar2) or
688: nvl(pe_poi_shd.g_old_rec.poei_information8, hr_api.g_varchar2) <>
689: nvl(p_rec.poei_information8, hr_api.g_varchar2) or
690: nvl(pe_poi_shd.g_old_rec.poei_information9, hr_api.g_varchar2) <>
691: nvl(p_rec.poei_information9, hr_api.g_varchar2) or
692: nvl(pe_poi_shd.g_old_rec.poei_information10, hr_api.g_varchar2) <>
693: nvl(p_rec.poei_information10, hr_api.g_varchar2) or
694: nvl(pe_poi_shd.g_old_rec.poei_information11, hr_api.g_varchar2) <>

Line 692: nvl(pe_poi_shd.g_old_rec.poei_information10, hr_api.g_varchar2) <>

688: nvl(pe_poi_shd.g_old_rec.poei_information8, hr_api.g_varchar2) <>
689: nvl(p_rec.poei_information8, hr_api.g_varchar2) or
690: nvl(pe_poi_shd.g_old_rec.poei_information9, hr_api.g_varchar2) <>
691: nvl(p_rec.poei_information9, hr_api.g_varchar2) or
692: nvl(pe_poi_shd.g_old_rec.poei_information10, hr_api.g_varchar2) <>
693: nvl(p_rec.poei_information10, hr_api.g_varchar2) or
694: nvl(pe_poi_shd.g_old_rec.poei_information11, hr_api.g_varchar2) <>
695: nvl(p_rec.poei_information11, hr_api.g_varchar2) or
696: nvl(pe_poi_shd.g_old_rec.poei_information12, hr_api.g_varchar2) <>

Line 694: nvl(pe_poi_shd.g_old_rec.poei_information11, hr_api.g_varchar2) <>

690: nvl(pe_poi_shd.g_old_rec.poei_information9, hr_api.g_varchar2) <>
691: nvl(p_rec.poei_information9, hr_api.g_varchar2) or
692: nvl(pe_poi_shd.g_old_rec.poei_information10, hr_api.g_varchar2) <>
693: nvl(p_rec.poei_information10, hr_api.g_varchar2) or
694: nvl(pe_poi_shd.g_old_rec.poei_information11, hr_api.g_varchar2) <>
695: nvl(p_rec.poei_information11, hr_api.g_varchar2) or
696: nvl(pe_poi_shd.g_old_rec.poei_information12, hr_api.g_varchar2) <>
697: nvl(p_rec.poei_information12, hr_api.g_varchar2) or
698: nvl(pe_poi_shd.g_old_rec.poei_information13, hr_api.g_varchar2) <>

Line 696: nvl(pe_poi_shd.g_old_rec.poei_information12, hr_api.g_varchar2) <>

692: nvl(pe_poi_shd.g_old_rec.poei_information10, hr_api.g_varchar2) <>
693: nvl(p_rec.poei_information10, hr_api.g_varchar2) or
694: nvl(pe_poi_shd.g_old_rec.poei_information11, hr_api.g_varchar2) <>
695: nvl(p_rec.poei_information11, hr_api.g_varchar2) or
696: nvl(pe_poi_shd.g_old_rec.poei_information12, hr_api.g_varchar2) <>
697: nvl(p_rec.poei_information12, hr_api.g_varchar2) or
698: nvl(pe_poi_shd.g_old_rec.poei_information13, hr_api.g_varchar2) <>
699: nvl(p_rec.poei_information13, hr_api.g_varchar2) or
700: nvl(pe_poi_shd.g_old_rec.poei_information14, hr_api.g_varchar2) <>

Line 698: nvl(pe_poi_shd.g_old_rec.poei_information13, hr_api.g_varchar2) <>

694: nvl(pe_poi_shd.g_old_rec.poei_information11, hr_api.g_varchar2) <>
695: nvl(p_rec.poei_information11, hr_api.g_varchar2) or
696: nvl(pe_poi_shd.g_old_rec.poei_information12, hr_api.g_varchar2) <>
697: nvl(p_rec.poei_information12, hr_api.g_varchar2) or
698: nvl(pe_poi_shd.g_old_rec.poei_information13, hr_api.g_varchar2) <>
699: nvl(p_rec.poei_information13, hr_api.g_varchar2) or
700: nvl(pe_poi_shd.g_old_rec.poei_information14, hr_api.g_varchar2) <>
701: nvl(p_rec.poei_information14, hr_api.g_varchar2) or
702: nvl(pe_poi_shd.g_old_rec.poei_information15, hr_api.g_varchar2) <>

Line 700: nvl(pe_poi_shd.g_old_rec.poei_information14, hr_api.g_varchar2) <>

696: nvl(pe_poi_shd.g_old_rec.poei_information12, hr_api.g_varchar2) <>
697: nvl(p_rec.poei_information12, hr_api.g_varchar2) or
698: nvl(pe_poi_shd.g_old_rec.poei_information13, hr_api.g_varchar2) <>
699: nvl(p_rec.poei_information13, hr_api.g_varchar2) or
700: nvl(pe_poi_shd.g_old_rec.poei_information14, hr_api.g_varchar2) <>
701: nvl(p_rec.poei_information14, hr_api.g_varchar2) or
702: nvl(pe_poi_shd.g_old_rec.poei_information15, hr_api.g_varchar2) <>
703: nvl(p_rec.poei_information15, hr_api.g_varchar2) or
704: nvl(pe_poi_shd.g_old_rec.poei_information16, hr_api.g_varchar2) <>

Line 702: nvl(pe_poi_shd.g_old_rec.poei_information15, hr_api.g_varchar2) <>

698: nvl(pe_poi_shd.g_old_rec.poei_information13, hr_api.g_varchar2) <>
699: nvl(p_rec.poei_information13, hr_api.g_varchar2) or
700: nvl(pe_poi_shd.g_old_rec.poei_information14, hr_api.g_varchar2) <>
701: nvl(p_rec.poei_information14, hr_api.g_varchar2) or
702: nvl(pe_poi_shd.g_old_rec.poei_information15, hr_api.g_varchar2) <>
703: nvl(p_rec.poei_information15, hr_api.g_varchar2) or
704: nvl(pe_poi_shd.g_old_rec.poei_information16, hr_api.g_varchar2) <>
705: nvl(p_rec.poei_information16, hr_api.g_varchar2) or
706: nvl(pe_poi_shd.g_old_rec.poei_information17, hr_api.g_varchar2) <>

Line 704: nvl(pe_poi_shd.g_old_rec.poei_information16, hr_api.g_varchar2) <>

700: nvl(pe_poi_shd.g_old_rec.poei_information14, hr_api.g_varchar2) <>
701: nvl(p_rec.poei_information14, hr_api.g_varchar2) or
702: nvl(pe_poi_shd.g_old_rec.poei_information15, hr_api.g_varchar2) <>
703: nvl(p_rec.poei_information15, hr_api.g_varchar2) or
704: nvl(pe_poi_shd.g_old_rec.poei_information16, hr_api.g_varchar2) <>
705: nvl(p_rec.poei_information16, hr_api.g_varchar2) or
706: nvl(pe_poi_shd.g_old_rec.poei_information17, hr_api.g_varchar2) <>
707: nvl(p_rec.poei_information17, hr_api.g_varchar2) or
708: nvl(pe_poi_shd.g_old_rec.poei_information18, hr_api.g_varchar2) <>

Line 706: nvl(pe_poi_shd.g_old_rec.poei_information17, hr_api.g_varchar2) <>

702: nvl(pe_poi_shd.g_old_rec.poei_information15, hr_api.g_varchar2) <>
703: nvl(p_rec.poei_information15, hr_api.g_varchar2) or
704: nvl(pe_poi_shd.g_old_rec.poei_information16, hr_api.g_varchar2) <>
705: nvl(p_rec.poei_information16, hr_api.g_varchar2) or
706: nvl(pe_poi_shd.g_old_rec.poei_information17, hr_api.g_varchar2) <>
707: nvl(p_rec.poei_information17, hr_api.g_varchar2) or
708: nvl(pe_poi_shd.g_old_rec.poei_information18, hr_api.g_varchar2) <>
709: nvl(p_rec.poei_information18, hr_api.g_varchar2) or
710: nvl(pe_poi_shd.g_old_rec.poei_information19, hr_api.g_varchar2) <>

Line 708: nvl(pe_poi_shd.g_old_rec.poei_information18, hr_api.g_varchar2) <>

704: nvl(pe_poi_shd.g_old_rec.poei_information16, hr_api.g_varchar2) <>
705: nvl(p_rec.poei_information16, hr_api.g_varchar2) or
706: nvl(pe_poi_shd.g_old_rec.poei_information17, hr_api.g_varchar2) <>
707: nvl(p_rec.poei_information17, hr_api.g_varchar2) or
708: nvl(pe_poi_shd.g_old_rec.poei_information18, hr_api.g_varchar2) <>
709: nvl(p_rec.poei_information18, hr_api.g_varchar2) or
710: nvl(pe_poi_shd.g_old_rec.poei_information19, hr_api.g_varchar2) <>
711: nvl(p_rec.poei_information19, hr_api.g_varchar2) or
712: nvl(pe_poi_shd.g_old_rec.poei_information20, hr_api.g_varchar2) <>

Line 710: nvl(pe_poi_shd.g_old_rec.poei_information19, hr_api.g_varchar2) <>

706: nvl(pe_poi_shd.g_old_rec.poei_information17, hr_api.g_varchar2) <>
707: nvl(p_rec.poei_information17, hr_api.g_varchar2) or
708: nvl(pe_poi_shd.g_old_rec.poei_information18, hr_api.g_varchar2) <>
709: nvl(p_rec.poei_information18, hr_api.g_varchar2) or
710: nvl(pe_poi_shd.g_old_rec.poei_information19, hr_api.g_varchar2) <>
711: nvl(p_rec.poei_information19, hr_api.g_varchar2) or
712: nvl(pe_poi_shd.g_old_rec.poei_information20, hr_api.g_varchar2) <>
713: nvl(p_rec.poei_information20, hr_api.g_varchar2) or
714: nvl(pe_poi_shd.g_old_rec.poei_information21, hr_api.g_varchar2) <>

Line 712: nvl(pe_poi_shd.g_old_rec.poei_information20, hr_api.g_varchar2) <>

708: nvl(pe_poi_shd.g_old_rec.poei_information18, hr_api.g_varchar2) <>
709: nvl(p_rec.poei_information18, hr_api.g_varchar2) or
710: nvl(pe_poi_shd.g_old_rec.poei_information19, hr_api.g_varchar2) <>
711: nvl(p_rec.poei_information19, hr_api.g_varchar2) or
712: nvl(pe_poi_shd.g_old_rec.poei_information20, hr_api.g_varchar2) <>
713: nvl(p_rec.poei_information20, hr_api.g_varchar2) or
714: nvl(pe_poi_shd.g_old_rec.poei_information21, hr_api.g_varchar2) <>
715: nvl(p_rec.poei_information21, hr_api.g_varchar2) or
716: nvl(pe_poi_shd.g_old_rec.poei_information22, hr_api.g_varchar2) <>

Line 714: nvl(pe_poi_shd.g_old_rec.poei_information21, hr_api.g_varchar2) <>

710: nvl(pe_poi_shd.g_old_rec.poei_information19, hr_api.g_varchar2) <>
711: nvl(p_rec.poei_information19, hr_api.g_varchar2) or
712: nvl(pe_poi_shd.g_old_rec.poei_information20, hr_api.g_varchar2) <>
713: nvl(p_rec.poei_information20, hr_api.g_varchar2) or
714: nvl(pe_poi_shd.g_old_rec.poei_information21, hr_api.g_varchar2) <>
715: nvl(p_rec.poei_information21, hr_api.g_varchar2) or
716: nvl(pe_poi_shd.g_old_rec.poei_information22, hr_api.g_varchar2) <>
717: nvl(p_rec.poei_information22, hr_api.g_varchar2) or
718: nvl(pe_poi_shd.g_old_rec.poei_information23, hr_api.g_varchar2) <>

Line 716: nvl(pe_poi_shd.g_old_rec.poei_information22, hr_api.g_varchar2) <>

712: nvl(pe_poi_shd.g_old_rec.poei_information20, hr_api.g_varchar2) <>
713: nvl(p_rec.poei_information20, hr_api.g_varchar2) or
714: nvl(pe_poi_shd.g_old_rec.poei_information21, hr_api.g_varchar2) <>
715: nvl(p_rec.poei_information21, hr_api.g_varchar2) or
716: nvl(pe_poi_shd.g_old_rec.poei_information22, hr_api.g_varchar2) <>
717: nvl(p_rec.poei_information22, hr_api.g_varchar2) or
718: nvl(pe_poi_shd.g_old_rec.poei_information23, hr_api.g_varchar2) <>
719: nvl(p_rec.poei_information23, hr_api.g_varchar2) or
720: nvl(pe_poi_shd.g_old_rec.poei_information24, hr_api.g_varchar2) <>

Line 718: nvl(pe_poi_shd.g_old_rec.poei_information23, hr_api.g_varchar2) <>

714: nvl(pe_poi_shd.g_old_rec.poei_information21, hr_api.g_varchar2) <>
715: nvl(p_rec.poei_information21, hr_api.g_varchar2) or
716: nvl(pe_poi_shd.g_old_rec.poei_information22, hr_api.g_varchar2) <>
717: nvl(p_rec.poei_information22, hr_api.g_varchar2) or
718: nvl(pe_poi_shd.g_old_rec.poei_information23, hr_api.g_varchar2) <>
719: nvl(p_rec.poei_information23, hr_api.g_varchar2) or
720: nvl(pe_poi_shd.g_old_rec.poei_information24, hr_api.g_varchar2) <>
721: nvl(p_rec.poei_information24, hr_api.g_varchar2) or
722: nvl(pe_poi_shd.g_old_rec.poei_information25, hr_api.g_varchar2) <>

Line 720: nvl(pe_poi_shd.g_old_rec.poei_information24, hr_api.g_varchar2) <>

716: nvl(pe_poi_shd.g_old_rec.poei_information22, hr_api.g_varchar2) <>
717: nvl(p_rec.poei_information22, hr_api.g_varchar2) or
718: nvl(pe_poi_shd.g_old_rec.poei_information23, hr_api.g_varchar2) <>
719: nvl(p_rec.poei_information23, hr_api.g_varchar2) or
720: nvl(pe_poi_shd.g_old_rec.poei_information24, hr_api.g_varchar2) <>
721: nvl(p_rec.poei_information24, hr_api.g_varchar2) or
722: nvl(pe_poi_shd.g_old_rec.poei_information25, hr_api.g_varchar2) <>
723: nvl(p_rec.poei_information25, hr_api.g_varchar2) or
724: nvl(pe_poi_shd.g_old_rec.poei_information26, hr_api.g_varchar2) <>

Line 722: nvl(pe_poi_shd.g_old_rec.poei_information25, hr_api.g_varchar2) <>

718: nvl(pe_poi_shd.g_old_rec.poei_information23, hr_api.g_varchar2) <>
719: nvl(p_rec.poei_information23, hr_api.g_varchar2) or
720: nvl(pe_poi_shd.g_old_rec.poei_information24, hr_api.g_varchar2) <>
721: nvl(p_rec.poei_information24, hr_api.g_varchar2) or
722: nvl(pe_poi_shd.g_old_rec.poei_information25, hr_api.g_varchar2) <>
723: nvl(p_rec.poei_information25, hr_api.g_varchar2) or
724: nvl(pe_poi_shd.g_old_rec.poei_information26, hr_api.g_varchar2) <>
725: nvl(p_rec.poei_information26, hr_api.g_varchar2) or
726: nvl(pe_poi_shd.g_old_rec.poei_information27, hr_api.g_varchar2) <>

Line 724: nvl(pe_poi_shd.g_old_rec.poei_information26, hr_api.g_varchar2) <>

720: nvl(pe_poi_shd.g_old_rec.poei_information24, hr_api.g_varchar2) <>
721: nvl(p_rec.poei_information24, hr_api.g_varchar2) or
722: nvl(pe_poi_shd.g_old_rec.poei_information25, hr_api.g_varchar2) <>
723: nvl(p_rec.poei_information25, hr_api.g_varchar2) or
724: nvl(pe_poi_shd.g_old_rec.poei_information26, hr_api.g_varchar2) <>
725: nvl(p_rec.poei_information26, hr_api.g_varchar2) or
726: nvl(pe_poi_shd.g_old_rec.poei_information27, hr_api.g_varchar2) <>
727: nvl(p_rec.poei_information27, hr_api.g_varchar2) or
728: nvl(pe_poi_shd.g_old_rec.poei_information28, hr_api.g_varchar2) <>

Line 726: nvl(pe_poi_shd.g_old_rec.poei_information27, hr_api.g_varchar2) <>

722: nvl(pe_poi_shd.g_old_rec.poei_information25, hr_api.g_varchar2) <>
723: nvl(p_rec.poei_information25, hr_api.g_varchar2) or
724: nvl(pe_poi_shd.g_old_rec.poei_information26, hr_api.g_varchar2) <>
725: nvl(p_rec.poei_information26, hr_api.g_varchar2) or
726: nvl(pe_poi_shd.g_old_rec.poei_information27, hr_api.g_varchar2) <>
727: nvl(p_rec.poei_information27, hr_api.g_varchar2) or
728: nvl(pe_poi_shd.g_old_rec.poei_information28, hr_api.g_varchar2) <>
729: nvl(p_rec.poei_information28, hr_api.g_varchar2) or
730: nvl(pe_poi_shd.g_old_rec.poei_information29, hr_api.g_varchar2) <>

Line 728: nvl(pe_poi_shd.g_old_rec.poei_information28, hr_api.g_varchar2) <>

724: nvl(pe_poi_shd.g_old_rec.poei_information26, hr_api.g_varchar2) <>
725: nvl(p_rec.poei_information26, hr_api.g_varchar2) or
726: nvl(pe_poi_shd.g_old_rec.poei_information27, hr_api.g_varchar2) <>
727: nvl(p_rec.poei_information27, hr_api.g_varchar2) or
728: nvl(pe_poi_shd.g_old_rec.poei_information28, hr_api.g_varchar2) <>
729: nvl(p_rec.poei_information28, hr_api.g_varchar2) or
730: nvl(pe_poi_shd.g_old_rec.poei_information29, hr_api.g_varchar2) <>
731: nvl(p_rec.poei_information29, hr_api.g_varchar2) or
732: nvl(pe_poi_shd.g_old_rec.poei_information30, hr_api.g_varchar2) <>

Line 730: nvl(pe_poi_shd.g_old_rec.poei_information29, hr_api.g_varchar2) <>

726: nvl(pe_poi_shd.g_old_rec.poei_information27, hr_api.g_varchar2) <>
727: nvl(p_rec.poei_information27, hr_api.g_varchar2) or
728: nvl(pe_poi_shd.g_old_rec.poei_information28, hr_api.g_varchar2) <>
729: nvl(p_rec.poei_information28, hr_api.g_varchar2) or
730: nvl(pe_poi_shd.g_old_rec.poei_information29, hr_api.g_varchar2) <>
731: nvl(p_rec.poei_information29, hr_api.g_varchar2) or
732: nvl(pe_poi_shd.g_old_rec.poei_information30, hr_api.g_varchar2) <>
733: nvl(p_rec.poei_information30, hr_api.g_varchar2))
734: then

Line 732: nvl(pe_poi_shd.g_old_rec.poei_information30, hr_api.g_varchar2) <>

728: nvl(pe_poi_shd.g_old_rec.poei_information28, hr_api.g_varchar2) <>
729: nvl(p_rec.poei_information28, hr_api.g_varchar2) or
730: nvl(pe_poi_shd.g_old_rec.poei_information29, hr_api.g_varchar2) <>
731: nvl(p_rec.poei_information29, hr_api.g_varchar2) or
732: nvl(pe_poi_shd.g_old_rec.poei_information30, hr_api.g_varchar2) <>
733: nvl(p_rec.poei_information30, hr_api.g_varchar2))
734: then
735: --
736: hr_dflex_utility.ins_or_upd_descflex_attribs

Line 810: function permit_extended_pay_poi(p_rec in pe_poi_shd.g_rec_type) return boolean is

806: --
807: -- --------------------------------------------------------------------------------
808: -- |---------------------------< permit_extended_pay_poi >----------------------------|
809: -- --------------------------------------------------------------------------------
810: function permit_extended_pay_poi(p_rec in pe_poi_shd.g_rec_type) return boolean is
811: l_position_family varchar2(100);
812: l_chk boolean := false;
813: cursor c1 is
814: select poei_information3

Line 868: procedure chk_position_family(p_work_period_type_cd varchar2, p_rec in pe_poi_shd.g_rec_type) is

864: --
865: -- --------------------------------------------------------------------------------
866: -- |---------------------------< chk_position_family >----------------------------|
867: -- --------------------------------------------------------------------------------
868: procedure chk_position_family(p_work_period_type_cd varchar2, p_rec in pe_poi_shd.g_rec_type) is
869: begin
870: if ( nvl(p_work_period_type_cd,'N') = 'Y' ) then
871: if (not permit_extended_pay_poi(p_rec)) then
872: -- Cannot change Position Family of Position Extra Info

Line 883: Procedure insert_validate(p_rec in pe_poi_shd.g_rec_type) is

879: --
880: -- ----------------------------------------------------------------------------
881: -- |---------------------------< insert_validate >----------------------------|
882: -- ----------------------------------------------------------------------------
883: Procedure insert_validate(p_rec in pe_poi_shd.g_rec_type) is
884: --
885: l_proc varchar2(72) := g_package||'insert_validate';
886: l_position_rec hr_all_positions_f%rowtype;
887: l_position_start_date date;

Line 1038: Procedure update_validate(p_rec in pe_poi_shd.g_rec_type) is

1034: --
1035: -- ----------------------------------------------------------------------------
1036: -- |---------------------------< update_validate >----------------------------|
1037: -- ----------------------------------------------------------------------------
1038: Procedure update_validate(p_rec in pe_poi_shd.g_rec_type) is
1039: --
1040: l_proc varchar2(72) := g_package||'update_validate';
1041: l_position_rec hr_all_positions_f%rowtype;
1042: l_position_start_date date;

Line 1167: Procedure delete_validate(p_rec in pe_poi_shd.g_rec_type) is

1163: --
1164: -- ----------------------------------------------------------------------------
1165: -- |---------------------------< delete_validate >----------------------------|
1166: -- ----------------------------------------------------------------------------
1167: Procedure delete_validate(p_rec in pe_poi_shd.g_rec_type) is
1168: --
1169: l_proc varchar2(72) := g_package||'delete_validate';
1170: l_position_rec hr_all_positions_f%rowtype;
1171: l_effective_date date := trunc(sysdate);