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;
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;
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;
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: );
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: --
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
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);
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: --
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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)))
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
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))
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
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: --
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: --
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: --
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;