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_extra_info_id'
50: ,p_argument_value => p_role_extra_info_id
51: );
69: close csr_sec_grp;
70: --
71: -- Set the security_group_id in CLIENT_INFO
72: --
73: hr_api.set_security_group_id
74: (p_security_group_id => l_security_group_id
75: );
76: end if;
77: --
110: hr_utility.set_location('Entering:'|| l_proc, 10);
111: --
112: -- Ensure that all the mandatory parameter are not null
113: --
114: hr_api.mandatory_arg_error
115: (p_api_name => l_proc
116: ,p_argument => 'role_extra_info_id'
117: ,p_argument_value => p_role_extra_info_id
118: );
116: ,p_argument => 'role_extra_info_id'
117: ,p_argument_value => p_role_extra_info_id
118: );
119: --
120: if ( nvl(pqh_rei_bus.g_role_extra_info_id, hr_api.g_number)
121: = p_role_extra_info_id) then
122: --
123: -- The legislation code has already been found with a previous
124: -- call to this function. Just return the value in the global
203: hr_utility.set_location('Entering:'||l_proc, 1);
204: --
205: -- Check mandatory parameters have been set
206: --
207: hr_api.mandatory_arg_error
208: (
209: p_api_name => l_proc,
210: p_argument => 'information_type',
211: p_argument_value => p_information_type
283: hr_utility.set_location('Entering:'||l_proc, 1);
284: --
285: -- Check mandatory parameters have been set
286: --
287: hr_api.mandatory_arg_error
288: (
289: p_api_name => l_proc,
290: p_argument => 'role_id',
291: p_argument_value => p_role_id
450: end if;
451: --
452: hr_utility.set_location(l_proc, 30);
453: --
454: if nvl(p_rec.information_type, hr_api.g_varchar2) <>
455: nvl(pqh_rei_shd.g_old_rec.information_type, hr_api.g_varchar2) then
456: l_argument := 'information_type';
457: raise l_error;
458: end if;
451: --
452: hr_utility.set_location(l_proc, 30);
453: --
454: if nvl(p_rec.information_type, hr_api.g_varchar2) <>
455: nvl(pqh_rei_shd.g_old_rec.information_type, hr_api.g_varchar2) then
456: l_argument := 'information_type';
457: raise l_error;
458: end if;
459: --
458: end if;
459: --
460: hr_utility.set_location(l_proc, 40);
461: --
462: if nvl(p_rec.role_id, hr_api.g_number) <>
463: nvl(pqh_rei_shd.g_old_rec.role_id, hr_api.g_number) then
464: l_argument := 'role_id';
465: raise l_error;
466: end if;
459: --
460: hr_utility.set_location(l_proc, 40);
461: --
462: if nvl(p_rec.role_id, hr_api.g_number) <>
463: nvl(pqh_rei_shd.g_old_rec.role_id, hr_api.g_number) then
464: l_argument := 'role_id';
465: raise l_error;
466: end if;
467: --
467: --
468: hr_utility.set_location(' Leaving:'||l_proc, 50);
469: exception
470: when l_error then
471: hr_api.argument_changed_error
472: (p_api_name => l_proc
473: ,p_argument => l_argument
474: );
475: hr_utility.set_location(l_proc, 60);
516: begin
517: hr_utility.set_location('Entering:'||l_proc,10);
518: --
519: if ((p_rec.role_extra_info_id is not null) and (
520: nvl(pqh_rei_shd.g_old_rec.information_type, hr_api.g_varchar2) <>
521: nvl(p_rec.information_type, hr_api.g_varchar2) or
522: nvl(pqh_rei_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
523: nvl(p_rec.information_category, hr_api.g_varchar2) or
524: nvl(pqh_rei_shd.g_old_rec.information1, hr_api.g_varchar2) <>
517: hr_utility.set_location('Entering:'||l_proc,10);
518: --
519: if ((p_rec.role_extra_info_id is not null) and (
520: nvl(pqh_rei_shd.g_old_rec.information_type, hr_api.g_varchar2) <>
521: nvl(p_rec.information_type, hr_api.g_varchar2) or
522: nvl(pqh_rei_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
523: nvl(p_rec.information_category, hr_api.g_varchar2) or
524: nvl(pqh_rei_shd.g_old_rec.information1, hr_api.g_varchar2) <>
525: nvl(p_rec.information1, hr_api.g_varchar2) or
518: --
519: if ((p_rec.role_extra_info_id is not null) and (
520: nvl(pqh_rei_shd.g_old_rec.information_type, hr_api.g_varchar2) <>
521: nvl(p_rec.information_type, hr_api.g_varchar2) or
522: nvl(pqh_rei_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
523: nvl(p_rec.information_category, hr_api.g_varchar2) or
524: nvl(pqh_rei_shd.g_old_rec.information1, hr_api.g_varchar2) <>
525: nvl(p_rec.information1, hr_api.g_varchar2) or
526: nvl(pqh_rei_shd.g_old_rec.information2, hr_api.g_varchar2) <>
519: if ((p_rec.role_extra_info_id is not null) and (
520: nvl(pqh_rei_shd.g_old_rec.information_type, hr_api.g_varchar2) <>
521: nvl(p_rec.information_type, hr_api.g_varchar2) or
522: nvl(pqh_rei_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
523: nvl(p_rec.information_category, hr_api.g_varchar2) or
524: nvl(pqh_rei_shd.g_old_rec.information1, hr_api.g_varchar2) <>
525: nvl(p_rec.information1, hr_api.g_varchar2) or
526: nvl(pqh_rei_shd.g_old_rec.information2, hr_api.g_varchar2) <>
527: nvl(p_rec.information2, hr_api.g_varchar2) or
520: nvl(pqh_rei_shd.g_old_rec.information_type, hr_api.g_varchar2) <>
521: nvl(p_rec.information_type, hr_api.g_varchar2) or
522: nvl(pqh_rei_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
523: nvl(p_rec.information_category, hr_api.g_varchar2) or
524: nvl(pqh_rei_shd.g_old_rec.information1, hr_api.g_varchar2) <>
525: nvl(p_rec.information1, hr_api.g_varchar2) or
526: nvl(pqh_rei_shd.g_old_rec.information2, hr_api.g_varchar2) <>
527: nvl(p_rec.information2, hr_api.g_varchar2) or
528: nvl(pqh_rei_shd.g_old_rec.information3, hr_api.g_varchar2) <>
521: nvl(p_rec.information_type, hr_api.g_varchar2) or
522: nvl(pqh_rei_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
523: nvl(p_rec.information_category, hr_api.g_varchar2) or
524: nvl(pqh_rei_shd.g_old_rec.information1, hr_api.g_varchar2) <>
525: nvl(p_rec.information1, hr_api.g_varchar2) or
526: nvl(pqh_rei_shd.g_old_rec.information2, hr_api.g_varchar2) <>
527: nvl(p_rec.information2, hr_api.g_varchar2) or
528: nvl(pqh_rei_shd.g_old_rec.information3, hr_api.g_varchar2) <>
529: nvl(p_rec.information3, hr_api.g_varchar2) or
522: nvl(pqh_rei_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
523: nvl(p_rec.information_category, hr_api.g_varchar2) or
524: nvl(pqh_rei_shd.g_old_rec.information1, hr_api.g_varchar2) <>
525: nvl(p_rec.information1, hr_api.g_varchar2) or
526: nvl(pqh_rei_shd.g_old_rec.information2, hr_api.g_varchar2) <>
527: nvl(p_rec.information2, hr_api.g_varchar2) or
528: nvl(pqh_rei_shd.g_old_rec.information3, hr_api.g_varchar2) <>
529: nvl(p_rec.information3, hr_api.g_varchar2) or
530: nvl(pqh_rei_shd.g_old_rec.information4, hr_api.g_varchar2) <>
523: nvl(p_rec.information_category, hr_api.g_varchar2) or
524: nvl(pqh_rei_shd.g_old_rec.information1, hr_api.g_varchar2) <>
525: nvl(p_rec.information1, hr_api.g_varchar2) or
526: nvl(pqh_rei_shd.g_old_rec.information2, hr_api.g_varchar2) <>
527: nvl(p_rec.information2, hr_api.g_varchar2) or
528: nvl(pqh_rei_shd.g_old_rec.information3, hr_api.g_varchar2) <>
529: nvl(p_rec.information3, hr_api.g_varchar2) or
530: nvl(pqh_rei_shd.g_old_rec.information4, hr_api.g_varchar2) <>
531: nvl(p_rec.information4, hr_api.g_varchar2) or
524: nvl(pqh_rei_shd.g_old_rec.information1, hr_api.g_varchar2) <>
525: nvl(p_rec.information1, hr_api.g_varchar2) or
526: nvl(pqh_rei_shd.g_old_rec.information2, hr_api.g_varchar2) <>
527: nvl(p_rec.information2, hr_api.g_varchar2) or
528: nvl(pqh_rei_shd.g_old_rec.information3, hr_api.g_varchar2) <>
529: nvl(p_rec.information3, hr_api.g_varchar2) or
530: nvl(pqh_rei_shd.g_old_rec.information4, hr_api.g_varchar2) <>
531: nvl(p_rec.information4, hr_api.g_varchar2) or
532: nvl(pqh_rei_shd.g_old_rec.information5, hr_api.g_varchar2) <>
525: nvl(p_rec.information1, hr_api.g_varchar2) or
526: nvl(pqh_rei_shd.g_old_rec.information2, hr_api.g_varchar2) <>
527: nvl(p_rec.information2, hr_api.g_varchar2) or
528: nvl(pqh_rei_shd.g_old_rec.information3, hr_api.g_varchar2) <>
529: nvl(p_rec.information3, hr_api.g_varchar2) or
530: nvl(pqh_rei_shd.g_old_rec.information4, hr_api.g_varchar2) <>
531: nvl(p_rec.information4, hr_api.g_varchar2) or
532: nvl(pqh_rei_shd.g_old_rec.information5, hr_api.g_varchar2) <>
533: nvl(p_rec.information5, hr_api.g_varchar2) or
526: nvl(pqh_rei_shd.g_old_rec.information2, hr_api.g_varchar2) <>
527: nvl(p_rec.information2, hr_api.g_varchar2) or
528: nvl(pqh_rei_shd.g_old_rec.information3, hr_api.g_varchar2) <>
529: nvl(p_rec.information3, hr_api.g_varchar2) or
530: nvl(pqh_rei_shd.g_old_rec.information4, hr_api.g_varchar2) <>
531: nvl(p_rec.information4, hr_api.g_varchar2) or
532: nvl(pqh_rei_shd.g_old_rec.information5, hr_api.g_varchar2) <>
533: nvl(p_rec.information5, hr_api.g_varchar2) or
534: nvl(pqh_rei_shd.g_old_rec.information6, hr_api.g_varchar2) <>
527: nvl(p_rec.information2, hr_api.g_varchar2) or
528: nvl(pqh_rei_shd.g_old_rec.information3, hr_api.g_varchar2) <>
529: nvl(p_rec.information3, hr_api.g_varchar2) or
530: nvl(pqh_rei_shd.g_old_rec.information4, hr_api.g_varchar2) <>
531: nvl(p_rec.information4, hr_api.g_varchar2) or
532: nvl(pqh_rei_shd.g_old_rec.information5, hr_api.g_varchar2) <>
533: nvl(p_rec.information5, hr_api.g_varchar2) or
534: nvl(pqh_rei_shd.g_old_rec.information6, hr_api.g_varchar2) <>
535: nvl(p_rec.information6, hr_api.g_varchar2) or
528: nvl(pqh_rei_shd.g_old_rec.information3, hr_api.g_varchar2) <>
529: nvl(p_rec.information3, hr_api.g_varchar2) or
530: nvl(pqh_rei_shd.g_old_rec.information4, hr_api.g_varchar2) <>
531: nvl(p_rec.information4, hr_api.g_varchar2) or
532: nvl(pqh_rei_shd.g_old_rec.information5, hr_api.g_varchar2) <>
533: nvl(p_rec.information5, hr_api.g_varchar2) or
534: nvl(pqh_rei_shd.g_old_rec.information6, hr_api.g_varchar2) <>
535: nvl(p_rec.information6, hr_api.g_varchar2) or
536: nvl(pqh_rei_shd.g_old_rec.information7, hr_api.g_varchar2) <>
529: nvl(p_rec.information3, hr_api.g_varchar2) or
530: nvl(pqh_rei_shd.g_old_rec.information4, hr_api.g_varchar2) <>
531: nvl(p_rec.information4, hr_api.g_varchar2) or
532: nvl(pqh_rei_shd.g_old_rec.information5, hr_api.g_varchar2) <>
533: nvl(p_rec.information5, hr_api.g_varchar2) or
534: nvl(pqh_rei_shd.g_old_rec.information6, hr_api.g_varchar2) <>
535: nvl(p_rec.information6, hr_api.g_varchar2) or
536: nvl(pqh_rei_shd.g_old_rec.information7, hr_api.g_varchar2) <>
537: nvl(p_rec.information7, hr_api.g_varchar2) or
530: nvl(pqh_rei_shd.g_old_rec.information4, hr_api.g_varchar2) <>
531: nvl(p_rec.information4, hr_api.g_varchar2) or
532: nvl(pqh_rei_shd.g_old_rec.information5, hr_api.g_varchar2) <>
533: nvl(p_rec.information5, hr_api.g_varchar2) or
534: nvl(pqh_rei_shd.g_old_rec.information6, hr_api.g_varchar2) <>
535: nvl(p_rec.information6, hr_api.g_varchar2) or
536: nvl(pqh_rei_shd.g_old_rec.information7, hr_api.g_varchar2) <>
537: nvl(p_rec.information7, hr_api.g_varchar2) or
538: nvl(pqh_rei_shd.g_old_rec.information8, hr_api.g_varchar2) <>
531: nvl(p_rec.information4, hr_api.g_varchar2) or
532: nvl(pqh_rei_shd.g_old_rec.information5, hr_api.g_varchar2) <>
533: nvl(p_rec.information5, hr_api.g_varchar2) or
534: nvl(pqh_rei_shd.g_old_rec.information6, hr_api.g_varchar2) <>
535: nvl(p_rec.information6, hr_api.g_varchar2) or
536: nvl(pqh_rei_shd.g_old_rec.information7, hr_api.g_varchar2) <>
537: nvl(p_rec.information7, hr_api.g_varchar2) or
538: nvl(pqh_rei_shd.g_old_rec.information8, hr_api.g_varchar2) <>
539: nvl(p_rec.information8, hr_api.g_varchar2) or
532: nvl(pqh_rei_shd.g_old_rec.information5, hr_api.g_varchar2) <>
533: nvl(p_rec.information5, hr_api.g_varchar2) or
534: nvl(pqh_rei_shd.g_old_rec.information6, hr_api.g_varchar2) <>
535: nvl(p_rec.information6, hr_api.g_varchar2) or
536: nvl(pqh_rei_shd.g_old_rec.information7, hr_api.g_varchar2) <>
537: nvl(p_rec.information7, hr_api.g_varchar2) or
538: nvl(pqh_rei_shd.g_old_rec.information8, hr_api.g_varchar2) <>
539: nvl(p_rec.information8, hr_api.g_varchar2) or
540: nvl(pqh_rei_shd.g_old_rec.information9, hr_api.g_varchar2) <>
533: nvl(p_rec.information5, hr_api.g_varchar2) or
534: nvl(pqh_rei_shd.g_old_rec.information6, hr_api.g_varchar2) <>
535: nvl(p_rec.information6, hr_api.g_varchar2) or
536: nvl(pqh_rei_shd.g_old_rec.information7, hr_api.g_varchar2) <>
537: nvl(p_rec.information7, hr_api.g_varchar2) or
538: nvl(pqh_rei_shd.g_old_rec.information8, hr_api.g_varchar2) <>
539: nvl(p_rec.information8, hr_api.g_varchar2) or
540: nvl(pqh_rei_shd.g_old_rec.information9, hr_api.g_varchar2) <>
541: nvl(p_rec.information9, hr_api.g_varchar2) or
534: nvl(pqh_rei_shd.g_old_rec.information6, hr_api.g_varchar2) <>
535: nvl(p_rec.information6, hr_api.g_varchar2) or
536: nvl(pqh_rei_shd.g_old_rec.information7, hr_api.g_varchar2) <>
537: nvl(p_rec.information7, hr_api.g_varchar2) or
538: nvl(pqh_rei_shd.g_old_rec.information8, hr_api.g_varchar2) <>
539: nvl(p_rec.information8, hr_api.g_varchar2) or
540: nvl(pqh_rei_shd.g_old_rec.information9, hr_api.g_varchar2) <>
541: nvl(p_rec.information9, hr_api.g_varchar2) or
542: nvl(pqh_rei_shd.g_old_rec.information10, hr_api.g_varchar2) <>
535: nvl(p_rec.information6, hr_api.g_varchar2) or
536: nvl(pqh_rei_shd.g_old_rec.information7, hr_api.g_varchar2) <>
537: nvl(p_rec.information7, hr_api.g_varchar2) or
538: nvl(pqh_rei_shd.g_old_rec.information8, hr_api.g_varchar2) <>
539: nvl(p_rec.information8, hr_api.g_varchar2) or
540: nvl(pqh_rei_shd.g_old_rec.information9, hr_api.g_varchar2) <>
541: nvl(p_rec.information9, hr_api.g_varchar2) or
542: nvl(pqh_rei_shd.g_old_rec.information10, hr_api.g_varchar2) <>
543: nvl(p_rec.information10, hr_api.g_varchar2) or
536: nvl(pqh_rei_shd.g_old_rec.information7, hr_api.g_varchar2) <>
537: nvl(p_rec.information7, hr_api.g_varchar2) or
538: nvl(pqh_rei_shd.g_old_rec.information8, hr_api.g_varchar2) <>
539: nvl(p_rec.information8, hr_api.g_varchar2) or
540: nvl(pqh_rei_shd.g_old_rec.information9, hr_api.g_varchar2) <>
541: nvl(p_rec.information9, hr_api.g_varchar2) or
542: nvl(pqh_rei_shd.g_old_rec.information10, hr_api.g_varchar2) <>
543: nvl(p_rec.information10, hr_api.g_varchar2) or
544: nvl(pqh_rei_shd.g_old_rec.information11, hr_api.g_varchar2) <>
537: nvl(p_rec.information7, hr_api.g_varchar2) or
538: nvl(pqh_rei_shd.g_old_rec.information8, hr_api.g_varchar2) <>
539: nvl(p_rec.information8, hr_api.g_varchar2) or
540: nvl(pqh_rei_shd.g_old_rec.information9, hr_api.g_varchar2) <>
541: nvl(p_rec.information9, hr_api.g_varchar2) or
542: nvl(pqh_rei_shd.g_old_rec.information10, hr_api.g_varchar2) <>
543: nvl(p_rec.information10, hr_api.g_varchar2) or
544: nvl(pqh_rei_shd.g_old_rec.information11, hr_api.g_varchar2) <>
545: nvl(p_rec.information11, hr_api.g_varchar2) or
538: nvl(pqh_rei_shd.g_old_rec.information8, hr_api.g_varchar2) <>
539: nvl(p_rec.information8, hr_api.g_varchar2) or
540: nvl(pqh_rei_shd.g_old_rec.information9, hr_api.g_varchar2) <>
541: nvl(p_rec.information9, hr_api.g_varchar2) or
542: nvl(pqh_rei_shd.g_old_rec.information10, hr_api.g_varchar2) <>
543: nvl(p_rec.information10, hr_api.g_varchar2) or
544: nvl(pqh_rei_shd.g_old_rec.information11, hr_api.g_varchar2) <>
545: nvl(p_rec.information11, hr_api.g_varchar2) or
546: nvl(pqh_rei_shd.g_old_rec.information12, hr_api.g_varchar2) <>
539: nvl(p_rec.information8, hr_api.g_varchar2) or
540: nvl(pqh_rei_shd.g_old_rec.information9, hr_api.g_varchar2) <>
541: nvl(p_rec.information9, hr_api.g_varchar2) or
542: nvl(pqh_rei_shd.g_old_rec.information10, hr_api.g_varchar2) <>
543: nvl(p_rec.information10, hr_api.g_varchar2) or
544: nvl(pqh_rei_shd.g_old_rec.information11, hr_api.g_varchar2) <>
545: nvl(p_rec.information11, hr_api.g_varchar2) or
546: nvl(pqh_rei_shd.g_old_rec.information12, hr_api.g_varchar2) <>
547: nvl(p_rec.information12, hr_api.g_varchar2) or
540: nvl(pqh_rei_shd.g_old_rec.information9, hr_api.g_varchar2) <>
541: nvl(p_rec.information9, hr_api.g_varchar2) or
542: nvl(pqh_rei_shd.g_old_rec.information10, hr_api.g_varchar2) <>
543: nvl(p_rec.information10, hr_api.g_varchar2) or
544: nvl(pqh_rei_shd.g_old_rec.information11, hr_api.g_varchar2) <>
545: nvl(p_rec.information11, hr_api.g_varchar2) or
546: nvl(pqh_rei_shd.g_old_rec.information12, hr_api.g_varchar2) <>
547: nvl(p_rec.information12, hr_api.g_varchar2) or
548: nvl(pqh_rei_shd.g_old_rec.information13, hr_api.g_varchar2) <>
541: nvl(p_rec.information9, hr_api.g_varchar2) or
542: nvl(pqh_rei_shd.g_old_rec.information10, hr_api.g_varchar2) <>
543: nvl(p_rec.information10, hr_api.g_varchar2) or
544: nvl(pqh_rei_shd.g_old_rec.information11, hr_api.g_varchar2) <>
545: nvl(p_rec.information11, hr_api.g_varchar2) or
546: nvl(pqh_rei_shd.g_old_rec.information12, hr_api.g_varchar2) <>
547: nvl(p_rec.information12, hr_api.g_varchar2) or
548: nvl(pqh_rei_shd.g_old_rec.information13, hr_api.g_varchar2) <>
549: nvl(p_rec.information13, hr_api.g_varchar2) or
542: nvl(pqh_rei_shd.g_old_rec.information10, hr_api.g_varchar2) <>
543: nvl(p_rec.information10, hr_api.g_varchar2) or
544: nvl(pqh_rei_shd.g_old_rec.information11, hr_api.g_varchar2) <>
545: nvl(p_rec.information11, hr_api.g_varchar2) or
546: nvl(pqh_rei_shd.g_old_rec.information12, hr_api.g_varchar2) <>
547: nvl(p_rec.information12, hr_api.g_varchar2) or
548: nvl(pqh_rei_shd.g_old_rec.information13, hr_api.g_varchar2) <>
549: nvl(p_rec.information13, hr_api.g_varchar2) or
550: nvl(pqh_rei_shd.g_old_rec.information14, hr_api.g_varchar2) <>
543: nvl(p_rec.information10, hr_api.g_varchar2) or
544: nvl(pqh_rei_shd.g_old_rec.information11, hr_api.g_varchar2) <>
545: nvl(p_rec.information11, hr_api.g_varchar2) or
546: nvl(pqh_rei_shd.g_old_rec.information12, hr_api.g_varchar2) <>
547: nvl(p_rec.information12, hr_api.g_varchar2) or
548: nvl(pqh_rei_shd.g_old_rec.information13, hr_api.g_varchar2) <>
549: nvl(p_rec.information13, hr_api.g_varchar2) or
550: nvl(pqh_rei_shd.g_old_rec.information14, hr_api.g_varchar2) <>
551: nvl(p_rec.information14, hr_api.g_varchar2) or
544: nvl(pqh_rei_shd.g_old_rec.information11, hr_api.g_varchar2) <>
545: nvl(p_rec.information11, hr_api.g_varchar2) or
546: nvl(pqh_rei_shd.g_old_rec.information12, hr_api.g_varchar2) <>
547: nvl(p_rec.information12, hr_api.g_varchar2) or
548: nvl(pqh_rei_shd.g_old_rec.information13, hr_api.g_varchar2) <>
549: nvl(p_rec.information13, hr_api.g_varchar2) or
550: nvl(pqh_rei_shd.g_old_rec.information14, hr_api.g_varchar2) <>
551: nvl(p_rec.information14, hr_api.g_varchar2) or
552: nvl(pqh_rei_shd.g_old_rec.information15, hr_api.g_varchar2) <>
545: nvl(p_rec.information11, hr_api.g_varchar2) or
546: nvl(pqh_rei_shd.g_old_rec.information12, hr_api.g_varchar2) <>
547: nvl(p_rec.information12, hr_api.g_varchar2) or
548: nvl(pqh_rei_shd.g_old_rec.information13, hr_api.g_varchar2) <>
549: nvl(p_rec.information13, hr_api.g_varchar2) or
550: nvl(pqh_rei_shd.g_old_rec.information14, hr_api.g_varchar2) <>
551: nvl(p_rec.information14, hr_api.g_varchar2) or
552: nvl(pqh_rei_shd.g_old_rec.information15, hr_api.g_varchar2) <>
553: nvl(p_rec.information15, hr_api.g_varchar2) or
546: nvl(pqh_rei_shd.g_old_rec.information12, hr_api.g_varchar2) <>
547: nvl(p_rec.information12, hr_api.g_varchar2) or
548: nvl(pqh_rei_shd.g_old_rec.information13, hr_api.g_varchar2) <>
549: nvl(p_rec.information13, hr_api.g_varchar2) or
550: nvl(pqh_rei_shd.g_old_rec.information14, hr_api.g_varchar2) <>
551: nvl(p_rec.information14, hr_api.g_varchar2) or
552: nvl(pqh_rei_shd.g_old_rec.information15, hr_api.g_varchar2) <>
553: nvl(p_rec.information15, hr_api.g_varchar2) or
554: nvl(pqh_rei_shd.g_old_rec.information16, hr_api.g_varchar2) <>
547: nvl(p_rec.information12, hr_api.g_varchar2) or
548: nvl(pqh_rei_shd.g_old_rec.information13, hr_api.g_varchar2) <>
549: nvl(p_rec.information13, hr_api.g_varchar2) or
550: nvl(pqh_rei_shd.g_old_rec.information14, hr_api.g_varchar2) <>
551: nvl(p_rec.information14, hr_api.g_varchar2) or
552: nvl(pqh_rei_shd.g_old_rec.information15, hr_api.g_varchar2) <>
553: nvl(p_rec.information15, hr_api.g_varchar2) or
554: nvl(pqh_rei_shd.g_old_rec.information16, hr_api.g_varchar2) <>
555: nvl(p_rec.information16, hr_api.g_varchar2) or
548: nvl(pqh_rei_shd.g_old_rec.information13, hr_api.g_varchar2) <>
549: nvl(p_rec.information13, hr_api.g_varchar2) or
550: nvl(pqh_rei_shd.g_old_rec.information14, hr_api.g_varchar2) <>
551: nvl(p_rec.information14, hr_api.g_varchar2) or
552: nvl(pqh_rei_shd.g_old_rec.information15, hr_api.g_varchar2) <>
553: nvl(p_rec.information15, hr_api.g_varchar2) or
554: nvl(pqh_rei_shd.g_old_rec.information16, hr_api.g_varchar2) <>
555: nvl(p_rec.information16, hr_api.g_varchar2) or
556: nvl(pqh_rei_shd.g_old_rec.information17, hr_api.g_varchar2) <>
549: nvl(p_rec.information13, hr_api.g_varchar2) or
550: nvl(pqh_rei_shd.g_old_rec.information14, hr_api.g_varchar2) <>
551: nvl(p_rec.information14, hr_api.g_varchar2) or
552: nvl(pqh_rei_shd.g_old_rec.information15, hr_api.g_varchar2) <>
553: nvl(p_rec.information15, hr_api.g_varchar2) or
554: nvl(pqh_rei_shd.g_old_rec.information16, hr_api.g_varchar2) <>
555: nvl(p_rec.information16, hr_api.g_varchar2) or
556: nvl(pqh_rei_shd.g_old_rec.information17, hr_api.g_varchar2) <>
557: nvl(p_rec.information17, hr_api.g_varchar2) or
550: nvl(pqh_rei_shd.g_old_rec.information14, hr_api.g_varchar2) <>
551: nvl(p_rec.information14, hr_api.g_varchar2) or
552: nvl(pqh_rei_shd.g_old_rec.information15, hr_api.g_varchar2) <>
553: nvl(p_rec.information15, hr_api.g_varchar2) or
554: nvl(pqh_rei_shd.g_old_rec.information16, hr_api.g_varchar2) <>
555: nvl(p_rec.information16, hr_api.g_varchar2) or
556: nvl(pqh_rei_shd.g_old_rec.information17, hr_api.g_varchar2) <>
557: nvl(p_rec.information17, hr_api.g_varchar2) or
558: nvl(pqh_rei_shd.g_old_rec.information18, hr_api.g_varchar2) <>
551: nvl(p_rec.information14, hr_api.g_varchar2) or
552: nvl(pqh_rei_shd.g_old_rec.information15, hr_api.g_varchar2) <>
553: nvl(p_rec.information15, hr_api.g_varchar2) or
554: nvl(pqh_rei_shd.g_old_rec.information16, hr_api.g_varchar2) <>
555: nvl(p_rec.information16, hr_api.g_varchar2) or
556: nvl(pqh_rei_shd.g_old_rec.information17, hr_api.g_varchar2) <>
557: nvl(p_rec.information17, hr_api.g_varchar2) or
558: nvl(pqh_rei_shd.g_old_rec.information18, hr_api.g_varchar2) <>
559: nvl(p_rec.information18, hr_api.g_varchar2) or
552: nvl(pqh_rei_shd.g_old_rec.information15, hr_api.g_varchar2) <>
553: nvl(p_rec.information15, hr_api.g_varchar2) or
554: nvl(pqh_rei_shd.g_old_rec.information16, hr_api.g_varchar2) <>
555: nvl(p_rec.information16, hr_api.g_varchar2) or
556: nvl(pqh_rei_shd.g_old_rec.information17, hr_api.g_varchar2) <>
557: nvl(p_rec.information17, hr_api.g_varchar2) or
558: nvl(pqh_rei_shd.g_old_rec.information18, hr_api.g_varchar2) <>
559: nvl(p_rec.information18, hr_api.g_varchar2) or
560: nvl(pqh_rei_shd.g_old_rec.information19, hr_api.g_varchar2) <>
553: nvl(p_rec.information15, hr_api.g_varchar2) or
554: nvl(pqh_rei_shd.g_old_rec.information16, hr_api.g_varchar2) <>
555: nvl(p_rec.information16, hr_api.g_varchar2) or
556: nvl(pqh_rei_shd.g_old_rec.information17, hr_api.g_varchar2) <>
557: nvl(p_rec.information17, hr_api.g_varchar2) or
558: nvl(pqh_rei_shd.g_old_rec.information18, hr_api.g_varchar2) <>
559: nvl(p_rec.information18, hr_api.g_varchar2) or
560: nvl(pqh_rei_shd.g_old_rec.information19, hr_api.g_varchar2) <>
561: nvl(p_rec.information19, hr_api.g_varchar2) or
554: nvl(pqh_rei_shd.g_old_rec.information16, hr_api.g_varchar2) <>
555: nvl(p_rec.information16, hr_api.g_varchar2) or
556: nvl(pqh_rei_shd.g_old_rec.information17, hr_api.g_varchar2) <>
557: nvl(p_rec.information17, hr_api.g_varchar2) or
558: nvl(pqh_rei_shd.g_old_rec.information18, hr_api.g_varchar2) <>
559: nvl(p_rec.information18, hr_api.g_varchar2) or
560: nvl(pqh_rei_shd.g_old_rec.information19, hr_api.g_varchar2) <>
561: nvl(p_rec.information19, hr_api.g_varchar2) or
562: nvl(pqh_rei_shd.g_old_rec.information20, hr_api.g_varchar2) <>
555: nvl(p_rec.information16, hr_api.g_varchar2) or
556: nvl(pqh_rei_shd.g_old_rec.information17, hr_api.g_varchar2) <>
557: nvl(p_rec.information17, hr_api.g_varchar2) or
558: nvl(pqh_rei_shd.g_old_rec.information18, hr_api.g_varchar2) <>
559: nvl(p_rec.information18, hr_api.g_varchar2) or
560: nvl(pqh_rei_shd.g_old_rec.information19, hr_api.g_varchar2) <>
561: nvl(p_rec.information19, hr_api.g_varchar2) or
562: nvl(pqh_rei_shd.g_old_rec.information20, hr_api.g_varchar2) <>
563: nvl(p_rec.information20, hr_api.g_varchar2) or
556: nvl(pqh_rei_shd.g_old_rec.information17, hr_api.g_varchar2) <>
557: nvl(p_rec.information17, hr_api.g_varchar2) or
558: nvl(pqh_rei_shd.g_old_rec.information18, hr_api.g_varchar2) <>
559: nvl(p_rec.information18, hr_api.g_varchar2) or
560: nvl(pqh_rei_shd.g_old_rec.information19, hr_api.g_varchar2) <>
561: nvl(p_rec.information19, hr_api.g_varchar2) or
562: nvl(pqh_rei_shd.g_old_rec.information20, hr_api.g_varchar2) <>
563: nvl(p_rec.information20, hr_api.g_varchar2) or
564: nvl(pqh_rei_shd.g_old_rec.information21, hr_api.g_varchar2) <>
557: nvl(p_rec.information17, hr_api.g_varchar2) or
558: nvl(pqh_rei_shd.g_old_rec.information18, hr_api.g_varchar2) <>
559: nvl(p_rec.information18, hr_api.g_varchar2) or
560: nvl(pqh_rei_shd.g_old_rec.information19, hr_api.g_varchar2) <>
561: nvl(p_rec.information19, hr_api.g_varchar2) or
562: nvl(pqh_rei_shd.g_old_rec.information20, hr_api.g_varchar2) <>
563: nvl(p_rec.information20, hr_api.g_varchar2) or
564: nvl(pqh_rei_shd.g_old_rec.information21, hr_api.g_varchar2) <>
565: nvl(p_rec.information21, hr_api.g_varchar2) or
558: nvl(pqh_rei_shd.g_old_rec.information18, hr_api.g_varchar2) <>
559: nvl(p_rec.information18, hr_api.g_varchar2) or
560: nvl(pqh_rei_shd.g_old_rec.information19, hr_api.g_varchar2) <>
561: nvl(p_rec.information19, hr_api.g_varchar2) or
562: nvl(pqh_rei_shd.g_old_rec.information20, hr_api.g_varchar2) <>
563: nvl(p_rec.information20, hr_api.g_varchar2) or
564: nvl(pqh_rei_shd.g_old_rec.information21, hr_api.g_varchar2) <>
565: nvl(p_rec.information21, hr_api.g_varchar2) or
566: nvl(pqh_rei_shd.g_old_rec.information22, hr_api.g_varchar2) <>
559: nvl(p_rec.information18, hr_api.g_varchar2) or
560: nvl(pqh_rei_shd.g_old_rec.information19, hr_api.g_varchar2) <>
561: nvl(p_rec.information19, hr_api.g_varchar2) or
562: nvl(pqh_rei_shd.g_old_rec.information20, hr_api.g_varchar2) <>
563: nvl(p_rec.information20, hr_api.g_varchar2) or
564: nvl(pqh_rei_shd.g_old_rec.information21, hr_api.g_varchar2) <>
565: nvl(p_rec.information21, hr_api.g_varchar2) or
566: nvl(pqh_rei_shd.g_old_rec.information22, hr_api.g_varchar2) <>
567: nvl(p_rec.information22, hr_api.g_varchar2) or
560: nvl(pqh_rei_shd.g_old_rec.information19, hr_api.g_varchar2) <>
561: nvl(p_rec.information19, hr_api.g_varchar2) or
562: nvl(pqh_rei_shd.g_old_rec.information20, hr_api.g_varchar2) <>
563: nvl(p_rec.information20, hr_api.g_varchar2) or
564: nvl(pqh_rei_shd.g_old_rec.information21, hr_api.g_varchar2) <>
565: nvl(p_rec.information21, hr_api.g_varchar2) or
566: nvl(pqh_rei_shd.g_old_rec.information22, hr_api.g_varchar2) <>
567: nvl(p_rec.information22, hr_api.g_varchar2) or
568: nvl(pqh_rei_shd.g_old_rec.information23, hr_api.g_varchar2) <>
561: nvl(p_rec.information19, hr_api.g_varchar2) or
562: nvl(pqh_rei_shd.g_old_rec.information20, hr_api.g_varchar2) <>
563: nvl(p_rec.information20, hr_api.g_varchar2) or
564: nvl(pqh_rei_shd.g_old_rec.information21, hr_api.g_varchar2) <>
565: nvl(p_rec.information21, hr_api.g_varchar2) or
566: nvl(pqh_rei_shd.g_old_rec.information22, hr_api.g_varchar2) <>
567: nvl(p_rec.information22, hr_api.g_varchar2) or
568: nvl(pqh_rei_shd.g_old_rec.information23, hr_api.g_varchar2) <>
569: nvl(p_rec.information23, hr_api.g_varchar2) or
562: nvl(pqh_rei_shd.g_old_rec.information20, hr_api.g_varchar2) <>
563: nvl(p_rec.information20, hr_api.g_varchar2) or
564: nvl(pqh_rei_shd.g_old_rec.information21, hr_api.g_varchar2) <>
565: nvl(p_rec.information21, hr_api.g_varchar2) or
566: nvl(pqh_rei_shd.g_old_rec.information22, hr_api.g_varchar2) <>
567: nvl(p_rec.information22, hr_api.g_varchar2) or
568: nvl(pqh_rei_shd.g_old_rec.information23, hr_api.g_varchar2) <>
569: nvl(p_rec.information23, hr_api.g_varchar2) or
570: nvl(pqh_rei_shd.g_old_rec.information24, hr_api.g_varchar2) <>
563: nvl(p_rec.information20, hr_api.g_varchar2) or
564: nvl(pqh_rei_shd.g_old_rec.information21, hr_api.g_varchar2) <>
565: nvl(p_rec.information21, hr_api.g_varchar2) or
566: nvl(pqh_rei_shd.g_old_rec.information22, hr_api.g_varchar2) <>
567: nvl(p_rec.information22, hr_api.g_varchar2) or
568: nvl(pqh_rei_shd.g_old_rec.information23, hr_api.g_varchar2) <>
569: nvl(p_rec.information23, hr_api.g_varchar2) or
570: nvl(pqh_rei_shd.g_old_rec.information24, hr_api.g_varchar2) <>
571: nvl(p_rec.information24, hr_api.g_varchar2) or
564: nvl(pqh_rei_shd.g_old_rec.information21, hr_api.g_varchar2) <>
565: nvl(p_rec.information21, hr_api.g_varchar2) or
566: nvl(pqh_rei_shd.g_old_rec.information22, hr_api.g_varchar2) <>
567: nvl(p_rec.information22, hr_api.g_varchar2) or
568: nvl(pqh_rei_shd.g_old_rec.information23, hr_api.g_varchar2) <>
569: nvl(p_rec.information23, hr_api.g_varchar2) or
570: nvl(pqh_rei_shd.g_old_rec.information24, hr_api.g_varchar2) <>
571: nvl(p_rec.information24, hr_api.g_varchar2) or
572: nvl(pqh_rei_shd.g_old_rec.information25, hr_api.g_varchar2) <>
565: nvl(p_rec.information21, hr_api.g_varchar2) or
566: nvl(pqh_rei_shd.g_old_rec.information22, hr_api.g_varchar2) <>
567: nvl(p_rec.information22, hr_api.g_varchar2) or
568: nvl(pqh_rei_shd.g_old_rec.information23, hr_api.g_varchar2) <>
569: nvl(p_rec.information23, hr_api.g_varchar2) or
570: nvl(pqh_rei_shd.g_old_rec.information24, hr_api.g_varchar2) <>
571: nvl(p_rec.information24, hr_api.g_varchar2) or
572: nvl(pqh_rei_shd.g_old_rec.information25, hr_api.g_varchar2) <>
573: nvl(p_rec.information25, hr_api.g_varchar2) or
566: nvl(pqh_rei_shd.g_old_rec.information22, hr_api.g_varchar2) <>
567: nvl(p_rec.information22, hr_api.g_varchar2) or
568: nvl(pqh_rei_shd.g_old_rec.information23, hr_api.g_varchar2) <>
569: nvl(p_rec.information23, hr_api.g_varchar2) or
570: nvl(pqh_rei_shd.g_old_rec.information24, hr_api.g_varchar2) <>
571: nvl(p_rec.information24, hr_api.g_varchar2) or
572: nvl(pqh_rei_shd.g_old_rec.information25, hr_api.g_varchar2) <>
573: nvl(p_rec.information25, hr_api.g_varchar2) or
574: nvl(pqh_rei_shd.g_old_rec.information26, hr_api.g_varchar2) <>
567: nvl(p_rec.information22, hr_api.g_varchar2) or
568: nvl(pqh_rei_shd.g_old_rec.information23, hr_api.g_varchar2) <>
569: nvl(p_rec.information23, hr_api.g_varchar2) or
570: nvl(pqh_rei_shd.g_old_rec.information24, hr_api.g_varchar2) <>
571: nvl(p_rec.information24, hr_api.g_varchar2) or
572: nvl(pqh_rei_shd.g_old_rec.information25, hr_api.g_varchar2) <>
573: nvl(p_rec.information25, hr_api.g_varchar2) or
574: nvl(pqh_rei_shd.g_old_rec.information26, hr_api.g_varchar2) <>
575: nvl(p_rec.information26, hr_api.g_varchar2) or
568: nvl(pqh_rei_shd.g_old_rec.information23, hr_api.g_varchar2) <>
569: nvl(p_rec.information23, hr_api.g_varchar2) or
570: nvl(pqh_rei_shd.g_old_rec.information24, hr_api.g_varchar2) <>
571: nvl(p_rec.information24, hr_api.g_varchar2) or
572: nvl(pqh_rei_shd.g_old_rec.information25, hr_api.g_varchar2) <>
573: nvl(p_rec.information25, hr_api.g_varchar2) or
574: nvl(pqh_rei_shd.g_old_rec.information26, hr_api.g_varchar2) <>
575: nvl(p_rec.information26, hr_api.g_varchar2) or
576: nvl(pqh_rei_shd.g_old_rec.information27, hr_api.g_varchar2) <>
569: nvl(p_rec.information23, hr_api.g_varchar2) or
570: nvl(pqh_rei_shd.g_old_rec.information24, hr_api.g_varchar2) <>
571: nvl(p_rec.information24, hr_api.g_varchar2) or
572: nvl(pqh_rei_shd.g_old_rec.information25, hr_api.g_varchar2) <>
573: nvl(p_rec.information25, hr_api.g_varchar2) or
574: nvl(pqh_rei_shd.g_old_rec.information26, hr_api.g_varchar2) <>
575: nvl(p_rec.information26, hr_api.g_varchar2) or
576: nvl(pqh_rei_shd.g_old_rec.information27, hr_api.g_varchar2) <>
577: nvl(p_rec.information27, hr_api.g_varchar2) or
570: nvl(pqh_rei_shd.g_old_rec.information24, hr_api.g_varchar2) <>
571: nvl(p_rec.information24, hr_api.g_varchar2) or
572: nvl(pqh_rei_shd.g_old_rec.information25, hr_api.g_varchar2) <>
573: nvl(p_rec.information25, hr_api.g_varchar2) or
574: nvl(pqh_rei_shd.g_old_rec.information26, hr_api.g_varchar2) <>
575: nvl(p_rec.information26, hr_api.g_varchar2) or
576: nvl(pqh_rei_shd.g_old_rec.information27, hr_api.g_varchar2) <>
577: nvl(p_rec.information27, hr_api.g_varchar2) or
578: nvl(pqh_rei_shd.g_old_rec.information28, hr_api.g_varchar2) <>
571: nvl(p_rec.information24, hr_api.g_varchar2) or
572: nvl(pqh_rei_shd.g_old_rec.information25, hr_api.g_varchar2) <>
573: nvl(p_rec.information25, hr_api.g_varchar2) or
574: nvl(pqh_rei_shd.g_old_rec.information26, hr_api.g_varchar2) <>
575: nvl(p_rec.information26, hr_api.g_varchar2) or
576: nvl(pqh_rei_shd.g_old_rec.information27, hr_api.g_varchar2) <>
577: nvl(p_rec.information27, hr_api.g_varchar2) or
578: nvl(pqh_rei_shd.g_old_rec.information28, hr_api.g_varchar2) <>
579: nvl(p_rec.information28, hr_api.g_varchar2) or
572: nvl(pqh_rei_shd.g_old_rec.information25, hr_api.g_varchar2) <>
573: nvl(p_rec.information25, hr_api.g_varchar2) or
574: nvl(pqh_rei_shd.g_old_rec.information26, hr_api.g_varchar2) <>
575: nvl(p_rec.information26, hr_api.g_varchar2) or
576: nvl(pqh_rei_shd.g_old_rec.information27, hr_api.g_varchar2) <>
577: nvl(p_rec.information27, hr_api.g_varchar2) or
578: nvl(pqh_rei_shd.g_old_rec.information28, hr_api.g_varchar2) <>
579: nvl(p_rec.information28, hr_api.g_varchar2) or
580: nvl(pqh_rei_shd.g_old_rec.information29, hr_api.g_varchar2) <>
573: nvl(p_rec.information25, hr_api.g_varchar2) or
574: nvl(pqh_rei_shd.g_old_rec.information26, hr_api.g_varchar2) <>
575: nvl(p_rec.information26, hr_api.g_varchar2) or
576: nvl(pqh_rei_shd.g_old_rec.information27, hr_api.g_varchar2) <>
577: nvl(p_rec.information27, hr_api.g_varchar2) or
578: nvl(pqh_rei_shd.g_old_rec.information28, hr_api.g_varchar2) <>
579: nvl(p_rec.information28, hr_api.g_varchar2) or
580: nvl(pqh_rei_shd.g_old_rec.information29, hr_api.g_varchar2) <>
581: nvl(p_rec.information29, hr_api.g_varchar2) or
574: nvl(pqh_rei_shd.g_old_rec.information26, hr_api.g_varchar2) <>
575: nvl(p_rec.information26, hr_api.g_varchar2) or
576: nvl(pqh_rei_shd.g_old_rec.information27, hr_api.g_varchar2) <>
577: nvl(p_rec.information27, hr_api.g_varchar2) or
578: nvl(pqh_rei_shd.g_old_rec.information28, hr_api.g_varchar2) <>
579: nvl(p_rec.information28, hr_api.g_varchar2) or
580: nvl(pqh_rei_shd.g_old_rec.information29, hr_api.g_varchar2) <>
581: nvl(p_rec.information29, hr_api.g_varchar2) or
582: nvl(pqh_rei_shd.g_old_rec.information30, hr_api.g_varchar2) <>
575: nvl(p_rec.information26, hr_api.g_varchar2) or
576: nvl(pqh_rei_shd.g_old_rec.information27, hr_api.g_varchar2) <>
577: nvl(p_rec.information27, hr_api.g_varchar2) or
578: nvl(pqh_rei_shd.g_old_rec.information28, hr_api.g_varchar2) <>
579: nvl(p_rec.information28, hr_api.g_varchar2) or
580: nvl(pqh_rei_shd.g_old_rec.information29, hr_api.g_varchar2) <>
581: nvl(p_rec.information29, hr_api.g_varchar2) or
582: nvl(pqh_rei_shd.g_old_rec.information30, hr_api.g_varchar2) <>
583: nvl(p_rec.information30, hr_api.g_varchar2) )) or
576: nvl(pqh_rei_shd.g_old_rec.information27, hr_api.g_varchar2) <>
577: nvl(p_rec.information27, hr_api.g_varchar2) or
578: nvl(pqh_rei_shd.g_old_rec.information28, hr_api.g_varchar2) <>
579: nvl(p_rec.information28, hr_api.g_varchar2) or
580: nvl(pqh_rei_shd.g_old_rec.information29, hr_api.g_varchar2) <>
581: nvl(p_rec.information29, hr_api.g_varchar2) or
582: nvl(pqh_rei_shd.g_old_rec.information30, hr_api.g_varchar2) <>
583: nvl(p_rec.information30, hr_api.g_varchar2) )) or
584: (p_rec.role_extra_info_id is null) then
577: nvl(p_rec.information27, hr_api.g_varchar2) or
578: nvl(pqh_rei_shd.g_old_rec.information28, hr_api.g_varchar2) <>
579: nvl(p_rec.information28, hr_api.g_varchar2) or
580: nvl(pqh_rei_shd.g_old_rec.information29, hr_api.g_varchar2) <>
581: nvl(p_rec.information29, hr_api.g_varchar2) or
582: nvl(pqh_rei_shd.g_old_rec.information30, hr_api.g_varchar2) <>
583: nvl(p_rec.information30, hr_api.g_varchar2) )) or
584: (p_rec.role_extra_info_id is null) then
585: --
578: nvl(pqh_rei_shd.g_old_rec.information28, hr_api.g_varchar2) <>
579: nvl(p_rec.information28, hr_api.g_varchar2) or
580: nvl(pqh_rei_shd.g_old_rec.information29, hr_api.g_varchar2) <>
581: nvl(p_rec.information29, hr_api.g_varchar2) or
582: nvl(pqh_rei_shd.g_old_rec.information30, hr_api.g_varchar2) <>
583: nvl(p_rec.information30, hr_api.g_varchar2) )) or
584: (p_rec.role_extra_info_id is null) then
585: --
586: -- Only execute the validation if absolutely necessary:
579: nvl(p_rec.information28, hr_api.g_varchar2) or
580: nvl(pqh_rei_shd.g_old_rec.information29, hr_api.g_varchar2) <>
581: nvl(p_rec.information29, hr_api.g_varchar2) or
582: nvl(pqh_rei_shd.g_old_rec.information30, hr_api.g_varchar2) <>
583: nvl(p_rec.information30, hr_api.g_varchar2) )) or
584: (p_rec.role_extra_info_id is null) then
585: --
586: -- Only execute the validation if absolutely necessary:
587: -- a) During update, the structure column value or any
695: begin
696: hr_utility.set_location('Entering:'||l_proc,10);
697: --
698: if ((p_rec.role_extra_info_id is not null) and (
699: nvl(pqh_rei_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
700: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
701: nvl(pqh_rei_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
702: nvl(p_rec.attribute1, hr_api.g_varchar2) or
703: nvl(pqh_rei_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
696: hr_utility.set_location('Entering:'||l_proc,10);
697: --
698: if ((p_rec.role_extra_info_id is not null) and (
699: nvl(pqh_rei_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
700: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
701: nvl(pqh_rei_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
702: nvl(p_rec.attribute1, hr_api.g_varchar2) or
703: nvl(pqh_rei_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
704: nvl(p_rec.attribute2, hr_api.g_varchar2) or
697: --
698: if ((p_rec.role_extra_info_id is not null) and (
699: nvl(pqh_rei_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
700: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
701: nvl(pqh_rei_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
702: nvl(p_rec.attribute1, hr_api.g_varchar2) or
703: nvl(pqh_rei_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
704: nvl(p_rec.attribute2, hr_api.g_varchar2) or
705: nvl(pqh_rei_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
698: if ((p_rec.role_extra_info_id is not null) and (
699: nvl(pqh_rei_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
700: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
701: nvl(pqh_rei_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
702: nvl(p_rec.attribute1, hr_api.g_varchar2) or
703: nvl(pqh_rei_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
704: nvl(p_rec.attribute2, hr_api.g_varchar2) or
705: nvl(pqh_rei_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
706: nvl(p_rec.attribute3, hr_api.g_varchar2) or
699: nvl(pqh_rei_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
700: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
701: nvl(pqh_rei_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
702: nvl(p_rec.attribute1, hr_api.g_varchar2) or
703: nvl(pqh_rei_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
704: nvl(p_rec.attribute2, hr_api.g_varchar2) or
705: nvl(pqh_rei_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
706: nvl(p_rec.attribute3, hr_api.g_varchar2) or
707: nvl(pqh_rei_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
700: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
701: nvl(pqh_rei_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
702: nvl(p_rec.attribute1, hr_api.g_varchar2) or
703: nvl(pqh_rei_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
704: nvl(p_rec.attribute2, hr_api.g_varchar2) or
705: nvl(pqh_rei_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
706: nvl(p_rec.attribute3, hr_api.g_varchar2) or
707: nvl(pqh_rei_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
708: nvl(p_rec.attribute4, hr_api.g_varchar2) or
701: nvl(pqh_rei_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
702: nvl(p_rec.attribute1, hr_api.g_varchar2) or
703: nvl(pqh_rei_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
704: nvl(p_rec.attribute2, hr_api.g_varchar2) or
705: nvl(pqh_rei_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
706: nvl(p_rec.attribute3, hr_api.g_varchar2) or
707: nvl(pqh_rei_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
708: nvl(p_rec.attribute4, hr_api.g_varchar2) or
709: nvl(pqh_rei_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
702: nvl(p_rec.attribute1, hr_api.g_varchar2) or
703: nvl(pqh_rei_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
704: nvl(p_rec.attribute2, hr_api.g_varchar2) or
705: nvl(pqh_rei_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
706: nvl(p_rec.attribute3, hr_api.g_varchar2) or
707: nvl(pqh_rei_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
708: nvl(p_rec.attribute4, hr_api.g_varchar2) or
709: nvl(pqh_rei_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
710: nvl(p_rec.attribute5, hr_api.g_varchar2) or
703: nvl(pqh_rei_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
704: nvl(p_rec.attribute2, hr_api.g_varchar2) or
705: nvl(pqh_rei_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
706: nvl(p_rec.attribute3, hr_api.g_varchar2) or
707: nvl(pqh_rei_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
708: nvl(p_rec.attribute4, hr_api.g_varchar2) or
709: nvl(pqh_rei_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
710: nvl(p_rec.attribute5, hr_api.g_varchar2) or
711: nvl(pqh_rei_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
704: nvl(p_rec.attribute2, hr_api.g_varchar2) or
705: nvl(pqh_rei_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
706: nvl(p_rec.attribute3, hr_api.g_varchar2) or
707: nvl(pqh_rei_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
708: nvl(p_rec.attribute4, hr_api.g_varchar2) or
709: nvl(pqh_rei_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
710: nvl(p_rec.attribute5, hr_api.g_varchar2) or
711: nvl(pqh_rei_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
712: nvl(p_rec.attribute6, hr_api.g_varchar2) or
705: nvl(pqh_rei_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
706: nvl(p_rec.attribute3, hr_api.g_varchar2) or
707: nvl(pqh_rei_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
708: nvl(p_rec.attribute4, hr_api.g_varchar2) or
709: nvl(pqh_rei_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
710: nvl(p_rec.attribute5, hr_api.g_varchar2) or
711: nvl(pqh_rei_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
712: nvl(p_rec.attribute6, hr_api.g_varchar2) or
713: nvl(pqh_rei_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
706: nvl(p_rec.attribute3, hr_api.g_varchar2) or
707: nvl(pqh_rei_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
708: nvl(p_rec.attribute4, hr_api.g_varchar2) or
709: nvl(pqh_rei_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
710: nvl(p_rec.attribute5, hr_api.g_varchar2) or
711: nvl(pqh_rei_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
712: nvl(p_rec.attribute6, hr_api.g_varchar2) or
713: nvl(pqh_rei_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
714: nvl(p_rec.attribute7, hr_api.g_varchar2) or
707: nvl(pqh_rei_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
708: nvl(p_rec.attribute4, hr_api.g_varchar2) or
709: nvl(pqh_rei_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
710: nvl(p_rec.attribute5, hr_api.g_varchar2) or
711: nvl(pqh_rei_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
712: nvl(p_rec.attribute6, hr_api.g_varchar2) or
713: nvl(pqh_rei_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
714: nvl(p_rec.attribute7, hr_api.g_varchar2) or
715: nvl(pqh_rei_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
708: nvl(p_rec.attribute4, hr_api.g_varchar2) or
709: nvl(pqh_rei_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
710: nvl(p_rec.attribute5, hr_api.g_varchar2) or
711: nvl(pqh_rei_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
712: nvl(p_rec.attribute6, hr_api.g_varchar2) or
713: nvl(pqh_rei_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
714: nvl(p_rec.attribute7, hr_api.g_varchar2) or
715: nvl(pqh_rei_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
716: nvl(p_rec.attribute8, hr_api.g_varchar2) or
709: nvl(pqh_rei_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
710: nvl(p_rec.attribute5, hr_api.g_varchar2) or
711: nvl(pqh_rei_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
712: nvl(p_rec.attribute6, hr_api.g_varchar2) or
713: nvl(pqh_rei_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
714: nvl(p_rec.attribute7, hr_api.g_varchar2) or
715: nvl(pqh_rei_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
716: nvl(p_rec.attribute8, hr_api.g_varchar2) or
717: nvl(pqh_rei_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
710: nvl(p_rec.attribute5, hr_api.g_varchar2) or
711: nvl(pqh_rei_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
712: nvl(p_rec.attribute6, hr_api.g_varchar2) or
713: nvl(pqh_rei_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
714: nvl(p_rec.attribute7, hr_api.g_varchar2) or
715: nvl(pqh_rei_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
716: nvl(p_rec.attribute8, hr_api.g_varchar2) or
717: nvl(pqh_rei_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
718: nvl(p_rec.attribute9, hr_api.g_varchar2) or
711: nvl(pqh_rei_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
712: nvl(p_rec.attribute6, hr_api.g_varchar2) or
713: nvl(pqh_rei_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
714: nvl(p_rec.attribute7, hr_api.g_varchar2) or
715: nvl(pqh_rei_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
716: nvl(p_rec.attribute8, hr_api.g_varchar2) or
717: nvl(pqh_rei_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
718: nvl(p_rec.attribute9, hr_api.g_varchar2) or
719: nvl(pqh_rei_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
712: nvl(p_rec.attribute6, hr_api.g_varchar2) or
713: nvl(pqh_rei_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
714: nvl(p_rec.attribute7, hr_api.g_varchar2) or
715: nvl(pqh_rei_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
716: nvl(p_rec.attribute8, hr_api.g_varchar2) or
717: nvl(pqh_rei_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
718: nvl(p_rec.attribute9, hr_api.g_varchar2) or
719: nvl(pqh_rei_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
720: nvl(p_rec.attribute10, hr_api.g_varchar2) or
713: nvl(pqh_rei_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
714: nvl(p_rec.attribute7, hr_api.g_varchar2) or
715: nvl(pqh_rei_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
716: nvl(p_rec.attribute8, hr_api.g_varchar2) or
717: nvl(pqh_rei_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
718: nvl(p_rec.attribute9, hr_api.g_varchar2) or
719: nvl(pqh_rei_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
720: nvl(p_rec.attribute10, hr_api.g_varchar2) or
721: nvl(pqh_rei_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
714: nvl(p_rec.attribute7, hr_api.g_varchar2) or
715: nvl(pqh_rei_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
716: nvl(p_rec.attribute8, hr_api.g_varchar2) or
717: nvl(pqh_rei_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
718: nvl(p_rec.attribute9, hr_api.g_varchar2) or
719: nvl(pqh_rei_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
720: nvl(p_rec.attribute10, hr_api.g_varchar2) or
721: nvl(pqh_rei_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
722: nvl(p_rec.attribute11, hr_api.g_varchar2) or
715: nvl(pqh_rei_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
716: nvl(p_rec.attribute8, hr_api.g_varchar2) or
717: nvl(pqh_rei_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
718: nvl(p_rec.attribute9, hr_api.g_varchar2) or
719: nvl(pqh_rei_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
720: nvl(p_rec.attribute10, hr_api.g_varchar2) or
721: nvl(pqh_rei_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
722: nvl(p_rec.attribute11, hr_api.g_varchar2) or
723: nvl(pqh_rei_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
716: nvl(p_rec.attribute8, hr_api.g_varchar2) or
717: nvl(pqh_rei_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
718: nvl(p_rec.attribute9, hr_api.g_varchar2) or
719: nvl(pqh_rei_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
720: nvl(p_rec.attribute10, hr_api.g_varchar2) or
721: nvl(pqh_rei_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
722: nvl(p_rec.attribute11, hr_api.g_varchar2) or
723: nvl(pqh_rei_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
724: nvl(p_rec.attribute12, hr_api.g_varchar2) or
717: nvl(pqh_rei_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
718: nvl(p_rec.attribute9, hr_api.g_varchar2) or
719: nvl(pqh_rei_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
720: nvl(p_rec.attribute10, hr_api.g_varchar2) or
721: nvl(pqh_rei_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
722: nvl(p_rec.attribute11, hr_api.g_varchar2) or
723: nvl(pqh_rei_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
724: nvl(p_rec.attribute12, hr_api.g_varchar2) or
725: nvl(pqh_rei_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
718: nvl(p_rec.attribute9, hr_api.g_varchar2) or
719: nvl(pqh_rei_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
720: nvl(p_rec.attribute10, hr_api.g_varchar2) or
721: nvl(pqh_rei_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
722: nvl(p_rec.attribute11, hr_api.g_varchar2) or
723: nvl(pqh_rei_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
724: nvl(p_rec.attribute12, hr_api.g_varchar2) or
725: nvl(pqh_rei_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
726: nvl(p_rec.attribute13, hr_api.g_varchar2) or
719: nvl(pqh_rei_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
720: nvl(p_rec.attribute10, hr_api.g_varchar2) or
721: nvl(pqh_rei_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
722: nvl(p_rec.attribute11, hr_api.g_varchar2) or
723: nvl(pqh_rei_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
724: nvl(p_rec.attribute12, hr_api.g_varchar2) or
725: nvl(pqh_rei_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
726: nvl(p_rec.attribute13, hr_api.g_varchar2) or
727: nvl(pqh_rei_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
720: nvl(p_rec.attribute10, hr_api.g_varchar2) or
721: nvl(pqh_rei_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
722: nvl(p_rec.attribute11, hr_api.g_varchar2) or
723: nvl(pqh_rei_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
724: nvl(p_rec.attribute12, hr_api.g_varchar2) or
725: nvl(pqh_rei_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
726: nvl(p_rec.attribute13, hr_api.g_varchar2) or
727: nvl(pqh_rei_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
728: nvl(p_rec.attribute14, hr_api.g_varchar2) or
721: nvl(pqh_rei_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
722: nvl(p_rec.attribute11, hr_api.g_varchar2) or
723: nvl(pqh_rei_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
724: nvl(p_rec.attribute12, hr_api.g_varchar2) or
725: nvl(pqh_rei_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
726: nvl(p_rec.attribute13, hr_api.g_varchar2) or
727: nvl(pqh_rei_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
728: nvl(p_rec.attribute14, hr_api.g_varchar2) or
729: nvl(pqh_rei_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
722: nvl(p_rec.attribute11, hr_api.g_varchar2) or
723: nvl(pqh_rei_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
724: nvl(p_rec.attribute12, hr_api.g_varchar2) or
725: nvl(pqh_rei_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
726: nvl(p_rec.attribute13, hr_api.g_varchar2) or
727: nvl(pqh_rei_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
728: nvl(p_rec.attribute14, hr_api.g_varchar2) or
729: nvl(pqh_rei_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
730: nvl(p_rec.attribute15, hr_api.g_varchar2) or
723: nvl(pqh_rei_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
724: nvl(p_rec.attribute12, hr_api.g_varchar2) or
725: nvl(pqh_rei_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
726: nvl(p_rec.attribute13, hr_api.g_varchar2) or
727: nvl(pqh_rei_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
728: nvl(p_rec.attribute14, hr_api.g_varchar2) or
729: nvl(pqh_rei_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
730: nvl(p_rec.attribute15, hr_api.g_varchar2) or
731: nvl(pqh_rei_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
724: nvl(p_rec.attribute12, hr_api.g_varchar2) or
725: nvl(pqh_rei_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
726: nvl(p_rec.attribute13, hr_api.g_varchar2) or
727: nvl(pqh_rei_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
728: nvl(p_rec.attribute14, hr_api.g_varchar2) or
729: nvl(pqh_rei_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
730: nvl(p_rec.attribute15, hr_api.g_varchar2) or
731: nvl(pqh_rei_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
732: nvl(p_rec.attribute16, hr_api.g_varchar2) or
725: nvl(pqh_rei_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
726: nvl(p_rec.attribute13, hr_api.g_varchar2) or
727: nvl(pqh_rei_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
728: nvl(p_rec.attribute14, hr_api.g_varchar2) or
729: nvl(pqh_rei_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
730: nvl(p_rec.attribute15, hr_api.g_varchar2) or
731: nvl(pqh_rei_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
732: nvl(p_rec.attribute16, hr_api.g_varchar2) or
733: nvl(pqh_rei_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
726: nvl(p_rec.attribute13, hr_api.g_varchar2) or
727: nvl(pqh_rei_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
728: nvl(p_rec.attribute14, hr_api.g_varchar2) or
729: nvl(pqh_rei_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
730: nvl(p_rec.attribute15, hr_api.g_varchar2) or
731: nvl(pqh_rei_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
732: nvl(p_rec.attribute16, hr_api.g_varchar2) or
733: nvl(pqh_rei_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
734: nvl(p_rec.attribute17, hr_api.g_varchar2) or
727: nvl(pqh_rei_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
728: nvl(p_rec.attribute14, hr_api.g_varchar2) or
729: nvl(pqh_rei_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
730: nvl(p_rec.attribute15, hr_api.g_varchar2) or
731: nvl(pqh_rei_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
732: nvl(p_rec.attribute16, hr_api.g_varchar2) or
733: nvl(pqh_rei_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
734: nvl(p_rec.attribute17, hr_api.g_varchar2) or
735: nvl(pqh_rei_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
728: nvl(p_rec.attribute14, hr_api.g_varchar2) or
729: nvl(pqh_rei_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
730: nvl(p_rec.attribute15, hr_api.g_varchar2) or
731: nvl(pqh_rei_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
732: nvl(p_rec.attribute16, hr_api.g_varchar2) or
733: nvl(pqh_rei_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
734: nvl(p_rec.attribute17, hr_api.g_varchar2) or
735: nvl(pqh_rei_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
736: nvl(p_rec.attribute18, hr_api.g_varchar2) or
729: nvl(pqh_rei_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
730: nvl(p_rec.attribute15, hr_api.g_varchar2) or
731: nvl(pqh_rei_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
732: nvl(p_rec.attribute16, hr_api.g_varchar2) or
733: nvl(pqh_rei_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
734: nvl(p_rec.attribute17, hr_api.g_varchar2) or
735: nvl(pqh_rei_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
736: nvl(p_rec.attribute18, hr_api.g_varchar2) or
737: nvl(pqh_rei_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
730: nvl(p_rec.attribute15, hr_api.g_varchar2) or
731: nvl(pqh_rei_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
732: nvl(p_rec.attribute16, hr_api.g_varchar2) or
733: nvl(pqh_rei_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
734: nvl(p_rec.attribute17, hr_api.g_varchar2) or
735: nvl(pqh_rei_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
736: nvl(p_rec.attribute18, hr_api.g_varchar2) or
737: nvl(pqh_rei_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
738: nvl(p_rec.attribute19, hr_api.g_varchar2) or
731: nvl(pqh_rei_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
732: nvl(p_rec.attribute16, hr_api.g_varchar2) or
733: nvl(pqh_rei_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
734: nvl(p_rec.attribute17, hr_api.g_varchar2) or
735: nvl(pqh_rei_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
736: nvl(p_rec.attribute18, hr_api.g_varchar2) or
737: nvl(pqh_rei_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
738: nvl(p_rec.attribute19, hr_api.g_varchar2) or
739: nvl(pqh_rei_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
732: nvl(p_rec.attribute16, hr_api.g_varchar2) or
733: nvl(pqh_rei_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
734: nvl(p_rec.attribute17, hr_api.g_varchar2) or
735: nvl(pqh_rei_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
736: nvl(p_rec.attribute18, hr_api.g_varchar2) or
737: nvl(pqh_rei_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
738: nvl(p_rec.attribute19, hr_api.g_varchar2) or
739: nvl(pqh_rei_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
740: nvl(p_rec.attribute20, hr_api.g_varchar2) or
733: nvl(pqh_rei_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
734: nvl(p_rec.attribute17, hr_api.g_varchar2) or
735: nvl(pqh_rei_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
736: nvl(p_rec.attribute18, hr_api.g_varchar2) or
737: nvl(pqh_rei_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
738: nvl(p_rec.attribute19, hr_api.g_varchar2) or
739: nvl(pqh_rei_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
740: nvl(p_rec.attribute20, hr_api.g_varchar2) or
741: nvl(pqh_rei_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
734: nvl(p_rec.attribute17, hr_api.g_varchar2) or
735: nvl(pqh_rei_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
736: nvl(p_rec.attribute18, hr_api.g_varchar2) or
737: nvl(pqh_rei_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
738: nvl(p_rec.attribute19, hr_api.g_varchar2) or
739: nvl(pqh_rei_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
740: nvl(p_rec.attribute20, hr_api.g_varchar2) or
741: nvl(pqh_rei_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
742: nvl(p_rec.attribute21, hr_api.g_varchar2) or
735: nvl(pqh_rei_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
736: nvl(p_rec.attribute18, hr_api.g_varchar2) or
737: nvl(pqh_rei_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
738: nvl(p_rec.attribute19, hr_api.g_varchar2) or
739: nvl(pqh_rei_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
740: nvl(p_rec.attribute20, hr_api.g_varchar2) or
741: nvl(pqh_rei_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
742: nvl(p_rec.attribute21, hr_api.g_varchar2) or
743: nvl(pqh_rei_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
736: nvl(p_rec.attribute18, hr_api.g_varchar2) or
737: nvl(pqh_rei_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
738: nvl(p_rec.attribute19, hr_api.g_varchar2) or
739: nvl(pqh_rei_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
740: nvl(p_rec.attribute20, hr_api.g_varchar2) or
741: nvl(pqh_rei_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
742: nvl(p_rec.attribute21, hr_api.g_varchar2) or
743: nvl(pqh_rei_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
744: nvl(p_rec.attribute22, hr_api.g_varchar2) or
737: nvl(pqh_rei_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
738: nvl(p_rec.attribute19, hr_api.g_varchar2) or
739: nvl(pqh_rei_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
740: nvl(p_rec.attribute20, hr_api.g_varchar2) or
741: nvl(pqh_rei_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
742: nvl(p_rec.attribute21, hr_api.g_varchar2) or
743: nvl(pqh_rei_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
744: nvl(p_rec.attribute22, hr_api.g_varchar2) or
745: nvl(pqh_rei_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
738: nvl(p_rec.attribute19, hr_api.g_varchar2) or
739: nvl(pqh_rei_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
740: nvl(p_rec.attribute20, hr_api.g_varchar2) or
741: nvl(pqh_rei_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
742: nvl(p_rec.attribute21, hr_api.g_varchar2) or
743: nvl(pqh_rei_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
744: nvl(p_rec.attribute22, hr_api.g_varchar2) or
745: nvl(pqh_rei_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
746: nvl(p_rec.attribute23, hr_api.g_varchar2) or
739: nvl(pqh_rei_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
740: nvl(p_rec.attribute20, hr_api.g_varchar2) or
741: nvl(pqh_rei_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
742: nvl(p_rec.attribute21, hr_api.g_varchar2) or
743: nvl(pqh_rei_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
744: nvl(p_rec.attribute22, hr_api.g_varchar2) or
745: nvl(pqh_rei_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
746: nvl(p_rec.attribute23, hr_api.g_varchar2) or
747: nvl(pqh_rei_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
740: nvl(p_rec.attribute20, hr_api.g_varchar2) or
741: nvl(pqh_rei_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
742: nvl(p_rec.attribute21, hr_api.g_varchar2) or
743: nvl(pqh_rei_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
744: nvl(p_rec.attribute22, hr_api.g_varchar2) or
745: nvl(pqh_rei_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
746: nvl(p_rec.attribute23, hr_api.g_varchar2) or
747: nvl(pqh_rei_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
748: nvl(p_rec.attribute24, hr_api.g_varchar2) or
741: nvl(pqh_rei_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
742: nvl(p_rec.attribute21, hr_api.g_varchar2) or
743: nvl(pqh_rei_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
744: nvl(p_rec.attribute22, hr_api.g_varchar2) or
745: nvl(pqh_rei_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
746: nvl(p_rec.attribute23, hr_api.g_varchar2) or
747: nvl(pqh_rei_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
748: nvl(p_rec.attribute24, hr_api.g_varchar2) or
749: nvl(pqh_rei_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
742: nvl(p_rec.attribute21, hr_api.g_varchar2) or
743: nvl(pqh_rei_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
744: nvl(p_rec.attribute22, hr_api.g_varchar2) or
745: nvl(pqh_rei_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
746: nvl(p_rec.attribute23, hr_api.g_varchar2) or
747: nvl(pqh_rei_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
748: nvl(p_rec.attribute24, hr_api.g_varchar2) or
749: nvl(pqh_rei_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
750: nvl(p_rec.attribute25, hr_api.g_varchar2) or
743: nvl(pqh_rei_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
744: nvl(p_rec.attribute22, hr_api.g_varchar2) or
745: nvl(pqh_rei_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
746: nvl(p_rec.attribute23, hr_api.g_varchar2) or
747: nvl(pqh_rei_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
748: nvl(p_rec.attribute24, hr_api.g_varchar2) or
749: nvl(pqh_rei_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
750: nvl(p_rec.attribute25, hr_api.g_varchar2) or
751: nvl(pqh_rei_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
744: nvl(p_rec.attribute22, hr_api.g_varchar2) or
745: nvl(pqh_rei_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
746: nvl(p_rec.attribute23, hr_api.g_varchar2) or
747: nvl(pqh_rei_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
748: nvl(p_rec.attribute24, hr_api.g_varchar2) or
749: nvl(pqh_rei_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
750: nvl(p_rec.attribute25, hr_api.g_varchar2) or
751: nvl(pqh_rei_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
752: nvl(p_rec.attribute26, hr_api.g_varchar2) or
745: nvl(pqh_rei_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
746: nvl(p_rec.attribute23, hr_api.g_varchar2) or
747: nvl(pqh_rei_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
748: nvl(p_rec.attribute24, hr_api.g_varchar2) or
749: nvl(pqh_rei_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
750: nvl(p_rec.attribute25, hr_api.g_varchar2) or
751: nvl(pqh_rei_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
752: nvl(p_rec.attribute26, hr_api.g_varchar2) or
753: nvl(pqh_rei_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
746: nvl(p_rec.attribute23, hr_api.g_varchar2) or
747: nvl(pqh_rei_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
748: nvl(p_rec.attribute24, hr_api.g_varchar2) or
749: nvl(pqh_rei_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
750: nvl(p_rec.attribute25, hr_api.g_varchar2) or
751: nvl(pqh_rei_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
752: nvl(p_rec.attribute26, hr_api.g_varchar2) or
753: nvl(pqh_rei_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
754: nvl(p_rec.attribute27, hr_api.g_varchar2) or
747: nvl(pqh_rei_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
748: nvl(p_rec.attribute24, hr_api.g_varchar2) or
749: nvl(pqh_rei_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
750: nvl(p_rec.attribute25, hr_api.g_varchar2) or
751: nvl(pqh_rei_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
752: nvl(p_rec.attribute26, hr_api.g_varchar2) or
753: nvl(pqh_rei_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
754: nvl(p_rec.attribute27, hr_api.g_varchar2) or
755: nvl(pqh_rei_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
748: nvl(p_rec.attribute24, hr_api.g_varchar2) or
749: nvl(pqh_rei_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
750: nvl(p_rec.attribute25, hr_api.g_varchar2) or
751: nvl(pqh_rei_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
752: nvl(p_rec.attribute26, hr_api.g_varchar2) or
753: nvl(pqh_rei_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
754: nvl(p_rec.attribute27, hr_api.g_varchar2) or
755: nvl(pqh_rei_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
756: nvl(p_rec.attribute28, hr_api.g_varchar2) or
749: nvl(pqh_rei_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
750: nvl(p_rec.attribute25, hr_api.g_varchar2) or
751: nvl(pqh_rei_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
752: nvl(p_rec.attribute26, hr_api.g_varchar2) or
753: nvl(pqh_rei_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
754: nvl(p_rec.attribute27, hr_api.g_varchar2) or
755: nvl(pqh_rei_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
756: nvl(p_rec.attribute28, hr_api.g_varchar2) or
757: nvl(pqh_rei_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
750: nvl(p_rec.attribute25, hr_api.g_varchar2) or
751: nvl(pqh_rei_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
752: nvl(p_rec.attribute26, hr_api.g_varchar2) or
753: nvl(pqh_rei_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
754: nvl(p_rec.attribute27, hr_api.g_varchar2) or
755: nvl(pqh_rei_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
756: nvl(p_rec.attribute28, hr_api.g_varchar2) or
757: nvl(pqh_rei_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
758: nvl(p_rec.attribute29, hr_api.g_varchar2) or
751: nvl(pqh_rei_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
752: nvl(p_rec.attribute26, hr_api.g_varchar2) or
753: nvl(pqh_rei_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
754: nvl(p_rec.attribute27, hr_api.g_varchar2) or
755: nvl(pqh_rei_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
756: nvl(p_rec.attribute28, hr_api.g_varchar2) or
757: nvl(pqh_rei_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
758: nvl(p_rec.attribute29, hr_api.g_varchar2) or
759: nvl(pqh_rei_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
752: nvl(p_rec.attribute26, hr_api.g_varchar2) or
753: nvl(pqh_rei_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
754: nvl(p_rec.attribute27, hr_api.g_varchar2) or
755: nvl(pqh_rei_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
756: nvl(p_rec.attribute28, hr_api.g_varchar2) or
757: nvl(pqh_rei_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
758: nvl(p_rec.attribute29, hr_api.g_varchar2) or
759: nvl(pqh_rei_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
760: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
753: nvl(pqh_rei_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
754: nvl(p_rec.attribute27, hr_api.g_varchar2) or
755: nvl(pqh_rei_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
756: nvl(p_rec.attribute28, hr_api.g_varchar2) or
757: nvl(pqh_rei_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
758: nvl(p_rec.attribute29, hr_api.g_varchar2) or
759: nvl(pqh_rei_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
760: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
761: or (p_rec.role_extra_info_id is null) then
754: nvl(p_rec.attribute27, hr_api.g_varchar2) or
755: nvl(pqh_rei_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
756: nvl(p_rec.attribute28, hr_api.g_varchar2) or
757: nvl(pqh_rei_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
758: nvl(p_rec.attribute29, hr_api.g_varchar2) or
759: nvl(pqh_rei_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
760: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
761: or (p_rec.role_extra_info_id is null) then
762: --
755: nvl(pqh_rei_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
756: nvl(p_rec.attribute28, hr_api.g_varchar2) or
757: nvl(pqh_rei_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
758: nvl(p_rec.attribute29, hr_api.g_varchar2) or
759: nvl(pqh_rei_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
760: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
761: or (p_rec.role_extra_info_id is null) then
762: --
763: -- Only execute the validation if absolutely necessary:
756: nvl(p_rec.attribute28, hr_api.g_varchar2) or
757: nvl(pqh_rei_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
758: nvl(p_rec.attribute29, hr_api.g_varchar2) or
759: nvl(pqh_rei_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
760: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
761: or (p_rec.role_extra_info_id is null) then
762: --
763: -- Only execute the validation if absolutely necessary:
764: -- a) During update, the structure column value or any