APPS.PE_PEI_BUS dependencies on HR_API

Line 44: hr_api.mandatory_arg_error

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

Line 49: if nvl(g_person_extra_info_id, hr_api.g_number) = p_person_extra_info_id then

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.

Line 139: if nvl(p_rec.person_id,hr_api.g_number)

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;

Line 140: <> nvl(pe_pei_shd.g_old_rec.person_id,hr_api.g_number) then

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

Line 145: if nvl(p_rec.information_type,hr_api.g_varchar2)

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;

Line 146: <> nvl(pe_pei_shd.g_old_rec.information_type,hr_api.g_varchar2) then

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

Line 155: hr_api.argument_changed_error

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;

Line 208: hr_api.mandatory_arg_error

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

Line 299: hr_api.mandatory_arg_error

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

Line 404: nvl(pe_pei_shd.g_old_rec.pei_attribute_category, hr_api.g_varchar2) <>

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

Line 405: nvl(p_rec.pei_attribute_category, hr_api.g_varchar2) or

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

Line 406: nvl(pe_pei_shd.g_old_rec.pei_attribute1, hr_api.g_varchar2) <>

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

Line 407: nvl(p_rec.pei_attribute1, hr_api.g_varchar2) or

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

Line 408: nvl(pe_pei_shd.g_old_rec.pei_attribute2, hr_api.g_varchar2) <>

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

Line 409: nvl(p_rec.pei_attribute2, hr_api.g_varchar2) or

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

Line 410: nvl(pe_pei_shd.g_old_rec.pei_attribute3, hr_api.g_varchar2) <>

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

Line 411: nvl(p_rec.pei_attribute3, hr_api.g_varchar2) or

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

Line 412: nvl(pe_pei_shd.g_old_rec.pei_attribute4, hr_api.g_varchar2) <>

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

Line 413: nvl(p_rec.pei_attribute4, hr_api.g_varchar2) or

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

Line 414: nvl(pe_pei_shd.g_old_rec.pei_attribute5, hr_api.g_varchar2) <>

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

Line 415: nvl(p_rec.pei_attribute5, hr_api.g_varchar2) or

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

Line 416: nvl(pe_pei_shd.g_old_rec.pei_attribute6, hr_api.g_varchar2) <>

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

Line 417: nvl(p_rec.pei_attribute6, hr_api.g_varchar2) or

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

Line 418: nvl(pe_pei_shd.g_old_rec.pei_attribute7, hr_api.g_varchar2) <>

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

Line 419: nvl(p_rec.pei_attribute7, hr_api.g_varchar2) or

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

Line 420: nvl(pe_pei_shd.g_old_rec.pei_attribute8, hr_api.g_varchar2) <>

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

Line 421: nvl(p_rec.pei_attribute8, hr_api.g_varchar2) or

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

Line 422: nvl(pe_pei_shd.g_old_rec.pei_attribute9, hr_api.g_varchar2) <>

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

Line 423: nvl(p_rec.pei_attribute9, hr_api.g_varchar2) or

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

Line 424: nvl(pe_pei_shd.g_old_rec.pei_attribute10, hr_api.g_varchar2) <>

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

Line 425: nvl(p_rec.pei_attribute10, hr_api.g_varchar2) or

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

Line 426: nvl(pe_pei_shd.g_old_rec.pei_attribute11, hr_api.g_varchar2) <>

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

Line 427: nvl(p_rec.pei_attribute11, hr_api.g_varchar2) or

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

Line 428: nvl(pe_pei_shd.g_old_rec.pei_attribute12, hr_api.g_varchar2) <>

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

Line 429: nvl(p_rec.pei_attribute12, hr_api.g_varchar2) or

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

Line 430: nvl(pe_pei_shd.g_old_rec.pei_attribute13, hr_api.g_varchar2) <>

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

Line 431: nvl(p_rec.pei_attribute13, hr_api.g_varchar2) or

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

Line 432: nvl(pe_pei_shd.g_old_rec.pei_attribute14, hr_api.g_varchar2) <>

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

Line 433: nvl(p_rec.pei_attribute14, hr_api.g_varchar2) or

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

Line 434: nvl(pe_pei_shd.g_old_rec.pei_attribute15, hr_api.g_varchar2) <>

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

Line 435: nvl(p_rec.pei_attribute15, hr_api.g_varchar2) or

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

Line 436: nvl(pe_pei_shd.g_old_rec.pei_attribute16, hr_api.g_varchar2) <>

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

Line 437: nvl(p_rec.pei_attribute16, hr_api.g_varchar2) or

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

Line 438: nvl(pe_pei_shd.g_old_rec.pei_attribute17, hr_api.g_varchar2) <>

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

Line 439: nvl(p_rec.pei_attribute17, hr_api.g_varchar2) or

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

Line 440: nvl(pe_pei_shd.g_old_rec.pei_attribute18, hr_api.g_varchar2) <>

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

Line 441: nvl(p_rec.pei_attribute18, hr_api.g_varchar2) or

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

Line 442: nvl(pe_pei_shd.g_old_rec.pei_attribute19, 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

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

Line 444: nvl(pe_pei_shd.g_old_rec.pei_attribute20, hr_api.g_varchar2) <>

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

Line 445: nvl(p_rec.pei_attribute20, 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: --
449: -- Only execute the validation if absolutely necessary:

Line 549: nvl(pe_pei_shd.g_old_rec.pei_attribute_category, hr_api.g_varchar2) <>

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

Line 550: nvl(p_rec.pei_information_category, hr_api.g_varchar2) or

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

Line 551: nvl(pe_pei_shd.g_old_rec.pei_information1, hr_api.g_varchar2) <>

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

Line 552: nvl(p_rec.pei_information1, hr_api.g_varchar2) or

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

Line 553: nvl(pe_pei_shd.g_old_rec.pei_information2, hr_api.g_varchar2) <>

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

Line 554: nvl(p_rec.pei_information2, hr_api.g_varchar2) or

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

Line 555: nvl(pe_pei_shd.g_old_rec.pei_information3, hr_api.g_varchar2) <>

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

Line 556: nvl(p_rec.pei_information3, hr_api.g_varchar2) or

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

Line 557: nvl(pe_pei_shd.g_old_rec.pei_information4, hr_api.g_varchar2) <>

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

Line 558: nvl(p_rec.pei_information4, hr_api.g_varchar2) or

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

Line 559: nvl(pe_pei_shd.g_old_rec.pei_information5, hr_api.g_varchar2) <>

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

Line 560: nvl(p_rec.pei_information5, hr_api.g_varchar2) or

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

Line 561: nvl(pe_pei_shd.g_old_rec.pei_information6, hr_api.g_varchar2) <>

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

Line 562: nvl(p_rec.pei_information6, hr_api.g_varchar2) or

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

Line 563: nvl(pe_pei_shd.g_old_rec.pei_information7, hr_api.g_varchar2) <>

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

Line 564: nvl(p_rec.pei_information7, hr_api.g_varchar2) or

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

Line 565: nvl(pe_pei_shd.g_old_rec.pei_information8, hr_api.g_varchar2) <>

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

Line 566: nvl(p_rec.pei_information8, hr_api.g_varchar2) or

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

Line 567: nvl(pe_pei_shd.g_old_rec.pei_information9, hr_api.g_varchar2) <>

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

Line 568: nvl(p_rec.pei_information9, hr_api.g_varchar2) or

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

Line 569: nvl(pe_pei_shd.g_old_rec.pei_information10, hr_api.g_varchar2) <>

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

Line 570: nvl(p_rec.pei_information10, hr_api.g_varchar2) or

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

Line 571: nvl(pe_pei_shd.g_old_rec.pei_information11, hr_api.g_varchar2) <>

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

Line 572: nvl(p_rec.pei_information11, hr_api.g_varchar2) or

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

Line 573: nvl(pe_pei_shd.g_old_rec.pei_information12, hr_api.g_varchar2) <>

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

Line 574: nvl(p_rec.pei_information12, hr_api.g_varchar2) or

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

Line 575: nvl(pe_pei_shd.g_old_rec.pei_information13, hr_api.g_varchar2) <>

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

Line 576: nvl(p_rec.pei_information13, hr_api.g_varchar2) or

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

Line 577: nvl(pe_pei_shd.g_old_rec.pei_information14, hr_api.g_varchar2) <>

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

Line 578: nvl(p_rec.pei_information14, hr_api.g_varchar2) or

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

Line 579: nvl(pe_pei_shd.g_old_rec.pei_information15, hr_api.g_varchar2) <>

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

Line 580: nvl(p_rec.pei_information15, hr_api.g_varchar2) or

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

Line 581: nvl(pe_pei_shd.g_old_rec.pei_information16, hr_api.g_varchar2) <>

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

Line 582: nvl(p_rec.pei_information16, hr_api.g_varchar2) or

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

Line 583: nvl(pe_pei_shd.g_old_rec.pei_information17, hr_api.g_varchar2) <>

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

Line 584: nvl(p_rec.pei_information17, hr_api.g_varchar2) or

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

Line 585: nvl(pe_pei_shd.g_old_rec.pei_information18, hr_api.g_varchar2) <>

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

Line 586: nvl(p_rec.pei_information18, hr_api.g_varchar2) or

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

Line 587: nvl(pe_pei_shd.g_old_rec.pei_information19, hr_api.g_varchar2) <>

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

Line 588: nvl(p_rec.pei_information19, hr_api.g_varchar2) or

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

Line 589: nvl(pe_pei_shd.g_old_rec.pei_information20, hr_api.g_varchar2) <>

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

Line 590: nvl(p_rec.pei_information20, hr_api.g_varchar2) or

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

Line 591: nvl(pe_pei_shd.g_old_rec.pei_information21, hr_api.g_varchar2) <>

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

Line 592: nvl(p_rec.pei_information21, hr_api.g_varchar2) or

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

Line 593: nvl(pe_pei_shd.g_old_rec.pei_information22, hr_api.g_varchar2) <>

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

Line 594: nvl(p_rec.pei_information22, hr_api.g_varchar2) or

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

Line 595: nvl(pe_pei_shd.g_old_rec.pei_information23, hr_api.g_varchar2) <>

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

Line 596: nvl(p_rec.pei_information23, hr_api.g_varchar2) or

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

Line 597: nvl(pe_pei_shd.g_old_rec.pei_information24, hr_api.g_varchar2) <>

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

Line 598: nvl(p_rec.pei_information24, hr_api.g_varchar2) or

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

Line 599: nvl(pe_pei_shd.g_old_rec.pei_information25, hr_api.g_varchar2) <>

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

Line 600: nvl(p_rec.pei_information25, hr_api.g_varchar2) or

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

Line 601: nvl(pe_pei_shd.g_old_rec.pei_information26, hr_api.g_varchar2) <>

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

Line 602: nvl(p_rec.pei_information26, hr_api.g_varchar2) or

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

Line 603: nvl(pe_pei_shd.g_old_rec.pei_information27, hr_api.g_varchar2) <>

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

Line 604: nvl(p_rec.pei_information27, hr_api.g_varchar2) or

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

Line 605: nvl(pe_pei_shd.g_old_rec.pei_information28, hr_api.g_varchar2) <>

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

Line 606: nvl(p_rec.pei_information28, hr_api.g_varchar2) or

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

Line 607: nvl(pe_pei_shd.g_old_rec.pei_information29, 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

Line 608: nvl(p_rec.pei_information29, hr_api.g_varchar2) or

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

Line 609: nvl(pe_pei_shd.g_old_rec.pei_information30, hr_api.g_varchar2) <>

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

Line 610: nvl(p_rec.pei_information30, 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
614: (p_appl_short_name => 'PER'