91: hr_utility.set_location('Entering:'|| l_proc,10);
92: --
93: -- Ensure that all the mandatory parameter are not null
94: --
95: hr_api.mandatory_arg_error
96: (p_api_name => l_proc
97: ,p_argument => 'role_id'
98: ,p_argument_value => p_role_id
99: );
114: close csr_sec_grp;
115: --
116: -- Set the security_group_id in CLIENT_INFO
117: --
118: hr_api.set_security_group_id
119: (p_security_group_id => l_security_group_id
120: );
121: --
122: hr_utility.set_location(' Leaving:'|| l_proc,20);
152: hr_utility.set_location('Entering:'|| l_proc,10);
153: --
154: -- Ensure that all the mandatory parameter are not null
155: --
156: hr_api.mandatory_arg_error
157: (p_api_name => l_proc
158: ,p_argument => 'role_id'
159: ,p_argument_value => p_role_id
160: );
158: ,p_argument => 'role_id'
159: ,p_argument_value => p_role_id
160: );
161: --
162: if ( nvl(pqh_rls_bus.g_role_id,hr_api.g_number)
163: = p_role_id) then
164: --
165: -- The legislation code has already been found with a previous
166: -- call to this function. Just return the value in the global
252: -- not been updated.
253: --
254: EXCEPTION
255: WHEN l_error THEN
256: hr_api.argument_changed_error
257: (p_api_name => l_proc
258: ,p_argument => l_argument);
259: WHEN OTHERS THEN
260: RAISE;
303: (p_role_id => p_role_id,
304: p_object_version_number => p_object_version_number);
305: --
306: if (l_api_updating
307: and nvl(p_role_id,hr_api.g_number)
308: <> pqh_rls_shd.g_old_rec.role_id) then
309: --
310: -- raise error as PK has changed
311: --
385: p_object_version_number => p_object_version_number);
386: --
387: if (l_api_updating
388: and p_enable_flag
389: <> nvl(pqh_rls_shd.g_old_rec.enable_flag,hr_api.g_varchar2)
390: or not l_api_updating)
391: and p_enable_flag is not null then
392: --
393: -- check if value of lookup falls within lookup type.
391: and p_enable_flag is not null then
392: --
393: -- check if value of lookup falls within lookup type.
394: --
395: if hr_api.not_exists_in_hr_lookups
396: (p_lookup_type => 'YES_NO',
397: p_lookup_code => p_enable_flag,
398: p_effective_date => p_effective_date) then
399: --
484: p_object_version_number => p_object_version_number);
485: --
486: if (l_api_updating
487: and p_role_type_cd
488: <> nvl(pqh_rls_shd.g_old_rec.role_type_cd,hr_api.g_varchar2)
489: or not l_api_updating)
490: and p_role_type_cd is not null then
491: --
492: -- check if value of lookup falls within lookup type.
490: and p_role_type_cd is not null then
491: --
492: -- check if value of lookup falls within lookup type.
493: --
494: if hr_api.not_exists_in_hr_lookups
495: (p_lookup_type => 'PQH_ROLE_TYPE',
496: p_lookup_code => p_role_type_cd,
497: p_effective_date => p_effective_date) then
498: --
819: hr_utility.set_location('Entering:'||l_proc,10);
820: --
821:
822: if ((p_rec.role_id is not null) and (
823: nvl(pqh_rls_shd.g_old_rec.information_category,hr_api.g_varchar2) <>
824: nvl(p_rec.information_category,hr_api.g_varchar2) or
825: nvl(pqh_rls_shd.g_old_rec.information1,hr_api.g_varchar2) <>
826: nvl(p_rec.information1,hr_api.g_varchar2) or
827: nvl(pqh_rls_shd.g_old_rec.information2,hr_api.g_varchar2) <>
820: --
821:
822: if ((p_rec.role_id is not null) and (
823: nvl(pqh_rls_shd.g_old_rec.information_category,hr_api.g_varchar2) <>
824: nvl(p_rec.information_category,hr_api.g_varchar2) or
825: nvl(pqh_rls_shd.g_old_rec.information1,hr_api.g_varchar2) <>
826: nvl(p_rec.information1,hr_api.g_varchar2) or
827: nvl(pqh_rls_shd.g_old_rec.information2,hr_api.g_varchar2) <>
828: nvl(p_rec.information2,hr_api.g_varchar2) or
821:
822: if ((p_rec.role_id is not null) and (
823: nvl(pqh_rls_shd.g_old_rec.information_category,hr_api.g_varchar2) <>
824: nvl(p_rec.information_category,hr_api.g_varchar2) or
825: nvl(pqh_rls_shd.g_old_rec.information1,hr_api.g_varchar2) <>
826: nvl(p_rec.information1,hr_api.g_varchar2) or
827: nvl(pqh_rls_shd.g_old_rec.information2,hr_api.g_varchar2) <>
828: nvl(p_rec.information2,hr_api.g_varchar2) or
829: nvl(pqh_rls_shd.g_old_rec.information3,hr_api.g_varchar2) <>
822: if ((p_rec.role_id is not null) and (
823: nvl(pqh_rls_shd.g_old_rec.information_category,hr_api.g_varchar2) <>
824: nvl(p_rec.information_category,hr_api.g_varchar2) or
825: nvl(pqh_rls_shd.g_old_rec.information1,hr_api.g_varchar2) <>
826: nvl(p_rec.information1,hr_api.g_varchar2) or
827: nvl(pqh_rls_shd.g_old_rec.information2,hr_api.g_varchar2) <>
828: nvl(p_rec.information2,hr_api.g_varchar2) or
829: nvl(pqh_rls_shd.g_old_rec.information3,hr_api.g_varchar2) <>
830: nvl(p_rec.information3,hr_api.g_varchar2) or
823: nvl(pqh_rls_shd.g_old_rec.information_category,hr_api.g_varchar2) <>
824: nvl(p_rec.information_category,hr_api.g_varchar2) or
825: nvl(pqh_rls_shd.g_old_rec.information1,hr_api.g_varchar2) <>
826: nvl(p_rec.information1,hr_api.g_varchar2) or
827: nvl(pqh_rls_shd.g_old_rec.information2,hr_api.g_varchar2) <>
828: nvl(p_rec.information2,hr_api.g_varchar2) or
829: nvl(pqh_rls_shd.g_old_rec.information3,hr_api.g_varchar2) <>
830: nvl(p_rec.information3,hr_api.g_varchar2) or
831: nvl(pqh_rls_shd.g_old_rec.information4,hr_api.g_varchar2) <>
824: nvl(p_rec.information_category,hr_api.g_varchar2) or
825: nvl(pqh_rls_shd.g_old_rec.information1,hr_api.g_varchar2) <>
826: nvl(p_rec.information1,hr_api.g_varchar2) or
827: nvl(pqh_rls_shd.g_old_rec.information2,hr_api.g_varchar2) <>
828: nvl(p_rec.information2,hr_api.g_varchar2) or
829: nvl(pqh_rls_shd.g_old_rec.information3,hr_api.g_varchar2) <>
830: nvl(p_rec.information3,hr_api.g_varchar2) or
831: nvl(pqh_rls_shd.g_old_rec.information4,hr_api.g_varchar2) <>
832: nvl(p_rec.information4,hr_api.g_varchar2) or
825: nvl(pqh_rls_shd.g_old_rec.information1,hr_api.g_varchar2) <>
826: nvl(p_rec.information1,hr_api.g_varchar2) or
827: nvl(pqh_rls_shd.g_old_rec.information2,hr_api.g_varchar2) <>
828: nvl(p_rec.information2,hr_api.g_varchar2) or
829: nvl(pqh_rls_shd.g_old_rec.information3,hr_api.g_varchar2) <>
830: nvl(p_rec.information3,hr_api.g_varchar2) or
831: nvl(pqh_rls_shd.g_old_rec.information4,hr_api.g_varchar2) <>
832: nvl(p_rec.information4,hr_api.g_varchar2) or
833: nvl(pqh_rls_shd.g_old_rec.information5,hr_api.g_varchar2) <>
826: nvl(p_rec.information1,hr_api.g_varchar2) or
827: nvl(pqh_rls_shd.g_old_rec.information2,hr_api.g_varchar2) <>
828: nvl(p_rec.information2,hr_api.g_varchar2) or
829: nvl(pqh_rls_shd.g_old_rec.information3,hr_api.g_varchar2) <>
830: nvl(p_rec.information3,hr_api.g_varchar2) or
831: nvl(pqh_rls_shd.g_old_rec.information4,hr_api.g_varchar2) <>
832: nvl(p_rec.information4,hr_api.g_varchar2) or
833: nvl(pqh_rls_shd.g_old_rec.information5,hr_api.g_varchar2) <>
834: nvl(p_rec.information5,hr_api.g_varchar2) or
827: nvl(pqh_rls_shd.g_old_rec.information2,hr_api.g_varchar2) <>
828: nvl(p_rec.information2,hr_api.g_varchar2) or
829: nvl(pqh_rls_shd.g_old_rec.information3,hr_api.g_varchar2) <>
830: nvl(p_rec.information3,hr_api.g_varchar2) or
831: nvl(pqh_rls_shd.g_old_rec.information4,hr_api.g_varchar2) <>
832: nvl(p_rec.information4,hr_api.g_varchar2) or
833: nvl(pqh_rls_shd.g_old_rec.information5,hr_api.g_varchar2) <>
834: nvl(p_rec.information5,hr_api.g_varchar2) or
835: nvl(pqh_rls_shd.g_old_rec.information6,hr_api.g_varchar2) <>
828: nvl(p_rec.information2,hr_api.g_varchar2) or
829: nvl(pqh_rls_shd.g_old_rec.information3,hr_api.g_varchar2) <>
830: nvl(p_rec.information3,hr_api.g_varchar2) or
831: nvl(pqh_rls_shd.g_old_rec.information4,hr_api.g_varchar2) <>
832: nvl(p_rec.information4,hr_api.g_varchar2) or
833: nvl(pqh_rls_shd.g_old_rec.information5,hr_api.g_varchar2) <>
834: nvl(p_rec.information5,hr_api.g_varchar2) or
835: nvl(pqh_rls_shd.g_old_rec.information6,hr_api.g_varchar2) <>
836: nvl(p_rec.information6,hr_api.g_varchar2) or
829: nvl(pqh_rls_shd.g_old_rec.information3,hr_api.g_varchar2) <>
830: nvl(p_rec.information3,hr_api.g_varchar2) or
831: nvl(pqh_rls_shd.g_old_rec.information4,hr_api.g_varchar2) <>
832: nvl(p_rec.information4,hr_api.g_varchar2) or
833: nvl(pqh_rls_shd.g_old_rec.information5,hr_api.g_varchar2) <>
834: nvl(p_rec.information5,hr_api.g_varchar2) or
835: nvl(pqh_rls_shd.g_old_rec.information6,hr_api.g_varchar2) <>
836: nvl(p_rec.information6,hr_api.g_varchar2) or
837: nvl(pqh_rls_shd.g_old_rec.information7,hr_api.g_varchar2) <>
830: nvl(p_rec.information3,hr_api.g_varchar2) or
831: nvl(pqh_rls_shd.g_old_rec.information4,hr_api.g_varchar2) <>
832: nvl(p_rec.information4,hr_api.g_varchar2) or
833: nvl(pqh_rls_shd.g_old_rec.information5,hr_api.g_varchar2) <>
834: nvl(p_rec.information5,hr_api.g_varchar2) or
835: nvl(pqh_rls_shd.g_old_rec.information6,hr_api.g_varchar2) <>
836: nvl(p_rec.information6,hr_api.g_varchar2) or
837: nvl(pqh_rls_shd.g_old_rec.information7,hr_api.g_varchar2) <>
838: nvl(p_rec.information7,hr_api.g_varchar2) or
831: nvl(pqh_rls_shd.g_old_rec.information4,hr_api.g_varchar2) <>
832: nvl(p_rec.information4,hr_api.g_varchar2) or
833: nvl(pqh_rls_shd.g_old_rec.information5,hr_api.g_varchar2) <>
834: nvl(p_rec.information5,hr_api.g_varchar2) or
835: nvl(pqh_rls_shd.g_old_rec.information6,hr_api.g_varchar2) <>
836: nvl(p_rec.information6,hr_api.g_varchar2) or
837: nvl(pqh_rls_shd.g_old_rec.information7,hr_api.g_varchar2) <>
838: nvl(p_rec.information7,hr_api.g_varchar2) or
839: nvl(pqh_rls_shd.g_old_rec.information8,hr_api.g_varchar2) <>
832: nvl(p_rec.information4,hr_api.g_varchar2) or
833: nvl(pqh_rls_shd.g_old_rec.information5,hr_api.g_varchar2) <>
834: nvl(p_rec.information5,hr_api.g_varchar2) or
835: nvl(pqh_rls_shd.g_old_rec.information6,hr_api.g_varchar2) <>
836: nvl(p_rec.information6,hr_api.g_varchar2) or
837: nvl(pqh_rls_shd.g_old_rec.information7,hr_api.g_varchar2) <>
838: nvl(p_rec.information7,hr_api.g_varchar2) or
839: nvl(pqh_rls_shd.g_old_rec.information8,hr_api.g_varchar2) <>
840: nvl(p_rec.information8,hr_api.g_varchar2) or
833: nvl(pqh_rls_shd.g_old_rec.information5,hr_api.g_varchar2) <>
834: nvl(p_rec.information5,hr_api.g_varchar2) or
835: nvl(pqh_rls_shd.g_old_rec.information6,hr_api.g_varchar2) <>
836: nvl(p_rec.information6,hr_api.g_varchar2) or
837: nvl(pqh_rls_shd.g_old_rec.information7,hr_api.g_varchar2) <>
838: nvl(p_rec.information7,hr_api.g_varchar2) or
839: nvl(pqh_rls_shd.g_old_rec.information8,hr_api.g_varchar2) <>
840: nvl(p_rec.information8,hr_api.g_varchar2) or
841: nvl(pqh_rls_shd.g_old_rec.information9,hr_api.g_varchar2) <>
834: nvl(p_rec.information5,hr_api.g_varchar2) or
835: nvl(pqh_rls_shd.g_old_rec.information6,hr_api.g_varchar2) <>
836: nvl(p_rec.information6,hr_api.g_varchar2) or
837: nvl(pqh_rls_shd.g_old_rec.information7,hr_api.g_varchar2) <>
838: nvl(p_rec.information7,hr_api.g_varchar2) or
839: nvl(pqh_rls_shd.g_old_rec.information8,hr_api.g_varchar2) <>
840: nvl(p_rec.information8,hr_api.g_varchar2) or
841: nvl(pqh_rls_shd.g_old_rec.information9,hr_api.g_varchar2) <>
842: nvl(p_rec.information9,hr_api.g_varchar2) or
835: nvl(pqh_rls_shd.g_old_rec.information6,hr_api.g_varchar2) <>
836: nvl(p_rec.information6,hr_api.g_varchar2) or
837: nvl(pqh_rls_shd.g_old_rec.information7,hr_api.g_varchar2) <>
838: nvl(p_rec.information7,hr_api.g_varchar2) or
839: nvl(pqh_rls_shd.g_old_rec.information8,hr_api.g_varchar2) <>
840: nvl(p_rec.information8,hr_api.g_varchar2) or
841: nvl(pqh_rls_shd.g_old_rec.information9,hr_api.g_varchar2) <>
842: nvl(p_rec.information9,hr_api.g_varchar2) or
843: nvl(pqh_rls_shd.g_old_rec.information10,hr_api.g_varchar2) <>
836: nvl(p_rec.information6,hr_api.g_varchar2) or
837: nvl(pqh_rls_shd.g_old_rec.information7,hr_api.g_varchar2) <>
838: nvl(p_rec.information7,hr_api.g_varchar2) or
839: nvl(pqh_rls_shd.g_old_rec.information8,hr_api.g_varchar2) <>
840: nvl(p_rec.information8,hr_api.g_varchar2) or
841: nvl(pqh_rls_shd.g_old_rec.information9,hr_api.g_varchar2) <>
842: nvl(p_rec.information9,hr_api.g_varchar2) or
843: nvl(pqh_rls_shd.g_old_rec.information10,hr_api.g_varchar2) <>
844: nvl(p_rec.information10,hr_api.g_varchar2) or
837: nvl(pqh_rls_shd.g_old_rec.information7,hr_api.g_varchar2) <>
838: nvl(p_rec.information7,hr_api.g_varchar2) or
839: nvl(pqh_rls_shd.g_old_rec.information8,hr_api.g_varchar2) <>
840: nvl(p_rec.information8,hr_api.g_varchar2) or
841: nvl(pqh_rls_shd.g_old_rec.information9,hr_api.g_varchar2) <>
842: nvl(p_rec.information9,hr_api.g_varchar2) or
843: nvl(pqh_rls_shd.g_old_rec.information10,hr_api.g_varchar2) <>
844: nvl(p_rec.information10,hr_api.g_varchar2) or
845: nvl(pqh_rls_shd.g_old_rec.information11,hr_api.g_varchar2) <>
838: nvl(p_rec.information7,hr_api.g_varchar2) or
839: nvl(pqh_rls_shd.g_old_rec.information8,hr_api.g_varchar2) <>
840: nvl(p_rec.information8,hr_api.g_varchar2) or
841: nvl(pqh_rls_shd.g_old_rec.information9,hr_api.g_varchar2) <>
842: nvl(p_rec.information9,hr_api.g_varchar2) or
843: nvl(pqh_rls_shd.g_old_rec.information10,hr_api.g_varchar2) <>
844: nvl(p_rec.information10,hr_api.g_varchar2) or
845: nvl(pqh_rls_shd.g_old_rec.information11,hr_api.g_varchar2) <>
846: nvl(p_rec.information11,hr_api.g_varchar2) or
839: nvl(pqh_rls_shd.g_old_rec.information8,hr_api.g_varchar2) <>
840: nvl(p_rec.information8,hr_api.g_varchar2) or
841: nvl(pqh_rls_shd.g_old_rec.information9,hr_api.g_varchar2) <>
842: nvl(p_rec.information9,hr_api.g_varchar2) or
843: nvl(pqh_rls_shd.g_old_rec.information10,hr_api.g_varchar2) <>
844: nvl(p_rec.information10,hr_api.g_varchar2) or
845: nvl(pqh_rls_shd.g_old_rec.information11,hr_api.g_varchar2) <>
846: nvl(p_rec.information11,hr_api.g_varchar2) or
847: nvl(pqh_rls_shd.g_old_rec.information12,hr_api.g_varchar2) <>
840: nvl(p_rec.information8,hr_api.g_varchar2) or
841: nvl(pqh_rls_shd.g_old_rec.information9,hr_api.g_varchar2) <>
842: nvl(p_rec.information9,hr_api.g_varchar2) or
843: nvl(pqh_rls_shd.g_old_rec.information10,hr_api.g_varchar2) <>
844: nvl(p_rec.information10,hr_api.g_varchar2) or
845: nvl(pqh_rls_shd.g_old_rec.information11,hr_api.g_varchar2) <>
846: nvl(p_rec.information11,hr_api.g_varchar2) or
847: nvl(pqh_rls_shd.g_old_rec.information12,hr_api.g_varchar2) <>
848: nvl(p_rec.information12,hr_api.g_varchar2) or
841: nvl(pqh_rls_shd.g_old_rec.information9,hr_api.g_varchar2) <>
842: nvl(p_rec.information9,hr_api.g_varchar2) or
843: nvl(pqh_rls_shd.g_old_rec.information10,hr_api.g_varchar2) <>
844: nvl(p_rec.information10,hr_api.g_varchar2) or
845: nvl(pqh_rls_shd.g_old_rec.information11,hr_api.g_varchar2) <>
846: nvl(p_rec.information11,hr_api.g_varchar2) or
847: nvl(pqh_rls_shd.g_old_rec.information12,hr_api.g_varchar2) <>
848: nvl(p_rec.information12,hr_api.g_varchar2) or
849: nvl(pqh_rls_shd.g_old_rec.information13,hr_api.g_varchar2) <>
842: nvl(p_rec.information9,hr_api.g_varchar2) or
843: nvl(pqh_rls_shd.g_old_rec.information10,hr_api.g_varchar2) <>
844: nvl(p_rec.information10,hr_api.g_varchar2) or
845: nvl(pqh_rls_shd.g_old_rec.information11,hr_api.g_varchar2) <>
846: nvl(p_rec.information11,hr_api.g_varchar2) or
847: nvl(pqh_rls_shd.g_old_rec.information12,hr_api.g_varchar2) <>
848: nvl(p_rec.information12,hr_api.g_varchar2) or
849: nvl(pqh_rls_shd.g_old_rec.information13,hr_api.g_varchar2) <>
850: nvl(p_rec.information13,hr_api.g_varchar2) or
843: nvl(pqh_rls_shd.g_old_rec.information10,hr_api.g_varchar2) <>
844: nvl(p_rec.information10,hr_api.g_varchar2) or
845: nvl(pqh_rls_shd.g_old_rec.information11,hr_api.g_varchar2) <>
846: nvl(p_rec.information11,hr_api.g_varchar2) or
847: nvl(pqh_rls_shd.g_old_rec.information12,hr_api.g_varchar2) <>
848: nvl(p_rec.information12,hr_api.g_varchar2) or
849: nvl(pqh_rls_shd.g_old_rec.information13,hr_api.g_varchar2) <>
850: nvl(p_rec.information13,hr_api.g_varchar2) or
851: nvl(pqh_rls_shd.g_old_rec.information14,hr_api.g_varchar2) <>
844: nvl(p_rec.information10,hr_api.g_varchar2) or
845: nvl(pqh_rls_shd.g_old_rec.information11,hr_api.g_varchar2) <>
846: nvl(p_rec.information11,hr_api.g_varchar2) or
847: nvl(pqh_rls_shd.g_old_rec.information12,hr_api.g_varchar2) <>
848: nvl(p_rec.information12,hr_api.g_varchar2) or
849: nvl(pqh_rls_shd.g_old_rec.information13,hr_api.g_varchar2) <>
850: nvl(p_rec.information13,hr_api.g_varchar2) or
851: nvl(pqh_rls_shd.g_old_rec.information14,hr_api.g_varchar2) <>
852: nvl(p_rec.information14,hr_api.g_varchar2) or
845: nvl(pqh_rls_shd.g_old_rec.information11,hr_api.g_varchar2) <>
846: nvl(p_rec.information11,hr_api.g_varchar2) or
847: nvl(pqh_rls_shd.g_old_rec.information12,hr_api.g_varchar2) <>
848: nvl(p_rec.information12,hr_api.g_varchar2) or
849: nvl(pqh_rls_shd.g_old_rec.information13,hr_api.g_varchar2) <>
850: nvl(p_rec.information13,hr_api.g_varchar2) or
851: nvl(pqh_rls_shd.g_old_rec.information14,hr_api.g_varchar2) <>
852: nvl(p_rec.information14,hr_api.g_varchar2) or
853: nvl(pqh_rls_shd.g_old_rec.information15,hr_api.g_varchar2) <>
846: nvl(p_rec.information11,hr_api.g_varchar2) or
847: nvl(pqh_rls_shd.g_old_rec.information12,hr_api.g_varchar2) <>
848: nvl(p_rec.information12,hr_api.g_varchar2) or
849: nvl(pqh_rls_shd.g_old_rec.information13,hr_api.g_varchar2) <>
850: nvl(p_rec.information13,hr_api.g_varchar2) or
851: nvl(pqh_rls_shd.g_old_rec.information14,hr_api.g_varchar2) <>
852: nvl(p_rec.information14,hr_api.g_varchar2) or
853: nvl(pqh_rls_shd.g_old_rec.information15,hr_api.g_varchar2) <>
854: nvl(p_rec.information15,hr_api.g_varchar2) or
847: nvl(pqh_rls_shd.g_old_rec.information12,hr_api.g_varchar2) <>
848: nvl(p_rec.information12,hr_api.g_varchar2) or
849: nvl(pqh_rls_shd.g_old_rec.information13,hr_api.g_varchar2) <>
850: nvl(p_rec.information13,hr_api.g_varchar2) or
851: nvl(pqh_rls_shd.g_old_rec.information14,hr_api.g_varchar2) <>
852: nvl(p_rec.information14,hr_api.g_varchar2) or
853: nvl(pqh_rls_shd.g_old_rec.information15,hr_api.g_varchar2) <>
854: nvl(p_rec.information15,hr_api.g_varchar2) or
855: nvl(pqh_rls_shd.g_old_rec.information16,hr_api.g_varchar2) <>
848: nvl(p_rec.information12,hr_api.g_varchar2) or
849: nvl(pqh_rls_shd.g_old_rec.information13,hr_api.g_varchar2) <>
850: nvl(p_rec.information13,hr_api.g_varchar2) or
851: nvl(pqh_rls_shd.g_old_rec.information14,hr_api.g_varchar2) <>
852: nvl(p_rec.information14,hr_api.g_varchar2) or
853: nvl(pqh_rls_shd.g_old_rec.information15,hr_api.g_varchar2) <>
854: nvl(p_rec.information15,hr_api.g_varchar2) or
855: nvl(pqh_rls_shd.g_old_rec.information16,hr_api.g_varchar2) <>
856: nvl(p_rec.information16,hr_api.g_varchar2) or
849: nvl(pqh_rls_shd.g_old_rec.information13,hr_api.g_varchar2) <>
850: nvl(p_rec.information13,hr_api.g_varchar2) or
851: nvl(pqh_rls_shd.g_old_rec.information14,hr_api.g_varchar2) <>
852: nvl(p_rec.information14,hr_api.g_varchar2) or
853: nvl(pqh_rls_shd.g_old_rec.information15,hr_api.g_varchar2) <>
854: nvl(p_rec.information15,hr_api.g_varchar2) or
855: nvl(pqh_rls_shd.g_old_rec.information16,hr_api.g_varchar2) <>
856: nvl(p_rec.information16,hr_api.g_varchar2) or
857: nvl(pqh_rls_shd.g_old_rec.information17,hr_api.g_varchar2) <>
850: nvl(p_rec.information13,hr_api.g_varchar2) or
851: nvl(pqh_rls_shd.g_old_rec.information14,hr_api.g_varchar2) <>
852: nvl(p_rec.information14,hr_api.g_varchar2) or
853: nvl(pqh_rls_shd.g_old_rec.information15,hr_api.g_varchar2) <>
854: nvl(p_rec.information15,hr_api.g_varchar2) or
855: nvl(pqh_rls_shd.g_old_rec.information16,hr_api.g_varchar2) <>
856: nvl(p_rec.information16,hr_api.g_varchar2) or
857: nvl(pqh_rls_shd.g_old_rec.information17,hr_api.g_varchar2) <>
858: nvl(p_rec.information17,hr_api.g_varchar2) or
851: nvl(pqh_rls_shd.g_old_rec.information14,hr_api.g_varchar2) <>
852: nvl(p_rec.information14,hr_api.g_varchar2) or
853: nvl(pqh_rls_shd.g_old_rec.information15,hr_api.g_varchar2) <>
854: nvl(p_rec.information15,hr_api.g_varchar2) or
855: nvl(pqh_rls_shd.g_old_rec.information16,hr_api.g_varchar2) <>
856: nvl(p_rec.information16,hr_api.g_varchar2) or
857: nvl(pqh_rls_shd.g_old_rec.information17,hr_api.g_varchar2) <>
858: nvl(p_rec.information17,hr_api.g_varchar2) or
859: nvl(pqh_rls_shd.g_old_rec.information18,hr_api.g_varchar2) <>
852: nvl(p_rec.information14,hr_api.g_varchar2) or
853: nvl(pqh_rls_shd.g_old_rec.information15,hr_api.g_varchar2) <>
854: nvl(p_rec.information15,hr_api.g_varchar2) or
855: nvl(pqh_rls_shd.g_old_rec.information16,hr_api.g_varchar2) <>
856: nvl(p_rec.information16,hr_api.g_varchar2) or
857: nvl(pqh_rls_shd.g_old_rec.information17,hr_api.g_varchar2) <>
858: nvl(p_rec.information17,hr_api.g_varchar2) or
859: nvl(pqh_rls_shd.g_old_rec.information18,hr_api.g_varchar2) <>
860: nvl(p_rec.information18,hr_api.g_varchar2) or
853: nvl(pqh_rls_shd.g_old_rec.information15,hr_api.g_varchar2) <>
854: nvl(p_rec.information15,hr_api.g_varchar2) or
855: nvl(pqh_rls_shd.g_old_rec.information16,hr_api.g_varchar2) <>
856: nvl(p_rec.information16,hr_api.g_varchar2) or
857: nvl(pqh_rls_shd.g_old_rec.information17,hr_api.g_varchar2) <>
858: nvl(p_rec.information17,hr_api.g_varchar2) or
859: nvl(pqh_rls_shd.g_old_rec.information18,hr_api.g_varchar2) <>
860: nvl(p_rec.information18,hr_api.g_varchar2) or
861: nvl(pqh_rls_shd.g_old_rec.information19,hr_api.g_varchar2) <>
854: nvl(p_rec.information15,hr_api.g_varchar2) or
855: nvl(pqh_rls_shd.g_old_rec.information16,hr_api.g_varchar2) <>
856: nvl(p_rec.information16,hr_api.g_varchar2) or
857: nvl(pqh_rls_shd.g_old_rec.information17,hr_api.g_varchar2) <>
858: nvl(p_rec.information17,hr_api.g_varchar2) or
859: nvl(pqh_rls_shd.g_old_rec.information18,hr_api.g_varchar2) <>
860: nvl(p_rec.information18,hr_api.g_varchar2) or
861: nvl(pqh_rls_shd.g_old_rec.information19,hr_api.g_varchar2) <>
862: nvl(p_rec.information19,hr_api.g_varchar2) or
855: nvl(pqh_rls_shd.g_old_rec.information16,hr_api.g_varchar2) <>
856: nvl(p_rec.information16,hr_api.g_varchar2) or
857: nvl(pqh_rls_shd.g_old_rec.information17,hr_api.g_varchar2) <>
858: nvl(p_rec.information17,hr_api.g_varchar2) or
859: nvl(pqh_rls_shd.g_old_rec.information18,hr_api.g_varchar2) <>
860: nvl(p_rec.information18,hr_api.g_varchar2) or
861: nvl(pqh_rls_shd.g_old_rec.information19,hr_api.g_varchar2) <>
862: nvl(p_rec.information19,hr_api.g_varchar2) or
863: nvl(pqh_rls_shd.g_old_rec.information20,hr_api.g_varchar2) <>
856: nvl(p_rec.information16,hr_api.g_varchar2) or
857: nvl(pqh_rls_shd.g_old_rec.information17,hr_api.g_varchar2) <>
858: nvl(p_rec.information17,hr_api.g_varchar2) or
859: nvl(pqh_rls_shd.g_old_rec.information18,hr_api.g_varchar2) <>
860: nvl(p_rec.information18,hr_api.g_varchar2) or
861: nvl(pqh_rls_shd.g_old_rec.information19,hr_api.g_varchar2) <>
862: nvl(p_rec.information19,hr_api.g_varchar2) or
863: nvl(pqh_rls_shd.g_old_rec.information20,hr_api.g_varchar2) <>
864: nvl(p_rec.information20,hr_api.g_varchar2) or
857: nvl(pqh_rls_shd.g_old_rec.information17,hr_api.g_varchar2) <>
858: nvl(p_rec.information17,hr_api.g_varchar2) or
859: nvl(pqh_rls_shd.g_old_rec.information18,hr_api.g_varchar2) <>
860: nvl(p_rec.information18,hr_api.g_varchar2) or
861: nvl(pqh_rls_shd.g_old_rec.information19,hr_api.g_varchar2) <>
862: nvl(p_rec.information19,hr_api.g_varchar2) or
863: nvl(pqh_rls_shd.g_old_rec.information20,hr_api.g_varchar2) <>
864: nvl(p_rec.information20,hr_api.g_varchar2) or
865: nvl(pqh_rls_shd.g_old_rec.information21,hr_api.g_varchar2) <>
858: nvl(p_rec.information17,hr_api.g_varchar2) or
859: nvl(pqh_rls_shd.g_old_rec.information18,hr_api.g_varchar2) <>
860: nvl(p_rec.information18,hr_api.g_varchar2) or
861: nvl(pqh_rls_shd.g_old_rec.information19,hr_api.g_varchar2) <>
862: nvl(p_rec.information19,hr_api.g_varchar2) or
863: nvl(pqh_rls_shd.g_old_rec.information20,hr_api.g_varchar2) <>
864: nvl(p_rec.information20,hr_api.g_varchar2) or
865: nvl(pqh_rls_shd.g_old_rec.information21,hr_api.g_varchar2) <>
866: nvl(p_rec.information21,hr_api.g_varchar2) or
859: nvl(pqh_rls_shd.g_old_rec.information18,hr_api.g_varchar2) <>
860: nvl(p_rec.information18,hr_api.g_varchar2) or
861: nvl(pqh_rls_shd.g_old_rec.information19,hr_api.g_varchar2) <>
862: nvl(p_rec.information19,hr_api.g_varchar2) or
863: nvl(pqh_rls_shd.g_old_rec.information20,hr_api.g_varchar2) <>
864: nvl(p_rec.information20,hr_api.g_varchar2) or
865: nvl(pqh_rls_shd.g_old_rec.information21,hr_api.g_varchar2) <>
866: nvl(p_rec.information21,hr_api.g_varchar2) or
867: nvl(pqh_rls_shd.g_old_rec.information22,hr_api.g_varchar2) <>
860: nvl(p_rec.information18,hr_api.g_varchar2) or
861: nvl(pqh_rls_shd.g_old_rec.information19,hr_api.g_varchar2) <>
862: nvl(p_rec.information19,hr_api.g_varchar2) or
863: nvl(pqh_rls_shd.g_old_rec.information20,hr_api.g_varchar2) <>
864: nvl(p_rec.information20,hr_api.g_varchar2) or
865: nvl(pqh_rls_shd.g_old_rec.information21,hr_api.g_varchar2) <>
866: nvl(p_rec.information21,hr_api.g_varchar2) or
867: nvl(pqh_rls_shd.g_old_rec.information22,hr_api.g_varchar2) <>
868: nvl(p_rec.information22,hr_api.g_varchar2) or
861: nvl(pqh_rls_shd.g_old_rec.information19,hr_api.g_varchar2) <>
862: nvl(p_rec.information19,hr_api.g_varchar2) or
863: nvl(pqh_rls_shd.g_old_rec.information20,hr_api.g_varchar2) <>
864: nvl(p_rec.information20,hr_api.g_varchar2) or
865: nvl(pqh_rls_shd.g_old_rec.information21,hr_api.g_varchar2) <>
866: nvl(p_rec.information21,hr_api.g_varchar2) or
867: nvl(pqh_rls_shd.g_old_rec.information22,hr_api.g_varchar2) <>
868: nvl(p_rec.information22,hr_api.g_varchar2) or
869: nvl(pqh_rls_shd.g_old_rec.information23,hr_api.g_varchar2) <>
862: nvl(p_rec.information19,hr_api.g_varchar2) or
863: nvl(pqh_rls_shd.g_old_rec.information20,hr_api.g_varchar2) <>
864: nvl(p_rec.information20,hr_api.g_varchar2) or
865: nvl(pqh_rls_shd.g_old_rec.information21,hr_api.g_varchar2) <>
866: nvl(p_rec.information21,hr_api.g_varchar2) or
867: nvl(pqh_rls_shd.g_old_rec.information22,hr_api.g_varchar2) <>
868: nvl(p_rec.information22,hr_api.g_varchar2) or
869: nvl(pqh_rls_shd.g_old_rec.information23,hr_api.g_varchar2) <>
870: nvl(p_rec.information23,hr_api.g_varchar2) or
863: nvl(pqh_rls_shd.g_old_rec.information20,hr_api.g_varchar2) <>
864: nvl(p_rec.information20,hr_api.g_varchar2) or
865: nvl(pqh_rls_shd.g_old_rec.information21,hr_api.g_varchar2) <>
866: nvl(p_rec.information21,hr_api.g_varchar2) or
867: nvl(pqh_rls_shd.g_old_rec.information22,hr_api.g_varchar2) <>
868: nvl(p_rec.information22,hr_api.g_varchar2) or
869: nvl(pqh_rls_shd.g_old_rec.information23,hr_api.g_varchar2) <>
870: nvl(p_rec.information23,hr_api.g_varchar2) or
871: nvl(pqh_rls_shd.g_old_rec.information24,hr_api.g_varchar2) <>
864: nvl(p_rec.information20,hr_api.g_varchar2) or
865: nvl(pqh_rls_shd.g_old_rec.information21,hr_api.g_varchar2) <>
866: nvl(p_rec.information21,hr_api.g_varchar2) or
867: nvl(pqh_rls_shd.g_old_rec.information22,hr_api.g_varchar2) <>
868: nvl(p_rec.information22,hr_api.g_varchar2) or
869: nvl(pqh_rls_shd.g_old_rec.information23,hr_api.g_varchar2) <>
870: nvl(p_rec.information23,hr_api.g_varchar2) or
871: nvl(pqh_rls_shd.g_old_rec.information24,hr_api.g_varchar2) <>
872: nvl(p_rec.information24,hr_api.g_varchar2) or
865: nvl(pqh_rls_shd.g_old_rec.information21,hr_api.g_varchar2) <>
866: nvl(p_rec.information21,hr_api.g_varchar2) or
867: nvl(pqh_rls_shd.g_old_rec.information22,hr_api.g_varchar2) <>
868: nvl(p_rec.information22,hr_api.g_varchar2) or
869: nvl(pqh_rls_shd.g_old_rec.information23,hr_api.g_varchar2) <>
870: nvl(p_rec.information23,hr_api.g_varchar2) or
871: nvl(pqh_rls_shd.g_old_rec.information24,hr_api.g_varchar2) <>
872: nvl(p_rec.information24,hr_api.g_varchar2) or
873: nvl(pqh_rls_shd.g_old_rec.information25,hr_api.g_varchar2) <>
866: nvl(p_rec.information21,hr_api.g_varchar2) or
867: nvl(pqh_rls_shd.g_old_rec.information22,hr_api.g_varchar2) <>
868: nvl(p_rec.information22,hr_api.g_varchar2) or
869: nvl(pqh_rls_shd.g_old_rec.information23,hr_api.g_varchar2) <>
870: nvl(p_rec.information23,hr_api.g_varchar2) or
871: nvl(pqh_rls_shd.g_old_rec.information24,hr_api.g_varchar2) <>
872: nvl(p_rec.information24,hr_api.g_varchar2) or
873: nvl(pqh_rls_shd.g_old_rec.information25,hr_api.g_varchar2) <>
874: nvl(p_rec.information25,hr_api.g_varchar2) or
867: nvl(pqh_rls_shd.g_old_rec.information22,hr_api.g_varchar2) <>
868: nvl(p_rec.information22,hr_api.g_varchar2) or
869: nvl(pqh_rls_shd.g_old_rec.information23,hr_api.g_varchar2) <>
870: nvl(p_rec.information23,hr_api.g_varchar2) or
871: nvl(pqh_rls_shd.g_old_rec.information24,hr_api.g_varchar2) <>
872: nvl(p_rec.information24,hr_api.g_varchar2) or
873: nvl(pqh_rls_shd.g_old_rec.information25,hr_api.g_varchar2) <>
874: nvl(p_rec.information25,hr_api.g_varchar2) or
875: nvl(pqh_rls_shd.g_old_rec.information26,hr_api.g_varchar2) <>
868: nvl(p_rec.information22,hr_api.g_varchar2) or
869: nvl(pqh_rls_shd.g_old_rec.information23,hr_api.g_varchar2) <>
870: nvl(p_rec.information23,hr_api.g_varchar2) or
871: nvl(pqh_rls_shd.g_old_rec.information24,hr_api.g_varchar2) <>
872: nvl(p_rec.information24,hr_api.g_varchar2) or
873: nvl(pqh_rls_shd.g_old_rec.information25,hr_api.g_varchar2) <>
874: nvl(p_rec.information25,hr_api.g_varchar2) or
875: nvl(pqh_rls_shd.g_old_rec.information26,hr_api.g_varchar2) <>
876: nvl(p_rec.information26,hr_api.g_varchar2) or
869: nvl(pqh_rls_shd.g_old_rec.information23,hr_api.g_varchar2) <>
870: nvl(p_rec.information23,hr_api.g_varchar2) or
871: nvl(pqh_rls_shd.g_old_rec.information24,hr_api.g_varchar2) <>
872: nvl(p_rec.information24,hr_api.g_varchar2) or
873: nvl(pqh_rls_shd.g_old_rec.information25,hr_api.g_varchar2) <>
874: nvl(p_rec.information25,hr_api.g_varchar2) or
875: nvl(pqh_rls_shd.g_old_rec.information26,hr_api.g_varchar2) <>
876: nvl(p_rec.information26,hr_api.g_varchar2) or
877: nvl(pqh_rls_shd.g_old_rec.information27,hr_api.g_varchar2) <>
870: nvl(p_rec.information23,hr_api.g_varchar2) or
871: nvl(pqh_rls_shd.g_old_rec.information24,hr_api.g_varchar2) <>
872: nvl(p_rec.information24,hr_api.g_varchar2) or
873: nvl(pqh_rls_shd.g_old_rec.information25,hr_api.g_varchar2) <>
874: nvl(p_rec.information25,hr_api.g_varchar2) or
875: nvl(pqh_rls_shd.g_old_rec.information26,hr_api.g_varchar2) <>
876: nvl(p_rec.information26,hr_api.g_varchar2) or
877: nvl(pqh_rls_shd.g_old_rec.information27,hr_api.g_varchar2) <>
878: nvl(p_rec.information27,hr_api.g_varchar2) or
871: nvl(pqh_rls_shd.g_old_rec.information24,hr_api.g_varchar2) <>
872: nvl(p_rec.information24,hr_api.g_varchar2) or
873: nvl(pqh_rls_shd.g_old_rec.information25,hr_api.g_varchar2) <>
874: nvl(p_rec.information25,hr_api.g_varchar2) or
875: nvl(pqh_rls_shd.g_old_rec.information26,hr_api.g_varchar2) <>
876: nvl(p_rec.information26,hr_api.g_varchar2) or
877: nvl(pqh_rls_shd.g_old_rec.information27,hr_api.g_varchar2) <>
878: nvl(p_rec.information27,hr_api.g_varchar2) or
879: nvl(pqh_rls_shd.g_old_rec.information28,hr_api.g_varchar2) <>
872: nvl(p_rec.information24,hr_api.g_varchar2) or
873: nvl(pqh_rls_shd.g_old_rec.information25,hr_api.g_varchar2) <>
874: nvl(p_rec.information25,hr_api.g_varchar2) or
875: nvl(pqh_rls_shd.g_old_rec.information26,hr_api.g_varchar2) <>
876: nvl(p_rec.information26,hr_api.g_varchar2) or
877: nvl(pqh_rls_shd.g_old_rec.information27,hr_api.g_varchar2) <>
878: nvl(p_rec.information27,hr_api.g_varchar2) or
879: nvl(pqh_rls_shd.g_old_rec.information28,hr_api.g_varchar2) <>
880: nvl(p_rec.information28,hr_api.g_varchar2) or
873: nvl(pqh_rls_shd.g_old_rec.information25,hr_api.g_varchar2) <>
874: nvl(p_rec.information25,hr_api.g_varchar2) or
875: nvl(pqh_rls_shd.g_old_rec.information26,hr_api.g_varchar2) <>
876: nvl(p_rec.information26,hr_api.g_varchar2) or
877: nvl(pqh_rls_shd.g_old_rec.information27,hr_api.g_varchar2) <>
878: nvl(p_rec.information27,hr_api.g_varchar2) or
879: nvl(pqh_rls_shd.g_old_rec.information28,hr_api.g_varchar2) <>
880: nvl(p_rec.information28,hr_api.g_varchar2) or
881: nvl(pqh_rls_shd.g_old_rec.information29,hr_api.g_varchar2) <>
874: nvl(p_rec.information25,hr_api.g_varchar2) or
875: nvl(pqh_rls_shd.g_old_rec.information26,hr_api.g_varchar2) <>
876: nvl(p_rec.information26,hr_api.g_varchar2) or
877: nvl(pqh_rls_shd.g_old_rec.information27,hr_api.g_varchar2) <>
878: nvl(p_rec.information27,hr_api.g_varchar2) or
879: nvl(pqh_rls_shd.g_old_rec.information28,hr_api.g_varchar2) <>
880: nvl(p_rec.information28,hr_api.g_varchar2) or
881: nvl(pqh_rls_shd.g_old_rec.information29,hr_api.g_varchar2) <>
882: nvl(p_rec.information29,hr_api.g_varchar2) or
875: nvl(pqh_rls_shd.g_old_rec.information26,hr_api.g_varchar2) <>
876: nvl(p_rec.information26,hr_api.g_varchar2) or
877: nvl(pqh_rls_shd.g_old_rec.information27,hr_api.g_varchar2) <>
878: nvl(p_rec.information27,hr_api.g_varchar2) or
879: nvl(pqh_rls_shd.g_old_rec.information28,hr_api.g_varchar2) <>
880: nvl(p_rec.information28,hr_api.g_varchar2) or
881: nvl(pqh_rls_shd.g_old_rec.information29,hr_api.g_varchar2) <>
882: nvl(p_rec.information29,hr_api.g_varchar2) or
883: nvl(pqh_rls_shd.g_old_rec.information30,hr_api.g_varchar2) <>
876: nvl(p_rec.information26,hr_api.g_varchar2) or
877: nvl(pqh_rls_shd.g_old_rec.information27,hr_api.g_varchar2) <>
878: nvl(p_rec.information27,hr_api.g_varchar2) or
879: nvl(pqh_rls_shd.g_old_rec.information28,hr_api.g_varchar2) <>
880: nvl(p_rec.information28,hr_api.g_varchar2) or
881: nvl(pqh_rls_shd.g_old_rec.information29,hr_api.g_varchar2) <>
882: nvl(p_rec.information29,hr_api.g_varchar2) or
883: nvl(pqh_rls_shd.g_old_rec.information30,hr_api.g_varchar2) <>
884: nvl(p_rec.information30,hr_api.g_varchar2)))
877: nvl(pqh_rls_shd.g_old_rec.information27,hr_api.g_varchar2) <>
878: nvl(p_rec.information27,hr_api.g_varchar2) or
879: nvl(pqh_rls_shd.g_old_rec.information28,hr_api.g_varchar2) <>
880: nvl(p_rec.information28,hr_api.g_varchar2) or
881: nvl(pqh_rls_shd.g_old_rec.information29,hr_api.g_varchar2) <>
882: nvl(p_rec.information29,hr_api.g_varchar2) or
883: nvl(pqh_rls_shd.g_old_rec.information30,hr_api.g_varchar2) <>
884: nvl(p_rec.information30,hr_api.g_varchar2)))
885: or
878: nvl(p_rec.information27,hr_api.g_varchar2) or
879: nvl(pqh_rls_shd.g_old_rec.information28,hr_api.g_varchar2) <>
880: nvl(p_rec.information28,hr_api.g_varchar2) or
881: nvl(pqh_rls_shd.g_old_rec.information29,hr_api.g_varchar2) <>
882: nvl(p_rec.information29,hr_api.g_varchar2) or
883: nvl(pqh_rls_shd.g_old_rec.information30,hr_api.g_varchar2) <>
884: nvl(p_rec.information30,hr_api.g_varchar2)))
885: or
886: (p_rec.role_id is null) then
879: nvl(pqh_rls_shd.g_old_rec.information28,hr_api.g_varchar2) <>
880: nvl(p_rec.information28,hr_api.g_varchar2) or
881: nvl(pqh_rls_shd.g_old_rec.information29,hr_api.g_varchar2) <>
882: nvl(p_rec.information29,hr_api.g_varchar2) or
883: nvl(pqh_rls_shd.g_old_rec.information30,hr_api.g_varchar2) <>
884: nvl(p_rec.information30,hr_api.g_varchar2)))
885: or
886: (p_rec.role_id is null) then
887: --
880: nvl(p_rec.information28,hr_api.g_varchar2) or
881: nvl(pqh_rls_shd.g_old_rec.information29,hr_api.g_varchar2) <>
882: nvl(p_rec.information29,hr_api.g_varchar2) or
883: nvl(pqh_rls_shd.g_old_rec.information30,hr_api.g_varchar2) <>
884: nvl(p_rec.information30,hr_api.g_varchar2)))
885: or
886: (p_rec.role_id is null) then
887: --
888: -- Only execute the validation if absolutely necessary:
997: p_role_name => p_rec.role_name);
998: --
999: --
1000: if p_rec.business_group_id is not null then -- ** For Global Roles **
1001: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1002: end if;
1003: --
1004: --
1005: -- mvankada
1053: p_role_name => p_rec.role_name);
1054: --
1055: --
1056: if p_rec.business_group_id is not null then -- ** For Global Roles **
1057: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1058: end if;
1059: --
1060: chk_non_updateable_args
1061: (p_effective_date => p_effective_date