APPS.PE_AEI_BUS dependencies on HR_API

Line 43: hr_api.mandatory_arg_error

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

Line 67: hr_api.set_security_group_id

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

Line 101: hr_api.mandatory_arg_error(p_api_name => l_proc

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:

Line 107: if ( nvl(pe_aei_bus.g_assignment_extra_info_id, hr_api.g_number)

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

Line 197: hr_api.mandatory_arg_error

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

Line 278: hr_api.mandatory_arg_error

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

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

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;

Line 445: nvl(pe_aei_shd.g_old_rec.information_type, hr_api.g_varchar2) then

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

Line 452: if nvl(p_rec.assignment_id, hr_api.g_number) <>

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;

Line 453: nvl(pe_aei_shd.g_old_rec.assignment_id, hr_api.g_number) then

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

Line 461: hr_api.argument_changed_error

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

Line 510: nvl(pe_aei_shd.g_old_rec.aei_attribute_category, hr_api.g_varchar2) <>

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

Line 511: nvl(p_rec.aei_attribute_category, hr_api.g_varchar2) or

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

Line 512: nvl(pe_aei_shd.g_old_rec.aei_attribute1, hr_api.g_varchar2) <>

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

Line 513: nvl(p_rec.aei_attribute1, hr_api.g_varchar2) or

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

Line 514: nvl(pe_aei_shd.g_old_rec.aei_attribute2, hr_api.g_varchar2) <>

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

Line 515: nvl(p_rec.aei_attribute2, hr_api.g_varchar2) or

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

Line 516: nvl(pe_aei_shd.g_old_rec.aei_attribute3, hr_api.g_varchar2) <>

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

Line 517: nvl(p_rec.aei_attribute3, hr_api.g_varchar2) or

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

Line 518: nvl(pe_aei_shd.g_old_rec.aei_attribute4, hr_api.g_varchar2) <>

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

Line 519: nvl(p_rec.aei_attribute4, hr_api.g_varchar2) or

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

Line 520: nvl(pe_aei_shd.g_old_rec.aei_attribute5, hr_api.g_varchar2) <>

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

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

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

Line 522: nvl(pe_aei_shd.g_old_rec.aei_attribute6, hr_api.g_varchar2) <>

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

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

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

Line 524: nvl(pe_aei_shd.g_old_rec.aei_attribute7, hr_api.g_varchar2) <>

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

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

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

Line 526: nvl(pe_aei_shd.g_old_rec.aei_attribute8, hr_api.g_varchar2) <>

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

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

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

Line 528: nvl(pe_aei_shd.g_old_rec.aei_attribute9, hr_api.g_varchar2) <>

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

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

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

Line 530: nvl(pe_aei_shd.g_old_rec.aei_attribute10, hr_api.g_varchar2) <>

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

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

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

Line 532: nvl(pe_aei_shd.g_old_rec.aei_attribute11, hr_api.g_varchar2) <>

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

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

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

Line 534: nvl(pe_aei_shd.g_old_rec.aei_attribute12, hr_api.g_varchar2) <>

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

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

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

Line 536: nvl(pe_aei_shd.g_old_rec.aei_attribute13, hr_api.g_varchar2) <>

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

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

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

Line 538: nvl(pe_aei_shd.g_old_rec.aei_attribute14, hr_api.g_varchar2) <>

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

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

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

Line 540: nvl(pe_aei_shd.g_old_rec.aei_attribute15, hr_api.g_varchar2) <>

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

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

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

Line 542: nvl(pe_aei_shd.g_old_rec.aei_attribute16, hr_api.g_varchar2) <>

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

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

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

Line 544: nvl(pe_aei_shd.g_old_rec.aei_attribute17, hr_api.g_varchar2) <>

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

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

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

Line 546: nvl(pe_aei_shd.g_old_rec.aei_attribute18, hr_api.g_varchar2) <>

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

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

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

Line 548: nvl(pe_aei_shd.g_old_rec.aei_attribute19, 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

Line 549: nvl(p_rec.aei_attribute19, hr_api.g_varchar2) 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

Line 550: nvl(pe_aei_shd.g_old_rec.aei_attribute20, hr_api.g_varchar2) <>

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

Line 551: nvl(p_rec.aei_attribute20, 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: --
555: -- Only execute the validation if absolutely necessary:

Line 655: nvl(pe_aei_shd.g_old_rec.aei_attribute_category, hr_api.g_varchar2) <>

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

Line 656: nvl(p_rec.aei_information_category, hr_api.g_varchar2) or

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

Line 657: nvl(pe_aei_shd.g_old_rec.aei_information1, hr_api.g_varchar2) <>

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

Line 658: nvl(p_rec.aei_information1, hr_api.g_varchar2) or

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

Line 659: nvl(pe_aei_shd.g_old_rec.aei_information2, hr_api.g_varchar2) <>

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

Line 660: nvl(p_rec.aei_information2, hr_api.g_varchar2) or

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

Line 661: nvl(pe_aei_shd.g_old_rec.aei_information3, hr_api.g_varchar2) <>

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

Line 662: nvl(p_rec.aei_information3, hr_api.g_varchar2) or

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

Line 663: nvl(pe_aei_shd.g_old_rec.aei_information4, hr_api.g_varchar2) <>

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

Line 664: nvl(p_rec.aei_information4, hr_api.g_varchar2) or

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

Line 665: nvl(pe_aei_shd.g_old_rec.aei_information5, hr_api.g_varchar2) <>

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

Line 666: nvl(p_rec.aei_information5, hr_api.g_varchar2) or

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

Line 667: nvl(pe_aei_shd.g_old_rec.aei_information6, hr_api.g_varchar2) <>

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

Line 668: nvl(p_rec.aei_information6, hr_api.g_varchar2) or

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

Line 669: nvl(pe_aei_shd.g_old_rec.aei_information7, hr_api.g_varchar2) <>

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

Line 670: nvl(p_rec.aei_information7, hr_api.g_varchar2) or

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

Line 671: nvl(pe_aei_shd.g_old_rec.aei_information8, hr_api.g_varchar2) <>

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

Line 672: nvl(p_rec.aei_information8, hr_api.g_varchar2) or

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

Line 673: nvl(pe_aei_shd.g_old_rec.aei_information9, hr_api.g_varchar2) <>

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

Line 674: nvl(p_rec.aei_information9, hr_api.g_varchar2) or

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

Line 675: nvl(pe_aei_shd.g_old_rec.aei_information10, hr_api.g_varchar2) <>

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

Line 676: nvl(p_rec.aei_information10, hr_api.g_varchar2) or

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

Line 677: nvl(pe_aei_shd.g_old_rec.aei_information11, hr_api.g_varchar2) <>

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

Line 678: nvl(p_rec.aei_information11, hr_api.g_varchar2) or

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

Line 679: nvl(pe_aei_shd.g_old_rec.aei_information12, hr_api.g_varchar2) <>

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

Line 680: nvl(p_rec.aei_information12, hr_api.g_varchar2) or

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

Line 681: nvl(pe_aei_shd.g_old_rec.aei_information13, hr_api.g_varchar2) <>

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

Line 682: nvl(p_rec.aei_information13, hr_api.g_varchar2) or

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

Line 683: nvl(pe_aei_shd.g_old_rec.aei_information14, hr_api.g_varchar2) <>

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

Line 684: nvl(p_rec.aei_information14, hr_api.g_varchar2) or

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

Line 685: nvl(pe_aei_shd.g_old_rec.aei_information15, hr_api.g_varchar2) <>

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

Line 686: nvl(p_rec.aei_information15, hr_api.g_varchar2) or

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

Line 687: nvl(pe_aei_shd.g_old_rec.aei_information16, hr_api.g_varchar2) <>

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

Line 688: nvl(p_rec.aei_information16, hr_api.g_varchar2) or

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

Line 689: nvl(pe_aei_shd.g_old_rec.aei_information17, hr_api.g_varchar2) <>

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

Line 690: nvl(p_rec.aei_information17, hr_api.g_varchar2) or

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

Line 691: nvl(pe_aei_shd.g_old_rec.aei_information18, hr_api.g_varchar2) <>

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

Line 692: nvl(p_rec.aei_information18, hr_api.g_varchar2) or

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

Line 693: nvl(pe_aei_shd.g_old_rec.aei_information19, hr_api.g_varchar2) <>

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

Line 694: nvl(p_rec.aei_information19, hr_api.g_varchar2) or

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

Line 695: nvl(pe_aei_shd.g_old_rec.aei_information20, hr_api.g_varchar2) <>

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

Line 696: nvl(p_rec.aei_information20, hr_api.g_varchar2) or

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

Line 697: nvl(pe_aei_shd.g_old_rec.aei_information21, hr_api.g_varchar2) <>

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

Line 698: nvl(p_rec.aei_information21, hr_api.g_varchar2) or

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

Line 699: nvl(pe_aei_shd.g_old_rec.aei_information22, hr_api.g_varchar2) <>

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

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

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

Line 701: nvl(pe_aei_shd.g_old_rec.aei_information23, hr_api.g_varchar2) <>

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

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

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

Line 703: nvl(pe_aei_shd.g_old_rec.aei_information24, hr_api.g_varchar2) <>

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

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

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

Line 705: nvl(pe_aei_shd.g_old_rec.aei_information25, hr_api.g_varchar2) <>

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

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

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

Line 707: nvl(pe_aei_shd.g_old_rec.aei_information26, hr_api.g_varchar2) <>

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

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

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

Line 709: nvl(pe_aei_shd.g_old_rec.aei_information27, hr_api.g_varchar2) <>

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

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

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

Line 711: nvl(pe_aei_shd.g_old_rec.aei_information28, hr_api.g_varchar2) <>

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

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

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

Line 713: nvl(pe_aei_shd.g_old_rec.aei_information29, 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

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

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

Line 715: nvl(pe_aei_shd.g_old_rec.aei_information30, hr_api.g_varchar2) <>

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

Line 716: nvl(p_rec.aei_information30, 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
720: (p_appl_short_name => 'PER'