eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_ESA_BUS dependencies on HR_API

Line 57: and nvl(p_attendance_id,hr_api.g_number)

53: (p_attendance_id => p_attendance_id,
54: p_object_version_number => p_object_version_number);
55: --
56: if (l_api_updating
57: and nvl(p_attendance_id,hr_api.g_number)
58: <> per_esa_shd.g_old_rec.attendance_id) then
59: --
60: -- raise error as PK has changed
61: --

Line 130: and per.attended_start_date = nvl(p_attended_start_date,hr_api.g_sot)

126: cursor c1 is
127: select null
128: from per_establishment_attendances per
129: where per.person_id = p_person_id
130: and per.attended_start_date = nvl(p_attended_start_date,hr_api.g_sot)
131: and nvl(per.establishment_id,-1) = nvl(p_establishment_id,-1)
132: and nvl(per.establishment,-1) = nvl(p_establishment,-1)
133: and nvl(per.business_group_id,-1) = nvl(p_business_group_id,-1);
134: --

Line 139: and per.attended_start_date = nvl(p_attended_start_date,hr_api.g_sot)

135: cursor c2 is
136: select null
137: from per_establishment_attendances per
138: where per.party_id = p_party_id
139: and per.attended_start_date = nvl(p_attended_start_date,hr_api.g_sot)
140: and nvl(per.establishment_id,-1) = nvl(p_establishment_id,-1)
141: and nvl(per.establishment,-1) = nvl(p_establishment,-1);
142: --
143: Begin

Line 152: and (nvl(p_person_id,hr_api.g_number)

148: (p_attendance_id => p_attendance_id,
149: p_object_version_number => p_object_version_number);
150: --
151: if (l_api_updating
152: and (nvl(p_person_id,hr_api.g_number)
153: <> per_esa_shd.g_old_rec.person_id
154: or nvl(p_party_id,hr_api.g_number) -- HR/TCA merge
155: <> per_esa_shd.g_old_rec.party_id
156: or nvl(p_attended_start_date,hr_api.g_date)

Line 154: or nvl(p_party_id,hr_api.g_number) -- HR/TCA merge

150: --
151: if (l_api_updating
152: and (nvl(p_person_id,hr_api.g_number)
153: <> per_esa_shd.g_old_rec.person_id
154: or nvl(p_party_id,hr_api.g_number) -- HR/TCA merge
155: <> per_esa_shd.g_old_rec.party_id
156: or nvl(p_attended_start_date,hr_api.g_date)
157: <> nvl(per_esa_shd.g_old_rec.attended_start_date,hr_api.g_date ) --Bug 8364149
158: or nvl(p_establishment_id,hr_api.g_number)

Line 156: or nvl(p_attended_start_date,hr_api.g_date)

152: and (nvl(p_person_id,hr_api.g_number)
153: <> per_esa_shd.g_old_rec.person_id
154: or nvl(p_party_id,hr_api.g_number) -- HR/TCA merge
155: <> per_esa_shd.g_old_rec.party_id
156: or nvl(p_attended_start_date,hr_api.g_date)
157: <> nvl(per_esa_shd.g_old_rec.attended_start_date,hr_api.g_date ) --Bug 8364149
158: or nvl(p_establishment_id,hr_api.g_number)
159: <> per_esa_shd.g_old_rec.establishment_id
160: or nvl(p_establishment,hr_api.g_varchar2)

Line 157: <> nvl(per_esa_shd.g_old_rec.attended_start_date,hr_api.g_date ) --Bug 8364149

153: <> per_esa_shd.g_old_rec.person_id
154: or nvl(p_party_id,hr_api.g_number) -- HR/TCA merge
155: <> per_esa_shd.g_old_rec.party_id
156: or nvl(p_attended_start_date,hr_api.g_date)
157: <> nvl(per_esa_shd.g_old_rec.attended_start_date,hr_api.g_date ) --Bug 8364149
158: or nvl(p_establishment_id,hr_api.g_number)
159: <> per_esa_shd.g_old_rec.establishment_id
160: or nvl(p_establishment,hr_api.g_varchar2)
161: <> per_esa_shd.g_old_rec.establishment

Line 158: or nvl(p_establishment_id,hr_api.g_number)

154: or nvl(p_party_id,hr_api.g_number) -- HR/TCA merge
155: <> per_esa_shd.g_old_rec.party_id
156: or nvl(p_attended_start_date,hr_api.g_date)
157: <> nvl(per_esa_shd.g_old_rec.attended_start_date,hr_api.g_date ) --Bug 8364149
158: or nvl(p_establishment_id,hr_api.g_number)
159: <> per_esa_shd.g_old_rec.establishment_id
160: or nvl(p_establishment,hr_api.g_varchar2)
161: <> per_esa_shd.g_old_rec.establishment
162: or nvl(p_business_group_id,hr_api.g_number)

Line 160: or nvl(p_establishment,hr_api.g_varchar2)

156: or nvl(p_attended_start_date,hr_api.g_date)
157: <> nvl(per_esa_shd.g_old_rec.attended_start_date,hr_api.g_date ) --Bug 8364149
158: or nvl(p_establishment_id,hr_api.g_number)
159: <> per_esa_shd.g_old_rec.establishment_id
160: or nvl(p_establishment,hr_api.g_varchar2)
161: <> per_esa_shd.g_old_rec.establishment
162: or nvl(p_business_group_id,hr_api.g_number)
163: <> per_esa_shd.g_old_rec.business_group_id)
164: or not l_api_updating) then

Line 162: or nvl(p_business_group_id,hr_api.g_number)

158: or nvl(p_establishment_id,hr_api.g_number)
159: <> per_esa_shd.g_old_rec.establishment_id
160: or nvl(p_establishment,hr_api.g_varchar2)
161: <> per_esa_shd.g_old_rec.establishment
162: or nvl(p_business_group_id,hr_api.g_number)
163: <> per_esa_shd.g_old_rec.business_group_id)
164: or not l_api_updating) then
165: --
166: -- check if person_id is null

Line 232: and nvl(per_esa_shd.g_old_rec.person_id,hr_api.g_number) <> hr_api.g_number

228: --
229: --UPDATE of person_id not allowed unless currently null(U)
230: --
231: if (l_api_updating
232: and nvl(per_esa_shd.g_old_rec.person_id,hr_api.g_number) <> hr_api.g_number
233: and per_esa_shd.g_old_rec.person_id <> p_person_id
234: ) then
235: --
236: hr_utility.set_message(800, 'HR_289948_INV_UPD_PERSON_ID');

Line 292: and nvl(per.effective_end_date,hr_api.g_eot);

288: from per_all_people_f per
289: where per.person_id = p_rec.person_id
290: and p_effective_date
291: between per.effective_start_date
292: and nvl(per.effective_end_date,hr_api.g_eot);
293: --
294: cursor csr_valid_party_id is
295: select party_id
296: from hz_parties hzp

Line 391: and nvl(p_address,hr_api.g_varchar2)

387: hr_utility.set_location(l_temp,6);
388: --hr_utility.set_location(l_api_updating,6);
389: --
390: if (l_api_updating
391: and nvl(p_address,hr_api.g_varchar2)
392: <> nvl(per_esa_shd.g_old_rec.address,hr_api.g_varchar2)
393: or not l_api_updating) then
394: --
395: -- check if establishment_id is changeing at the same time as the address

Line 392: <> nvl(per_esa_shd.g_old_rec.address,hr_api.g_varchar2)

388: --hr_utility.set_location(l_api_updating,6);
389: --
390: if (l_api_updating
391: and nvl(p_address,hr_api.g_varchar2)
392: <> nvl(per_esa_shd.g_old_rec.address,hr_api.g_varchar2)
393: or not l_api_updating) then
394: --
395: -- check if establishment_id is changeing at the same time as the address
396: --

Line 400: if nvl(p_establishment_id,hr_api.g_number) <> nvl(per_esa_shd.g_old_rec.establishment_id,hr_api.g_number) and p_attendance_id is not null then

396: --
397: hr_utility.set_location(p_address,10);
398: hr_utility.set_location(p_establishment_id,10);
399: --
400: if nvl(p_establishment_id,hr_api.g_number) <> nvl(per_esa_shd.g_old_rec.establishment_id,hr_api.g_number) and p_attendance_id is not null then
401: --
402: -- raise error as does not exist as lookup
403: --
404: fnd_message.set_name('PER', 'HR_289587_ESA_ADDRESS_UPDATE');

Line 410: and nvl(p_establishment_id,hr_api.g_number)

406: --
407: end if;
408:
409: elsif (l_api_updating
410: and nvl(p_establishment_id,hr_api.g_number)
411: <> per_esa_shd.g_old_rec.establishment_id
412: or not l_api_updating) then
413:
414: hr_utility.set_location('Establishment Updating',15);

Line 482: and nvl(p_full_time,hr_api.g_varchar2)

478: (p_attendance_id => p_attendance_id,
479: p_object_version_number => p_object_version_number);
480: --
481: if (l_api_updating
482: and nvl(p_full_time,hr_api.g_varchar2)
483: <> per_esa_shd.g_old_rec.full_time
484: or not l_api_updating) then
485: --
486: -- check if value of full time falls within Full or Part time

Line 490: if hr_api.not_exists_in_hr_lookups(p_lookup_type => 'YES_NO',

486: -- check if value of full time falls within Full or Part time
487: --
488: hr_utility.set_location(p_full_time,100);
489: --
490: if hr_api.not_exists_in_hr_lookups(p_lookup_type => 'YES_NO',
491: p_lookup_code => p_full_time,
492: p_effective_date => p_effective_date) then
493: --
494: -- raise error as does not exist as lookup

Line 581: and nvl(p_establishment_id,hr_api.g_number)

577: --
578: if p_establishment_id is not null
579: and (not l_api_updating
580: or (l_api_updating
581: and nvl(p_establishment_id,hr_api.g_number)
582: <> per_esa_shd.g_old_rec.establishment_id)) then
583: --
584: -- check if establishment id exists in per_establishments table
585: --

Line 676: and (nvl(p_attended_start_date,hr_api.g_sot)

672: from per_establishment_attendances per
673: where per.person_id = p_person_id
674: and per.establishment_id = p_establishment_id
675: and per.attendance_id <> nvl(p_attendance_id,-1)
676: and (nvl(p_attended_start_date,hr_api.g_sot)
677: between per.attended_start_date
678: and nvl(per.attended_end_date,hr_api.g_eot)
679: or nvl(p_attended_end_date,hr_api.g_eot)
680: between per.attended_start_date

Line 678: and nvl(per.attended_end_date,hr_api.g_eot)

674: and per.establishment_id = p_establishment_id
675: and per.attendance_id <> nvl(p_attendance_id,-1)
676: and (nvl(p_attended_start_date,hr_api.g_sot)
677: between per.attended_start_date
678: and nvl(per.attended_end_date,hr_api.g_eot)
679: or nvl(p_attended_end_date,hr_api.g_eot)
680: between per.attended_start_date
681: and nvl(per.attended_end_date,hr_api.g_eot));
682: --

Line 679: or nvl(p_attended_end_date,hr_api.g_eot)

675: and per.attendance_id <> nvl(p_attendance_id,-1)
676: and (nvl(p_attended_start_date,hr_api.g_sot)
677: between per.attended_start_date
678: and nvl(per.attended_end_date,hr_api.g_eot)
679: or nvl(p_attended_end_date,hr_api.g_eot)
680: between per.attended_start_date
681: and nvl(per.attended_end_date,hr_api.g_eot));
682: --
683: cursor c2 is

Line 681: and nvl(per.attended_end_date,hr_api.g_eot));

677: between per.attended_start_date
678: and nvl(per.attended_end_date,hr_api.g_eot)
679: or nvl(p_attended_end_date,hr_api.g_eot)
680: between per.attended_start_date
681: and nvl(per.attended_end_date,hr_api.g_eot));
682: --
683: cursor c2 is
684: select null
685: from per_qualifications per

Line 688: not between nvl(p_attended_start_date,hr_api.g_sot)

684: select null
685: from per_qualifications per
686: where per.attendance_id = p_attendance_id
687: and (per.start_date
688: not between nvl(p_attended_start_date,hr_api.g_sot)
689: and nvl(p_attended_end_date,per.start_date)
690: or per.end_date
691: not between nvl(p_attended_start_date,hr_api.g_sot)
692: and nvl(p_attended_end_date,per.end_date));

Line 691: not between nvl(p_attended_start_date,hr_api.g_sot)

687: and (per.start_date
688: not between nvl(p_attended_start_date,hr_api.g_sot)
689: and nvl(p_attended_end_date,per.start_date)
690: or per.end_date
691: not between nvl(p_attended_start_date,hr_api.g_sot)
692: and nvl(p_attended_end_date,per.end_date));
693: -- HR/TCA merge
694: -- For party_id
695: cursor c3 is

Line 701: and (nvl(p_attended_start_date,hr_api.g_sot)

697: from per_establishment_attendances per
698: where per.party_id = p_party_id
699: and per.establishment_id = p_establishment_id
700: and per.attendance_id <> nvl(p_attendance_id,-1)
701: and (nvl(p_attended_start_date,hr_api.g_sot)
702: between per.attended_start_date
703: and nvl(per.attended_end_date,hr_api.g_eot)
704: or nvl(p_attended_end_date,hr_api.g_eot)
705: between per.attended_start_date

Line 703: and nvl(per.attended_end_date,hr_api.g_eot)

699: and per.establishment_id = p_establishment_id
700: and per.attendance_id <> nvl(p_attendance_id,-1)
701: and (nvl(p_attended_start_date,hr_api.g_sot)
702: between per.attended_start_date
703: and nvl(per.attended_end_date,hr_api.g_eot)
704: or nvl(p_attended_end_date,hr_api.g_eot)
705: between per.attended_start_date
706: and nvl(per.attended_end_date,hr_api.g_eot));
707: --

Line 704: or nvl(p_attended_end_date,hr_api.g_eot)

700: and per.attendance_id <> nvl(p_attendance_id,-1)
701: and (nvl(p_attended_start_date,hr_api.g_sot)
702: between per.attended_start_date
703: and nvl(per.attended_end_date,hr_api.g_eot)
704: or nvl(p_attended_end_date,hr_api.g_eot)
705: between per.attended_start_date
706: and nvl(per.attended_end_date,hr_api.g_eot));
707: --
708: -- Bug: 1664075 Starts here

Line 706: and nvl(per.attended_end_date,hr_api.g_eot));

702: between per.attended_start_date
703: and nvl(per.attended_end_date,hr_api.g_eot)
704: or nvl(p_attended_end_date,hr_api.g_eot)
705: between per.attended_start_date
706: and nvl(per.attended_end_date,hr_api.g_eot));
707: --
708: -- Bug: 1664075 Starts here
709: --
710: cursor c4 is

Line 716: and nvl(per.effective_end_date,hr_api.g_eot)

712: from per_all_people_f per
713: where per.person_id = p_person_id
714: and p_effective_date
715: between per.effective_start_date
716: and nvl(per.effective_end_date,hr_api.g_eot)
717: and date_of_birth is not null;
718: --
719: -- Bug: 1664075 Ends here.
720: --

Line 736: and (nvl(p_attended_start_date,hr_api.g_date)

732: hr_utility.set_location('Entering:chk_end'||p_attended_end_date,212);
733: hr_utility.set_location('Entering:chk_start'||per_esa_shd.g_old_rec.attended_end_date,121);
734: end if;
735: if (l_api_updating
736: and (nvl(p_attended_start_date,hr_api.g_date)
737: <> nvl(per_esa_shd.g_old_rec.attended_start_date,hr_api.g_date)
738: or nvl(p_attended_end_date,hr_api.g_date)
739: <> nvl(per_esa_shd.g_old_rec.attended_end_date,hr_api.g_date))
740: or not l_api_updating) then

Line 737: <> nvl(per_esa_shd.g_old_rec.attended_start_date,hr_api.g_date)

733: hr_utility.set_location('Entering:chk_start'||per_esa_shd.g_old_rec.attended_end_date,121);
734: end if;
735: if (l_api_updating
736: and (nvl(p_attended_start_date,hr_api.g_date)
737: <> nvl(per_esa_shd.g_old_rec.attended_start_date,hr_api.g_date)
738: or nvl(p_attended_end_date,hr_api.g_date)
739: <> nvl(per_esa_shd.g_old_rec.attended_end_date,hr_api.g_date))
740: or not l_api_updating) then
741: --

Line 738: or nvl(p_attended_end_date,hr_api.g_date)

734: end if;
735: if (l_api_updating
736: and (nvl(p_attended_start_date,hr_api.g_date)
737: <> nvl(per_esa_shd.g_old_rec.attended_start_date,hr_api.g_date)
738: or nvl(p_attended_end_date,hr_api.g_date)
739: <> nvl(per_esa_shd.g_old_rec.attended_end_date,hr_api.g_date))
740: or not l_api_updating) then
741: --
742: -- check if attended start date is null

Line 739: <> nvl(per_esa_shd.g_old_rec.attended_end_date,hr_api.g_date))

735: if (l_api_updating
736: and (nvl(p_attended_start_date,hr_api.g_date)
737: <> nvl(per_esa_shd.g_old_rec.attended_start_date,hr_api.g_date)
738: or nvl(p_attended_end_date,hr_api.g_date)
739: <> nvl(per_esa_shd.g_old_rec.attended_end_date,hr_api.g_date))
740: or not l_api_updating) then
741: --
742: -- check if attended start date is null
743: --

Line 758: elsif (p_attended_start_date is not null) and (l_dob > nvl(p_attended_start_date,hr_api.g_sot) ) then

754: /* if (l_dob is null) then
755: close c4;
756: hr_utility.set_message(800,'HR_289737_SCH_ATTND_NULL_DOB');
757: hr_utility.raise_error;
758: elsif (p_attended_start_date is not null) and (l_dob > nvl(p_attended_start_date,hr_api.g_sot) ) then
759: close c4;
760: hr_utility.set_message(800,'HR_289384_SCH_ATND_START_DATE');
761: hr_utility.raise_error;
762: end if;

Line 773: if (p_attended_start_date is not null) and (p_attended_end_date is null) and l_dob > nvl(p_attended_start_date,hr_api.g_sot) then

769: --
770: -- Validate date of birth, start date and end date for the schools and colleges attended
771: --
772: --
773: if (p_attended_start_date is not null) and (p_attended_end_date is null) and l_dob > nvl(p_attended_start_date,hr_api.g_sot) then
774: close c4;
775: hr_utility.set_message(800,'HR_289384_SCH_ATND_START_DATE');
776: hr_utility.raise_error;
777: elsif (p_attended_start_date is null) and (p_attended_end_date is not null) and (l_dob > nvl(p_attended_end_date,hr_api.g_sot)) then

Line 777: elsif (p_attended_start_date is null) and (p_attended_end_date is not null) and (l_dob > nvl(p_attended_end_date,hr_api.g_sot)) then

773: if (p_attended_start_date is not null) and (p_attended_end_date is null) and l_dob > nvl(p_attended_start_date,hr_api.g_sot) then
774: close c4;
775: hr_utility.set_message(800,'HR_289384_SCH_ATND_START_DATE');
776: hr_utility.raise_error;
777: elsif (p_attended_start_date is null) and (p_attended_end_date is not null) and (l_dob > nvl(p_attended_end_date,hr_api.g_sot)) then
778: close c4;
779: hr_utility.set_message(800,'PER_289498_ATT_END_DATE');
780: hr_utility.raise_error;
781: elsif (p_attended_start_date is not null) and (p_attended_end_date is not null) then

Line 819: if nvl(p_attended_start_date,hr_api.g_sot) > nvl(p_attended_end_date,nvl(p_attended_start_date,hr_api.g_sot))

815: --
816: -- check if the attended start date is later than the attended end date
817: --
818: hr_utility.set_location('Entering:'||l_proc, 20);
819: if nvl(p_attended_start_date,hr_api.g_sot) > nvl(p_attended_end_date,nvl(p_attended_start_date,hr_api.g_sot))
820: then
821: --
822: -- raise error
823: --

Line 959: and nvl(p_person_id,hr_api.g_number) <> per_esa_shd.g_old_rec.person_id

955: (p_attendance_id => p_attendance_id,
956: p_object_version_number => p_object_version_number);
957: --
958: if (l_api_updating
959: and nvl(p_person_id,hr_api.g_number) <> per_esa_shd.g_old_rec.person_id
960: or not l_api_updating) then
961: --
962: -- check if the person exists in the per_people_f table for the same
963: -- business group

Line 989: and nvl(per_esa_shd.g_old_rec.business_group_id,hr_api.g_number)

985: --
986: --UPDATE of Business_group_id is not allowed unless currently null(U)
987: --
988: if (l_api_updating
989: and nvl(per_esa_shd.g_old_rec.business_group_id,hr_api.g_number)
990: <> hr_api.g_number
991: and per_esa_shd.g_old_rec.business_group_id <> p_business_group_id ) then
992: --
993: hr_utility.set_message(800, 'HR_289947_INV_UPD_BG_ID');

Line 990: <> hr_api.g_number

986: --UPDATE of Business_group_id is not allowed unless currently null(U)
987: --
988: if (l_api_updating
989: and nvl(per_esa_shd.g_old_rec.business_group_id,hr_api.g_number)
990: <> hr_api.g_number
991: and per_esa_shd.g_old_rec.business_group_id <> p_business_group_id ) then
992: --
993: hr_utility.set_message(800, 'HR_289947_INV_UPD_BG_ID');
994: hr_utility.raise_error;

Line 1100: nvl(per_esa_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

1096: begin
1097: hr_utility.set_location('Entering:'||l_proc, 10);
1098: --
1099: if ((p_rec.attendance_id is not null) and (
1100: nvl(per_esa_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1101: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1102: nvl(per_esa_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1103: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1104: nvl(per_esa_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

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

1097: hr_utility.set_location('Entering:'||l_proc, 10);
1098: --
1099: if ((p_rec.attendance_id is not null) and (
1100: nvl(per_esa_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1101: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1102: nvl(per_esa_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1103: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1104: nvl(per_esa_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1105: nvl(p_rec.attribute2, hr_api.g_varchar2) or

Line 1102: nvl(per_esa_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

1098: --
1099: if ((p_rec.attendance_id is not null) and (
1100: nvl(per_esa_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1101: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1102: nvl(per_esa_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1103: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1104: nvl(per_esa_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1105: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1106: nvl(per_esa_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

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

1099: if ((p_rec.attendance_id is not null) and (
1100: nvl(per_esa_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1101: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1102: nvl(per_esa_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1103: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1104: nvl(per_esa_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1105: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1106: nvl(per_esa_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1107: nvl(p_rec.attribute3, hr_api.g_varchar2) or

Line 1104: nvl(per_esa_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

1100: nvl(per_esa_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1101: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1102: nvl(per_esa_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1103: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1104: nvl(per_esa_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1105: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1106: nvl(per_esa_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1107: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1108: nvl(per_esa_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

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

1101: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1102: nvl(per_esa_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1103: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1104: nvl(per_esa_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1105: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1106: nvl(per_esa_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1107: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1108: nvl(per_esa_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1109: nvl(p_rec.attribute4, hr_api.g_varchar2) or

Line 1106: nvl(per_esa_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

1102: nvl(per_esa_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1103: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1104: nvl(per_esa_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1105: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1106: nvl(per_esa_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1107: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1108: nvl(per_esa_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1109: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1110: nvl(per_esa_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

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

1103: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1104: nvl(per_esa_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1105: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1106: nvl(per_esa_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1107: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1108: nvl(per_esa_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1109: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1110: nvl(per_esa_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1111: nvl(p_rec.attribute5, hr_api.g_varchar2) or

Line 1108: nvl(per_esa_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

1104: nvl(per_esa_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1105: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1106: nvl(per_esa_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1107: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1108: nvl(per_esa_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1109: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1110: nvl(per_esa_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1111: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1112: nvl(per_esa_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

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

1105: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1106: nvl(per_esa_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1107: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1108: nvl(per_esa_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1109: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1110: nvl(per_esa_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1111: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1112: nvl(per_esa_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1113: nvl(p_rec.attribute6, hr_api.g_varchar2) or

Line 1110: nvl(per_esa_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

1106: nvl(per_esa_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1107: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1108: nvl(per_esa_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1109: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1110: nvl(per_esa_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1111: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1112: nvl(per_esa_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1113: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1114: nvl(per_esa_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

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

1107: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1108: nvl(per_esa_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1109: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1110: nvl(per_esa_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1111: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1112: nvl(per_esa_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1113: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1114: nvl(per_esa_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1115: nvl(p_rec.attribute7, hr_api.g_varchar2) or

Line 1112: nvl(per_esa_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

1108: nvl(per_esa_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1109: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1110: nvl(per_esa_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1111: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1112: nvl(per_esa_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1113: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1114: nvl(per_esa_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1115: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1116: nvl(per_esa_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

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

1109: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1110: nvl(per_esa_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1111: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1112: nvl(per_esa_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1113: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1114: nvl(per_esa_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1115: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1116: nvl(per_esa_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1117: nvl(p_rec.attribute8, hr_api.g_varchar2) or

Line 1114: nvl(per_esa_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

1110: nvl(per_esa_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1111: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1112: nvl(per_esa_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1113: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1114: nvl(per_esa_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1115: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1116: nvl(per_esa_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1117: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1118: nvl(per_esa_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

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

1111: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1112: nvl(per_esa_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1113: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1114: nvl(per_esa_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1115: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1116: nvl(per_esa_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1117: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1118: nvl(per_esa_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1119: nvl(p_rec.attribute9, hr_api.g_varchar2) or

Line 1116: nvl(per_esa_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

1112: nvl(per_esa_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1113: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1114: nvl(per_esa_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1115: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1116: nvl(per_esa_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1117: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1118: nvl(per_esa_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1119: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1120: nvl(per_esa_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

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

1113: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1114: nvl(per_esa_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1115: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1116: nvl(per_esa_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1117: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1118: nvl(per_esa_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1119: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1120: nvl(per_esa_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1121: nvl(p_rec.attribute10, hr_api.g_varchar2) or

Line 1118: nvl(per_esa_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

1114: nvl(per_esa_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1115: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1116: nvl(per_esa_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1117: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1118: nvl(per_esa_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1119: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1120: nvl(per_esa_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1121: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1122: nvl(per_esa_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

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

1115: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1116: nvl(per_esa_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1117: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1118: nvl(per_esa_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1119: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1120: nvl(per_esa_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1121: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1122: nvl(per_esa_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1123: nvl(p_rec.attribute11, hr_api.g_varchar2) or

Line 1120: nvl(per_esa_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

1116: nvl(per_esa_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1117: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1118: nvl(per_esa_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1119: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1120: nvl(per_esa_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1121: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1122: nvl(per_esa_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1123: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1124: nvl(per_esa_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

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

1117: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1118: nvl(per_esa_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1119: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1120: nvl(per_esa_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1121: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1122: nvl(per_esa_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1123: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1124: nvl(per_esa_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1125: nvl(p_rec.attribute12, hr_api.g_varchar2) or

Line 1122: nvl(per_esa_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

1118: nvl(per_esa_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1119: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1120: nvl(per_esa_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1121: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1122: nvl(per_esa_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1123: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1124: nvl(per_esa_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1125: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1126: nvl(per_esa_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

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

1119: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1120: nvl(per_esa_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1121: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1122: nvl(per_esa_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1123: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1124: nvl(per_esa_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1125: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1126: nvl(per_esa_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1127: nvl(p_rec.attribute13, hr_api.g_varchar2) or

Line 1124: nvl(per_esa_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

1120: nvl(per_esa_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1121: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1122: nvl(per_esa_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1123: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1124: nvl(per_esa_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1125: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1126: nvl(per_esa_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1127: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1128: nvl(per_esa_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

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

1121: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1122: nvl(per_esa_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1123: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1124: nvl(per_esa_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1125: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1126: nvl(per_esa_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1127: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1128: nvl(per_esa_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1129: nvl(p_rec.attribute14, hr_api.g_varchar2) or

Line 1126: nvl(per_esa_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

1122: nvl(per_esa_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1123: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1124: nvl(per_esa_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1125: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1126: nvl(per_esa_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1127: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1128: nvl(per_esa_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1129: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1130: nvl(per_esa_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

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

1123: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1124: nvl(per_esa_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1125: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1126: nvl(per_esa_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1127: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1128: nvl(per_esa_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1129: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1130: nvl(per_esa_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1131: nvl(p_rec.attribute15, hr_api.g_varchar2) or

Line 1128: nvl(per_esa_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

1124: nvl(per_esa_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1125: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1126: nvl(per_esa_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1127: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1128: nvl(per_esa_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1129: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1130: nvl(per_esa_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1131: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1132: nvl(per_esa_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

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

1125: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1126: nvl(per_esa_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1127: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1128: nvl(per_esa_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1129: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1130: nvl(per_esa_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1131: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1132: nvl(per_esa_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1133: nvl(p_rec.attribute16, hr_api.g_varchar2) or

Line 1130: nvl(per_esa_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

1126: nvl(per_esa_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1127: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1128: nvl(per_esa_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1129: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1130: nvl(per_esa_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1131: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1132: nvl(per_esa_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1133: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1134: nvl(per_esa_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

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

1127: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1128: nvl(per_esa_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1129: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1130: nvl(per_esa_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1131: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1132: nvl(per_esa_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1133: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1134: nvl(per_esa_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1135: nvl(p_rec.attribute17, hr_api.g_varchar2) or

Line 1132: nvl(per_esa_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

1128: nvl(per_esa_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1129: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1130: nvl(per_esa_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1131: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1132: nvl(per_esa_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1133: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1134: nvl(per_esa_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1135: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1136: nvl(per_esa_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

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

1129: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1130: nvl(per_esa_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1131: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1132: nvl(per_esa_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1133: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1134: nvl(per_esa_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1135: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1136: nvl(per_esa_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1137: nvl(p_rec.attribute18, hr_api.g_varchar2) or

Line 1134: nvl(per_esa_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

1130: nvl(per_esa_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1131: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1132: nvl(per_esa_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1133: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1134: nvl(per_esa_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1135: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1136: nvl(per_esa_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1137: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1138: nvl(per_esa_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

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

1131: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1132: nvl(per_esa_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1133: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1134: nvl(per_esa_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1135: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1136: nvl(per_esa_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1137: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1138: nvl(per_esa_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1139: nvl(p_rec.attribute19, hr_api.g_varchar2) or

Line 1136: nvl(per_esa_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

1132: nvl(per_esa_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1133: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1134: nvl(per_esa_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1135: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1136: nvl(per_esa_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1137: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1138: nvl(per_esa_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1139: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1140: nvl(per_esa_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

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

1133: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1134: nvl(per_esa_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1135: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1136: nvl(per_esa_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1137: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1138: nvl(per_esa_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1139: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1140: nvl(per_esa_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1141: nvl(p_rec.attribute20, hr_api.g_varchar2)))

Line 1138: nvl(per_esa_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

1134: nvl(per_esa_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1135: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1136: nvl(per_esa_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1137: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1138: nvl(per_esa_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1139: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1140: nvl(per_esa_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1141: nvl(p_rec.attribute20, hr_api.g_varchar2)))
1142: or

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

1135: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1136: nvl(per_esa_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1137: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1138: nvl(per_esa_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1139: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1140: nvl(per_esa_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1141: nvl(p_rec.attribute20, hr_api.g_varchar2)))
1142: or
1143: (p_rec.attendance_id is null) then

Line 1140: nvl(per_esa_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

1136: nvl(per_esa_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1137: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1138: nvl(per_esa_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1139: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1140: nvl(per_esa_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1141: nvl(p_rec.attribute20, hr_api.g_varchar2)))
1142: or
1143: (p_rec.attendance_id is null) then
1144: --

Line 1141: nvl(p_rec.attribute20, hr_api.g_varchar2)))

1137: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1138: nvl(per_esa_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1139: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1140: nvl(per_esa_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1141: nvl(p_rec.attribute20, hr_api.g_varchar2)))
1142: or
1143: (p_rec.attendance_id is null) then
1144: --
1145: -- Only execute the validation if absolutely necessary:

Line 1215: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

1211: -- only party_id is specified, validate business_group_id
1212: -- for HR/TCA merge
1213: --
1214: if p_rec.person_id is not null then
1215: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1216: end if;
1217: --
1218: -- Call all supporting business operations
1219: --

Line 1334: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

1330: -- if person_id is specified, validate business_group_id
1331: -- for HR/TCA merge
1332: --
1333: if p_rec.person_id is not null then
1334: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1335: end if;
1336: --
1337: -- Call all supporting business operations
1338: --

Line 1482: hr_api.mandatory_arg_error(p_api_name => l_proc,

1478: hr_utility.set_location('Entering:'|| l_proc, 10);
1479: --
1480: -- Ensure that all the mandatory parameter are not null
1481: --
1482: hr_api.mandatory_arg_error(p_api_name => l_proc,
1483: p_argument => 'attendance_id',
1484: p_argument_value => p_attendance_id);
1485: --
1486: open csr_no_bg;

Line 1497: if nvl(g_attendance_id, hr_api.g_number) = p_attendance_id then

1493: if l_no_business_group = 'Y' then
1494: return null;
1495: end if;
1496: --
1497: if nvl(g_attendance_id, hr_api.g_number) = p_attendance_id then
1498: --
1499: -- The legislation has already been found with a previous
1500: -- call to this function. Just return the value in the global
1501: -- variable.