APPS.PQH_RLS_BUS dependencies on HR_API

Line 95: hr_api.mandatory_arg_error

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

Line 118: hr_api.set_security_group_id

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

Line 156: hr_api.mandatory_arg_error

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

Line 162: if ( nvl(pqh_rls_bus.g_role_id,hr_api.g_number)

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

Line 256: hr_api.argument_changed_error

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;

Line 307: and nvl(p_role_id,hr_api.g_number)

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

Line 389: <> nvl(pqh_rls_shd.g_old_rec.enable_flag,hr_api.g_varchar2)

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.

Line 395: if hr_api.not_exists_in_hr_lookups

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

Line 488: <> nvl(pqh_rls_shd.g_old_rec.role_type_cd,hr_api.g_varchar2)

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.

Line 494: if hr_api.not_exists_in_hr_lookups

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

Line 823: nvl(pqh_rls_shd.g_old_rec.information_category,hr_api.g_varchar2) <>

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

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

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

Line 825: nvl(pqh_rls_shd.g_old_rec.information1,hr_api.g_varchar2) <>

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

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

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

Line 827: nvl(pqh_rls_shd.g_old_rec.information2,hr_api.g_varchar2) <>

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

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

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

Line 829: nvl(pqh_rls_shd.g_old_rec.information3,hr_api.g_varchar2) <>

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

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

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

Line 831: nvl(pqh_rls_shd.g_old_rec.information4,hr_api.g_varchar2) <>

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

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

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

Line 833: nvl(pqh_rls_shd.g_old_rec.information5,hr_api.g_varchar2) <>

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

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

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

Line 835: nvl(pqh_rls_shd.g_old_rec.information6,hr_api.g_varchar2) <>

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

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

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

Line 837: nvl(pqh_rls_shd.g_old_rec.information7,hr_api.g_varchar2) <>

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

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

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

Line 839: nvl(pqh_rls_shd.g_old_rec.information8,hr_api.g_varchar2) <>

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

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

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

Line 841: nvl(pqh_rls_shd.g_old_rec.information9,hr_api.g_varchar2) <>

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

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

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

Line 843: nvl(pqh_rls_shd.g_old_rec.information10,hr_api.g_varchar2) <>

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

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

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

Line 845: nvl(pqh_rls_shd.g_old_rec.information11,hr_api.g_varchar2) <>

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

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

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

Line 847: nvl(pqh_rls_shd.g_old_rec.information12,hr_api.g_varchar2) <>

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

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

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

Line 849: nvl(pqh_rls_shd.g_old_rec.information13,hr_api.g_varchar2) <>

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

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

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

Line 851: nvl(pqh_rls_shd.g_old_rec.information14,hr_api.g_varchar2) <>

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

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

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

Line 853: nvl(pqh_rls_shd.g_old_rec.information15,hr_api.g_varchar2) <>

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

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

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

Line 855: nvl(pqh_rls_shd.g_old_rec.information16,hr_api.g_varchar2) <>

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

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

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

Line 857: nvl(pqh_rls_shd.g_old_rec.information17,hr_api.g_varchar2) <>

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

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

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

Line 859: nvl(pqh_rls_shd.g_old_rec.information18,hr_api.g_varchar2) <>

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

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

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

Line 861: nvl(pqh_rls_shd.g_old_rec.information19,hr_api.g_varchar2) <>

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

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

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

Line 863: nvl(pqh_rls_shd.g_old_rec.information20,hr_api.g_varchar2) <>

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

Line 864: nvl(p_rec.information20,hr_api.g_varchar2) or

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

Line 865: nvl(pqh_rls_shd.g_old_rec.information21,hr_api.g_varchar2) <>

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

Line 866: nvl(p_rec.information21,hr_api.g_varchar2) or

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

Line 867: nvl(pqh_rls_shd.g_old_rec.information22,hr_api.g_varchar2) <>

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

Line 868: nvl(p_rec.information22,hr_api.g_varchar2) or

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

Line 869: nvl(pqh_rls_shd.g_old_rec.information23,hr_api.g_varchar2) <>

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

Line 870: nvl(p_rec.information23,hr_api.g_varchar2) or

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

Line 871: nvl(pqh_rls_shd.g_old_rec.information24,hr_api.g_varchar2) <>

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

Line 872: nvl(p_rec.information24,hr_api.g_varchar2) or

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

Line 873: nvl(pqh_rls_shd.g_old_rec.information25,hr_api.g_varchar2) <>

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

Line 874: nvl(p_rec.information25,hr_api.g_varchar2) or

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

Line 875: nvl(pqh_rls_shd.g_old_rec.information26,hr_api.g_varchar2) <>

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

Line 876: nvl(p_rec.information26,hr_api.g_varchar2) or

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

Line 877: nvl(pqh_rls_shd.g_old_rec.information27,hr_api.g_varchar2) <>

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

Line 878: nvl(p_rec.information27,hr_api.g_varchar2) or

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

Line 879: nvl(pqh_rls_shd.g_old_rec.information28,hr_api.g_varchar2) <>

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

Line 880: nvl(p_rec.information28,hr_api.g_varchar2) or

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

Line 881: nvl(pqh_rls_shd.g_old_rec.information29,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

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

Line 883: nvl(pqh_rls_shd.g_old_rec.information30,hr_api.g_varchar2) <>

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

Line 884: nvl(p_rec.information30,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: --
888: -- Only execute the validation if absolutely necessary:

Line 1001: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

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

Line 1057: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

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