APPS.PQH_REI_BUS dependencies on HR_API

Line 47: hr_api.mandatory_arg_error

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

Line 73: hr_api.set_security_group_id

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

Line 114: hr_api.mandatory_arg_error

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

Line 120: if ( nvl(pqh_rei_bus.g_role_extra_info_id, hr_api.g_number)

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

Line 207: hr_api.mandatory_arg_error

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

Line 287: hr_api.mandatory_arg_error

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

Line 454: if nvl(p_rec.information_type, hr_api.g_varchar2) <>

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;

Line 455: nvl(pqh_rei_shd.g_old_rec.information_type, hr_api.g_varchar2) then

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

Line 462: if nvl(p_rec.role_id, hr_api.g_number) <>

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;

Line 463: nvl(pqh_rei_shd.g_old_rec.role_id, hr_api.g_number) then

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

Line 471: hr_api.argument_changed_error

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

Line 520: nvl(pqh_rei_shd.g_old_rec.information_type, hr_api.g_varchar2) <>

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

Line 521: nvl(p_rec.information_type, hr_api.g_varchar2) or

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

Line 522: nvl(pqh_rei_shd.g_old_rec.information_category, hr_api.g_varchar2) <>

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

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

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

Line 524: nvl(pqh_rei_shd.g_old_rec.information1, hr_api.g_varchar2) <>

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

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

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

Line 526: nvl(pqh_rei_shd.g_old_rec.information2, hr_api.g_varchar2) <>

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

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

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

Line 528: nvl(pqh_rei_shd.g_old_rec.information3, hr_api.g_varchar2) <>

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

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

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

Line 530: nvl(pqh_rei_shd.g_old_rec.information4, hr_api.g_varchar2) <>

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

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

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

Line 532: nvl(pqh_rei_shd.g_old_rec.information5, hr_api.g_varchar2) <>

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

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

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

Line 534: nvl(pqh_rei_shd.g_old_rec.information6, hr_api.g_varchar2) <>

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

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

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

Line 536: nvl(pqh_rei_shd.g_old_rec.information7, hr_api.g_varchar2) <>

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

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

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

Line 538: nvl(pqh_rei_shd.g_old_rec.information8, hr_api.g_varchar2) <>

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

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

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

Line 540: nvl(pqh_rei_shd.g_old_rec.information9, hr_api.g_varchar2) <>

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

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

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

Line 542: nvl(pqh_rei_shd.g_old_rec.information10, hr_api.g_varchar2) <>

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

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

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

Line 544: nvl(pqh_rei_shd.g_old_rec.information11, hr_api.g_varchar2) <>

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

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

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

Line 546: nvl(pqh_rei_shd.g_old_rec.information12, hr_api.g_varchar2) <>

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

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

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

Line 548: nvl(pqh_rei_shd.g_old_rec.information13, hr_api.g_varchar2) <>

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

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

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

Line 550: nvl(pqh_rei_shd.g_old_rec.information14, hr_api.g_varchar2) <>

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

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

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

Line 552: nvl(pqh_rei_shd.g_old_rec.information15, hr_api.g_varchar2) <>

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

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

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

Line 554: nvl(pqh_rei_shd.g_old_rec.information16, hr_api.g_varchar2) <>

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

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

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

Line 556: nvl(pqh_rei_shd.g_old_rec.information17, hr_api.g_varchar2) <>

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

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

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

Line 558: nvl(pqh_rei_shd.g_old_rec.information18, hr_api.g_varchar2) <>

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

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

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

Line 560: nvl(pqh_rei_shd.g_old_rec.information19, hr_api.g_varchar2) <>

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

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

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

Line 562: nvl(pqh_rei_shd.g_old_rec.information20, hr_api.g_varchar2) <>

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

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

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

Line 564: nvl(pqh_rei_shd.g_old_rec.information21, hr_api.g_varchar2) <>

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

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

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

Line 566: nvl(pqh_rei_shd.g_old_rec.information22, hr_api.g_varchar2) <>

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

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

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

Line 568: nvl(pqh_rei_shd.g_old_rec.information23, hr_api.g_varchar2) <>

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

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

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

Line 570: nvl(pqh_rei_shd.g_old_rec.information24, hr_api.g_varchar2) <>

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

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

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

Line 572: nvl(pqh_rei_shd.g_old_rec.information25, hr_api.g_varchar2) <>

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

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

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

Line 574: nvl(pqh_rei_shd.g_old_rec.information26, hr_api.g_varchar2) <>

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

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

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

Line 576: nvl(pqh_rei_shd.g_old_rec.information27, hr_api.g_varchar2) <>

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

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

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

Line 578: nvl(pqh_rei_shd.g_old_rec.information28, hr_api.g_varchar2) <>

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

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

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

Line 580: nvl(pqh_rei_shd.g_old_rec.information29, hr_api.g_varchar2) <>

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

Line 581: nvl(p_rec.information29, hr_api.g_varchar2) or

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

Line 582: nvl(pqh_rei_shd.g_old_rec.information30, hr_api.g_varchar2) <>

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:

Line 583: nvl(p_rec.information30, hr_api.g_varchar2) )) or

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

Line 699: nvl(pqh_rei_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

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

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

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

Line 701: nvl(pqh_rei_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

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

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

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

Line 703: nvl(pqh_rei_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

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

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

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

Line 705: nvl(pqh_rei_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

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

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

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

Line 707: nvl(pqh_rei_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

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

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

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

Line 709: nvl(pqh_rei_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

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

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

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

Line 711: nvl(pqh_rei_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

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

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

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

Line 713: nvl(pqh_rei_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

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

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

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

Line 715: nvl(pqh_rei_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

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

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

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

Line 717: nvl(pqh_rei_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

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

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

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

Line 719: nvl(pqh_rei_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

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

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

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

Line 721: nvl(pqh_rei_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

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

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

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

Line 723: nvl(pqh_rei_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

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

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

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

Line 725: nvl(pqh_rei_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

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

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

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

Line 727: nvl(pqh_rei_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

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

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

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

Line 729: nvl(pqh_rei_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

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

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

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

Line 731: nvl(pqh_rei_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

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

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

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

Line 733: nvl(pqh_rei_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

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

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

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

Line 735: nvl(pqh_rei_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

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

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

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

Line 737: nvl(pqh_rei_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

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

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

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

Line 739: nvl(pqh_rei_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

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

Line 740: nvl(p_rec.attribute20, hr_api.g_varchar2) or

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

Line 741: nvl(pqh_rei_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>

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

Line 742: nvl(p_rec.attribute21, hr_api.g_varchar2) or

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

Line 743: nvl(pqh_rei_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>

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

Line 744: nvl(p_rec.attribute22, hr_api.g_varchar2) or

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

Line 745: nvl(pqh_rei_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>

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

Line 746: nvl(p_rec.attribute23, hr_api.g_varchar2) or

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

Line 747: nvl(pqh_rei_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>

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

Line 748: nvl(p_rec.attribute24, hr_api.g_varchar2) or

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

Line 749: nvl(pqh_rei_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>

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

Line 750: nvl(p_rec.attribute25, hr_api.g_varchar2) or

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

Line 751: nvl(pqh_rei_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>

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

Line 752: nvl(p_rec.attribute26, hr_api.g_varchar2) or

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

Line 753: nvl(pqh_rei_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>

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

Line 754: nvl(p_rec.attribute27, hr_api.g_varchar2) or

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

Line 755: nvl(pqh_rei_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>

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

Line 756: nvl(p_rec.attribute28, hr_api.g_varchar2) or

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

Line 757: nvl(pqh_rei_shd.g_old_rec.attribute29, 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

Line 758: nvl(p_rec.attribute29, hr_api.g_varchar2) or

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

Line 759: nvl(pqh_rei_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>

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:

Line 760: nvl(p_rec.attribute30, 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:
764: -- a) During update, the structure column value or any