APPS.PQH_RLS_BUS dependencies on PQH_RLS_SHD

Line 229: p_rec in pqh_rls_shd.g_rec_type

225: -- {End Of Comments}
226: -- ----------------------------------------------------------------------------
227: Procedure chk_non_updateable_args
228: (p_effective_date in date,
229: p_rec in pqh_rls_shd.g_rec_type
230: ) IS
231: --
232: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
233: l_error EXCEPTION;

Line 241: IF NOT pqh_rls_shd.api_updating

237: --
238: -- Only proceed with the validation if a row exists for the current
239: -- record in the HR Schema.
240: --
241: IF NOT pqh_rls_shd.api_updating
242: (p_role_id => p_rec.role_id
243: ,p_object_version_number => p_rec.object_version_number
244: ) THEN
245: fnd_message.set_name('PER','HR_6153_ALL_PROCEDURE_FAIL');

Line 302: l_api_updating := pqh_rls_shd.api_updating

298: Begin
299: --
300: hr_utility.set_location('Entering:'||l_proc,5);
301: --
302: l_api_updating := pqh_rls_shd.api_updating
303: (p_role_id => p_role_id,
304: p_object_version_number => p_object_version_number);
305: --
306: if (l_api_updating

Line 308: <> pqh_rls_shd.g_old_rec.role_id) then

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: --
312: pqh_rls_shd.constraint_error('PQH_ROLES_PK');

Line 312: pqh_rls_shd.constraint_error('PQH_ROLES_PK');

308: <> pqh_rls_shd.g_old_rec.role_id) then
309: --
310: -- raise error as PK has changed
311: --
312: pqh_rls_shd.constraint_error('PQH_ROLES_PK');
313: --
314: elsif not l_api_updating then
315: --
316: -- check if PK is null

Line 322: pqh_rls_shd.constraint_error('PQH_ROLES_PK');

318: if p_role_id is not null then
319: --
320: -- raise error as PK is not null
321: --
322: pqh_rls_shd.constraint_error('PQH_ROLES_PK');
323: --
324: end if;
325: --
326: end if;

Line 383: l_api_updating := pqh_rls_shd.api_updating

379: Begin
380: --
381: hr_utility.set_location('Entering:'||l_proc,5);
382: --
383: l_api_updating := pqh_rls_shd.api_updating
384: (p_role_id => p_role_id,
385: p_object_version_number => p_object_version_number);
386: --
387: if (l_api_updating

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 482: l_api_updating := pqh_rls_shd.api_updating

478: Begin
479: --
480: hr_utility.set_location('Entering:'||l_proc,5);
481: --
482: l_api_updating := pqh_rls_shd.api_updating
483: (p_role_id => p_role_id,
484: p_object_version_number => p_object_version_number);
485: --
486: if (l_api_updating

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 814: ( p_rec in pqh_rls_shd.g_rec_type) is

810: -- Access Status:
811: -- Internal Row Handler Use Only.
812: --
813: procedure chk_ddf
814: ( p_rec in pqh_rls_shd.g_rec_type) is
815: --
816: l_proc varchar2(72) := g_package||'chk_ddf';
817: --
818: begin

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 969: ,p_rec in pqh_rls_shd.g_rec_type

965: -- |---------------------------< insert_validate >----------------------------|
966: -- ----------------------------------------------------------------------------
967: Procedure insert_validate
968: (p_effective_date in date
969: ,p_rec in pqh_rls_shd.g_rec_type
970: ) is
971: --
972: l_proc varchar2(72) := g_package||'insert_validate';
973: --

Line 1025: ,p_rec in pqh_rls_shd.g_rec_type

1021: -- |---------------------------< update_validate >----------------------------|
1022: -- ----------------------------------------------------------------------------
1023: Procedure update_validate
1024: (p_effective_date in date
1025: ,p_rec in pqh_rls_shd.g_rec_type
1026: ) is
1027: --
1028: l_proc varchar2(72) := g_package||'update_validate';
1029: --

Line 1086: (p_rec in pqh_rls_shd.g_rec_type

1082: -- ----------------------------------------------------------------------------
1083: -- |---------------------------< delete_validate >----------------------------|
1084: -- ----------------------------------------------------------------------------
1085: Procedure delete_validate
1086: (p_rec in pqh_rls_shd.g_rec_type
1087: ,p_effective_date in date
1088: ) is
1089: --
1090: l_proc varchar2(72) := g_package||'delete_validate';