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_VGR_BUS dependencies on PER_VGR_SHD

Line 195: l_api_updating := per_vgr_shd.api_updating

191: -- Only proceed with validation if :
192: -- a) The current g_old_rec is current and
193: -- b) The date_from value has changed
194: --
195: l_api_updating := per_vgr_shd.api_updating
196: (p_valid_grade_id => p_valid_grade_id
197: ,p_object_version_number => p_object_version_number);
198: --
199: if ((l_api_updating and per_vgr_shd.g_old_rec.date_from <> p_date_from) or

Line 199: if ((l_api_updating and per_vgr_shd.g_old_rec.date_from <> p_date_from) or

195: l_api_updating := per_vgr_shd.api_updating
196: (p_valid_grade_id => p_valid_grade_id
197: ,p_object_version_number => p_object_version_number);
198: --
199: if ((l_api_updating and per_vgr_shd.g_old_rec.date_from <> p_date_from) or
200: (NOT l_api_updating)) then
201: hr_utility.set_location(l_proc, 2);
202: --
203: -- Check that the date_from value is less than or equal to the date_to

Line 630: l_api_updating := per_vgr_shd.api_updating

626: -- Only proceed with validation if :
627: -- a) The current g_old_rec is current and
628: -- b) The date_to value has changed
629: --
630: l_api_updating := per_vgr_shd.api_updating
631: (p_valid_grade_id => p_valid_grade_id
632: ,p_object_version_number => p_object_version_number);
633: --
634: if ((l_api_updating and

Line 635: nvl(per_vgr_shd.g_old_rec.date_to, hr_api.g_eot) <>

631: (p_valid_grade_id => p_valid_grade_id
632: ,p_object_version_number => p_object_version_number);
633: --
634: if ((l_api_updating and
635: nvl(per_vgr_shd.g_old_rec.date_to, hr_api.g_eot) <>
636: nvl(p_date_to, hr_api.g_eot)) or
637: (NOT l_api_updating)) then
638: hr_utility.set_location(l_proc, 2);
639: --

Line 722: (p_rec in per_vgr_shd.g_rec_type) is

718: -- Access Status:
719: -- Internal Row Handler Use Only.
720: --
721: procedure chk_df
722: (p_rec in per_vgr_shd.g_rec_type) is
723: --
724: l_proc varchar2(72) := g_package||'chk_df';
725: --
726: begin

Line 730: nvl(per_vgr_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

726: begin
727: hr_utility.set_location('Entering:'||l_proc, 10);
728: --
729: if ((p_rec.valid_grade_id is not null) and (
730: nvl(per_vgr_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
731: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
732: nvl(per_vgr_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
733: nvl(p_rec.attribute1, hr_api.g_varchar2) or
734: nvl(per_vgr_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

Line 732: nvl(per_vgr_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

728: --
729: if ((p_rec.valid_grade_id is not null) and (
730: nvl(per_vgr_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
731: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
732: nvl(per_vgr_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
733: nvl(p_rec.attribute1, hr_api.g_varchar2) or
734: nvl(per_vgr_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
735: nvl(p_rec.attribute2, hr_api.g_varchar2) or
736: nvl(per_vgr_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

Line 734: nvl(per_vgr_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

730: nvl(per_vgr_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
731: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
732: nvl(per_vgr_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
733: nvl(p_rec.attribute1, hr_api.g_varchar2) or
734: nvl(per_vgr_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
735: nvl(p_rec.attribute2, hr_api.g_varchar2) or
736: nvl(per_vgr_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
737: nvl(p_rec.attribute3, hr_api.g_varchar2) or
738: nvl(per_vgr_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

Line 736: nvl(per_vgr_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

732: nvl(per_vgr_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
733: nvl(p_rec.attribute1, hr_api.g_varchar2) or
734: nvl(per_vgr_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
735: nvl(p_rec.attribute2, hr_api.g_varchar2) or
736: nvl(per_vgr_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
737: nvl(p_rec.attribute3, hr_api.g_varchar2) or
738: nvl(per_vgr_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
739: nvl(p_rec.attribute4, hr_api.g_varchar2) or
740: nvl(per_vgr_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

Line 738: nvl(per_vgr_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

734: nvl(per_vgr_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
735: nvl(p_rec.attribute2, hr_api.g_varchar2) or
736: nvl(per_vgr_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
737: nvl(p_rec.attribute3, hr_api.g_varchar2) or
738: nvl(per_vgr_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
739: nvl(p_rec.attribute4, hr_api.g_varchar2) or
740: nvl(per_vgr_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
741: nvl(p_rec.attribute5, hr_api.g_varchar2) or
742: nvl(per_vgr_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

Line 740: nvl(per_vgr_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

736: nvl(per_vgr_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
737: nvl(p_rec.attribute3, hr_api.g_varchar2) or
738: nvl(per_vgr_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
739: nvl(p_rec.attribute4, hr_api.g_varchar2) or
740: nvl(per_vgr_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
741: nvl(p_rec.attribute5, hr_api.g_varchar2) or
742: nvl(per_vgr_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
743: nvl(p_rec.attribute6, hr_api.g_varchar2) or
744: nvl(per_vgr_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

Line 742: nvl(per_vgr_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

738: nvl(per_vgr_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
739: nvl(p_rec.attribute4, hr_api.g_varchar2) or
740: nvl(per_vgr_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
741: nvl(p_rec.attribute5, hr_api.g_varchar2) or
742: nvl(per_vgr_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
743: nvl(p_rec.attribute6, hr_api.g_varchar2) or
744: nvl(per_vgr_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
745: nvl(p_rec.attribute7, hr_api.g_varchar2) or
746: nvl(per_vgr_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

Line 744: nvl(per_vgr_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

740: nvl(per_vgr_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
741: nvl(p_rec.attribute5, hr_api.g_varchar2) or
742: nvl(per_vgr_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
743: nvl(p_rec.attribute6, hr_api.g_varchar2) or
744: nvl(per_vgr_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
745: nvl(p_rec.attribute7, hr_api.g_varchar2) or
746: nvl(per_vgr_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
747: nvl(p_rec.attribute8, hr_api.g_varchar2) or
748: nvl(per_vgr_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

Line 746: nvl(per_vgr_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

742: nvl(per_vgr_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
743: nvl(p_rec.attribute6, hr_api.g_varchar2) or
744: nvl(per_vgr_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
745: nvl(p_rec.attribute7, hr_api.g_varchar2) or
746: nvl(per_vgr_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
747: nvl(p_rec.attribute8, hr_api.g_varchar2) or
748: nvl(per_vgr_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
749: nvl(p_rec.attribute9, hr_api.g_varchar2) or
750: nvl(per_vgr_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

Line 748: nvl(per_vgr_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

744: nvl(per_vgr_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
745: nvl(p_rec.attribute7, hr_api.g_varchar2) or
746: nvl(per_vgr_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
747: nvl(p_rec.attribute8, hr_api.g_varchar2) or
748: nvl(per_vgr_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
749: nvl(p_rec.attribute9, hr_api.g_varchar2) or
750: nvl(per_vgr_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
751: nvl(p_rec.attribute10, hr_api.g_varchar2) or
752: nvl(per_vgr_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

Line 750: nvl(per_vgr_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

746: nvl(per_vgr_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
747: nvl(p_rec.attribute8, hr_api.g_varchar2) or
748: nvl(per_vgr_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
749: nvl(p_rec.attribute9, hr_api.g_varchar2) or
750: nvl(per_vgr_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
751: nvl(p_rec.attribute10, hr_api.g_varchar2) or
752: nvl(per_vgr_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
753: nvl(p_rec.attribute11, hr_api.g_varchar2) or
754: nvl(per_vgr_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

Line 752: nvl(per_vgr_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

748: nvl(per_vgr_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
749: nvl(p_rec.attribute9, hr_api.g_varchar2) or
750: nvl(per_vgr_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
751: nvl(p_rec.attribute10, hr_api.g_varchar2) or
752: nvl(per_vgr_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
753: nvl(p_rec.attribute11, hr_api.g_varchar2) or
754: nvl(per_vgr_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
755: nvl(p_rec.attribute12, hr_api.g_varchar2) or
756: nvl(per_vgr_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

Line 754: nvl(per_vgr_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

750: nvl(per_vgr_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
751: nvl(p_rec.attribute10, hr_api.g_varchar2) or
752: nvl(per_vgr_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
753: nvl(p_rec.attribute11, hr_api.g_varchar2) or
754: nvl(per_vgr_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
755: nvl(p_rec.attribute12, hr_api.g_varchar2) or
756: nvl(per_vgr_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
757: nvl(p_rec.attribute13, hr_api.g_varchar2) or
758: nvl(per_vgr_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

Line 756: nvl(per_vgr_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

752: nvl(per_vgr_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
753: nvl(p_rec.attribute11, hr_api.g_varchar2) or
754: nvl(per_vgr_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
755: nvl(p_rec.attribute12, hr_api.g_varchar2) or
756: nvl(per_vgr_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
757: nvl(p_rec.attribute13, hr_api.g_varchar2) or
758: nvl(per_vgr_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
759: nvl(p_rec.attribute14, hr_api.g_varchar2) or
760: nvl(per_vgr_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

Line 758: nvl(per_vgr_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

754: nvl(per_vgr_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
755: nvl(p_rec.attribute12, hr_api.g_varchar2) or
756: nvl(per_vgr_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
757: nvl(p_rec.attribute13, hr_api.g_varchar2) or
758: nvl(per_vgr_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
759: nvl(p_rec.attribute14, hr_api.g_varchar2) or
760: nvl(per_vgr_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
761: nvl(p_rec.attribute15, hr_api.g_varchar2) or
762: nvl(per_vgr_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

Line 760: nvl(per_vgr_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

756: nvl(per_vgr_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
757: nvl(p_rec.attribute13, hr_api.g_varchar2) or
758: nvl(per_vgr_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
759: nvl(p_rec.attribute14, hr_api.g_varchar2) or
760: nvl(per_vgr_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
761: nvl(p_rec.attribute15, hr_api.g_varchar2) or
762: nvl(per_vgr_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
763: nvl(p_rec.attribute16, hr_api.g_varchar2) or
764: nvl(per_vgr_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

Line 762: nvl(per_vgr_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

758: nvl(per_vgr_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
759: nvl(p_rec.attribute14, hr_api.g_varchar2) or
760: nvl(per_vgr_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
761: nvl(p_rec.attribute15, hr_api.g_varchar2) or
762: nvl(per_vgr_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
763: nvl(p_rec.attribute16, hr_api.g_varchar2) or
764: nvl(per_vgr_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
765: nvl(p_rec.attribute17, hr_api.g_varchar2) or
766: nvl(per_vgr_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

Line 764: nvl(per_vgr_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

760: nvl(per_vgr_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
761: nvl(p_rec.attribute15, hr_api.g_varchar2) or
762: nvl(per_vgr_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
763: nvl(p_rec.attribute16, hr_api.g_varchar2) or
764: nvl(per_vgr_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
765: nvl(p_rec.attribute17, hr_api.g_varchar2) or
766: nvl(per_vgr_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
767: nvl(p_rec.attribute18, hr_api.g_varchar2) or
768: nvl(per_vgr_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

Line 766: nvl(per_vgr_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

762: nvl(per_vgr_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
763: nvl(p_rec.attribute16, hr_api.g_varchar2) or
764: nvl(per_vgr_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
765: nvl(p_rec.attribute17, hr_api.g_varchar2) or
766: nvl(per_vgr_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
767: nvl(p_rec.attribute18, hr_api.g_varchar2) or
768: nvl(per_vgr_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
769: nvl(p_rec.attribute19, hr_api.g_varchar2) or
770: nvl(per_vgr_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

Line 768: nvl(per_vgr_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

764: nvl(per_vgr_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
765: nvl(p_rec.attribute17, hr_api.g_varchar2) or
766: nvl(per_vgr_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
767: nvl(p_rec.attribute18, hr_api.g_varchar2) or
768: nvl(per_vgr_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
769: nvl(p_rec.attribute19, hr_api.g_varchar2) or
770: nvl(per_vgr_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
771: nvl(p_rec.attribute20, hr_api.g_varchar2)))
772: or

Line 770: nvl(per_vgr_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

766: nvl(per_vgr_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
767: nvl(p_rec.attribute18, hr_api.g_varchar2) or
768: nvl(per_vgr_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
769: nvl(p_rec.attribute19, hr_api.g_varchar2) or
770: nvl(per_vgr_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
771: nvl(p_rec.attribute20, hr_api.g_varchar2)))
772: or
773: (p_rec.valid_grade_id is null) then
774: --

Line 834: Procedure insert_validate(p_rec in per_vgr_shd.g_rec_type,

830: --
831: -- ----------------------------------------------------------------------------
832: -- |---------------------------< insert_validate >----------------------------|
833: -- ----------------------------------------------------------------------------
834: Procedure insert_validate(p_rec in per_vgr_shd.g_rec_type,
835: p_effective_date in date) is -- Added for Bug# 1760707
836: --
837: l_proc varchar2(72) := g_package||'insert_validate';
838: --

Line 925: Procedure update_validate(p_rec in per_vgr_shd.g_rec_type,

921: --
922: -- ----------------------------------------------------------------------------
923: -- |---------------------------< update_validate >----------------------------|
924: -- ----------------------------------------------------------------------------
925: Procedure update_validate(p_rec in per_vgr_shd.g_rec_type,
926: p_effective_date in date) is
927: --
928: l_proc varchar2(72) := g_package||'update_validate';
929: --

Line 981: Procedure delete_validate(p_rec in per_vgr_shd.g_rec_type) is

977: --
978: -- ----------------------------------------------------------------------------
979: -- |---------------------------< delete_validate >----------------------------|
980: -- ----------------------------------------------------------------------------
981: Procedure delete_validate(p_rec in per_vgr_shd.g_rec_type) is
982: --
983: l_proc varchar2(72) := g_package||'delete_validate';
984: --
985: Begin