APPS.PE_PEI_BUS dependencies on PE_PEI_SHD

Line 116: Procedure chk_non_updateable_args(p_rec in pe_pei_shd.g_rec_type) is

112: --
113: -- {End Of Comments}
114: -- ----------------------------------------------------------------------------
115: --
116: Procedure chk_non_updateable_args(p_rec in pe_pei_shd.g_rec_type) is
117: --
118: l_proc varchar2(72) := g_package||'chk_non_updateable_args';
119: l_error exception;
120: l_argument varchar2(30);

Line 128: if not pe_pei_shd.api_updating

124: hr_utility.set_location('Entering:'|| l_proc,10);
125: --
126: -- Only proceed with validation if a row exists for
127: -- the current record in the HR Schema.
128: if not pe_pei_shd.api_updating
129: (p_person_extra_info_id => p_rec.person_extra_info_id
130: ,p_object_version_number => p_rec.object_version_number
131: ) then
132: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

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 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 396: (p_rec in pe_pei_shd.g_rec_type) is

392: -- Access Status:
393: -- Internal Row Handler Use Only.
394: --
395: procedure chk_df
396: (p_rec in pe_pei_shd.g_rec_type) is
397: --
398: l_proc varchar2(72) := g_package||'chk_df';
399: --
400: begin

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 535: (p_rec in pe_pei_shd.g_rec_type) is

531: -- {End Of Comments}
532: -- ----------------------------------------------------------------------------
533: --
534: procedure chk_ddf
535: (p_rec in pe_pei_shd.g_rec_type) is
536: --
537: l_proc varchar2(72) := g_package||'chk_ddf';
538: l_error exception;
539: --

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 687: Procedure insert_validate(p_rec in pe_pei_shd.g_rec_type) is

683: --
684: -- ----------------------------------------------------------------------------
685: -- |---------------------------< insert_validate >----------------------------|
686: -- ----------------------------------------------------------------------------
687: Procedure insert_validate(p_rec in pe_pei_shd.g_rec_type) is
688: --
689: l_proc varchar2(72) := g_package||'insert_validate';
690: --
691: Begin

Line 733: Procedure update_validate(p_rec in pe_pei_shd.g_rec_type) is

729: --
730: -- ----------------------------------------------------------------------------
731: -- |---------------------------< update_validate >----------------------------|
732: -- ----------------------------------------------------------------------------
733: Procedure update_validate(p_rec in pe_pei_shd.g_rec_type) is
734: --
735: l_proc varchar2(72) := g_package||'update_validate';
736: --
737: Begin

Line 769: Procedure delete_validate(p_rec in pe_pei_shd.g_rec_type) is

765: --
766: -- ----------------------------------------------------------------------------
767: -- |---------------------------< delete_validate >----------------------------|
768: -- ----------------------------------------------------------------------------
769: Procedure delete_validate(p_rec in pe_pei_shd.g_rec_type) is
770: --
771: l_proc varchar2(72) := g_package||'delete_validate';
772: --
773: Begin