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.PER_ORS_BUS dependencies on PER_ORS_SHD

Line 454: (p_rec in per_ors_shd.g_rec_type

450: -- Internal Row Handler Use Only.
451: --
452: -- ----------------------------------------------------------------------------
453: procedure chk_df
454: (p_rec in per_ors_shd.g_rec_type
455: ) is
456: --
457: l_proc varchar2(72) := g_package || 'chk_df';
458: --

Line 463: nvl(per_ors_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

459: begin
460: hr_utility.set_location('Entering:'||l_proc,10);
461: --
462: if ((p_rec.organization_structure_id is not null) and (
463: nvl(per_ors_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
464: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
465: nvl(per_ors_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
466: nvl(p_rec.attribute1, hr_api.g_varchar2) or
467: nvl(per_ors_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

Line 465: nvl(per_ors_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

461: --
462: if ((p_rec.organization_structure_id is not null) and (
463: nvl(per_ors_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
464: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
465: nvl(per_ors_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
466: nvl(p_rec.attribute1, hr_api.g_varchar2) or
467: nvl(per_ors_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
468: nvl(p_rec.attribute2, hr_api.g_varchar2) or
469: nvl(per_ors_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

Line 467: nvl(per_ors_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

463: nvl(per_ors_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
464: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
465: nvl(per_ors_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
466: nvl(p_rec.attribute1, hr_api.g_varchar2) or
467: nvl(per_ors_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
468: nvl(p_rec.attribute2, hr_api.g_varchar2) or
469: nvl(per_ors_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
470: nvl(p_rec.attribute3, hr_api.g_varchar2) or
471: nvl(per_ors_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

Line 469: nvl(per_ors_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

465: nvl(per_ors_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
466: nvl(p_rec.attribute1, hr_api.g_varchar2) or
467: nvl(per_ors_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
468: nvl(p_rec.attribute2, hr_api.g_varchar2) or
469: nvl(per_ors_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
470: nvl(p_rec.attribute3, hr_api.g_varchar2) or
471: nvl(per_ors_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
472: nvl(p_rec.attribute4, hr_api.g_varchar2) or
473: nvl(per_ors_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

Line 471: nvl(per_ors_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

467: nvl(per_ors_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
468: nvl(p_rec.attribute2, hr_api.g_varchar2) or
469: nvl(per_ors_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
470: nvl(p_rec.attribute3, hr_api.g_varchar2) or
471: nvl(per_ors_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
472: nvl(p_rec.attribute4, hr_api.g_varchar2) or
473: nvl(per_ors_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
474: nvl(p_rec.attribute5, hr_api.g_varchar2) or
475: nvl(per_ors_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

Line 473: nvl(per_ors_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

469: nvl(per_ors_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
470: nvl(p_rec.attribute3, hr_api.g_varchar2) or
471: nvl(per_ors_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
472: nvl(p_rec.attribute4, hr_api.g_varchar2) or
473: nvl(per_ors_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
474: nvl(p_rec.attribute5, hr_api.g_varchar2) or
475: nvl(per_ors_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
476: nvl(p_rec.attribute6, hr_api.g_varchar2) or
477: nvl(per_ors_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

Line 475: nvl(per_ors_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

471: nvl(per_ors_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
472: nvl(p_rec.attribute4, hr_api.g_varchar2) or
473: nvl(per_ors_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
474: nvl(p_rec.attribute5, hr_api.g_varchar2) or
475: nvl(per_ors_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
476: nvl(p_rec.attribute6, hr_api.g_varchar2) or
477: nvl(per_ors_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
478: nvl(p_rec.attribute7, hr_api.g_varchar2) or
479: nvl(per_ors_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

Line 477: nvl(per_ors_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

473: nvl(per_ors_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
474: nvl(p_rec.attribute5, hr_api.g_varchar2) or
475: nvl(per_ors_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
476: nvl(p_rec.attribute6, hr_api.g_varchar2) or
477: nvl(per_ors_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
478: nvl(p_rec.attribute7, hr_api.g_varchar2) or
479: nvl(per_ors_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
480: nvl(p_rec.attribute8, hr_api.g_varchar2) or
481: nvl(per_ors_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

Line 479: nvl(per_ors_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

475: nvl(per_ors_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
476: nvl(p_rec.attribute6, hr_api.g_varchar2) or
477: nvl(per_ors_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
478: nvl(p_rec.attribute7, hr_api.g_varchar2) or
479: nvl(per_ors_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
480: nvl(p_rec.attribute8, hr_api.g_varchar2) or
481: nvl(per_ors_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
482: nvl(p_rec.attribute9, hr_api.g_varchar2) or
483: nvl(per_ors_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

Line 481: nvl(per_ors_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

477: nvl(per_ors_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
478: nvl(p_rec.attribute7, hr_api.g_varchar2) or
479: nvl(per_ors_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
480: nvl(p_rec.attribute8, hr_api.g_varchar2) or
481: nvl(per_ors_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
482: nvl(p_rec.attribute9, hr_api.g_varchar2) or
483: nvl(per_ors_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
484: nvl(p_rec.attribute10, hr_api.g_varchar2) or
485: nvl(per_ors_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

Line 483: nvl(per_ors_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

479: nvl(per_ors_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
480: nvl(p_rec.attribute8, hr_api.g_varchar2) or
481: nvl(per_ors_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
482: nvl(p_rec.attribute9, hr_api.g_varchar2) or
483: nvl(per_ors_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
484: nvl(p_rec.attribute10, hr_api.g_varchar2) or
485: nvl(per_ors_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
486: nvl(p_rec.attribute11, hr_api.g_varchar2) or
487: nvl(per_ors_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

Line 485: nvl(per_ors_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

481: nvl(per_ors_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
482: nvl(p_rec.attribute9, hr_api.g_varchar2) or
483: nvl(per_ors_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
484: nvl(p_rec.attribute10, hr_api.g_varchar2) or
485: nvl(per_ors_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
486: nvl(p_rec.attribute11, hr_api.g_varchar2) or
487: nvl(per_ors_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
488: nvl(p_rec.attribute12, hr_api.g_varchar2) or
489: nvl(per_ors_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

Line 487: nvl(per_ors_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

483: nvl(per_ors_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
484: nvl(p_rec.attribute10, hr_api.g_varchar2) or
485: nvl(per_ors_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
486: nvl(p_rec.attribute11, hr_api.g_varchar2) or
487: nvl(per_ors_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
488: nvl(p_rec.attribute12, hr_api.g_varchar2) or
489: nvl(per_ors_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
490: nvl(p_rec.attribute13, hr_api.g_varchar2) or
491: nvl(per_ors_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

Line 489: nvl(per_ors_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

485: nvl(per_ors_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
486: nvl(p_rec.attribute11, hr_api.g_varchar2) or
487: nvl(per_ors_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
488: nvl(p_rec.attribute12, hr_api.g_varchar2) or
489: nvl(per_ors_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
490: nvl(p_rec.attribute13, hr_api.g_varchar2) or
491: nvl(per_ors_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
492: nvl(p_rec.attribute14, hr_api.g_varchar2) or
493: nvl(per_ors_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

Line 491: nvl(per_ors_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

487: nvl(per_ors_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
488: nvl(p_rec.attribute12, hr_api.g_varchar2) or
489: nvl(per_ors_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
490: nvl(p_rec.attribute13, hr_api.g_varchar2) or
491: nvl(per_ors_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
492: nvl(p_rec.attribute14, hr_api.g_varchar2) or
493: nvl(per_ors_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
494: nvl(p_rec.attribute15, hr_api.g_varchar2) or
495: nvl(per_ors_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

Line 493: nvl(per_ors_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

489: nvl(per_ors_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
490: nvl(p_rec.attribute13, hr_api.g_varchar2) or
491: nvl(per_ors_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
492: nvl(p_rec.attribute14, hr_api.g_varchar2) or
493: nvl(per_ors_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
494: nvl(p_rec.attribute15, hr_api.g_varchar2) or
495: nvl(per_ors_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
496: nvl(p_rec.attribute16, hr_api.g_varchar2) or
497: nvl(per_ors_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

Line 495: nvl(per_ors_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

491: nvl(per_ors_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
492: nvl(p_rec.attribute14, hr_api.g_varchar2) or
493: nvl(per_ors_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
494: nvl(p_rec.attribute15, hr_api.g_varchar2) or
495: nvl(per_ors_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
496: nvl(p_rec.attribute16, hr_api.g_varchar2) or
497: nvl(per_ors_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
498: nvl(p_rec.attribute17, hr_api.g_varchar2) or
499: nvl(per_ors_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

Line 497: nvl(per_ors_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

493: nvl(per_ors_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
494: nvl(p_rec.attribute15, hr_api.g_varchar2) or
495: nvl(per_ors_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
496: nvl(p_rec.attribute16, hr_api.g_varchar2) or
497: nvl(per_ors_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
498: nvl(p_rec.attribute17, hr_api.g_varchar2) or
499: nvl(per_ors_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
500: nvl(p_rec.attribute18, hr_api.g_varchar2) or
501: nvl(per_ors_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

Line 499: nvl(per_ors_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

495: nvl(per_ors_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
496: nvl(p_rec.attribute16, hr_api.g_varchar2) or
497: nvl(per_ors_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
498: nvl(p_rec.attribute17, hr_api.g_varchar2) or
499: nvl(per_ors_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
500: nvl(p_rec.attribute18, hr_api.g_varchar2) or
501: nvl(per_ors_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
502: nvl(p_rec.attribute19, hr_api.g_varchar2) or
503: nvl(per_ors_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

Line 501: nvl(per_ors_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

497: nvl(per_ors_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
498: nvl(p_rec.attribute17, hr_api.g_varchar2) or
499: nvl(per_ors_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
500: nvl(p_rec.attribute18, hr_api.g_varchar2) or
501: nvl(per_ors_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
502: nvl(p_rec.attribute19, hr_api.g_varchar2) or
503: nvl(per_ors_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
504: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
505: or (p_rec.organization_structure_id is null) then

Line 503: nvl(per_ors_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

499: nvl(per_ors_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
500: nvl(p_rec.attribute18, hr_api.g_varchar2) or
501: nvl(per_ors_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
502: nvl(p_rec.attribute19, hr_api.g_varchar2) or
503: nvl(per_ors_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
504: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
505: or (p_rec.organization_structure_id is null) then
506: --
507: -- Only execute the validation if absolutely necessary:

Line 591: ,p_rec in per_ors_shd.g_rec_type

587: -- {End Of Comments}
588: -- ----------------------------------------------------------------------------
589: Procedure chk_non_updateable_args
590: (p_effective_date in date
591: ,p_rec in per_ors_shd.g_rec_type
592: ) IS
593: --
594: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
595: l_error EXCEPTION;

Line 603: IF NOT per_ors_shd.api_updating

599: --
600: -- Only proceed with the validation if a row exists for the current
601: -- record in the HR Schema.
602: --
603: IF NOT per_ors_shd.api_updating
604: (p_organization_structure_id => p_rec.organization_structure_id
605: ,p_object_version_number => p_rec.object_version_number
606: ) THEN
607: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 627: ,p_rec in per_ors_shd.g_rec_type

623: -- |---------------------------< insert_validate >----------------------------|
624: -- ----------------------------------------------------------------------------
625: Procedure insert_validate
626: (p_effective_date in date
627: ,p_rec in per_ors_shd.g_rec_type
628: ) is
629: --
630: l_proc varchar2(72) := g_package||'insert_validate';
631: --

Line 673: ,p_rec in per_ors_shd.g_rec_type

669: -- |---------------------------< update_validate >----------------------------|
670: -- ----------------------------------------------------------------------------
671: Procedure update_validate
672: (p_effective_date in date
673: ,p_rec in per_ors_shd.g_rec_type
674: ) is
675: --
676: l_proc varchar2(72) := g_package||'update_validate';
677: --

Line 722: (p_rec in per_ors_shd.g_rec_type

718: -- ----------------------------------------------------------------------------
719: -- |---------------------------< delete_validate >----------------------------|
720: -- ----------------------------------------------------------------------------
721: Procedure delete_validate
722: (p_rec in per_ors_shd.g_rec_type
723: ) is
724: --
725: l_proc varchar2(72) := g_package||'delete_validate';
726: --