APPS.PER_ROL_BUS dependencies on HR_API

Line 47: hr_api.mandatory_arg_error

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

Line 70: hr_api.set_security_group_id

66: close csr_sec_grp;
67: --
68: -- Set the security_group_id in CLIENT_INFO
69: --
70: hr_api.set_security_group_id
71: (p_security_group_id => l_security_group_id
72: );
73: --
74: hr_utility.set_location(' Leaving:'|| l_proc, 20);

Line 109: hr_api.mandatory_arg_error

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

Line 115: if ( nvl(per_rol_bus.g_role_id, hr_api.g_number)

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

Line 555: nvl(per_rol_shd.g_old_rec.role_information_category, hr_api.g_varchar2) <>

551: begin
552: hr_utility.set_location('Entering:'||l_proc,10);
553: --
554: if ((p_rec.role_id is not null) and (
555: nvl(per_rol_shd.g_old_rec.role_information_category, hr_api.g_varchar2) <>
556: nvl(p_rec.role_information_category, hr_api.g_varchar2) or
557: nvl(per_rol_shd.g_old_rec.role_information1, hr_api.g_varchar2) <>
558: nvl(p_rec.role_information1, hr_api.g_varchar2) or
559: nvl(per_rol_shd.g_old_rec.role_information2, hr_api.g_varchar2) <>

Line 556: nvl(p_rec.role_information_category, hr_api.g_varchar2) or

552: hr_utility.set_location('Entering:'||l_proc,10);
553: --
554: if ((p_rec.role_id is not null) and (
555: nvl(per_rol_shd.g_old_rec.role_information_category, hr_api.g_varchar2) <>
556: nvl(p_rec.role_information_category, hr_api.g_varchar2) or
557: nvl(per_rol_shd.g_old_rec.role_information1, hr_api.g_varchar2) <>
558: nvl(p_rec.role_information1, hr_api.g_varchar2) or
559: nvl(per_rol_shd.g_old_rec.role_information2, hr_api.g_varchar2) <>
560: nvl(p_rec.role_information2, hr_api.g_varchar2) or

Line 557: nvl(per_rol_shd.g_old_rec.role_information1, hr_api.g_varchar2) <>

553: --
554: if ((p_rec.role_id is not null) and (
555: nvl(per_rol_shd.g_old_rec.role_information_category, hr_api.g_varchar2) <>
556: nvl(p_rec.role_information_category, hr_api.g_varchar2) or
557: nvl(per_rol_shd.g_old_rec.role_information1, hr_api.g_varchar2) <>
558: nvl(p_rec.role_information1, hr_api.g_varchar2) or
559: nvl(per_rol_shd.g_old_rec.role_information2, hr_api.g_varchar2) <>
560: nvl(p_rec.role_information2, hr_api.g_varchar2) or
561: nvl(per_rol_shd.g_old_rec.role_information3, hr_api.g_varchar2) <>

Line 558: nvl(p_rec.role_information1, hr_api.g_varchar2) or

554: if ((p_rec.role_id is not null) and (
555: nvl(per_rol_shd.g_old_rec.role_information_category, hr_api.g_varchar2) <>
556: nvl(p_rec.role_information_category, hr_api.g_varchar2) or
557: nvl(per_rol_shd.g_old_rec.role_information1, hr_api.g_varchar2) <>
558: nvl(p_rec.role_information1, hr_api.g_varchar2) or
559: nvl(per_rol_shd.g_old_rec.role_information2, hr_api.g_varchar2) <>
560: nvl(p_rec.role_information2, hr_api.g_varchar2) or
561: nvl(per_rol_shd.g_old_rec.role_information3, hr_api.g_varchar2) <>
562: nvl(p_rec.role_information3, hr_api.g_varchar2) or

Line 559: nvl(per_rol_shd.g_old_rec.role_information2, hr_api.g_varchar2) <>

555: nvl(per_rol_shd.g_old_rec.role_information_category, hr_api.g_varchar2) <>
556: nvl(p_rec.role_information_category, hr_api.g_varchar2) or
557: nvl(per_rol_shd.g_old_rec.role_information1, hr_api.g_varchar2) <>
558: nvl(p_rec.role_information1, hr_api.g_varchar2) or
559: nvl(per_rol_shd.g_old_rec.role_information2, hr_api.g_varchar2) <>
560: nvl(p_rec.role_information2, hr_api.g_varchar2) or
561: nvl(per_rol_shd.g_old_rec.role_information3, hr_api.g_varchar2) <>
562: nvl(p_rec.role_information3, hr_api.g_varchar2) or
563: nvl(per_rol_shd.g_old_rec.role_information4, hr_api.g_varchar2) <>

Line 560: nvl(p_rec.role_information2, hr_api.g_varchar2) or

556: nvl(p_rec.role_information_category, hr_api.g_varchar2) or
557: nvl(per_rol_shd.g_old_rec.role_information1, hr_api.g_varchar2) <>
558: nvl(p_rec.role_information1, hr_api.g_varchar2) or
559: nvl(per_rol_shd.g_old_rec.role_information2, hr_api.g_varchar2) <>
560: nvl(p_rec.role_information2, hr_api.g_varchar2) or
561: nvl(per_rol_shd.g_old_rec.role_information3, hr_api.g_varchar2) <>
562: nvl(p_rec.role_information3, hr_api.g_varchar2) or
563: nvl(per_rol_shd.g_old_rec.role_information4, hr_api.g_varchar2) <>
564: nvl(p_rec.role_information4, hr_api.g_varchar2) or

Line 561: nvl(per_rol_shd.g_old_rec.role_information3, hr_api.g_varchar2) <>

557: nvl(per_rol_shd.g_old_rec.role_information1, hr_api.g_varchar2) <>
558: nvl(p_rec.role_information1, hr_api.g_varchar2) or
559: nvl(per_rol_shd.g_old_rec.role_information2, hr_api.g_varchar2) <>
560: nvl(p_rec.role_information2, hr_api.g_varchar2) or
561: nvl(per_rol_shd.g_old_rec.role_information3, hr_api.g_varchar2) <>
562: nvl(p_rec.role_information3, hr_api.g_varchar2) or
563: nvl(per_rol_shd.g_old_rec.role_information4, hr_api.g_varchar2) <>
564: nvl(p_rec.role_information4, hr_api.g_varchar2) or
565: nvl(per_rol_shd.g_old_rec.role_information5, hr_api.g_varchar2) <>

Line 562: nvl(p_rec.role_information3, hr_api.g_varchar2) or

558: nvl(p_rec.role_information1, hr_api.g_varchar2) or
559: nvl(per_rol_shd.g_old_rec.role_information2, hr_api.g_varchar2) <>
560: nvl(p_rec.role_information2, hr_api.g_varchar2) or
561: nvl(per_rol_shd.g_old_rec.role_information3, hr_api.g_varchar2) <>
562: nvl(p_rec.role_information3, hr_api.g_varchar2) or
563: nvl(per_rol_shd.g_old_rec.role_information4, hr_api.g_varchar2) <>
564: nvl(p_rec.role_information4, hr_api.g_varchar2) or
565: nvl(per_rol_shd.g_old_rec.role_information5, hr_api.g_varchar2) <>
566: nvl(p_rec.role_information5, hr_api.g_varchar2) or

Line 563: nvl(per_rol_shd.g_old_rec.role_information4, hr_api.g_varchar2) <>

559: nvl(per_rol_shd.g_old_rec.role_information2, hr_api.g_varchar2) <>
560: nvl(p_rec.role_information2, hr_api.g_varchar2) or
561: nvl(per_rol_shd.g_old_rec.role_information3, hr_api.g_varchar2) <>
562: nvl(p_rec.role_information3, hr_api.g_varchar2) or
563: nvl(per_rol_shd.g_old_rec.role_information4, hr_api.g_varchar2) <>
564: nvl(p_rec.role_information4, hr_api.g_varchar2) or
565: nvl(per_rol_shd.g_old_rec.role_information5, hr_api.g_varchar2) <>
566: nvl(p_rec.role_information5, hr_api.g_varchar2) or
567: nvl(per_rol_shd.g_old_rec.role_information6, hr_api.g_varchar2) <>

Line 564: nvl(p_rec.role_information4, hr_api.g_varchar2) or

560: nvl(p_rec.role_information2, hr_api.g_varchar2) or
561: nvl(per_rol_shd.g_old_rec.role_information3, hr_api.g_varchar2) <>
562: nvl(p_rec.role_information3, hr_api.g_varchar2) or
563: nvl(per_rol_shd.g_old_rec.role_information4, hr_api.g_varchar2) <>
564: nvl(p_rec.role_information4, hr_api.g_varchar2) or
565: nvl(per_rol_shd.g_old_rec.role_information5, hr_api.g_varchar2) <>
566: nvl(p_rec.role_information5, hr_api.g_varchar2) or
567: nvl(per_rol_shd.g_old_rec.role_information6, hr_api.g_varchar2) <>
568: nvl(p_rec.role_information6, hr_api.g_varchar2) or

Line 565: nvl(per_rol_shd.g_old_rec.role_information5, hr_api.g_varchar2) <>

561: nvl(per_rol_shd.g_old_rec.role_information3, hr_api.g_varchar2) <>
562: nvl(p_rec.role_information3, hr_api.g_varchar2) or
563: nvl(per_rol_shd.g_old_rec.role_information4, hr_api.g_varchar2) <>
564: nvl(p_rec.role_information4, hr_api.g_varchar2) or
565: nvl(per_rol_shd.g_old_rec.role_information5, hr_api.g_varchar2) <>
566: nvl(p_rec.role_information5, hr_api.g_varchar2) or
567: nvl(per_rol_shd.g_old_rec.role_information6, hr_api.g_varchar2) <>
568: nvl(p_rec.role_information6, hr_api.g_varchar2) or
569: nvl(per_rol_shd.g_old_rec.role_information7, hr_api.g_varchar2) <>

Line 566: nvl(p_rec.role_information5, hr_api.g_varchar2) or

562: nvl(p_rec.role_information3, hr_api.g_varchar2) or
563: nvl(per_rol_shd.g_old_rec.role_information4, hr_api.g_varchar2) <>
564: nvl(p_rec.role_information4, hr_api.g_varchar2) or
565: nvl(per_rol_shd.g_old_rec.role_information5, hr_api.g_varchar2) <>
566: nvl(p_rec.role_information5, hr_api.g_varchar2) or
567: nvl(per_rol_shd.g_old_rec.role_information6, hr_api.g_varchar2) <>
568: nvl(p_rec.role_information6, hr_api.g_varchar2) or
569: nvl(per_rol_shd.g_old_rec.role_information7, hr_api.g_varchar2) <>
570: nvl(p_rec.role_information7, hr_api.g_varchar2) or

Line 567: nvl(per_rol_shd.g_old_rec.role_information6, hr_api.g_varchar2) <>

563: nvl(per_rol_shd.g_old_rec.role_information4, hr_api.g_varchar2) <>
564: nvl(p_rec.role_information4, hr_api.g_varchar2) or
565: nvl(per_rol_shd.g_old_rec.role_information5, hr_api.g_varchar2) <>
566: nvl(p_rec.role_information5, hr_api.g_varchar2) or
567: nvl(per_rol_shd.g_old_rec.role_information6, hr_api.g_varchar2) <>
568: nvl(p_rec.role_information6, hr_api.g_varchar2) or
569: nvl(per_rol_shd.g_old_rec.role_information7, hr_api.g_varchar2) <>
570: nvl(p_rec.role_information7, hr_api.g_varchar2) or
571: nvl(per_rol_shd.g_old_rec.role_information8, hr_api.g_varchar2) <>

Line 568: nvl(p_rec.role_information6, hr_api.g_varchar2) or

564: nvl(p_rec.role_information4, hr_api.g_varchar2) or
565: nvl(per_rol_shd.g_old_rec.role_information5, hr_api.g_varchar2) <>
566: nvl(p_rec.role_information5, hr_api.g_varchar2) or
567: nvl(per_rol_shd.g_old_rec.role_information6, hr_api.g_varchar2) <>
568: nvl(p_rec.role_information6, hr_api.g_varchar2) or
569: nvl(per_rol_shd.g_old_rec.role_information7, hr_api.g_varchar2) <>
570: nvl(p_rec.role_information7, hr_api.g_varchar2) or
571: nvl(per_rol_shd.g_old_rec.role_information8, hr_api.g_varchar2) <>
572: nvl(p_rec.role_information8, hr_api.g_varchar2) or

Line 569: nvl(per_rol_shd.g_old_rec.role_information7, hr_api.g_varchar2) <>

565: nvl(per_rol_shd.g_old_rec.role_information5, hr_api.g_varchar2) <>
566: nvl(p_rec.role_information5, hr_api.g_varchar2) or
567: nvl(per_rol_shd.g_old_rec.role_information6, hr_api.g_varchar2) <>
568: nvl(p_rec.role_information6, hr_api.g_varchar2) or
569: nvl(per_rol_shd.g_old_rec.role_information7, hr_api.g_varchar2) <>
570: nvl(p_rec.role_information7, hr_api.g_varchar2) or
571: nvl(per_rol_shd.g_old_rec.role_information8, hr_api.g_varchar2) <>
572: nvl(p_rec.role_information8, hr_api.g_varchar2) or
573: nvl(per_rol_shd.g_old_rec.role_information9, hr_api.g_varchar2) <>

Line 570: nvl(p_rec.role_information7, hr_api.g_varchar2) or

566: nvl(p_rec.role_information5, hr_api.g_varchar2) or
567: nvl(per_rol_shd.g_old_rec.role_information6, hr_api.g_varchar2) <>
568: nvl(p_rec.role_information6, hr_api.g_varchar2) or
569: nvl(per_rol_shd.g_old_rec.role_information7, hr_api.g_varchar2) <>
570: nvl(p_rec.role_information7, hr_api.g_varchar2) or
571: nvl(per_rol_shd.g_old_rec.role_information8, hr_api.g_varchar2) <>
572: nvl(p_rec.role_information8, hr_api.g_varchar2) or
573: nvl(per_rol_shd.g_old_rec.role_information9, hr_api.g_varchar2) <>
574: nvl(p_rec.role_information9, hr_api.g_varchar2) or

Line 571: nvl(per_rol_shd.g_old_rec.role_information8, hr_api.g_varchar2) <>

567: nvl(per_rol_shd.g_old_rec.role_information6, hr_api.g_varchar2) <>
568: nvl(p_rec.role_information6, hr_api.g_varchar2) or
569: nvl(per_rol_shd.g_old_rec.role_information7, hr_api.g_varchar2) <>
570: nvl(p_rec.role_information7, hr_api.g_varchar2) or
571: nvl(per_rol_shd.g_old_rec.role_information8, hr_api.g_varchar2) <>
572: nvl(p_rec.role_information8, hr_api.g_varchar2) or
573: nvl(per_rol_shd.g_old_rec.role_information9, hr_api.g_varchar2) <>
574: nvl(p_rec.role_information9, hr_api.g_varchar2) or
575: nvl(per_rol_shd.g_old_rec.role_information10, hr_api.g_varchar2) <>

Line 572: nvl(p_rec.role_information8, hr_api.g_varchar2) or

568: nvl(p_rec.role_information6, hr_api.g_varchar2) or
569: nvl(per_rol_shd.g_old_rec.role_information7, hr_api.g_varchar2) <>
570: nvl(p_rec.role_information7, hr_api.g_varchar2) or
571: nvl(per_rol_shd.g_old_rec.role_information8, hr_api.g_varchar2) <>
572: nvl(p_rec.role_information8, hr_api.g_varchar2) or
573: nvl(per_rol_shd.g_old_rec.role_information9, hr_api.g_varchar2) <>
574: nvl(p_rec.role_information9, hr_api.g_varchar2) or
575: nvl(per_rol_shd.g_old_rec.role_information10, hr_api.g_varchar2) <>
576: nvl(p_rec.role_information10, hr_api.g_varchar2) or

Line 573: nvl(per_rol_shd.g_old_rec.role_information9, hr_api.g_varchar2) <>

569: nvl(per_rol_shd.g_old_rec.role_information7, hr_api.g_varchar2) <>
570: nvl(p_rec.role_information7, hr_api.g_varchar2) or
571: nvl(per_rol_shd.g_old_rec.role_information8, hr_api.g_varchar2) <>
572: nvl(p_rec.role_information8, hr_api.g_varchar2) or
573: nvl(per_rol_shd.g_old_rec.role_information9, hr_api.g_varchar2) <>
574: nvl(p_rec.role_information9, hr_api.g_varchar2) or
575: nvl(per_rol_shd.g_old_rec.role_information10, hr_api.g_varchar2) <>
576: nvl(p_rec.role_information10, hr_api.g_varchar2) or
577: nvl(per_rol_shd.g_old_rec.role_information11, hr_api.g_varchar2) <>

Line 574: nvl(p_rec.role_information9, hr_api.g_varchar2) or

570: nvl(p_rec.role_information7, hr_api.g_varchar2) or
571: nvl(per_rol_shd.g_old_rec.role_information8, hr_api.g_varchar2) <>
572: nvl(p_rec.role_information8, hr_api.g_varchar2) or
573: nvl(per_rol_shd.g_old_rec.role_information9, hr_api.g_varchar2) <>
574: nvl(p_rec.role_information9, hr_api.g_varchar2) or
575: nvl(per_rol_shd.g_old_rec.role_information10, hr_api.g_varchar2) <>
576: nvl(p_rec.role_information10, hr_api.g_varchar2) or
577: nvl(per_rol_shd.g_old_rec.role_information11, hr_api.g_varchar2) <>
578: nvl(p_rec.role_information11, hr_api.g_varchar2) or

Line 575: nvl(per_rol_shd.g_old_rec.role_information10, hr_api.g_varchar2) <>

571: nvl(per_rol_shd.g_old_rec.role_information8, hr_api.g_varchar2) <>
572: nvl(p_rec.role_information8, hr_api.g_varchar2) or
573: nvl(per_rol_shd.g_old_rec.role_information9, hr_api.g_varchar2) <>
574: nvl(p_rec.role_information9, hr_api.g_varchar2) or
575: nvl(per_rol_shd.g_old_rec.role_information10, hr_api.g_varchar2) <>
576: nvl(p_rec.role_information10, hr_api.g_varchar2) or
577: nvl(per_rol_shd.g_old_rec.role_information11, hr_api.g_varchar2) <>
578: nvl(p_rec.role_information11, hr_api.g_varchar2) or
579: nvl(per_rol_shd.g_old_rec.role_information12, hr_api.g_varchar2) <>

Line 576: nvl(p_rec.role_information10, hr_api.g_varchar2) or

572: nvl(p_rec.role_information8, hr_api.g_varchar2) or
573: nvl(per_rol_shd.g_old_rec.role_information9, hr_api.g_varchar2) <>
574: nvl(p_rec.role_information9, hr_api.g_varchar2) or
575: nvl(per_rol_shd.g_old_rec.role_information10, hr_api.g_varchar2) <>
576: nvl(p_rec.role_information10, hr_api.g_varchar2) or
577: nvl(per_rol_shd.g_old_rec.role_information11, hr_api.g_varchar2) <>
578: nvl(p_rec.role_information11, hr_api.g_varchar2) or
579: nvl(per_rol_shd.g_old_rec.role_information12, hr_api.g_varchar2) <>
580: nvl(p_rec.role_information12, hr_api.g_varchar2) or

Line 577: nvl(per_rol_shd.g_old_rec.role_information11, hr_api.g_varchar2) <>

573: nvl(per_rol_shd.g_old_rec.role_information9, hr_api.g_varchar2) <>
574: nvl(p_rec.role_information9, hr_api.g_varchar2) or
575: nvl(per_rol_shd.g_old_rec.role_information10, hr_api.g_varchar2) <>
576: nvl(p_rec.role_information10, hr_api.g_varchar2) or
577: nvl(per_rol_shd.g_old_rec.role_information11, hr_api.g_varchar2) <>
578: nvl(p_rec.role_information11, hr_api.g_varchar2) or
579: nvl(per_rol_shd.g_old_rec.role_information12, hr_api.g_varchar2) <>
580: nvl(p_rec.role_information12, hr_api.g_varchar2) or
581: nvl(per_rol_shd.g_old_rec.role_information13, hr_api.g_varchar2) <>

Line 578: nvl(p_rec.role_information11, hr_api.g_varchar2) or

574: nvl(p_rec.role_information9, hr_api.g_varchar2) or
575: nvl(per_rol_shd.g_old_rec.role_information10, hr_api.g_varchar2) <>
576: nvl(p_rec.role_information10, hr_api.g_varchar2) or
577: nvl(per_rol_shd.g_old_rec.role_information11, hr_api.g_varchar2) <>
578: nvl(p_rec.role_information11, hr_api.g_varchar2) or
579: nvl(per_rol_shd.g_old_rec.role_information12, hr_api.g_varchar2) <>
580: nvl(p_rec.role_information12, hr_api.g_varchar2) or
581: nvl(per_rol_shd.g_old_rec.role_information13, hr_api.g_varchar2) <>
582: nvl(p_rec.role_information13, hr_api.g_varchar2) or

Line 579: nvl(per_rol_shd.g_old_rec.role_information12, hr_api.g_varchar2) <>

575: nvl(per_rol_shd.g_old_rec.role_information10, hr_api.g_varchar2) <>
576: nvl(p_rec.role_information10, hr_api.g_varchar2) or
577: nvl(per_rol_shd.g_old_rec.role_information11, hr_api.g_varchar2) <>
578: nvl(p_rec.role_information11, hr_api.g_varchar2) or
579: nvl(per_rol_shd.g_old_rec.role_information12, hr_api.g_varchar2) <>
580: nvl(p_rec.role_information12, hr_api.g_varchar2) or
581: nvl(per_rol_shd.g_old_rec.role_information13, hr_api.g_varchar2) <>
582: nvl(p_rec.role_information13, hr_api.g_varchar2) or
583: nvl(per_rol_shd.g_old_rec.role_information14, hr_api.g_varchar2) <>

Line 580: nvl(p_rec.role_information12, hr_api.g_varchar2) or

576: nvl(p_rec.role_information10, hr_api.g_varchar2) or
577: nvl(per_rol_shd.g_old_rec.role_information11, hr_api.g_varchar2) <>
578: nvl(p_rec.role_information11, hr_api.g_varchar2) or
579: nvl(per_rol_shd.g_old_rec.role_information12, hr_api.g_varchar2) <>
580: nvl(p_rec.role_information12, hr_api.g_varchar2) or
581: nvl(per_rol_shd.g_old_rec.role_information13, hr_api.g_varchar2) <>
582: nvl(p_rec.role_information13, hr_api.g_varchar2) or
583: nvl(per_rol_shd.g_old_rec.role_information14, hr_api.g_varchar2) <>
584: nvl(p_rec.role_information14, hr_api.g_varchar2) or

Line 581: nvl(per_rol_shd.g_old_rec.role_information13, hr_api.g_varchar2) <>

577: nvl(per_rol_shd.g_old_rec.role_information11, hr_api.g_varchar2) <>
578: nvl(p_rec.role_information11, hr_api.g_varchar2) or
579: nvl(per_rol_shd.g_old_rec.role_information12, hr_api.g_varchar2) <>
580: nvl(p_rec.role_information12, hr_api.g_varchar2) or
581: nvl(per_rol_shd.g_old_rec.role_information13, hr_api.g_varchar2) <>
582: nvl(p_rec.role_information13, hr_api.g_varchar2) or
583: nvl(per_rol_shd.g_old_rec.role_information14, hr_api.g_varchar2) <>
584: nvl(p_rec.role_information14, hr_api.g_varchar2) or
585: nvl(per_rol_shd.g_old_rec.role_information15, hr_api.g_varchar2) <>

Line 582: nvl(p_rec.role_information13, hr_api.g_varchar2) or

578: nvl(p_rec.role_information11, hr_api.g_varchar2) or
579: nvl(per_rol_shd.g_old_rec.role_information12, hr_api.g_varchar2) <>
580: nvl(p_rec.role_information12, hr_api.g_varchar2) or
581: nvl(per_rol_shd.g_old_rec.role_information13, hr_api.g_varchar2) <>
582: nvl(p_rec.role_information13, hr_api.g_varchar2) or
583: nvl(per_rol_shd.g_old_rec.role_information14, hr_api.g_varchar2) <>
584: nvl(p_rec.role_information14, hr_api.g_varchar2) or
585: nvl(per_rol_shd.g_old_rec.role_information15, hr_api.g_varchar2) <>
586: nvl(p_rec.role_information15, hr_api.g_varchar2) or

Line 583: nvl(per_rol_shd.g_old_rec.role_information14, hr_api.g_varchar2) <>

579: nvl(per_rol_shd.g_old_rec.role_information12, hr_api.g_varchar2) <>
580: nvl(p_rec.role_information12, hr_api.g_varchar2) or
581: nvl(per_rol_shd.g_old_rec.role_information13, hr_api.g_varchar2) <>
582: nvl(p_rec.role_information13, hr_api.g_varchar2) or
583: nvl(per_rol_shd.g_old_rec.role_information14, hr_api.g_varchar2) <>
584: nvl(p_rec.role_information14, hr_api.g_varchar2) or
585: nvl(per_rol_shd.g_old_rec.role_information15, hr_api.g_varchar2) <>
586: nvl(p_rec.role_information15, hr_api.g_varchar2) or
587: nvl(per_rol_shd.g_old_rec.role_information16, hr_api.g_varchar2) <>

Line 584: nvl(p_rec.role_information14, hr_api.g_varchar2) or

580: nvl(p_rec.role_information12, hr_api.g_varchar2) or
581: nvl(per_rol_shd.g_old_rec.role_information13, hr_api.g_varchar2) <>
582: nvl(p_rec.role_information13, hr_api.g_varchar2) or
583: nvl(per_rol_shd.g_old_rec.role_information14, hr_api.g_varchar2) <>
584: nvl(p_rec.role_information14, hr_api.g_varchar2) or
585: nvl(per_rol_shd.g_old_rec.role_information15, hr_api.g_varchar2) <>
586: nvl(p_rec.role_information15, hr_api.g_varchar2) or
587: nvl(per_rol_shd.g_old_rec.role_information16, hr_api.g_varchar2) <>
588: nvl(p_rec.role_information16, hr_api.g_varchar2) or

Line 585: nvl(per_rol_shd.g_old_rec.role_information15, hr_api.g_varchar2) <>

581: nvl(per_rol_shd.g_old_rec.role_information13, hr_api.g_varchar2) <>
582: nvl(p_rec.role_information13, hr_api.g_varchar2) or
583: nvl(per_rol_shd.g_old_rec.role_information14, hr_api.g_varchar2) <>
584: nvl(p_rec.role_information14, hr_api.g_varchar2) or
585: nvl(per_rol_shd.g_old_rec.role_information15, hr_api.g_varchar2) <>
586: nvl(p_rec.role_information15, hr_api.g_varchar2) or
587: nvl(per_rol_shd.g_old_rec.role_information16, hr_api.g_varchar2) <>
588: nvl(p_rec.role_information16, hr_api.g_varchar2) or
589: nvl(per_rol_shd.g_old_rec.role_information17, hr_api.g_varchar2) <>

Line 586: nvl(p_rec.role_information15, hr_api.g_varchar2) or

582: nvl(p_rec.role_information13, hr_api.g_varchar2) or
583: nvl(per_rol_shd.g_old_rec.role_information14, hr_api.g_varchar2) <>
584: nvl(p_rec.role_information14, hr_api.g_varchar2) or
585: nvl(per_rol_shd.g_old_rec.role_information15, hr_api.g_varchar2) <>
586: nvl(p_rec.role_information15, hr_api.g_varchar2) or
587: nvl(per_rol_shd.g_old_rec.role_information16, hr_api.g_varchar2) <>
588: nvl(p_rec.role_information16, hr_api.g_varchar2) or
589: nvl(per_rol_shd.g_old_rec.role_information17, hr_api.g_varchar2) <>
590: nvl(p_rec.role_information17, hr_api.g_varchar2) or

Line 587: nvl(per_rol_shd.g_old_rec.role_information16, hr_api.g_varchar2) <>

583: nvl(per_rol_shd.g_old_rec.role_information14, hr_api.g_varchar2) <>
584: nvl(p_rec.role_information14, hr_api.g_varchar2) or
585: nvl(per_rol_shd.g_old_rec.role_information15, hr_api.g_varchar2) <>
586: nvl(p_rec.role_information15, hr_api.g_varchar2) or
587: nvl(per_rol_shd.g_old_rec.role_information16, hr_api.g_varchar2) <>
588: nvl(p_rec.role_information16, hr_api.g_varchar2) or
589: nvl(per_rol_shd.g_old_rec.role_information17, hr_api.g_varchar2) <>
590: nvl(p_rec.role_information17, hr_api.g_varchar2) or
591: nvl(per_rol_shd.g_old_rec.role_information18, hr_api.g_varchar2) <>

Line 588: nvl(p_rec.role_information16, hr_api.g_varchar2) or

584: nvl(p_rec.role_information14, hr_api.g_varchar2) or
585: nvl(per_rol_shd.g_old_rec.role_information15, hr_api.g_varchar2) <>
586: nvl(p_rec.role_information15, hr_api.g_varchar2) or
587: nvl(per_rol_shd.g_old_rec.role_information16, hr_api.g_varchar2) <>
588: nvl(p_rec.role_information16, hr_api.g_varchar2) or
589: nvl(per_rol_shd.g_old_rec.role_information17, hr_api.g_varchar2) <>
590: nvl(p_rec.role_information17, hr_api.g_varchar2) or
591: nvl(per_rol_shd.g_old_rec.role_information18, hr_api.g_varchar2) <>
592: nvl(p_rec.role_information18, hr_api.g_varchar2) or

Line 589: nvl(per_rol_shd.g_old_rec.role_information17, hr_api.g_varchar2) <>

585: nvl(per_rol_shd.g_old_rec.role_information15, hr_api.g_varchar2) <>
586: nvl(p_rec.role_information15, hr_api.g_varchar2) or
587: nvl(per_rol_shd.g_old_rec.role_information16, hr_api.g_varchar2) <>
588: nvl(p_rec.role_information16, hr_api.g_varchar2) or
589: nvl(per_rol_shd.g_old_rec.role_information17, hr_api.g_varchar2) <>
590: nvl(p_rec.role_information17, hr_api.g_varchar2) or
591: nvl(per_rol_shd.g_old_rec.role_information18, hr_api.g_varchar2) <>
592: nvl(p_rec.role_information18, hr_api.g_varchar2) or
593: nvl(per_rol_shd.g_old_rec.role_information19, hr_api.g_varchar2) <>

Line 590: nvl(p_rec.role_information17, hr_api.g_varchar2) or

586: nvl(p_rec.role_information15, hr_api.g_varchar2) or
587: nvl(per_rol_shd.g_old_rec.role_information16, hr_api.g_varchar2) <>
588: nvl(p_rec.role_information16, hr_api.g_varchar2) or
589: nvl(per_rol_shd.g_old_rec.role_information17, hr_api.g_varchar2) <>
590: nvl(p_rec.role_information17, hr_api.g_varchar2) or
591: nvl(per_rol_shd.g_old_rec.role_information18, hr_api.g_varchar2) <>
592: nvl(p_rec.role_information18, hr_api.g_varchar2) or
593: nvl(per_rol_shd.g_old_rec.role_information19, hr_api.g_varchar2) <>
594: nvl(p_rec.role_information19, hr_api.g_varchar2) or

Line 591: nvl(per_rol_shd.g_old_rec.role_information18, hr_api.g_varchar2) <>

587: nvl(per_rol_shd.g_old_rec.role_information16, hr_api.g_varchar2) <>
588: nvl(p_rec.role_information16, hr_api.g_varchar2) or
589: nvl(per_rol_shd.g_old_rec.role_information17, hr_api.g_varchar2) <>
590: nvl(p_rec.role_information17, hr_api.g_varchar2) or
591: nvl(per_rol_shd.g_old_rec.role_information18, hr_api.g_varchar2) <>
592: nvl(p_rec.role_information18, hr_api.g_varchar2) or
593: nvl(per_rol_shd.g_old_rec.role_information19, hr_api.g_varchar2) <>
594: nvl(p_rec.role_information19, hr_api.g_varchar2) or
595: nvl(per_rol_shd.g_old_rec.role_information20, hr_api.g_varchar2) <>

Line 592: nvl(p_rec.role_information18, hr_api.g_varchar2) or

588: nvl(p_rec.role_information16, hr_api.g_varchar2) or
589: nvl(per_rol_shd.g_old_rec.role_information17, hr_api.g_varchar2) <>
590: nvl(p_rec.role_information17, hr_api.g_varchar2) or
591: nvl(per_rol_shd.g_old_rec.role_information18, hr_api.g_varchar2) <>
592: nvl(p_rec.role_information18, hr_api.g_varchar2) or
593: nvl(per_rol_shd.g_old_rec.role_information19, hr_api.g_varchar2) <>
594: nvl(p_rec.role_information19, hr_api.g_varchar2) or
595: nvl(per_rol_shd.g_old_rec.role_information20, hr_api.g_varchar2) <>
596: nvl(p_rec.role_information20, hr_api.g_varchar2) ))

Line 593: nvl(per_rol_shd.g_old_rec.role_information19, hr_api.g_varchar2) <>

589: nvl(per_rol_shd.g_old_rec.role_information17, hr_api.g_varchar2) <>
590: nvl(p_rec.role_information17, hr_api.g_varchar2) or
591: nvl(per_rol_shd.g_old_rec.role_information18, hr_api.g_varchar2) <>
592: nvl(p_rec.role_information18, hr_api.g_varchar2) or
593: nvl(per_rol_shd.g_old_rec.role_information19, hr_api.g_varchar2) <>
594: nvl(p_rec.role_information19, hr_api.g_varchar2) or
595: nvl(per_rol_shd.g_old_rec.role_information20, hr_api.g_varchar2) <>
596: nvl(p_rec.role_information20, hr_api.g_varchar2) ))
597: or (p_rec.role_id is null) then

Line 594: nvl(p_rec.role_information19, hr_api.g_varchar2) or

590: nvl(p_rec.role_information17, hr_api.g_varchar2) or
591: nvl(per_rol_shd.g_old_rec.role_information18, hr_api.g_varchar2) <>
592: nvl(p_rec.role_information18, hr_api.g_varchar2) or
593: nvl(per_rol_shd.g_old_rec.role_information19, hr_api.g_varchar2) <>
594: nvl(p_rec.role_information19, hr_api.g_varchar2) or
595: nvl(per_rol_shd.g_old_rec.role_information20, hr_api.g_varchar2) <>
596: nvl(p_rec.role_information20, hr_api.g_varchar2) ))
597: or (p_rec.role_id is null) then
598: --

Line 595: nvl(per_rol_shd.g_old_rec.role_information20, hr_api.g_varchar2) <>

591: nvl(per_rol_shd.g_old_rec.role_information18, hr_api.g_varchar2) <>
592: nvl(p_rec.role_information18, hr_api.g_varchar2) or
593: nvl(per_rol_shd.g_old_rec.role_information19, hr_api.g_varchar2) <>
594: nvl(p_rec.role_information19, hr_api.g_varchar2) or
595: nvl(per_rol_shd.g_old_rec.role_information20, hr_api.g_varchar2) <>
596: nvl(p_rec.role_information20, hr_api.g_varchar2) ))
597: or (p_rec.role_id is null) then
598: --
599: -- Only execute the validation if absolutely necessary:

Line 596: nvl(p_rec.role_information20, hr_api.g_varchar2) ))

592: nvl(p_rec.role_information18, hr_api.g_varchar2) or
593: nvl(per_rol_shd.g_old_rec.role_information19, hr_api.g_varchar2) <>
594: nvl(p_rec.role_information19, hr_api.g_varchar2) or
595: nvl(per_rol_shd.g_old_rec.role_information20, hr_api.g_varchar2) <>
596: nvl(p_rec.role_information20, hr_api.g_varchar2) ))
597: or (p_rec.role_id is null) then
598: --
599: -- Only execute the validation if absolutely necessary:
600: -- a) During update, the structure column value or any

Line 692: nvl(per_rol_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

688: begin
689: hr_utility.set_location('Entering:'||l_proc,10);
690: --
691: if ((p_rec.role_id is not null) and (
692: nvl(per_rol_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
693: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
694: nvl(per_rol_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
695: nvl(p_rec.attribute1, hr_api.g_varchar2) or
696: nvl(per_rol_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

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

689: hr_utility.set_location('Entering:'||l_proc,10);
690: --
691: if ((p_rec.role_id is not null) and (
692: nvl(per_rol_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
693: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
694: nvl(per_rol_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
695: nvl(p_rec.attribute1, hr_api.g_varchar2) or
696: nvl(per_rol_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
697: nvl(p_rec.attribute2, hr_api.g_varchar2) or

Line 694: nvl(per_rol_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

690: --
691: if ((p_rec.role_id is not null) and (
692: nvl(per_rol_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
693: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
694: nvl(per_rol_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
695: nvl(p_rec.attribute1, hr_api.g_varchar2) or
696: nvl(per_rol_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
697: nvl(p_rec.attribute2, hr_api.g_varchar2) or
698: nvl(per_rol_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

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

691: if ((p_rec.role_id is not null) and (
692: nvl(per_rol_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
693: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
694: nvl(per_rol_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
695: nvl(p_rec.attribute1, hr_api.g_varchar2) or
696: nvl(per_rol_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
697: nvl(p_rec.attribute2, hr_api.g_varchar2) or
698: nvl(per_rol_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
699: nvl(p_rec.attribute3, hr_api.g_varchar2) or

Line 696: nvl(per_rol_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

692: nvl(per_rol_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
693: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
694: nvl(per_rol_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
695: nvl(p_rec.attribute1, hr_api.g_varchar2) or
696: nvl(per_rol_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
697: nvl(p_rec.attribute2, hr_api.g_varchar2) or
698: nvl(per_rol_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
699: nvl(p_rec.attribute3, hr_api.g_varchar2) or
700: nvl(per_rol_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

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

693: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
694: nvl(per_rol_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
695: nvl(p_rec.attribute1, hr_api.g_varchar2) or
696: nvl(per_rol_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
697: nvl(p_rec.attribute2, hr_api.g_varchar2) or
698: nvl(per_rol_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
699: nvl(p_rec.attribute3, hr_api.g_varchar2) or
700: nvl(per_rol_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
701: nvl(p_rec.attribute4, hr_api.g_varchar2) or

Line 698: nvl(per_rol_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

694: nvl(per_rol_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
695: nvl(p_rec.attribute1, hr_api.g_varchar2) or
696: nvl(per_rol_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
697: nvl(p_rec.attribute2, hr_api.g_varchar2) or
698: nvl(per_rol_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
699: nvl(p_rec.attribute3, hr_api.g_varchar2) or
700: nvl(per_rol_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
701: nvl(p_rec.attribute4, hr_api.g_varchar2) or
702: nvl(per_rol_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

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

695: nvl(p_rec.attribute1, hr_api.g_varchar2) or
696: nvl(per_rol_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
697: nvl(p_rec.attribute2, hr_api.g_varchar2) or
698: nvl(per_rol_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
699: nvl(p_rec.attribute3, hr_api.g_varchar2) or
700: nvl(per_rol_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
701: nvl(p_rec.attribute4, hr_api.g_varchar2) or
702: nvl(per_rol_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
703: nvl(p_rec.attribute5, hr_api.g_varchar2) or

Line 700: nvl(per_rol_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

696: nvl(per_rol_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
697: nvl(p_rec.attribute2, hr_api.g_varchar2) or
698: nvl(per_rol_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
699: nvl(p_rec.attribute3, hr_api.g_varchar2) or
700: nvl(per_rol_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
701: nvl(p_rec.attribute4, hr_api.g_varchar2) or
702: nvl(per_rol_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
703: nvl(p_rec.attribute5, hr_api.g_varchar2) or
704: nvl(per_rol_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

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

697: nvl(p_rec.attribute2, hr_api.g_varchar2) or
698: nvl(per_rol_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
699: nvl(p_rec.attribute3, hr_api.g_varchar2) or
700: nvl(per_rol_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
701: nvl(p_rec.attribute4, hr_api.g_varchar2) or
702: nvl(per_rol_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
703: nvl(p_rec.attribute5, hr_api.g_varchar2) or
704: nvl(per_rol_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
705: nvl(p_rec.attribute6, hr_api.g_varchar2) or

Line 702: nvl(per_rol_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

698: nvl(per_rol_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
699: nvl(p_rec.attribute3, hr_api.g_varchar2) or
700: nvl(per_rol_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
701: nvl(p_rec.attribute4, hr_api.g_varchar2) or
702: nvl(per_rol_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
703: nvl(p_rec.attribute5, hr_api.g_varchar2) or
704: nvl(per_rol_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
705: nvl(p_rec.attribute6, hr_api.g_varchar2) or
706: nvl(per_rol_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

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

699: nvl(p_rec.attribute3, hr_api.g_varchar2) or
700: nvl(per_rol_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
701: nvl(p_rec.attribute4, hr_api.g_varchar2) or
702: nvl(per_rol_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
703: nvl(p_rec.attribute5, hr_api.g_varchar2) or
704: nvl(per_rol_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
705: nvl(p_rec.attribute6, hr_api.g_varchar2) or
706: nvl(per_rol_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
707: nvl(p_rec.attribute7, hr_api.g_varchar2) or

Line 704: nvl(per_rol_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

700: nvl(per_rol_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
701: nvl(p_rec.attribute4, hr_api.g_varchar2) or
702: nvl(per_rol_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
703: nvl(p_rec.attribute5, hr_api.g_varchar2) or
704: nvl(per_rol_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
705: nvl(p_rec.attribute6, hr_api.g_varchar2) or
706: nvl(per_rol_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
707: nvl(p_rec.attribute7, hr_api.g_varchar2) or
708: nvl(per_rol_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

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

701: nvl(p_rec.attribute4, hr_api.g_varchar2) or
702: nvl(per_rol_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
703: nvl(p_rec.attribute5, hr_api.g_varchar2) or
704: nvl(per_rol_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
705: nvl(p_rec.attribute6, hr_api.g_varchar2) or
706: nvl(per_rol_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
707: nvl(p_rec.attribute7, hr_api.g_varchar2) or
708: nvl(per_rol_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
709: nvl(p_rec.attribute8, hr_api.g_varchar2) or

Line 706: nvl(per_rol_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

702: nvl(per_rol_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
703: nvl(p_rec.attribute5, hr_api.g_varchar2) or
704: nvl(per_rol_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
705: nvl(p_rec.attribute6, hr_api.g_varchar2) or
706: nvl(per_rol_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
707: nvl(p_rec.attribute7, hr_api.g_varchar2) or
708: nvl(per_rol_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
709: nvl(p_rec.attribute8, hr_api.g_varchar2) or
710: nvl(per_rol_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

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

703: nvl(p_rec.attribute5, hr_api.g_varchar2) or
704: nvl(per_rol_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
705: nvl(p_rec.attribute6, hr_api.g_varchar2) or
706: nvl(per_rol_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
707: nvl(p_rec.attribute7, hr_api.g_varchar2) or
708: nvl(per_rol_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
709: nvl(p_rec.attribute8, hr_api.g_varchar2) or
710: nvl(per_rol_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
711: nvl(p_rec.attribute9, hr_api.g_varchar2) or

Line 708: nvl(per_rol_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

704: nvl(per_rol_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
705: nvl(p_rec.attribute6, hr_api.g_varchar2) or
706: nvl(per_rol_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
707: nvl(p_rec.attribute7, hr_api.g_varchar2) or
708: nvl(per_rol_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
709: nvl(p_rec.attribute8, hr_api.g_varchar2) or
710: nvl(per_rol_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
711: nvl(p_rec.attribute9, hr_api.g_varchar2) or
712: nvl(per_rol_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

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

705: nvl(p_rec.attribute6, hr_api.g_varchar2) or
706: nvl(per_rol_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
707: nvl(p_rec.attribute7, hr_api.g_varchar2) or
708: nvl(per_rol_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
709: nvl(p_rec.attribute8, hr_api.g_varchar2) or
710: nvl(per_rol_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
711: nvl(p_rec.attribute9, hr_api.g_varchar2) or
712: nvl(per_rol_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
713: nvl(p_rec.attribute10, hr_api.g_varchar2) or

Line 710: nvl(per_rol_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

706: nvl(per_rol_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
707: nvl(p_rec.attribute7, hr_api.g_varchar2) or
708: nvl(per_rol_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
709: nvl(p_rec.attribute8, hr_api.g_varchar2) or
710: nvl(per_rol_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
711: nvl(p_rec.attribute9, hr_api.g_varchar2) or
712: nvl(per_rol_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
713: nvl(p_rec.attribute10, hr_api.g_varchar2) or
714: nvl(per_rol_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

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

707: nvl(p_rec.attribute7, hr_api.g_varchar2) or
708: nvl(per_rol_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
709: nvl(p_rec.attribute8, hr_api.g_varchar2) or
710: nvl(per_rol_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
711: nvl(p_rec.attribute9, hr_api.g_varchar2) or
712: nvl(per_rol_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
713: nvl(p_rec.attribute10, hr_api.g_varchar2) or
714: nvl(per_rol_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
715: nvl(p_rec.attribute11, hr_api.g_varchar2) or

Line 712: nvl(per_rol_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

708: nvl(per_rol_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
709: nvl(p_rec.attribute8, hr_api.g_varchar2) or
710: nvl(per_rol_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
711: nvl(p_rec.attribute9, hr_api.g_varchar2) or
712: nvl(per_rol_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
713: nvl(p_rec.attribute10, hr_api.g_varchar2) or
714: nvl(per_rol_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
715: nvl(p_rec.attribute11, hr_api.g_varchar2) or
716: nvl(per_rol_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

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

709: nvl(p_rec.attribute8, hr_api.g_varchar2) or
710: nvl(per_rol_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
711: nvl(p_rec.attribute9, hr_api.g_varchar2) or
712: nvl(per_rol_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
713: nvl(p_rec.attribute10, hr_api.g_varchar2) or
714: nvl(per_rol_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
715: nvl(p_rec.attribute11, hr_api.g_varchar2) or
716: nvl(per_rol_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
717: nvl(p_rec.attribute12, hr_api.g_varchar2) or

Line 714: nvl(per_rol_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

710: nvl(per_rol_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
711: nvl(p_rec.attribute9, hr_api.g_varchar2) or
712: nvl(per_rol_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
713: nvl(p_rec.attribute10, hr_api.g_varchar2) or
714: nvl(per_rol_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
715: nvl(p_rec.attribute11, hr_api.g_varchar2) or
716: nvl(per_rol_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
717: nvl(p_rec.attribute12, hr_api.g_varchar2) or
718: nvl(per_rol_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

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

711: nvl(p_rec.attribute9, hr_api.g_varchar2) or
712: nvl(per_rol_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
713: nvl(p_rec.attribute10, hr_api.g_varchar2) or
714: nvl(per_rol_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
715: nvl(p_rec.attribute11, hr_api.g_varchar2) or
716: nvl(per_rol_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
717: nvl(p_rec.attribute12, hr_api.g_varchar2) or
718: nvl(per_rol_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
719: nvl(p_rec.attribute13, hr_api.g_varchar2) or

Line 716: nvl(per_rol_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

712: nvl(per_rol_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
713: nvl(p_rec.attribute10, hr_api.g_varchar2) or
714: nvl(per_rol_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
715: nvl(p_rec.attribute11, hr_api.g_varchar2) or
716: nvl(per_rol_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
717: nvl(p_rec.attribute12, hr_api.g_varchar2) or
718: nvl(per_rol_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
719: nvl(p_rec.attribute13, hr_api.g_varchar2) or
720: nvl(per_rol_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

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

713: nvl(p_rec.attribute10, hr_api.g_varchar2) or
714: nvl(per_rol_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
715: nvl(p_rec.attribute11, hr_api.g_varchar2) or
716: nvl(per_rol_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
717: nvl(p_rec.attribute12, hr_api.g_varchar2) or
718: nvl(per_rol_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
719: nvl(p_rec.attribute13, hr_api.g_varchar2) or
720: nvl(per_rol_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
721: nvl(p_rec.attribute14, hr_api.g_varchar2) or

Line 718: nvl(per_rol_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

714: nvl(per_rol_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
715: nvl(p_rec.attribute11, hr_api.g_varchar2) or
716: nvl(per_rol_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
717: nvl(p_rec.attribute12, hr_api.g_varchar2) or
718: nvl(per_rol_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
719: nvl(p_rec.attribute13, hr_api.g_varchar2) or
720: nvl(per_rol_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
721: nvl(p_rec.attribute14, hr_api.g_varchar2) or
722: nvl(per_rol_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

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

715: nvl(p_rec.attribute11, hr_api.g_varchar2) or
716: nvl(per_rol_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
717: nvl(p_rec.attribute12, hr_api.g_varchar2) or
718: nvl(per_rol_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
719: nvl(p_rec.attribute13, hr_api.g_varchar2) or
720: nvl(per_rol_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
721: nvl(p_rec.attribute14, hr_api.g_varchar2) or
722: nvl(per_rol_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
723: nvl(p_rec.attribute15, hr_api.g_varchar2) or

Line 720: nvl(per_rol_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

716: nvl(per_rol_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
717: nvl(p_rec.attribute12, hr_api.g_varchar2) or
718: nvl(per_rol_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
719: nvl(p_rec.attribute13, hr_api.g_varchar2) or
720: nvl(per_rol_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
721: nvl(p_rec.attribute14, hr_api.g_varchar2) or
722: nvl(per_rol_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
723: nvl(p_rec.attribute15, hr_api.g_varchar2) or
724: nvl(per_rol_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

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

717: nvl(p_rec.attribute12, hr_api.g_varchar2) or
718: nvl(per_rol_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
719: nvl(p_rec.attribute13, hr_api.g_varchar2) or
720: nvl(per_rol_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
721: nvl(p_rec.attribute14, hr_api.g_varchar2) or
722: nvl(per_rol_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
723: nvl(p_rec.attribute15, hr_api.g_varchar2) or
724: nvl(per_rol_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
725: nvl(p_rec.attribute16, hr_api.g_varchar2) or

Line 722: nvl(per_rol_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

718: nvl(per_rol_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
719: nvl(p_rec.attribute13, hr_api.g_varchar2) or
720: nvl(per_rol_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
721: nvl(p_rec.attribute14, hr_api.g_varchar2) or
722: nvl(per_rol_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
723: nvl(p_rec.attribute15, hr_api.g_varchar2) or
724: nvl(per_rol_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
725: nvl(p_rec.attribute16, hr_api.g_varchar2) or
726: nvl(per_rol_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

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

719: nvl(p_rec.attribute13, hr_api.g_varchar2) or
720: nvl(per_rol_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
721: nvl(p_rec.attribute14, hr_api.g_varchar2) or
722: nvl(per_rol_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
723: nvl(p_rec.attribute15, hr_api.g_varchar2) or
724: nvl(per_rol_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
725: nvl(p_rec.attribute16, hr_api.g_varchar2) or
726: nvl(per_rol_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
727: nvl(p_rec.attribute17, hr_api.g_varchar2) or

Line 724: nvl(per_rol_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

720: nvl(per_rol_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
721: nvl(p_rec.attribute14, hr_api.g_varchar2) or
722: nvl(per_rol_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
723: nvl(p_rec.attribute15, hr_api.g_varchar2) or
724: nvl(per_rol_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
725: nvl(p_rec.attribute16, hr_api.g_varchar2) or
726: nvl(per_rol_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
727: nvl(p_rec.attribute17, hr_api.g_varchar2) or
728: nvl(per_rol_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

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

721: nvl(p_rec.attribute14, hr_api.g_varchar2) or
722: nvl(per_rol_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
723: nvl(p_rec.attribute15, hr_api.g_varchar2) or
724: nvl(per_rol_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
725: nvl(p_rec.attribute16, hr_api.g_varchar2) or
726: nvl(per_rol_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
727: nvl(p_rec.attribute17, hr_api.g_varchar2) or
728: nvl(per_rol_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
729: nvl(p_rec.attribute18, hr_api.g_varchar2) or

Line 726: nvl(per_rol_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

722: nvl(per_rol_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
723: nvl(p_rec.attribute15, hr_api.g_varchar2) or
724: nvl(per_rol_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
725: nvl(p_rec.attribute16, hr_api.g_varchar2) or
726: nvl(per_rol_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
727: nvl(p_rec.attribute17, hr_api.g_varchar2) or
728: nvl(per_rol_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
729: nvl(p_rec.attribute18, hr_api.g_varchar2) or
730: nvl(per_rol_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

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

723: nvl(p_rec.attribute15, hr_api.g_varchar2) or
724: nvl(per_rol_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
725: nvl(p_rec.attribute16, hr_api.g_varchar2) or
726: nvl(per_rol_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
727: nvl(p_rec.attribute17, hr_api.g_varchar2) or
728: nvl(per_rol_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
729: nvl(p_rec.attribute18, hr_api.g_varchar2) or
730: nvl(per_rol_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
731: nvl(p_rec.attribute19, hr_api.g_varchar2) or

Line 728: nvl(per_rol_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

724: nvl(per_rol_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
725: nvl(p_rec.attribute16, hr_api.g_varchar2) or
726: nvl(per_rol_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
727: nvl(p_rec.attribute17, hr_api.g_varchar2) or
728: nvl(per_rol_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
729: nvl(p_rec.attribute18, hr_api.g_varchar2) or
730: nvl(per_rol_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
731: nvl(p_rec.attribute19, hr_api.g_varchar2) or
732: nvl(per_rol_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

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

725: nvl(p_rec.attribute16, hr_api.g_varchar2) or
726: nvl(per_rol_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
727: nvl(p_rec.attribute17, hr_api.g_varchar2) or
728: nvl(per_rol_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
729: nvl(p_rec.attribute18, hr_api.g_varchar2) or
730: nvl(per_rol_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
731: nvl(p_rec.attribute19, hr_api.g_varchar2) or
732: nvl(per_rol_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
733: nvl(p_rec.attribute20, hr_api.g_varchar2) ))

Line 730: nvl(per_rol_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

726: nvl(per_rol_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
727: nvl(p_rec.attribute17, hr_api.g_varchar2) or
728: nvl(per_rol_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
729: nvl(p_rec.attribute18, hr_api.g_varchar2) or
730: nvl(per_rol_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
731: nvl(p_rec.attribute19, hr_api.g_varchar2) or
732: nvl(per_rol_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
733: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
734: or (p_rec.role_id is null) then

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

727: nvl(p_rec.attribute17, hr_api.g_varchar2) or
728: nvl(per_rol_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
729: nvl(p_rec.attribute18, hr_api.g_varchar2) or
730: nvl(per_rol_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
731: nvl(p_rec.attribute19, hr_api.g_varchar2) or
732: nvl(per_rol_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
733: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
734: or (p_rec.role_id is null) then
735: --

Line 732: nvl(per_rol_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

728: nvl(per_rol_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
729: nvl(p_rec.attribute18, hr_api.g_varchar2) or
730: nvl(per_rol_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
731: nvl(p_rec.attribute19, hr_api.g_varchar2) or
732: nvl(per_rol_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
733: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
734: or (p_rec.role_id is null) then
735: --
736: -- Only execute the validation if absolutely necessary:

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

729: nvl(p_rec.attribute18, hr_api.g_varchar2) or
730: nvl(per_rol_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
731: nvl(p_rec.attribute19, hr_api.g_varchar2) or
732: nvl(per_rol_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
733: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
734: or (p_rec.role_id is null) then
735: --
736: -- Only execute the validation if absolutely necessary:
737: -- a) During update, the structure column value or any

Line 842: IF nvl(p_rec.person_id, hr_api.g_number) <>

838: fnd_message.set_token('STEP ', '5');
839: fnd_message.raise_error;
840: END IF;
841: --
842: IF nvl(p_rec.person_id, hr_api.g_number) <>
843: nvl(per_rol_shd.g_old_rec.person_id, hr_api.g_number) then
844: l_argument := 'person_id';
845: raise l_error;
846: END IF;

Line 843: nvl(per_rol_shd.g_old_rec.person_id, hr_api.g_number) then

839: fnd_message.raise_error;
840: END IF;
841: --
842: IF nvl(p_rec.person_id, hr_api.g_number) <>
843: nvl(per_rol_shd.g_old_rec.person_id, hr_api.g_number) then
844: l_argument := 'person_id';
845: raise l_error;
846: END IF;
847: --

Line 850: hr_api.argument_changed_error

846: END IF;
847: --
848: EXCEPTION
849: WHEN l_error THEN
850: hr_api.argument_changed_error
851: (p_api_name => l_proc
852: ,p_argument => l_argument);
853: WHEN OTHERS THEN
854: RAISE;