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_GRD_BUS dependencies on HR_API

Line 45: hr_api.mandatory_arg_error

41: hr_utility.set_location('Entering:'|| l_proc, 10);
42: --
43: -- Ensure that all the mandatory parameter are not null
44: --
45: hr_api.mandatory_arg_error
46: (p_api_name => l_proc
47: ,p_argument => 'grade_id'
48: ,p_argument_value => p_grade_id
49: );

Line 71: hr_api.set_security_group_id

67: close csr_sec_grp;
68: --
69: -- Set the security_group_id in CLIENT_INFO
70: --
71: hr_api.set_security_group_id
72: (p_security_group_id => l_security_group_id
73: );
74: end if;
75: --

Line 109: hr_api.mandatory_arg_error

105: hr_utility.set_location('Entering:'|| l_proc, 10);
106: --
107: -- Ensure that all the mandatory parameter are not null
108: --
109: hr_api.mandatory_arg_error
110: (p_api_name => l_proc
111: ,p_argument => 'grade_id'
112: ,p_argument_value => p_grade_id
113: );

Line 115: if ( nvl(per_grd_bus.g_grade_id, hr_api.g_number)

111: ,p_argument => 'grade_id'
112: ,p_argument_value => p_grade_id
113: );
114: --
115: if ( nvl(per_grd_bus.g_grade_id, hr_api.g_number)
116: = p_grade_id) then
117: --
118: -- The legislation code has already been found with a previous
119: -- call to this function. Just return the value in the global

Line 451: and nvl(p_grade_id,hr_api.g_number)

447: p_object_version_number => p_object_version_number
448: );
449: --
450: if (l_api_updating
451: and nvl(p_grade_id,hr_api.g_number)
452: <> per_grd_shd.g_old_rec.grade_id) then
453: --
454: -- raise error as PK has changed
455: --

Line 643: hr_api.mandatory_arg_error

639: hr_utility.set_location('Entering:'||l_proc, 1);
640: --
641: -- Check mandatory parameters have been set
642: --
643: hr_api.mandatory_arg_error
644: (p_api_name => l_proc
645: ,p_argument => 'grade_definition_id'
646: ,p_argument_value => p_grade_definition_id
647: );

Line 736: hr_api.mandatory_arg_error

732: --
733: -- Check mandatory parameters have been set
734: --
735:
736: hr_api.mandatory_arg_error
737: (p_api_name => l_proc
738: ,p_argument => 'date_from'
739: ,p_argument_value => p_date_from
740: );

Line 752: (nvl(per_grd_shd.g_old_rec.date_to,hr_api.g_eot) <>

748: (p_grade_id => p_grade_id
749: ,p_object_version_number => p_object_version_number);
750: --
751: if (((l_api_updating and
752: (nvl(per_grd_shd.g_old_rec.date_to,hr_api.g_eot) <>
753: nvl(p_date_to,hr_api.g_eot)) or
754: (per_grd_shd.g_old_rec.date_from <> p_date_from)) or
755: (NOT l_api_updating))) then
756: --

Line 753: nvl(p_date_to,hr_api.g_eot)) or

749: ,p_object_version_number => p_object_version_number);
750: --
751: if (((l_api_updating and
752: (nvl(per_grd_shd.g_old_rec.date_to,hr_api.g_eot) <>
753: nvl(p_date_to,hr_api.g_eot)) or
754: (per_grd_shd.g_old_rec.date_from <> p_date_from)) or
755: (NOT l_api_updating))) then
756: --
757: -- Check that date_from <= date_to

Line 761: if p_date_from > nvl(p_date_to,hr_api.g_eot) then

757: -- Check that date_from <= date_to
758: --
759: hr_utility.set_location(l_proc, 3);
760: --
761: if p_date_from > nvl(p_date_to,hr_api.g_eot) then
762: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
763: hr_utility.set_message_token('PROCEDURE', l_proc);
764: hr_utility.set_message_token('STEP', '3');
765: hr_utility.raise_error;

Line 822: hr_api.mandatory_arg_error

818: BEGIN
819: --
820: hr_utility.set_location('Entering:'||l_proc, 5);
821: --
822: hr_api.mandatory_arg_error
823: (p_api_name => l_proc,
824: p_argument => 'sequence',
825: p_argument_value => p_sequence);
826: --

Line 887: nvl(per_grd_shd.g_old_rec.information_category, hr_api.g_varchar2) <>

883: begin
884: hr_utility.set_location('Entering:'||l_proc,10);
885: --
886: if ((p_rec.grade_id is not null) and (
887: nvl(per_grd_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
888: nvl(p_rec.information_category, hr_api.g_varchar2) or
889: nvl(per_grd_shd.g_old_rec.information1, hr_api.g_varchar2) <>
890: nvl(p_rec.information1, hr_api.g_varchar2) or
891: nvl(per_grd_shd.g_old_rec.information2, hr_api.g_varchar2) <>

Line 888: nvl(p_rec.information_category, hr_api.g_varchar2) or

884: hr_utility.set_location('Entering:'||l_proc,10);
885: --
886: if ((p_rec.grade_id is not null) and (
887: nvl(per_grd_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
888: nvl(p_rec.information_category, hr_api.g_varchar2) or
889: nvl(per_grd_shd.g_old_rec.information1, hr_api.g_varchar2) <>
890: nvl(p_rec.information1, hr_api.g_varchar2) or
891: nvl(per_grd_shd.g_old_rec.information2, hr_api.g_varchar2) <>
892: nvl(p_rec.information2, hr_api.g_varchar2) or

Line 889: nvl(per_grd_shd.g_old_rec.information1, hr_api.g_varchar2) <>

885: --
886: if ((p_rec.grade_id is not null) and (
887: nvl(per_grd_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
888: nvl(p_rec.information_category, hr_api.g_varchar2) or
889: nvl(per_grd_shd.g_old_rec.information1, hr_api.g_varchar2) <>
890: nvl(p_rec.information1, hr_api.g_varchar2) or
891: nvl(per_grd_shd.g_old_rec.information2, hr_api.g_varchar2) <>
892: nvl(p_rec.information2, hr_api.g_varchar2) or
893: nvl(per_grd_shd.g_old_rec.information3, hr_api.g_varchar2) <>

Line 890: nvl(p_rec.information1, hr_api.g_varchar2) or

886: if ((p_rec.grade_id is not null) and (
887: nvl(per_grd_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
888: nvl(p_rec.information_category, hr_api.g_varchar2) or
889: nvl(per_grd_shd.g_old_rec.information1, hr_api.g_varchar2) <>
890: nvl(p_rec.information1, hr_api.g_varchar2) or
891: nvl(per_grd_shd.g_old_rec.information2, hr_api.g_varchar2) <>
892: nvl(p_rec.information2, hr_api.g_varchar2) or
893: nvl(per_grd_shd.g_old_rec.information3, hr_api.g_varchar2) <>
894: nvl(p_rec.information3, hr_api.g_varchar2) or

Line 891: nvl(per_grd_shd.g_old_rec.information2, hr_api.g_varchar2) <>

887: nvl(per_grd_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
888: nvl(p_rec.information_category, hr_api.g_varchar2) or
889: nvl(per_grd_shd.g_old_rec.information1, hr_api.g_varchar2) <>
890: nvl(p_rec.information1, hr_api.g_varchar2) or
891: nvl(per_grd_shd.g_old_rec.information2, hr_api.g_varchar2) <>
892: nvl(p_rec.information2, hr_api.g_varchar2) or
893: nvl(per_grd_shd.g_old_rec.information3, hr_api.g_varchar2) <>
894: nvl(p_rec.information3, hr_api.g_varchar2) or
895: nvl(per_grd_shd.g_old_rec.information4, hr_api.g_varchar2) <>

Line 892: nvl(p_rec.information2, hr_api.g_varchar2) or

888: nvl(p_rec.information_category, hr_api.g_varchar2) or
889: nvl(per_grd_shd.g_old_rec.information1, hr_api.g_varchar2) <>
890: nvl(p_rec.information1, hr_api.g_varchar2) or
891: nvl(per_grd_shd.g_old_rec.information2, hr_api.g_varchar2) <>
892: nvl(p_rec.information2, hr_api.g_varchar2) or
893: nvl(per_grd_shd.g_old_rec.information3, hr_api.g_varchar2) <>
894: nvl(p_rec.information3, hr_api.g_varchar2) or
895: nvl(per_grd_shd.g_old_rec.information4, hr_api.g_varchar2) <>
896: nvl(p_rec.information4, hr_api.g_varchar2) or

Line 893: nvl(per_grd_shd.g_old_rec.information3, hr_api.g_varchar2) <>

889: nvl(per_grd_shd.g_old_rec.information1, hr_api.g_varchar2) <>
890: nvl(p_rec.information1, hr_api.g_varchar2) or
891: nvl(per_grd_shd.g_old_rec.information2, hr_api.g_varchar2) <>
892: nvl(p_rec.information2, hr_api.g_varchar2) or
893: nvl(per_grd_shd.g_old_rec.information3, hr_api.g_varchar2) <>
894: nvl(p_rec.information3, hr_api.g_varchar2) or
895: nvl(per_grd_shd.g_old_rec.information4, hr_api.g_varchar2) <>
896: nvl(p_rec.information4, hr_api.g_varchar2) or
897: nvl(per_grd_shd.g_old_rec.information5, hr_api.g_varchar2) <>

Line 894: nvl(p_rec.information3, hr_api.g_varchar2) or

890: nvl(p_rec.information1, hr_api.g_varchar2) or
891: nvl(per_grd_shd.g_old_rec.information2, hr_api.g_varchar2) <>
892: nvl(p_rec.information2, hr_api.g_varchar2) or
893: nvl(per_grd_shd.g_old_rec.information3, hr_api.g_varchar2) <>
894: nvl(p_rec.information3, hr_api.g_varchar2) or
895: nvl(per_grd_shd.g_old_rec.information4, hr_api.g_varchar2) <>
896: nvl(p_rec.information4, hr_api.g_varchar2) or
897: nvl(per_grd_shd.g_old_rec.information5, hr_api.g_varchar2) <>
898: nvl(p_rec.information5, hr_api.g_varchar2) or

Line 895: nvl(per_grd_shd.g_old_rec.information4, hr_api.g_varchar2) <>

891: nvl(per_grd_shd.g_old_rec.information2, hr_api.g_varchar2) <>
892: nvl(p_rec.information2, hr_api.g_varchar2) or
893: nvl(per_grd_shd.g_old_rec.information3, hr_api.g_varchar2) <>
894: nvl(p_rec.information3, hr_api.g_varchar2) or
895: nvl(per_grd_shd.g_old_rec.information4, hr_api.g_varchar2) <>
896: nvl(p_rec.information4, hr_api.g_varchar2) or
897: nvl(per_grd_shd.g_old_rec.information5, hr_api.g_varchar2) <>
898: nvl(p_rec.information5, hr_api.g_varchar2) or
899: nvl(per_grd_shd.g_old_rec.information6, hr_api.g_varchar2) <>

Line 896: nvl(p_rec.information4, hr_api.g_varchar2) or

892: nvl(p_rec.information2, hr_api.g_varchar2) or
893: nvl(per_grd_shd.g_old_rec.information3, hr_api.g_varchar2) <>
894: nvl(p_rec.information3, hr_api.g_varchar2) or
895: nvl(per_grd_shd.g_old_rec.information4, hr_api.g_varchar2) <>
896: nvl(p_rec.information4, hr_api.g_varchar2) or
897: nvl(per_grd_shd.g_old_rec.information5, hr_api.g_varchar2) <>
898: nvl(p_rec.information5, hr_api.g_varchar2) or
899: nvl(per_grd_shd.g_old_rec.information6, hr_api.g_varchar2) <>
900: nvl(p_rec.information6, hr_api.g_varchar2) or

Line 897: nvl(per_grd_shd.g_old_rec.information5, hr_api.g_varchar2) <>

893: nvl(per_grd_shd.g_old_rec.information3, hr_api.g_varchar2) <>
894: nvl(p_rec.information3, hr_api.g_varchar2) or
895: nvl(per_grd_shd.g_old_rec.information4, hr_api.g_varchar2) <>
896: nvl(p_rec.information4, hr_api.g_varchar2) or
897: nvl(per_grd_shd.g_old_rec.information5, hr_api.g_varchar2) <>
898: nvl(p_rec.information5, hr_api.g_varchar2) or
899: nvl(per_grd_shd.g_old_rec.information6, hr_api.g_varchar2) <>
900: nvl(p_rec.information6, hr_api.g_varchar2) or
901: nvl(per_grd_shd.g_old_rec.information7, hr_api.g_varchar2) <>

Line 898: nvl(p_rec.information5, hr_api.g_varchar2) or

894: nvl(p_rec.information3, hr_api.g_varchar2) or
895: nvl(per_grd_shd.g_old_rec.information4, hr_api.g_varchar2) <>
896: nvl(p_rec.information4, hr_api.g_varchar2) or
897: nvl(per_grd_shd.g_old_rec.information5, hr_api.g_varchar2) <>
898: nvl(p_rec.information5, hr_api.g_varchar2) or
899: nvl(per_grd_shd.g_old_rec.information6, hr_api.g_varchar2) <>
900: nvl(p_rec.information6, hr_api.g_varchar2) or
901: nvl(per_grd_shd.g_old_rec.information7, hr_api.g_varchar2) <>
902: nvl(p_rec.information7, hr_api.g_varchar2) or

Line 899: nvl(per_grd_shd.g_old_rec.information6, hr_api.g_varchar2) <>

895: nvl(per_grd_shd.g_old_rec.information4, hr_api.g_varchar2) <>
896: nvl(p_rec.information4, hr_api.g_varchar2) or
897: nvl(per_grd_shd.g_old_rec.information5, hr_api.g_varchar2) <>
898: nvl(p_rec.information5, hr_api.g_varchar2) or
899: nvl(per_grd_shd.g_old_rec.information6, hr_api.g_varchar2) <>
900: nvl(p_rec.information6, hr_api.g_varchar2) or
901: nvl(per_grd_shd.g_old_rec.information7, hr_api.g_varchar2) <>
902: nvl(p_rec.information7, hr_api.g_varchar2) or
903: nvl(per_grd_shd.g_old_rec.information8, hr_api.g_varchar2) <>

Line 900: nvl(p_rec.information6, hr_api.g_varchar2) or

896: nvl(p_rec.information4, hr_api.g_varchar2) or
897: nvl(per_grd_shd.g_old_rec.information5, hr_api.g_varchar2) <>
898: nvl(p_rec.information5, hr_api.g_varchar2) or
899: nvl(per_grd_shd.g_old_rec.information6, hr_api.g_varchar2) <>
900: nvl(p_rec.information6, hr_api.g_varchar2) or
901: nvl(per_grd_shd.g_old_rec.information7, hr_api.g_varchar2) <>
902: nvl(p_rec.information7, hr_api.g_varchar2) or
903: nvl(per_grd_shd.g_old_rec.information8, hr_api.g_varchar2) <>
904: nvl(p_rec.information8, hr_api.g_varchar2) or

Line 901: nvl(per_grd_shd.g_old_rec.information7, hr_api.g_varchar2) <>

897: nvl(per_grd_shd.g_old_rec.information5, hr_api.g_varchar2) <>
898: nvl(p_rec.information5, hr_api.g_varchar2) or
899: nvl(per_grd_shd.g_old_rec.information6, hr_api.g_varchar2) <>
900: nvl(p_rec.information6, hr_api.g_varchar2) or
901: nvl(per_grd_shd.g_old_rec.information7, hr_api.g_varchar2) <>
902: nvl(p_rec.information7, hr_api.g_varchar2) or
903: nvl(per_grd_shd.g_old_rec.information8, hr_api.g_varchar2) <>
904: nvl(p_rec.information8, hr_api.g_varchar2) or
905: nvl(per_grd_shd.g_old_rec.information9, hr_api.g_varchar2) <>

Line 902: nvl(p_rec.information7, hr_api.g_varchar2) or

898: nvl(p_rec.information5, hr_api.g_varchar2) or
899: nvl(per_grd_shd.g_old_rec.information6, hr_api.g_varchar2) <>
900: nvl(p_rec.information6, hr_api.g_varchar2) or
901: nvl(per_grd_shd.g_old_rec.information7, hr_api.g_varchar2) <>
902: nvl(p_rec.information7, hr_api.g_varchar2) or
903: nvl(per_grd_shd.g_old_rec.information8, hr_api.g_varchar2) <>
904: nvl(p_rec.information8, hr_api.g_varchar2) or
905: nvl(per_grd_shd.g_old_rec.information9, hr_api.g_varchar2) <>
906: nvl(p_rec.information9, hr_api.g_varchar2) or

Line 903: nvl(per_grd_shd.g_old_rec.information8, hr_api.g_varchar2) <>

899: nvl(per_grd_shd.g_old_rec.information6, hr_api.g_varchar2) <>
900: nvl(p_rec.information6, hr_api.g_varchar2) or
901: nvl(per_grd_shd.g_old_rec.information7, hr_api.g_varchar2) <>
902: nvl(p_rec.information7, hr_api.g_varchar2) or
903: nvl(per_grd_shd.g_old_rec.information8, hr_api.g_varchar2) <>
904: nvl(p_rec.information8, hr_api.g_varchar2) or
905: nvl(per_grd_shd.g_old_rec.information9, hr_api.g_varchar2) <>
906: nvl(p_rec.information9, hr_api.g_varchar2) or
907: nvl(per_grd_shd.g_old_rec.information10, hr_api.g_varchar2) <>

Line 904: nvl(p_rec.information8, hr_api.g_varchar2) or

900: nvl(p_rec.information6, hr_api.g_varchar2) or
901: nvl(per_grd_shd.g_old_rec.information7, hr_api.g_varchar2) <>
902: nvl(p_rec.information7, hr_api.g_varchar2) or
903: nvl(per_grd_shd.g_old_rec.information8, hr_api.g_varchar2) <>
904: nvl(p_rec.information8, hr_api.g_varchar2) or
905: nvl(per_grd_shd.g_old_rec.information9, hr_api.g_varchar2) <>
906: nvl(p_rec.information9, hr_api.g_varchar2) or
907: nvl(per_grd_shd.g_old_rec.information10, hr_api.g_varchar2) <>
908: nvl(p_rec.information10, hr_api.g_varchar2) or

Line 905: nvl(per_grd_shd.g_old_rec.information9, hr_api.g_varchar2) <>

901: nvl(per_grd_shd.g_old_rec.information7, hr_api.g_varchar2) <>
902: nvl(p_rec.information7, hr_api.g_varchar2) or
903: nvl(per_grd_shd.g_old_rec.information8, hr_api.g_varchar2) <>
904: nvl(p_rec.information8, hr_api.g_varchar2) or
905: nvl(per_grd_shd.g_old_rec.information9, hr_api.g_varchar2) <>
906: nvl(p_rec.information9, hr_api.g_varchar2) or
907: nvl(per_grd_shd.g_old_rec.information10, hr_api.g_varchar2) <>
908: nvl(p_rec.information10, hr_api.g_varchar2) or
909: nvl(per_grd_shd.g_old_rec.information11, hr_api.g_varchar2) <>

Line 906: nvl(p_rec.information9, hr_api.g_varchar2) or

902: nvl(p_rec.information7, hr_api.g_varchar2) or
903: nvl(per_grd_shd.g_old_rec.information8, hr_api.g_varchar2) <>
904: nvl(p_rec.information8, hr_api.g_varchar2) or
905: nvl(per_grd_shd.g_old_rec.information9, hr_api.g_varchar2) <>
906: nvl(p_rec.information9, hr_api.g_varchar2) or
907: nvl(per_grd_shd.g_old_rec.information10, hr_api.g_varchar2) <>
908: nvl(p_rec.information10, hr_api.g_varchar2) or
909: nvl(per_grd_shd.g_old_rec.information11, hr_api.g_varchar2) <>
910: nvl(p_rec.information11, hr_api.g_varchar2) or

Line 907: nvl(per_grd_shd.g_old_rec.information10, hr_api.g_varchar2) <>

903: nvl(per_grd_shd.g_old_rec.information8, hr_api.g_varchar2) <>
904: nvl(p_rec.information8, hr_api.g_varchar2) or
905: nvl(per_grd_shd.g_old_rec.information9, hr_api.g_varchar2) <>
906: nvl(p_rec.information9, hr_api.g_varchar2) or
907: nvl(per_grd_shd.g_old_rec.information10, hr_api.g_varchar2) <>
908: nvl(p_rec.information10, hr_api.g_varchar2) or
909: nvl(per_grd_shd.g_old_rec.information11, hr_api.g_varchar2) <>
910: nvl(p_rec.information11, hr_api.g_varchar2) or
911: nvl(per_grd_shd.g_old_rec.information12, hr_api.g_varchar2) <>

Line 908: nvl(p_rec.information10, hr_api.g_varchar2) or

904: nvl(p_rec.information8, hr_api.g_varchar2) or
905: nvl(per_grd_shd.g_old_rec.information9, hr_api.g_varchar2) <>
906: nvl(p_rec.information9, hr_api.g_varchar2) or
907: nvl(per_grd_shd.g_old_rec.information10, hr_api.g_varchar2) <>
908: nvl(p_rec.information10, hr_api.g_varchar2) or
909: nvl(per_grd_shd.g_old_rec.information11, hr_api.g_varchar2) <>
910: nvl(p_rec.information11, hr_api.g_varchar2) or
911: nvl(per_grd_shd.g_old_rec.information12, hr_api.g_varchar2) <>
912: nvl(p_rec.information12, hr_api.g_varchar2) or

Line 909: nvl(per_grd_shd.g_old_rec.information11, hr_api.g_varchar2) <>

905: nvl(per_grd_shd.g_old_rec.information9, hr_api.g_varchar2) <>
906: nvl(p_rec.information9, hr_api.g_varchar2) or
907: nvl(per_grd_shd.g_old_rec.information10, hr_api.g_varchar2) <>
908: nvl(p_rec.information10, hr_api.g_varchar2) or
909: nvl(per_grd_shd.g_old_rec.information11, hr_api.g_varchar2) <>
910: nvl(p_rec.information11, hr_api.g_varchar2) or
911: nvl(per_grd_shd.g_old_rec.information12, hr_api.g_varchar2) <>
912: nvl(p_rec.information12, hr_api.g_varchar2) or
913: nvl(per_grd_shd.g_old_rec.information13, hr_api.g_varchar2) <>

Line 910: nvl(p_rec.information11, hr_api.g_varchar2) or

906: nvl(p_rec.information9, hr_api.g_varchar2) or
907: nvl(per_grd_shd.g_old_rec.information10, hr_api.g_varchar2) <>
908: nvl(p_rec.information10, hr_api.g_varchar2) or
909: nvl(per_grd_shd.g_old_rec.information11, hr_api.g_varchar2) <>
910: nvl(p_rec.information11, hr_api.g_varchar2) or
911: nvl(per_grd_shd.g_old_rec.information12, hr_api.g_varchar2) <>
912: nvl(p_rec.information12, hr_api.g_varchar2) or
913: nvl(per_grd_shd.g_old_rec.information13, hr_api.g_varchar2) <>
914: nvl(p_rec.information13, hr_api.g_varchar2) or

Line 911: nvl(per_grd_shd.g_old_rec.information12, hr_api.g_varchar2) <>

907: nvl(per_grd_shd.g_old_rec.information10, hr_api.g_varchar2) <>
908: nvl(p_rec.information10, hr_api.g_varchar2) or
909: nvl(per_grd_shd.g_old_rec.information11, hr_api.g_varchar2) <>
910: nvl(p_rec.information11, hr_api.g_varchar2) or
911: nvl(per_grd_shd.g_old_rec.information12, hr_api.g_varchar2) <>
912: nvl(p_rec.information12, hr_api.g_varchar2) or
913: nvl(per_grd_shd.g_old_rec.information13, hr_api.g_varchar2) <>
914: nvl(p_rec.information13, hr_api.g_varchar2) or
915: nvl(per_grd_shd.g_old_rec.information14, hr_api.g_varchar2) <>

Line 912: nvl(p_rec.information12, hr_api.g_varchar2) or

908: nvl(p_rec.information10, hr_api.g_varchar2) or
909: nvl(per_grd_shd.g_old_rec.information11, hr_api.g_varchar2) <>
910: nvl(p_rec.information11, hr_api.g_varchar2) or
911: nvl(per_grd_shd.g_old_rec.information12, hr_api.g_varchar2) <>
912: nvl(p_rec.information12, hr_api.g_varchar2) or
913: nvl(per_grd_shd.g_old_rec.information13, hr_api.g_varchar2) <>
914: nvl(p_rec.information13, hr_api.g_varchar2) or
915: nvl(per_grd_shd.g_old_rec.information14, hr_api.g_varchar2) <>
916: nvl(p_rec.information14, hr_api.g_varchar2) or

Line 913: nvl(per_grd_shd.g_old_rec.information13, hr_api.g_varchar2) <>

909: nvl(per_grd_shd.g_old_rec.information11, hr_api.g_varchar2) <>
910: nvl(p_rec.information11, hr_api.g_varchar2) or
911: nvl(per_grd_shd.g_old_rec.information12, hr_api.g_varchar2) <>
912: nvl(p_rec.information12, hr_api.g_varchar2) or
913: nvl(per_grd_shd.g_old_rec.information13, hr_api.g_varchar2) <>
914: nvl(p_rec.information13, hr_api.g_varchar2) or
915: nvl(per_grd_shd.g_old_rec.information14, hr_api.g_varchar2) <>
916: nvl(p_rec.information14, hr_api.g_varchar2) or
917: nvl(per_grd_shd.g_old_rec.information15, hr_api.g_varchar2) <>

Line 914: nvl(p_rec.information13, hr_api.g_varchar2) or

910: nvl(p_rec.information11, hr_api.g_varchar2) or
911: nvl(per_grd_shd.g_old_rec.information12, hr_api.g_varchar2) <>
912: nvl(p_rec.information12, hr_api.g_varchar2) or
913: nvl(per_grd_shd.g_old_rec.information13, hr_api.g_varchar2) <>
914: nvl(p_rec.information13, hr_api.g_varchar2) or
915: nvl(per_grd_shd.g_old_rec.information14, hr_api.g_varchar2) <>
916: nvl(p_rec.information14, hr_api.g_varchar2) or
917: nvl(per_grd_shd.g_old_rec.information15, hr_api.g_varchar2) <>
918: nvl(p_rec.information15, hr_api.g_varchar2) or

Line 915: nvl(per_grd_shd.g_old_rec.information14, hr_api.g_varchar2) <>

911: nvl(per_grd_shd.g_old_rec.information12, hr_api.g_varchar2) <>
912: nvl(p_rec.information12, hr_api.g_varchar2) or
913: nvl(per_grd_shd.g_old_rec.information13, hr_api.g_varchar2) <>
914: nvl(p_rec.information13, hr_api.g_varchar2) or
915: nvl(per_grd_shd.g_old_rec.information14, hr_api.g_varchar2) <>
916: nvl(p_rec.information14, hr_api.g_varchar2) or
917: nvl(per_grd_shd.g_old_rec.information15, hr_api.g_varchar2) <>
918: nvl(p_rec.information15, hr_api.g_varchar2) or
919: nvl(per_grd_shd.g_old_rec.information16, hr_api.g_varchar2) <>

Line 916: nvl(p_rec.information14, hr_api.g_varchar2) or

912: nvl(p_rec.information12, hr_api.g_varchar2) or
913: nvl(per_grd_shd.g_old_rec.information13, hr_api.g_varchar2) <>
914: nvl(p_rec.information13, hr_api.g_varchar2) or
915: nvl(per_grd_shd.g_old_rec.information14, hr_api.g_varchar2) <>
916: nvl(p_rec.information14, hr_api.g_varchar2) or
917: nvl(per_grd_shd.g_old_rec.information15, hr_api.g_varchar2) <>
918: nvl(p_rec.information15, hr_api.g_varchar2) or
919: nvl(per_grd_shd.g_old_rec.information16, hr_api.g_varchar2) <>
920: nvl(p_rec.information16, hr_api.g_varchar2) or

Line 917: nvl(per_grd_shd.g_old_rec.information15, hr_api.g_varchar2) <>

913: nvl(per_grd_shd.g_old_rec.information13, hr_api.g_varchar2) <>
914: nvl(p_rec.information13, hr_api.g_varchar2) or
915: nvl(per_grd_shd.g_old_rec.information14, hr_api.g_varchar2) <>
916: nvl(p_rec.information14, hr_api.g_varchar2) or
917: nvl(per_grd_shd.g_old_rec.information15, hr_api.g_varchar2) <>
918: nvl(p_rec.information15, hr_api.g_varchar2) or
919: nvl(per_grd_shd.g_old_rec.information16, hr_api.g_varchar2) <>
920: nvl(p_rec.information16, hr_api.g_varchar2) or
921: nvl(per_grd_shd.g_old_rec.information17, hr_api.g_varchar2) <>

Line 918: nvl(p_rec.information15, hr_api.g_varchar2) or

914: nvl(p_rec.information13, hr_api.g_varchar2) or
915: nvl(per_grd_shd.g_old_rec.information14, hr_api.g_varchar2) <>
916: nvl(p_rec.information14, hr_api.g_varchar2) or
917: nvl(per_grd_shd.g_old_rec.information15, hr_api.g_varchar2) <>
918: nvl(p_rec.information15, hr_api.g_varchar2) or
919: nvl(per_grd_shd.g_old_rec.information16, hr_api.g_varchar2) <>
920: nvl(p_rec.information16, hr_api.g_varchar2) or
921: nvl(per_grd_shd.g_old_rec.information17, hr_api.g_varchar2) <>
922: nvl(p_rec.information17, hr_api.g_varchar2) or

Line 919: nvl(per_grd_shd.g_old_rec.information16, hr_api.g_varchar2) <>

915: nvl(per_grd_shd.g_old_rec.information14, hr_api.g_varchar2) <>
916: nvl(p_rec.information14, hr_api.g_varchar2) or
917: nvl(per_grd_shd.g_old_rec.information15, hr_api.g_varchar2) <>
918: nvl(p_rec.information15, hr_api.g_varchar2) or
919: nvl(per_grd_shd.g_old_rec.information16, hr_api.g_varchar2) <>
920: nvl(p_rec.information16, hr_api.g_varchar2) or
921: nvl(per_grd_shd.g_old_rec.information17, hr_api.g_varchar2) <>
922: nvl(p_rec.information17, hr_api.g_varchar2) or
923: nvl(per_grd_shd.g_old_rec.information18, hr_api.g_varchar2) <>

Line 920: nvl(p_rec.information16, hr_api.g_varchar2) or

916: nvl(p_rec.information14, hr_api.g_varchar2) or
917: nvl(per_grd_shd.g_old_rec.information15, hr_api.g_varchar2) <>
918: nvl(p_rec.information15, hr_api.g_varchar2) or
919: nvl(per_grd_shd.g_old_rec.information16, hr_api.g_varchar2) <>
920: nvl(p_rec.information16, hr_api.g_varchar2) or
921: nvl(per_grd_shd.g_old_rec.information17, hr_api.g_varchar2) <>
922: nvl(p_rec.information17, hr_api.g_varchar2) or
923: nvl(per_grd_shd.g_old_rec.information18, hr_api.g_varchar2) <>
924: nvl(p_rec.information18, hr_api.g_varchar2) or

Line 921: nvl(per_grd_shd.g_old_rec.information17, hr_api.g_varchar2) <>

917: nvl(per_grd_shd.g_old_rec.information15, hr_api.g_varchar2) <>
918: nvl(p_rec.information15, hr_api.g_varchar2) or
919: nvl(per_grd_shd.g_old_rec.information16, hr_api.g_varchar2) <>
920: nvl(p_rec.information16, hr_api.g_varchar2) or
921: nvl(per_grd_shd.g_old_rec.information17, hr_api.g_varchar2) <>
922: nvl(p_rec.information17, hr_api.g_varchar2) or
923: nvl(per_grd_shd.g_old_rec.information18, hr_api.g_varchar2) <>
924: nvl(p_rec.information18, hr_api.g_varchar2) or
925: nvl(per_grd_shd.g_old_rec.information19, hr_api.g_varchar2) <>

Line 922: nvl(p_rec.information17, hr_api.g_varchar2) or

918: nvl(p_rec.information15, hr_api.g_varchar2) or
919: nvl(per_grd_shd.g_old_rec.information16, hr_api.g_varchar2) <>
920: nvl(p_rec.information16, hr_api.g_varchar2) or
921: nvl(per_grd_shd.g_old_rec.information17, hr_api.g_varchar2) <>
922: nvl(p_rec.information17, hr_api.g_varchar2) or
923: nvl(per_grd_shd.g_old_rec.information18, hr_api.g_varchar2) <>
924: nvl(p_rec.information18, hr_api.g_varchar2) or
925: nvl(per_grd_shd.g_old_rec.information19, hr_api.g_varchar2) <>
926: nvl(p_rec.information19, hr_api.g_varchar2) or

Line 923: nvl(per_grd_shd.g_old_rec.information18, hr_api.g_varchar2) <>

919: nvl(per_grd_shd.g_old_rec.information16, hr_api.g_varchar2) <>
920: nvl(p_rec.information16, hr_api.g_varchar2) or
921: nvl(per_grd_shd.g_old_rec.information17, hr_api.g_varchar2) <>
922: nvl(p_rec.information17, hr_api.g_varchar2) or
923: nvl(per_grd_shd.g_old_rec.information18, hr_api.g_varchar2) <>
924: nvl(p_rec.information18, hr_api.g_varchar2) or
925: nvl(per_grd_shd.g_old_rec.information19, hr_api.g_varchar2) <>
926: nvl(p_rec.information19, hr_api.g_varchar2) or
927: nvl(per_grd_shd.g_old_rec.information20, hr_api.g_varchar2) <>

Line 924: nvl(p_rec.information18, hr_api.g_varchar2) or

920: nvl(p_rec.information16, hr_api.g_varchar2) or
921: nvl(per_grd_shd.g_old_rec.information17, hr_api.g_varchar2) <>
922: nvl(p_rec.information17, hr_api.g_varchar2) or
923: nvl(per_grd_shd.g_old_rec.information18, hr_api.g_varchar2) <>
924: nvl(p_rec.information18, hr_api.g_varchar2) or
925: nvl(per_grd_shd.g_old_rec.information19, hr_api.g_varchar2) <>
926: nvl(p_rec.information19, hr_api.g_varchar2) or
927: nvl(per_grd_shd.g_old_rec.information20, hr_api.g_varchar2) <>
928: nvl(p_rec.information20, hr_api.g_varchar2) ))

Line 925: nvl(per_grd_shd.g_old_rec.information19, hr_api.g_varchar2) <>

921: nvl(per_grd_shd.g_old_rec.information17, hr_api.g_varchar2) <>
922: nvl(p_rec.information17, hr_api.g_varchar2) or
923: nvl(per_grd_shd.g_old_rec.information18, hr_api.g_varchar2) <>
924: nvl(p_rec.information18, hr_api.g_varchar2) or
925: nvl(per_grd_shd.g_old_rec.information19, hr_api.g_varchar2) <>
926: nvl(p_rec.information19, hr_api.g_varchar2) or
927: nvl(per_grd_shd.g_old_rec.information20, hr_api.g_varchar2) <>
928: nvl(p_rec.information20, hr_api.g_varchar2) ))
929: or (p_rec.grade_id is null) then

Line 926: nvl(p_rec.information19, hr_api.g_varchar2) or

922: nvl(p_rec.information17, hr_api.g_varchar2) or
923: nvl(per_grd_shd.g_old_rec.information18, hr_api.g_varchar2) <>
924: nvl(p_rec.information18, hr_api.g_varchar2) or
925: nvl(per_grd_shd.g_old_rec.information19, hr_api.g_varchar2) <>
926: nvl(p_rec.information19, hr_api.g_varchar2) or
927: nvl(per_grd_shd.g_old_rec.information20, hr_api.g_varchar2) <>
928: nvl(p_rec.information20, hr_api.g_varchar2) ))
929: or (p_rec.grade_id is null) then
930: --

Line 927: nvl(per_grd_shd.g_old_rec.information20, hr_api.g_varchar2) <>

923: nvl(per_grd_shd.g_old_rec.information18, hr_api.g_varchar2) <>
924: nvl(p_rec.information18, hr_api.g_varchar2) or
925: nvl(per_grd_shd.g_old_rec.information19, hr_api.g_varchar2) <>
926: nvl(p_rec.information19, hr_api.g_varchar2) or
927: nvl(per_grd_shd.g_old_rec.information20, hr_api.g_varchar2) <>
928: nvl(p_rec.information20, hr_api.g_varchar2) ))
929: or (p_rec.grade_id is null) then
930: --
931: -- Only execute the validation if absolutely necessary:

Line 928: nvl(p_rec.information20, hr_api.g_varchar2) ))

924: nvl(p_rec.information18, hr_api.g_varchar2) or
925: nvl(per_grd_shd.g_old_rec.information19, hr_api.g_varchar2) <>
926: nvl(p_rec.information19, hr_api.g_varchar2) or
927: nvl(per_grd_shd.g_old_rec.information20, hr_api.g_varchar2) <>
928: nvl(p_rec.information20, hr_api.g_varchar2) ))
929: or (p_rec.grade_id is null) then
930: --
931: -- Only execute the validation if absolutely necessary:
932: -- a) During update, the structure column value or any

Line 1024: nvl(per_grd_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

1020: begin
1021: hr_utility.set_location('Entering:'||l_proc,10);
1022: --
1023: if ((p_rec.grade_id is not null) and (
1024: nvl(per_grd_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1025: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1026: nvl(per_grd_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1027: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1028: nvl(per_grd_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

Line 1025: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

1021: hr_utility.set_location('Entering:'||l_proc,10);
1022: --
1023: if ((p_rec.grade_id is not null) and (
1024: nvl(per_grd_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1025: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1026: nvl(per_grd_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1027: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1028: nvl(per_grd_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1029: nvl(p_rec.attribute2, hr_api.g_varchar2) or

Line 1026: nvl(per_grd_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

1022: --
1023: if ((p_rec.grade_id is not null) and (
1024: nvl(per_grd_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1025: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1026: nvl(per_grd_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1027: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1028: nvl(per_grd_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1029: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1030: nvl(per_grd_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

Line 1027: nvl(p_rec.attribute1, hr_api.g_varchar2) or

1023: if ((p_rec.grade_id is not null) and (
1024: nvl(per_grd_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1025: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1026: nvl(per_grd_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1027: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1028: nvl(per_grd_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1029: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1030: nvl(per_grd_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1031: nvl(p_rec.attribute3, hr_api.g_varchar2) or

Line 1028: nvl(per_grd_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

1024: nvl(per_grd_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1025: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1026: nvl(per_grd_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1027: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1028: nvl(per_grd_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1029: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1030: nvl(per_grd_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1031: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1032: nvl(per_grd_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

Line 1029: nvl(p_rec.attribute2, hr_api.g_varchar2) or

1025: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1026: nvl(per_grd_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1027: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1028: nvl(per_grd_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1029: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1030: nvl(per_grd_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1031: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1032: nvl(per_grd_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1033: nvl(p_rec.attribute4, hr_api.g_varchar2) or

Line 1030: nvl(per_grd_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

1026: nvl(per_grd_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1027: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1028: nvl(per_grd_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1029: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1030: nvl(per_grd_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1031: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1032: nvl(per_grd_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1033: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1034: nvl(per_grd_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

Line 1031: nvl(p_rec.attribute3, hr_api.g_varchar2) or

1027: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1028: nvl(per_grd_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1029: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1030: nvl(per_grd_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1031: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1032: nvl(per_grd_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1033: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1034: nvl(per_grd_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1035: nvl(p_rec.attribute5, hr_api.g_varchar2) or

Line 1032: nvl(per_grd_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

1028: nvl(per_grd_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1029: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1030: nvl(per_grd_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1031: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1032: nvl(per_grd_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1033: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1034: nvl(per_grd_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1035: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1036: nvl(per_grd_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

Line 1033: nvl(p_rec.attribute4, hr_api.g_varchar2) or

1029: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1030: nvl(per_grd_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1031: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1032: nvl(per_grd_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1033: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1034: nvl(per_grd_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1035: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1036: nvl(per_grd_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1037: nvl(p_rec.attribute6, hr_api.g_varchar2) or

Line 1034: nvl(per_grd_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

1030: nvl(per_grd_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1031: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1032: nvl(per_grd_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1033: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1034: nvl(per_grd_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1035: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1036: nvl(per_grd_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1037: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1038: nvl(per_grd_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

Line 1035: nvl(p_rec.attribute5, hr_api.g_varchar2) or

1031: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1032: nvl(per_grd_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1033: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1034: nvl(per_grd_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1035: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1036: nvl(per_grd_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1037: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1038: nvl(per_grd_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1039: nvl(p_rec.attribute7, hr_api.g_varchar2) or

Line 1036: nvl(per_grd_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

1032: nvl(per_grd_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1033: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1034: nvl(per_grd_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1035: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1036: nvl(per_grd_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1037: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1038: nvl(per_grd_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1039: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1040: nvl(per_grd_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

Line 1037: nvl(p_rec.attribute6, hr_api.g_varchar2) or

1033: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1034: nvl(per_grd_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1035: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1036: nvl(per_grd_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1037: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1038: nvl(per_grd_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1039: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1040: nvl(per_grd_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1041: nvl(p_rec.attribute8, hr_api.g_varchar2) or

Line 1038: nvl(per_grd_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

1034: nvl(per_grd_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1035: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1036: nvl(per_grd_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1037: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1038: nvl(per_grd_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1039: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1040: nvl(per_grd_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1041: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1042: nvl(per_grd_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

Line 1039: nvl(p_rec.attribute7, hr_api.g_varchar2) or

1035: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1036: nvl(per_grd_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1037: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1038: nvl(per_grd_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1039: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1040: nvl(per_grd_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1041: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1042: nvl(per_grd_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1043: nvl(p_rec.attribute9, hr_api.g_varchar2) or

Line 1040: nvl(per_grd_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

1036: nvl(per_grd_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1037: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1038: nvl(per_grd_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1039: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1040: nvl(per_grd_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1041: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1042: nvl(per_grd_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1043: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1044: nvl(per_grd_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

Line 1041: nvl(p_rec.attribute8, hr_api.g_varchar2) or

1037: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1038: nvl(per_grd_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1039: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1040: nvl(per_grd_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1041: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1042: nvl(per_grd_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1043: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1044: nvl(per_grd_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1045: nvl(p_rec.attribute10, hr_api.g_varchar2) or

Line 1042: nvl(per_grd_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

1038: nvl(per_grd_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1039: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1040: nvl(per_grd_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1041: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1042: nvl(per_grd_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1043: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1044: nvl(per_grd_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1045: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1046: nvl(per_grd_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

Line 1043: nvl(p_rec.attribute9, hr_api.g_varchar2) or

1039: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1040: nvl(per_grd_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1041: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1042: nvl(per_grd_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1043: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1044: nvl(per_grd_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1045: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1046: nvl(per_grd_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1047: nvl(p_rec.attribute11, hr_api.g_varchar2) or

Line 1044: nvl(per_grd_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

1040: nvl(per_grd_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1041: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1042: nvl(per_grd_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1043: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1044: nvl(per_grd_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1045: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1046: nvl(per_grd_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1047: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1048: nvl(per_grd_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

Line 1045: nvl(p_rec.attribute10, hr_api.g_varchar2) or

1041: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1042: nvl(per_grd_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1043: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1044: nvl(per_grd_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1045: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1046: nvl(per_grd_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1047: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1048: nvl(per_grd_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1049: nvl(p_rec.attribute12, hr_api.g_varchar2) or

Line 1046: nvl(per_grd_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

1042: nvl(per_grd_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1043: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1044: nvl(per_grd_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1045: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1046: nvl(per_grd_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1047: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1048: nvl(per_grd_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1049: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1050: nvl(per_grd_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

Line 1047: nvl(p_rec.attribute11, hr_api.g_varchar2) or

1043: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1044: nvl(per_grd_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1045: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1046: nvl(per_grd_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1047: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1048: nvl(per_grd_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1049: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1050: nvl(per_grd_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1051: nvl(p_rec.attribute13, hr_api.g_varchar2) or

Line 1048: nvl(per_grd_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

1044: nvl(per_grd_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1045: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1046: nvl(per_grd_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1047: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1048: nvl(per_grd_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1049: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1050: nvl(per_grd_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1051: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1052: nvl(per_grd_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

Line 1049: nvl(p_rec.attribute12, hr_api.g_varchar2) or

1045: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1046: nvl(per_grd_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1047: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1048: nvl(per_grd_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1049: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1050: nvl(per_grd_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1051: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1052: nvl(per_grd_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1053: nvl(p_rec.attribute14, hr_api.g_varchar2) or

Line 1050: nvl(per_grd_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

1046: nvl(per_grd_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1047: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1048: nvl(per_grd_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1049: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1050: nvl(per_grd_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1051: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1052: nvl(per_grd_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1053: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1054: nvl(per_grd_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

Line 1051: nvl(p_rec.attribute13, hr_api.g_varchar2) or

1047: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1048: nvl(per_grd_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1049: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1050: nvl(per_grd_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1051: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1052: nvl(per_grd_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1053: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1054: nvl(per_grd_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1055: nvl(p_rec.attribute15, hr_api.g_varchar2) or

Line 1052: nvl(per_grd_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

1048: nvl(per_grd_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1049: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1050: nvl(per_grd_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1051: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1052: nvl(per_grd_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1053: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1054: nvl(per_grd_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1055: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1056: nvl(per_grd_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

Line 1053: nvl(p_rec.attribute14, hr_api.g_varchar2) or

1049: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1050: nvl(per_grd_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1051: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1052: nvl(per_grd_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1053: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1054: nvl(per_grd_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1055: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1056: nvl(per_grd_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1057: nvl(p_rec.attribute16, hr_api.g_varchar2) or

Line 1054: nvl(per_grd_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

1050: nvl(per_grd_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1051: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1052: nvl(per_grd_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1053: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1054: nvl(per_grd_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1055: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1056: nvl(per_grd_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1057: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1058: nvl(per_grd_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

Line 1055: nvl(p_rec.attribute15, hr_api.g_varchar2) or

1051: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1052: nvl(per_grd_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1053: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1054: nvl(per_grd_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1055: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1056: nvl(per_grd_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1057: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1058: nvl(per_grd_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1059: nvl(p_rec.attribute17, hr_api.g_varchar2) or

Line 1056: nvl(per_grd_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

1052: nvl(per_grd_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1053: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1054: nvl(per_grd_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1055: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1056: nvl(per_grd_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1057: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1058: nvl(per_grd_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1059: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1060: nvl(per_grd_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

Line 1057: nvl(p_rec.attribute16, hr_api.g_varchar2) or

1053: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1054: nvl(per_grd_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1055: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1056: nvl(per_grd_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1057: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1058: nvl(per_grd_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1059: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1060: nvl(per_grd_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1061: nvl(p_rec.attribute18, hr_api.g_varchar2) or

Line 1058: nvl(per_grd_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

1054: nvl(per_grd_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1055: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1056: nvl(per_grd_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1057: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1058: nvl(per_grd_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1059: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1060: nvl(per_grd_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1061: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1062: nvl(per_grd_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

Line 1059: nvl(p_rec.attribute17, hr_api.g_varchar2) or

1055: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1056: nvl(per_grd_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1057: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1058: nvl(per_grd_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1059: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1060: nvl(per_grd_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1061: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1062: nvl(per_grd_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1063: nvl(p_rec.attribute19, hr_api.g_varchar2) or

Line 1060: nvl(per_grd_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

1056: nvl(per_grd_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1057: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1058: nvl(per_grd_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1059: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1060: nvl(per_grd_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1061: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1062: nvl(per_grd_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1063: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1064: nvl(per_grd_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

Line 1061: nvl(p_rec.attribute18, hr_api.g_varchar2) or

1057: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1058: nvl(per_grd_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1059: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1060: nvl(per_grd_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1061: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1062: nvl(per_grd_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1063: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1064: nvl(per_grd_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1065: nvl(p_rec.attribute20, hr_api.g_varchar2) ))

Line 1062: nvl(per_grd_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

1058: nvl(per_grd_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1059: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1060: nvl(per_grd_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1061: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1062: nvl(per_grd_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1063: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1064: nvl(per_grd_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1065: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
1066: or (p_rec.grade_id is null) then

Line 1063: nvl(p_rec.attribute19, hr_api.g_varchar2) or

1059: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1060: nvl(per_grd_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1061: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1062: nvl(per_grd_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1063: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1064: nvl(per_grd_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1065: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
1066: or (p_rec.grade_id is null) then
1067: --

Line 1064: nvl(per_grd_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

1060: nvl(per_grd_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1061: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1062: nvl(per_grd_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1063: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1064: nvl(per_grd_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1065: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
1066: or (p_rec.grade_id is null) then
1067: --
1068: -- Only execute the validation if absolutely necessary:

Line 1065: nvl(p_rec.attribute20, hr_api.g_varchar2) ))

1061: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1062: nvl(per_grd_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1063: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1064: nvl(per_grd_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1065: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
1066: or (p_rec.grade_id is null) then
1067: --
1068: -- Only execute the validation if absolutely necessary:
1069: -- a) During update, the structure column value or any

Line 1192: hr_api.validate_bus_grp_id

1188: hr_utility.set_location('Entering:'||l_proc, 5);
1189: --
1190: -- Call all supporting business operations
1191: --
1192: hr_api.validate_bus_grp_id
1193: (p_business_group_id => p_rec.business_group_id
1194: ,p_associated_column1 => per_grd_shd.g_tab_nam
1195: || '.BUSINESS_GROUP_ID');
1196: --

Line 1271: -- hr_api.validate_bus_grp_id

1267: hr_utility.set_location('Entering:'||l_proc, 5);
1268: --
1269: -- Call all supporting business operations
1270: --
1271: -- hr_api.validate_bus_grp_id
1272: -- (p_business_group_id => p_rec.business_group_id
1273: -- ,p_associated_column1 => per_grd_shd.g_tab_nam
1274: -- || '.BUSINESS_GROUP_ID');
1275: --