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_SPS_BUS dependencies on PER_SPS_SHD

Line 203: l_api_updating := per_sps_shd.api_updating

199: --
200: Begin
201: hr_utility.set_location('Entering:'||l_proc, 10);
202: --
203: l_api_updating := per_sps_shd.api_updating
204: (p_effective_date => p_effective_date
205: ,p_step_id => p_step_id
206: ,p_object_version_number => p_object_version_number
207: );

Line 211: <> per_sps_shd.g_old_rec.step_id) then

207: );
208: --
209: if (l_api_updating
210: and nvl(p_step_id,hr_api.g_number)
211: <> per_sps_shd.g_old_rec.step_id) then
212: --
213: -- raise error as PK has changed
214: --
215: per_sps_shd.constraint_error('PER_SPINAL_POINT_STEPS_F_PK');

Line 215: per_sps_shd.constraint_error('PER_SPINAL_POINT_STEPS_F_PK');

211: <> per_sps_shd.g_old_rec.step_id) then
212: --
213: -- raise error as PK has changed
214: --
215: per_sps_shd.constraint_error('PER_SPINAL_POINT_STEPS_F_PK');
216: --
217: elsif not l_api_updating then
218: --
219: -- check if PK is null

Line 231: per_sps_shd.constraint_error('PER_SPINAL_POINT_STEPS_F_PK');

227: /*
228: --
229: -- raise error as PK is not null
230: --
231: per_sps_shd.constraint_error('PER_SPINAL_POINT_STEPS_F_PK');
232: --
233: */
234: end if;
235: --

Line 331: l_api_updating := per_sps_shd.api_updating

327: -- Only proceed with validation if :
328: -- a) The current g_old_rec is current and
329: -- b) The value for spinal_point_id has changed
330: --
331: l_api_updating := per_sps_shd.api_updating
332: (p_effective_date => p_effective_date
333: ,p_step_id => p_step_id
334: ,p_object_version_number => p_object_version_number);
335: --

Line 336: if (l_api_updating and nvl(per_sps_shd.g_old_rec.spinal_point_id,

332: (p_effective_date => p_effective_date
333: ,p_step_id => p_step_id
334: ,p_object_version_number => p_object_version_number);
335: --
336: if (l_api_updating and nvl(per_sps_shd.g_old_rec.spinal_point_id,
337: hr_api.g_number) = nvl(p_spinal_point_id, hr_api.g_number)) then
338: return;
339: end if;
340:

Line 348: per_sps_shd.constraint_error(p_constraint_name => 'PER_SPINAL_POINT_STEPS_F_FK2');

344: fetch csr_valid_spinal_point into l_exists;
345: if csr_valid_spinal_point%notfound then
346: close csr_valid_spinal_point;
347: --
348: per_sps_shd.constraint_error(p_constraint_name => 'PER_SPINAL_POINT_STEPS_F_FK2');
349: --
350: end if;
351: close csr_valid_spinal_point;
352:

Line 447: l_api_updating := per_sps_shd.api_updating

443: -- Only proceed with validation if :
444: -- a) The current g_old_rec is current and
445: -- b) The value for grade_spine_id has changed
446: --
447: l_api_updating := per_sps_shd.api_updating
448: (p_effective_date => p_effective_date
449: ,p_step_id => p_step_id
450: ,p_object_version_number => p_object_version_number);
451: --

Line 452: if (l_api_updating and nvl(per_sps_shd.g_old_rec.grade_spine_id,

448: (p_effective_date => p_effective_date
449: ,p_step_id => p_step_id
450: ,p_object_version_number => p_object_version_number);
451: --
452: if (l_api_updating and nvl(per_sps_shd.g_old_rec.grade_spine_id,
453: hr_api.g_number) = nvl(p_grade_spine_id, hr_api.g_number)) then
454: return;
455: end if;
456:

Line 464: per_sps_shd.constraint_error(p_constraint_name => 'PER_SPINAL_POINT_STEPS_F_N3');

460: fetch csr_valid_grade_spine into l_exists;
461: if csr_valid_grade_spine%notfound then
462: close csr_valid_grade_spine;
463: --
464: per_sps_shd.constraint_error(p_constraint_name => 'PER_SPINAL_POINT_STEPS_F_N3');
465: --
466: end if;
467: close csr_valid_grade_spine;
468:

Line 542: l_api_updating := per_sps_shd.api_updating

538: -- Only proceed with validation if :
539: -- a) The current g_old_rec is current and
540: -- b) The value for sequence has changed
541: --
542: l_api_updating := per_sps_shd.api_updating
543: (p_effective_date => p_effective_date
544: ,p_step_id => p_step_id
545: ,p_object_version_number => p_object_version_number);
546: --

Line 547: if (l_api_updating and nvl(per_sps_shd.g_old_rec.sequence,

543: (p_effective_date => p_effective_date
544: ,p_step_id => p_step_id
545: ,p_object_version_number => p_object_version_number);
546: --
547: if (l_api_updating and nvl(per_sps_shd.g_old_rec.sequence,
548: hr_api.g_number) = nvl(p_sequence, hr_api.g_number)) then
549: return;
550: end if;
551:

Line 636: l_api_updating := per_sps_shd.api_updating

632: -- Only proceed with validation if :
633: -- a) The current g_old_rec is current and
634: -- b) The value for spinal_point_id and grade_spine_id have changed
635: --
636: l_api_updating := per_sps_shd.api_updating
637: (p_effective_date => p_effective_date
638: ,p_step_id => p_step_id
639: ,p_object_version_number => p_object_version_number);
640: --

Line 642: and nvl(per_sps_shd.g_old_rec.spinal_point_id,

638: ,p_step_id => p_step_id
639: ,p_object_version_number => p_object_version_number);
640: --
641: if (l_api_updating
642: and nvl(per_sps_shd.g_old_rec.spinal_point_id,
643: hr_api.g_number) = nvl(p_spinal_point_id, hr_api.g_number)
644: and nvl(per_sps_shd.g_old_rec.grade_spine_id,hr_api.g_number)
645: = nvl(p_grade_spine_id, hr_api.g_number)
646: ) then

Line 644: and nvl(per_sps_shd.g_old_rec.grade_spine_id,hr_api.g_number)

640: --
641: if (l_api_updating
642: and nvl(per_sps_shd.g_old_rec.spinal_point_id,
643: hr_api.g_number) = nvl(p_spinal_point_id, hr_api.g_number)
644: and nvl(per_sps_shd.g_old_rec.grade_spine_id,hr_api.g_number)
645: = nvl(p_grade_spine_id, hr_api.g_number)
646: ) then
647: return;
648: end if;

Line 864: (p_rec in per_sps_shd.g_rec_type

860: -- Internal Row Handler Use Only.
861: --
862: -- ----------------------------------------------------------------------------
863: procedure chk_ddf
864: (p_rec in per_sps_shd.g_rec_type
865: ) is
866: --
867: l_proc varchar2(72) := g_package || 'chk_ddf';
868: --

Line 873: nvl(per_sps_shd.g_old_rec.information1, hr_api.g_varchar2) <>

869: begin
870: hr_utility.set_location('Entering:'||l_proc,10);
871: --
872: if ((p_rec.step_id is not null) and (
873: nvl(per_sps_shd.g_old_rec.information1, hr_api.g_varchar2) <>
874: nvl(p_rec.information1, hr_api.g_varchar2) or
875: nvl(per_sps_shd.g_old_rec.information2, hr_api.g_varchar2) <>
876: nvl(p_rec.information2, hr_api.g_varchar2) or
877: nvl(per_sps_shd.g_old_rec.information3, hr_api.g_varchar2) <>

Line 875: nvl(per_sps_shd.g_old_rec.information2, hr_api.g_varchar2) <>

871: --
872: if ((p_rec.step_id is not null) and (
873: nvl(per_sps_shd.g_old_rec.information1, hr_api.g_varchar2) <>
874: nvl(p_rec.information1, hr_api.g_varchar2) or
875: nvl(per_sps_shd.g_old_rec.information2, hr_api.g_varchar2) <>
876: nvl(p_rec.information2, hr_api.g_varchar2) or
877: nvl(per_sps_shd.g_old_rec.information3, hr_api.g_varchar2) <>
878: nvl(p_rec.information3, hr_api.g_varchar2) or
879: nvl(per_sps_shd.g_old_rec.information4, hr_api.g_varchar2) <>

Line 877: nvl(per_sps_shd.g_old_rec.information3, hr_api.g_varchar2) <>

873: nvl(per_sps_shd.g_old_rec.information1, hr_api.g_varchar2) <>
874: nvl(p_rec.information1, hr_api.g_varchar2) or
875: nvl(per_sps_shd.g_old_rec.information2, hr_api.g_varchar2) <>
876: nvl(p_rec.information2, hr_api.g_varchar2) or
877: nvl(per_sps_shd.g_old_rec.information3, hr_api.g_varchar2) <>
878: nvl(p_rec.information3, hr_api.g_varchar2) or
879: nvl(per_sps_shd.g_old_rec.information4, hr_api.g_varchar2) <>
880: nvl(p_rec.information4, hr_api.g_varchar2) or
881: nvl(per_sps_shd.g_old_rec.information5, hr_api.g_varchar2) <>

Line 879: nvl(per_sps_shd.g_old_rec.information4, hr_api.g_varchar2) <>

875: nvl(per_sps_shd.g_old_rec.information2, hr_api.g_varchar2) <>
876: nvl(p_rec.information2, hr_api.g_varchar2) or
877: nvl(per_sps_shd.g_old_rec.information3, hr_api.g_varchar2) <>
878: nvl(p_rec.information3, hr_api.g_varchar2) or
879: nvl(per_sps_shd.g_old_rec.information4, hr_api.g_varchar2) <>
880: nvl(p_rec.information4, hr_api.g_varchar2) or
881: nvl(per_sps_shd.g_old_rec.information5, hr_api.g_varchar2) <>
882: nvl(p_rec.information5, hr_api.g_varchar2) or
883: nvl(per_sps_shd.g_old_rec.information6, hr_api.g_varchar2) <>

Line 881: nvl(per_sps_shd.g_old_rec.information5, hr_api.g_varchar2) <>

877: nvl(per_sps_shd.g_old_rec.information3, hr_api.g_varchar2) <>
878: nvl(p_rec.information3, hr_api.g_varchar2) or
879: nvl(per_sps_shd.g_old_rec.information4, hr_api.g_varchar2) <>
880: nvl(p_rec.information4, hr_api.g_varchar2) or
881: nvl(per_sps_shd.g_old_rec.information5, hr_api.g_varchar2) <>
882: nvl(p_rec.information5, hr_api.g_varchar2) or
883: nvl(per_sps_shd.g_old_rec.information6, hr_api.g_varchar2) <>
884: nvl(p_rec.information6, hr_api.g_varchar2) or
885: nvl(per_sps_shd.g_old_rec.information7, hr_api.g_varchar2) <>

Line 883: nvl(per_sps_shd.g_old_rec.information6, hr_api.g_varchar2) <>

879: nvl(per_sps_shd.g_old_rec.information4, hr_api.g_varchar2) <>
880: nvl(p_rec.information4, hr_api.g_varchar2) or
881: nvl(per_sps_shd.g_old_rec.information5, hr_api.g_varchar2) <>
882: nvl(p_rec.information5, hr_api.g_varchar2) or
883: nvl(per_sps_shd.g_old_rec.information6, hr_api.g_varchar2) <>
884: nvl(p_rec.information6, hr_api.g_varchar2) or
885: nvl(per_sps_shd.g_old_rec.information7, hr_api.g_varchar2) <>
886: nvl(p_rec.information7, hr_api.g_varchar2) or
887: nvl(per_sps_shd.g_old_rec.information8, hr_api.g_varchar2) <>

Line 885: nvl(per_sps_shd.g_old_rec.information7, hr_api.g_varchar2) <>

881: nvl(per_sps_shd.g_old_rec.information5, hr_api.g_varchar2) <>
882: nvl(p_rec.information5, hr_api.g_varchar2) or
883: nvl(per_sps_shd.g_old_rec.information6, hr_api.g_varchar2) <>
884: nvl(p_rec.information6, hr_api.g_varchar2) or
885: nvl(per_sps_shd.g_old_rec.information7, hr_api.g_varchar2) <>
886: nvl(p_rec.information7, hr_api.g_varchar2) or
887: nvl(per_sps_shd.g_old_rec.information8, hr_api.g_varchar2) <>
888: nvl(p_rec.information8, hr_api.g_varchar2) or
889: nvl(per_sps_shd.g_old_rec.information9, hr_api.g_varchar2) <>

Line 887: nvl(per_sps_shd.g_old_rec.information8, hr_api.g_varchar2) <>

883: nvl(per_sps_shd.g_old_rec.information6, hr_api.g_varchar2) <>
884: nvl(p_rec.information6, hr_api.g_varchar2) or
885: nvl(per_sps_shd.g_old_rec.information7, hr_api.g_varchar2) <>
886: nvl(p_rec.information7, hr_api.g_varchar2) or
887: nvl(per_sps_shd.g_old_rec.information8, hr_api.g_varchar2) <>
888: nvl(p_rec.information8, hr_api.g_varchar2) or
889: nvl(per_sps_shd.g_old_rec.information9, hr_api.g_varchar2) <>
890: nvl(p_rec.information9, hr_api.g_varchar2) or
891: nvl(per_sps_shd.g_old_rec.information10, hr_api.g_varchar2) <>

Line 889: nvl(per_sps_shd.g_old_rec.information9, hr_api.g_varchar2) <>

885: nvl(per_sps_shd.g_old_rec.information7, hr_api.g_varchar2) <>
886: nvl(p_rec.information7, hr_api.g_varchar2) or
887: nvl(per_sps_shd.g_old_rec.information8, hr_api.g_varchar2) <>
888: nvl(p_rec.information8, hr_api.g_varchar2) or
889: nvl(per_sps_shd.g_old_rec.information9, hr_api.g_varchar2) <>
890: nvl(p_rec.information9, hr_api.g_varchar2) or
891: nvl(per_sps_shd.g_old_rec.information10, hr_api.g_varchar2) <>
892: nvl(p_rec.information10, hr_api.g_varchar2) or
893: nvl(per_sps_shd.g_old_rec.information11, hr_api.g_varchar2) <>

Line 891: nvl(per_sps_shd.g_old_rec.information10, hr_api.g_varchar2) <>

887: nvl(per_sps_shd.g_old_rec.information8, hr_api.g_varchar2) <>
888: nvl(p_rec.information8, hr_api.g_varchar2) or
889: nvl(per_sps_shd.g_old_rec.information9, hr_api.g_varchar2) <>
890: nvl(p_rec.information9, hr_api.g_varchar2) or
891: nvl(per_sps_shd.g_old_rec.information10, hr_api.g_varchar2) <>
892: nvl(p_rec.information10, hr_api.g_varchar2) or
893: nvl(per_sps_shd.g_old_rec.information11, hr_api.g_varchar2) <>
894: nvl(p_rec.information11, hr_api.g_varchar2) or
895: nvl(per_sps_shd.g_old_rec.information12, hr_api.g_varchar2) <>

Line 893: nvl(per_sps_shd.g_old_rec.information11, hr_api.g_varchar2) <>

889: nvl(per_sps_shd.g_old_rec.information9, hr_api.g_varchar2) <>
890: nvl(p_rec.information9, hr_api.g_varchar2) or
891: nvl(per_sps_shd.g_old_rec.information10, hr_api.g_varchar2) <>
892: nvl(p_rec.information10, hr_api.g_varchar2) or
893: nvl(per_sps_shd.g_old_rec.information11, hr_api.g_varchar2) <>
894: nvl(p_rec.information11, hr_api.g_varchar2) or
895: nvl(per_sps_shd.g_old_rec.information12, hr_api.g_varchar2) <>
896: nvl(p_rec.information12, hr_api.g_varchar2) or
897: nvl(per_sps_shd.g_old_rec.information13, hr_api.g_varchar2) <>

Line 895: nvl(per_sps_shd.g_old_rec.information12, hr_api.g_varchar2) <>

891: nvl(per_sps_shd.g_old_rec.information10, hr_api.g_varchar2) <>
892: nvl(p_rec.information10, hr_api.g_varchar2) or
893: nvl(per_sps_shd.g_old_rec.information11, hr_api.g_varchar2) <>
894: nvl(p_rec.information11, hr_api.g_varchar2) or
895: nvl(per_sps_shd.g_old_rec.information12, hr_api.g_varchar2) <>
896: nvl(p_rec.information12, hr_api.g_varchar2) or
897: nvl(per_sps_shd.g_old_rec.information13, hr_api.g_varchar2) <>
898: nvl(p_rec.information13, hr_api.g_varchar2) or
899: nvl(per_sps_shd.g_old_rec.information14, hr_api.g_varchar2) <>

Line 897: nvl(per_sps_shd.g_old_rec.information13, hr_api.g_varchar2) <>

893: nvl(per_sps_shd.g_old_rec.information11, hr_api.g_varchar2) <>
894: nvl(p_rec.information11, hr_api.g_varchar2) or
895: nvl(per_sps_shd.g_old_rec.information12, hr_api.g_varchar2) <>
896: nvl(p_rec.information12, hr_api.g_varchar2) or
897: nvl(per_sps_shd.g_old_rec.information13, hr_api.g_varchar2) <>
898: nvl(p_rec.information13, hr_api.g_varchar2) or
899: nvl(per_sps_shd.g_old_rec.information14, hr_api.g_varchar2) <>
900: nvl(p_rec.information14, hr_api.g_varchar2) or
901: nvl(per_sps_shd.g_old_rec.information15, hr_api.g_varchar2) <>

Line 899: nvl(per_sps_shd.g_old_rec.information14, hr_api.g_varchar2) <>

895: nvl(per_sps_shd.g_old_rec.information12, hr_api.g_varchar2) <>
896: nvl(p_rec.information12, hr_api.g_varchar2) or
897: nvl(per_sps_shd.g_old_rec.information13, hr_api.g_varchar2) <>
898: nvl(p_rec.information13, hr_api.g_varchar2) or
899: nvl(per_sps_shd.g_old_rec.information14, hr_api.g_varchar2) <>
900: nvl(p_rec.information14, hr_api.g_varchar2) or
901: nvl(per_sps_shd.g_old_rec.information15, hr_api.g_varchar2) <>
902: nvl(p_rec.information15, hr_api.g_varchar2) or
903: nvl(per_sps_shd.g_old_rec.information16, hr_api.g_varchar2) <>

Line 901: nvl(per_sps_shd.g_old_rec.information15, hr_api.g_varchar2) <>

897: nvl(per_sps_shd.g_old_rec.information13, hr_api.g_varchar2) <>
898: nvl(p_rec.information13, hr_api.g_varchar2) or
899: nvl(per_sps_shd.g_old_rec.information14, hr_api.g_varchar2) <>
900: nvl(p_rec.information14, hr_api.g_varchar2) or
901: nvl(per_sps_shd.g_old_rec.information15, hr_api.g_varchar2) <>
902: nvl(p_rec.information15, hr_api.g_varchar2) or
903: nvl(per_sps_shd.g_old_rec.information16, hr_api.g_varchar2) <>
904: nvl(p_rec.information16, hr_api.g_varchar2) or
905: nvl(per_sps_shd.g_old_rec.information17, hr_api.g_varchar2) <>

Line 903: nvl(per_sps_shd.g_old_rec.information16, hr_api.g_varchar2) <>

899: nvl(per_sps_shd.g_old_rec.information14, hr_api.g_varchar2) <>
900: nvl(p_rec.information14, hr_api.g_varchar2) or
901: nvl(per_sps_shd.g_old_rec.information15, hr_api.g_varchar2) <>
902: nvl(p_rec.information15, hr_api.g_varchar2) or
903: nvl(per_sps_shd.g_old_rec.information16, hr_api.g_varchar2) <>
904: nvl(p_rec.information16, hr_api.g_varchar2) or
905: nvl(per_sps_shd.g_old_rec.information17, hr_api.g_varchar2) <>
906: nvl(p_rec.information17, hr_api.g_varchar2) or
907: nvl(per_sps_shd.g_old_rec.information18, hr_api.g_varchar2) <>

Line 905: nvl(per_sps_shd.g_old_rec.information17, hr_api.g_varchar2) <>

901: nvl(per_sps_shd.g_old_rec.information15, hr_api.g_varchar2) <>
902: nvl(p_rec.information15, hr_api.g_varchar2) or
903: nvl(per_sps_shd.g_old_rec.information16, hr_api.g_varchar2) <>
904: nvl(p_rec.information16, hr_api.g_varchar2) or
905: nvl(per_sps_shd.g_old_rec.information17, hr_api.g_varchar2) <>
906: nvl(p_rec.information17, hr_api.g_varchar2) or
907: nvl(per_sps_shd.g_old_rec.information18, hr_api.g_varchar2) <>
908: nvl(p_rec.information18, hr_api.g_varchar2) or
909: nvl(per_sps_shd.g_old_rec.information19, hr_api.g_varchar2) <>

Line 907: nvl(per_sps_shd.g_old_rec.information18, hr_api.g_varchar2) <>

903: nvl(per_sps_shd.g_old_rec.information16, hr_api.g_varchar2) <>
904: nvl(p_rec.information16, hr_api.g_varchar2) or
905: nvl(per_sps_shd.g_old_rec.information17, hr_api.g_varchar2) <>
906: nvl(p_rec.information17, hr_api.g_varchar2) or
907: nvl(per_sps_shd.g_old_rec.information18, hr_api.g_varchar2) <>
908: nvl(p_rec.information18, hr_api.g_varchar2) or
909: nvl(per_sps_shd.g_old_rec.information19, hr_api.g_varchar2) <>
910: nvl(p_rec.information19, hr_api.g_varchar2) or
911: nvl(per_sps_shd.g_old_rec.information20, hr_api.g_varchar2) <>

Line 909: nvl(per_sps_shd.g_old_rec.information19, hr_api.g_varchar2) <>

905: nvl(per_sps_shd.g_old_rec.information17, hr_api.g_varchar2) <>
906: nvl(p_rec.information17, hr_api.g_varchar2) or
907: nvl(per_sps_shd.g_old_rec.information18, hr_api.g_varchar2) <>
908: nvl(p_rec.information18, hr_api.g_varchar2) or
909: nvl(per_sps_shd.g_old_rec.information19, hr_api.g_varchar2) <>
910: nvl(p_rec.information19, hr_api.g_varchar2) or
911: nvl(per_sps_shd.g_old_rec.information20, hr_api.g_varchar2) <>
912: nvl(p_rec.information20, hr_api.g_varchar2) or
913: nvl(per_sps_shd.g_old_rec.information21, hr_api.g_varchar2) <>

Line 911: nvl(per_sps_shd.g_old_rec.information20, hr_api.g_varchar2) <>

907: nvl(per_sps_shd.g_old_rec.information18, hr_api.g_varchar2) <>
908: nvl(p_rec.information18, hr_api.g_varchar2) or
909: nvl(per_sps_shd.g_old_rec.information19, hr_api.g_varchar2) <>
910: nvl(p_rec.information19, hr_api.g_varchar2) or
911: nvl(per_sps_shd.g_old_rec.information20, hr_api.g_varchar2) <>
912: nvl(p_rec.information20, hr_api.g_varchar2) or
913: nvl(per_sps_shd.g_old_rec.information21, hr_api.g_varchar2) <>
914: nvl(p_rec.information21, hr_api.g_varchar2) or
915: nvl(per_sps_shd.g_old_rec.information22, hr_api.g_varchar2) <>

Line 913: nvl(per_sps_shd.g_old_rec.information21, hr_api.g_varchar2) <>

909: nvl(per_sps_shd.g_old_rec.information19, hr_api.g_varchar2) <>
910: nvl(p_rec.information19, hr_api.g_varchar2) or
911: nvl(per_sps_shd.g_old_rec.information20, hr_api.g_varchar2) <>
912: nvl(p_rec.information20, hr_api.g_varchar2) or
913: nvl(per_sps_shd.g_old_rec.information21, hr_api.g_varchar2) <>
914: nvl(p_rec.information21, hr_api.g_varchar2) or
915: nvl(per_sps_shd.g_old_rec.information22, hr_api.g_varchar2) <>
916: nvl(p_rec.information22, hr_api.g_varchar2) or
917: nvl(per_sps_shd.g_old_rec.information23, hr_api.g_varchar2) <>

Line 915: nvl(per_sps_shd.g_old_rec.information22, hr_api.g_varchar2) <>

911: nvl(per_sps_shd.g_old_rec.information20, hr_api.g_varchar2) <>
912: nvl(p_rec.information20, hr_api.g_varchar2) or
913: nvl(per_sps_shd.g_old_rec.information21, hr_api.g_varchar2) <>
914: nvl(p_rec.information21, hr_api.g_varchar2) or
915: nvl(per_sps_shd.g_old_rec.information22, hr_api.g_varchar2) <>
916: nvl(p_rec.information22, hr_api.g_varchar2) or
917: nvl(per_sps_shd.g_old_rec.information23, hr_api.g_varchar2) <>
918: nvl(p_rec.information23, hr_api.g_varchar2) or
919: nvl(per_sps_shd.g_old_rec.information24, hr_api.g_varchar2) <>

Line 917: nvl(per_sps_shd.g_old_rec.information23, hr_api.g_varchar2) <>

913: nvl(per_sps_shd.g_old_rec.information21, hr_api.g_varchar2) <>
914: nvl(p_rec.information21, hr_api.g_varchar2) or
915: nvl(per_sps_shd.g_old_rec.information22, hr_api.g_varchar2) <>
916: nvl(p_rec.information22, hr_api.g_varchar2) or
917: nvl(per_sps_shd.g_old_rec.information23, hr_api.g_varchar2) <>
918: nvl(p_rec.information23, hr_api.g_varchar2) or
919: nvl(per_sps_shd.g_old_rec.information24, hr_api.g_varchar2) <>
920: nvl(p_rec.information24, hr_api.g_varchar2) or
921: nvl(per_sps_shd.g_old_rec.information25, hr_api.g_varchar2) <>

Line 919: nvl(per_sps_shd.g_old_rec.information24, hr_api.g_varchar2) <>

915: nvl(per_sps_shd.g_old_rec.information22, hr_api.g_varchar2) <>
916: nvl(p_rec.information22, hr_api.g_varchar2) or
917: nvl(per_sps_shd.g_old_rec.information23, hr_api.g_varchar2) <>
918: nvl(p_rec.information23, hr_api.g_varchar2) or
919: nvl(per_sps_shd.g_old_rec.information24, hr_api.g_varchar2) <>
920: nvl(p_rec.information24, hr_api.g_varchar2) or
921: nvl(per_sps_shd.g_old_rec.information25, hr_api.g_varchar2) <>
922: nvl(p_rec.information25, hr_api.g_varchar2) or
923: nvl(per_sps_shd.g_old_rec.information26, hr_api.g_varchar2) <>

Line 921: nvl(per_sps_shd.g_old_rec.information25, hr_api.g_varchar2) <>

917: nvl(per_sps_shd.g_old_rec.information23, hr_api.g_varchar2) <>
918: nvl(p_rec.information23, hr_api.g_varchar2) or
919: nvl(per_sps_shd.g_old_rec.information24, hr_api.g_varchar2) <>
920: nvl(p_rec.information24, hr_api.g_varchar2) or
921: nvl(per_sps_shd.g_old_rec.information25, hr_api.g_varchar2) <>
922: nvl(p_rec.information25, hr_api.g_varchar2) or
923: nvl(per_sps_shd.g_old_rec.information26, hr_api.g_varchar2) <>
924: nvl(p_rec.information26, hr_api.g_varchar2) or
925: nvl(per_sps_shd.g_old_rec.information27, hr_api.g_varchar2) <>

Line 923: nvl(per_sps_shd.g_old_rec.information26, hr_api.g_varchar2) <>

919: nvl(per_sps_shd.g_old_rec.information24, hr_api.g_varchar2) <>
920: nvl(p_rec.information24, hr_api.g_varchar2) or
921: nvl(per_sps_shd.g_old_rec.information25, hr_api.g_varchar2) <>
922: nvl(p_rec.information25, hr_api.g_varchar2) or
923: nvl(per_sps_shd.g_old_rec.information26, hr_api.g_varchar2) <>
924: nvl(p_rec.information26, hr_api.g_varchar2) or
925: nvl(per_sps_shd.g_old_rec.information27, hr_api.g_varchar2) <>
926: nvl(p_rec.information27, hr_api.g_varchar2) or
927: nvl(per_sps_shd.g_old_rec.information28, hr_api.g_varchar2) <>

Line 925: nvl(per_sps_shd.g_old_rec.information27, hr_api.g_varchar2) <>

921: nvl(per_sps_shd.g_old_rec.information25, hr_api.g_varchar2) <>
922: nvl(p_rec.information25, hr_api.g_varchar2) or
923: nvl(per_sps_shd.g_old_rec.information26, hr_api.g_varchar2) <>
924: nvl(p_rec.information26, hr_api.g_varchar2) or
925: nvl(per_sps_shd.g_old_rec.information27, hr_api.g_varchar2) <>
926: nvl(p_rec.information27, hr_api.g_varchar2) or
927: nvl(per_sps_shd.g_old_rec.information28, hr_api.g_varchar2) <>
928: nvl(p_rec.information28, hr_api.g_varchar2) or
929: nvl(per_sps_shd.g_old_rec.information29, hr_api.g_varchar2) <>

Line 927: nvl(per_sps_shd.g_old_rec.information28, hr_api.g_varchar2) <>

923: nvl(per_sps_shd.g_old_rec.information26, hr_api.g_varchar2) <>
924: nvl(p_rec.information26, hr_api.g_varchar2) or
925: nvl(per_sps_shd.g_old_rec.information27, hr_api.g_varchar2) <>
926: nvl(p_rec.information27, hr_api.g_varchar2) or
927: nvl(per_sps_shd.g_old_rec.information28, hr_api.g_varchar2) <>
928: nvl(p_rec.information28, hr_api.g_varchar2) or
929: nvl(per_sps_shd.g_old_rec.information29, hr_api.g_varchar2) <>
930: nvl(p_rec.information29, hr_api.g_varchar2) or
931: nvl(per_sps_shd.g_old_rec.information30, hr_api.g_varchar2) <>

Line 929: nvl(per_sps_shd.g_old_rec.information29, hr_api.g_varchar2) <>

925: nvl(per_sps_shd.g_old_rec.information27, hr_api.g_varchar2) <>
926: nvl(p_rec.information27, hr_api.g_varchar2) or
927: nvl(per_sps_shd.g_old_rec.information28, hr_api.g_varchar2) <>
928: nvl(p_rec.information28, hr_api.g_varchar2) or
929: nvl(per_sps_shd.g_old_rec.information29, hr_api.g_varchar2) <>
930: nvl(p_rec.information29, hr_api.g_varchar2) or
931: nvl(per_sps_shd.g_old_rec.information30, hr_api.g_varchar2) <>
932: nvl(p_rec.information30, hr_api.g_varchar2) or
933: nvl(per_sps_shd.g_old_rec.information_category, hr_api.g_varchar2) <>

Line 931: nvl(per_sps_shd.g_old_rec.information30, hr_api.g_varchar2) <>

927: nvl(per_sps_shd.g_old_rec.information28, hr_api.g_varchar2) <>
928: nvl(p_rec.information28, hr_api.g_varchar2) or
929: nvl(per_sps_shd.g_old_rec.information29, hr_api.g_varchar2) <>
930: nvl(p_rec.information29, hr_api.g_varchar2) or
931: nvl(per_sps_shd.g_old_rec.information30, hr_api.g_varchar2) <>
932: nvl(p_rec.information30, hr_api.g_varchar2) or
933: nvl(per_sps_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
934: nvl(p_rec.information_category, hr_api.g_varchar2) ))
935: or (p_rec.step_id is null) then

Line 933: nvl(per_sps_shd.g_old_rec.information_category, hr_api.g_varchar2) <>

929: nvl(per_sps_shd.g_old_rec.information29, hr_api.g_varchar2) <>
930: nvl(p_rec.information29, hr_api.g_varchar2) or
931: nvl(per_sps_shd.g_old_rec.information30, hr_api.g_varchar2) <>
932: nvl(p_rec.information30, hr_api.g_varchar2) or
933: nvl(per_sps_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
934: nvl(p_rec.information_category, hr_api.g_varchar2) ))
935: or (p_rec.step_id is null) then
936: --
937: -- Only execute the validation if absolutely necessary:

Line 1041: ,p_rec in per_sps_shd.g_rec_type

1037: -- {End Of Comments}
1038: -- ----------------------------------------------------------------------------
1039: Procedure chk_non_updateable_args
1040: (p_effective_date in date
1041: ,p_rec in per_sps_shd.g_rec_type
1042: ) IS
1043: --
1044: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
1045: --

Line 1051: IF NOT per_sps_shd.api_updating

1047: --
1048: -- Only proceed with the validation if a row exists for the current
1049: -- record in the HR Schema.
1050: --
1051: IF NOT per_sps_shd.api_updating
1052: (p_step_id => p_rec.step_id
1053: ,p_effective_date => p_effective_date
1054: ,p_object_version_number => p_rec.object_version_number
1055: ) THEN

Line 1066: per_sps_shd.g_old_rec.business_group_id then

1062: --
1063: -- Check business_group_id is not updated
1064: --
1065: IF nvl(p_rec.business_group_id, hr_api.g_number) <>
1066: per_sps_shd.g_old_rec.business_group_id then
1067: hr_api.argument_changed_error
1068: (p_api_name => l_proc
1069: ,p_argument => 'BUSINESS_GROUP_ID'
1070: ,p_base_table => per_sps_shd.g_tab_nam

Line 1070: ,p_base_table => per_sps_shd.g_tab_nam

1066: per_sps_shd.g_old_rec.business_group_id then
1067: hr_api.argument_changed_error
1068: (p_api_name => l_proc
1069: ,p_argument => 'BUSINESS_GROUP_ID'
1070: ,p_base_table => per_sps_shd.g_tab_nam
1071: );
1072: END IF;
1073:
1074: --

Line 1078: per_sps_shd.g_old_rec.spinal_point_id then

1074: --
1075: -- Check spinal_point_id is not updated
1076: --
1077: IF nvl(p_rec.spinal_point_id, hr_api.g_number) <>
1078: per_sps_shd.g_old_rec.spinal_point_id then
1079: hr_api.argument_changed_error
1080: (p_api_name => l_proc
1081: ,p_argument => 'SPINAL_POINT_ID'
1082: ,p_base_table => per_sps_shd.g_tab_nam

Line 1082: ,p_base_table => per_sps_shd.g_tab_nam

1078: per_sps_shd.g_old_rec.spinal_point_id then
1079: hr_api.argument_changed_error
1080: (p_api_name => l_proc
1081: ,p_argument => 'SPINAL_POINT_ID'
1082: ,p_base_table => per_sps_shd.g_tab_nam
1083: );
1084: END IF;
1085:
1086: --

Line 1090: per_sps_shd.g_old_rec.grade_spine_id then

1086: --
1087: -- Check grade_spine_id is not updated
1088: --
1089: IF nvl(p_rec.grade_spine_id, hr_api.g_number) <>
1090: per_sps_shd.g_old_rec.grade_spine_id then
1091: hr_api.argument_changed_error
1092: (p_api_name => l_proc
1093: ,p_argument => 'GRADE_SPINE_ID'
1094: ,p_base_table => per_sps_shd.g_tab_nam

Line 1094: ,p_base_table => per_sps_shd.g_tab_nam

1090: per_sps_shd.g_old_rec.grade_spine_id then
1091: hr_api.argument_changed_error
1092: (p_api_name => l_proc
1093: ,p_argument => 'GRADE_SPINE_ID'
1094: ,p_base_table => per_sps_shd.g_tab_nam
1095: );
1096: END IF;
1097:
1098: --

Line 1102: per_sps_shd.g_old_rec.sequence then

1098: --
1099: -- Check sequence is not updated
1100: --
1101: IF nvl(p_rec.sequence, hr_api.g_number) <>
1102: per_sps_shd.g_old_rec.sequence then
1103: hr_api.argument_changed_error
1104: (p_api_name => l_proc
1105: ,p_argument => 'SEQUENCE'
1106: ,p_base_table => per_sps_shd.g_tab_nam

Line 1106: ,p_base_table => per_sps_shd.g_tab_nam

1102: per_sps_shd.g_old_rec.sequence then
1103: hr_api.argument_changed_error
1104: (p_api_name => l_proc
1105: ,p_argument => 'SEQUENCE'
1106: ,p_base_table => per_sps_shd.g_tab_nam
1107: );
1108: END IF;
1109: --
1110: End chk_non_updateable_args;

Line 1186: (p_associated_column1 => per_sps_shd.g_tab_nam || '.GRADE_SPINE_ID');

1182: ,p_to_date => p_validation_end_date))) Then
1183: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
1184: fnd_message.set_token('TABLE_NAME','grade spines');
1185: hr_multi_message.add
1186: (p_associated_column1 => per_sps_shd.g_tab_nam || '.GRADE_SPINE_ID');
1187: End If;
1188: --
1189: Exception
1190: When Others Then

Line 1334: (p_rec in per_sps_shd.g_rec_type

1330: -- ----------------------------------------------------------------------------
1331: -- |---------------------------< insert_validate >----------------------------|
1332: -- ----------------------------------------------------------------------------
1333: Procedure insert_validate
1334: (p_rec in per_sps_shd.g_rec_type
1335: ,p_effective_date in date
1336: ,p_datetrack_mode in varchar2
1337: ,p_validation_start_date in date
1338: ,p_validation_end_date in date

Line 1350: ,p_associated_column1 => per_sps_shd.g_tab_nam

1346: -- Call all supporting business operations
1347: --
1348: hr_api.validate_bus_grp_id
1349: (p_business_group_id => p_rec.business_group_id
1350: ,p_associated_column1 => per_sps_shd.g_tab_nam
1351: || '.BUSINESS_GROUP_ID');
1352:
1353: --
1354: -- Check step id

Line 1437: (p_rec in per_sps_shd.g_rec_type

1433: -- ----------------------------------------------------------------------------
1434: -- |---------------------------< update_validate >----------------------------|
1435: -- ----------------------------------------------------------------------------
1436: Procedure update_validate
1437: (p_rec in per_sps_shd.g_rec_type
1438: ,p_effective_date in date
1439: ,p_datetrack_mode in varchar2
1440: ,p_validation_start_date in date
1441: ,p_validation_end_date in date

Line 1453: ,p_associated_column1 => per_sps_shd.g_tab_nam

1449: -- Call all supporting business operations
1450: --
1451: hr_api.validate_bus_grp_id
1452: (p_business_group_id => p_rec.business_group_id
1453: ,p_associated_column1 => per_sps_shd.g_tab_nam
1454: || '.BUSINESS_GROUP_ID');
1455:
1456: --
1457: -- Check step id

Line 1562: (p_rec in per_sps_shd.g_rec_type

1558: -- ----------------------------------------------------------------------------
1559: -- |---------------------------< delete_validate >----------------------------|
1560: -- ----------------------------------------------------------------------------
1561: Procedure delete_validate
1562: (p_rec in per_sps_shd.g_rec_type
1563: ,p_effective_date in date
1564: ,p_datetrack_mode in varchar2
1565: ,p_validation_start_date in date
1566: ,p_validation_end_date in date