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_PPS_BUS dependencies on PER_PPS_SHD

Line 200: l_api_updating := per_pps_shd.api_updating

196: --
197: Begin
198: hr_utility.set_location('Entering:'||l_proc, 5);
199: --
200: l_api_updating := per_pps_shd.api_updating
201: (p_parent_spine_id => p_parent_spine_id
202: ,p_object_version_number => p_object_version_number
203: );
204: --

Line 207: <> per_pps_shd.g_old_rec.parent_spine_id) then

203: );
204: --
205: if (l_api_updating
206: and nvl(p_parent_spine_id,hr_api.g_number)
207: <> per_pps_shd.g_old_rec.parent_spine_id) then
208: --
209: -- raise error as PK has changed
210: --
211: per_pps_shd.constraint_error('PER_PARENT_SPINES_PK');

Line 211: per_pps_shd.constraint_error('PER_PARENT_SPINES_PK');

207: <> per_pps_shd.g_old_rec.parent_spine_id) then
208: --
209: -- raise error as PK has changed
210: --
211: per_pps_shd.constraint_error('PER_PARENT_SPINES_PK');
212: --
213: elsif not l_api_updating then
214: --
215: -- check if PK is null

Line 221: per_pps_shd.constraint_error('PER_PARENT_SPINES_PK');

217: if p_parent_spine_id is not null then
218: --
219: -- raise error as PK is not null
220: --
221: per_pps_shd.constraint_error('PER_PARENT_SPINES_PK');
222: --
223: end if;
224: --
225: end if;

Line 300: l_api_updating := per_pps_shd.api_updating

296: -- Only proceed with validation if :
297: -- a) The current g_old_rec is current and
298: -- b) The name value has changed
299: --
300: l_api_updating := per_pps_shd.api_updating
301: (p_parent_spine_id => p_parent_spine_id
302: ,p_object_version_number => p_object_version_number);
303: --
304: if ((l_api_updating and upper(per_pps_shd.g_old_rec.name) <> upper(p_name))

Line 304: if ((l_api_updating and upper(per_pps_shd.g_old_rec.name) <> upper(p_name))

300: l_api_updating := per_pps_shd.api_updating
301: (p_parent_spine_id => p_parent_spine_id
302: ,p_object_version_number => p_object_version_number);
303: --
304: if ((l_api_updating and upper(per_pps_shd.g_old_rec.name) <> upper(p_name))
305: or (NOT l_api_updating)) then
306: hr_utility.set_location(l_proc, 20);
307: --
308: open csr_unique_name;

Line 376: l_api_updating := per_pps_shd.api_updating

372: Begin
373: --
374: hr_utility.set_location('Entering:'||l_proc, 10);
375: --
376: l_api_updating := per_pps_shd.api_updating
377: ( p_parent_spine_id => p_parent_spine_id
378: ,p_object_version_number => p_object_version_number
379: );
380: --

Line 383: <> per_pps_shd.g_old_rec.increment_frequency) then

379: );
380: --
381: if (l_api_updating
382: and nvl(p_increment_frequency,hr_api.g_number)
383: <> per_pps_shd.g_old_rec.increment_frequency) then
384: --
385: -- Check mandatory parameters have been set
386: --
387: hr_utility.set_location(l_proc,20);

Line 670: (p_rec in per_pps_shd.g_rec_type

666: -- Internal Row Handler Use Only.
667: --
668: -- ----------------------------------------------------------------------------
669: procedure chk_df
670: (p_rec in per_pps_shd.g_rec_type
671: ) is
672: --
673: l_proc varchar2(72) := g_package || 'chk_df';
674: --

Line 679: nvl(per_pps_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

675: begin
676: hr_utility.set_location('Entering:'||l_proc,10);
677: --
678: if ((p_rec.parent_spine_id is not null) and (
679: nvl(per_pps_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
680: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
681: nvl(per_pps_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
682: nvl(p_rec.attribute1, hr_api.g_varchar2) or
683: nvl(per_pps_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

Line 681: nvl(per_pps_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

677: --
678: if ((p_rec.parent_spine_id is not null) and (
679: nvl(per_pps_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
680: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
681: nvl(per_pps_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
682: nvl(p_rec.attribute1, hr_api.g_varchar2) or
683: nvl(per_pps_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
684: nvl(p_rec.attribute2, hr_api.g_varchar2) or
685: nvl(per_pps_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

Line 683: nvl(per_pps_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

679: nvl(per_pps_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
680: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
681: nvl(per_pps_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
682: nvl(p_rec.attribute1, hr_api.g_varchar2) or
683: nvl(per_pps_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
684: nvl(p_rec.attribute2, hr_api.g_varchar2) or
685: nvl(per_pps_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
686: nvl(p_rec.attribute3, hr_api.g_varchar2) or
687: nvl(per_pps_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

Line 685: nvl(per_pps_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

681: nvl(per_pps_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
682: nvl(p_rec.attribute1, hr_api.g_varchar2) or
683: nvl(per_pps_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
684: nvl(p_rec.attribute2, hr_api.g_varchar2) or
685: nvl(per_pps_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
686: nvl(p_rec.attribute3, hr_api.g_varchar2) or
687: nvl(per_pps_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
688: nvl(p_rec.attribute4, hr_api.g_varchar2) or
689: nvl(per_pps_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

Line 687: nvl(per_pps_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

683: nvl(per_pps_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
684: nvl(p_rec.attribute2, hr_api.g_varchar2) or
685: nvl(per_pps_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
686: nvl(p_rec.attribute3, hr_api.g_varchar2) or
687: nvl(per_pps_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
688: nvl(p_rec.attribute4, hr_api.g_varchar2) or
689: nvl(per_pps_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
690: nvl(p_rec.attribute5, hr_api.g_varchar2) or
691: nvl(per_pps_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

Line 689: nvl(per_pps_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

685: nvl(per_pps_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
686: nvl(p_rec.attribute3, hr_api.g_varchar2) or
687: nvl(per_pps_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
688: nvl(p_rec.attribute4, hr_api.g_varchar2) or
689: nvl(per_pps_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
690: nvl(p_rec.attribute5, hr_api.g_varchar2) or
691: nvl(per_pps_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
692: nvl(p_rec.attribute6, hr_api.g_varchar2) or
693: nvl(per_pps_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

Line 691: nvl(per_pps_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

687: nvl(per_pps_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
688: nvl(p_rec.attribute4, hr_api.g_varchar2) or
689: nvl(per_pps_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
690: nvl(p_rec.attribute5, hr_api.g_varchar2) or
691: nvl(per_pps_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
692: nvl(p_rec.attribute6, hr_api.g_varchar2) or
693: nvl(per_pps_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
694: nvl(p_rec.attribute7, hr_api.g_varchar2) or
695: nvl(per_pps_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

Line 693: nvl(per_pps_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

689: nvl(per_pps_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
690: nvl(p_rec.attribute5, hr_api.g_varchar2) or
691: nvl(per_pps_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
692: nvl(p_rec.attribute6, hr_api.g_varchar2) or
693: nvl(per_pps_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
694: nvl(p_rec.attribute7, hr_api.g_varchar2) or
695: nvl(per_pps_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
696: nvl(p_rec.attribute8, hr_api.g_varchar2) or
697: nvl(per_pps_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

Line 695: nvl(per_pps_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

691: nvl(per_pps_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
692: nvl(p_rec.attribute6, hr_api.g_varchar2) or
693: nvl(per_pps_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
694: nvl(p_rec.attribute7, hr_api.g_varchar2) or
695: nvl(per_pps_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
696: nvl(p_rec.attribute8, hr_api.g_varchar2) or
697: nvl(per_pps_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
698: nvl(p_rec.attribute9, hr_api.g_varchar2) or
699: nvl(per_pps_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

Line 697: nvl(per_pps_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

693: nvl(per_pps_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
694: nvl(p_rec.attribute7, hr_api.g_varchar2) or
695: nvl(per_pps_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
696: nvl(p_rec.attribute8, hr_api.g_varchar2) or
697: nvl(per_pps_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
698: nvl(p_rec.attribute9, hr_api.g_varchar2) or
699: nvl(per_pps_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
700: nvl(p_rec.attribute10, hr_api.g_varchar2) or
701: nvl(per_pps_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

Line 699: nvl(per_pps_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

695: nvl(per_pps_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
696: nvl(p_rec.attribute8, hr_api.g_varchar2) or
697: nvl(per_pps_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
698: nvl(p_rec.attribute9, hr_api.g_varchar2) or
699: nvl(per_pps_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
700: nvl(p_rec.attribute10, hr_api.g_varchar2) or
701: nvl(per_pps_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
702: nvl(p_rec.attribute11, hr_api.g_varchar2) or
703: nvl(per_pps_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

Line 701: nvl(per_pps_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

697: nvl(per_pps_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
698: nvl(p_rec.attribute9, hr_api.g_varchar2) or
699: nvl(per_pps_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
700: nvl(p_rec.attribute10, hr_api.g_varchar2) or
701: nvl(per_pps_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
702: nvl(p_rec.attribute11, hr_api.g_varchar2) or
703: nvl(per_pps_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
704: nvl(p_rec.attribute12, hr_api.g_varchar2) or
705: nvl(per_pps_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

Line 703: nvl(per_pps_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

699: nvl(per_pps_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
700: nvl(p_rec.attribute10, hr_api.g_varchar2) or
701: nvl(per_pps_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
702: nvl(p_rec.attribute11, hr_api.g_varchar2) or
703: nvl(per_pps_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
704: nvl(p_rec.attribute12, hr_api.g_varchar2) or
705: nvl(per_pps_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
706: nvl(p_rec.attribute13, hr_api.g_varchar2) or
707: nvl(per_pps_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

Line 705: nvl(per_pps_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

701: nvl(per_pps_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
702: nvl(p_rec.attribute11, hr_api.g_varchar2) or
703: nvl(per_pps_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
704: nvl(p_rec.attribute12, hr_api.g_varchar2) or
705: nvl(per_pps_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
706: nvl(p_rec.attribute13, hr_api.g_varchar2) or
707: nvl(per_pps_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
708: nvl(p_rec.attribute14, hr_api.g_varchar2) or
709: nvl(per_pps_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

Line 707: nvl(per_pps_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

703: nvl(per_pps_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
704: nvl(p_rec.attribute12, hr_api.g_varchar2) or
705: nvl(per_pps_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
706: nvl(p_rec.attribute13, hr_api.g_varchar2) or
707: nvl(per_pps_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
708: nvl(p_rec.attribute14, hr_api.g_varchar2) or
709: nvl(per_pps_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
710: nvl(p_rec.attribute15, hr_api.g_varchar2) or
711: nvl(per_pps_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

Line 709: nvl(per_pps_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

705: nvl(per_pps_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
706: nvl(p_rec.attribute13, hr_api.g_varchar2) or
707: nvl(per_pps_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
708: nvl(p_rec.attribute14, hr_api.g_varchar2) or
709: nvl(per_pps_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
710: nvl(p_rec.attribute15, hr_api.g_varchar2) or
711: nvl(per_pps_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
712: nvl(p_rec.attribute16, hr_api.g_varchar2) or
713: nvl(per_pps_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

Line 711: nvl(per_pps_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

707: nvl(per_pps_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
708: nvl(p_rec.attribute14, hr_api.g_varchar2) or
709: nvl(per_pps_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
710: nvl(p_rec.attribute15, hr_api.g_varchar2) or
711: nvl(per_pps_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
712: nvl(p_rec.attribute16, hr_api.g_varchar2) or
713: nvl(per_pps_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
714: nvl(p_rec.attribute17, hr_api.g_varchar2) or
715: nvl(per_pps_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

Line 713: nvl(per_pps_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

709: nvl(per_pps_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
710: nvl(p_rec.attribute15, hr_api.g_varchar2) or
711: nvl(per_pps_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
712: nvl(p_rec.attribute16, hr_api.g_varchar2) or
713: nvl(per_pps_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
714: nvl(p_rec.attribute17, hr_api.g_varchar2) or
715: nvl(per_pps_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
716: nvl(p_rec.attribute18, hr_api.g_varchar2) or
717: nvl(per_pps_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

Line 715: nvl(per_pps_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

711: nvl(per_pps_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
712: nvl(p_rec.attribute16, hr_api.g_varchar2) or
713: nvl(per_pps_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
714: nvl(p_rec.attribute17, hr_api.g_varchar2) or
715: nvl(per_pps_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
716: nvl(p_rec.attribute18, hr_api.g_varchar2) or
717: nvl(per_pps_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
718: nvl(p_rec.attribute19, hr_api.g_varchar2) or
719: nvl(per_pps_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

Line 717: nvl(per_pps_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

713: nvl(per_pps_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
714: nvl(p_rec.attribute17, hr_api.g_varchar2) or
715: nvl(per_pps_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
716: nvl(p_rec.attribute18, hr_api.g_varchar2) or
717: nvl(per_pps_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
718: nvl(p_rec.attribute19, hr_api.g_varchar2) or
719: nvl(per_pps_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
720: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
721: or (p_rec.parent_spine_id is null) then

Line 719: nvl(per_pps_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

715: nvl(per_pps_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
716: nvl(p_rec.attribute18, hr_api.g_varchar2) or
717: nvl(per_pps_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
718: nvl(p_rec.attribute19, hr_api.g_varchar2) or
719: nvl(per_pps_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
720: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
721: or (p_rec.parent_spine_id is null) then
722: --
723: -- Only execute the validation if absolutely necessary:

Line 808: (p_rec in per_pps_shd.g_rec_type

804: -- Internal Row Handler Use Only.
805: --
806: -- ----------------------------------------------------------------------------
807: procedure chk_ddf
808: (p_rec in per_pps_shd.g_rec_type
809: ) is
810: --
811: l_proc varchar2(72) := g_package || 'chk_ddf';
812: --

Line 817: nvl(per_pps_shd.g_old_rec.information_category, hr_api.g_varchar2) <>

813: begin
814: hr_utility.set_location('Entering:'||l_proc,10);
815: --
816: if ((p_rec.parent_spine_id is not null) and (
817: nvl(per_pps_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
818: nvl(p_rec.information_category, hr_api.g_varchar2) or
819: nvl(per_pps_shd.g_old_rec.information1, hr_api.g_varchar2) <>
820: nvl(p_rec.information1, hr_api.g_varchar2) or
821: nvl(per_pps_shd.g_old_rec.information2, hr_api.g_varchar2) <>

Line 819: nvl(per_pps_shd.g_old_rec.information1, hr_api.g_varchar2) <>

815: --
816: if ((p_rec.parent_spine_id is not null) and (
817: nvl(per_pps_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
818: nvl(p_rec.information_category, hr_api.g_varchar2) or
819: nvl(per_pps_shd.g_old_rec.information1, hr_api.g_varchar2) <>
820: nvl(p_rec.information1, hr_api.g_varchar2) or
821: nvl(per_pps_shd.g_old_rec.information2, hr_api.g_varchar2) <>
822: nvl(p_rec.information2, hr_api.g_varchar2) or
823: nvl(per_pps_shd.g_old_rec.information3, hr_api.g_varchar2) <>

Line 821: nvl(per_pps_shd.g_old_rec.information2, hr_api.g_varchar2) <>

817: nvl(per_pps_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
818: nvl(p_rec.information_category, hr_api.g_varchar2) or
819: nvl(per_pps_shd.g_old_rec.information1, hr_api.g_varchar2) <>
820: nvl(p_rec.information1, hr_api.g_varchar2) or
821: nvl(per_pps_shd.g_old_rec.information2, hr_api.g_varchar2) <>
822: nvl(p_rec.information2, hr_api.g_varchar2) or
823: nvl(per_pps_shd.g_old_rec.information3, hr_api.g_varchar2) <>
824: nvl(p_rec.information3, hr_api.g_varchar2) or
825: nvl(per_pps_shd.g_old_rec.information4, hr_api.g_varchar2) <>

Line 823: nvl(per_pps_shd.g_old_rec.information3, hr_api.g_varchar2) <>

819: nvl(per_pps_shd.g_old_rec.information1, hr_api.g_varchar2) <>
820: nvl(p_rec.information1, hr_api.g_varchar2) or
821: nvl(per_pps_shd.g_old_rec.information2, hr_api.g_varchar2) <>
822: nvl(p_rec.information2, hr_api.g_varchar2) or
823: nvl(per_pps_shd.g_old_rec.information3, hr_api.g_varchar2) <>
824: nvl(p_rec.information3, hr_api.g_varchar2) or
825: nvl(per_pps_shd.g_old_rec.information4, hr_api.g_varchar2) <>
826: nvl(p_rec.information4, hr_api.g_varchar2) or
827: nvl(per_pps_shd.g_old_rec.information5, hr_api.g_varchar2) <>

Line 825: nvl(per_pps_shd.g_old_rec.information4, hr_api.g_varchar2) <>

821: nvl(per_pps_shd.g_old_rec.information2, hr_api.g_varchar2) <>
822: nvl(p_rec.information2, hr_api.g_varchar2) or
823: nvl(per_pps_shd.g_old_rec.information3, hr_api.g_varchar2) <>
824: nvl(p_rec.information3, hr_api.g_varchar2) or
825: nvl(per_pps_shd.g_old_rec.information4, hr_api.g_varchar2) <>
826: nvl(p_rec.information4, hr_api.g_varchar2) or
827: nvl(per_pps_shd.g_old_rec.information5, hr_api.g_varchar2) <>
828: nvl(p_rec.information5, hr_api.g_varchar2) or
829: nvl(per_pps_shd.g_old_rec.information6, hr_api.g_varchar2) <>

Line 827: nvl(per_pps_shd.g_old_rec.information5, hr_api.g_varchar2) <>

823: nvl(per_pps_shd.g_old_rec.information3, hr_api.g_varchar2) <>
824: nvl(p_rec.information3, hr_api.g_varchar2) or
825: nvl(per_pps_shd.g_old_rec.information4, hr_api.g_varchar2) <>
826: nvl(p_rec.information4, hr_api.g_varchar2) or
827: nvl(per_pps_shd.g_old_rec.information5, hr_api.g_varchar2) <>
828: nvl(p_rec.information5, hr_api.g_varchar2) or
829: nvl(per_pps_shd.g_old_rec.information6, hr_api.g_varchar2) <>
830: nvl(p_rec.information6, hr_api.g_varchar2) or
831: nvl(per_pps_shd.g_old_rec.information7, hr_api.g_varchar2) <>

Line 829: nvl(per_pps_shd.g_old_rec.information6, hr_api.g_varchar2) <>

825: nvl(per_pps_shd.g_old_rec.information4, hr_api.g_varchar2) <>
826: nvl(p_rec.information4, hr_api.g_varchar2) or
827: nvl(per_pps_shd.g_old_rec.information5, hr_api.g_varchar2) <>
828: nvl(p_rec.information5, hr_api.g_varchar2) or
829: nvl(per_pps_shd.g_old_rec.information6, hr_api.g_varchar2) <>
830: nvl(p_rec.information6, hr_api.g_varchar2) or
831: nvl(per_pps_shd.g_old_rec.information7, hr_api.g_varchar2) <>
832: nvl(p_rec.information7, hr_api.g_varchar2) or
833: nvl(per_pps_shd.g_old_rec.information8, hr_api.g_varchar2) <>

Line 831: nvl(per_pps_shd.g_old_rec.information7, hr_api.g_varchar2) <>

827: nvl(per_pps_shd.g_old_rec.information5, hr_api.g_varchar2) <>
828: nvl(p_rec.information5, hr_api.g_varchar2) or
829: nvl(per_pps_shd.g_old_rec.information6, hr_api.g_varchar2) <>
830: nvl(p_rec.information6, hr_api.g_varchar2) or
831: nvl(per_pps_shd.g_old_rec.information7, hr_api.g_varchar2) <>
832: nvl(p_rec.information7, hr_api.g_varchar2) or
833: nvl(per_pps_shd.g_old_rec.information8, hr_api.g_varchar2) <>
834: nvl(p_rec.information8, hr_api.g_varchar2) or
835: nvl(per_pps_shd.g_old_rec.information9, hr_api.g_varchar2) <>

Line 833: nvl(per_pps_shd.g_old_rec.information8, hr_api.g_varchar2) <>

829: nvl(per_pps_shd.g_old_rec.information6, hr_api.g_varchar2) <>
830: nvl(p_rec.information6, hr_api.g_varchar2) or
831: nvl(per_pps_shd.g_old_rec.information7, hr_api.g_varchar2) <>
832: nvl(p_rec.information7, hr_api.g_varchar2) or
833: nvl(per_pps_shd.g_old_rec.information8, hr_api.g_varchar2) <>
834: nvl(p_rec.information8, hr_api.g_varchar2) or
835: nvl(per_pps_shd.g_old_rec.information9, hr_api.g_varchar2) <>
836: nvl(p_rec.information9, hr_api.g_varchar2) or
837: nvl(per_pps_shd.g_old_rec.information10, hr_api.g_varchar2) <>

Line 835: nvl(per_pps_shd.g_old_rec.information9, hr_api.g_varchar2) <>

831: nvl(per_pps_shd.g_old_rec.information7, hr_api.g_varchar2) <>
832: nvl(p_rec.information7, hr_api.g_varchar2) or
833: nvl(per_pps_shd.g_old_rec.information8, hr_api.g_varchar2) <>
834: nvl(p_rec.information8, hr_api.g_varchar2) or
835: nvl(per_pps_shd.g_old_rec.information9, hr_api.g_varchar2) <>
836: nvl(p_rec.information9, hr_api.g_varchar2) or
837: nvl(per_pps_shd.g_old_rec.information10, hr_api.g_varchar2) <>
838: nvl(p_rec.information10, hr_api.g_varchar2) or
839: nvl(per_pps_shd.g_old_rec.information11, hr_api.g_varchar2) <>

Line 837: nvl(per_pps_shd.g_old_rec.information10, hr_api.g_varchar2) <>

833: nvl(per_pps_shd.g_old_rec.information8, hr_api.g_varchar2) <>
834: nvl(p_rec.information8, hr_api.g_varchar2) or
835: nvl(per_pps_shd.g_old_rec.information9, hr_api.g_varchar2) <>
836: nvl(p_rec.information9, hr_api.g_varchar2) or
837: nvl(per_pps_shd.g_old_rec.information10, hr_api.g_varchar2) <>
838: nvl(p_rec.information10, hr_api.g_varchar2) or
839: nvl(per_pps_shd.g_old_rec.information11, hr_api.g_varchar2) <>
840: nvl(p_rec.information11, hr_api.g_varchar2) or
841: nvl(per_pps_shd.g_old_rec.information12, hr_api.g_varchar2) <>

Line 839: nvl(per_pps_shd.g_old_rec.information11, hr_api.g_varchar2) <>

835: nvl(per_pps_shd.g_old_rec.information9, hr_api.g_varchar2) <>
836: nvl(p_rec.information9, hr_api.g_varchar2) or
837: nvl(per_pps_shd.g_old_rec.information10, hr_api.g_varchar2) <>
838: nvl(p_rec.information10, hr_api.g_varchar2) or
839: nvl(per_pps_shd.g_old_rec.information11, hr_api.g_varchar2) <>
840: nvl(p_rec.information11, hr_api.g_varchar2) or
841: nvl(per_pps_shd.g_old_rec.information12, hr_api.g_varchar2) <>
842: nvl(p_rec.information12, hr_api.g_varchar2) or
843: nvl(per_pps_shd.g_old_rec.information13, hr_api.g_varchar2) <>

Line 841: nvl(per_pps_shd.g_old_rec.information12, hr_api.g_varchar2) <>

837: nvl(per_pps_shd.g_old_rec.information10, hr_api.g_varchar2) <>
838: nvl(p_rec.information10, hr_api.g_varchar2) or
839: nvl(per_pps_shd.g_old_rec.information11, hr_api.g_varchar2) <>
840: nvl(p_rec.information11, hr_api.g_varchar2) or
841: nvl(per_pps_shd.g_old_rec.information12, hr_api.g_varchar2) <>
842: nvl(p_rec.information12, hr_api.g_varchar2) or
843: nvl(per_pps_shd.g_old_rec.information13, hr_api.g_varchar2) <>
844: nvl(p_rec.information13, hr_api.g_varchar2) or
845: nvl(per_pps_shd.g_old_rec.information14, hr_api.g_varchar2) <>

Line 843: nvl(per_pps_shd.g_old_rec.information13, hr_api.g_varchar2) <>

839: nvl(per_pps_shd.g_old_rec.information11, hr_api.g_varchar2) <>
840: nvl(p_rec.information11, hr_api.g_varchar2) or
841: nvl(per_pps_shd.g_old_rec.information12, hr_api.g_varchar2) <>
842: nvl(p_rec.information12, hr_api.g_varchar2) or
843: nvl(per_pps_shd.g_old_rec.information13, hr_api.g_varchar2) <>
844: nvl(p_rec.information13, hr_api.g_varchar2) or
845: nvl(per_pps_shd.g_old_rec.information14, hr_api.g_varchar2) <>
846: nvl(p_rec.information14, hr_api.g_varchar2) or
847: nvl(per_pps_shd.g_old_rec.information15, hr_api.g_varchar2) <>

Line 845: nvl(per_pps_shd.g_old_rec.information14, hr_api.g_varchar2) <>

841: nvl(per_pps_shd.g_old_rec.information12, hr_api.g_varchar2) <>
842: nvl(p_rec.information12, hr_api.g_varchar2) or
843: nvl(per_pps_shd.g_old_rec.information13, hr_api.g_varchar2) <>
844: nvl(p_rec.information13, hr_api.g_varchar2) or
845: nvl(per_pps_shd.g_old_rec.information14, hr_api.g_varchar2) <>
846: nvl(p_rec.information14, hr_api.g_varchar2) or
847: nvl(per_pps_shd.g_old_rec.information15, hr_api.g_varchar2) <>
848: nvl(p_rec.information15, hr_api.g_varchar2) or
849: nvl(per_pps_shd.g_old_rec.information16, hr_api.g_varchar2) <>

Line 847: nvl(per_pps_shd.g_old_rec.information15, hr_api.g_varchar2) <>

843: nvl(per_pps_shd.g_old_rec.information13, hr_api.g_varchar2) <>
844: nvl(p_rec.information13, hr_api.g_varchar2) or
845: nvl(per_pps_shd.g_old_rec.information14, hr_api.g_varchar2) <>
846: nvl(p_rec.information14, hr_api.g_varchar2) or
847: nvl(per_pps_shd.g_old_rec.information15, hr_api.g_varchar2) <>
848: nvl(p_rec.information15, hr_api.g_varchar2) or
849: nvl(per_pps_shd.g_old_rec.information16, hr_api.g_varchar2) <>
850: nvl(p_rec.information16, hr_api.g_varchar2) or
851: nvl(per_pps_shd.g_old_rec.information17, hr_api.g_varchar2) <>

Line 849: nvl(per_pps_shd.g_old_rec.information16, hr_api.g_varchar2) <>

845: nvl(per_pps_shd.g_old_rec.information14, hr_api.g_varchar2) <>
846: nvl(p_rec.information14, hr_api.g_varchar2) or
847: nvl(per_pps_shd.g_old_rec.information15, hr_api.g_varchar2) <>
848: nvl(p_rec.information15, hr_api.g_varchar2) or
849: nvl(per_pps_shd.g_old_rec.information16, hr_api.g_varchar2) <>
850: nvl(p_rec.information16, hr_api.g_varchar2) or
851: nvl(per_pps_shd.g_old_rec.information17, hr_api.g_varchar2) <>
852: nvl(p_rec.information17, hr_api.g_varchar2) or
853: nvl(per_pps_shd.g_old_rec.information18, hr_api.g_varchar2) <>

Line 851: nvl(per_pps_shd.g_old_rec.information17, hr_api.g_varchar2) <>

847: nvl(per_pps_shd.g_old_rec.information15, hr_api.g_varchar2) <>
848: nvl(p_rec.information15, hr_api.g_varchar2) or
849: nvl(per_pps_shd.g_old_rec.information16, hr_api.g_varchar2) <>
850: nvl(p_rec.information16, hr_api.g_varchar2) or
851: nvl(per_pps_shd.g_old_rec.information17, hr_api.g_varchar2) <>
852: nvl(p_rec.information17, hr_api.g_varchar2) or
853: nvl(per_pps_shd.g_old_rec.information18, hr_api.g_varchar2) <>
854: nvl(p_rec.information18, hr_api.g_varchar2) or
855: nvl(per_pps_shd.g_old_rec.information19, hr_api.g_varchar2) <>

Line 853: nvl(per_pps_shd.g_old_rec.information18, hr_api.g_varchar2) <>

849: nvl(per_pps_shd.g_old_rec.information16, hr_api.g_varchar2) <>
850: nvl(p_rec.information16, hr_api.g_varchar2) or
851: nvl(per_pps_shd.g_old_rec.information17, hr_api.g_varchar2) <>
852: nvl(p_rec.information17, hr_api.g_varchar2) or
853: nvl(per_pps_shd.g_old_rec.information18, hr_api.g_varchar2) <>
854: nvl(p_rec.information18, hr_api.g_varchar2) or
855: nvl(per_pps_shd.g_old_rec.information19, hr_api.g_varchar2) <>
856: nvl(p_rec.information19, hr_api.g_varchar2) or
857: nvl(per_pps_shd.g_old_rec.information20, hr_api.g_varchar2) <>

Line 855: nvl(per_pps_shd.g_old_rec.information19, hr_api.g_varchar2) <>

851: nvl(per_pps_shd.g_old_rec.information17, hr_api.g_varchar2) <>
852: nvl(p_rec.information17, hr_api.g_varchar2) or
853: nvl(per_pps_shd.g_old_rec.information18, hr_api.g_varchar2) <>
854: nvl(p_rec.information18, hr_api.g_varchar2) or
855: nvl(per_pps_shd.g_old_rec.information19, hr_api.g_varchar2) <>
856: nvl(p_rec.information19, hr_api.g_varchar2) or
857: nvl(per_pps_shd.g_old_rec.information20, hr_api.g_varchar2) <>
858: nvl(p_rec.information20, hr_api.g_varchar2) or
859: nvl(per_pps_shd.g_old_rec.information21, hr_api.g_varchar2) <>

Line 857: nvl(per_pps_shd.g_old_rec.information20, hr_api.g_varchar2) <>

853: nvl(per_pps_shd.g_old_rec.information18, hr_api.g_varchar2) <>
854: nvl(p_rec.information18, hr_api.g_varchar2) or
855: nvl(per_pps_shd.g_old_rec.information19, hr_api.g_varchar2) <>
856: nvl(p_rec.information19, hr_api.g_varchar2) or
857: nvl(per_pps_shd.g_old_rec.information20, hr_api.g_varchar2) <>
858: nvl(p_rec.information20, hr_api.g_varchar2) or
859: nvl(per_pps_shd.g_old_rec.information21, hr_api.g_varchar2) <>
860: nvl(p_rec.information21, hr_api.g_varchar2) or
861: nvl(per_pps_shd.g_old_rec.information22, hr_api.g_varchar2) <>

Line 859: nvl(per_pps_shd.g_old_rec.information21, hr_api.g_varchar2) <>

855: nvl(per_pps_shd.g_old_rec.information19, hr_api.g_varchar2) <>
856: nvl(p_rec.information19, hr_api.g_varchar2) or
857: nvl(per_pps_shd.g_old_rec.information20, hr_api.g_varchar2) <>
858: nvl(p_rec.information20, hr_api.g_varchar2) or
859: nvl(per_pps_shd.g_old_rec.information21, hr_api.g_varchar2) <>
860: nvl(p_rec.information21, hr_api.g_varchar2) or
861: nvl(per_pps_shd.g_old_rec.information22, hr_api.g_varchar2) <>
862: nvl(p_rec.information22, hr_api.g_varchar2) or
863: nvl(per_pps_shd.g_old_rec.information23, hr_api.g_varchar2) <>

Line 861: nvl(per_pps_shd.g_old_rec.information22, hr_api.g_varchar2) <>

857: nvl(per_pps_shd.g_old_rec.information20, hr_api.g_varchar2) <>
858: nvl(p_rec.information20, hr_api.g_varchar2) or
859: nvl(per_pps_shd.g_old_rec.information21, hr_api.g_varchar2) <>
860: nvl(p_rec.information21, hr_api.g_varchar2) or
861: nvl(per_pps_shd.g_old_rec.information22, hr_api.g_varchar2) <>
862: nvl(p_rec.information22, hr_api.g_varchar2) or
863: nvl(per_pps_shd.g_old_rec.information23, hr_api.g_varchar2) <>
864: nvl(p_rec.information23, hr_api.g_varchar2) or
865: nvl(per_pps_shd.g_old_rec.information24, hr_api.g_varchar2) <>

Line 863: nvl(per_pps_shd.g_old_rec.information23, hr_api.g_varchar2) <>

859: nvl(per_pps_shd.g_old_rec.information21, hr_api.g_varchar2) <>
860: nvl(p_rec.information21, hr_api.g_varchar2) or
861: nvl(per_pps_shd.g_old_rec.information22, hr_api.g_varchar2) <>
862: nvl(p_rec.information22, hr_api.g_varchar2) or
863: nvl(per_pps_shd.g_old_rec.information23, hr_api.g_varchar2) <>
864: nvl(p_rec.information23, hr_api.g_varchar2) or
865: nvl(per_pps_shd.g_old_rec.information24, hr_api.g_varchar2) <>
866: nvl(p_rec.information24, hr_api.g_varchar2) or
867: nvl(per_pps_shd.g_old_rec.information25, hr_api.g_varchar2) <>

Line 865: nvl(per_pps_shd.g_old_rec.information24, hr_api.g_varchar2) <>

861: nvl(per_pps_shd.g_old_rec.information22, hr_api.g_varchar2) <>
862: nvl(p_rec.information22, hr_api.g_varchar2) or
863: nvl(per_pps_shd.g_old_rec.information23, hr_api.g_varchar2) <>
864: nvl(p_rec.information23, hr_api.g_varchar2) or
865: nvl(per_pps_shd.g_old_rec.information24, hr_api.g_varchar2) <>
866: nvl(p_rec.information24, hr_api.g_varchar2) or
867: nvl(per_pps_shd.g_old_rec.information25, hr_api.g_varchar2) <>
868: nvl(p_rec.information25, hr_api.g_varchar2) or
869: nvl(per_pps_shd.g_old_rec.information26, hr_api.g_varchar2) <>

Line 867: nvl(per_pps_shd.g_old_rec.information25, hr_api.g_varchar2) <>

863: nvl(per_pps_shd.g_old_rec.information23, hr_api.g_varchar2) <>
864: nvl(p_rec.information23, hr_api.g_varchar2) or
865: nvl(per_pps_shd.g_old_rec.information24, hr_api.g_varchar2) <>
866: nvl(p_rec.information24, hr_api.g_varchar2) or
867: nvl(per_pps_shd.g_old_rec.information25, hr_api.g_varchar2) <>
868: nvl(p_rec.information25, hr_api.g_varchar2) or
869: nvl(per_pps_shd.g_old_rec.information26, hr_api.g_varchar2) <>
870: nvl(p_rec.information26, hr_api.g_varchar2) or
871: nvl(per_pps_shd.g_old_rec.information27, hr_api.g_varchar2) <>

Line 869: nvl(per_pps_shd.g_old_rec.information26, hr_api.g_varchar2) <>

865: nvl(per_pps_shd.g_old_rec.information24, hr_api.g_varchar2) <>
866: nvl(p_rec.information24, hr_api.g_varchar2) or
867: nvl(per_pps_shd.g_old_rec.information25, hr_api.g_varchar2) <>
868: nvl(p_rec.information25, hr_api.g_varchar2) or
869: nvl(per_pps_shd.g_old_rec.information26, hr_api.g_varchar2) <>
870: nvl(p_rec.information26, hr_api.g_varchar2) or
871: nvl(per_pps_shd.g_old_rec.information27, hr_api.g_varchar2) <>
872: nvl(p_rec.information27, hr_api.g_varchar2) or
873: nvl(per_pps_shd.g_old_rec.information28, hr_api.g_varchar2) <>

Line 871: nvl(per_pps_shd.g_old_rec.information27, hr_api.g_varchar2) <>

867: nvl(per_pps_shd.g_old_rec.information25, hr_api.g_varchar2) <>
868: nvl(p_rec.information25, hr_api.g_varchar2) or
869: nvl(per_pps_shd.g_old_rec.information26, hr_api.g_varchar2) <>
870: nvl(p_rec.information26, hr_api.g_varchar2) or
871: nvl(per_pps_shd.g_old_rec.information27, hr_api.g_varchar2) <>
872: nvl(p_rec.information27, hr_api.g_varchar2) or
873: nvl(per_pps_shd.g_old_rec.information28, hr_api.g_varchar2) <>
874: nvl(p_rec.information28, hr_api.g_varchar2) or
875: nvl(per_pps_shd.g_old_rec.information29, hr_api.g_varchar2) <>

Line 873: nvl(per_pps_shd.g_old_rec.information28, hr_api.g_varchar2) <>

869: nvl(per_pps_shd.g_old_rec.information26, hr_api.g_varchar2) <>
870: nvl(p_rec.information26, hr_api.g_varchar2) or
871: nvl(per_pps_shd.g_old_rec.information27, hr_api.g_varchar2) <>
872: nvl(p_rec.information27, hr_api.g_varchar2) or
873: nvl(per_pps_shd.g_old_rec.information28, hr_api.g_varchar2) <>
874: nvl(p_rec.information28, hr_api.g_varchar2) or
875: nvl(per_pps_shd.g_old_rec.information29, hr_api.g_varchar2) <>
876: nvl(p_rec.information29, hr_api.g_varchar2) or
877: nvl(per_pps_shd.g_old_rec.information30, hr_api.g_varchar2) <>

Line 875: nvl(per_pps_shd.g_old_rec.information29, hr_api.g_varchar2) <>

871: nvl(per_pps_shd.g_old_rec.information27, hr_api.g_varchar2) <>
872: nvl(p_rec.information27, hr_api.g_varchar2) or
873: nvl(per_pps_shd.g_old_rec.information28, hr_api.g_varchar2) <>
874: nvl(p_rec.information28, hr_api.g_varchar2) or
875: nvl(per_pps_shd.g_old_rec.information29, hr_api.g_varchar2) <>
876: nvl(p_rec.information29, hr_api.g_varchar2) or
877: nvl(per_pps_shd.g_old_rec.information30, hr_api.g_varchar2) <>
878: nvl(p_rec.information30, hr_api.g_varchar2) ))
879: or (p_rec.parent_spine_id is null) then

Line 877: nvl(per_pps_shd.g_old_rec.information30, hr_api.g_varchar2) <>

873: nvl(per_pps_shd.g_old_rec.information28, hr_api.g_varchar2) <>
874: nvl(p_rec.information28, hr_api.g_varchar2) or
875: nvl(per_pps_shd.g_old_rec.information29, hr_api.g_varchar2) <>
876: nvl(p_rec.information29, hr_api.g_varchar2) or
877: nvl(per_pps_shd.g_old_rec.information30, hr_api.g_varchar2) <>
878: nvl(p_rec.information30, hr_api.g_varchar2) ))
879: or (p_rec.parent_spine_id is null) then
880: --
881: -- Only execute the validation if absolutely necessary:

Line 987: ,p_rec in per_pps_shd.g_rec_type

983: -- {End Of Comments}
984: -- ----------------------------------------------------------------------------
985: Procedure chk_non_updateable_args
986: (p_effective_date in date
987: ,p_rec in per_pps_shd.g_rec_type
988: ) IS
989: --
990: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
991: --

Line 997: IF NOT per_pps_shd.api_updating

993: --
994: -- Only proceed with the validation if a row exists for the current
995: -- record in the HR Schema.
996: --
997: IF NOT per_pps_shd.api_updating
998: (p_parent_spine_id => p_rec.parent_spine_id
999: ,p_object_version_number => p_rec.object_version_number
1000: ) THEN
1001: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 1008: per_pps_shd.g_old_rec.business_group_id then

1004: fnd_message.raise_error;
1005: END IF;
1006: --
1007: IF nvl(p_rec.business_group_id, hr_api.g_number) <>
1008: per_pps_shd.g_old_rec.business_group_id then
1009: hr_api.argument_changed_error
1010: (p_api_name => l_proc
1011: ,p_argument => 'BUSINESS_GROUP_ID'
1012: ,p_base_table => per_pps_shd.g_tab_nam

Line 1012: ,p_base_table => per_pps_shd.g_tab_nam

1008: per_pps_shd.g_old_rec.business_group_id then
1009: hr_api.argument_changed_error
1010: (p_api_name => l_proc
1011: ,p_argument => 'BUSINESS_GROUP_ID'
1012: ,p_base_table => per_pps_shd.g_tab_nam
1013: );
1014: END IF;
1015: --
1016: End chk_non_updateable_args;

Line 1023: -- ,p_rec in out nocopy per_pps_shd.g_rec_type

1019: -- |---------------------------< insert_validate >----------------------------|
1020: -- ----------------------------------------------------------------------------
1021: Procedure insert_validate
1022: (p_effective_date in date
1023: -- ,p_rec in out nocopy per_pps_shd.g_rec_type
1024: ,p_rec in per_pps_shd.g_rec_type
1025: ) is
1026: --
1027: l_proc varchar2(72) := g_package||'insert_validate';

Line 1024: ,p_rec in per_pps_shd.g_rec_type

1020: -- ----------------------------------------------------------------------------
1021: Procedure insert_validate
1022: (p_effective_date in date
1023: -- ,p_rec in out nocopy per_pps_shd.g_rec_type
1024: ,p_rec in per_pps_shd.g_rec_type
1025: ) is
1026: --
1027: l_proc varchar2(72) := g_package||'insert_validate';
1028: --

Line 1037: ,p_associated_column1 => per_pps_shd.g_tab_nam

1033: -- Call all supporting business operations
1034: --
1035: hr_api.validate_bus_grp_id
1036: (p_business_group_id => p_rec.business_group_id
1037: ,p_associated_column1 => per_pps_shd.g_tab_nam
1038: || '.BUSINESS_GROUP_ID');
1039: --
1040: --
1041: -- Validate parent spine id

Line 1124: ,p_rec in per_pps_shd.g_rec_type

1120: -- |---------------------------< update_validate >----------------------------|
1121: -- ----------------------------------------------------------------------------
1122: Procedure update_validate
1123: (p_effective_date in date
1124: ,p_rec in per_pps_shd.g_rec_type
1125: ) is
1126: --
1127: l_proc varchar2(72) := g_package||'update_validate';
1128: --

Line 1136: ,p_associated_column1 => per_pps_shd.g_tab_nam

1132: -- Call all supporting business operations
1133: --
1134: hr_api.validate_bus_grp_id
1135: (p_business_group_id => p_rec.business_group_id
1136: ,p_associated_column1 => per_pps_shd.g_tab_nam
1137: || '.BUSINESS_GROUP_ID');
1138:
1139: --
1140: -- Validate parent spine id

Line 1221: (p_rec in per_pps_shd.g_rec_type

1217: -- ----------------------------------------------------------------------------
1218: -- |---------------------------< delete_validate >----------------------------|
1219: -- ----------------------------------------------------------------------------
1220: Procedure delete_validate
1221: (p_rec in per_pps_shd.g_rec_type
1222: ) is
1223: --
1224: l_proc varchar2(72) := g_package||'delete_validate';
1225: --