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