43: hr_utility.set_location('Entering:'|| l_proc, 10);
44: --
45: -- Ensure that all the mandatory parameter are not null
46: --
47: hr_api.mandatory_arg_error
48: (p_api_name => l_proc
49: ,p_argument => 'spinal_point_id'
50: ,p_argument_value => p_spinal_point_id
51: );
70: close csr_sec_grp;
71: --
72: -- Set the security_group_id in CLIENT_INFO
73: --
74: hr_api.set_security_group_id
75: (p_security_group_id => l_security_group_id
76: );
77: --
78: -- Set the sessions legislation context in HR_SESSION_DATA
76: );
77: --
78: -- Set the sessions legislation context in HR_SESSION_DATA
79: --
80: hr_api.set_legislation_context(l_legislation_code);
81: end if;
82: --
83: hr_utility.set_location(' Leaving:'|| l_proc, 20);
84: --
112: hr_utility.set_location('Entering:'|| l_proc, 10);
113: --
114: -- Ensure that all the mandatory parameter are not null
115: --
116: hr_api.mandatory_arg_error
117: (p_api_name => l_proc
118: ,p_argument => 'spinal_point_id'
119: ,p_argument_value => p_spinal_point_id
120: );
118: ,p_argument => 'spinal_point_id'
119: ,p_argument_value => p_spinal_point_id
120: );
121: --
122: if ( nvl(per_psp_bus.g_spinal_point_id, hr_api.g_number)
123: = p_spinal_point_id) then
124: --
125: -- The legislation code has already been found with a previous
126: -- call to this function. Just return the value in the global
203: ,p_object_version_number => p_object_version_number
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: --
285: hr_utility.set_location('Entering:'|| l_proc, 10);
286: --
287: -- Check mandatory parameters have been set
288: --
289: hr_api.mandatory_arg_error
290: (p_api_name => l_proc
291: ,p_argument => 'parent_spine_id'
292: ,p_argument_value => p_parent_spine_id
293: );
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:
309: open csr_valid_parent_spines;
372: BEGIN
373: --
374: hr_utility.set_location('Entering:'||l_proc, 10);
375: --
376: hr_api.mandatory_arg_error
377: (p_api_name => l_proc,
378: p_argument => 'sequence',
379: p_argument_value => p_sequence);
380: --
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;
392:
460: BEGIN
461: --
462: hr_utility.set_location('Entering:'||l_proc, 10);
463: --
464: hr_api.mandatory_arg_error
465: (p_api_name => l_proc,
466: p_argument => 'spinal_point',
467: p_argument_value => p_spinal_point);
468: --
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;
480:
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) <>
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) <>
641: nvl(p_rec.information2, hr_api.g_varchar2) or
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) <>
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) <>
643: nvl(p_rec.information3, hr_api.g_varchar2) or
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) <>
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) <>
645: nvl(p_rec.information4, 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) <>
645: nvl(p_rec.information4, hr_api.g_varchar2) or
646: nvl(per_psp_shd.g_old_rec.information5, 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) <>
647: nvl(p_rec.information5, 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) <>
647: nvl(p_rec.information5, hr_api.g_varchar2) or
648: nvl(per_psp_shd.g_old_rec.information6, 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) <>
649: nvl(p_rec.information6, 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) <>
649: nvl(p_rec.information6, hr_api.g_varchar2) or
650: nvl(per_psp_shd.g_old_rec.information7, 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) <>
651: nvl(p_rec.information7, 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) <>
651: nvl(p_rec.information7, hr_api.g_varchar2) or
652: nvl(per_psp_shd.g_old_rec.information8, 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) <>
653: nvl(p_rec.information8, 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) <>
653: nvl(p_rec.information8, hr_api.g_varchar2) or
654: nvl(per_psp_shd.g_old_rec.information9, 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) <>
655: nvl(p_rec.information9, 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) <>
655: nvl(p_rec.information9, hr_api.g_varchar2) or
656: nvl(per_psp_shd.g_old_rec.information10, 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) <>
657: nvl(p_rec.information10, 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) <>
657: nvl(p_rec.information10, hr_api.g_varchar2) or
658: nvl(per_psp_shd.g_old_rec.information11, 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) <>
659: nvl(p_rec.information11, 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) <>
659: nvl(p_rec.information11, hr_api.g_varchar2) or
660: nvl(per_psp_shd.g_old_rec.information12, 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) <>
661: nvl(p_rec.information12, 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) <>
661: nvl(p_rec.information12, hr_api.g_varchar2) or
662: nvl(per_psp_shd.g_old_rec.information13, 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) <>
663: nvl(p_rec.information13, 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) <>
663: nvl(p_rec.information13, hr_api.g_varchar2) or
664: nvl(per_psp_shd.g_old_rec.information14, 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) <>
665: nvl(p_rec.information14, 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) <>
665: nvl(p_rec.information14, hr_api.g_varchar2) or
666: nvl(per_psp_shd.g_old_rec.information15, 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) <>
667: nvl(p_rec.information15, 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) <>
667: nvl(p_rec.information15, hr_api.g_varchar2) or
668: nvl(per_psp_shd.g_old_rec.information16, 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) <>
669: nvl(p_rec.information16, 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) <>
669: nvl(p_rec.information16, hr_api.g_varchar2) or
670: nvl(per_psp_shd.g_old_rec.information17, 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) <>
671: nvl(p_rec.information17, 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) <>
671: nvl(p_rec.information17, hr_api.g_varchar2) or
672: nvl(per_psp_shd.g_old_rec.information18, 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) <>
673: nvl(p_rec.information18, 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) <>
673: nvl(p_rec.information18, hr_api.g_varchar2) or
674: nvl(per_psp_shd.g_old_rec.information19, 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) <>
675: nvl(p_rec.information19, 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) <>
675: nvl(p_rec.information19, hr_api.g_varchar2) or
676: nvl(per_psp_shd.g_old_rec.information20, 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) <>
677: nvl(p_rec.information20, 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) <>
677: nvl(p_rec.information20, hr_api.g_varchar2) or
678: nvl(per_psp_shd.g_old_rec.information21, 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) <>
679: nvl(p_rec.information21, 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) <>
679: nvl(p_rec.information21, hr_api.g_varchar2) or
680: nvl(per_psp_shd.g_old_rec.information22, 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) <>
681: nvl(p_rec.information22, 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) <>
681: nvl(p_rec.information22, hr_api.g_varchar2) or
682: nvl(per_psp_shd.g_old_rec.information23, 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) <>
683: nvl(p_rec.information23, 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) <>
683: nvl(p_rec.information23, hr_api.g_varchar2) or
684: nvl(per_psp_shd.g_old_rec.information24, 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) <>
685: nvl(p_rec.information24, 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) <>
685: nvl(p_rec.information24, hr_api.g_varchar2) or
686: nvl(per_psp_shd.g_old_rec.information25, 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) <>
687: nvl(p_rec.information25, 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) <>
687: nvl(p_rec.information25, hr_api.g_varchar2) or
688: nvl(per_psp_shd.g_old_rec.information26, 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) <>
689: nvl(p_rec.information26, 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) <>
689: nvl(p_rec.information26, hr_api.g_varchar2) or
690: nvl(per_psp_shd.g_old_rec.information27, 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) <>
691: nvl(p_rec.information27, 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) <>
691: nvl(p_rec.information27, hr_api.g_varchar2) or
692: nvl(per_psp_shd.g_old_rec.information28, 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) <>
693: nvl(p_rec.information28, 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) <>
693: nvl(p_rec.information28, hr_api.g_varchar2) or
694: nvl(per_psp_shd.g_old_rec.information29, 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) <>
695: nvl(p_rec.information29, 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) <>
695: nvl(p_rec.information29, hr_api.g_varchar2) or
696: nvl(per_psp_shd.g_old_rec.information30, 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) <>
697: nvl(p_rec.information30, 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
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
699: --
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:
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:
701: -- a) During update, the structure column value or any
825: END IF;
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'
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
835: );
836: END IF;
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'
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
846: );
861: hr_utility.set_location('Entering:'||l_proc, 10);
862: --
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: --
946: hr_utility.set_location('Entering:'||l_proc, 10);
947: --
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: