40: hr_utility.set_location('Entering:'|| l_proc, 10);
41: --
42: -- Ensure that all the mandatory parameters are not null
43: --
44: hr_api.mandatory_arg_error
45: (p_api_name => l_proc
46: ,p_argument => 'person_extra_info_id'
47: ,p_argument_value => p_person_extra_info_id);
48: --
45: (p_api_name => l_proc
46: ,p_argument => 'person_extra_info_id'
47: ,p_argument_value => p_person_extra_info_id);
48: --
49: if nvl(g_person_extra_info_id, hr_api.g_number) = p_person_extra_info_id then
50: --
51: -- The legislation code has already been found with a previous
52: -- call to this function. Just return the value in the global
53: -- variable.
135: end if;
136: --
137: hr_utility.set_location (l_proc, 30);
138: --
139: if nvl(p_rec.person_id,hr_api.g_number)
140: <> nvl(pe_pei_shd.g_old_rec.person_id,hr_api.g_number) then
141: l_argument := 'person_id';
142: raise l_error;
143: end if;
136: --
137: hr_utility.set_location (l_proc, 30);
138: --
139: if nvl(p_rec.person_id,hr_api.g_number)
140: <> nvl(pe_pei_shd.g_old_rec.person_id,hr_api.g_number) then
141: l_argument := 'person_id';
142: raise l_error;
143: end if;
144: --
141: l_argument := 'person_id';
142: raise l_error;
143: end if;
144: --
145: if nvl(p_rec.information_type,hr_api.g_varchar2)
146: <> nvl(pe_pei_shd.g_old_rec.information_type,hr_api.g_varchar2) then
147: l_argument := 'information_type';
148: raise l_error;
149: end if;
142: raise l_error;
143: end if;
144: --
145: if nvl(p_rec.information_type,hr_api.g_varchar2)
146: <> nvl(pe_pei_shd.g_old_rec.information_type,hr_api.g_varchar2) then
147: l_argument := 'information_type';
148: raise l_error;
149: end if;
150: --
151: hr_utility.set_location(' Leaving : '|| l_proc, 40);
152: --
153: exception
154: when l_error then
155: hr_api.argument_changed_error
156: (p_api_name => l_proc
157: ,p_argument => l_argument);
158: when others then
159: raise;
204: hr_utility.set_location('Entering:'||l_proc, 10);
205: --
206: -- Check mandatory parameters have been set
207: --
208: hr_api.mandatory_arg_error
209: (
210: p_api_name => l_proc,
211: p_argument => 'person_id',
212: p_argument_value => p_person_id
295: hr_utility.set_location('Entering:'||l_proc, 5);
296: --
297: -- Check mandatory parameters have been set
298: --
299: hr_api.mandatory_arg_error
300: (
301: p_api_name => l_proc,
302: p_argument => 'information_type',
303: p_argument_value => p_information_type
400: begin
401: hr_utility.set_location('Entering:'||l_proc, 10);
402: --
403: if ((p_rec.person_extra_info_id is not null) and (
404: nvl(pe_pei_shd.g_old_rec.pei_attribute_category, hr_api.g_varchar2) <>
405: nvl(p_rec.pei_attribute_category, hr_api.g_varchar2) or
406: nvl(pe_pei_shd.g_old_rec.pei_attribute1, hr_api.g_varchar2) <>
407: nvl(p_rec.pei_attribute1, hr_api.g_varchar2) or
408: nvl(pe_pei_shd.g_old_rec.pei_attribute2, hr_api.g_varchar2) <>
401: hr_utility.set_location('Entering:'||l_proc, 10);
402: --
403: if ((p_rec.person_extra_info_id is not null) and (
404: nvl(pe_pei_shd.g_old_rec.pei_attribute_category, hr_api.g_varchar2) <>
405: nvl(p_rec.pei_attribute_category, hr_api.g_varchar2) or
406: nvl(pe_pei_shd.g_old_rec.pei_attribute1, hr_api.g_varchar2) <>
407: nvl(p_rec.pei_attribute1, hr_api.g_varchar2) or
408: nvl(pe_pei_shd.g_old_rec.pei_attribute2, hr_api.g_varchar2) <>
409: nvl(p_rec.pei_attribute2, hr_api.g_varchar2) or
402: --
403: if ((p_rec.person_extra_info_id is not null) and (
404: nvl(pe_pei_shd.g_old_rec.pei_attribute_category, hr_api.g_varchar2) <>
405: nvl(p_rec.pei_attribute_category, hr_api.g_varchar2) or
406: nvl(pe_pei_shd.g_old_rec.pei_attribute1, hr_api.g_varchar2) <>
407: nvl(p_rec.pei_attribute1, hr_api.g_varchar2) or
408: nvl(pe_pei_shd.g_old_rec.pei_attribute2, hr_api.g_varchar2) <>
409: nvl(p_rec.pei_attribute2, hr_api.g_varchar2) or
410: nvl(pe_pei_shd.g_old_rec.pei_attribute3, hr_api.g_varchar2) <>
403: if ((p_rec.person_extra_info_id is not null) and (
404: nvl(pe_pei_shd.g_old_rec.pei_attribute_category, hr_api.g_varchar2) <>
405: nvl(p_rec.pei_attribute_category, hr_api.g_varchar2) or
406: nvl(pe_pei_shd.g_old_rec.pei_attribute1, hr_api.g_varchar2) <>
407: nvl(p_rec.pei_attribute1, hr_api.g_varchar2) or
408: nvl(pe_pei_shd.g_old_rec.pei_attribute2, hr_api.g_varchar2) <>
409: nvl(p_rec.pei_attribute2, hr_api.g_varchar2) or
410: nvl(pe_pei_shd.g_old_rec.pei_attribute3, hr_api.g_varchar2) <>
411: nvl(p_rec.pei_attribute3, hr_api.g_varchar2) or
404: nvl(pe_pei_shd.g_old_rec.pei_attribute_category, hr_api.g_varchar2) <>
405: nvl(p_rec.pei_attribute_category, hr_api.g_varchar2) or
406: nvl(pe_pei_shd.g_old_rec.pei_attribute1, hr_api.g_varchar2) <>
407: nvl(p_rec.pei_attribute1, hr_api.g_varchar2) or
408: nvl(pe_pei_shd.g_old_rec.pei_attribute2, hr_api.g_varchar2) <>
409: nvl(p_rec.pei_attribute2, hr_api.g_varchar2) or
410: nvl(pe_pei_shd.g_old_rec.pei_attribute3, hr_api.g_varchar2) <>
411: nvl(p_rec.pei_attribute3, hr_api.g_varchar2) or
412: nvl(pe_pei_shd.g_old_rec.pei_attribute4, hr_api.g_varchar2) <>
405: nvl(p_rec.pei_attribute_category, hr_api.g_varchar2) or
406: nvl(pe_pei_shd.g_old_rec.pei_attribute1, hr_api.g_varchar2) <>
407: nvl(p_rec.pei_attribute1, hr_api.g_varchar2) or
408: nvl(pe_pei_shd.g_old_rec.pei_attribute2, hr_api.g_varchar2) <>
409: nvl(p_rec.pei_attribute2, hr_api.g_varchar2) or
410: nvl(pe_pei_shd.g_old_rec.pei_attribute3, hr_api.g_varchar2) <>
411: nvl(p_rec.pei_attribute3, hr_api.g_varchar2) or
412: nvl(pe_pei_shd.g_old_rec.pei_attribute4, hr_api.g_varchar2) <>
413: nvl(p_rec.pei_attribute4, hr_api.g_varchar2) or
406: nvl(pe_pei_shd.g_old_rec.pei_attribute1, hr_api.g_varchar2) <>
407: nvl(p_rec.pei_attribute1, hr_api.g_varchar2) or
408: nvl(pe_pei_shd.g_old_rec.pei_attribute2, hr_api.g_varchar2) <>
409: nvl(p_rec.pei_attribute2, hr_api.g_varchar2) or
410: nvl(pe_pei_shd.g_old_rec.pei_attribute3, hr_api.g_varchar2) <>
411: nvl(p_rec.pei_attribute3, hr_api.g_varchar2) or
412: nvl(pe_pei_shd.g_old_rec.pei_attribute4, hr_api.g_varchar2) <>
413: nvl(p_rec.pei_attribute4, hr_api.g_varchar2) or
414: nvl(pe_pei_shd.g_old_rec.pei_attribute5, hr_api.g_varchar2) <>
407: nvl(p_rec.pei_attribute1, hr_api.g_varchar2) or
408: nvl(pe_pei_shd.g_old_rec.pei_attribute2, hr_api.g_varchar2) <>
409: nvl(p_rec.pei_attribute2, hr_api.g_varchar2) or
410: nvl(pe_pei_shd.g_old_rec.pei_attribute3, hr_api.g_varchar2) <>
411: nvl(p_rec.pei_attribute3, hr_api.g_varchar2) or
412: nvl(pe_pei_shd.g_old_rec.pei_attribute4, hr_api.g_varchar2) <>
413: nvl(p_rec.pei_attribute4, hr_api.g_varchar2) or
414: nvl(pe_pei_shd.g_old_rec.pei_attribute5, hr_api.g_varchar2) <>
415: nvl(p_rec.pei_attribute5, hr_api.g_varchar2) or
408: nvl(pe_pei_shd.g_old_rec.pei_attribute2, hr_api.g_varchar2) <>
409: nvl(p_rec.pei_attribute2, hr_api.g_varchar2) or
410: nvl(pe_pei_shd.g_old_rec.pei_attribute3, hr_api.g_varchar2) <>
411: nvl(p_rec.pei_attribute3, hr_api.g_varchar2) or
412: nvl(pe_pei_shd.g_old_rec.pei_attribute4, hr_api.g_varchar2) <>
413: nvl(p_rec.pei_attribute4, hr_api.g_varchar2) or
414: nvl(pe_pei_shd.g_old_rec.pei_attribute5, hr_api.g_varchar2) <>
415: nvl(p_rec.pei_attribute5, hr_api.g_varchar2) or
416: nvl(pe_pei_shd.g_old_rec.pei_attribute6, hr_api.g_varchar2) <>
409: nvl(p_rec.pei_attribute2, hr_api.g_varchar2) or
410: nvl(pe_pei_shd.g_old_rec.pei_attribute3, hr_api.g_varchar2) <>
411: nvl(p_rec.pei_attribute3, hr_api.g_varchar2) or
412: nvl(pe_pei_shd.g_old_rec.pei_attribute4, hr_api.g_varchar2) <>
413: nvl(p_rec.pei_attribute4, hr_api.g_varchar2) or
414: nvl(pe_pei_shd.g_old_rec.pei_attribute5, hr_api.g_varchar2) <>
415: nvl(p_rec.pei_attribute5, hr_api.g_varchar2) or
416: nvl(pe_pei_shd.g_old_rec.pei_attribute6, hr_api.g_varchar2) <>
417: nvl(p_rec.pei_attribute6, hr_api.g_varchar2) or
410: nvl(pe_pei_shd.g_old_rec.pei_attribute3, hr_api.g_varchar2) <>
411: nvl(p_rec.pei_attribute3, hr_api.g_varchar2) or
412: nvl(pe_pei_shd.g_old_rec.pei_attribute4, hr_api.g_varchar2) <>
413: nvl(p_rec.pei_attribute4, hr_api.g_varchar2) or
414: nvl(pe_pei_shd.g_old_rec.pei_attribute5, hr_api.g_varchar2) <>
415: nvl(p_rec.pei_attribute5, hr_api.g_varchar2) or
416: nvl(pe_pei_shd.g_old_rec.pei_attribute6, hr_api.g_varchar2) <>
417: nvl(p_rec.pei_attribute6, hr_api.g_varchar2) or
418: nvl(pe_pei_shd.g_old_rec.pei_attribute7, hr_api.g_varchar2) <>
411: nvl(p_rec.pei_attribute3, hr_api.g_varchar2) or
412: nvl(pe_pei_shd.g_old_rec.pei_attribute4, hr_api.g_varchar2) <>
413: nvl(p_rec.pei_attribute4, hr_api.g_varchar2) or
414: nvl(pe_pei_shd.g_old_rec.pei_attribute5, hr_api.g_varchar2) <>
415: nvl(p_rec.pei_attribute5, hr_api.g_varchar2) or
416: nvl(pe_pei_shd.g_old_rec.pei_attribute6, hr_api.g_varchar2) <>
417: nvl(p_rec.pei_attribute6, hr_api.g_varchar2) or
418: nvl(pe_pei_shd.g_old_rec.pei_attribute7, hr_api.g_varchar2) <>
419: nvl(p_rec.pei_attribute7, hr_api.g_varchar2) or
412: nvl(pe_pei_shd.g_old_rec.pei_attribute4, hr_api.g_varchar2) <>
413: nvl(p_rec.pei_attribute4, hr_api.g_varchar2) or
414: nvl(pe_pei_shd.g_old_rec.pei_attribute5, hr_api.g_varchar2) <>
415: nvl(p_rec.pei_attribute5, hr_api.g_varchar2) or
416: nvl(pe_pei_shd.g_old_rec.pei_attribute6, hr_api.g_varchar2) <>
417: nvl(p_rec.pei_attribute6, hr_api.g_varchar2) or
418: nvl(pe_pei_shd.g_old_rec.pei_attribute7, hr_api.g_varchar2) <>
419: nvl(p_rec.pei_attribute7, hr_api.g_varchar2) or
420: nvl(pe_pei_shd.g_old_rec.pei_attribute8, hr_api.g_varchar2) <>
413: nvl(p_rec.pei_attribute4, hr_api.g_varchar2) or
414: nvl(pe_pei_shd.g_old_rec.pei_attribute5, hr_api.g_varchar2) <>
415: nvl(p_rec.pei_attribute5, hr_api.g_varchar2) or
416: nvl(pe_pei_shd.g_old_rec.pei_attribute6, hr_api.g_varchar2) <>
417: nvl(p_rec.pei_attribute6, hr_api.g_varchar2) or
418: nvl(pe_pei_shd.g_old_rec.pei_attribute7, hr_api.g_varchar2) <>
419: nvl(p_rec.pei_attribute7, hr_api.g_varchar2) or
420: nvl(pe_pei_shd.g_old_rec.pei_attribute8, hr_api.g_varchar2) <>
421: nvl(p_rec.pei_attribute8, hr_api.g_varchar2) or
414: nvl(pe_pei_shd.g_old_rec.pei_attribute5, hr_api.g_varchar2) <>
415: nvl(p_rec.pei_attribute5, hr_api.g_varchar2) or
416: nvl(pe_pei_shd.g_old_rec.pei_attribute6, hr_api.g_varchar2) <>
417: nvl(p_rec.pei_attribute6, hr_api.g_varchar2) or
418: nvl(pe_pei_shd.g_old_rec.pei_attribute7, hr_api.g_varchar2) <>
419: nvl(p_rec.pei_attribute7, hr_api.g_varchar2) or
420: nvl(pe_pei_shd.g_old_rec.pei_attribute8, hr_api.g_varchar2) <>
421: nvl(p_rec.pei_attribute8, hr_api.g_varchar2) or
422: nvl(pe_pei_shd.g_old_rec.pei_attribute9, hr_api.g_varchar2) <>
415: nvl(p_rec.pei_attribute5, hr_api.g_varchar2) or
416: nvl(pe_pei_shd.g_old_rec.pei_attribute6, hr_api.g_varchar2) <>
417: nvl(p_rec.pei_attribute6, hr_api.g_varchar2) or
418: nvl(pe_pei_shd.g_old_rec.pei_attribute7, hr_api.g_varchar2) <>
419: nvl(p_rec.pei_attribute7, hr_api.g_varchar2) or
420: nvl(pe_pei_shd.g_old_rec.pei_attribute8, hr_api.g_varchar2) <>
421: nvl(p_rec.pei_attribute8, hr_api.g_varchar2) or
422: nvl(pe_pei_shd.g_old_rec.pei_attribute9, hr_api.g_varchar2) <>
423: nvl(p_rec.pei_attribute9, hr_api.g_varchar2) or
416: nvl(pe_pei_shd.g_old_rec.pei_attribute6, hr_api.g_varchar2) <>
417: nvl(p_rec.pei_attribute6, hr_api.g_varchar2) or
418: nvl(pe_pei_shd.g_old_rec.pei_attribute7, hr_api.g_varchar2) <>
419: nvl(p_rec.pei_attribute7, hr_api.g_varchar2) or
420: nvl(pe_pei_shd.g_old_rec.pei_attribute8, hr_api.g_varchar2) <>
421: nvl(p_rec.pei_attribute8, hr_api.g_varchar2) or
422: nvl(pe_pei_shd.g_old_rec.pei_attribute9, hr_api.g_varchar2) <>
423: nvl(p_rec.pei_attribute9, hr_api.g_varchar2) or
424: nvl(pe_pei_shd.g_old_rec.pei_attribute10, hr_api.g_varchar2) <>
417: nvl(p_rec.pei_attribute6, hr_api.g_varchar2) or
418: nvl(pe_pei_shd.g_old_rec.pei_attribute7, hr_api.g_varchar2) <>
419: nvl(p_rec.pei_attribute7, hr_api.g_varchar2) or
420: nvl(pe_pei_shd.g_old_rec.pei_attribute8, hr_api.g_varchar2) <>
421: nvl(p_rec.pei_attribute8, hr_api.g_varchar2) or
422: nvl(pe_pei_shd.g_old_rec.pei_attribute9, hr_api.g_varchar2) <>
423: nvl(p_rec.pei_attribute9, hr_api.g_varchar2) or
424: nvl(pe_pei_shd.g_old_rec.pei_attribute10, hr_api.g_varchar2) <>
425: nvl(p_rec.pei_attribute10, hr_api.g_varchar2) or
418: nvl(pe_pei_shd.g_old_rec.pei_attribute7, hr_api.g_varchar2) <>
419: nvl(p_rec.pei_attribute7, hr_api.g_varchar2) or
420: nvl(pe_pei_shd.g_old_rec.pei_attribute8, hr_api.g_varchar2) <>
421: nvl(p_rec.pei_attribute8, hr_api.g_varchar2) or
422: nvl(pe_pei_shd.g_old_rec.pei_attribute9, hr_api.g_varchar2) <>
423: nvl(p_rec.pei_attribute9, hr_api.g_varchar2) or
424: nvl(pe_pei_shd.g_old_rec.pei_attribute10, hr_api.g_varchar2) <>
425: nvl(p_rec.pei_attribute10, hr_api.g_varchar2) or
426: nvl(pe_pei_shd.g_old_rec.pei_attribute11, hr_api.g_varchar2) <>
419: nvl(p_rec.pei_attribute7, hr_api.g_varchar2) or
420: nvl(pe_pei_shd.g_old_rec.pei_attribute8, hr_api.g_varchar2) <>
421: nvl(p_rec.pei_attribute8, hr_api.g_varchar2) or
422: nvl(pe_pei_shd.g_old_rec.pei_attribute9, hr_api.g_varchar2) <>
423: nvl(p_rec.pei_attribute9, hr_api.g_varchar2) or
424: nvl(pe_pei_shd.g_old_rec.pei_attribute10, hr_api.g_varchar2) <>
425: nvl(p_rec.pei_attribute10, hr_api.g_varchar2) or
426: nvl(pe_pei_shd.g_old_rec.pei_attribute11, hr_api.g_varchar2) <>
427: nvl(p_rec.pei_attribute11, hr_api.g_varchar2) or
420: nvl(pe_pei_shd.g_old_rec.pei_attribute8, hr_api.g_varchar2) <>
421: nvl(p_rec.pei_attribute8, hr_api.g_varchar2) or
422: nvl(pe_pei_shd.g_old_rec.pei_attribute9, hr_api.g_varchar2) <>
423: nvl(p_rec.pei_attribute9, hr_api.g_varchar2) or
424: nvl(pe_pei_shd.g_old_rec.pei_attribute10, hr_api.g_varchar2) <>
425: nvl(p_rec.pei_attribute10, hr_api.g_varchar2) or
426: nvl(pe_pei_shd.g_old_rec.pei_attribute11, hr_api.g_varchar2) <>
427: nvl(p_rec.pei_attribute11, hr_api.g_varchar2) or
428: nvl(pe_pei_shd.g_old_rec.pei_attribute12, hr_api.g_varchar2) <>
421: nvl(p_rec.pei_attribute8, hr_api.g_varchar2) or
422: nvl(pe_pei_shd.g_old_rec.pei_attribute9, hr_api.g_varchar2) <>
423: nvl(p_rec.pei_attribute9, hr_api.g_varchar2) or
424: nvl(pe_pei_shd.g_old_rec.pei_attribute10, hr_api.g_varchar2) <>
425: nvl(p_rec.pei_attribute10, hr_api.g_varchar2) or
426: nvl(pe_pei_shd.g_old_rec.pei_attribute11, hr_api.g_varchar2) <>
427: nvl(p_rec.pei_attribute11, hr_api.g_varchar2) or
428: nvl(pe_pei_shd.g_old_rec.pei_attribute12, hr_api.g_varchar2) <>
429: nvl(p_rec.pei_attribute12, hr_api.g_varchar2) or
422: nvl(pe_pei_shd.g_old_rec.pei_attribute9, hr_api.g_varchar2) <>
423: nvl(p_rec.pei_attribute9, hr_api.g_varchar2) or
424: nvl(pe_pei_shd.g_old_rec.pei_attribute10, hr_api.g_varchar2) <>
425: nvl(p_rec.pei_attribute10, hr_api.g_varchar2) or
426: nvl(pe_pei_shd.g_old_rec.pei_attribute11, hr_api.g_varchar2) <>
427: nvl(p_rec.pei_attribute11, hr_api.g_varchar2) or
428: nvl(pe_pei_shd.g_old_rec.pei_attribute12, hr_api.g_varchar2) <>
429: nvl(p_rec.pei_attribute12, hr_api.g_varchar2) or
430: nvl(pe_pei_shd.g_old_rec.pei_attribute13, hr_api.g_varchar2) <>
423: nvl(p_rec.pei_attribute9, hr_api.g_varchar2) or
424: nvl(pe_pei_shd.g_old_rec.pei_attribute10, hr_api.g_varchar2) <>
425: nvl(p_rec.pei_attribute10, hr_api.g_varchar2) or
426: nvl(pe_pei_shd.g_old_rec.pei_attribute11, hr_api.g_varchar2) <>
427: nvl(p_rec.pei_attribute11, hr_api.g_varchar2) or
428: nvl(pe_pei_shd.g_old_rec.pei_attribute12, hr_api.g_varchar2) <>
429: nvl(p_rec.pei_attribute12, hr_api.g_varchar2) or
430: nvl(pe_pei_shd.g_old_rec.pei_attribute13, hr_api.g_varchar2) <>
431: nvl(p_rec.pei_attribute13, hr_api.g_varchar2) or
424: nvl(pe_pei_shd.g_old_rec.pei_attribute10, hr_api.g_varchar2) <>
425: nvl(p_rec.pei_attribute10, hr_api.g_varchar2) or
426: nvl(pe_pei_shd.g_old_rec.pei_attribute11, hr_api.g_varchar2) <>
427: nvl(p_rec.pei_attribute11, hr_api.g_varchar2) or
428: nvl(pe_pei_shd.g_old_rec.pei_attribute12, hr_api.g_varchar2) <>
429: nvl(p_rec.pei_attribute12, hr_api.g_varchar2) or
430: nvl(pe_pei_shd.g_old_rec.pei_attribute13, hr_api.g_varchar2) <>
431: nvl(p_rec.pei_attribute13, hr_api.g_varchar2) or
432: nvl(pe_pei_shd.g_old_rec.pei_attribute14, hr_api.g_varchar2) <>
425: nvl(p_rec.pei_attribute10, hr_api.g_varchar2) or
426: nvl(pe_pei_shd.g_old_rec.pei_attribute11, hr_api.g_varchar2) <>
427: nvl(p_rec.pei_attribute11, hr_api.g_varchar2) or
428: nvl(pe_pei_shd.g_old_rec.pei_attribute12, hr_api.g_varchar2) <>
429: nvl(p_rec.pei_attribute12, hr_api.g_varchar2) or
430: nvl(pe_pei_shd.g_old_rec.pei_attribute13, hr_api.g_varchar2) <>
431: nvl(p_rec.pei_attribute13, hr_api.g_varchar2) or
432: nvl(pe_pei_shd.g_old_rec.pei_attribute14, hr_api.g_varchar2) <>
433: nvl(p_rec.pei_attribute14, hr_api.g_varchar2) or
426: nvl(pe_pei_shd.g_old_rec.pei_attribute11, hr_api.g_varchar2) <>
427: nvl(p_rec.pei_attribute11, hr_api.g_varchar2) or
428: nvl(pe_pei_shd.g_old_rec.pei_attribute12, hr_api.g_varchar2) <>
429: nvl(p_rec.pei_attribute12, hr_api.g_varchar2) or
430: nvl(pe_pei_shd.g_old_rec.pei_attribute13, hr_api.g_varchar2) <>
431: nvl(p_rec.pei_attribute13, hr_api.g_varchar2) or
432: nvl(pe_pei_shd.g_old_rec.pei_attribute14, hr_api.g_varchar2) <>
433: nvl(p_rec.pei_attribute14, hr_api.g_varchar2) or
434: nvl(pe_pei_shd.g_old_rec.pei_attribute15, hr_api.g_varchar2) <>
427: nvl(p_rec.pei_attribute11, hr_api.g_varchar2) or
428: nvl(pe_pei_shd.g_old_rec.pei_attribute12, hr_api.g_varchar2) <>
429: nvl(p_rec.pei_attribute12, hr_api.g_varchar2) or
430: nvl(pe_pei_shd.g_old_rec.pei_attribute13, hr_api.g_varchar2) <>
431: nvl(p_rec.pei_attribute13, hr_api.g_varchar2) or
432: nvl(pe_pei_shd.g_old_rec.pei_attribute14, hr_api.g_varchar2) <>
433: nvl(p_rec.pei_attribute14, hr_api.g_varchar2) or
434: nvl(pe_pei_shd.g_old_rec.pei_attribute15, hr_api.g_varchar2) <>
435: nvl(p_rec.pei_attribute15, hr_api.g_varchar2) or
428: nvl(pe_pei_shd.g_old_rec.pei_attribute12, hr_api.g_varchar2) <>
429: nvl(p_rec.pei_attribute12, hr_api.g_varchar2) or
430: nvl(pe_pei_shd.g_old_rec.pei_attribute13, hr_api.g_varchar2) <>
431: nvl(p_rec.pei_attribute13, hr_api.g_varchar2) or
432: nvl(pe_pei_shd.g_old_rec.pei_attribute14, hr_api.g_varchar2) <>
433: nvl(p_rec.pei_attribute14, hr_api.g_varchar2) or
434: nvl(pe_pei_shd.g_old_rec.pei_attribute15, hr_api.g_varchar2) <>
435: nvl(p_rec.pei_attribute15, hr_api.g_varchar2) or
436: nvl(pe_pei_shd.g_old_rec.pei_attribute16, hr_api.g_varchar2) <>
429: nvl(p_rec.pei_attribute12, hr_api.g_varchar2) or
430: nvl(pe_pei_shd.g_old_rec.pei_attribute13, hr_api.g_varchar2) <>
431: nvl(p_rec.pei_attribute13, hr_api.g_varchar2) or
432: nvl(pe_pei_shd.g_old_rec.pei_attribute14, hr_api.g_varchar2) <>
433: nvl(p_rec.pei_attribute14, hr_api.g_varchar2) or
434: nvl(pe_pei_shd.g_old_rec.pei_attribute15, hr_api.g_varchar2) <>
435: nvl(p_rec.pei_attribute15, hr_api.g_varchar2) or
436: nvl(pe_pei_shd.g_old_rec.pei_attribute16, hr_api.g_varchar2) <>
437: nvl(p_rec.pei_attribute16, hr_api.g_varchar2) or
430: nvl(pe_pei_shd.g_old_rec.pei_attribute13, hr_api.g_varchar2) <>
431: nvl(p_rec.pei_attribute13, hr_api.g_varchar2) or
432: nvl(pe_pei_shd.g_old_rec.pei_attribute14, hr_api.g_varchar2) <>
433: nvl(p_rec.pei_attribute14, hr_api.g_varchar2) or
434: nvl(pe_pei_shd.g_old_rec.pei_attribute15, hr_api.g_varchar2) <>
435: nvl(p_rec.pei_attribute15, hr_api.g_varchar2) or
436: nvl(pe_pei_shd.g_old_rec.pei_attribute16, hr_api.g_varchar2) <>
437: nvl(p_rec.pei_attribute16, hr_api.g_varchar2) or
438: nvl(pe_pei_shd.g_old_rec.pei_attribute17, hr_api.g_varchar2) <>
431: nvl(p_rec.pei_attribute13, hr_api.g_varchar2) or
432: nvl(pe_pei_shd.g_old_rec.pei_attribute14, hr_api.g_varchar2) <>
433: nvl(p_rec.pei_attribute14, hr_api.g_varchar2) or
434: nvl(pe_pei_shd.g_old_rec.pei_attribute15, hr_api.g_varchar2) <>
435: nvl(p_rec.pei_attribute15, hr_api.g_varchar2) or
436: nvl(pe_pei_shd.g_old_rec.pei_attribute16, hr_api.g_varchar2) <>
437: nvl(p_rec.pei_attribute16, hr_api.g_varchar2) or
438: nvl(pe_pei_shd.g_old_rec.pei_attribute17, hr_api.g_varchar2) <>
439: nvl(p_rec.pei_attribute17, hr_api.g_varchar2) or
432: nvl(pe_pei_shd.g_old_rec.pei_attribute14, hr_api.g_varchar2) <>
433: nvl(p_rec.pei_attribute14, hr_api.g_varchar2) or
434: nvl(pe_pei_shd.g_old_rec.pei_attribute15, hr_api.g_varchar2) <>
435: nvl(p_rec.pei_attribute15, hr_api.g_varchar2) or
436: nvl(pe_pei_shd.g_old_rec.pei_attribute16, hr_api.g_varchar2) <>
437: nvl(p_rec.pei_attribute16, hr_api.g_varchar2) or
438: nvl(pe_pei_shd.g_old_rec.pei_attribute17, hr_api.g_varchar2) <>
439: nvl(p_rec.pei_attribute17, hr_api.g_varchar2) or
440: nvl(pe_pei_shd.g_old_rec.pei_attribute18, hr_api.g_varchar2) <>
433: nvl(p_rec.pei_attribute14, hr_api.g_varchar2) or
434: nvl(pe_pei_shd.g_old_rec.pei_attribute15, hr_api.g_varchar2) <>
435: nvl(p_rec.pei_attribute15, hr_api.g_varchar2) or
436: nvl(pe_pei_shd.g_old_rec.pei_attribute16, hr_api.g_varchar2) <>
437: nvl(p_rec.pei_attribute16, hr_api.g_varchar2) or
438: nvl(pe_pei_shd.g_old_rec.pei_attribute17, hr_api.g_varchar2) <>
439: nvl(p_rec.pei_attribute17, hr_api.g_varchar2) or
440: nvl(pe_pei_shd.g_old_rec.pei_attribute18, hr_api.g_varchar2) <>
441: nvl(p_rec.pei_attribute18, hr_api.g_varchar2) or
434: nvl(pe_pei_shd.g_old_rec.pei_attribute15, hr_api.g_varchar2) <>
435: nvl(p_rec.pei_attribute15, hr_api.g_varchar2) or
436: nvl(pe_pei_shd.g_old_rec.pei_attribute16, hr_api.g_varchar2) <>
437: nvl(p_rec.pei_attribute16, hr_api.g_varchar2) or
438: nvl(pe_pei_shd.g_old_rec.pei_attribute17, hr_api.g_varchar2) <>
439: nvl(p_rec.pei_attribute17, hr_api.g_varchar2) or
440: nvl(pe_pei_shd.g_old_rec.pei_attribute18, hr_api.g_varchar2) <>
441: nvl(p_rec.pei_attribute18, hr_api.g_varchar2) or
442: nvl(pe_pei_shd.g_old_rec.pei_attribute19, hr_api.g_varchar2) <>
435: nvl(p_rec.pei_attribute15, hr_api.g_varchar2) or
436: nvl(pe_pei_shd.g_old_rec.pei_attribute16, hr_api.g_varchar2) <>
437: nvl(p_rec.pei_attribute16, hr_api.g_varchar2) or
438: nvl(pe_pei_shd.g_old_rec.pei_attribute17, hr_api.g_varchar2) <>
439: nvl(p_rec.pei_attribute17, hr_api.g_varchar2) or
440: nvl(pe_pei_shd.g_old_rec.pei_attribute18, hr_api.g_varchar2) <>
441: nvl(p_rec.pei_attribute18, hr_api.g_varchar2) or
442: nvl(pe_pei_shd.g_old_rec.pei_attribute19, hr_api.g_varchar2) <>
443: nvl(p_rec.pei_attribute19, hr_api.g_varchar2) or
436: nvl(pe_pei_shd.g_old_rec.pei_attribute16, hr_api.g_varchar2) <>
437: nvl(p_rec.pei_attribute16, hr_api.g_varchar2) or
438: nvl(pe_pei_shd.g_old_rec.pei_attribute17, hr_api.g_varchar2) <>
439: nvl(p_rec.pei_attribute17, hr_api.g_varchar2) or
440: nvl(pe_pei_shd.g_old_rec.pei_attribute18, hr_api.g_varchar2) <>
441: nvl(p_rec.pei_attribute18, hr_api.g_varchar2) or
442: nvl(pe_pei_shd.g_old_rec.pei_attribute19, hr_api.g_varchar2) <>
443: nvl(p_rec.pei_attribute19, hr_api.g_varchar2) or
444: nvl(pe_pei_shd.g_old_rec.pei_attribute20, hr_api.g_varchar2) <>
437: nvl(p_rec.pei_attribute16, hr_api.g_varchar2) or
438: nvl(pe_pei_shd.g_old_rec.pei_attribute17, hr_api.g_varchar2) <>
439: nvl(p_rec.pei_attribute17, hr_api.g_varchar2) or
440: nvl(pe_pei_shd.g_old_rec.pei_attribute18, hr_api.g_varchar2) <>
441: nvl(p_rec.pei_attribute18, hr_api.g_varchar2) or
442: nvl(pe_pei_shd.g_old_rec.pei_attribute19, hr_api.g_varchar2) <>
443: nvl(p_rec.pei_attribute19, hr_api.g_varchar2) or
444: nvl(pe_pei_shd.g_old_rec.pei_attribute20, hr_api.g_varchar2) <>
445: nvl(p_rec.pei_attribute20, hr_api.g_varchar2)))
438: nvl(pe_pei_shd.g_old_rec.pei_attribute17, hr_api.g_varchar2) <>
439: nvl(p_rec.pei_attribute17, hr_api.g_varchar2) or
440: nvl(pe_pei_shd.g_old_rec.pei_attribute18, hr_api.g_varchar2) <>
441: nvl(p_rec.pei_attribute18, hr_api.g_varchar2) or
442: nvl(pe_pei_shd.g_old_rec.pei_attribute19, hr_api.g_varchar2) <>
443: nvl(p_rec.pei_attribute19, hr_api.g_varchar2) or
444: nvl(pe_pei_shd.g_old_rec.pei_attribute20, hr_api.g_varchar2) <>
445: nvl(p_rec.pei_attribute20, hr_api.g_varchar2)))
446: or
439: nvl(p_rec.pei_attribute17, hr_api.g_varchar2) or
440: nvl(pe_pei_shd.g_old_rec.pei_attribute18, hr_api.g_varchar2) <>
441: nvl(p_rec.pei_attribute18, hr_api.g_varchar2) or
442: nvl(pe_pei_shd.g_old_rec.pei_attribute19, hr_api.g_varchar2) <>
443: nvl(p_rec.pei_attribute19, hr_api.g_varchar2) or
444: nvl(pe_pei_shd.g_old_rec.pei_attribute20, hr_api.g_varchar2) <>
445: nvl(p_rec.pei_attribute20, hr_api.g_varchar2)))
446: or
447: (p_rec.person_extra_info_id is null) then
440: nvl(pe_pei_shd.g_old_rec.pei_attribute18, hr_api.g_varchar2) <>
441: nvl(p_rec.pei_attribute18, hr_api.g_varchar2) or
442: nvl(pe_pei_shd.g_old_rec.pei_attribute19, hr_api.g_varchar2) <>
443: nvl(p_rec.pei_attribute19, hr_api.g_varchar2) or
444: nvl(pe_pei_shd.g_old_rec.pei_attribute20, hr_api.g_varchar2) <>
445: nvl(p_rec.pei_attribute20, hr_api.g_varchar2)))
446: or
447: (p_rec.person_extra_info_id is null) then
448: --
441: nvl(p_rec.pei_attribute18, hr_api.g_varchar2) or
442: nvl(pe_pei_shd.g_old_rec.pei_attribute19, hr_api.g_varchar2) <>
443: nvl(p_rec.pei_attribute19, hr_api.g_varchar2) or
444: nvl(pe_pei_shd.g_old_rec.pei_attribute20, hr_api.g_varchar2) <>
445: nvl(p_rec.pei_attribute20, hr_api.g_varchar2)))
446: or
447: (p_rec.person_extra_info_id is null) then
448: --
449: -- Only execute the validation if absolutely necessary:
545: --
546: if (p_rec.person_extra_info_id is null)
547: or ((p_rec.person_extra_info_id is not null)
548: and
549: nvl(pe_pei_shd.g_old_rec.pei_attribute_category, hr_api.g_varchar2) <>
550: nvl(p_rec.pei_information_category, hr_api.g_varchar2) or
551: nvl(pe_pei_shd.g_old_rec.pei_information1, hr_api.g_varchar2) <>
552: nvl(p_rec.pei_information1, hr_api.g_varchar2) or
553: nvl(pe_pei_shd.g_old_rec.pei_information2, hr_api.g_varchar2) <>
546: if (p_rec.person_extra_info_id is null)
547: or ((p_rec.person_extra_info_id is not null)
548: and
549: nvl(pe_pei_shd.g_old_rec.pei_attribute_category, hr_api.g_varchar2) <>
550: nvl(p_rec.pei_information_category, hr_api.g_varchar2) or
551: nvl(pe_pei_shd.g_old_rec.pei_information1, hr_api.g_varchar2) <>
552: nvl(p_rec.pei_information1, hr_api.g_varchar2) or
553: nvl(pe_pei_shd.g_old_rec.pei_information2, hr_api.g_varchar2) <>
554: nvl(p_rec.pei_information2, hr_api.g_varchar2) or
547: or ((p_rec.person_extra_info_id is not null)
548: and
549: nvl(pe_pei_shd.g_old_rec.pei_attribute_category, hr_api.g_varchar2) <>
550: nvl(p_rec.pei_information_category, hr_api.g_varchar2) or
551: nvl(pe_pei_shd.g_old_rec.pei_information1, hr_api.g_varchar2) <>
552: nvl(p_rec.pei_information1, hr_api.g_varchar2) or
553: nvl(pe_pei_shd.g_old_rec.pei_information2, hr_api.g_varchar2) <>
554: nvl(p_rec.pei_information2, hr_api.g_varchar2) or
555: nvl(pe_pei_shd.g_old_rec.pei_information3, hr_api.g_varchar2) <>
548: and
549: nvl(pe_pei_shd.g_old_rec.pei_attribute_category, hr_api.g_varchar2) <>
550: nvl(p_rec.pei_information_category, hr_api.g_varchar2) or
551: nvl(pe_pei_shd.g_old_rec.pei_information1, hr_api.g_varchar2) <>
552: nvl(p_rec.pei_information1, hr_api.g_varchar2) or
553: nvl(pe_pei_shd.g_old_rec.pei_information2, hr_api.g_varchar2) <>
554: nvl(p_rec.pei_information2, hr_api.g_varchar2) or
555: nvl(pe_pei_shd.g_old_rec.pei_information3, hr_api.g_varchar2) <>
556: nvl(p_rec.pei_information3, hr_api.g_varchar2) or
549: nvl(pe_pei_shd.g_old_rec.pei_attribute_category, hr_api.g_varchar2) <>
550: nvl(p_rec.pei_information_category, hr_api.g_varchar2) or
551: nvl(pe_pei_shd.g_old_rec.pei_information1, hr_api.g_varchar2) <>
552: nvl(p_rec.pei_information1, hr_api.g_varchar2) or
553: nvl(pe_pei_shd.g_old_rec.pei_information2, hr_api.g_varchar2) <>
554: nvl(p_rec.pei_information2, hr_api.g_varchar2) or
555: nvl(pe_pei_shd.g_old_rec.pei_information3, hr_api.g_varchar2) <>
556: nvl(p_rec.pei_information3, hr_api.g_varchar2) or
557: nvl(pe_pei_shd.g_old_rec.pei_information4, hr_api.g_varchar2) <>
550: nvl(p_rec.pei_information_category, hr_api.g_varchar2) or
551: nvl(pe_pei_shd.g_old_rec.pei_information1, hr_api.g_varchar2) <>
552: nvl(p_rec.pei_information1, hr_api.g_varchar2) or
553: nvl(pe_pei_shd.g_old_rec.pei_information2, hr_api.g_varchar2) <>
554: nvl(p_rec.pei_information2, hr_api.g_varchar2) or
555: nvl(pe_pei_shd.g_old_rec.pei_information3, hr_api.g_varchar2) <>
556: nvl(p_rec.pei_information3, hr_api.g_varchar2) or
557: nvl(pe_pei_shd.g_old_rec.pei_information4, hr_api.g_varchar2) <>
558: nvl(p_rec.pei_information4, hr_api.g_varchar2) or
551: nvl(pe_pei_shd.g_old_rec.pei_information1, hr_api.g_varchar2) <>
552: nvl(p_rec.pei_information1, hr_api.g_varchar2) or
553: nvl(pe_pei_shd.g_old_rec.pei_information2, hr_api.g_varchar2) <>
554: nvl(p_rec.pei_information2, hr_api.g_varchar2) or
555: nvl(pe_pei_shd.g_old_rec.pei_information3, hr_api.g_varchar2) <>
556: nvl(p_rec.pei_information3, hr_api.g_varchar2) or
557: nvl(pe_pei_shd.g_old_rec.pei_information4, hr_api.g_varchar2) <>
558: nvl(p_rec.pei_information4, hr_api.g_varchar2) or
559: nvl(pe_pei_shd.g_old_rec.pei_information5, hr_api.g_varchar2) <>
552: nvl(p_rec.pei_information1, hr_api.g_varchar2) or
553: nvl(pe_pei_shd.g_old_rec.pei_information2, hr_api.g_varchar2) <>
554: nvl(p_rec.pei_information2, hr_api.g_varchar2) or
555: nvl(pe_pei_shd.g_old_rec.pei_information3, hr_api.g_varchar2) <>
556: nvl(p_rec.pei_information3, hr_api.g_varchar2) or
557: nvl(pe_pei_shd.g_old_rec.pei_information4, hr_api.g_varchar2) <>
558: nvl(p_rec.pei_information4, hr_api.g_varchar2) or
559: nvl(pe_pei_shd.g_old_rec.pei_information5, hr_api.g_varchar2) <>
560: nvl(p_rec.pei_information5, hr_api.g_varchar2) or
553: nvl(pe_pei_shd.g_old_rec.pei_information2, hr_api.g_varchar2) <>
554: nvl(p_rec.pei_information2, hr_api.g_varchar2) or
555: nvl(pe_pei_shd.g_old_rec.pei_information3, hr_api.g_varchar2) <>
556: nvl(p_rec.pei_information3, hr_api.g_varchar2) or
557: nvl(pe_pei_shd.g_old_rec.pei_information4, hr_api.g_varchar2) <>
558: nvl(p_rec.pei_information4, hr_api.g_varchar2) or
559: nvl(pe_pei_shd.g_old_rec.pei_information5, hr_api.g_varchar2) <>
560: nvl(p_rec.pei_information5, hr_api.g_varchar2) or
561: nvl(pe_pei_shd.g_old_rec.pei_information6, hr_api.g_varchar2) <>
554: nvl(p_rec.pei_information2, hr_api.g_varchar2) or
555: nvl(pe_pei_shd.g_old_rec.pei_information3, hr_api.g_varchar2) <>
556: nvl(p_rec.pei_information3, hr_api.g_varchar2) or
557: nvl(pe_pei_shd.g_old_rec.pei_information4, hr_api.g_varchar2) <>
558: nvl(p_rec.pei_information4, hr_api.g_varchar2) or
559: nvl(pe_pei_shd.g_old_rec.pei_information5, hr_api.g_varchar2) <>
560: nvl(p_rec.pei_information5, hr_api.g_varchar2) or
561: nvl(pe_pei_shd.g_old_rec.pei_information6, hr_api.g_varchar2) <>
562: nvl(p_rec.pei_information6, hr_api.g_varchar2) or
555: nvl(pe_pei_shd.g_old_rec.pei_information3, hr_api.g_varchar2) <>
556: nvl(p_rec.pei_information3, hr_api.g_varchar2) or
557: nvl(pe_pei_shd.g_old_rec.pei_information4, hr_api.g_varchar2) <>
558: nvl(p_rec.pei_information4, hr_api.g_varchar2) or
559: nvl(pe_pei_shd.g_old_rec.pei_information5, hr_api.g_varchar2) <>
560: nvl(p_rec.pei_information5, hr_api.g_varchar2) or
561: nvl(pe_pei_shd.g_old_rec.pei_information6, hr_api.g_varchar2) <>
562: nvl(p_rec.pei_information6, hr_api.g_varchar2) or
563: nvl(pe_pei_shd.g_old_rec.pei_information7, hr_api.g_varchar2) <>
556: nvl(p_rec.pei_information3, hr_api.g_varchar2) or
557: nvl(pe_pei_shd.g_old_rec.pei_information4, hr_api.g_varchar2) <>
558: nvl(p_rec.pei_information4, hr_api.g_varchar2) or
559: nvl(pe_pei_shd.g_old_rec.pei_information5, hr_api.g_varchar2) <>
560: nvl(p_rec.pei_information5, hr_api.g_varchar2) or
561: nvl(pe_pei_shd.g_old_rec.pei_information6, hr_api.g_varchar2) <>
562: nvl(p_rec.pei_information6, hr_api.g_varchar2) or
563: nvl(pe_pei_shd.g_old_rec.pei_information7, hr_api.g_varchar2) <>
564: nvl(p_rec.pei_information7, hr_api.g_varchar2) or
557: nvl(pe_pei_shd.g_old_rec.pei_information4, hr_api.g_varchar2) <>
558: nvl(p_rec.pei_information4, hr_api.g_varchar2) or
559: nvl(pe_pei_shd.g_old_rec.pei_information5, hr_api.g_varchar2) <>
560: nvl(p_rec.pei_information5, hr_api.g_varchar2) or
561: nvl(pe_pei_shd.g_old_rec.pei_information6, hr_api.g_varchar2) <>
562: nvl(p_rec.pei_information6, hr_api.g_varchar2) or
563: nvl(pe_pei_shd.g_old_rec.pei_information7, hr_api.g_varchar2) <>
564: nvl(p_rec.pei_information7, hr_api.g_varchar2) or
565: nvl(pe_pei_shd.g_old_rec.pei_information8, hr_api.g_varchar2) <>
558: nvl(p_rec.pei_information4, hr_api.g_varchar2) or
559: nvl(pe_pei_shd.g_old_rec.pei_information5, hr_api.g_varchar2) <>
560: nvl(p_rec.pei_information5, hr_api.g_varchar2) or
561: nvl(pe_pei_shd.g_old_rec.pei_information6, hr_api.g_varchar2) <>
562: nvl(p_rec.pei_information6, hr_api.g_varchar2) or
563: nvl(pe_pei_shd.g_old_rec.pei_information7, hr_api.g_varchar2) <>
564: nvl(p_rec.pei_information7, hr_api.g_varchar2) or
565: nvl(pe_pei_shd.g_old_rec.pei_information8, hr_api.g_varchar2) <>
566: nvl(p_rec.pei_information8, hr_api.g_varchar2) or
559: nvl(pe_pei_shd.g_old_rec.pei_information5, hr_api.g_varchar2) <>
560: nvl(p_rec.pei_information5, hr_api.g_varchar2) or
561: nvl(pe_pei_shd.g_old_rec.pei_information6, hr_api.g_varchar2) <>
562: nvl(p_rec.pei_information6, hr_api.g_varchar2) or
563: nvl(pe_pei_shd.g_old_rec.pei_information7, hr_api.g_varchar2) <>
564: nvl(p_rec.pei_information7, hr_api.g_varchar2) or
565: nvl(pe_pei_shd.g_old_rec.pei_information8, hr_api.g_varchar2) <>
566: nvl(p_rec.pei_information8, hr_api.g_varchar2) or
567: nvl(pe_pei_shd.g_old_rec.pei_information9, hr_api.g_varchar2) <>
560: nvl(p_rec.pei_information5, hr_api.g_varchar2) or
561: nvl(pe_pei_shd.g_old_rec.pei_information6, hr_api.g_varchar2) <>
562: nvl(p_rec.pei_information6, hr_api.g_varchar2) or
563: nvl(pe_pei_shd.g_old_rec.pei_information7, hr_api.g_varchar2) <>
564: nvl(p_rec.pei_information7, hr_api.g_varchar2) or
565: nvl(pe_pei_shd.g_old_rec.pei_information8, hr_api.g_varchar2) <>
566: nvl(p_rec.pei_information8, hr_api.g_varchar2) or
567: nvl(pe_pei_shd.g_old_rec.pei_information9, hr_api.g_varchar2) <>
568: nvl(p_rec.pei_information9, hr_api.g_varchar2) or
561: nvl(pe_pei_shd.g_old_rec.pei_information6, hr_api.g_varchar2) <>
562: nvl(p_rec.pei_information6, hr_api.g_varchar2) or
563: nvl(pe_pei_shd.g_old_rec.pei_information7, hr_api.g_varchar2) <>
564: nvl(p_rec.pei_information7, hr_api.g_varchar2) or
565: nvl(pe_pei_shd.g_old_rec.pei_information8, hr_api.g_varchar2) <>
566: nvl(p_rec.pei_information8, hr_api.g_varchar2) or
567: nvl(pe_pei_shd.g_old_rec.pei_information9, hr_api.g_varchar2) <>
568: nvl(p_rec.pei_information9, hr_api.g_varchar2) or
569: nvl(pe_pei_shd.g_old_rec.pei_information10, hr_api.g_varchar2) <>
562: nvl(p_rec.pei_information6, hr_api.g_varchar2) or
563: nvl(pe_pei_shd.g_old_rec.pei_information7, hr_api.g_varchar2) <>
564: nvl(p_rec.pei_information7, hr_api.g_varchar2) or
565: nvl(pe_pei_shd.g_old_rec.pei_information8, hr_api.g_varchar2) <>
566: nvl(p_rec.pei_information8, hr_api.g_varchar2) or
567: nvl(pe_pei_shd.g_old_rec.pei_information9, hr_api.g_varchar2) <>
568: nvl(p_rec.pei_information9, hr_api.g_varchar2) or
569: nvl(pe_pei_shd.g_old_rec.pei_information10, hr_api.g_varchar2) <>
570: nvl(p_rec.pei_information10, hr_api.g_varchar2) or
563: nvl(pe_pei_shd.g_old_rec.pei_information7, hr_api.g_varchar2) <>
564: nvl(p_rec.pei_information7, hr_api.g_varchar2) or
565: nvl(pe_pei_shd.g_old_rec.pei_information8, hr_api.g_varchar2) <>
566: nvl(p_rec.pei_information8, hr_api.g_varchar2) or
567: nvl(pe_pei_shd.g_old_rec.pei_information9, hr_api.g_varchar2) <>
568: nvl(p_rec.pei_information9, hr_api.g_varchar2) or
569: nvl(pe_pei_shd.g_old_rec.pei_information10, hr_api.g_varchar2) <>
570: nvl(p_rec.pei_information10, hr_api.g_varchar2) or
571: nvl(pe_pei_shd.g_old_rec.pei_information11, hr_api.g_varchar2) <>
564: nvl(p_rec.pei_information7, hr_api.g_varchar2) or
565: nvl(pe_pei_shd.g_old_rec.pei_information8, hr_api.g_varchar2) <>
566: nvl(p_rec.pei_information8, hr_api.g_varchar2) or
567: nvl(pe_pei_shd.g_old_rec.pei_information9, hr_api.g_varchar2) <>
568: nvl(p_rec.pei_information9, hr_api.g_varchar2) or
569: nvl(pe_pei_shd.g_old_rec.pei_information10, hr_api.g_varchar2) <>
570: nvl(p_rec.pei_information10, hr_api.g_varchar2) or
571: nvl(pe_pei_shd.g_old_rec.pei_information11, hr_api.g_varchar2) <>
572: nvl(p_rec.pei_information11, hr_api.g_varchar2) or
565: nvl(pe_pei_shd.g_old_rec.pei_information8, hr_api.g_varchar2) <>
566: nvl(p_rec.pei_information8, hr_api.g_varchar2) or
567: nvl(pe_pei_shd.g_old_rec.pei_information9, hr_api.g_varchar2) <>
568: nvl(p_rec.pei_information9, hr_api.g_varchar2) or
569: nvl(pe_pei_shd.g_old_rec.pei_information10, hr_api.g_varchar2) <>
570: nvl(p_rec.pei_information10, hr_api.g_varchar2) or
571: nvl(pe_pei_shd.g_old_rec.pei_information11, hr_api.g_varchar2) <>
572: nvl(p_rec.pei_information11, hr_api.g_varchar2) or
573: nvl(pe_pei_shd.g_old_rec.pei_information12, hr_api.g_varchar2) <>
566: nvl(p_rec.pei_information8, hr_api.g_varchar2) or
567: nvl(pe_pei_shd.g_old_rec.pei_information9, hr_api.g_varchar2) <>
568: nvl(p_rec.pei_information9, hr_api.g_varchar2) or
569: nvl(pe_pei_shd.g_old_rec.pei_information10, hr_api.g_varchar2) <>
570: nvl(p_rec.pei_information10, hr_api.g_varchar2) or
571: nvl(pe_pei_shd.g_old_rec.pei_information11, hr_api.g_varchar2) <>
572: nvl(p_rec.pei_information11, hr_api.g_varchar2) or
573: nvl(pe_pei_shd.g_old_rec.pei_information12, hr_api.g_varchar2) <>
574: nvl(p_rec.pei_information12, hr_api.g_varchar2) or
567: nvl(pe_pei_shd.g_old_rec.pei_information9, hr_api.g_varchar2) <>
568: nvl(p_rec.pei_information9, hr_api.g_varchar2) or
569: nvl(pe_pei_shd.g_old_rec.pei_information10, hr_api.g_varchar2) <>
570: nvl(p_rec.pei_information10, hr_api.g_varchar2) or
571: nvl(pe_pei_shd.g_old_rec.pei_information11, hr_api.g_varchar2) <>
572: nvl(p_rec.pei_information11, hr_api.g_varchar2) or
573: nvl(pe_pei_shd.g_old_rec.pei_information12, hr_api.g_varchar2) <>
574: nvl(p_rec.pei_information12, hr_api.g_varchar2) or
575: nvl(pe_pei_shd.g_old_rec.pei_information13, hr_api.g_varchar2) <>
568: nvl(p_rec.pei_information9, hr_api.g_varchar2) or
569: nvl(pe_pei_shd.g_old_rec.pei_information10, hr_api.g_varchar2) <>
570: nvl(p_rec.pei_information10, hr_api.g_varchar2) or
571: nvl(pe_pei_shd.g_old_rec.pei_information11, hr_api.g_varchar2) <>
572: nvl(p_rec.pei_information11, hr_api.g_varchar2) or
573: nvl(pe_pei_shd.g_old_rec.pei_information12, hr_api.g_varchar2) <>
574: nvl(p_rec.pei_information12, hr_api.g_varchar2) or
575: nvl(pe_pei_shd.g_old_rec.pei_information13, hr_api.g_varchar2) <>
576: nvl(p_rec.pei_information13, hr_api.g_varchar2) or
569: nvl(pe_pei_shd.g_old_rec.pei_information10, hr_api.g_varchar2) <>
570: nvl(p_rec.pei_information10, hr_api.g_varchar2) or
571: nvl(pe_pei_shd.g_old_rec.pei_information11, hr_api.g_varchar2) <>
572: nvl(p_rec.pei_information11, hr_api.g_varchar2) or
573: nvl(pe_pei_shd.g_old_rec.pei_information12, hr_api.g_varchar2) <>
574: nvl(p_rec.pei_information12, hr_api.g_varchar2) or
575: nvl(pe_pei_shd.g_old_rec.pei_information13, hr_api.g_varchar2) <>
576: nvl(p_rec.pei_information13, hr_api.g_varchar2) or
577: nvl(pe_pei_shd.g_old_rec.pei_information14, hr_api.g_varchar2) <>
570: nvl(p_rec.pei_information10, hr_api.g_varchar2) or
571: nvl(pe_pei_shd.g_old_rec.pei_information11, hr_api.g_varchar2) <>
572: nvl(p_rec.pei_information11, hr_api.g_varchar2) or
573: nvl(pe_pei_shd.g_old_rec.pei_information12, hr_api.g_varchar2) <>
574: nvl(p_rec.pei_information12, hr_api.g_varchar2) or
575: nvl(pe_pei_shd.g_old_rec.pei_information13, hr_api.g_varchar2) <>
576: nvl(p_rec.pei_information13, hr_api.g_varchar2) or
577: nvl(pe_pei_shd.g_old_rec.pei_information14, hr_api.g_varchar2) <>
578: nvl(p_rec.pei_information14, hr_api.g_varchar2) or
571: nvl(pe_pei_shd.g_old_rec.pei_information11, hr_api.g_varchar2) <>
572: nvl(p_rec.pei_information11, hr_api.g_varchar2) or
573: nvl(pe_pei_shd.g_old_rec.pei_information12, hr_api.g_varchar2) <>
574: nvl(p_rec.pei_information12, hr_api.g_varchar2) or
575: nvl(pe_pei_shd.g_old_rec.pei_information13, hr_api.g_varchar2) <>
576: nvl(p_rec.pei_information13, hr_api.g_varchar2) or
577: nvl(pe_pei_shd.g_old_rec.pei_information14, hr_api.g_varchar2) <>
578: nvl(p_rec.pei_information14, hr_api.g_varchar2) or
579: nvl(pe_pei_shd.g_old_rec.pei_information15, hr_api.g_varchar2) <>
572: nvl(p_rec.pei_information11, hr_api.g_varchar2) or
573: nvl(pe_pei_shd.g_old_rec.pei_information12, hr_api.g_varchar2) <>
574: nvl(p_rec.pei_information12, hr_api.g_varchar2) or
575: nvl(pe_pei_shd.g_old_rec.pei_information13, hr_api.g_varchar2) <>
576: nvl(p_rec.pei_information13, hr_api.g_varchar2) or
577: nvl(pe_pei_shd.g_old_rec.pei_information14, hr_api.g_varchar2) <>
578: nvl(p_rec.pei_information14, hr_api.g_varchar2) or
579: nvl(pe_pei_shd.g_old_rec.pei_information15, hr_api.g_varchar2) <>
580: nvl(p_rec.pei_information15, hr_api.g_varchar2) or
573: nvl(pe_pei_shd.g_old_rec.pei_information12, hr_api.g_varchar2) <>
574: nvl(p_rec.pei_information12, hr_api.g_varchar2) or
575: nvl(pe_pei_shd.g_old_rec.pei_information13, hr_api.g_varchar2) <>
576: nvl(p_rec.pei_information13, hr_api.g_varchar2) or
577: nvl(pe_pei_shd.g_old_rec.pei_information14, hr_api.g_varchar2) <>
578: nvl(p_rec.pei_information14, hr_api.g_varchar2) or
579: nvl(pe_pei_shd.g_old_rec.pei_information15, hr_api.g_varchar2) <>
580: nvl(p_rec.pei_information15, hr_api.g_varchar2) or
581: nvl(pe_pei_shd.g_old_rec.pei_information16, hr_api.g_varchar2) <>
574: nvl(p_rec.pei_information12, hr_api.g_varchar2) or
575: nvl(pe_pei_shd.g_old_rec.pei_information13, hr_api.g_varchar2) <>
576: nvl(p_rec.pei_information13, hr_api.g_varchar2) or
577: nvl(pe_pei_shd.g_old_rec.pei_information14, hr_api.g_varchar2) <>
578: nvl(p_rec.pei_information14, hr_api.g_varchar2) or
579: nvl(pe_pei_shd.g_old_rec.pei_information15, hr_api.g_varchar2) <>
580: nvl(p_rec.pei_information15, hr_api.g_varchar2) or
581: nvl(pe_pei_shd.g_old_rec.pei_information16, hr_api.g_varchar2) <>
582: nvl(p_rec.pei_information16, hr_api.g_varchar2) or
575: nvl(pe_pei_shd.g_old_rec.pei_information13, hr_api.g_varchar2) <>
576: nvl(p_rec.pei_information13, hr_api.g_varchar2) or
577: nvl(pe_pei_shd.g_old_rec.pei_information14, hr_api.g_varchar2) <>
578: nvl(p_rec.pei_information14, hr_api.g_varchar2) or
579: nvl(pe_pei_shd.g_old_rec.pei_information15, hr_api.g_varchar2) <>
580: nvl(p_rec.pei_information15, hr_api.g_varchar2) or
581: nvl(pe_pei_shd.g_old_rec.pei_information16, hr_api.g_varchar2) <>
582: nvl(p_rec.pei_information16, hr_api.g_varchar2) or
583: nvl(pe_pei_shd.g_old_rec.pei_information17, hr_api.g_varchar2) <>
576: nvl(p_rec.pei_information13, hr_api.g_varchar2) or
577: nvl(pe_pei_shd.g_old_rec.pei_information14, hr_api.g_varchar2) <>
578: nvl(p_rec.pei_information14, hr_api.g_varchar2) or
579: nvl(pe_pei_shd.g_old_rec.pei_information15, hr_api.g_varchar2) <>
580: nvl(p_rec.pei_information15, hr_api.g_varchar2) or
581: nvl(pe_pei_shd.g_old_rec.pei_information16, hr_api.g_varchar2) <>
582: nvl(p_rec.pei_information16, hr_api.g_varchar2) or
583: nvl(pe_pei_shd.g_old_rec.pei_information17, hr_api.g_varchar2) <>
584: nvl(p_rec.pei_information17, hr_api.g_varchar2) or
577: nvl(pe_pei_shd.g_old_rec.pei_information14, hr_api.g_varchar2) <>
578: nvl(p_rec.pei_information14, hr_api.g_varchar2) or
579: nvl(pe_pei_shd.g_old_rec.pei_information15, hr_api.g_varchar2) <>
580: nvl(p_rec.pei_information15, hr_api.g_varchar2) or
581: nvl(pe_pei_shd.g_old_rec.pei_information16, hr_api.g_varchar2) <>
582: nvl(p_rec.pei_information16, hr_api.g_varchar2) or
583: nvl(pe_pei_shd.g_old_rec.pei_information17, hr_api.g_varchar2) <>
584: nvl(p_rec.pei_information17, hr_api.g_varchar2) or
585: nvl(pe_pei_shd.g_old_rec.pei_information18, hr_api.g_varchar2) <>
578: nvl(p_rec.pei_information14, hr_api.g_varchar2) or
579: nvl(pe_pei_shd.g_old_rec.pei_information15, hr_api.g_varchar2) <>
580: nvl(p_rec.pei_information15, hr_api.g_varchar2) or
581: nvl(pe_pei_shd.g_old_rec.pei_information16, hr_api.g_varchar2) <>
582: nvl(p_rec.pei_information16, hr_api.g_varchar2) or
583: nvl(pe_pei_shd.g_old_rec.pei_information17, hr_api.g_varchar2) <>
584: nvl(p_rec.pei_information17, hr_api.g_varchar2) or
585: nvl(pe_pei_shd.g_old_rec.pei_information18, hr_api.g_varchar2) <>
586: nvl(p_rec.pei_information18, hr_api.g_varchar2) or
579: nvl(pe_pei_shd.g_old_rec.pei_information15, hr_api.g_varchar2) <>
580: nvl(p_rec.pei_information15, hr_api.g_varchar2) or
581: nvl(pe_pei_shd.g_old_rec.pei_information16, hr_api.g_varchar2) <>
582: nvl(p_rec.pei_information16, hr_api.g_varchar2) or
583: nvl(pe_pei_shd.g_old_rec.pei_information17, hr_api.g_varchar2) <>
584: nvl(p_rec.pei_information17, hr_api.g_varchar2) or
585: nvl(pe_pei_shd.g_old_rec.pei_information18, hr_api.g_varchar2) <>
586: nvl(p_rec.pei_information18, hr_api.g_varchar2) or
587: nvl(pe_pei_shd.g_old_rec.pei_information19, hr_api.g_varchar2) <>
580: nvl(p_rec.pei_information15, hr_api.g_varchar2) or
581: nvl(pe_pei_shd.g_old_rec.pei_information16, hr_api.g_varchar2) <>
582: nvl(p_rec.pei_information16, hr_api.g_varchar2) or
583: nvl(pe_pei_shd.g_old_rec.pei_information17, hr_api.g_varchar2) <>
584: nvl(p_rec.pei_information17, hr_api.g_varchar2) or
585: nvl(pe_pei_shd.g_old_rec.pei_information18, hr_api.g_varchar2) <>
586: nvl(p_rec.pei_information18, hr_api.g_varchar2) or
587: nvl(pe_pei_shd.g_old_rec.pei_information19, hr_api.g_varchar2) <>
588: nvl(p_rec.pei_information19, hr_api.g_varchar2) or
581: nvl(pe_pei_shd.g_old_rec.pei_information16, hr_api.g_varchar2) <>
582: nvl(p_rec.pei_information16, hr_api.g_varchar2) or
583: nvl(pe_pei_shd.g_old_rec.pei_information17, hr_api.g_varchar2) <>
584: nvl(p_rec.pei_information17, hr_api.g_varchar2) or
585: nvl(pe_pei_shd.g_old_rec.pei_information18, hr_api.g_varchar2) <>
586: nvl(p_rec.pei_information18, hr_api.g_varchar2) or
587: nvl(pe_pei_shd.g_old_rec.pei_information19, hr_api.g_varchar2) <>
588: nvl(p_rec.pei_information19, hr_api.g_varchar2) or
589: nvl(pe_pei_shd.g_old_rec.pei_information20, hr_api.g_varchar2) <>
582: nvl(p_rec.pei_information16, hr_api.g_varchar2) or
583: nvl(pe_pei_shd.g_old_rec.pei_information17, hr_api.g_varchar2) <>
584: nvl(p_rec.pei_information17, hr_api.g_varchar2) or
585: nvl(pe_pei_shd.g_old_rec.pei_information18, hr_api.g_varchar2) <>
586: nvl(p_rec.pei_information18, hr_api.g_varchar2) or
587: nvl(pe_pei_shd.g_old_rec.pei_information19, hr_api.g_varchar2) <>
588: nvl(p_rec.pei_information19, hr_api.g_varchar2) or
589: nvl(pe_pei_shd.g_old_rec.pei_information20, hr_api.g_varchar2) <>
590: nvl(p_rec.pei_information20, hr_api.g_varchar2) or
583: nvl(pe_pei_shd.g_old_rec.pei_information17, hr_api.g_varchar2) <>
584: nvl(p_rec.pei_information17, hr_api.g_varchar2) or
585: nvl(pe_pei_shd.g_old_rec.pei_information18, hr_api.g_varchar2) <>
586: nvl(p_rec.pei_information18, hr_api.g_varchar2) or
587: nvl(pe_pei_shd.g_old_rec.pei_information19, hr_api.g_varchar2) <>
588: nvl(p_rec.pei_information19, hr_api.g_varchar2) or
589: nvl(pe_pei_shd.g_old_rec.pei_information20, hr_api.g_varchar2) <>
590: nvl(p_rec.pei_information20, hr_api.g_varchar2) or
591: nvl(pe_pei_shd.g_old_rec.pei_information21, hr_api.g_varchar2) <>
584: nvl(p_rec.pei_information17, hr_api.g_varchar2) or
585: nvl(pe_pei_shd.g_old_rec.pei_information18, hr_api.g_varchar2) <>
586: nvl(p_rec.pei_information18, hr_api.g_varchar2) or
587: nvl(pe_pei_shd.g_old_rec.pei_information19, hr_api.g_varchar2) <>
588: nvl(p_rec.pei_information19, hr_api.g_varchar2) or
589: nvl(pe_pei_shd.g_old_rec.pei_information20, hr_api.g_varchar2) <>
590: nvl(p_rec.pei_information20, hr_api.g_varchar2) or
591: nvl(pe_pei_shd.g_old_rec.pei_information21, hr_api.g_varchar2) <>
592: nvl(p_rec.pei_information21, hr_api.g_varchar2) or
585: nvl(pe_pei_shd.g_old_rec.pei_information18, hr_api.g_varchar2) <>
586: nvl(p_rec.pei_information18, hr_api.g_varchar2) or
587: nvl(pe_pei_shd.g_old_rec.pei_information19, hr_api.g_varchar2) <>
588: nvl(p_rec.pei_information19, hr_api.g_varchar2) or
589: nvl(pe_pei_shd.g_old_rec.pei_information20, hr_api.g_varchar2) <>
590: nvl(p_rec.pei_information20, hr_api.g_varchar2) or
591: nvl(pe_pei_shd.g_old_rec.pei_information21, hr_api.g_varchar2) <>
592: nvl(p_rec.pei_information21, hr_api.g_varchar2) or
593: nvl(pe_pei_shd.g_old_rec.pei_information22, hr_api.g_varchar2) <>
586: nvl(p_rec.pei_information18, hr_api.g_varchar2) or
587: nvl(pe_pei_shd.g_old_rec.pei_information19, hr_api.g_varchar2) <>
588: nvl(p_rec.pei_information19, hr_api.g_varchar2) or
589: nvl(pe_pei_shd.g_old_rec.pei_information20, hr_api.g_varchar2) <>
590: nvl(p_rec.pei_information20, hr_api.g_varchar2) or
591: nvl(pe_pei_shd.g_old_rec.pei_information21, hr_api.g_varchar2) <>
592: nvl(p_rec.pei_information21, hr_api.g_varchar2) or
593: nvl(pe_pei_shd.g_old_rec.pei_information22, hr_api.g_varchar2) <>
594: nvl(p_rec.pei_information22, hr_api.g_varchar2) or
587: nvl(pe_pei_shd.g_old_rec.pei_information19, hr_api.g_varchar2) <>
588: nvl(p_rec.pei_information19, hr_api.g_varchar2) or
589: nvl(pe_pei_shd.g_old_rec.pei_information20, hr_api.g_varchar2) <>
590: nvl(p_rec.pei_information20, hr_api.g_varchar2) or
591: nvl(pe_pei_shd.g_old_rec.pei_information21, hr_api.g_varchar2) <>
592: nvl(p_rec.pei_information21, hr_api.g_varchar2) or
593: nvl(pe_pei_shd.g_old_rec.pei_information22, hr_api.g_varchar2) <>
594: nvl(p_rec.pei_information22, hr_api.g_varchar2) or
595: nvl(pe_pei_shd.g_old_rec.pei_information23, hr_api.g_varchar2) <>
588: nvl(p_rec.pei_information19, hr_api.g_varchar2) or
589: nvl(pe_pei_shd.g_old_rec.pei_information20, hr_api.g_varchar2) <>
590: nvl(p_rec.pei_information20, hr_api.g_varchar2) or
591: nvl(pe_pei_shd.g_old_rec.pei_information21, hr_api.g_varchar2) <>
592: nvl(p_rec.pei_information21, hr_api.g_varchar2) or
593: nvl(pe_pei_shd.g_old_rec.pei_information22, hr_api.g_varchar2) <>
594: nvl(p_rec.pei_information22, hr_api.g_varchar2) or
595: nvl(pe_pei_shd.g_old_rec.pei_information23, hr_api.g_varchar2) <>
596: nvl(p_rec.pei_information23, hr_api.g_varchar2) or
589: nvl(pe_pei_shd.g_old_rec.pei_information20, hr_api.g_varchar2) <>
590: nvl(p_rec.pei_information20, hr_api.g_varchar2) or
591: nvl(pe_pei_shd.g_old_rec.pei_information21, hr_api.g_varchar2) <>
592: nvl(p_rec.pei_information21, hr_api.g_varchar2) or
593: nvl(pe_pei_shd.g_old_rec.pei_information22, hr_api.g_varchar2) <>
594: nvl(p_rec.pei_information22, hr_api.g_varchar2) or
595: nvl(pe_pei_shd.g_old_rec.pei_information23, hr_api.g_varchar2) <>
596: nvl(p_rec.pei_information23, hr_api.g_varchar2) or
597: nvl(pe_pei_shd.g_old_rec.pei_information24, hr_api.g_varchar2) <>
590: nvl(p_rec.pei_information20, hr_api.g_varchar2) or
591: nvl(pe_pei_shd.g_old_rec.pei_information21, hr_api.g_varchar2) <>
592: nvl(p_rec.pei_information21, hr_api.g_varchar2) or
593: nvl(pe_pei_shd.g_old_rec.pei_information22, hr_api.g_varchar2) <>
594: nvl(p_rec.pei_information22, hr_api.g_varchar2) or
595: nvl(pe_pei_shd.g_old_rec.pei_information23, hr_api.g_varchar2) <>
596: nvl(p_rec.pei_information23, hr_api.g_varchar2) or
597: nvl(pe_pei_shd.g_old_rec.pei_information24, hr_api.g_varchar2) <>
598: nvl(p_rec.pei_information24, hr_api.g_varchar2) or
591: nvl(pe_pei_shd.g_old_rec.pei_information21, hr_api.g_varchar2) <>
592: nvl(p_rec.pei_information21, hr_api.g_varchar2) or
593: nvl(pe_pei_shd.g_old_rec.pei_information22, hr_api.g_varchar2) <>
594: nvl(p_rec.pei_information22, hr_api.g_varchar2) or
595: nvl(pe_pei_shd.g_old_rec.pei_information23, hr_api.g_varchar2) <>
596: nvl(p_rec.pei_information23, hr_api.g_varchar2) or
597: nvl(pe_pei_shd.g_old_rec.pei_information24, hr_api.g_varchar2) <>
598: nvl(p_rec.pei_information24, hr_api.g_varchar2) or
599: nvl(pe_pei_shd.g_old_rec.pei_information25, hr_api.g_varchar2) <>
592: nvl(p_rec.pei_information21, hr_api.g_varchar2) or
593: nvl(pe_pei_shd.g_old_rec.pei_information22, hr_api.g_varchar2) <>
594: nvl(p_rec.pei_information22, hr_api.g_varchar2) or
595: nvl(pe_pei_shd.g_old_rec.pei_information23, hr_api.g_varchar2) <>
596: nvl(p_rec.pei_information23, hr_api.g_varchar2) or
597: nvl(pe_pei_shd.g_old_rec.pei_information24, hr_api.g_varchar2) <>
598: nvl(p_rec.pei_information24, hr_api.g_varchar2) or
599: nvl(pe_pei_shd.g_old_rec.pei_information25, hr_api.g_varchar2) <>
600: nvl(p_rec.pei_information25, hr_api.g_varchar2) or
593: nvl(pe_pei_shd.g_old_rec.pei_information22, hr_api.g_varchar2) <>
594: nvl(p_rec.pei_information22, hr_api.g_varchar2) or
595: nvl(pe_pei_shd.g_old_rec.pei_information23, hr_api.g_varchar2) <>
596: nvl(p_rec.pei_information23, hr_api.g_varchar2) or
597: nvl(pe_pei_shd.g_old_rec.pei_information24, hr_api.g_varchar2) <>
598: nvl(p_rec.pei_information24, hr_api.g_varchar2) or
599: nvl(pe_pei_shd.g_old_rec.pei_information25, hr_api.g_varchar2) <>
600: nvl(p_rec.pei_information25, hr_api.g_varchar2) or
601: nvl(pe_pei_shd.g_old_rec.pei_information26, hr_api.g_varchar2) <>
594: nvl(p_rec.pei_information22, hr_api.g_varchar2) or
595: nvl(pe_pei_shd.g_old_rec.pei_information23, hr_api.g_varchar2) <>
596: nvl(p_rec.pei_information23, hr_api.g_varchar2) or
597: nvl(pe_pei_shd.g_old_rec.pei_information24, hr_api.g_varchar2) <>
598: nvl(p_rec.pei_information24, hr_api.g_varchar2) or
599: nvl(pe_pei_shd.g_old_rec.pei_information25, hr_api.g_varchar2) <>
600: nvl(p_rec.pei_information25, hr_api.g_varchar2) or
601: nvl(pe_pei_shd.g_old_rec.pei_information26, hr_api.g_varchar2) <>
602: nvl(p_rec.pei_information26, hr_api.g_varchar2) or
595: nvl(pe_pei_shd.g_old_rec.pei_information23, hr_api.g_varchar2) <>
596: nvl(p_rec.pei_information23, hr_api.g_varchar2) or
597: nvl(pe_pei_shd.g_old_rec.pei_information24, hr_api.g_varchar2) <>
598: nvl(p_rec.pei_information24, hr_api.g_varchar2) or
599: nvl(pe_pei_shd.g_old_rec.pei_information25, hr_api.g_varchar2) <>
600: nvl(p_rec.pei_information25, hr_api.g_varchar2) or
601: nvl(pe_pei_shd.g_old_rec.pei_information26, hr_api.g_varchar2) <>
602: nvl(p_rec.pei_information26, hr_api.g_varchar2) or
603: nvl(pe_pei_shd.g_old_rec.pei_information27, hr_api.g_varchar2) <>
596: nvl(p_rec.pei_information23, hr_api.g_varchar2) or
597: nvl(pe_pei_shd.g_old_rec.pei_information24, hr_api.g_varchar2) <>
598: nvl(p_rec.pei_information24, hr_api.g_varchar2) or
599: nvl(pe_pei_shd.g_old_rec.pei_information25, hr_api.g_varchar2) <>
600: nvl(p_rec.pei_information25, hr_api.g_varchar2) or
601: nvl(pe_pei_shd.g_old_rec.pei_information26, hr_api.g_varchar2) <>
602: nvl(p_rec.pei_information26, hr_api.g_varchar2) or
603: nvl(pe_pei_shd.g_old_rec.pei_information27, hr_api.g_varchar2) <>
604: nvl(p_rec.pei_information27, hr_api.g_varchar2) or
597: nvl(pe_pei_shd.g_old_rec.pei_information24, hr_api.g_varchar2) <>
598: nvl(p_rec.pei_information24, hr_api.g_varchar2) or
599: nvl(pe_pei_shd.g_old_rec.pei_information25, hr_api.g_varchar2) <>
600: nvl(p_rec.pei_information25, hr_api.g_varchar2) or
601: nvl(pe_pei_shd.g_old_rec.pei_information26, hr_api.g_varchar2) <>
602: nvl(p_rec.pei_information26, hr_api.g_varchar2) or
603: nvl(pe_pei_shd.g_old_rec.pei_information27, hr_api.g_varchar2) <>
604: nvl(p_rec.pei_information27, hr_api.g_varchar2) or
605: nvl(pe_pei_shd.g_old_rec.pei_information28, hr_api.g_varchar2) <>
598: nvl(p_rec.pei_information24, hr_api.g_varchar2) or
599: nvl(pe_pei_shd.g_old_rec.pei_information25, hr_api.g_varchar2) <>
600: nvl(p_rec.pei_information25, hr_api.g_varchar2) or
601: nvl(pe_pei_shd.g_old_rec.pei_information26, hr_api.g_varchar2) <>
602: nvl(p_rec.pei_information26, hr_api.g_varchar2) or
603: nvl(pe_pei_shd.g_old_rec.pei_information27, hr_api.g_varchar2) <>
604: nvl(p_rec.pei_information27, hr_api.g_varchar2) or
605: nvl(pe_pei_shd.g_old_rec.pei_information28, hr_api.g_varchar2) <>
606: nvl(p_rec.pei_information28, hr_api.g_varchar2) or
599: nvl(pe_pei_shd.g_old_rec.pei_information25, hr_api.g_varchar2) <>
600: nvl(p_rec.pei_information25, hr_api.g_varchar2) or
601: nvl(pe_pei_shd.g_old_rec.pei_information26, hr_api.g_varchar2) <>
602: nvl(p_rec.pei_information26, hr_api.g_varchar2) or
603: nvl(pe_pei_shd.g_old_rec.pei_information27, hr_api.g_varchar2) <>
604: nvl(p_rec.pei_information27, hr_api.g_varchar2) or
605: nvl(pe_pei_shd.g_old_rec.pei_information28, hr_api.g_varchar2) <>
606: nvl(p_rec.pei_information28, hr_api.g_varchar2) or
607: nvl(pe_pei_shd.g_old_rec.pei_information29, hr_api.g_varchar2) <>
600: nvl(p_rec.pei_information25, hr_api.g_varchar2) or
601: nvl(pe_pei_shd.g_old_rec.pei_information26, hr_api.g_varchar2) <>
602: nvl(p_rec.pei_information26, hr_api.g_varchar2) or
603: nvl(pe_pei_shd.g_old_rec.pei_information27, hr_api.g_varchar2) <>
604: nvl(p_rec.pei_information27, hr_api.g_varchar2) or
605: nvl(pe_pei_shd.g_old_rec.pei_information28, hr_api.g_varchar2) <>
606: nvl(p_rec.pei_information28, hr_api.g_varchar2) or
607: nvl(pe_pei_shd.g_old_rec.pei_information29, hr_api.g_varchar2) <>
608: nvl(p_rec.pei_information29, hr_api.g_varchar2) or
601: nvl(pe_pei_shd.g_old_rec.pei_information26, hr_api.g_varchar2) <>
602: nvl(p_rec.pei_information26, hr_api.g_varchar2) or
603: nvl(pe_pei_shd.g_old_rec.pei_information27, hr_api.g_varchar2) <>
604: nvl(p_rec.pei_information27, hr_api.g_varchar2) or
605: nvl(pe_pei_shd.g_old_rec.pei_information28, hr_api.g_varchar2) <>
606: nvl(p_rec.pei_information28, hr_api.g_varchar2) or
607: nvl(pe_pei_shd.g_old_rec.pei_information29, hr_api.g_varchar2) <>
608: nvl(p_rec.pei_information29, hr_api.g_varchar2) or
609: nvl(pe_pei_shd.g_old_rec.pei_information30, hr_api.g_varchar2) <>
602: nvl(p_rec.pei_information26, hr_api.g_varchar2) or
603: nvl(pe_pei_shd.g_old_rec.pei_information27, hr_api.g_varchar2) <>
604: nvl(p_rec.pei_information27, hr_api.g_varchar2) or
605: nvl(pe_pei_shd.g_old_rec.pei_information28, hr_api.g_varchar2) <>
606: nvl(p_rec.pei_information28, hr_api.g_varchar2) or
607: nvl(pe_pei_shd.g_old_rec.pei_information29, hr_api.g_varchar2) <>
608: nvl(p_rec.pei_information29, hr_api.g_varchar2) or
609: nvl(pe_pei_shd.g_old_rec.pei_information30, hr_api.g_varchar2) <>
610: nvl(p_rec.pei_information30, hr_api.g_varchar2))
603: nvl(pe_pei_shd.g_old_rec.pei_information27, hr_api.g_varchar2) <>
604: nvl(p_rec.pei_information27, hr_api.g_varchar2) or
605: nvl(pe_pei_shd.g_old_rec.pei_information28, hr_api.g_varchar2) <>
606: nvl(p_rec.pei_information28, hr_api.g_varchar2) or
607: nvl(pe_pei_shd.g_old_rec.pei_information29, hr_api.g_varchar2) <>
608: nvl(p_rec.pei_information29, hr_api.g_varchar2) or
609: nvl(pe_pei_shd.g_old_rec.pei_information30, hr_api.g_varchar2) <>
610: nvl(p_rec.pei_information30, hr_api.g_varchar2))
611: then
604: nvl(p_rec.pei_information27, hr_api.g_varchar2) or
605: nvl(pe_pei_shd.g_old_rec.pei_information28, hr_api.g_varchar2) <>
606: nvl(p_rec.pei_information28, hr_api.g_varchar2) or
607: nvl(pe_pei_shd.g_old_rec.pei_information29, hr_api.g_varchar2) <>
608: nvl(p_rec.pei_information29, hr_api.g_varchar2) or
609: nvl(pe_pei_shd.g_old_rec.pei_information30, hr_api.g_varchar2) <>
610: nvl(p_rec.pei_information30, hr_api.g_varchar2))
611: then
612: --
605: nvl(pe_pei_shd.g_old_rec.pei_information28, hr_api.g_varchar2) <>
606: nvl(p_rec.pei_information28, hr_api.g_varchar2) or
607: nvl(pe_pei_shd.g_old_rec.pei_information29, hr_api.g_varchar2) <>
608: nvl(p_rec.pei_information29, hr_api.g_varchar2) or
609: nvl(pe_pei_shd.g_old_rec.pei_information30, hr_api.g_varchar2) <>
610: nvl(p_rec.pei_information30, hr_api.g_varchar2))
611: then
612: --
613: hr_dflex_utility.ins_or_upd_descflex_attribs
606: nvl(p_rec.pei_information28, hr_api.g_varchar2) or
607: nvl(pe_pei_shd.g_old_rec.pei_information29, hr_api.g_varchar2) <>
608: nvl(p_rec.pei_information29, hr_api.g_varchar2) or
609: nvl(pe_pei_shd.g_old_rec.pei_information30, hr_api.g_varchar2) <>
610: nvl(p_rec.pei_information30, hr_api.g_varchar2))
611: then
612: --
613: hr_dflex_utility.ins_or_upd_descflex_attribs
614: (p_appl_short_name => 'PER'