APPS.PER_PSP_BUS dependencies on HR_API

Line 47: hr_api.mandatory_arg_error

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: );

Line 74: hr_api.set_security_group_id

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

Line 80: hr_api.set_legislation_context(l_legislation_code);

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: --

Line 116: hr_api.mandatory_arg_error

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: );

Line 122: if ( nvl(per_psp_bus.g_spinal_point_id, hr_api.g_number)

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

Line 207: and nvl(p_spinal_point_id,hr_api.g_number)

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: --

Line 289: hr_api.mandatory_arg_error

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: );

Line 305: hr_api.g_number) = nvl(p_parent_spine_id, hr_api.g_number)) then

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;

Line 376: hr_api.mandatory_arg_error

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: --

Line 388: hr_api.g_number) = nvl(p_sequence, hr_api.g_number)) then

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:

Line 464: hr_api.mandatory_arg_error

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: --

Line 476: hr_api.g_varchar2) = nvl(p_spinal_point, hr_api.g_varchar2)) then

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:

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 637: nvl(p_rec.information_category, hr_api.g_varchar2) or

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

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 639: nvl(p_rec.information1, hr_api.g_varchar2) or

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

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 641: nvl(p_rec.information2, hr_api.g_varchar2) or

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

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 643: nvl(p_rec.information3, hr_api.g_varchar2) or

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

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 645: nvl(p_rec.information4, hr_api.g_varchar2) or

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

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 647: nvl(p_rec.information5, hr_api.g_varchar2) or

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

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 649: nvl(p_rec.information6, hr_api.g_varchar2) or

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

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 651: nvl(p_rec.information7, hr_api.g_varchar2) or

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

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 653: nvl(p_rec.information8, hr_api.g_varchar2) or

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

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 655: nvl(p_rec.information9, hr_api.g_varchar2) or

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

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 657: nvl(p_rec.information10, hr_api.g_varchar2) or

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

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 659: nvl(p_rec.information11, hr_api.g_varchar2) or

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

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 661: nvl(p_rec.information12, hr_api.g_varchar2) or

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

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 663: nvl(p_rec.information13, hr_api.g_varchar2) or

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

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 665: nvl(p_rec.information14, hr_api.g_varchar2) or

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

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 667: nvl(p_rec.information15, hr_api.g_varchar2) or

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

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 669: nvl(p_rec.information16, hr_api.g_varchar2) or

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

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 671: nvl(p_rec.information17, hr_api.g_varchar2) or

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

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 673: nvl(p_rec.information18, hr_api.g_varchar2) or

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

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 675: nvl(p_rec.information19, hr_api.g_varchar2) or

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

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 677: nvl(p_rec.information20, hr_api.g_varchar2) or

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

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 679: nvl(p_rec.information21, hr_api.g_varchar2) or

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

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 681: nvl(p_rec.information22, hr_api.g_varchar2) or

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

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 683: nvl(p_rec.information23, hr_api.g_varchar2) or

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

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 685: nvl(p_rec.information24, hr_api.g_varchar2) or

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

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 687: nvl(p_rec.information25, hr_api.g_varchar2) or

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

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 689: nvl(p_rec.information26, hr_api.g_varchar2) or

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

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 691: nvl(p_rec.information27, hr_api.g_varchar2) or

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

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 693: nvl(p_rec.information28, hr_api.g_varchar2) or

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) ))

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 695: nvl(p_rec.information29, hr_api.g_varchar2) or

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: --

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 697: nvl(p_rec.information30, 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:
701: -- a) During update, the structure column value or any

Line 829: IF nvl(p_rec.business_group_id, hr_api.g_number) <>

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'

Line 831: hr_api.argument_changed_error

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: );

Line 840: IF nvl(p_rec.parent_spine_id, hr_api.g_number) <>

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'

Line 842: hr_api.argument_changed_error

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: );

Line 865: hr_api.validate_bus_grp_id

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: --

Line 950: hr_api.validate_bus_grp_id

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: