APPS.PER_RSC_BUS dependencies on HR_API

Line 62: hr_api.argument_changed_error

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

Line 152: /* hr_api.mandatory_arg_error

148: hr_utility.raise_error;
149: end if;
150: --
151: -- ngundura changes as per the pa requirements.
152: /* hr_api.mandatory_arg_error
153: (p_api_name => l_proc
154: ,p_argument => 'business_group_id'
155: ,p_argument_value => p_business_group_id
156: );

Line 172: nvl(per_rsc_shd.g_old_rec.name, hr_api.g_varchar2)

168: --
169: hr_utility.set_location (l_proc, 3);
170: --
171: if (l_api_updating AND
172: nvl(per_rsc_shd.g_old_rec.name, hr_api.g_varchar2)
173: <> nvl(p_name, hr_api.g_varchar2)
174: or not l_api_updating)
175: then
176: --

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

169: hr_utility.set_location (l_proc, 3);
170: --
171: if (l_api_updating AND
172: nvl(per_rsc_shd.g_old_rec.name, hr_api.g_varchar2)
173: <> nvl(p_name, hr_api.g_varchar2)
174: or not l_api_updating)
175: then
176: --
177: hr_utility.set_location (l_proc, 4);

Line 245: hr_api.mandatory_arg_error

241: hr_utility.set_location('Entering: '||l_proc, 1);
242: --
243: -- Check mandatory parameters have been set.
244: --
245: hr_api.mandatory_arg_error
246: (p_api_name => l_proc
247: ,p_argument => 'effective_date'
248: ,p_argument_value => p_effective_date
249: );

Line 262: hr_api.g_varchar2)

258: ,p_object_version_number => p_object_version_number
259: );
260: --
261: if ((l_api_updating and nvl(per_rsc_shd.g_old_rec.type,
262: hr_api.g_varchar2)
263: <> nvl(p_type, hr_api.g_varchar2)) or
264: (NOT l_api_updating)) then
265: --
266: hr_utility.set_location(l_proc, 2);

Line 263: <> nvl(p_type, hr_api.g_varchar2)) or

259: );
260: --
261: if ((l_api_updating and nvl(per_rsc_shd.g_old_rec.type,
262: hr_api.g_varchar2)
263: <> nvl(p_type, hr_api.g_varchar2)) or
264: (NOT l_api_updating)) then
265: --
266: hr_utility.set_location(l_proc, 2);
267: --

Line 273: if hr_api.not_exists_in_hr_lookups

269: -- Check if the type value exists in hr_lookups
270: -- where lookup_type is 'RATING_SCALE_TYPE'
271: --
272: if p_type is not null then
273: if hr_api.not_exists_in_hr_lookups
274: (p_effective_date => p_effective_date
275: ,p_lookup_type => 'RATING_SCALE_TYPE'
276: ,p_lookup_code => p_type
277: ) then

Line 363: hr_api.mandatory_arg_error

359: hr_utility.set_location('Entering: '||l_proc, 1);
360: --
361: -- Check mandatory parameters have been set.
362: --
363: hr_api.mandatory_arg_error
364: (p_api_name => l_proc
365: ,p_argument => 'effective_date'
366: ,p_argument_value => p_effective_date
367: );

Line 380: hr_api.g_varchar2)

376: ,p_object_version_number => p_object_version_number
377: );
378: --
379: if ((l_api_updating and nvl(per_rsc_shd.g_old_rec.default_flag,
380: hr_api.g_varchar2)
381: <> nvl(p_default_flag, hr_api.g_varchar2))
382: or
383: (NOT l_api_updating)) then
384: --

Line 381: <> nvl(p_default_flag, hr_api.g_varchar2))

377: );
378: --
379: if ((l_api_updating and nvl(per_rsc_shd.g_old_rec.default_flag,
380: hr_api.g_varchar2)
381: <> nvl(p_default_flag, hr_api.g_varchar2))
382: or
383: (NOT l_api_updating)) then
384: --
385: hr_utility.set_location(l_proc, 2);

Line 393: if hr_api.not_exists_in_hr_lookups

389: -- Check if the default_flag value exists in hr_lookups
390: -- where lookup_type is 'YES_NO'
391: --
392: if p_default_flag is not null then
393: if hr_api.not_exists_in_hr_lookups
394: (p_effective_date => p_effective_date
395: ,p_lookup_type => 'YES_NO'
396: ,p_lookup_code => p_default_flag
397: )

Line 601: nvl(per_rsc_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

597: begin
598: hr_utility.set_location('Entering:'||l_proc, 10);
599: --
600: if (((p_rec.rating_scale_id is not null) and (
601: nvl(per_rsc_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
602: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
603: nvl(per_rsc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
604: nvl(p_rec.attribute1, hr_api.g_varchar2) or
605: nvl(per_rsc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

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

598: hr_utility.set_location('Entering:'||l_proc, 10);
599: --
600: if (((p_rec.rating_scale_id is not null) and (
601: nvl(per_rsc_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
602: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
603: nvl(per_rsc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
604: nvl(p_rec.attribute1, hr_api.g_varchar2) or
605: nvl(per_rsc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
606: nvl(p_rec.attribute2, hr_api.g_varchar2) or

Line 603: nvl(per_rsc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

599: --
600: if (((p_rec.rating_scale_id is not null) and (
601: nvl(per_rsc_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
602: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
603: nvl(per_rsc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
604: nvl(p_rec.attribute1, hr_api.g_varchar2) or
605: nvl(per_rsc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
606: nvl(p_rec.attribute2, hr_api.g_varchar2) or
607: nvl(per_rsc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

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

600: if (((p_rec.rating_scale_id is not null) and (
601: nvl(per_rsc_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
602: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
603: nvl(per_rsc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
604: nvl(p_rec.attribute1, hr_api.g_varchar2) or
605: nvl(per_rsc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
606: nvl(p_rec.attribute2, hr_api.g_varchar2) or
607: nvl(per_rsc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
608: nvl(p_rec.attribute3, hr_api.g_varchar2) or

Line 605: nvl(per_rsc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

601: nvl(per_rsc_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
602: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
603: nvl(per_rsc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
604: nvl(p_rec.attribute1, hr_api.g_varchar2) or
605: nvl(per_rsc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
606: nvl(p_rec.attribute2, hr_api.g_varchar2) or
607: nvl(per_rsc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
608: nvl(p_rec.attribute3, hr_api.g_varchar2) or
609: nvl(per_rsc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

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

602: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
603: nvl(per_rsc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
604: nvl(p_rec.attribute1, hr_api.g_varchar2) or
605: nvl(per_rsc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
606: nvl(p_rec.attribute2, hr_api.g_varchar2) or
607: nvl(per_rsc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
608: nvl(p_rec.attribute3, hr_api.g_varchar2) or
609: nvl(per_rsc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
610: nvl(p_rec.attribute4, hr_api.g_varchar2) or

Line 607: nvl(per_rsc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

603: nvl(per_rsc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
604: nvl(p_rec.attribute1, hr_api.g_varchar2) or
605: nvl(per_rsc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
606: nvl(p_rec.attribute2, hr_api.g_varchar2) or
607: nvl(per_rsc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
608: nvl(p_rec.attribute3, hr_api.g_varchar2) or
609: nvl(per_rsc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
610: nvl(p_rec.attribute4, hr_api.g_varchar2) or
611: nvl(per_rsc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

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

604: nvl(p_rec.attribute1, hr_api.g_varchar2) or
605: nvl(per_rsc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
606: nvl(p_rec.attribute2, hr_api.g_varchar2) or
607: nvl(per_rsc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
608: nvl(p_rec.attribute3, hr_api.g_varchar2) or
609: nvl(per_rsc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
610: nvl(p_rec.attribute4, hr_api.g_varchar2) or
611: nvl(per_rsc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
612: nvl(p_rec.attribute5, hr_api.g_varchar2) or

Line 609: nvl(per_rsc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

605: nvl(per_rsc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
606: nvl(p_rec.attribute2, hr_api.g_varchar2) or
607: nvl(per_rsc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
608: nvl(p_rec.attribute3, hr_api.g_varchar2) or
609: nvl(per_rsc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
610: nvl(p_rec.attribute4, hr_api.g_varchar2) or
611: nvl(per_rsc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
612: nvl(p_rec.attribute5, hr_api.g_varchar2) or
613: nvl(per_rsc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

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

606: nvl(p_rec.attribute2, hr_api.g_varchar2) or
607: nvl(per_rsc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
608: nvl(p_rec.attribute3, hr_api.g_varchar2) or
609: nvl(per_rsc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
610: nvl(p_rec.attribute4, hr_api.g_varchar2) or
611: nvl(per_rsc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
612: nvl(p_rec.attribute5, hr_api.g_varchar2) or
613: nvl(per_rsc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
614: nvl(p_rec.attribute6, hr_api.g_varchar2) or

Line 611: nvl(per_rsc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

607: nvl(per_rsc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
608: nvl(p_rec.attribute3, hr_api.g_varchar2) or
609: nvl(per_rsc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
610: nvl(p_rec.attribute4, hr_api.g_varchar2) or
611: nvl(per_rsc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
612: nvl(p_rec.attribute5, hr_api.g_varchar2) or
613: nvl(per_rsc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
614: nvl(p_rec.attribute6, hr_api.g_varchar2) or
615: nvl(per_rsc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

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

608: nvl(p_rec.attribute3, hr_api.g_varchar2) or
609: nvl(per_rsc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
610: nvl(p_rec.attribute4, hr_api.g_varchar2) or
611: nvl(per_rsc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
612: nvl(p_rec.attribute5, hr_api.g_varchar2) or
613: nvl(per_rsc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
614: nvl(p_rec.attribute6, hr_api.g_varchar2) or
615: nvl(per_rsc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
616: nvl(p_rec.attribute7, hr_api.g_varchar2) or

Line 613: nvl(per_rsc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

609: nvl(per_rsc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
610: nvl(p_rec.attribute4, hr_api.g_varchar2) or
611: nvl(per_rsc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
612: nvl(p_rec.attribute5, hr_api.g_varchar2) or
613: nvl(per_rsc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
614: nvl(p_rec.attribute6, hr_api.g_varchar2) or
615: nvl(per_rsc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
616: nvl(p_rec.attribute7, hr_api.g_varchar2) or
617: nvl(per_rsc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

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

610: nvl(p_rec.attribute4, hr_api.g_varchar2) or
611: nvl(per_rsc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
612: nvl(p_rec.attribute5, hr_api.g_varchar2) or
613: nvl(per_rsc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
614: nvl(p_rec.attribute6, hr_api.g_varchar2) or
615: nvl(per_rsc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
616: nvl(p_rec.attribute7, hr_api.g_varchar2) or
617: nvl(per_rsc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
618: nvl(p_rec.attribute8, hr_api.g_varchar2) or

Line 615: nvl(per_rsc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

611: nvl(per_rsc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
612: nvl(p_rec.attribute5, hr_api.g_varchar2) or
613: nvl(per_rsc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
614: nvl(p_rec.attribute6, hr_api.g_varchar2) or
615: nvl(per_rsc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
616: nvl(p_rec.attribute7, hr_api.g_varchar2) or
617: nvl(per_rsc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
618: nvl(p_rec.attribute8, hr_api.g_varchar2) or
619: nvl(per_rsc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

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

612: nvl(p_rec.attribute5, hr_api.g_varchar2) or
613: nvl(per_rsc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
614: nvl(p_rec.attribute6, hr_api.g_varchar2) or
615: nvl(per_rsc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
616: nvl(p_rec.attribute7, hr_api.g_varchar2) or
617: nvl(per_rsc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
618: nvl(p_rec.attribute8, hr_api.g_varchar2) or
619: nvl(per_rsc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
620: nvl(p_rec.attribute9, hr_api.g_varchar2) or

Line 617: nvl(per_rsc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

613: nvl(per_rsc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
614: nvl(p_rec.attribute6, hr_api.g_varchar2) or
615: nvl(per_rsc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
616: nvl(p_rec.attribute7, hr_api.g_varchar2) or
617: nvl(per_rsc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
618: nvl(p_rec.attribute8, hr_api.g_varchar2) or
619: nvl(per_rsc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
620: nvl(p_rec.attribute9, hr_api.g_varchar2) or
621: nvl(per_rsc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

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

614: nvl(p_rec.attribute6, hr_api.g_varchar2) or
615: nvl(per_rsc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
616: nvl(p_rec.attribute7, hr_api.g_varchar2) or
617: nvl(per_rsc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
618: nvl(p_rec.attribute8, hr_api.g_varchar2) or
619: nvl(per_rsc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
620: nvl(p_rec.attribute9, hr_api.g_varchar2) or
621: nvl(per_rsc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
622: nvl(p_rec.attribute10, hr_api.g_varchar2) or

Line 619: nvl(per_rsc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

615: nvl(per_rsc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
616: nvl(p_rec.attribute7, hr_api.g_varchar2) or
617: nvl(per_rsc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
618: nvl(p_rec.attribute8, hr_api.g_varchar2) or
619: nvl(per_rsc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
620: nvl(p_rec.attribute9, hr_api.g_varchar2) or
621: nvl(per_rsc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
622: nvl(p_rec.attribute10, hr_api.g_varchar2) or
623: nvl(per_rsc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

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

616: nvl(p_rec.attribute7, hr_api.g_varchar2) or
617: nvl(per_rsc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
618: nvl(p_rec.attribute8, hr_api.g_varchar2) or
619: nvl(per_rsc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
620: nvl(p_rec.attribute9, hr_api.g_varchar2) or
621: nvl(per_rsc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
622: nvl(p_rec.attribute10, hr_api.g_varchar2) or
623: nvl(per_rsc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
624: nvl(p_rec.attribute11, hr_api.g_varchar2) or

Line 621: nvl(per_rsc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

617: nvl(per_rsc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
618: nvl(p_rec.attribute8, hr_api.g_varchar2) or
619: nvl(per_rsc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
620: nvl(p_rec.attribute9, hr_api.g_varchar2) or
621: nvl(per_rsc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
622: nvl(p_rec.attribute10, hr_api.g_varchar2) or
623: nvl(per_rsc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
624: nvl(p_rec.attribute11, hr_api.g_varchar2) or
625: nvl(per_rsc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

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

618: nvl(p_rec.attribute8, hr_api.g_varchar2) or
619: nvl(per_rsc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
620: nvl(p_rec.attribute9, hr_api.g_varchar2) or
621: nvl(per_rsc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
622: nvl(p_rec.attribute10, hr_api.g_varchar2) or
623: nvl(per_rsc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
624: nvl(p_rec.attribute11, hr_api.g_varchar2) or
625: nvl(per_rsc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
626: nvl(p_rec.attribute12, hr_api.g_varchar2) or

Line 623: nvl(per_rsc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

619: nvl(per_rsc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
620: nvl(p_rec.attribute9, hr_api.g_varchar2) or
621: nvl(per_rsc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
622: nvl(p_rec.attribute10, hr_api.g_varchar2) or
623: nvl(per_rsc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
624: nvl(p_rec.attribute11, hr_api.g_varchar2) or
625: nvl(per_rsc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
626: nvl(p_rec.attribute12, hr_api.g_varchar2) or
627: nvl(per_rsc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

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

620: nvl(p_rec.attribute9, hr_api.g_varchar2) or
621: nvl(per_rsc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
622: nvl(p_rec.attribute10, hr_api.g_varchar2) or
623: nvl(per_rsc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
624: nvl(p_rec.attribute11, hr_api.g_varchar2) or
625: nvl(per_rsc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
626: nvl(p_rec.attribute12, hr_api.g_varchar2) or
627: nvl(per_rsc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
628: nvl(p_rec.attribute13, hr_api.g_varchar2) or

Line 625: nvl(per_rsc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

621: nvl(per_rsc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
622: nvl(p_rec.attribute10, hr_api.g_varchar2) or
623: nvl(per_rsc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
624: nvl(p_rec.attribute11, hr_api.g_varchar2) or
625: nvl(per_rsc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
626: nvl(p_rec.attribute12, hr_api.g_varchar2) or
627: nvl(per_rsc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
628: nvl(p_rec.attribute13, hr_api.g_varchar2) or
629: nvl(per_rsc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

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

622: nvl(p_rec.attribute10, hr_api.g_varchar2) or
623: nvl(per_rsc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
624: nvl(p_rec.attribute11, hr_api.g_varchar2) or
625: nvl(per_rsc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
626: nvl(p_rec.attribute12, hr_api.g_varchar2) or
627: nvl(per_rsc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
628: nvl(p_rec.attribute13, hr_api.g_varchar2) or
629: nvl(per_rsc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
630: nvl(p_rec.attribute14, hr_api.g_varchar2) or

Line 627: nvl(per_rsc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

623: nvl(per_rsc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
624: nvl(p_rec.attribute11, hr_api.g_varchar2) or
625: nvl(per_rsc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
626: nvl(p_rec.attribute12, hr_api.g_varchar2) or
627: nvl(per_rsc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
628: nvl(p_rec.attribute13, hr_api.g_varchar2) or
629: nvl(per_rsc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
630: nvl(p_rec.attribute14, hr_api.g_varchar2) or
631: nvl(per_rsc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

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

624: nvl(p_rec.attribute11, hr_api.g_varchar2) or
625: nvl(per_rsc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
626: nvl(p_rec.attribute12, hr_api.g_varchar2) or
627: nvl(per_rsc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
628: nvl(p_rec.attribute13, hr_api.g_varchar2) or
629: nvl(per_rsc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
630: nvl(p_rec.attribute14, hr_api.g_varchar2) or
631: nvl(per_rsc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
632: nvl(p_rec.attribute15, hr_api.g_varchar2) or

Line 629: nvl(per_rsc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

625: nvl(per_rsc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
626: nvl(p_rec.attribute12, hr_api.g_varchar2) or
627: nvl(per_rsc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
628: nvl(p_rec.attribute13, hr_api.g_varchar2) or
629: nvl(per_rsc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
630: nvl(p_rec.attribute14, hr_api.g_varchar2) or
631: nvl(per_rsc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
632: nvl(p_rec.attribute15, hr_api.g_varchar2) or
633: nvl(per_rsc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

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

626: nvl(p_rec.attribute12, hr_api.g_varchar2) or
627: nvl(per_rsc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
628: nvl(p_rec.attribute13, hr_api.g_varchar2) or
629: nvl(per_rsc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
630: nvl(p_rec.attribute14, hr_api.g_varchar2) or
631: nvl(per_rsc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
632: nvl(p_rec.attribute15, hr_api.g_varchar2) or
633: nvl(per_rsc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
634: nvl(p_rec.attribute16, hr_api.g_varchar2) or

Line 631: nvl(per_rsc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

627: nvl(per_rsc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
628: nvl(p_rec.attribute13, hr_api.g_varchar2) or
629: nvl(per_rsc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
630: nvl(p_rec.attribute14, hr_api.g_varchar2) or
631: nvl(per_rsc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
632: nvl(p_rec.attribute15, hr_api.g_varchar2) or
633: nvl(per_rsc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
634: nvl(p_rec.attribute16, hr_api.g_varchar2) or
635: nvl(per_rsc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

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

628: nvl(p_rec.attribute13, hr_api.g_varchar2) or
629: nvl(per_rsc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
630: nvl(p_rec.attribute14, hr_api.g_varchar2) or
631: nvl(per_rsc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
632: nvl(p_rec.attribute15, hr_api.g_varchar2) or
633: nvl(per_rsc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
634: nvl(p_rec.attribute16, hr_api.g_varchar2) or
635: nvl(per_rsc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
636: nvl(p_rec.attribute17, hr_api.g_varchar2) or

Line 633: nvl(per_rsc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

629: nvl(per_rsc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
630: nvl(p_rec.attribute14, hr_api.g_varchar2) or
631: nvl(per_rsc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
632: nvl(p_rec.attribute15, hr_api.g_varchar2) or
633: nvl(per_rsc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
634: nvl(p_rec.attribute16, hr_api.g_varchar2) or
635: nvl(per_rsc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
636: nvl(p_rec.attribute17, hr_api.g_varchar2) or
637: nvl(per_rsc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

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

630: nvl(p_rec.attribute14, hr_api.g_varchar2) or
631: nvl(per_rsc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
632: nvl(p_rec.attribute15, hr_api.g_varchar2) or
633: nvl(per_rsc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
634: nvl(p_rec.attribute16, hr_api.g_varchar2) or
635: nvl(per_rsc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
636: nvl(p_rec.attribute17, hr_api.g_varchar2) or
637: nvl(per_rsc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
638: nvl(p_rec.attribute18, hr_api.g_varchar2) or

Line 635: nvl(per_rsc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

631: nvl(per_rsc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
632: nvl(p_rec.attribute15, hr_api.g_varchar2) or
633: nvl(per_rsc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
634: nvl(p_rec.attribute16, hr_api.g_varchar2) or
635: nvl(per_rsc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
636: nvl(p_rec.attribute17, hr_api.g_varchar2) or
637: nvl(per_rsc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
638: nvl(p_rec.attribute18, hr_api.g_varchar2) or
639: nvl(per_rsc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

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

632: nvl(p_rec.attribute15, hr_api.g_varchar2) or
633: nvl(per_rsc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
634: nvl(p_rec.attribute16, hr_api.g_varchar2) or
635: nvl(per_rsc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
636: nvl(p_rec.attribute17, hr_api.g_varchar2) or
637: nvl(per_rsc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
638: nvl(p_rec.attribute18, hr_api.g_varchar2) or
639: nvl(per_rsc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
640: nvl(p_rec.attribute19, hr_api.g_varchar2) or

Line 637: nvl(per_rsc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

633: nvl(per_rsc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
634: nvl(p_rec.attribute16, hr_api.g_varchar2) or
635: nvl(per_rsc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
636: nvl(p_rec.attribute17, hr_api.g_varchar2) or
637: nvl(per_rsc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
638: nvl(p_rec.attribute18, hr_api.g_varchar2) or
639: nvl(per_rsc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
640: nvl(p_rec.attribute19, hr_api.g_varchar2) or
641: nvl(per_rsc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

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

634: nvl(p_rec.attribute16, hr_api.g_varchar2) or
635: nvl(per_rsc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
636: nvl(p_rec.attribute17, hr_api.g_varchar2) or
637: nvl(per_rsc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
638: nvl(p_rec.attribute18, hr_api.g_varchar2) or
639: nvl(per_rsc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
640: nvl(p_rec.attribute19, hr_api.g_varchar2) or
641: nvl(per_rsc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
642: nvl(p_rec.attribute20, hr_api.g_varchar2)))

Line 639: nvl(per_rsc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

635: nvl(per_rsc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
636: nvl(p_rec.attribute17, hr_api.g_varchar2) or
637: nvl(per_rsc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
638: nvl(p_rec.attribute18, hr_api.g_varchar2) or
639: nvl(per_rsc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
640: nvl(p_rec.attribute19, hr_api.g_varchar2) or
641: nvl(per_rsc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
642: nvl(p_rec.attribute20, hr_api.g_varchar2)))
643: or

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

636: nvl(p_rec.attribute17, hr_api.g_varchar2) or
637: nvl(per_rsc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
638: nvl(p_rec.attribute18, hr_api.g_varchar2) or
639: nvl(per_rsc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
640: nvl(p_rec.attribute19, hr_api.g_varchar2) or
641: nvl(per_rsc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
642: nvl(p_rec.attribute20, hr_api.g_varchar2)))
643: or
644: (p_rec.rating_scale_id is null))

Line 641: nvl(per_rsc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

637: nvl(per_rsc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
638: nvl(p_rec.attribute18, hr_api.g_varchar2) or
639: nvl(per_rsc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
640: nvl(p_rec.attribute19, hr_api.g_varchar2) or
641: nvl(per_rsc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
642: nvl(p_rec.attribute20, hr_api.g_varchar2)))
643: or
644: (p_rec.rating_scale_id is null))
645: and hr_rating_scales_api.g_ignore_df <> 'Y' then -- BUG3621261

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

638: nvl(p_rec.attribute18, hr_api.g_varchar2) or
639: nvl(per_rsc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
640: nvl(p_rec.attribute19, hr_api.g_varchar2) or
641: nvl(per_rsc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
642: nvl(p_rec.attribute20, hr_api.g_varchar2)))
643: or
644: (p_rec.rating_scale_id is null))
645: and hr_rating_scales_api.g_ignore_df <> 'Y' then -- BUG3621261
646: --

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

720: -- =====================
721: -- Rule CHK_BUSINESS_GROUP_ID a
722: -- ngundura changes done for pa requirements
723: if p_rec.business_group_id is not null then
724: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
725: end if;
726: -- ngundura end of changes
727: --
728: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

805: -- =====================
806: -- CHK_BUSINESS_GROUP_ID b
807: -- ngundura changes as per pa changes
808: if p_rec.business_group_id is not null then
809: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
810: end if;
811: --
812: -- CHK_TYPE b
813: --

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

908: hr_utility.set_location('Entering:'||l_proc, 5);
909: --
910: -- Ensure that all the mandatory parameters are not null
911: --
912: hr_api.mandatory_arg_error (p_api_name => l_proc,
913: p_argument => 'rating_scale_id',
914: p_argument_value => p_rating_scale_id );
915: -- ngundura changes done for pa requirements...
916: select 'Y' into l_business_group_flag

Line 924: if nvl(g_rating_scale_id, hr_api.g_number) = p_rating_scale_id then

920: if l_business_group_flag = 'Y' then
921: return null;
922: end if;
923: -- ngundura end of changes
924: if nvl(g_rating_scale_id, hr_api.g_number) = p_rating_scale_id then
925: --
926: -- The legislation has already been found with a previous
927: -- call to this function. Just return the value in the global
928: -- variable.