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_RTL_BUS dependencies on HR_API

Line 61: hr_api.argument_changed_error

57: hr_utility.set_location(l_proc, 8);
58: --
59: exception
60: when l_error then
61: hr_api.argument_changed_error
62: (p_api_name => l_proc
63: ,p_argument => l_argument);
64: when others then
65: raise;

Line 162: if nvl(l_business_group_id,hr_api.g_number) <> p_business_group_id then

158: fnd_message.set_name('PER','HR_52694_ENTER_GLOB_RAT_SCAL');
159: fnd_message.raise_error;
160: end if;
161: else
162: if nvl(l_business_group_id,hr_api.g_number) <> p_business_group_id then
163: hr_utility.set_message(801,'HR_51470_RTL_RSC_DIFF_BUS_GRP');
164: hr_utility.raise_error;
165: end if;
166: end if;

Line 189: if nvl(l_business_group_id,hr_api.g_number) <> p_business_group_id then

185: fnd_message.set_name('PER','HR_52694_ENTER_GLOB_RAT_SCAL');
186: fnd_message.raise_error;
187: end if;
188: else
189: if nvl(l_business_group_id,hr_api.g_number) <> p_business_group_id then
190: hr_utility.set_message(801,'HR_51473_RTL_CPN_DIFF_BUS_GRP');
191: hr_utility.raise_error;
192: end if;
193: end if;

Line 257: and ( (nvl(competence_id,hr_api.g_number)

253: where ( (p_rating_level_id is null)
254: or(p_rating_level_id <> rating_level_id)
255: )
256: and name = p_name
257: and ( (nvl(competence_id,hr_api.g_number)
258: = nvl(p_competence_id,hr_api.g_number) )
259: and(nvl(rating_scale_id,hr_api.g_number)
260: = nvl(p_rating_scale_id,hr_api.g_number))
261: );

Line 258: = nvl(p_competence_id,hr_api.g_number) )

254: or(p_rating_level_id <> rating_level_id)
255: )
256: and name = p_name
257: and ( (nvl(competence_id,hr_api.g_number)
258: = nvl(p_competence_id,hr_api.g_number) )
259: and(nvl(rating_scale_id,hr_api.g_number)
260: = nvl(p_rating_scale_id,hr_api.g_number))
261: );
262: --

Line 259: and(nvl(rating_scale_id,hr_api.g_number)

255: )
256: and name = p_name
257: and ( (nvl(competence_id,hr_api.g_number)
258: = nvl(p_competence_id,hr_api.g_number) )
259: and(nvl(rating_scale_id,hr_api.g_number)
260: = nvl(p_rating_scale_id,hr_api.g_number))
261: );
262: --
263: begin

Line 260: = nvl(p_rating_scale_id,hr_api.g_number))

256: and name = p_name
257: and ( (nvl(competence_id,hr_api.g_number)
258: = nvl(p_competence_id,hr_api.g_number) )
259: and(nvl(rating_scale_id,hr_api.g_number)
260: = nvl(p_rating_scale_id,hr_api.g_number))
261: );
262: --
263: begin
264: hr_utility.set_location('Entering:'|| l_proc, 1);

Line 275: <> nvl(p_name,hr_api.g_varchar2))

271: (p_rating_level_id => p_rating_level_id
272: ,p_object_version_number => p_object_version_number);
273: --
274: if ( (l_api_updating and (per_rtl_shd.g_old_rec.name
275: <> nvl(p_name,hr_api.g_varchar2))
276: ) or
277: (NOT l_api_updating)
278: ) then
279: --

Line 702: nvl(per_rtl_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

698: begin
699: hr_utility.set_location('Entering:'||l_proc, 10);
700: --
701: if (((p_rec.rating_level_id is not null) and (
702: nvl(per_rtl_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
703: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
704: nvl(per_rtl_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
705: nvl(p_rec.attribute1, hr_api.g_varchar2) or
706: nvl(per_rtl_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

Line 703: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

699: hr_utility.set_location('Entering:'||l_proc, 10);
700: --
701: if (((p_rec.rating_level_id is not null) and (
702: nvl(per_rtl_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
703: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
704: nvl(per_rtl_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
705: nvl(p_rec.attribute1, hr_api.g_varchar2) or
706: nvl(per_rtl_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
707: nvl(p_rec.attribute2, hr_api.g_varchar2) or

Line 704: nvl(per_rtl_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

700: --
701: if (((p_rec.rating_level_id is not null) and (
702: nvl(per_rtl_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
703: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
704: nvl(per_rtl_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
705: nvl(p_rec.attribute1, hr_api.g_varchar2) or
706: nvl(per_rtl_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
707: nvl(p_rec.attribute2, hr_api.g_varchar2) or
708: nvl(per_rtl_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

Line 705: nvl(p_rec.attribute1, hr_api.g_varchar2) or

701: if (((p_rec.rating_level_id is not null) and (
702: nvl(per_rtl_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
703: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
704: nvl(per_rtl_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
705: nvl(p_rec.attribute1, hr_api.g_varchar2) or
706: nvl(per_rtl_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
707: nvl(p_rec.attribute2, hr_api.g_varchar2) or
708: nvl(per_rtl_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
709: nvl(p_rec.attribute3, hr_api.g_varchar2) or

Line 706: nvl(per_rtl_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

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

Line 707: nvl(p_rec.attribute2, hr_api.g_varchar2) or

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

Line 708: nvl(per_rtl_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

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

Line 709: nvl(p_rec.attribute3, hr_api.g_varchar2) or

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

Line 710: nvl(per_rtl_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

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

Line 711: nvl(p_rec.attribute4, hr_api.g_varchar2) or

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

Line 712: nvl(per_rtl_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

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

Line 713: nvl(p_rec.attribute5, hr_api.g_varchar2) or

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

Line 714: nvl(per_rtl_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

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

Line 715: nvl(p_rec.attribute6, hr_api.g_varchar2) or

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

Line 716: nvl(per_rtl_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

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

Line 717: nvl(p_rec.attribute7, hr_api.g_varchar2) or

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

Line 718: nvl(per_rtl_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

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

Line 719: nvl(p_rec.attribute8, hr_api.g_varchar2) or

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

Line 720: nvl(per_rtl_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

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

Line 721: nvl(p_rec.attribute9, hr_api.g_varchar2) or

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

Line 722: nvl(per_rtl_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

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

Line 723: nvl(p_rec.attribute10, hr_api.g_varchar2) or

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

Line 724: nvl(per_rtl_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

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

Line 725: nvl(p_rec.attribute11, hr_api.g_varchar2) or

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

Line 726: nvl(per_rtl_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

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

Line 727: nvl(p_rec.attribute12, hr_api.g_varchar2) or

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

Line 728: nvl(per_rtl_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

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

Line 729: nvl(p_rec.attribute13, hr_api.g_varchar2) or

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

Line 730: nvl(per_rtl_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

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

Line 731: nvl(p_rec.attribute14, hr_api.g_varchar2) or

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

Line 732: nvl(per_rtl_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

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

Line 733: nvl(p_rec.attribute15, hr_api.g_varchar2) or

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

Line 734: nvl(per_rtl_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

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

Line 735: nvl(p_rec.attribute16, hr_api.g_varchar2) or

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

Line 736: nvl(per_rtl_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

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

Line 737: nvl(p_rec.attribute17, hr_api.g_varchar2) or

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

Line 738: nvl(per_rtl_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

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

Line 739: nvl(p_rec.attribute18, hr_api.g_varchar2) or

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

Line 740: nvl(per_rtl_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

736: nvl(per_rtl_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
737: nvl(p_rec.attribute17, hr_api.g_varchar2) or
738: nvl(per_rtl_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
739: nvl(p_rec.attribute18, hr_api.g_varchar2) or
740: nvl(per_rtl_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
741: nvl(p_rec.attribute19, hr_api.g_varchar2) or
742: nvl(per_rtl_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
743: nvl(p_rec.attribute20, hr_api.g_varchar2)))
744: or

Line 741: nvl(p_rec.attribute19, hr_api.g_varchar2) or

737: nvl(p_rec.attribute17, hr_api.g_varchar2) or
738: nvl(per_rtl_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
739: nvl(p_rec.attribute18, hr_api.g_varchar2) or
740: nvl(per_rtl_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
741: nvl(p_rec.attribute19, hr_api.g_varchar2) or
742: nvl(per_rtl_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
743: nvl(p_rec.attribute20, hr_api.g_varchar2)))
744: or
745: (p_rec.rating_level_id is null))

Line 742: nvl(per_rtl_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

738: nvl(per_rtl_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
739: nvl(p_rec.attribute18, hr_api.g_varchar2) or
740: nvl(per_rtl_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
741: nvl(p_rec.attribute19, hr_api.g_varchar2) or
742: nvl(per_rtl_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
743: nvl(p_rec.attribute20, hr_api.g_varchar2)))
744: or
745: (p_rec.rating_level_id is null))
746: and hr_rating_levels_api.g_ignore_df <> 'Y' then -- BUG3621261

Line 743: nvl(p_rec.attribute20, hr_api.g_varchar2)))

739: nvl(p_rec.attribute18, hr_api.g_varchar2) or
740: nvl(per_rtl_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
741: nvl(p_rec.attribute19, hr_api.g_varchar2) or
742: nvl(per_rtl_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
743: nvl(p_rec.attribute20, hr_api.g_varchar2)))
744: or
745: (p_rec.rating_level_id is null))
746: and hr_rating_levels_api.g_ignore_df <> 'Y' then -- BUG3621261
747: --

Line 818: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

814: --
815: -- ngundura changes done as per pa requirements.
816: hr_utility.set_location('p_rec.business_group_id :'|| to_char(p_rec.business_group_id),99);
817: if p_rec.business_group_id is not null then
818: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
819: end if;
820: -- end of changes
821: --
822: --

Line 907: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

903: --
904: -- Call all supporting business operations
905: --
906: if p_rec.business_group_id is not null then
907: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
908: end if;
909: --
910: -- Rule Check Business group id and step value cannot be updated
911: --

Line 1004: hr_api.mandatory_arg_error (p_api_name => l_proc,

1000: -- ngundura end of changes.
1001: --
1002: -- Ensure that all the mandatory parameters are not null
1003: --
1004: hr_api.mandatory_arg_error (p_api_name => l_proc,
1005: p_argument => 'rating_level_id',
1006: p_argument_value => p_rating_level_id );
1007: open csr_leg_code;
1008: fetch csr_leg_code into l_legislation_code;