39: hr_utility.set_location('Entering:'|| l_proc, 10);
40: --
41: -- Ensure that all the mandatory parameter are not null
42: --
43: hr_api.mandatory_arg_error
44: (p_api_name => l_proc
45: ,p_argument => 'assignment_extra_info_id'
46: ,p_argument_value => p_assignment_extra_info_id
47: );
63: close csr_sec_grp;
64: --
65: -- Set the security_group_id in CLIENT_INFO
66: --
67: hr_api.set_security_group_id
68: (p_security_group_id => l_security_group_id
69: );
70: --
71: hr_utility.set_location(' Leaving:'|| l_proc, 20);
97: l_proc varchar2(72) := g_package||'return_legislation_code';
98: Begin
99: --
100: hr_utility.set_location('Entering:'||l_proc, 5);
101: hr_api.mandatory_arg_error(p_api_name => l_proc
102: ,p_argument => 'assignment_extra_info_id'
103: ,p_argument_value => p_assignment_extra_info_id
104: );
105:
103: ,p_argument_value => p_assignment_extra_info_id
104: );
105:
106: --
107: if ( nvl(pe_aei_bus.g_assignment_extra_info_id, hr_api.g_number)
108: = p_assignment_extra_info_id) then
109: --
110: -- The legislation code has already been found with a previous
111: -- call to this function. Just return the value in the global
193: hr_utility.set_location('Entering:'||l_proc, 1);
194: --
195: -- Check mandatory parameters have been set
196: --
197: hr_api.mandatory_arg_error
198: (
199: p_api_name => l_proc,
200: p_argument => 'information_type',
201: p_argument_value => p_information_type
274: hr_utility.set_location('Entering:'||l_proc, 1);
275: --
276: -- Check mandatory parameters have been set
277: --
278: hr_api.mandatory_arg_error
279: (
280: p_api_name => l_proc,
281: p_argument => 'assignment_id',
282: p_argument_value => p_assignment_id
440: end if;
441: --
442: hr_utility.set_location(l_proc, 30);
443: --
444: if nvl(p_rec.information_type, hr_api.g_varchar2) <>
445: nvl(pe_aei_shd.g_old_rec.information_type, hr_api.g_varchar2) then
446: l_argument := 'information_type';
447: raise l_error;
448: end if;
441: --
442: hr_utility.set_location(l_proc, 30);
443: --
444: if nvl(p_rec.information_type, hr_api.g_varchar2) <>
445: nvl(pe_aei_shd.g_old_rec.information_type, hr_api.g_varchar2) then
446: l_argument := 'information_type';
447: raise l_error;
448: end if;
449: --
448: end if;
449: --
450: hr_utility.set_location(l_proc, 40);
451: --
452: if nvl(p_rec.assignment_id, hr_api.g_number) <>
453: nvl(pe_aei_shd.g_old_rec.assignment_id, hr_api.g_number) then
454: l_argument := 'assignment_id';
455: raise l_error;
456: end if;
449: --
450: hr_utility.set_location(l_proc, 40);
451: --
452: if nvl(p_rec.assignment_id, hr_api.g_number) <>
453: nvl(pe_aei_shd.g_old_rec.assignment_id, hr_api.g_number) then
454: l_argument := 'assignment_id';
455: raise l_error;
456: end if;
457: --
457: --
458: hr_utility.set_location(' Leaving:'||l_proc, 50);
459: exception
460: when l_error then
461: hr_api.argument_changed_error
462: (p_api_name => l_proc
463: ,p_argument => l_argument
464: );
465: hr_utility.set_location(l_proc, 60);
506: begin
507: hr_utility.set_location('Entering:'||l_proc, 10);
508: --
509: if ((p_rec.assignment_extra_info_id is not null) and (
510: nvl(pe_aei_shd.g_old_rec.aei_attribute_category, hr_api.g_varchar2) <>
511: nvl(p_rec.aei_attribute_category, hr_api.g_varchar2) or
512: nvl(pe_aei_shd.g_old_rec.aei_attribute1, hr_api.g_varchar2) <>
513: nvl(p_rec.aei_attribute1, hr_api.g_varchar2) or
514: nvl(pe_aei_shd.g_old_rec.aei_attribute2, hr_api.g_varchar2) <>
507: hr_utility.set_location('Entering:'||l_proc, 10);
508: --
509: if ((p_rec.assignment_extra_info_id is not null) and (
510: nvl(pe_aei_shd.g_old_rec.aei_attribute_category, hr_api.g_varchar2) <>
511: nvl(p_rec.aei_attribute_category, hr_api.g_varchar2) or
512: nvl(pe_aei_shd.g_old_rec.aei_attribute1, hr_api.g_varchar2) <>
513: nvl(p_rec.aei_attribute1, hr_api.g_varchar2) or
514: nvl(pe_aei_shd.g_old_rec.aei_attribute2, hr_api.g_varchar2) <>
515: nvl(p_rec.aei_attribute2, hr_api.g_varchar2) or
508: --
509: if ((p_rec.assignment_extra_info_id is not null) and (
510: nvl(pe_aei_shd.g_old_rec.aei_attribute_category, hr_api.g_varchar2) <>
511: nvl(p_rec.aei_attribute_category, hr_api.g_varchar2) or
512: nvl(pe_aei_shd.g_old_rec.aei_attribute1, hr_api.g_varchar2) <>
513: nvl(p_rec.aei_attribute1, hr_api.g_varchar2) or
514: nvl(pe_aei_shd.g_old_rec.aei_attribute2, hr_api.g_varchar2) <>
515: nvl(p_rec.aei_attribute2, hr_api.g_varchar2) or
516: nvl(pe_aei_shd.g_old_rec.aei_attribute3, hr_api.g_varchar2) <>
509: if ((p_rec.assignment_extra_info_id is not null) and (
510: nvl(pe_aei_shd.g_old_rec.aei_attribute_category, hr_api.g_varchar2) <>
511: nvl(p_rec.aei_attribute_category, hr_api.g_varchar2) or
512: nvl(pe_aei_shd.g_old_rec.aei_attribute1, hr_api.g_varchar2) <>
513: nvl(p_rec.aei_attribute1, hr_api.g_varchar2) or
514: nvl(pe_aei_shd.g_old_rec.aei_attribute2, hr_api.g_varchar2) <>
515: nvl(p_rec.aei_attribute2, hr_api.g_varchar2) or
516: nvl(pe_aei_shd.g_old_rec.aei_attribute3, hr_api.g_varchar2) <>
517: nvl(p_rec.aei_attribute3, hr_api.g_varchar2) or
510: nvl(pe_aei_shd.g_old_rec.aei_attribute_category, hr_api.g_varchar2) <>
511: nvl(p_rec.aei_attribute_category, hr_api.g_varchar2) or
512: nvl(pe_aei_shd.g_old_rec.aei_attribute1, hr_api.g_varchar2) <>
513: nvl(p_rec.aei_attribute1, hr_api.g_varchar2) or
514: nvl(pe_aei_shd.g_old_rec.aei_attribute2, hr_api.g_varchar2) <>
515: nvl(p_rec.aei_attribute2, hr_api.g_varchar2) or
516: nvl(pe_aei_shd.g_old_rec.aei_attribute3, hr_api.g_varchar2) <>
517: nvl(p_rec.aei_attribute3, hr_api.g_varchar2) or
518: nvl(pe_aei_shd.g_old_rec.aei_attribute4, hr_api.g_varchar2) <>
511: nvl(p_rec.aei_attribute_category, hr_api.g_varchar2) or
512: nvl(pe_aei_shd.g_old_rec.aei_attribute1, hr_api.g_varchar2) <>
513: nvl(p_rec.aei_attribute1, hr_api.g_varchar2) or
514: nvl(pe_aei_shd.g_old_rec.aei_attribute2, hr_api.g_varchar2) <>
515: nvl(p_rec.aei_attribute2, hr_api.g_varchar2) or
516: nvl(pe_aei_shd.g_old_rec.aei_attribute3, hr_api.g_varchar2) <>
517: nvl(p_rec.aei_attribute3, hr_api.g_varchar2) or
518: nvl(pe_aei_shd.g_old_rec.aei_attribute4, hr_api.g_varchar2) <>
519: nvl(p_rec.aei_attribute4, hr_api.g_varchar2) or
512: nvl(pe_aei_shd.g_old_rec.aei_attribute1, hr_api.g_varchar2) <>
513: nvl(p_rec.aei_attribute1, hr_api.g_varchar2) or
514: nvl(pe_aei_shd.g_old_rec.aei_attribute2, hr_api.g_varchar2) <>
515: nvl(p_rec.aei_attribute2, hr_api.g_varchar2) or
516: nvl(pe_aei_shd.g_old_rec.aei_attribute3, hr_api.g_varchar2) <>
517: nvl(p_rec.aei_attribute3, hr_api.g_varchar2) or
518: nvl(pe_aei_shd.g_old_rec.aei_attribute4, hr_api.g_varchar2) <>
519: nvl(p_rec.aei_attribute4, hr_api.g_varchar2) or
520: nvl(pe_aei_shd.g_old_rec.aei_attribute5, hr_api.g_varchar2) <>
513: nvl(p_rec.aei_attribute1, hr_api.g_varchar2) or
514: nvl(pe_aei_shd.g_old_rec.aei_attribute2, hr_api.g_varchar2) <>
515: nvl(p_rec.aei_attribute2, hr_api.g_varchar2) or
516: nvl(pe_aei_shd.g_old_rec.aei_attribute3, hr_api.g_varchar2) <>
517: nvl(p_rec.aei_attribute3, hr_api.g_varchar2) or
518: nvl(pe_aei_shd.g_old_rec.aei_attribute4, hr_api.g_varchar2) <>
519: nvl(p_rec.aei_attribute4, hr_api.g_varchar2) or
520: nvl(pe_aei_shd.g_old_rec.aei_attribute5, hr_api.g_varchar2) <>
521: nvl(p_rec.aei_attribute5, hr_api.g_varchar2) or
514: nvl(pe_aei_shd.g_old_rec.aei_attribute2, hr_api.g_varchar2) <>
515: nvl(p_rec.aei_attribute2, hr_api.g_varchar2) or
516: nvl(pe_aei_shd.g_old_rec.aei_attribute3, hr_api.g_varchar2) <>
517: nvl(p_rec.aei_attribute3, hr_api.g_varchar2) or
518: nvl(pe_aei_shd.g_old_rec.aei_attribute4, hr_api.g_varchar2) <>
519: nvl(p_rec.aei_attribute4, hr_api.g_varchar2) or
520: nvl(pe_aei_shd.g_old_rec.aei_attribute5, hr_api.g_varchar2) <>
521: nvl(p_rec.aei_attribute5, hr_api.g_varchar2) or
522: nvl(pe_aei_shd.g_old_rec.aei_attribute6, hr_api.g_varchar2) <>
515: nvl(p_rec.aei_attribute2, hr_api.g_varchar2) or
516: nvl(pe_aei_shd.g_old_rec.aei_attribute3, hr_api.g_varchar2) <>
517: nvl(p_rec.aei_attribute3, hr_api.g_varchar2) or
518: nvl(pe_aei_shd.g_old_rec.aei_attribute4, hr_api.g_varchar2) <>
519: nvl(p_rec.aei_attribute4, hr_api.g_varchar2) or
520: nvl(pe_aei_shd.g_old_rec.aei_attribute5, hr_api.g_varchar2) <>
521: nvl(p_rec.aei_attribute5, hr_api.g_varchar2) or
522: nvl(pe_aei_shd.g_old_rec.aei_attribute6, hr_api.g_varchar2) <>
523: nvl(p_rec.aei_attribute6, hr_api.g_varchar2) or
516: nvl(pe_aei_shd.g_old_rec.aei_attribute3, hr_api.g_varchar2) <>
517: nvl(p_rec.aei_attribute3, hr_api.g_varchar2) or
518: nvl(pe_aei_shd.g_old_rec.aei_attribute4, hr_api.g_varchar2) <>
519: nvl(p_rec.aei_attribute4, hr_api.g_varchar2) or
520: nvl(pe_aei_shd.g_old_rec.aei_attribute5, hr_api.g_varchar2) <>
521: nvl(p_rec.aei_attribute5, hr_api.g_varchar2) or
522: nvl(pe_aei_shd.g_old_rec.aei_attribute6, hr_api.g_varchar2) <>
523: nvl(p_rec.aei_attribute6, hr_api.g_varchar2) or
524: nvl(pe_aei_shd.g_old_rec.aei_attribute7, hr_api.g_varchar2) <>
517: nvl(p_rec.aei_attribute3, hr_api.g_varchar2) or
518: nvl(pe_aei_shd.g_old_rec.aei_attribute4, hr_api.g_varchar2) <>
519: nvl(p_rec.aei_attribute4, hr_api.g_varchar2) or
520: nvl(pe_aei_shd.g_old_rec.aei_attribute5, hr_api.g_varchar2) <>
521: nvl(p_rec.aei_attribute5, hr_api.g_varchar2) or
522: nvl(pe_aei_shd.g_old_rec.aei_attribute6, hr_api.g_varchar2) <>
523: nvl(p_rec.aei_attribute6, hr_api.g_varchar2) or
524: nvl(pe_aei_shd.g_old_rec.aei_attribute7, hr_api.g_varchar2) <>
525: nvl(p_rec.aei_attribute7, hr_api.g_varchar2) or
518: nvl(pe_aei_shd.g_old_rec.aei_attribute4, hr_api.g_varchar2) <>
519: nvl(p_rec.aei_attribute4, hr_api.g_varchar2) or
520: nvl(pe_aei_shd.g_old_rec.aei_attribute5, hr_api.g_varchar2) <>
521: nvl(p_rec.aei_attribute5, hr_api.g_varchar2) or
522: nvl(pe_aei_shd.g_old_rec.aei_attribute6, hr_api.g_varchar2) <>
523: nvl(p_rec.aei_attribute6, hr_api.g_varchar2) or
524: nvl(pe_aei_shd.g_old_rec.aei_attribute7, hr_api.g_varchar2) <>
525: nvl(p_rec.aei_attribute7, hr_api.g_varchar2) or
526: nvl(pe_aei_shd.g_old_rec.aei_attribute8, hr_api.g_varchar2) <>
519: nvl(p_rec.aei_attribute4, hr_api.g_varchar2) or
520: nvl(pe_aei_shd.g_old_rec.aei_attribute5, hr_api.g_varchar2) <>
521: nvl(p_rec.aei_attribute5, hr_api.g_varchar2) or
522: nvl(pe_aei_shd.g_old_rec.aei_attribute6, hr_api.g_varchar2) <>
523: nvl(p_rec.aei_attribute6, hr_api.g_varchar2) or
524: nvl(pe_aei_shd.g_old_rec.aei_attribute7, hr_api.g_varchar2) <>
525: nvl(p_rec.aei_attribute7, hr_api.g_varchar2) or
526: nvl(pe_aei_shd.g_old_rec.aei_attribute8, hr_api.g_varchar2) <>
527: nvl(p_rec.aei_attribute8, hr_api.g_varchar2) or
520: nvl(pe_aei_shd.g_old_rec.aei_attribute5, hr_api.g_varchar2) <>
521: nvl(p_rec.aei_attribute5, hr_api.g_varchar2) or
522: nvl(pe_aei_shd.g_old_rec.aei_attribute6, hr_api.g_varchar2) <>
523: nvl(p_rec.aei_attribute6, hr_api.g_varchar2) or
524: nvl(pe_aei_shd.g_old_rec.aei_attribute7, hr_api.g_varchar2) <>
525: nvl(p_rec.aei_attribute7, hr_api.g_varchar2) or
526: nvl(pe_aei_shd.g_old_rec.aei_attribute8, hr_api.g_varchar2) <>
527: nvl(p_rec.aei_attribute8, hr_api.g_varchar2) or
528: nvl(pe_aei_shd.g_old_rec.aei_attribute9, hr_api.g_varchar2) <>
521: nvl(p_rec.aei_attribute5, hr_api.g_varchar2) or
522: nvl(pe_aei_shd.g_old_rec.aei_attribute6, hr_api.g_varchar2) <>
523: nvl(p_rec.aei_attribute6, hr_api.g_varchar2) or
524: nvl(pe_aei_shd.g_old_rec.aei_attribute7, hr_api.g_varchar2) <>
525: nvl(p_rec.aei_attribute7, hr_api.g_varchar2) or
526: nvl(pe_aei_shd.g_old_rec.aei_attribute8, hr_api.g_varchar2) <>
527: nvl(p_rec.aei_attribute8, hr_api.g_varchar2) or
528: nvl(pe_aei_shd.g_old_rec.aei_attribute9, hr_api.g_varchar2) <>
529: nvl(p_rec.aei_attribute9, hr_api.g_varchar2) or
522: nvl(pe_aei_shd.g_old_rec.aei_attribute6, hr_api.g_varchar2) <>
523: nvl(p_rec.aei_attribute6, hr_api.g_varchar2) or
524: nvl(pe_aei_shd.g_old_rec.aei_attribute7, hr_api.g_varchar2) <>
525: nvl(p_rec.aei_attribute7, hr_api.g_varchar2) or
526: nvl(pe_aei_shd.g_old_rec.aei_attribute8, hr_api.g_varchar2) <>
527: nvl(p_rec.aei_attribute8, hr_api.g_varchar2) or
528: nvl(pe_aei_shd.g_old_rec.aei_attribute9, hr_api.g_varchar2) <>
529: nvl(p_rec.aei_attribute9, hr_api.g_varchar2) or
530: nvl(pe_aei_shd.g_old_rec.aei_attribute10, hr_api.g_varchar2) <>
523: nvl(p_rec.aei_attribute6, hr_api.g_varchar2) or
524: nvl(pe_aei_shd.g_old_rec.aei_attribute7, hr_api.g_varchar2) <>
525: nvl(p_rec.aei_attribute7, hr_api.g_varchar2) or
526: nvl(pe_aei_shd.g_old_rec.aei_attribute8, hr_api.g_varchar2) <>
527: nvl(p_rec.aei_attribute8, hr_api.g_varchar2) or
528: nvl(pe_aei_shd.g_old_rec.aei_attribute9, hr_api.g_varchar2) <>
529: nvl(p_rec.aei_attribute9, hr_api.g_varchar2) or
530: nvl(pe_aei_shd.g_old_rec.aei_attribute10, hr_api.g_varchar2) <>
531: nvl(p_rec.aei_attribute10, hr_api.g_varchar2) or
524: nvl(pe_aei_shd.g_old_rec.aei_attribute7, hr_api.g_varchar2) <>
525: nvl(p_rec.aei_attribute7, hr_api.g_varchar2) or
526: nvl(pe_aei_shd.g_old_rec.aei_attribute8, hr_api.g_varchar2) <>
527: nvl(p_rec.aei_attribute8, hr_api.g_varchar2) or
528: nvl(pe_aei_shd.g_old_rec.aei_attribute9, hr_api.g_varchar2) <>
529: nvl(p_rec.aei_attribute9, hr_api.g_varchar2) or
530: nvl(pe_aei_shd.g_old_rec.aei_attribute10, hr_api.g_varchar2) <>
531: nvl(p_rec.aei_attribute10, hr_api.g_varchar2) or
532: nvl(pe_aei_shd.g_old_rec.aei_attribute11, hr_api.g_varchar2) <>
525: nvl(p_rec.aei_attribute7, hr_api.g_varchar2) or
526: nvl(pe_aei_shd.g_old_rec.aei_attribute8, hr_api.g_varchar2) <>
527: nvl(p_rec.aei_attribute8, hr_api.g_varchar2) or
528: nvl(pe_aei_shd.g_old_rec.aei_attribute9, hr_api.g_varchar2) <>
529: nvl(p_rec.aei_attribute9, hr_api.g_varchar2) or
530: nvl(pe_aei_shd.g_old_rec.aei_attribute10, hr_api.g_varchar2) <>
531: nvl(p_rec.aei_attribute10, hr_api.g_varchar2) or
532: nvl(pe_aei_shd.g_old_rec.aei_attribute11, hr_api.g_varchar2) <>
533: nvl(p_rec.aei_attribute11, hr_api.g_varchar2) or
526: nvl(pe_aei_shd.g_old_rec.aei_attribute8, hr_api.g_varchar2) <>
527: nvl(p_rec.aei_attribute8, hr_api.g_varchar2) or
528: nvl(pe_aei_shd.g_old_rec.aei_attribute9, hr_api.g_varchar2) <>
529: nvl(p_rec.aei_attribute9, hr_api.g_varchar2) or
530: nvl(pe_aei_shd.g_old_rec.aei_attribute10, hr_api.g_varchar2) <>
531: nvl(p_rec.aei_attribute10, hr_api.g_varchar2) or
532: nvl(pe_aei_shd.g_old_rec.aei_attribute11, hr_api.g_varchar2) <>
533: nvl(p_rec.aei_attribute11, hr_api.g_varchar2) or
534: nvl(pe_aei_shd.g_old_rec.aei_attribute12, hr_api.g_varchar2) <>
527: nvl(p_rec.aei_attribute8, hr_api.g_varchar2) or
528: nvl(pe_aei_shd.g_old_rec.aei_attribute9, hr_api.g_varchar2) <>
529: nvl(p_rec.aei_attribute9, hr_api.g_varchar2) or
530: nvl(pe_aei_shd.g_old_rec.aei_attribute10, hr_api.g_varchar2) <>
531: nvl(p_rec.aei_attribute10, hr_api.g_varchar2) or
532: nvl(pe_aei_shd.g_old_rec.aei_attribute11, hr_api.g_varchar2) <>
533: nvl(p_rec.aei_attribute11, hr_api.g_varchar2) or
534: nvl(pe_aei_shd.g_old_rec.aei_attribute12, hr_api.g_varchar2) <>
535: nvl(p_rec.aei_attribute12, hr_api.g_varchar2) or
528: nvl(pe_aei_shd.g_old_rec.aei_attribute9, hr_api.g_varchar2) <>
529: nvl(p_rec.aei_attribute9, hr_api.g_varchar2) or
530: nvl(pe_aei_shd.g_old_rec.aei_attribute10, hr_api.g_varchar2) <>
531: nvl(p_rec.aei_attribute10, hr_api.g_varchar2) or
532: nvl(pe_aei_shd.g_old_rec.aei_attribute11, hr_api.g_varchar2) <>
533: nvl(p_rec.aei_attribute11, hr_api.g_varchar2) or
534: nvl(pe_aei_shd.g_old_rec.aei_attribute12, hr_api.g_varchar2) <>
535: nvl(p_rec.aei_attribute12, hr_api.g_varchar2) or
536: nvl(pe_aei_shd.g_old_rec.aei_attribute13, hr_api.g_varchar2) <>
529: nvl(p_rec.aei_attribute9, hr_api.g_varchar2) or
530: nvl(pe_aei_shd.g_old_rec.aei_attribute10, hr_api.g_varchar2) <>
531: nvl(p_rec.aei_attribute10, hr_api.g_varchar2) or
532: nvl(pe_aei_shd.g_old_rec.aei_attribute11, hr_api.g_varchar2) <>
533: nvl(p_rec.aei_attribute11, hr_api.g_varchar2) or
534: nvl(pe_aei_shd.g_old_rec.aei_attribute12, hr_api.g_varchar2) <>
535: nvl(p_rec.aei_attribute12, hr_api.g_varchar2) or
536: nvl(pe_aei_shd.g_old_rec.aei_attribute13, hr_api.g_varchar2) <>
537: nvl(p_rec.aei_attribute13, hr_api.g_varchar2) or
530: nvl(pe_aei_shd.g_old_rec.aei_attribute10, hr_api.g_varchar2) <>
531: nvl(p_rec.aei_attribute10, hr_api.g_varchar2) or
532: nvl(pe_aei_shd.g_old_rec.aei_attribute11, hr_api.g_varchar2) <>
533: nvl(p_rec.aei_attribute11, hr_api.g_varchar2) or
534: nvl(pe_aei_shd.g_old_rec.aei_attribute12, hr_api.g_varchar2) <>
535: nvl(p_rec.aei_attribute12, hr_api.g_varchar2) or
536: nvl(pe_aei_shd.g_old_rec.aei_attribute13, hr_api.g_varchar2) <>
537: nvl(p_rec.aei_attribute13, hr_api.g_varchar2) or
538: nvl(pe_aei_shd.g_old_rec.aei_attribute14, hr_api.g_varchar2) <>
531: nvl(p_rec.aei_attribute10, hr_api.g_varchar2) or
532: nvl(pe_aei_shd.g_old_rec.aei_attribute11, hr_api.g_varchar2) <>
533: nvl(p_rec.aei_attribute11, hr_api.g_varchar2) or
534: nvl(pe_aei_shd.g_old_rec.aei_attribute12, hr_api.g_varchar2) <>
535: nvl(p_rec.aei_attribute12, hr_api.g_varchar2) or
536: nvl(pe_aei_shd.g_old_rec.aei_attribute13, hr_api.g_varchar2) <>
537: nvl(p_rec.aei_attribute13, hr_api.g_varchar2) or
538: nvl(pe_aei_shd.g_old_rec.aei_attribute14, hr_api.g_varchar2) <>
539: nvl(p_rec.aei_attribute14, hr_api.g_varchar2) or
532: nvl(pe_aei_shd.g_old_rec.aei_attribute11, hr_api.g_varchar2) <>
533: nvl(p_rec.aei_attribute11, hr_api.g_varchar2) or
534: nvl(pe_aei_shd.g_old_rec.aei_attribute12, hr_api.g_varchar2) <>
535: nvl(p_rec.aei_attribute12, hr_api.g_varchar2) or
536: nvl(pe_aei_shd.g_old_rec.aei_attribute13, hr_api.g_varchar2) <>
537: nvl(p_rec.aei_attribute13, hr_api.g_varchar2) or
538: nvl(pe_aei_shd.g_old_rec.aei_attribute14, hr_api.g_varchar2) <>
539: nvl(p_rec.aei_attribute14, hr_api.g_varchar2) or
540: nvl(pe_aei_shd.g_old_rec.aei_attribute15, hr_api.g_varchar2) <>
533: nvl(p_rec.aei_attribute11, hr_api.g_varchar2) or
534: nvl(pe_aei_shd.g_old_rec.aei_attribute12, hr_api.g_varchar2) <>
535: nvl(p_rec.aei_attribute12, hr_api.g_varchar2) or
536: nvl(pe_aei_shd.g_old_rec.aei_attribute13, hr_api.g_varchar2) <>
537: nvl(p_rec.aei_attribute13, hr_api.g_varchar2) or
538: nvl(pe_aei_shd.g_old_rec.aei_attribute14, hr_api.g_varchar2) <>
539: nvl(p_rec.aei_attribute14, hr_api.g_varchar2) or
540: nvl(pe_aei_shd.g_old_rec.aei_attribute15, hr_api.g_varchar2) <>
541: nvl(p_rec.aei_attribute15, hr_api.g_varchar2) or
534: nvl(pe_aei_shd.g_old_rec.aei_attribute12, hr_api.g_varchar2) <>
535: nvl(p_rec.aei_attribute12, hr_api.g_varchar2) or
536: nvl(pe_aei_shd.g_old_rec.aei_attribute13, hr_api.g_varchar2) <>
537: nvl(p_rec.aei_attribute13, hr_api.g_varchar2) or
538: nvl(pe_aei_shd.g_old_rec.aei_attribute14, hr_api.g_varchar2) <>
539: nvl(p_rec.aei_attribute14, hr_api.g_varchar2) or
540: nvl(pe_aei_shd.g_old_rec.aei_attribute15, hr_api.g_varchar2) <>
541: nvl(p_rec.aei_attribute15, hr_api.g_varchar2) or
542: nvl(pe_aei_shd.g_old_rec.aei_attribute16, hr_api.g_varchar2) <>
535: nvl(p_rec.aei_attribute12, hr_api.g_varchar2) or
536: nvl(pe_aei_shd.g_old_rec.aei_attribute13, hr_api.g_varchar2) <>
537: nvl(p_rec.aei_attribute13, hr_api.g_varchar2) or
538: nvl(pe_aei_shd.g_old_rec.aei_attribute14, hr_api.g_varchar2) <>
539: nvl(p_rec.aei_attribute14, hr_api.g_varchar2) or
540: nvl(pe_aei_shd.g_old_rec.aei_attribute15, hr_api.g_varchar2) <>
541: nvl(p_rec.aei_attribute15, hr_api.g_varchar2) or
542: nvl(pe_aei_shd.g_old_rec.aei_attribute16, hr_api.g_varchar2) <>
543: nvl(p_rec.aei_attribute16, hr_api.g_varchar2) or
536: nvl(pe_aei_shd.g_old_rec.aei_attribute13, hr_api.g_varchar2) <>
537: nvl(p_rec.aei_attribute13, hr_api.g_varchar2) or
538: nvl(pe_aei_shd.g_old_rec.aei_attribute14, hr_api.g_varchar2) <>
539: nvl(p_rec.aei_attribute14, hr_api.g_varchar2) or
540: nvl(pe_aei_shd.g_old_rec.aei_attribute15, hr_api.g_varchar2) <>
541: nvl(p_rec.aei_attribute15, hr_api.g_varchar2) or
542: nvl(pe_aei_shd.g_old_rec.aei_attribute16, hr_api.g_varchar2) <>
543: nvl(p_rec.aei_attribute16, hr_api.g_varchar2) or
544: nvl(pe_aei_shd.g_old_rec.aei_attribute17, hr_api.g_varchar2) <>
537: nvl(p_rec.aei_attribute13, hr_api.g_varchar2) or
538: nvl(pe_aei_shd.g_old_rec.aei_attribute14, hr_api.g_varchar2) <>
539: nvl(p_rec.aei_attribute14, hr_api.g_varchar2) or
540: nvl(pe_aei_shd.g_old_rec.aei_attribute15, hr_api.g_varchar2) <>
541: nvl(p_rec.aei_attribute15, hr_api.g_varchar2) or
542: nvl(pe_aei_shd.g_old_rec.aei_attribute16, hr_api.g_varchar2) <>
543: nvl(p_rec.aei_attribute16, hr_api.g_varchar2) or
544: nvl(pe_aei_shd.g_old_rec.aei_attribute17, hr_api.g_varchar2) <>
545: nvl(p_rec.aei_attribute17, hr_api.g_varchar2) or
538: nvl(pe_aei_shd.g_old_rec.aei_attribute14, hr_api.g_varchar2) <>
539: nvl(p_rec.aei_attribute14, hr_api.g_varchar2) or
540: nvl(pe_aei_shd.g_old_rec.aei_attribute15, hr_api.g_varchar2) <>
541: nvl(p_rec.aei_attribute15, hr_api.g_varchar2) or
542: nvl(pe_aei_shd.g_old_rec.aei_attribute16, hr_api.g_varchar2) <>
543: nvl(p_rec.aei_attribute16, hr_api.g_varchar2) or
544: nvl(pe_aei_shd.g_old_rec.aei_attribute17, hr_api.g_varchar2) <>
545: nvl(p_rec.aei_attribute17, hr_api.g_varchar2) or
546: nvl(pe_aei_shd.g_old_rec.aei_attribute18, hr_api.g_varchar2) <>
539: nvl(p_rec.aei_attribute14, hr_api.g_varchar2) or
540: nvl(pe_aei_shd.g_old_rec.aei_attribute15, hr_api.g_varchar2) <>
541: nvl(p_rec.aei_attribute15, hr_api.g_varchar2) or
542: nvl(pe_aei_shd.g_old_rec.aei_attribute16, hr_api.g_varchar2) <>
543: nvl(p_rec.aei_attribute16, hr_api.g_varchar2) or
544: nvl(pe_aei_shd.g_old_rec.aei_attribute17, hr_api.g_varchar2) <>
545: nvl(p_rec.aei_attribute17, hr_api.g_varchar2) or
546: nvl(pe_aei_shd.g_old_rec.aei_attribute18, hr_api.g_varchar2) <>
547: nvl(p_rec.aei_attribute18, hr_api.g_varchar2) or
540: nvl(pe_aei_shd.g_old_rec.aei_attribute15, hr_api.g_varchar2) <>
541: nvl(p_rec.aei_attribute15, hr_api.g_varchar2) or
542: nvl(pe_aei_shd.g_old_rec.aei_attribute16, hr_api.g_varchar2) <>
543: nvl(p_rec.aei_attribute16, hr_api.g_varchar2) or
544: nvl(pe_aei_shd.g_old_rec.aei_attribute17, hr_api.g_varchar2) <>
545: nvl(p_rec.aei_attribute17, hr_api.g_varchar2) or
546: nvl(pe_aei_shd.g_old_rec.aei_attribute18, hr_api.g_varchar2) <>
547: nvl(p_rec.aei_attribute18, hr_api.g_varchar2) or
548: nvl(pe_aei_shd.g_old_rec.aei_attribute19, hr_api.g_varchar2) <>
541: nvl(p_rec.aei_attribute15, hr_api.g_varchar2) or
542: nvl(pe_aei_shd.g_old_rec.aei_attribute16, hr_api.g_varchar2) <>
543: nvl(p_rec.aei_attribute16, hr_api.g_varchar2) or
544: nvl(pe_aei_shd.g_old_rec.aei_attribute17, hr_api.g_varchar2) <>
545: nvl(p_rec.aei_attribute17, hr_api.g_varchar2) or
546: nvl(pe_aei_shd.g_old_rec.aei_attribute18, hr_api.g_varchar2) <>
547: nvl(p_rec.aei_attribute18, hr_api.g_varchar2) or
548: nvl(pe_aei_shd.g_old_rec.aei_attribute19, hr_api.g_varchar2) <>
549: nvl(p_rec.aei_attribute19, hr_api.g_varchar2) or
542: nvl(pe_aei_shd.g_old_rec.aei_attribute16, hr_api.g_varchar2) <>
543: nvl(p_rec.aei_attribute16, hr_api.g_varchar2) or
544: nvl(pe_aei_shd.g_old_rec.aei_attribute17, hr_api.g_varchar2) <>
545: nvl(p_rec.aei_attribute17, hr_api.g_varchar2) or
546: nvl(pe_aei_shd.g_old_rec.aei_attribute18, hr_api.g_varchar2) <>
547: nvl(p_rec.aei_attribute18, hr_api.g_varchar2) or
548: nvl(pe_aei_shd.g_old_rec.aei_attribute19, hr_api.g_varchar2) <>
549: nvl(p_rec.aei_attribute19, hr_api.g_varchar2) or
550: nvl(pe_aei_shd.g_old_rec.aei_attribute20, hr_api.g_varchar2) <>
543: nvl(p_rec.aei_attribute16, hr_api.g_varchar2) or
544: nvl(pe_aei_shd.g_old_rec.aei_attribute17, hr_api.g_varchar2) <>
545: nvl(p_rec.aei_attribute17, hr_api.g_varchar2) or
546: nvl(pe_aei_shd.g_old_rec.aei_attribute18, hr_api.g_varchar2) <>
547: nvl(p_rec.aei_attribute18, hr_api.g_varchar2) or
548: nvl(pe_aei_shd.g_old_rec.aei_attribute19, hr_api.g_varchar2) <>
549: nvl(p_rec.aei_attribute19, hr_api.g_varchar2) or
550: nvl(pe_aei_shd.g_old_rec.aei_attribute20, hr_api.g_varchar2) <>
551: nvl(p_rec.aei_attribute20, hr_api.g_varchar2)))
544: nvl(pe_aei_shd.g_old_rec.aei_attribute17, hr_api.g_varchar2) <>
545: nvl(p_rec.aei_attribute17, hr_api.g_varchar2) or
546: nvl(pe_aei_shd.g_old_rec.aei_attribute18, hr_api.g_varchar2) <>
547: nvl(p_rec.aei_attribute18, hr_api.g_varchar2) or
548: nvl(pe_aei_shd.g_old_rec.aei_attribute19, hr_api.g_varchar2) <>
549: nvl(p_rec.aei_attribute19, hr_api.g_varchar2) or
550: nvl(pe_aei_shd.g_old_rec.aei_attribute20, hr_api.g_varchar2) <>
551: nvl(p_rec.aei_attribute20, hr_api.g_varchar2)))
552: or
545: nvl(p_rec.aei_attribute17, hr_api.g_varchar2) or
546: nvl(pe_aei_shd.g_old_rec.aei_attribute18, hr_api.g_varchar2) <>
547: nvl(p_rec.aei_attribute18, hr_api.g_varchar2) or
548: nvl(pe_aei_shd.g_old_rec.aei_attribute19, hr_api.g_varchar2) <>
549: nvl(p_rec.aei_attribute19, hr_api.g_varchar2) or
550: nvl(pe_aei_shd.g_old_rec.aei_attribute20, hr_api.g_varchar2) <>
551: nvl(p_rec.aei_attribute20, hr_api.g_varchar2)))
552: or
553: (p_rec.assignment_extra_info_id is null) then
546: nvl(pe_aei_shd.g_old_rec.aei_attribute18, hr_api.g_varchar2) <>
547: nvl(p_rec.aei_attribute18, hr_api.g_varchar2) or
548: nvl(pe_aei_shd.g_old_rec.aei_attribute19, hr_api.g_varchar2) <>
549: nvl(p_rec.aei_attribute19, hr_api.g_varchar2) or
550: nvl(pe_aei_shd.g_old_rec.aei_attribute20, hr_api.g_varchar2) <>
551: nvl(p_rec.aei_attribute20, hr_api.g_varchar2)))
552: or
553: (p_rec.assignment_extra_info_id is null) then
554: --
547: nvl(p_rec.aei_attribute18, hr_api.g_varchar2) or
548: nvl(pe_aei_shd.g_old_rec.aei_attribute19, hr_api.g_varchar2) <>
549: nvl(p_rec.aei_attribute19, hr_api.g_varchar2) or
550: nvl(pe_aei_shd.g_old_rec.aei_attribute20, hr_api.g_varchar2) <>
551: nvl(p_rec.aei_attribute20, hr_api.g_varchar2)))
552: or
553: (p_rec.assignment_extra_info_id is null) then
554: --
555: -- Only execute the validation if absolutely necessary:
651: --
652: if (p_rec.assignment_extra_info_id is null)
653: or ((p_rec.assignment_extra_info_id is not null)
654: and
655: nvl(pe_aei_shd.g_old_rec.aei_attribute_category, hr_api.g_varchar2) <>
656: nvl(p_rec.aei_information_category, hr_api.g_varchar2) or
657: nvl(pe_aei_shd.g_old_rec.aei_information1, hr_api.g_varchar2) <>
658: nvl(p_rec.aei_information1, hr_api.g_varchar2) or
659: nvl(pe_aei_shd.g_old_rec.aei_information2, hr_api.g_varchar2) <>
652: if (p_rec.assignment_extra_info_id is null)
653: or ((p_rec.assignment_extra_info_id is not null)
654: and
655: nvl(pe_aei_shd.g_old_rec.aei_attribute_category, hr_api.g_varchar2) <>
656: nvl(p_rec.aei_information_category, hr_api.g_varchar2) or
657: nvl(pe_aei_shd.g_old_rec.aei_information1, hr_api.g_varchar2) <>
658: nvl(p_rec.aei_information1, hr_api.g_varchar2) or
659: nvl(pe_aei_shd.g_old_rec.aei_information2, hr_api.g_varchar2) <>
660: nvl(p_rec.aei_information2, hr_api.g_varchar2) or
653: or ((p_rec.assignment_extra_info_id is not null)
654: and
655: nvl(pe_aei_shd.g_old_rec.aei_attribute_category, hr_api.g_varchar2) <>
656: nvl(p_rec.aei_information_category, hr_api.g_varchar2) or
657: nvl(pe_aei_shd.g_old_rec.aei_information1, hr_api.g_varchar2) <>
658: nvl(p_rec.aei_information1, hr_api.g_varchar2) or
659: nvl(pe_aei_shd.g_old_rec.aei_information2, hr_api.g_varchar2) <>
660: nvl(p_rec.aei_information2, hr_api.g_varchar2) or
661: nvl(pe_aei_shd.g_old_rec.aei_information3, hr_api.g_varchar2) <>
654: and
655: nvl(pe_aei_shd.g_old_rec.aei_attribute_category, hr_api.g_varchar2) <>
656: nvl(p_rec.aei_information_category, hr_api.g_varchar2) or
657: nvl(pe_aei_shd.g_old_rec.aei_information1, hr_api.g_varchar2) <>
658: nvl(p_rec.aei_information1, hr_api.g_varchar2) or
659: nvl(pe_aei_shd.g_old_rec.aei_information2, hr_api.g_varchar2) <>
660: nvl(p_rec.aei_information2, hr_api.g_varchar2) or
661: nvl(pe_aei_shd.g_old_rec.aei_information3, hr_api.g_varchar2) <>
662: nvl(p_rec.aei_information3, hr_api.g_varchar2) or
655: nvl(pe_aei_shd.g_old_rec.aei_attribute_category, hr_api.g_varchar2) <>
656: nvl(p_rec.aei_information_category, hr_api.g_varchar2) or
657: nvl(pe_aei_shd.g_old_rec.aei_information1, hr_api.g_varchar2) <>
658: nvl(p_rec.aei_information1, hr_api.g_varchar2) or
659: nvl(pe_aei_shd.g_old_rec.aei_information2, hr_api.g_varchar2) <>
660: nvl(p_rec.aei_information2, hr_api.g_varchar2) or
661: nvl(pe_aei_shd.g_old_rec.aei_information3, hr_api.g_varchar2) <>
662: nvl(p_rec.aei_information3, hr_api.g_varchar2) or
663: nvl(pe_aei_shd.g_old_rec.aei_information4, hr_api.g_varchar2) <>
656: nvl(p_rec.aei_information_category, hr_api.g_varchar2) or
657: nvl(pe_aei_shd.g_old_rec.aei_information1, hr_api.g_varchar2) <>
658: nvl(p_rec.aei_information1, hr_api.g_varchar2) or
659: nvl(pe_aei_shd.g_old_rec.aei_information2, hr_api.g_varchar2) <>
660: nvl(p_rec.aei_information2, hr_api.g_varchar2) or
661: nvl(pe_aei_shd.g_old_rec.aei_information3, hr_api.g_varchar2) <>
662: nvl(p_rec.aei_information3, hr_api.g_varchar2) or
663: nvl(pe_aei_shd.g_old_rec.aei_information4, hr_api.g_varchar2) <>
664: nvl(p_rec.aei_information4, hr_api.g_varchar2) or
657: nvl(pe_aei_shd.g_old_rec.aei_information1, hr_api.g_varchar2) <>
658: nvl(p_rec.aei_information1, hr_api.g_varchar2) or
659: nvl(pe_aei_shd.g_old_rec.aei_information2, hr_api.g_varchar2) <>
660: nvl(p_rec.aei_information2, hr_api.g_varchar2) or
661: nvl(pe_aei_shd.g_old_rec.aei_information3, hr_api.g_varchar2) <>
662: nvl(p_rec.aei_information3, hr_api.g_varchar2) or
663: nvl(pe_aei_shd.g_old_rec.aei_information4, hr_api.g_varchar2) <>
664: nvl(p_rec.aei_information4, hr_api.g_varchar2) or
665: nvl(pe_aei_shd.g_old_rec.aei_information5, hr_api.g_varchar2) <>
658: nvl(p_rec.aei_information1, hr_api.g_varchar2) or
659: nvl(pe_aei_shd.g_old_rec.aei_information2, hr_api.g_varchar2) <>
660: nvl(p_rec.aei_information2, hr_api.g_varchar2) or
661: nvl(pe_aei_shd.g_old_rec.aei_information3, hr_api.g_varchar2) <>
662: nvl(p_rec.aei_information3, hr_api.g_varchar2) or
663: nvl(pe_aei_shd.g_old_rec.aei_information4, hr_api.g_varchar2) <>
664: nvl(p_rec.aei_information4, hr_api.g_varchar2) or
665: nvl(pe_aei_shd.g_old_rec.aei_information5, hr_api.g_varchar2) <>
666: nvl(p_rec.aei_information5, hr_api.g_varchar2) or
659: nvl(pe_aei_shd.g_old_rec.aei_information2, hr_api.g_varchar2) <>
660: nvl(p_rec.aei_information2, hr_api.g_varchar2) or
661: nvl(pe_aei_shd.g_old_rec.aei_information3, hr_api.g_varchar2) <>
662: nvl(p_rec.aei_information3, hr_api.g_varchar2) or
663: nvl(pe_aei_shd.g_old_rec.aei_information4, hr_api.g_varchar2) <>
664: nvl(p_rec.aei_information4, hr_api.g_varchar2) or
665: nvl(pe_aei_shd.g_old_rec.aei_information5, hr_api.g_varchar2) <>
666: nvl(p_rec.aei_information5, hr_api.g_varchar2) or
667: nvl(pe_aei_shd.g_old_rec.aei_information6, hr_api.g_varchar2) <>
660: nvl(p_rec.aei_information2, hr_api.g_varchar2) or
661: nvl(pe_aei_shd.g_old_rec.aei_information3, hr_api.g_varchar2) <>
662: nvl(p_rec.aei_information3, hr_api.g_varchar2) or
663: nvl(pe_aei_shd.g_old_rec.aei_information4, hr_api.g_varchar2) <>
664: nvl(p_rec.aei_information4, hr_api.g_varchar2) or
665: nvl(pe_aei_shd.g_old_rec.aei_information5, hr_api.g_varchar2) <>
666: nvl(p_rec.aei_information5, hr_api.g_varchar2) or
667: nvl(pe_aei_shd.g_old_rec.aei_information6, hr_api.g_varchar2) <>
668: nvl(p_rec.aei_information6, hr_api.g_varchar2) or
661: nvl(pe_aei_shd.g_old_rec.aei_information3, hr_api.g_varchar2) <>
662: nvl(p_rec.aei_information3, hr_api.g_varchar2) or
663: nvl(pe_aei_shd.g_old_rec.aei_information4, hr_api.g_varchar2) <>
664: nvl(p_rec.aei_information4, hr_api.g_varchar2) or
665: nvl(pe_aei_shd.g_old_rec.aei_information5, hr_api.g_varchar2) <>
666: nvl(p_rec.aei_information5, hr_api.g_varchar2) or
667: nvl(pe_aei_shd.g_old_rec.aei_information6, hr_api.g_varchar2) <>
668: nvl(p_rec.aei_information6, hr_api.g_varchar2) or
669: nvl(pe_aei_shd.g_old_rec.aei_information7, hr_api.g_varchar2) <>
662: nvl(p_rec.aei_information3, hr_api.g_varchar2) or
663: nvl(pe_aei_shd.g_old_rec.aei_information4, hr_api.g_varchar2) <>
664: nvl(p_rec.aei_information4, hr_api.g_varchar2) or
665: nvl(pe_aei_shd.g_old_rec.aei_information5, hr_api.g_varchar2) <>
666: nvl(p_rec.aei_information5, hr_api.g_varchar2) or
667: nvl(pe_aei_shd.g_old_rec.aei_information6, hr_api.g_varchar2) <>
668: nvl(p_rec.aei_information6, hr_api.g_varchar2) or
669: nvl(pe_aei_shd.g_old_rec.aei_information7, hr_api.g_varchar2) <>
670: nvl(p_rec.aei_information7, hr_api.g_varchar2) or
663: nvl(pe_aei_shd.g_old_rec.aei_information4, hr_api.g_varchar2) <>
664: nvl(p_rec.aei_information4, hr_api.g_varchar2) or
665: nvl(pe_aei_shd.g_old_rec.aei_information5, hr_api.g_varchar2) <>
666: nvl(p_rec.aei_information5, hr_api.g_varchar2) or
667: nvl(pe_aei_shd.g_old_rec.aei_information6, hr_api.g_varchar2) <>
668: nvl(p_rec.aei_information6, hr_api.g_varchar2) or
669: nvl(pe_aei_shd.g_old_rec.aei_information7, hr_api.g_varchar2) <>
670: nvl(p_rec.aei_information7, hr_api.g_varchar2) or
671: nvl(pe_aei_shd.g_old_rec.aei_information8, hr_api.g_varchar2) <>
664: nvl(p_rec.aei_information4, hr_api.g_varchar2) or
665: nvl(pe_aei_shd.g_old_rec.aei_information5, hr_api.g_varchar2) <>
666: nvl(p_rec.aei_information5, hr_api.g_varchar2) or
667: nvl(pe_aei_shd.g_old_rec.aei_information6, hr_api.g_varchar2) <>
668: nvl(p_rec.aei_information6, hr_api.g_varchar2) or
669: nvl(pe_aei_shd.g_old_rec.aei_information7, hr_api.g_varchar2) <>
670: nvl(p_rec.aei_information7, hr_api.g_varchar2) or
671: nvl(pe_aei_shd.g_old_rec.aei_information8, hr_api.g_varchar2) <>
672: nvl(p_rec.aei_information8, hr_api.g_varchar2) or
665: nvl(pe_aei_shd.g_old_rec.aei_information5, hr_api.g_varchar2) <>
666: nvl(p_rec.aei_information5, hr_api.g_varchar2) or
667: nvl(pe_aei_shd.g_old_rec.aei_information6, hr_api.g_varchar2) <>
668: nvl(p_rec.aei_information6, hr_api.g_varchar2) or
669: nvl(pe_aei_shd.g_old_rec.aei_information7, hr_api.g_varchar2) <>
670: nvl(p_rec.aei_information7, hr_api.g_varchar2) or
671: nvl(pe_aei_shd.g_old_rec.aei_information8, hr_api.g_varchar2) <>
672: nvl(p_rec.aei_information8, hr_api.g_varchar2) or
673: nvl(pe_aei_shd.g_old_rec.aei_information9, hr_api.g_varchar2) <>
666: nvl(p_rec.aei_information5, hr_api.g_varchar2) or
667: nvl(pe_aei_shd.g_old_rec.aei_information6, hr_api.g_varchar2) <>
668: nvl(p_rec.aei_information6, hr_api.g_varchar2) or
669: nvl(pe_aei_shd.g_old_rec.aei_information7, hr_api.g_varchar2) <>
670: nvl(p_rec.aei_information7, hr_api.g_varchar2) or
671: nvl(pe_aei_shd.g_old_rec.aei_information8, hr_api.g_varchar2) <>
672: nvl(p_rec.aei_information8, hr_api.g_varchar2) or
673: nvl(pe_aei_shd.g_old_rec.aei_information9, hr_api.g_varchar2) <>
674: nvl(p_rec.aei_information9, hr_api.g_varchar2) or
667: nvl(pe_aei_shd.g_old_rec.aei_information6, hr_api.g_varchar2) <>
668: nvl(p_rec.aei_information6, hr_api.g_varchar2) or
669: nvl(pe_aei_shd.g_old_rec.aei_information7, hr_api.g_varchar2) <>
670: nvl(p_rec.aei_information7, hr_api.g_varchar2) or
671: nvl(pe_aei_shd.g_old_rec.aei_information8, hr_api.g_varchar2) <>
672: nvl(p_rec.aei_information8, hr_api.g_varchar2) or
673: nvl(pe_aei_shd.g_old_rec.aei_information9, hr_api.g_varchar2) <>
674: nvl(p_rec.aei_information9, hr_api.g_varchar2) or
675: nvl(pe_aei_shd.g_old_rec.aei_information10, hr_api.g_varchar2) <>
668: nvl(p_rec.aei_information6, hr_api.g_varchar2) or
669: nvl(pe_aei_shd.g_old_rec.aei_information7, hr_api.g_varchar2) <>
670: nvl(p_rec.aei_information7, hr_api.g_varchar2) or
671: nvl(pe_aei_shd.g_old_rec.aei_information8, hr_api.g_varchar2) <>
672: nvl(p_rec.aei_information8, hr_api.g_varchar2) or
673: nvl(pe_aei_shd.g_old_rec.aei_information9, hr_api.g_varchar2) <>
674: nvl(p_rec.aei_information9, hr_api.g_varchar2) or
675: nvl(pe_aei_shd.g_old_rec.aei_information10, hr_api.g_varchar2) <>
676: nvl(p_rec.aei_information10, hr_api.g_varchar2) or
669: nvl(pe_aei_shd.g_old_rec.aei_information7, hr_api.g_varchar2) <>
670: nvl(p_rec.aei_information7, hr_api.g_varchar2) or
671: nvl(pe_aei_shd.g_old_rec.aei_information8, hr_api.g_varchar2) <>
672: nvl(p_rec.aei_information8, hr_api.g_varchar2) or
673: nvl(pe_aei_shd.g_old_rec.aei_information9, hr_api.g_varchar2) <>
674: nvl(p_rec.aei_information9, hr_api.g_varchar2) or
675: nvl(pe_aei_shd.g_old_rec.aei_information10, hr_api.g_varchar2) <>
676: nvl(p_rec.aei_information10, hr_api.g_varchar2) or
677: nvl(pe_aei_shd.g_old_rec.aei_information11, hr_api.g_varchar2) <>
670: nvl(p_rec.aei_information7, hr_api.g_varchar2) or
671: nvl(pe_aei_shd.g_old_rec.aei_information8, hr_api.g_varchar2) <>
672: nvl(p_rec.aei_information8, hr_api.g_varchar2) or
673: nvl(pe_aei_shd.g_old_rec.aei_information9, hr_api.g_varchar2) <>
674: nvl(p_rec.aei_information9, hr_api.g_varchar2) or
675: nvl(pe_aei_shd.g_old_rec.aei_information10, hr_api.g_varchar2) <>
676: nvl(p_rec.aei_information10, hr_api.g_varchar2) or
677: nvl(pe_aei_shd.g_old_rec.aei_information11, hr_api.g_varchar2) <>
678: nvl(p_rec.aei_information11, hr_api.g_varchar2) or
671: nvl(pe_aei_shd.g_old_rec.aei_information8, hr_api.g_varchar2) <>
672: nvl(p_rec.aei_information8, hr_api.g_varchar2) or
673: nvl(pe_aei_shd.g_old_rec.aei_information9, hr_api.g_varchar2) <>
674: nvl(p_rec.aei_information9, hr_api.g_varchar2) or
675: nvl(pe_aei_shd.g_old_rec.aei_information10, hr_api.g_varchar2) <>
676: nvl(p_rec.aei_information10, hr_api.g_varchar2) or
677: nvl(pe_aei_shd.g_old_rec.aei_information11, hr_api.g_varchar2) <>
678: nvl(p_rec.aei_information11, hr_api.g_varchar2) or
679: nvl(pe_aei_shd.g_old_rec.aei_information12, hr_api.g_varchar2) <>
672: nvl(p_rec.aei_information8, hr_api.g_varchar2) or
673: nvl(pe_aei_shd.g_old_rec.aei_information9, hr_api.g_varchar2) <>
674: nvl(p_rec.aei_information9, hr_api.g_varchar2) or
675: nvl(pe_aei_shd.g_old_rec.aei_information10, hr_api.g_varchar2) <>
676: nvl(p_rec.aei_information10, hr_api.g_varchar2) or
677: nvl(pe_aei_shd.g_old_rec.aei_information11, hr_api.g_varchar2) <>
678: nvl(p_rec.aei_information11, hr_api.g_varchar2) or
679: nvl(pe_aei_shd.g_old_rec.aei_information12, hr_api.g_varchar2) <>
680: nvl(p_rec.aei_information12, hr_api.g_varchar2) or
673: nvl(pe_aei_shd.g_old_rec.aei_information9, hr_api.g_varchar2) <>
674: nvl(p_rec.aei_information9, hr_api.g_varchar2) or
675: nvl(pe_aei_shd.g_old_rec.aei_information10, hr_api.g_varchar2) <>
676: nvl(p_rec.aei_information10, hr_api.g_varchar2) or
677: nvl(pe_aei_shd.g_old_rec.aei_information11, hr_api.g_varchar2) <>
678: nvl(p_rec.aei_information11, hr_api.g_varchar2) or
679: nvl(pe_aei_shd.g_old_rec.aei_information12, hr_api.g_varchar2) <>
680: nvl(p_rec.aei_information12, hr_api.g_varchar2) or
681: nvl(pe_aei_shd.g_old_rec.aei_information13, hr_api.g_varchar2) <>
674: nvl(p_rec.aei_information9, hr_api.g_varchar2) or
675: nvl(pe_aei_shd.g_old_rec.aei_information10, hr_api.g_varchar2) <>
676: nvl(p_rec.aei_information10, hr_api.g_varchar2) or
677: nvl(pe_aei_shd.g_old_rec.aei_information11, hr_api.g_varchar2) <>
678: nvl(p_rec.aei_information11, hr_api.g_varchar2) or
679: nvl(pe_aei_shd.g_old_rec.aei_information12, hr_api.g_varchar2) <>
680: nvl(p_rec.aei_information12, hr_api.g_varchar2) or
681: nvl(pe_aei_shd.g_old_rec.aei_information13, hr_api.g_varchar2) <>
682: nvl(p_rec.aei_information13, hr_api.g_varchar2) or
675: nvl(pe_aei_shd.g_old_rec.aei_information10, hr_api.g_varchar2) <>
676: nvl(p_rec.aei_information10, hr_api.g_varchar2) or
677: nvl(pe_aei_shd.g_old_rec.aei_information11, hr_api.g_varchar2) <>
678: nvl(p_rec.aei_information11, hr_api.g_varchar2) or
679: nvl(pe_aei_shd.g_old_rec.aei_information12, hr_api.g_varchar2) <>
680: nvl(p_rec.aei_information12, hr_api.g_varchar2) or
681: nvl(pe_aei_shd.g_old_rec.aei_information13, hr_api.g_varchar2) <>
682: nvl(p_rec.aei_information13, hr_api.g_varchar2) or
683: nvl(pe_aei_shd.g_old_rec.aei_information14, hr_api.g_varchar2) <>
676: nvl(p_rec.aei_information10, hr_api.g_varchar2) or
677: nvl(pe_aei_shd.g_old_rec.aei_information11, hr_api.g_varchar2) <>
678: nvl(p_rec.aei_information11, hr_api.g_varchar2) or
679: nvl(pe_aei_shd.g_old_rec.aei_information12, hr_api.g_varchar2) <>
680: nvl(p_rec.aei_information12, hr_api.g_varchar2) or
681: nvl(pe_aei_shd.g_old_rec.aei_information13, hr_api.g_varchar2) <>
682: nvl(p_rec.aei_information13, hr_api.g_varchar2) or
683: nvl(pe_aei_shd.g_old_rec.aei_information14, hr_api.g_varchar2) <>
684: nvl(p_rec.aei_information14, hr_api.g_varchar2) or
677: nvl(pe_aei_shd.g_old_rec.aei_information11, hr_api.g_varchar2) <>
678: nvl(p_rec.aei_information11, hr_api.g_varchar2) or
679: nvl(pe_aei_shd.g_old_rec.aei_information12, hr_api.g_varchar2) <>
680: nvl(p_rec.aei_information12, hr_api.g_varchar2) or
681: nvl(pe_aei_shd.g_old_rec.aei_information13, hr_api.g_varchar2) <>
682: nvl(p_rec.aei_information13, hr_api.g_varchar2) or
683: nvl(pe_aei_shd.g_old_rec.aei_information14, hr_api.g_varchar2) <>
684: nvl(p_rec.aei_information14, hr_api.g_varchar2) or
685: nvl(pe_aei_shd.g_old_rec.aei_information15, hr_api.g_varchar2) <>
678: nvl(p_rec.aei_information11, hr_api.g_varchar2) or
679: nvl(pe_aei_shd.g_old_rec.aei_information12, hr_api.g_varchar2) <>
680: nvl(p_rec.aei_information12, hr_api.g_varchar2) or
681: nvl(pe_aei_shd.g_old_rec.aei_information13, hr_api.g_varchar2) <>
682: nvl(p_rec.aei_information13, hr_api.g_varchar2) or
683: nvl(pe_aei_shd.g_old_rec.aei_information14, hr_api.g_varchar2) <>
684: nvl(p_rec.aei_information14, hr_api.g_varchar2) or
685: nvl(pe_aei_shd.g_old_rec.aei_information15, hr_api.g_varchar2) <>
686: nvl(p_rec.aei_information15, hr_api.g_varchar2) or
679: nvl(pe_aei_shd.g_old_rec.aei_information12, hr_api.g_varchar2) <>
680: nvl(p_rec.aei_information12, hr_api.g_varchar2) or
681: nvl(pe_aei_shd.g_old_rec.aei_information13, hr_api.g_varchar2) <>
682: nvl(p_rec.aei_information13, hr_api.g_varchar2) or
683: nvl(pe_aei_shd.g_old_rec.aei_information14, hr_api.g_varchar2) <>
684: nvl(p_rec.aei_information14, hr_api.g_varchar2) or
685: nvl(pe_aei_shd.g_old_rec.aei_information15, hr_api.g_varchar2) <>
686: nvl(p_rec.aei_information15, hr_api.g_varchar2) or
687: nvl(pe_aei_shd.g_old_rec.aei_information16, hr_api.g_varchar2) <>
680: nvl(p_rec.aei_information12, hr_api.g_varchar2) or
681: nvl(pe_aei_shd.g_old_rec.aei_information13, hr_api.g_varchar2) <>
682: nvl(p_rec.aei_information13, hr_api.g_varchar2) or
683: nvl(pe_aei_shd.g_old_rec.aei_information14, hr_api.g_varchar2) <>
684: nvl(p_rec.aei_information14, hr_api.g_varchar2) or
685: nvl(pe_aei_shd.g_old_rec.aei_information15, hr_api.g_varchar2) <>
686: nvl(p_rec.aei_information15, hr_api.g_varchar2) or
687: nvl(pe_aei_shd.g_old_rec.aei_information16, hr_api.g_varchar2) <>
688: nvl(p_rec.aei_information16, hr_api.g_varchar2) or
681: nvl(pe_aei_shd.g_old_rec.aei_information13, hr_api.g_varchar2) <>
682: nvl(p_rec.aei_information13, hr_api.g_varchar2) or
683: nvl(pe_aei_shd.g_old_rec.aei_information14, hr_api.g_varchar2) <>
684: nvl(p_rec.aei_information14, hr_api.g_varchar2) or
685: nvl(pe_aei_shd.g_old_rec.aei_information15, hr_api.g_varchar2) <>
686: nvl(p_rec.aei_information15, hr_api.g_varchar2) or
687: nvl(pe_aei_shd.g_old_rec.aei_information16, hr_api.g_varchar2) <>
688: nvl(p_rec.aei_information16, hr_api.g_varchar2) or
689: nvl(pe_aei_shd.g_old_rec.aei_information17, hr_api.g_varchar2) <>
682: nvl(p_rec.aei_information13, hr_api.g_varchar2) or
683: nvl(pe_aei_shd.g_old_rec.aei_information14, hr_api.g_varchar2) <>
684: nvl(p_rec.aei_information14, hr_api.g_varchar2) or
685: nvl(pe_aei_shd.g_old_rec.aei_information15, hr_api.g_varchar2) <>
686: nvl(p_rec.aei_information15, hr_api.g_varchar2) or
687: nvl(pe_aei_shd.g_old_rec.aei_information16, hr_api.g_varchar2) <>
688: nvl(p_rec.aei_information16, hr_api.g_varchar2) or
689: nvl(pe_aei_shd.g_old_rec.aei_information17, hr_api.g_varchar2) <>
690: nvl(p_rec.aei_information17, hr_api.g_varchar2) or
683: nvl(pe_aei_shd.g_old_rec.aei_information14, hr_api.g_varchar2) <>
684: nvl(p_rec.aei_information14, hr_api.g_varchar2) or
685: nvl(pe_aei_shd.g_old_rec.aei_information15, hr_api.g_varchar2) <>
686: nvl(p_rec.aei_information15, hr_api.g_varchar2) or
687: nvl(pe_aei_shd.g_old_rec.aei_information16, hr_api.g_varchar2) <>
688: nvl(p_rec.aei_information16, hr_api.g_varchar2) or
689: nvl(pe_aei_shd.g_old_rec.aei_information17, hr_api.g_varchar2) <>
690: nvl(p_rec.aei_information17, hr_api.g_varchar2) or
691: nvl(pe_aei_shd.g_old_rec.aei_information18, hr_api.g_varchar2) <>
684: nvl(p_rec.aei_information14, hr_api.g_varchar2) or
685: nvl(pe_aei_shd.g_old_rec.aei_information15, hr_api.g_varchar2) <>
686: nvl(p_rec.aei_information15, hr_api.g_varchar2) or
687: nvl(pe_aei_shd.g_old_rec.aei_information16, hr_api.g_varchar2) <>
688: nvl(p_rec.aei_information16, hr_api.g_varchar2) or
689: nvl(pe_aei_shd.g_old_rec.aei_information17, hr_api.g_varchar2) <>
690: nvl(p_rec.aei_information17, hr_api.g_varchar2) or
691: nvl(pe_aei_shd.g_old_rec.aei_information18, hr_api.g_varchar2) <>
692: nvl(p_rec.aei_information18, hr_api.g_varchar2) or
685: nvl(pe_aei_shd.g_old_rec.aei_information15, hr_api.g_varchar2) <>
686: nvl(p_rec.aei_information15, hr_api.g_varchar2) or
687: nvl(pe_aei_shd.g_old_rec.aei_information16, hr_api.g_varchar2) <>
688: nvl(p_rec.aei_information16, hr_api.g_varchar2) or
689: nvl(pe_aei_shd.g_old_rec.aei_information17, hr_api.g_varchar2) <>
690: nvl(p_rec.aei_information17, hr_api.g_varchar2) or
691: nvl(pe_aei_shd.g_old_rec.aei_information18, hr_api.g_varchar2) <>
692: nvl(p_rec.aei_information18, hr_api.g_varchar2) or
693: nvl(pe_aei_shd.g_old_rec.aei_information19, hr_api.g_varchar2) <>
686: nvl(p_rec.aei_information15, hr_api.g_varchar2) or
687: nvl(pe_aei_shd.g_old_rec.aei_information16, hr_api.g_varchar2) <>
688: nvl(p_rec.aei_information16, hr_api.g_varchar2) or
689: nvl(pe_aei_shd.g_old_rec.aei_information17, hr_api.g_varchar2) <>
690: nvl(p_rec.aei_information17, hr_api.g_varchar2) or
691: nvl(pe_aei_shd.g_old_rec.aei_information18, hr_api.g_varchar2) <>
692: nvl(p_rec.aei_information18, hr_api.g_varchar2) or
693: nvl(pe_aei_shd.g_old_rec.aei_information19, hr_api.g_varchar2) <>
694: nvl(p_rec.aei_information19, hr_api.g_varchar2) or
687: nvl(pe_aei_shd.g_old_rec.aei_information16, hr_api.g_varchar2) <>
688: nvl(p_rec.aei_information16, hr_api.g_varchar2) or
689: nvl(pe_aei_shd.g_old_rec.aei_information17, hr_api.g_varchar2) <>
690: nvl(p_rec.aei_information17, hr_api.g_varchar2) or
691: nvl(pe_aei_shd.g_old_rec.aei_information18, hr_api.g_varchar2) <>
692: nvl(p_rec.aei_information18, hr_api.g_varchar2) or
693: nvl(pe_aei_shd.g_old_rec.aei_information19, hr_api.g_varchar2) <>
694: nvl(p_rec.aei_information19, hr_api.g_varchar2) or
695: nvl(pe_aei_shd.g_old_rec.aei_information20, hr_api.g_varchar2) <>
688: nvl(p_rec.aei_information16, hr_api.g_varchar2) or
689: nvl(pe_aei_shd.g_old_rec.aei_information17, hr_api.g_varchar2) <>
690: nvl(p_rec.aei_information17, hr_api.g_varchar2) or
691: nvl(pe_aei_shd.g_old_rec.aei_information18, hr_api.g_varchar2) <>
692: nvl(p_rec.aei_information18, hr_api.g_varchar2) or
693: nvl(pe_aei_shd.g_old_rec.aei_information19, hr_api.g_varchar2) <>
694: nvl(p_rec.aei_information19, hr_api.g_varchar2) or
695: nvl(pe_aei_shd.g_old_rec.aei_information20, hr_api.g_varchar2) <>
696: nvl(p_rec.aei_information20, hr_api.g_varchar2) or
689: nvl(pe_aei_shd.g_old_rec.aei_information17, hr_api.g_varchar2) <>
690: nvl(p_rec.aei_information17, hr_api.g_varchar2) or
691: nvl(pe_aei_shd.g_old_rec.aei_information18, hr_api.g_varchar2) <>
692: nvl(p_rec.aei_information18, hr_api.g_varchar2) or
693: nvl(pe_aei_shd.g_old_rec.aei_information19, hr_api.g_varchar2) <>
694: nvl(p_rec.aei_information19, hr_api.g_varchar2) or
695: nvl(pe_aei_shd.g_old_rec.aei_information20, hr_api.g_varchar2) <>
696: nvl(p_rec.aei_information20, hr_api.g_varchar2) or
697: nvl(pe_aei_shd.g_old_rec.aei_information21, hr_api.g_varchar2) <>
690: nvl(p_rec.aei_information17, hr_api.g_varchar2) or
691: nvl(pe_aei_shd.g_old_rec.aei_information18, hr_api.g_varchar2) <>
692: nvl(p_rec.aei_information18, hr_api.g_varchar2) or
693: nvl(pe_aei_shd.g_old_rec.aei_information19, hr_api.g_varchar2) <>
694: nvl(p_rec.aei_information19, hr_api.g_varchar2) or
695: nvl(pe_aei_shd.g_old_rec.aei_information20, hr_api.g_varchar2) <>
696: nvl(p_rec.aei_information20, hr_api.g_varchar2) or
697: nvl(pe_aei_shd.g_old_rec.aei_information21, hr_api.g_varchar2) <>
698: nvl(p_rec.aei_information21, hr_api.g_varchar2) or
691: nvl(pe_aei_shd.g_old_rec.aei_information18, hr_api.g_varchar2) <>
692: nvl(p_rec.aei_information18, hr_api.g_varchar2) or
693: nvl(pe_aei_shd.g_old_rec.aei_information19, hr_api.g_varchar2) <>
694: nvl(p_rec.aei_information19, hr_api.g_varchar2) or
695: nvl(pe_aei_shd.g_old_rec.aei_information20, hr_api.g_varchar2) <>
696: nvl(p_rec.aei_information20, hr_api.g_varchar2) or
697: nvl(pe_aei_shd.g_old_rec.aei_information21, hr_api.g_varchar2) <>
698: nvl(p_rec.aei_information21, hr_api.g_varchar2) or
699: nvl(pe_aei_shd.g_old_rec.aei_information22, hr_api.g_varchar2) <>
692: nvl(p_rec.aei_information18, hr_api.g_varchar2) or
693: nvl(pe_aei_shd.g_old_rec.aei_information19, hr_api.g_varchar2) <>
694: nvl(p_rec.aei_information19, hr_api.g_varchar2) or
695: nvl(pe_aei_shd.g_old_rec.aei_information20, hr_api.g_varchar2) <>
696: nvl(p_rec.aei_information20, hr_api.g_varchar2) or
697: nvl(pe_aei_shd.g_old_rec.aei_information21, hr_api.g_varchar2) <>
698: nvl(p_rec.aei_information21, hr_api.g_varchar2) or
699: nvl(pe_aei_shd.g_old_rec.aei_information22, hr_api.g_varchar2) <>
700: nvl(p_rec.aei_information22, hr_api.g_varchar2) or
693: nvl(pe_aei_shd.g_old_rec.aei_information19, hr_api.g_varchar2) <>
694: nvl(p_rec.aei_information19, hr_api.g_varchar2) or
695: nvl(pe_aei_shd.g_old_rec.aei_information20, hr_api.g_varchar2) <>
696: nvl(p_rec.aei_information20, hr_api.g_varchar2) or
697: nvl(pe_aei_shd.g_old_rec.aei_information21, hr_api.g_varchar2) <>
698: nvl(p_rec.aei_information21, hr_api.g_varchar2) or
699: nvl(pe_aei_shd.g_old_rec.aei_information22, hr_api.g_varchar2) <>
700: nvl(p_rec.aei_information22, hr_api.g_varchar2) or
701: nvl(pe_aei_shd.g_old_rec.aei_information23, hr_api.g_varchar2) <>
694: nvl(p_rec.aei_information19, hr_api.g_varchar2) or
695: nvl(pe_aei_shd.g_old_rec.aei_information20, hr_api.g_varchar2) <>
696: nvl(p_rec.aei_information20, hr_api.g_varchar2) or
697: nvl(pe_aei_shd.g_old_rec.aei_information21, hr_api.g_varchar2) <>
698: nvl(p_rec.aei_information21, hr_api.g_varchar2) or
699: nvl(pe_aei_shd.g_old_rec.aei_information22, hr_api.g_varchar2) <>
700: nvl(p_rec.aei_information22, hr_api.g_varchar2) or
701: nvl(pe_aei_shd.g_old_rec.aei_information23, hr_api.g_varchar2) <>
702: nvl(p_rec.aei_information23, hr_api.g_varchar2) or
695: nvl(pe_aei_shd.g_old_rec.aei_information20, hr_api.g_varchar2) <>
696: nvl(p_rec.aei_information20, hr_api.g_varchar2) or
697: nvl(pe_aei_shd.g_old_rec.aei_information21, hr_api.g_varchar2) <>
698: nvl(p_rec.aei_information21, hr_api.g_varchar2) or
699: nvl(pe_aei_shd.g_old_rec.aei_information22, hr_api.g_varchar2) <>
700: nvl(p_rec.aei_information22, hr_api.g_varchar2) or
701: nvl(pe_aei_shd.g_old_rec.aei_information23, hr_api.g_varchar2) <>
702: nvl(p_rec.aei_information23, hr_api.g_varchar2) or
703: nvl(pe_aei_shd.g_old_rec.aei_information24, hr_api.g_varchar2) <>
696: nvl(p_rec.aei_information20, hr_api.g_varchar2) or
697: nvl(pe_aei_shd.g_old_rec.aei_information21, hr_api.g_varchar2) <>
698: nvl(p_rec.aei_information21, hr_api.g_varchar2) or
699: nvl(pe_aei_shd.g_old_rec.aei_information22, hr_api.g_varchar2) <>
700: nvl(p_rec.aei_information22, hr_api.g_varchar2) or
701: nvl(pe_aei_shd.g_old_rec.aei_information23, hr_api.g_varchar2) <>
702: nvl(p_rec.aei_information23, hr_api.g_varchar2) or
703: nvl(pe_aei_shd.g_old_rec.aei_information24, hr_api.g_varchar2) <>
704: nvl(p_rec.aei_information24, hr_api.g_varchar2) or
697: nvl(pe_aei_shd.g_old_rec.aei_information21, hr_api.g_varchar2) <>
698: nvl(p_rec.aei_information21, hr_api.g_varchar2) or
699: nvl(pe_aei_shd.g_old_rec.aei_information22, hr_api.g_varchar2) <>
700: nvl(p_rec.aei_information22, hr_api.g_varchar2) or
701: nvl(pe_aei_shd.g_old_rec.aei_information23, hr_api.g_varchar2) <>
702: nvl(p_rec.aei_information23, hr_api.g_varchar2) or
703: nvl(pe_aei_shd.g_old_rec.aei_information24, hr_api.g_varchar2) <>
704: nvl(p_rec.aei_information24, hr_api.g_varchar2) or
705: nvl(pe_aei_shd.g_old_rec.aei_information25, hr_api.g_varchar2) <>
698: nvl(p_rec.aei_information21, hr_api.g_varchar2) or
699: nvl(pe_aei_shd.g_old_rec.aei_information22, hr_api.g_varchar2) <>
700: nvl(p_rec.aei_information22, hr_api.g_varchar2) or
701: nvl(pe_aei_shd.g_old_rec.aei_information23, hr_api.g_varchar2) <>
702: nvl(p_rec.aei_information23, hr_api.g_varchar2) or
703: nvl(pe_aei_shd.g_old_rec.aei_information24, hr_api.g_varchar2) <>
704: nvl(p_rec.aei_information24, hr_api.g_varchar2) or
705: nvl(pe_aei_shd.g_old_rec.aei_information25, hr_api.g_varchar2) <>
706: nvl(p_rec.aei_information25, hr_api.g_varchar2) or
699: nvl(pe_aei_shd.g_old_rec.aei_information22, hr_api.g_varchar2) <>
700: nvl(p_rec.aei_information22, hr_api.g_varchar2) or
701: nvl(pe_aei_shd.g_old_rec.aei_information23, hr_api.g_varchar2) <>
702: nvl(p_rec.aei_information23, hr_api.g_varchar2) or
703: nvl(pe_aei_shd.g_old_rec.aei_information24, hr_api.g_varchar2) <>
704: nvl(p_rec.aei_information24, hr_api.g_varchar2) or
705: nvl(pe_aei_shd.g_old_rec.aei_information25, hr_api.g_varchar2) <>
706: nvl(p_rec.aei_information25, hr_api.g_varchar2) or
707: nvl(pe_aei_shd.g_old_rec.aei_information26, hr_api.g_varchar2) <>
700: nvl(p_rec.aei_information22, hr_api.g_varchar2) or
701: nvl(pe_aei_shd.g_old_rec.aei_information23, hr_api.g_varchar2) <>
702: nvl(p_rec.aei_information23, hr_api.g_varchar2) or
703: nvl(pe_aei_shd.g_old_rec.aei_information24, hr_api.g_varchar2) <>
704: nvl(p_rec.aei_information24, hr_api.g_varchar2) or
705: nvl(pe_aei_shd.g_old_rec.aei_information25, hr_api.g_varchar2) <>
706: nvl(p_rec.aei_information25, hr_api.g_varchar2) or
707: nvl(pe_aei_shd.g_old_rec.aei_information26, hr_api.g_varchar2) <>
708: nvl(p_rec.aei_information26, hr_api.g_varchar2) or
701: nvl(pe_aei_shd.g_old_rec.aei_information23, hr_api.g_varchar2) <>
702: nvl(p_rec.aei_information23, hr_api.g_varchar2) or
703: nvl(pe_aei_shd.g_old_rec.aei_information24, hr_api.g_varchar2) <>
704: nvl(p_rec.aei_information24, hr_api.g_varchar2) or
705: nvl(pe_aei_shd.g_old_rec.aei_information25, hr_api.g_varchar2) <>
706: nvl(p_rec.aei_information25, hr_api.g_varchar2) or
707: nvl(pe_aei_shd.g_old_rec.aei_information26, hr_api.g_varchar2) <>
708: nvl(p_rec.aei_information26, hr_api.g_varchar2) or
709: nvl(pe_aei_shd.g_old_rec.aei_information27, hr_api.g_varchar2) <>
702: nvl(p_rec.aei_information23, hr_api.g_varchar2) or
703: nvl(pe_aei_shd.g_old_rec.aei_information24, hr_api.g_varchar2) <>
704: nvl(p_rec.aei_information24, hr_api.g_varchar2) or
705: nvl(pe_aei_shd.g_old_rec.aei_information25, hr_api.g_varchar2) <>
706: nvl(p_rec.aei_information25, hr_api.g_varchar2) or
707: nvl(pe_aei_shd.g_old_rec.aei_information26, hr_api.g_varchar2) <>
708: nvl(p_rec.aei_information26, hr_api.g_varchar2) or
709: nvl(pe_aei_shd.g_old_rec.aei_information27, hr_api.g_varchar2) <>
710: nvl(p_rec.aei_information27, hr_api.g_varchar2) or
703: nvl(pe_aei_shd.g_old_rec.aei_information24, hr_api.g_varchar2) <>
704: nvl(p_rec.aei_information24, hr_api.g_varchar2) or
705: nvl(pe_aei_shd.g_old_rec.aei_information25, hr_api.g_varchar2) <>
706: nvl(p_rec.aei_information25, hr_api.g_varchar2) or
707: nvl(pe_aei_shd.g_old_rec.aei_information26, hr_api.g_varchar2) <>
708: nvl(p_rec.aei_information26, hr_api.g_varchar2) or
709: nvl(pe_aei_shd.g_old_rec.aei_information27, hr_api.g_varchar2) <>
710: nvl(p_rec.aei_information27, hr_api.g_varchar2) or
711: nvl(pe_aei_shd.g_old_rec.aei_information28, hr_api.g_varchar2) <>
704: nvl(p_rec.aei_information24, hr_api.g_varchar2) or
705: nvl(pe_aei_shd.g_old_rec.aei_information25, hr_api.g_varchar2) <>
706: nvl(p_rec.aei_information25, hr_api.g_varchar2) or
707: nvl(pe_aei_shd.g_old_rec.aei_information26, hr_api.g_varchar2) <>
708: nvl(p_rec.aei_information26, hr_api.g_varchar2) or
709: nvl(pe_aei_shd.g_old_rec.aei_information27, hr_api.g_varchar2) <>
710: nvl(p_rec.aei_information27, hr_api.g_varchar2) or
711: nvl(pe_aei_shd.g_old_rec.aei_information28, hr_api.g_varchar2) <>
712: nvl(p_rec.aei_information28, hr_api.g_varchar2) or
705: nvl(pe_aei_shd.g_old_rec.aei_information25, hr_api.g_varchar2) <>
706: nvl(p_rec.aei_information25, hr_api.g_varchar2) or
707: nvl(pe_aei_shd.g_old_rec.aei_information26, hr_api.g_varchar2) <>
708: nvl(p_rec.aei_information26, hr_api.g_varchar2) or
709: nvl(pe_aei_shd.g_old_rec.aei_information27, hr_api.g_varchar2) <>
710: nvl(p_rec.aei_information27, hr_api.g_varchar2) or
711: nvl(pe_aei_shd.g_old_rec.aei_information28, hr_api.g_varchar2) <>
712: nvl(p_rec.aei_information28, hr_api.g_varchar2) or
713: nvl(pe_aei_shd.g_old_rec.aei_information29, hr_api.g_varchar2) <>
706: nvl(p_rec.aei_information25, hr_api.g_varchar2) or
707: nvl(pe_aei_shd.g_old_rec.aei_information26, hr_api.g_varchar2) <>
708: nvl(p_rec.aei_information26, hr_api.g_varchar2) or
709: nvl(pe_aei_shd.g_old_rec.aei_information27, hr_api.g_varchar2) <>
710: nvl(p_rec.aei_information27, hr_api.g_varchar2) or
711: nvl(pe_aei_shd.g_old_rec.aei_information28, hr_api.g_varchar2) <>
712: nvl(p_rec.aei_information28, hr_api.g_varchar2) or
713: nvl(pe_aei_shd.g_old_rec.aei_information29, hr_api.g_varchar2) <>
714: nvl(p_rec.aei_information29, hr_api.g_varchar2) or
707: nvl(pe_aei_shd.g_old_rec.aei_information26, hr_api.g_varchar2) <>
708: nvl(p_rec.aei_information26, hr_api.g_varchar2) or
709: nvl(pe_aei_shd.g_old_rec.aei_information27, hr_api.g_varchar2) <>
710: nvl(p_rec.aei_information27, hr_api.g_varchar2) or
711: nvl(pe_aei_shd.g_old_rec.aei_information28, hr_api.g_varchar2) <>
712: nvl(p_rec.aei_information28, hr_api.g_varchar2) or
713: nvl(pe_aei_shd.g_old_rec.aei_information29, hr_api.g_varchar2) <>
714: nvl(p_rec.aei_information29, hr_api.g_varchar2) or
715: nvl(pe_aei_shd.g_old_rec.aei_information30, hr_api.g_varchar2) <>
708: nvl(p_rec.aei_information26, hr_api.g_varchar2) or
709: nvl(pe_aei_shd.g_old_rec.aei_information27, hr_api.g_varchar2) <>
710: nvl(p_rec.aei_information27, hr_api.g_varchar2) or
711: nvl(pe_aei_shd.g_old_rec.aei_information28, hr_api.g_varchar2) <>
712: nvl(p_rec.aei_information28, hr_api.g_varchar2) or
713: nvl(pe_aei_shd.g_old_rec.aei_information29, hr_api.g_varchar2) <>
714: nvl(p_rec.aei_information29, hr_api.g_varchar2) or
715: nvl(pe_aei_shd.g_old_rec.aei_information30, hr_api.g_varchar2) <>
716: nvl(p_rec.aei_information30, hr_api.g_varchar2))
709: nvl(pe_aei_shd.g_old_rec.aei_information27, hr_api.g_varchar2) <>
710: nvl(p_rec.aei_information27, hr_api.g_varchar2) or
711: nvl(pe_aei_shd.g_old_rec.aei_information28, hr_api.g_varchar2) <>
712: nvl(p_rec.aei_information28, hr_api.g_varchar2) or
713: nvl(pe_aei_shd.g_old_rec.aei_information29, hr_api.g_varchar2) <>
714: nvl(p_rec.aei_information29, hr_api.g_varchar2) or
715: nvl(pe_aei_shd.g_old_rec.aei_information30, hr_api.g_varchar2) <>
716: nvl(p_rec.aei_information30, hr_api.g_varchar2))
717: then
710: nvl(p_rec.aei_information27, hr_api.g_varchar2) or
711: nvl(pe_aei_shd.g_old_rec.aei_information28, hr_api.g_varchar2) <>
712: nvl(p_rec.aei_information28, hr_api.g_varchar2) or
713: nvl(pe_aei_shd.g_old_rec.aei_information29, hr_api.g_varchar2) <>
714: nvl(p_rec.aei_information29, hr_api.g_varchar2) or
715: nvl(pe_aei_shd.g_old_rec.aei_information30, hr_api.g_varchar2) <>
716: nvl(p_rec.aei_information30, hr_api.g_varchar2))
717: then
718: --
711: nvl(pe_aei_shd.g_old_rec.aei_information28, hr_api.g_varchar2) <>
712: nvl(p_rec.aei_information28, hr_api.g_varchar2) or
713: nvl(pe_aei_shd.g_old_rec.aei_information29, hr_api.g_varchar2) <>
714: nvl(p_rec.aei_information29, hr_api.g_varchar2) or
715: nvl(pe_aei_shd.g_old_rec.aei_information30, hr_api.g_varchar2) <>
716: nvl(p_rec.aei_information30, hr_api.g_varchar2))
717: then
718: --
719: hr_dflex_utility.ins_or_upd_descflex_attribs
712: nvl(p_rec.aei_information28, hr_api.g_varchar2) or
713: nvl(pe_aei_shd.g_old_rec.aei_information29, hr_api.g_varchar2) <>
714: nvl(p_rec.aei_information29, hr_api.g_varchar2) or
715: nvl(pe_aei_shd.g_old_rec.aei_information30, hr_api.g_varchar2) <>
716: nvl(p_rec.aei_information30, hr_api.g_varchar2))
717: then
718: --
719: hr_dflex_utility.ins_or_upd_descflex_attribs
720: (p_appl_short_name => 'PER'