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 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 => 'step_id'
50: ,p_argument_value => p_step_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 => 'step_id'
119: ,p_argument_value => p_step_id
120: );

Line 122: if ( nvl(per_sps_bus.g_step_id, hr_api.g_number)

118: ,p_argument => 'step_id'
119: ,p_argument_value => p_step_id
120: );
121: --
122: if ( nvl(per_sps_bus.g_step_id, hr_api.g_number)
123: = p_step_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 210: and nvl(p_step_id,hr_api.g_number)

206: ,p_object_version_number => p_object_version_number
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: --

Line 320: hr_api.mandatory_arg_error

316: hr_utility.set_location('Entering:'|| l_proc, 10);
317: --
318: -- Check mandatory parameters have been set
319: --
320: hr_api.mandatory_arg_error
321: (p_api_name => l_proc
322: ,p_argument => 'spinal_point_id'
323: ,p_argument_value => p_spinal_point_id
324: );

Line 337: hr_api.g_number) = nvl(p_spinal_point_id, hr_api.g_number)) then

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:
341: hr_utility.set_location(l_proc, 20);

Line 436: hr_api.mandatory_arg_error

432: hr_utility.set_location('Entering:'|| l_proc, 10);
433: --
434: -- Check mandatory parameters have been set
435: --
436: hr_api.mandatory_arg_error
437: (p_api_name => l_proc
438: ,p_argument => 'grade_spine_id'
439: ,p_argument_value => p_grade_spine_id
440: );

Line 453: hr_api.g_number) = nvl(p_grade_spine_id, hr_api.g_number)) then

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:
457: hr_utility.set_location(l_proc, 20);

Line 531: hr_api.mandatory_arg_error

527: hr_utility.set_location('Entering:'|| l_proc, 10);
528: --
529: -- Check mandatory parameters have been set
530: --
531: hr_api.mandatory_arg_error
532: (p_api_name => l_proc
533: ,p_argument => 'sequence'
534: ,p_argument_value => p_sequence
535: );

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

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:
552: hr_utility.set_location(l_proc, 20);

Line 624: and step_id <> nvl(p_step_id,hr_api.g_number)

620: (select null
621: from per_spinal_point_steps_f
622: where grade_spine_id = p_grade_spine_id
623: and spinal_point_id = p_spinal_point_id
624: and step_id <> nvl(p_step_id,hr_api.g_number)
625: and p_effective_date between effective_start_date
626: and effective_end_date);
627: --
628: begin

Line 643: hr_api.g_number) = nvl(p_spinal_point_id, hr_api.g_number)

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
647: return;

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 645: = nvl(p_grade_spine_id, hr_api.g_number)

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;
649: hr_utility.set_location(l_proc, 20);

Line 766: if p_datetrack_mode = hr_api.g_delete then

762: hr_utility.set_location('Entering:'||l_proc, 10);
763: --
764: -- Needs to be checked the existence of child records
765: -- based on the DT mode
766: if p_datetrack_mode = hr_api.g_delete then
767: l_date := p_effective_date;
768: else
769: l_date := hr_api.g_eot;
770: end if;

Line 769: l_date := hr_api.g_eot;

765: -- based on the DT mode
766: if p_datetrack_mode = hr_api.g_delete then
767: l_date := p_effective_date;
768: else
769: l_date := hr_api.g_eot;
770: end if;
771: -- Check on per_spinal_point_placements_f
772: open csr_spinal_point(l_date);
773: fetch csr_spinal_point into l_exists1;

Line 805: if ( not p_called_from_del_grd_scale ) and (p_datetrack_mode = hr_api.g_zap ) then

801:
802: select grade_spine_id into l_grade_spine_id
803: from per_spinal_point_steps_f where step_id=p_step_id;
804:
805: if ( not p_called_from_del_grd_scale ) and (p_datetrack_mode = hr_api.g_zap ) then
806: open csr_ceiling_chk;
807: fetch csr_ceiling_chk into l_ceil_id;
808: close csr_ceiling_chk;
809: if l_ceil_id = 'X' then

Line 816: if ( not p_called_from_del_grd_scale ) and (p_datetrack_mode = hr_api.g_delete ) then

812: hr_utility.raise_error;
813: end if;
814: end if;
815: l_ceil_id :=Null;
816: if ( not p_called_from_del_grd_scale ) and (p_datetrack_mode = hr_api.g_delete ) then
817: open csr_ceiling_chk2;
818: fetch csr_ceiling_chk2 into l_ceil_id;
819: close csr_ceiling_chk2;
820: if l_ceil_id = 'X' then

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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) <>
934: nvl(p_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 932: nvl(p_rec.information30, hr_api.g_varchar2) or

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

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

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

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

Line 1067: hr_api.argument_changed_error

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

Line 1077: IF nvl(p_rec.spinal_point_id, hr_api.g_number) <>

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

Line 1079: hr_api.argument_changed_error

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

Line 1089: IF nvl(p_rec.grade_spine_id, hr_api.g_number) <>

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

Line 1091: hr_api.argument_changed_error

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

Line 1101: IF nvl(p_rec.sequence, hr_api.g_number) <>

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

Line 1103: hr_api.argument_changed_error

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

Line 1142: (p_grade_spine_id in number default hr_api.g_number

1138: --
1139: -- {End Of Comments}
1140: -- ----------------------------------------------------------------------------
1141: Procedure dt_update_validate
1142: (p_grade_spine_id in number default hr_api.g_number
1143: ,p_datetrack_mode in varchar2
1144: ,p_validation_start_date in date
1145: ,p_validation_end_date in date
1146: ) Is

Line 1154: hr_api.mandatory_arg_error

1150: Begin
1151: --
1152: -- Ensure that the p_datetrack_mode argument is not null
1153: --
1154: hr_api.mandatory_arg_error
1155: (p_api_name => l_proc
1156: ,p_argument => 'datetrack_mode'
1157: ,p_argument_value => p_datetrack_mode
1158: );

Line 1164: hr_api.mandatory_arg_error

1160: -- Mode will be valid, as this is checked at the start of the upd.
1161: --
1162: -- Ensure the arguments are not null
1163: --
1164: hr_api.mandatory_arg_error
1165: (p_api_name => l_proc
1166: ,p_argument => 'validation_start_date'
1167: ,p_argument_value => p_validation_start_date
1168: );

Line 1170: hr_api.mandatory_arg_error

1166: ,p_argument => 'validation_start_date'
1167: ,p_argument_value => p_validation_start_date
1168: );
1169: --
1170: hr_api.mandatory_arg_error
1171: (p_api_name => l_proc
1172: ,p_argument => 'validation_end_date'
1173: ,p_argument_value => p_validation_end_date
1174: );

Line 1176: If ((nvl(p_grade_spine_id, hr_api.g_number) <> hr_api.g_number) and

1172: ,p_argument => 'validation_end_date'
1173: ,p_argument_value => p_validation_end_date
1174: );
1175: --
1176: If ((nvl(p_grade_spine_id, hr_api.g_number) <> hr_api.g_number) and
1177: NOT (dt_api.check_min_max_dates
1178: (p_base_table_name => 'per_grade_spines_f'
1179: ,p_base_key_column => 'GRADE_SPINE_ID'
1180: ,p_base_key_value => p_grade_spine_id

Line 1252: hr_api.mandatory_arg_error

1248: hr_utility.trace('p_datetrack_mode : ' || p_datetrack_mode);
1249: --
1250: -- Ensure that the p_datetrack_mode argument is not null
1251: --
1252: hr_api.mandatory_arg_error
1253: (p_api_name => l_proc
1254: ,p_argument => 'datetrack_mode'
1255: ,p_argument_value => p_datetrack_mode
1256: );

Line 1261: If (p_datetrack_mode = hr_api.g_delete or

1257: --
1258: -- Only perform the validation if the datetrack mode is either
1259: -- DELETE or ZAP
1260: --
1261: If (p_datetrack_mode = hr_api.g_delete or
1262: p_datetrack_mode = hr_api.g_zap) then
1263: --
1264: --
1265: -- Ensure the arguments are not null

Line 1262: p_datetrack_mode = hr_api.g_zap) then

1258: -- Only perform the validation if the datetrack mode is either
1259: -- DELETE or ZAP
1260: --
1261: If (p_datetrack_mode = hr_api.g_delete or
1262: p_datetrack_mode = hr_api.g_zap) then
1263: --
1264: --
1265: -- Ensure the arguments are not null
1266: --

Line 1267: hr_api.mandatory_arg_error

1263: --
1264: --
1265: -- Ensure the arguments are not null
1266: --
1267: hr_api.mandatory_arg_error
1268: (p_api_name => l_proc
1269: ,p_argument => 'validation_start_date'
1270: ,p_argument_value => p_validation_start_date
1271: );

Line 1273: hr_api.mandatory_arg_error

1269: ,p_argument => 'validation_start_date'
1270: ,p_argument_value => p_validation_start_date
1271: );
1272: --
1273: hr_api.mandatory_arg_error
1274: (p_api_name => l_proc
1275: ,p_argument => 'validation_end_date'
1276: ,p_argument_value => p_validation_end_date
1277: );

Line 1279: hr_api.mandatory_arg_error

1275: ,p_argument => 'validation_end_date'
1276: ,p_argument_value => p_validation_end_date
1277: );
1278: --
1279: hr_api.mandatory_arg_error
1280: (p_api_name => l_proc
1281: ,p_argument => 'step_id'
1282: ,p_argument_value => p_step_id
1283: );

Line 1348: hr_api.validate_bus_grp_id

1344: hr_utility.set_location('Entering:'||l_proc, 10);
1345: --
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:

Line 1451: hr_api.validate_bus_grp_id

1447: hr_utility.set_location('Entering:'||l_proc, 10);
1448: --
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: