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 PER_ESA_SHD

Line 52: l_api_updating := per_esa_shd.api_updating

48: Begin
49: --
50: hr_utility.set_location('Entering:'||l_proc, 5);
51: --
52: l_api_updating := per_esa_shd.api_updating
53: (p_attendance_id => p_attendance_id,
54: p_object_version_number => p_object_version_number);
55: --
56: if (l_api_updating

Line 58: <> per_esa_shd.g_old_rec.attendance_id) then

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: --
62: per_esa_shd.constraint_error('PER_ESTAB_ATTENDANCES_PK');

Line 62: per_esa_shd.constraint_error('PER_ESTAB_ATTENDANCES_PK');

58: <> per_esa_shd.g_old_rec.attendance_id) then
59: --
60: -- raise error as PK has changed
61: --
62: per_esa_shd.constraint_error('PER_ESTAB_ATTENDANCES_PK');
63: --
64: elsif not l_api_updating then
65: --
66: -- check if PK is null

Line 72: per_esa_shd.constraint_error('PER_ESTAB_ATTENDANCES_PK');

68: if p_attendance_id is not null then
69: --
70: -- raise error as PK is not null
71: --
72: per_esa_shd.constraint_error('PER_ESTAB_ATTENDANCES_PK');
73: --
74: end if;
75: --
76: end if;

Line 147: l_api_updating := per_esa_shd.api_updating

143: Begin
144: --
145: hr_utility.set_location('Entering:'||l_proc, 5);
146: --
147: l_api_updating := per_esa_shd.api_updating
148: (p_attendance_id => p_attendance_id,
149: p_object_version_number => p_object_version_number);
150: --
151: if (l_api_updating

Line 153: <> per_esa_shd.g_old_rec.person_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)
157: <> per_esa_shd.g_old_rec.attended_start_date

Line 155: <> per_esa_shd.g_old_rec.party_id

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: <> per_esa_shd.g_old_rec.attended_start_date
158: or nvl(p_establishment_id,hr_api.g_number)
159: <> per_esa_shd.g_old_rec.establishment_id

Line 157: <> per_esa_shd.g_old_rec.attended_start_date

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: <> per_esa_shd.g_old_rec.attended_start_date
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 159: <> per_esa_shd.g_old_rec.establishment_id

155: <> per_esa_shd.g_old_rec.party_id
156: or nvl(p_attended_start_date,hr_api.g_date)
157: <> per_esa_shd.g_old_rec.attended_start_date
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)

Line 161: <> per_esa_shd.g_old_rec.establishment

157: <> per_esa_shd.g_old_rec.attended_start_date
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: --

Line 163: <> per_esa_shd.g_old_rec.business_group_id)

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

Line 195: per_esa_shd.constraint_error('PER_ESTAB_ATTENDANCES_UK');

191: close c2;
192: --
193: -- raise error as record alreasy exists
194: --
195: per_esa_shd.constraint_error('PER_ESTAB_ATTENDANCES_UK');
196: --
197: end if;
198: --
199: close c2;

Line 218: per_esa_shd.constraint_error('PER_ESTAB_ATTENDANCES_UK');

214: close c1;
215: --
216: -- raise error as record alreasy exists
217: --
218: per_esa_shd.constraint_error('PER_ESTAB_ATTENDANCES_UK');
219: --
220: end if;
221: --
222: close c1;

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 233: and per_esa_shd.g_old_rec.person_id <> p_person_id

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');
237: hr_utility.raise_error;

Line 275: p_rec in out nocopy per_esa_shd.g_rec_type

271: -- Internal Table Handler Use Only.
272: --
273: --
274: Procedure chk_party_id(
275: p_rec in out nocopy per_esa_shd.g_rec_type
276: ,p_effective_date in date
277: )is
278: --
279: l_proc varchar2(72) := g_package||'chk_party_id';

Line 376: l_temp varchar2(4000) := per_esa_shd.g_old_rec.address;

372: --
373: l_proc varchar2(72) := g_package||'chk_address_constraints';
374: l_api_updating boolean;
375:
376: l_temp varchar2(4000) := per_esa_shd.g_old_rec.address;
377: --
378: Begin
379: --
380: hr_utility.set_location('Entering:'||l_proc, 5);

Line 382: l_api_updating := per_esa_shd.api_updating

378: Begin
379: --
380: hr_utility.set_location('Entering:'||l_proc, 5);
381: --
382: l_api_updating := per_esa_shd.api_updating
383: (p_attendance_id => p_attendance_id,
384: p_object_version_number => p_object_version_number);
385:
386: hr_utility.set_location(p_address,6);

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 411: <> per_esa_shd.g_old_rec.establishment_id

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);
415: hr_utility.set_location(p_address,15);

Line 477: l_api_updating := per_esa_shd.api_updating

473: Begin
474: --
475: hr_utility.set_location('Entering:'||l_proc, 5);
476: --
477: l_api_updating := per_esa_shd.api_updating
478: (p_attendance_id => p_attendance_id,
479: p_object_version_number => p_object_version_number);
480: --
481: if (l_api_updating

Line 483: <> per_esa_shd.g_old_rec.full_time

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

Line 552: l_api_updating := per_esa_shd.api_updating

548: Begin
549: --
550: hr_utility.set_location('Entering:'||l_proc, 5);
551: --
552: l_api_updating := per_esa_shd.api_updating
553: (p_attendance_id => p_attendance_id,
554: p_object_version_number => p_object_version_number);
555: --
556: if (l_api_updating

Line 582: <> per_esa_shd.g_old_rec.establishment_id)) then

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: --
586: open c1;

Line 596: per_esa_shd.constraint_error('PER_ESTAB_ATTENDANCES_FK1');

592: close c1;
593: --
594: -- raise error as establishment_id doesn't exist
595: --
596: per_esa_shd.constraint_error('PER_ESTAB_ATTENDANCES_FK1');
597: --
598: end if;
599: --
600: close c1;

Line 725: l_api_updating := per_esa_shd.api_updating

721: Begin
722: --
723: hr_utility.set_location('Entering:'||l_proc, 5);
724: --
725: l_api_updating := per_esa_shd.api_updating
726: (p_attendance_id => p_attendance_id,
727: p_object_version_number => p_object_version_number);
728: --
729: if l_api_updating then

Line 731: hr_utility.set_location('Entering:chk_start'||per_esa_shd.g_old_rec.attended_start_date,121);

727: p_object_version_number => p_object_version_number);
728: --
729: if l_api_updating then
730: hr_utility.set_location('Entering:chk_start'||p_attended_start_date,121);
731: hr_utility.set_location('Entering:chk_start'||per_esa_shd.g_old_rec.attended_start_date,121);
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

Line 733: hr_utility.set_location('Entering:chk_start'||per_esa_shd.g_old_rec.attended_end_date,121);

729: if l_api_updating then
730: hr_utility.set_location('Entering:chk_start'||p_attended_start_date,121);
731: hr_utility.set_location('Entering:chk_start'||per_esa_shd.g_old_rec.attended_start_date,121);
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)

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 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 954: l_api_updating := per_esa_shd.api_updating

950: Begin
951: --
952: hr_utility.set_location('Entering:'||l_proc, 5);
953: --
954: l_api_updating := per_esa_shd.api_updating
955: (p_attendance_id => p_attendance_id,
956: p_object_version_number => p_object_version_number);
957: --
958: if (l_api_updating

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 991: and per_esa_shd.g_old_rec.business_group_id <> p_business_group_id ) then

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

Line 1092: (p_rec in per_esa_shd.g_rec_type) is

1088: -- Access Status:
1089: -- Internal Row Handler Use Only.
1090: --
1091: procedure chk_df
1092: (p_rec in per_esa_shd.g_rec_type) is
1093: --
1094: l_proc varchar2(72) := g_package||'chk_df';
1095: --
1096: begin

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 1203: Procedure insert_validate(p_rec in out nocopy per_esa_shd.g_rec_type,

1199: end chk_df;
1200: -- ----------------------------------------------------------------------------
1201: -- |---------------------------< insert_validate >----------------------------|
1202: -- ----------------------------------------------------------------------------
1203: Procedure insert_validate(p_rec in out nocopy per_esa_shd.g_rec_type,
1204: p_effective_date in date) is
1205: --
1206: l_proc varchar2(72) := g_package||'insert_validate';
1207: --

Line 1321: Procedure update_validate(p_rec in per_esa_shd.g_rec_type,

1317: --
1318: -- ----------------------------------------------------------------------------
1319: -- |---------------------------< update_validate >----------------------------|
1320: -- ----------------------------------------------------------------------------
1321: Procedure update_validate(p_rec in per_esa_shd.g_rec_type,
1322: p_effective_date in date) is
1323: --
1324: l_proc varchar2(72) := g_package||'update_validate';
1325: --

Line 1429: Procedure delete_validate(p_rec in per_esa_shd.g_rec_type) is

1425: --
1426: -- ----------------------------------------------------------------------------
1427: -- |---------------------------< delete_validate >----------------------------|
1428: -- ----------------------------------------------------------------------------
1429: Procedure delete_validate(p_rec in per_esa_shd.g_rec_type) is
1430: --
1431: l_proc varchar2(72) := g_package||'delete_validate';
1432: --
1433: Begin