APPS.PER_PSP_BUS dependencies on PER_PSP_SHD

Line 201: l_api_updating := per_psp_shd.api_updating

197: --
198: Begin
199: hr_utility.set_location('Entering:'||l_proc, 10);
200: --
201: l_api_updating := per_psp_shd.api_updating
202: (p_spinal_point_id => p_spinal_point_id
203: ,p_object_version_number => p_object_version_number
204: );
205: --

Line 208: <> per_psp_shd.g_old_rec.spinal_point_id) then

204: );
205: --
206: if (l_api_updating
207: and nvl(p_spinal_point_id,hr_api.g_number)
208: <> per_psp_shd.g_old_rec.spinal_point_id) then
209: --
210: -- raise error as PK has changed
211: --
212: per_psp_shd.constraint_error('PER_SPINAL_POINTS_PK');

Line 212: per_psp_shd.constraint_error('PER_SPINAL_POINTS_PK');

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

Line 222: per_psp_shd.constraint_error('PER_SPINAL_POINTS_PK');

218: if p_spinal_point_id is not null then
219: --
220: -- raise error as PK is not null
221: --
222: per_psp_shd.constraint_error('PER_SPINAL_POINTS_PK');
223: --
224: end if;
225: --
226: end if;

Line 300: l_api_updating := per_psp_shd.api_updating

296: -- Only proceed with validation if :
297: -- a) The current g_old_rec is current and
298: -- b) The value for parent_spine_id has changed
299: --
300: l_api_updating := per_psp_shd.api_updating
301: (p_spinal_point_id => p_spinal_point_id
302: ,p_object_version_number => p_object_version_number);
303: --
304: if (l_api_updating and nvl(per_psp_shd.g_old_rec.parent_spine_id,

Line 304: if (l_api_updating and nvl(per_psp_shd.g_old_rec.parent_spine_id,

300: l_api_updating := per_psp_shd.api_updating
301: (p_spinal_point_id => p_spinal_point_id
302: ,p_object_version_number => p_object_version_number);
303: --
304: if (l_api_updating and nvl(per_psp_shd.g_old_rec.parent_spine_id,
305: hr_api.g_number) = nvl(p_parent_spine_id, hr_api.g_number)) then
306: return;
307: end if;
308:

Line 314: per_psp_shd.constraint_error(p_constraint_name => 'PER_SPINAL_POINTS_FK2');

310: fetch csr_valid_parent_spines into l_exists;
311: if csr_valid_parent_spines%notfound then
312: close csr_valid_parent_spines;
313: --
314: per_psp_shd.constraint_error(p_constraint_name => 'PER_SPINAL_POINTS_FK2');
315: --
316: end if;
317: close csr_valid_parent_spines;
318:

Line 383: l_api_updating := per_psp_shd.api_updating

379: p_argument_value => p_sequence);
380: --
381: hr_utility.set_location(l_proc,20);
382: --
383: l_api_updating := per_psp_shd.api_updating
384: (p_spinal_point_id => p_spinal_point_id
385: ,p_object_version_number => p_object_version_number);
386: --
387: if (l_api_updating and nvl(per_psp_shd.g_old_rec.sequence,

Line 387: if (l_api_updating and nvl(per_psp_shd.g_old_rec.sequence,

383: l_api_updating := per_psp_shd.api_updating
384: (p_spinal_point_id => p_spinal_point_id
385: ,p_object_version_number => p_object_version_number);
386: --
387: if (l_api_updating and nvl(per_psp_shd.g_old_rec.sequence,
388: hr_api.g_number) = nvl(p_sequence, hr_api.g_number)) then
389: hr_utility.set_location('Leaving:'||l_proc, 30);
390: return;
391: end if;

Line 471: l_api_updating := per_psp_shd.api_updating

467: p_argument_value => p_spinal_point);
468: --
469: hr_utility.set_location(l_proc,20);
470: --
471: l_api_updating := per_psp_shd.api_updating
472: (p_spinal_point_id => p_spinal_point_id
473: ,p_object_version_number => p_object_version_number);
474: --
475: if (l_api_updating and nvl(per_psp_shd.g_old_rec.spinal_point,

Line 475: if (l_api_updating and nvl(per_psp_shd.g_old_rec.spinal_point,

471: l_api_updating := per_psp_shd.api_updating
472: (p_spinal_point_id => p_spinal_point_id
473: ,p_object_version_number => p_object_version_number);
474: --
475: if (l_api_updating and nvl(per_psp_shd.g_old_rec.spinal_point,
476: hr_api.g_varchar2) = nvl(p_spinal_point, hr_api.g_varchar2)) then
477: hr_utility.set_location('Leaving:'||l_proc, 30);
478: return;
479: end if;

Line 627: (p_rec in per_psp_shd.g_rec_type

623: -- Internal Row Handler Use Only.
624: --
625: -- ----------------------------------------------------------------------------
626: procedure chk_ddf
627: (p_rec in per_psp_shd.g_rec_type
628: ) is
629: --
630: l_proc varchar2(72) := g_package || 'chk_ddf';
631: --

Line 636: nvl(per_psp_shd.g_old_rec.information_category, hr_api.g_varchar2) <>

632: begin
633: hr_utility.set_location('Entering:'||l_proc,10);
634: --
635: if ((p_rec.spinal_point_id is not null) and (
636: nvl(per_psp_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
637: nvl(p_rec.information_category, hr_api.g_varchar2) or
638: nvl(per_psp_shd.g_old_rec.information1, hr_api.g_varchar2) <>
639: nvl(p_rec.information1, hr_api.g_varchar2) or
640: nvl(per_psp_shd.g_old_rec.information2, hr_api.g_varchar2) <>

Line 638: nvl(per_psp_shd.g_old_rec.information1, hr_api.g_varchar2) <>

634: --
635: if ((p_rec.spinal_point_id is not null) and (
636: nvl(per_psp_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
637: nvl(p_rec.information_category, hr_api.g_varchar2) or
638: nvl(per_psp_shd.g_old_rec.information1, hr_api.g_varchar2) <>
639: nvl(p_rec.information1, hr_api.g_varchar2) or
640: nvl(per_psp_shd.g_old_rec.information2, hr_api.g_varchar2) <>
641: nvl(p_rec.information2, hr_api.g_varchar2) or
642: nvl(per_psp_shd.g_old_rec.information3, hr_api.g_varchar2) <>

Line 640: nvl(per_psp_shd.g_old_rec.information2, hr_api.g_varchar2) <>

636: nvl(per_psp_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
637: nvl(p_rec.information_category, hr_api.g_varchar2) or
638: nvl(per_psp_shd.g_old_rec.information1, hr_api.g_varchar2) <>
639: nvl(p_rec.information1, hr_api.g_varchar2) or
640: nvl(per_psp_shd.g_old_rec.information2, hr_api.g_varchar2) <>
641: nvl(p_rec.information2, hr_api.g_varchar2) or
642: nvl(per_psp_shd.g_old_rec.information3, hr_api.g_varchar2) <>
643: nvl(p_rec.information3, hr_api.g_varchar2) or
644: nvl(per_psp_shd.g_old_rec.information4, hr_api.g_varchar2) <>

Line 642: nvl(per_psp_shd.g_old_rec.information3, hr_api.g_varchar2) <>

638: nvl(per_psp_shd.g_old_rec.information1, hr_api.g_varchar2) <>
639: nvl(p_rec.information1, hr_api.g_varchar2) or
640: nvl(per_psp_shd.g_old_rec.information2, hr_api.g_varchar2) <>
641: nvl(p_rec.information2, hr_api.g_varchar2) or
642: nvl(per_psp_shd.g_old_rec.information3, hr_api.g_varchar2) <>
643: nvl(p_rec.information3, hr_api.g_varchar2) or
644: nvl(per_psp_shd.g_old_rec.information4, hr_api.g_varchar2) <>
645: nvl(p_rec.information4, hr_api.g_varchar2) or
646: nvl(per_psp_shd.g_old_rec.information5, hr_api.g_varchar2) <>

Line 644: nvl(per_psp_shd.g_old_rec.information4, hr_api.g_varchar2) <>

640: nvl(per_psp_shd.g_old_rec.information2, hr_api.g_varchar2) <>
641: nvl(p_rec.information2, hr_api.g_varchar2) or
642: nvl(per_psp_shd.g_old_rec.information3, hr_api.g_varchar2) <>
643: nvl(p_rec.information3, hr_api.g_varchar2) or
644: nvl(per_psp_shd.g_old_rec.information4, hr_api.g_varchar2) <>
645: nvl(p_rec.information4, hr_api.g_varchar2) or
646: nvl(per_psp_shd.g_old_rec.information5, hr_api.g_varchar2) <>
647: nvl(p_rec.information5, hr_api.g_varchar2) or
648: nvl(per_psp_shd.g_old_rec.information6, hr_api.g_varchar2) <>

Line 646: nvl(per_psp_shd.g_old_rec.information5, hr_api.g_varchar2) <>

642: nvl(per_psp_shd.g_old_rec.information3, hr_api.g_varchar2) <>
643: nvl(p_rec.information3, hr_api.g_varchar2) or
644: nvl(per_psp_shd.g_old_rec.information4, hr_api.g_varchar2) <>
645: nvl(p_rec.information4, hr_api.g_varchar2) or
646: nvl(per_psp_shd.g_old_rec.information5, hr_api.g_varchar2) <>
647: nvl(p_rec.information5, hr_api.g_varchar2) or
648: nvl(per_psp_shd.g_old_rec.information6, hr_api.g_varchar2) <>
649: nvl(p_rec.information6, hr_api.g_varchar2) or
650: nvl(per_psp_shd.g_old_rec.information7, hr_api.g_varchar2) <>

Line 648: nvl(per_psp_shd.g_old_rec.information6, hr_api.g_varchar2) <>

644: nvl(per_psp_shd.g_old_rec.information4, hr_api.g_varchar2) <>
645: nvl(p_rec.information4, hr_api.g_varchar2) or
646: nvl(per_psp_shd.g_old_rec.information5, hr_api.g_varchar2) <>
647: nvl(p_rec.information5, hr_api.g_varchar2) or
648: nvl(per_psp_shd.g_old_rec.information6, hr_api.g_varchar2) <>
649: nvl(p_rec.information6, hr_api.g_varchar2) or
650: nvl(per_psp_shd.g_old_rec.information7, hr_api.g_varchar2) <>
651: nvl(p_rec.information7, hr_api.g_varchar2) or
652: nvl(per_psp_shd.g_old_rec.information8, hr_api.g_varchar2) <>

Line 650: nvl(per_psp_shd.g_old_rec.information7, hr_api.g_varchar2) <>

646: nvl(per_psp_shd.g_old_rec.information5, hr_api.g_varchar2) <>
647: nvl(p_rec.information5, hr_api.g_varchar2) or
648: nvl(per_psp_shd.g_old_rec.information6, hr_api.g_varchar2) <>
649: nvl(p_rec.information6, hr_api.g_varchar2) or
650: nvl(per_psp_shd.g_old_rec.information7, hr_api.g_varchar2) <>
651: nvl(p_rec.information7, hr_api.g_varchar2) or
652: nvl(per_psp_shd.g_old_rec.information8, hr_api.g_varchar2) <>
653: nvl(p_rec.information8, hr_api.g_varchar2) or
654: nvl(per_psp_shd.g_old_rec.information9, hr_api.g_varchar2) <>

Line 652: nvl(per_psp_shd.g_old_rec.information8, hr_api.g_varchar2) <>

648: nvl(per_psp_shd.g_old_rec.information6, hr_api.g_varchar2) <>
649: nvl(p_rec.information6, hr_api.g_varchar2) or
650: nvl(per_psp_shd.g_old_rec.information7, hr_api.g_varchar2) <>
651: nvl(p_rec.information7, hr_api.g_varchar2) or
652: nvl(per_psp_shd.g_old_rec.information8, hr_api.g_varchar2) <>
653: nvl(p_rec.information8, hr_api.g_varchar2) or
654: nvl(per_psp_shd.g_old_rec.information9, hr_api.g_varchar2) <>
655: nvl(p_rec.information9, hr_api.g_varchar2) or
656: nvl(per_psp_shd.g_old_rec.information10, hr_api.g_varchar2) <>

Line 654: nvl(per_psp_shd.g_old_rec.information9, hr_api.g_varchar2) <>

650: nvl(per_psp_shd.g_old_rec.information7, hr_api.g_varchar2) <>
651: nvl(p_rec.information7, hr_api.g_varchar2) or
652: nvl(per_psp_shd.g_old_rec.information8, hr_api.g_varchar2) <>
653: nvl(p_rec.information8, hr_api.g_varchar2) or
654: nvl(per_psp_shd.g_old_rec.information9, hr_api.g_varchar2) <>
655: nvl(p_rec.information9, hr_api.g_varchar2) or
656: nvl(per_psp_shd.g_old_rec.information10, hr_api.g_varchar2) <>
657: nvl(p_rec.information10, hr_api.g_varchar2) or
658: nvl(per_psp_shd.g_old_rec.information11, hr_api.g_varchar2) <>

Line 656: nvl(per_psp_shd.g_old_rec.information10, hr_api.g_varchar2) <>

652: nvl(per_psp_shd.g_old_rec.information8, hr_api.g_varchar2) <>
653: nvl(p_rec.information8, hr_api.g_varchar2) or
654: nvl(per_psp_shd.g_old_rec.information9, hr_api.g_varchar2) <>
655: nvl(p_rec.information9, hr_api.g_varchar2) or
656: nvl(per_psp_shd.g_old_rec.information10, hr_api.g_varchar2) <>
657: nvl(p_rec.information10, hr_api.g_varchar2) or
658: nvl(per_psp_shd.g_old_rec.information11, hr_api.g_varchar2) <>
659: nvl(p_rec.information11, hr_api.g_varchar2) or
660: nvl(per_psp_shd.g_old_rec.information12, hr_api.g_varchar2) <>

Line 658: nvl(per_psp_shd.g_old_rec.information11, hr_api.g_varchar2) <>

654: nvl(per_psp_shd.g_old_rec.information9, hr_api.g_varchar2) <>
655: nvl(p_rec.information9, hr_api.g_varchar2) or
656: nvl(per_psp_shd.g_old_rec.information10, hr_api.g_varchar2) <>
657: nvl(p_rec.information10, hr_api.g_varchar2) or
658: nvl(per_psp_shd.g_old_rec.information11, hr_api.g_varchar2) <>
659: nvl(p_rec.information11, hr_api.g_varchar2) or
660: nvl(per_psp_shd.g_old_rec.information12, hr_api.g_varchar2) <>
661: nvl(p_rec.information12, hr_api.g_varchar2) or
662: nvl(per_psp_shd.g_old_rec.information13, hr_api.g_varchar2) <>

Line 660: nvl(per_psp_shd.g_old_rec.information12, hr_api.g_varchar2) <>

656: nvl(per_psp_shd.g_old_rec.information10, hr_api.g_varchar2) <>
657: nvl(p_rec.information10, hr_api.g_varchar2) or
658: nvl(per_psp_shd.g_old_rec.information11, hr_api.g_varchar2) <>
659: nvl(p_rec.information11, hr_api.g_varchar2) or
660: nvl(per_psp_shd.g_old_rec.information12, hr_api.g_varchar2) <>
661: nvl(p_rec.information12, hr_api.g_varchar2) or
662: nvl(per_psp_shd.g_old_rec.information13, hr_api.g_varchar2) <>
663: nvl(p_rec.information13, hr_api.g_varchar2) or
664: nvl(per_psp_shd.g_old_rec.information14, hr_api.g_varchar2) <>

Line 662: nvl(per_psp_shd.g_old_rec.information13, hr_api.g_varchar2) <>

658: nvl(per_psp_shd.g_old_rec.information11, hr_api.g_varchar2) <>
659: nvl(p_rec.information11, hr_api.g_varchar2) or
660: nvl(per_psp_shd.g_old_rec.information12, hr_api.g_varchar2) <>
661: nvl(p_rec.information12, hr_api.g_varchar2) or
662: nvl(per_psp_shd.g_old_rec.information13, hr_api.g_varchar2) <>
663: nvl(p_rec.information13, hr_api.g_varchar2) or
664: nvl(per_psp_shd.g_old_rec.information14, hr_api.g_varchar2) <>
665: nvl(p_rec.information14, hr_api.g_varchar2) or
666: nvl(per_psp_shd.g_old_rec.information15, hr_api.g_varchar2) <>

Line 664: nvl(per_psp_shd.g_old_rec.information14, hr_api.g_varchar2) <>

660: nvl(per_psp_shd.g_old_rec.information12, hr_api.g_varchar2) <>
661: nvl(p_rec.information12, hr_api.g_varchar2) or
662: nvl(per_psp_shd.g_old_rec.information13, hr_api.g_varchar2) <>
663: nvl(p_rec.information13, hr_api.g_varchar2) or
664: nvl(per_psp_shd.g_old_rec.information14, hr_api.g_varchar2) <>
665: nvl(p_rec.information14, hr_api.g_varchar2) or
666: nvl(per_psp_shd.g_old_rec.information15, hr_api.g_varchar2) <>
667: nvl(p_rec.information15, hr_api.g_varchar2) or
668: nvl(per_psp_shd.g_old_rec.information16, hr_api.g_varchar2) <>

Line 666: nvl(per_psp_shd.g_old_rec.information15, hr_api.g_varchar2) <>

662: nvl(per_psp_shd.g_old_rec.information13, hr_api.g_varchar2) <>
663: nvl(p_rec.information13, hr_api.g_varchar2) or
664: nvl(per_psp_shd.g_old_rec.information14, hr_api.g_varchar2) <>
665: nvl(p_rec.information14, hr_api.g_varchar2) or
666: nvl(per_psp_shd.g_old_rec.information15, hr_api.g_varchar2) <>
667: nvl(p_rec.information15, hr_api.g_varchar2) or
668: nvl(per_psp_shd.g_old_rec.information16, hr_api.g_varchar2) <>
669: nvl(p_rec.information16, hr_api.g_varchar2) or
670: nvl(per_psp_shd.g_old_rec.information17, hr_api.g_varchar2) <>

Line 668: nvl(per_psp_shd.g_old_rec.information16, hr_api.g_varchar2) <>

664: nvl(per_psp_shd.g_old_rec.information14, hr_api.g_varchar2) <>
665: nvl(p_rec.information14, hr_api.g_varchar2) or
666: nvl(per_psp_shd.g_old_rec.information15, hr_api.g_varchar2) <>
667: nvl(p_rec.information15, hr_api.g_varchar2) or
668: nvl(per_psp_shd.g_old_rec.information16, hr_api.g_varchar2) <>
669: nvl(p_rec.information16, hr_api.g_varchar2) or
670: nvl(per_psp_shd.g_old_rec.information17, hr_api.g_varchar2) <>
671: nvl(p_rec.information17, hr_api.g_varchar2) or
672: nvl(per_psp_shd.g_old_rec.information18, hr_api.g_varchar2) <>

Line 670: nvl(per_psp_shd.g_old_rec.information17, hr_api.g_varchar2) <>

666: nvl(per_psp_shd.g_old_rec.information15, hr_api.g_varchar2) <>
667: nvl(p_rec.information15, hr_api.g_varchar2) or
668: nvl(per_psp_shd.g_old_rec.information16, hr_api.g_varchar2) <>
669: nvl(p_rec.information16, hr_api.g_varchar2) or
670: nvl(per_psp_shd.g_old_rec.information17, hr_api.g_varchar2) <>
671: nvl(p_rec.information17, hr_api.g_varchar2) or
672: nvl(per_psp_shd.g_old_rec.information18, hr_api.g_varchar2) <>
673: nvl(p_rec.information18, hr_api.g_varchar2) or
674: nvl(per_psp_shd.g_old_rec.information19, hr_api.g_varchar2) <>

Line 672: nvl(per_psp_shd.g_old_rec.information18, hr_api.g_varchar2) <>

668: nvl(per_psp_shd.g_old_rec.information16, hr_api.g_varchar2) <>
669: nvl(p_rec.information16, hr_api.g_varchar2) or
670: nvl(per_psp_shd.g_old_rec.information17, hr_api.g_varchar2) <>
671: nvl(p_rec.information17, hr_api.g_varchar2) or
672: nvl(per_psp_shd.g_old_rec.information18, hr_api.g_varchar2) <>
673: nvl(p_rec.information18, hr_api.g_varchar2) or
674: nvl(per_psp_shd.g_old_rec.information19, hr_api.g_varchar2) <>
675: nvl(p_rec.information19, hr_api.g_varchar2) or
676: nvl(per_psp_shd.g_old_rec.information20, hr_api.g_varchar2) <>

Line 674: nvl(per_psp_shd.g_old_rec.information19, hr_api.g_varchar2) <>

670: nvl(per_psp_shd.g_old_rec.information17, hr_api.g_varchar2) <>
671: nvl(p_rec.information17, hr_api.g_varchar2) or
672: nvl(per_psp_shd.g_old_rec.information18, hr_api.g_varchar2) <>
673: nvl(p_rec.information18, hr_api.g_varchar2) or
674: nvl(per_psp_shd.g_old_rec.information19, hr_api.g_varchar2) <>
675: nvl(p_rec.information19, hr_api.g_varchar2) or
676: nvl(per_psp_shd.g_old_rec.information20, hr_api.g_varchar2) <>
677: nvl(p_rec.information20, hr_api.g_varchar2) or
678: nvl(per_psp_shd.g_old_rec.information21, hr_api.g_varchar2) <>

Line 676: nvl(per_psp_shd.g_old_rec.information20, hr_api.g_varchar2) <>

672: nvl(per_psp_shd.g_old_rec.information18, hr_api.g_varchar2) <>
673: nvl(p_rec.information18, hr_api.g_varchar2) or
674: nvl(per_psp_shd.g_old_rec.information19, hr_api.g_varchar2) <>
675: nvl(p_rec.information19, hr_api.g_varchar2) or
676: nvl(per_psp_shd.g_old_rec.information20, hr_api.g_varchar2) <>
677: nvl(p_rec.information20, hr_api.g_varchar2) or
678: nvl(per_psp_shd.g_old_rec.information21, hr_api.g_varchar2) <>
679: nvl(p_rec.information21, hr_api.g_varchar2) or
680: nvl(per_psp_shd.g_old_rec.information22, hr_api.g_varchar2) <>

Line 678: nvl(per_psp_shd.g_old_rec.information21, hr_api.g_varchar2) <>

674: nvl(per_psp_shd.g_old_rec.information19, hr_api.g_varchar2) <>
675: nvl(p_rec.information19, hr_api.g_varchar2) or
676: nvl(per_psp_shd.g_old_rec.information20, hr_api.g_varchar2) <>
677: nvl(p_rec.information20, hr_api.g_varchar2) or
678: nvl(per_psp_shd.g_old_rec.information21, hr_api.g_varchar2) <>
679: nvl(p_rec.information21, hr_api.g_varchar2) or
680: nvl(per_psp_shd.g_old_rec.information22, hr_api.g_varchar2) <>
681: nvl(p_rec.information22, hr_api.g_varchar2) or
682: nvl(per_psp_shd.g_old_rec.information23, hr_api.g_varchar2) <>

Line 680: nvl(per_psp_shd.g_old_rec.information22, hr_api.g_varchar2) <>

676: nvl(per_psp_shd.g_old_rec.information20, hr_api.g_varchar2) <>
677: nvl(p_rec.information20, hr_api.g_varchar2) or
678: nvl(per_psp_shd.g_old_rec.information21, hr_api.g_varchar2) <>
679: nvl(p_rec.information21, hr_api.g_varchar2) or
680: nvl(per_psp_shd.g_old_rec.information22, hr_api.g_varchar2) <>
681: nvl(p_rec.information22, hr_api.g_varchar2) or
682: nvl(per_psp_shd.g_old_rec.information23, hr_api.g_varchar2) <>
683: nvl(p_rec.information23, hr_api.g_varchar2) or
684: nvl(per_psp_shd.g_old_rec.information24, hr_api.g_varchar2) <>

Line 682: nvl(per_psp_shd.g_old_rec.information23, hr_api.g_varchar2) <>

678: nvl(per_psp_shd.g_old_rec.information21, hr_api.g_varchar2) <>
679: nvl(p_rec.information21, hr_api.g_varchar2) or
680: nvl(per_psp_shd.g_old_rec.information22, hr_api.g_varchar2) <>
681: nvl(p_rec.information22, hr_api.g_varchar2) or
682: nvl(per_psp_shd.g_old_rec.information23, hr_api.g_varchar2) <>
683: nvl(p_rec.information23, hr_api.g_varchar2) or
684: nvl(per_psp_shd.g_old_rec.information24, hr_api.g_varchar2) <>
685: nvl(p_rec.information24, hr_api.g_varchar2) or
686: nvl(per_psp_shd.g_old_rec.information25, hr_api.g_varchar2) <>

Line 684: nvl(per_psp_shd.g_old_rec.information24, hr_api.g_varchar2) <>

680: nvl(per_psp_shd.g_old_rec.information22, hr_api.g_varchar2) <>
681: nvl(p_rec.information22, hr_api.g_varchar2) or
682: nvl(per_psp_shd.g_old_rec.information23, hr_api.g_varchar2) <>
683: nvl(p_rec.information23, hr_api.g_varchar2) or
684: nvl(per_psp_shd.g_old_rec.information24, hr_api.g_varchar2) <>
685: nvl(p_rec.information24, hr_api.g_varchar2) or
686: nvl(per_psp_shd.g_old_rec.information25, hr_api.g_varchar2) <>
687: nvl(p_rec.information25, hr_api.g_varchar2) or
688: nvl(per_psp_shd.g_old_rec.information26, hr_api.g_varchar2) <>

Line 686: nvl(per_psp_shd.g_old_rec.information25, hr_api.g_varchar2) <>

682: nvl(per_psp_shd.g_old_rec.information23, hr_api.g_varchar2) <>
683: nvl(p_rec.information23, hr_api.g_varchar2) or
684: nvl(per_psp_shd.g_old_rec.information24, hr_api.g_varchar2) <>
685: nvl(p_rec.information24, hr_api.g_varchar2) or
686: nvl(per_psp_shd.g_old_rec.information25, hr_api.g_varchar2) <>
687: nvl(p_rec.information25, hr_api.g_varchar2) or
688: nvl(per_psp_shd.g_old_rec.information26, hr_api.g_varchar2) <>
689: nvl(p_rec.information26, hr_api.g_varchar2) or
690: nvl(per_psp_shd.g_old_rec.information27, hr_api.g_varchar2) <>

Line 688: nvl(per_psp_shd.g_old_rec.information26, hr_api.g_varchar2) <>

684: nvl(per_psp_shd.g_old_rec.information24, hr_api.g_varchar2) <>
685: nvl(p_rec.information24, hr_api.g_varchar2) or
686: nvl(per_psp_shd.g_old_rec.information25, hr_api.g_varchar2) <>
687: nvl(p_rec.information25, hr_api.g_varchar2) or
688: nvl(per_psp_shd.g_old_rec.information26, hr_api.g_varchar2) <>
689: nvl(p_rec.information26, hr_api.g_varchar2) or
690: nvl(per_psp_shd.g_old_rec.information27, hr_api.g_varchar2) <>
691: nvl(p_rec.information27, hr_api.g_varchar2) or
692: nvl(per_psp_shd.g_old_rec.information28, hr_api.g_varchar2) <>

Line 690: nvl(per_psp_shd.g_old_rec.information27, hr_api.g_varchar2) <>

686: nvl(per_psp_shd.g_old_rec.information25, hr_api.g_varchar2) <>
687: nvl(p_rec.information25, hr_api.g_varchar2) or
688: nvl(per_psp_shd.g_old_rec.information26, hr_api.g_varchar2) <>
689: nvl(p_rec.information26, hr_api.g_varchar2) or
690: nvl(per_psp_shd.g_old_rec.information27, hr_api.g_varchar2) <>
691: nvl(p_rec.information27, hr_api.g_varchar2) or
692: nvl(per_psp_shd.g_old_rec.information28, hr_api.g_varchar2) <>
693: nvl(p_rec.information28, hr_api.g_varchar2) or
694: nvl(per_psp_shd.g_old_rec.information29, hr_api.g_varchar2) <>

Line 692: nvl(per_psp_shd.g_old_rec.information28, hr_api.g_varchar2) <>

688: nvl(per_psp_shd.g_old_rec.information26, hr_api.g_varchar2) <>
689: nvl(p_rec.information26, hr_api.g_varchar2) or
690: nvl(per_psp_shd.g_old_rec.information27, hr_api.g_varchar2) <>
691: nvl(p_rec.information27, hr_api.g_varchar2) or
692: nvl(per_psp_shd.g_old_rec.information28, hr_api.g_varchar2) <>
693: nvl(p_rec.information28, hr_api.g_varchar2) or
694: nvl(per_psp_shd.g_old_rec.information29, hr_api.g_varchar2) <>
695: nvl(p_rec.information29, hr_api.g_varchar2) or
696: nvl(per_psp_shd.g_old_rec.information30, hr_api.g_varchar2) <>

Line 694: nvl(per_psp_shd.g_old_rec.information29, hr_api.g_varchar2) <>

690: nvl(per_psp_shd.g_old_rec.information27, hr_api.g_varchar2) <>
691: nvl(p_rec.information27, hr_api.g_varchar2) or
692: nvl(per_psp_shd.g_old_rec.information28, hr_api.g_varchar2) <>
693: nvl(p_rec.information28, hr_api.g_varchar2) or
694: nvl(per_psp_shd.g_old_rec.information29, hr_api.g_varchar2) <>
695: nvl(p_rec.information29, hr_api.g_varchar2) or
696: nvl(per_psp_shd.g_old_rec.information30, hr_api.g_varchar2) <>
697: nvl(p_rec.information30, hr_api.g_varchar2) ))
698: or (p_rec.spinal_point_id is null) then

Line 696: nvl(per_psp_shd.g_old_rec.information30, hr_api.g_varchar2) <>

692: nvl(per_psp_shd.g_old_rec.information28, hr_api.g_varchar2) <>
693: nvl(p_rec.information28, hr_api.g_varchar2) or
694: nvl(per_psp_shd.g_old_rec.information29, hr_api.g_varchar2) <>
695: nvl(p_rec.information29, hr_api.g_varchar2) or
696: nvl(per_psp_shd.g_old_rec.information30, hr_api.g_varchar2) <>
697: nvl(p_rec.information30, hr_api.g_varchar2) ))
698: or (p_rec.spinal_point_id is null) then
699: --
700: -- Only execute the validation if absolutely necessary:

Line 807: ,p_rec in per_psp_shd.g_rec_type

803: -- {End Of Comments}
804: -- ----------------------------------------------------------------------------
805: Procedure chk_non_updateable_args
806: (p_effective_date in date
807: ,p_rec in per_psp_shd.g_rec_type
808: ) IS
809: --
810: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
811: --

Line 817: IF NOT per_psp_shd.api_updating

813: --
814: -- Only proceed with the validation if a row exists for the current
815: -- record in the HR Schema.
816: --
817: IF NOT per_psp_shd.api_updating
818: (p_spinal_point_id => p_rec.spinal_point_id
819: ,p_object_version_number => p_rec.object_version_number
820: ) THEN
821: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 830: per_psp_shd.g_old_rec.business_group_id then

826: --
827: -- Check business_group_id is not updated
828: --
829: IF nvl(p_rec.business_group_id, hr_api.g_number) <>
830: per_psp_shd.g_old_rec.business_group_id then
831: hr_api.argument_changed_error
832: (p_api_name => l_proc
833: ,p_argument => 'BUSINESS_GROUP_ID'
834: ,p_base_table => per_psp_shd.g_tab_nam

Line 834: ,p_base_table => per_psp_shd.g_tab_nam

830: per_psp_shd.g_old_rec.business_group_id then
831: hr_api.argument_changed_error
832: (p_api_name => l_proc
833: ,p_argument => 'BUSINESS_GROUP_ID'
834: ,p_base_table => per_psp_shd.g_tab_nam
835: );
836: END IF;
837: --
838: -- Check parent_spine_id is not updated

Line 841: per_psp_shd.g_old_rec.parent_spine_id then

837: --
838: -- Check parent_spine_id is not updated
839: --
840: IF nvl(p_rec.parent_spine_id, hr_api.g_number) <>
841: per_psp_shd.g_old_rec.parent_spine_id then
842: hr_api.argument_changed_error
843: (p_api_name => l_proc
844: ,p_argument => 'PARENT_SPINE_ID'
845: ,p_base_table => per_psp_shd.g_tab_nam

Line 845: ,p_base_table => per_psp_shd.g_tab_nam

841: per_psp_shd.g_old_rec.parent_spine_id then
842: hr_api.argument_changed_error
843: (p_api_name => l_proc
844: ,p_argument => 'PARENT_SPINE_ID'
845: ,p_base_table => per_psp_shd.g_tab_nam
846: );
847: END IF;
848: End chk_non_updateable_args;
849: --

Line 855: ,p_rec in per_psp_shd.g_rec_type

851: -- |---------------------------< insert_validate >----------------------------|
852: -- ----------------------------------------------------------------------------
853: Procedure insert_validate
854: (p_effective_date in date
855: ,p_rec in per_psp_shd.g_rec_type
856: ) is
857: --
858: l_proc varchar2(72) := g_package||'insert_validate';
859: --

Line 867: ,p_associated_column1 => per_psp_shd.g_tab_nam

863: -- Call all supporting business operations
864: --
865: hr_api.validate_bus_grp_id
866: (p_business_group_id => p_rec.business_group_id
867: ,p_associated_column1 => per_psp_shd.g_tab_nam
868: || '.BUSINESS_GROUP_ID');
869: --
870: -- Validate spinal point id
871: --

Line 940: ,p_rec in per_psp_shd.g_rec_type

936: -- |---------------------------< update_validate >----------------------------|
937: -- ----------------------------------------------------------------------------
938: Procedure update_validate
939: (p_effective_date in date
940: ,p_rec in per_psp_shd.g_rec_type
941: ) is
942: --
943: l_proc varchar2(72) := g_package||'update_validate';
944: --

Line 952: ,p_associated_column1 => per_psp_shd.g_tab_nam

948: -- Call all supporting business operations
949: --
950: hr_api.validate_bus_grp_id
951: (p_business_group_id => p_rec.business_group_id
952: ,p_associated_column1 => per_psp_shd.g_tab_nam
953: || '.BUSINESS_GROUP_ID');
954:
955: --
956: -- Validate spinal point id

Line 1032: (p_rec in per_psp_shd.g_rec_type

1028: -- ----------------------------------------------------------------------------
1029: -- |---------------------------< delete_validate >----------------------------|
1030: -- ----------------------------------------------------------------------------
1031: Procedure delete_validate
1032: (p_rec in per_psp_shd.g_rec_type
1033: ) is
1034: --
1035: l_proc varchar2(72) := g_package||'delete_validate';
1036: --