APPS.PER_REI_BUS dependencies on PER_REI_SHD

Line 398: (p_rec in per_rei_shd.g_rec_type

394: -- Internal Row Handler Use Only.
395: --
396: -- ----------------------------------------------------------------------------
397: procedure chk_ddf
398: (p_rec in per_rei_shd.g_rec_type
399: ) is
400: --
401: l_proc varchar2(72) := g_package || 'chk_ddf';
402: --

Line 419: nvl(per_rei_shd.g_old_rec.information_type, hr_api.g_varchar2) <>

415: fnd_message.raise_error;
416: end if;
417: --
418: if ((p_rec.contact_extra_info_id is not null) and (
419: nvl(per_rei_shd.g_old_rec.information_type, hr_api.g_varchar2) <>
420: nvl(p_rec.information_type, hr_api.g_varchar2) or
421: nvl(per_rei_shd.g_old_rec.cei_information_category, hr_api.g_varchar2) <>
422: nvl(p_rec.cei_information_category, hr_api.g_varchar2) or
423: nvl(per_rei_shd.g_old_rec.cei_information1, hr_api.g_varchar2) <>

Line 421: nvl(per_rei_shd.g_old_rec.cei_information_category, hr_api.g_varchar2) <>

417: --
418: if ((p_rec.contact_extra_info_id is not null) and (
419: nvl(per_rei_shd.g_old_rec.information_type, hr_api.g_varchar2) <>
420: nvl(p_rec.information_type, hr_api.g_varchar2) or
421: nvl(per_rei_shd.g_old_rec.cei_information_category, hr_api.g_varchar2) <>
422: nvl(p_rec.cei_information_category, hr_api.g_varchar2) or
423: nvl(per_rei_shd.g_old_rec.cei_information1, hr_api.g_varchar2) <>
424: nvl(p_rec.cei_information1, hr_api.g_varchar2) or
425: nvl(per_rei_shd.g_old_rec.cei_information2, hr_api.g_varchar2) <>

Line 423: nvl(per_rei_shd.g_old_rec.cei_information1, hr_api.g_varchar2) <>

419: nvl(per_rei_shd.g_old_rec.information_type, hr_api.g_varchar2) <>
420: nvl(p_rec.information_type, hr_api.g_varchar2) or
421: nvl(per_rei_shd.g_old_rec.cei_information_category, hr_api.g_varchar2) <>
422: nvl(p_rec.cei_information_category, hr_api.g_varchar2) or
423: nvl(per_rei_shd.g_old_rec.cei_information1, hr_api.g_varchar2) <>
424: nvl(p_rec.cei_information1, hr_api.g_varchar2) or
425: nvl(per_rei_shd.g_old_rec.cei_information2, hr_api.g_varchar2) <>
426: nvl(p_rec.cei_information2, hr_api.g_varchar2) or
427: nvl(per_rei_shd.g_old_rec.cei_information3, hr_api.g_varchar2) <>

Line 425: nvl(per_rei_shd.g_old_rec.cei_information2, hr_api.g_varchar2) <>

421: nvl(per_rei_shd.g_old_rec.cei_information_category, hr_api.g_varchar2) <>
422: nvl(p_rec.cei_information_category, hr_api.g_varchar2) or
423: nvl(per_rei_shd.g_old_rec.cei_information1, hr_api.g_varchar2) <>
424: nvl(p_rec.cei_information1, hr_api.g_varchar2) or
425: nvl(per_rei_shd.g_old_rec.cei_information2, hr_api.g_varchar2) <>
426: nvl(p_rec.cei_information2, hr_api.g_varchar2) or
427: nvl(per_rei_shd.g_old_rec.cei_information3, hr_api.g_varchar2) <>
428: nvl(p_rec.cei_information3, hr_api.g_varchar2) or
429: nvl(per_rei_shd.g_old_rec.cei_information4, hr_api.g_varchar2) <>

Line 427: nvl(per_rei_shd.g_old_rec.cei_information3, hr_api.g_varchar2) <>

423: nvl(per_rei_shd.g_old_rec.cei_information1, hr_api.g_varchar2) <>
424: nvl(p_rec.cei_information1, hr_api.g_varchar2) or
425: nvl(per_rei_shd.g_old_rec.cei_information2, hr_api.g_varchar2) <>
426: nvl(p_rec.cei_information2, hr_api.g_varchar2) or
427: nvl(per_rei_shd.g_old_rec.cei_information3, hr_api.g_varchar2) <>
428: nvl(p_rec.cei_information3, hr_api.g_varchar2) or
429: nvl(per_rei_shd.g_old_rec.cei_information4, hr_api.g_varchar2) <>
430: nvl(p_rec.cei_information4, hr_api.g_varchar2) or
431: nvl(per_rei_shd.g_old_rec.cei_information5, hr_api.g_varchar2) <>

Line 429: nvl(per_rei_shd.g_old_rec.cei_information4, hr_api.g_varchar2) <>

425: nvl(per_rei_shd.g_old_rec.cei_information2, hr_api.g_varchar2) <>
426: nvl(p_rec.cei_information2, hr_api.g_varchar2) or
427: nvl(per_rei_shd.g_old_rec.cei_information3, hr_api.g_varchar2) <>
428: nvl(p_rec.cei_information3, hr_api.g_varchar2) or
429: nvl(per_rei_shd.g_old_rec.cei_information4, hr_api.g_varchar2) <>
430: nvl(p_rec.cei_information4, hr_api.g_varchar2) or
431: nvl(per_rei_shd.g_old_rec.cei_information5, hr_api.g_varchar2) <>
432: nvl(p_rec.cei_information5, hr_api.g_varchar2) or
433: nvl(per_rei_shd.g_old_rec.cei_information6, hr_api.g_varchar2) <>

Line 431: nvl(per_rei_shd.g_old_rec.cei_information5, hr_api.g_varchar2) <>

427: nvl(per_rei_shd.g_old_rec.cei_information3, hr_api.g_varchar2) <>
428: nvl(p_rec.cei_information3, hr_api.g_varchar2) or
429: nvl(per_rei_shd.g_old_rec.cei_information4, hr_api.g_varchar2) <>
430: nvl(p_rec.cei_information4, hr_api.g_varchar2) or
431: nvl(per_rei_shd.g_old_rec.cei_information5, hr_api.g_varchar2) <>
432: nvl(p_rec.cei_information5, hr_api.g_varchar2) or
433: nvl(per_rei_shd.g_old_rec.cei_information6, hr_api.g_varchar2) <>
434: nvl(p_rec.cei_information6, hr_api.g_varchar2) or
435: nvl(per_rei_shd.g_old_rec.cei_information7, hr_api.g_varchar2) <>

Line 433: nvl(per_rei_shd.g_old_rec.cei_information6, hr_api.g_varchar2) <>

429: nvl(per_rei_shd.g_old_rec.cei_information4, hr_api.g_varchar2) <>
430: nvl(p_rec.cei_information4, hr_api.g_varchar2) or
431: nvl(per_rei_shd.g_old_rec.cei_information5, hr_api.g_varchar2) <>
432: nvl(p_rec.cei_information5, hr_api.g_varchar2) or
433: nvl(per_rei_shd.g_old_rec.cei_information6, hr_api.g_varchar2) <>
434: nvl(p_rec.cei_information6, hr_api.g_varchar2) or
435: nvl(per_rei_shd.g_old_rec.cei_information7, hr_api.g_varchar2) <>
436: nvl(p_rec.cei_information7, hr_api.g_varchar2) or
437: nvl(per_rei_shd.g_old_rec.cei_information8, hr_api.g_varchar2) <>

Line 435: nvl(per_rei_shd.g_old_rec.cei_information7, hr_api.g_varchar2) <>

431: nvl(per_rei_shd.g_old_rec.cei_information5, hr_api.g_varchar2) <>
432: nvl(p_rec.cei_information5, hr_api.g_varchar2) or
433: nvl(per_rei_shd.g_old_rec.cei_information6, hr_api.g_varchar2) <>
434: nvl(p_rec.cei_information6, hr_api.g_varchar2) or
435: nvl(per_rei_shd.g_old_rec.cei_information7, hr_api.g_varchar2) <>
436: nvl(p_rec.cei_information7, hr_api.g_varchar2) or
437: nvl(per_rei_shd.g_old_rec.cei_information8, hr_api.g_varchar2) <>
438: nvl(p_rec.cei_information8, hr_api.g_varchar2) or
439: nvl(per_rei_shd.g_old_rec.cei_information9, hr_api.g_varchar2) <>

Line 437: nvl(per_rei_shd.g_old_rec.cei_information8, hr_api.g_varchar2) <>

433: nvl(per_rei_shd.g_old_rec.cei_information6, hr_api.g_varchar2) <>
434: nvl(p_rec.cei_information6, hr_api.g_varchar2) or
435: nvl(per_rei_shd.g_old_rec.cei_information7, hr_api.g_varchar2) <>
436: nvl(p_rec.cei_information7, hr_api.g_varchar2) or
437: nvl(per_rei_shd.g_old_rec.cei_information8, hr_api.g_varchar2) <>
438: nvl(p_rec.cei_information8, hr_api.g_varchar2) or
439: nvl(per_rei_shd.g_old_rec.cei_information9, hr_api.g_varchar2) <>
440: nvl(p_rec.cei_information9, hr_api.g_varchar2) or
441: nvl(per_rei_shd.g_old_rec.cei_information10, hr_api.g_varchar2) <>

Line 439: nvl(per_rei_shd.g_old_rec.cei_information9, hr_api.g_varchar2) <>

435: nvl(per_rei_shd.g_old_rec.cei_information7, hr_api.g_varchar2) <>
436: nvl(p_rec.cei_information7, hr_api.g_varchar2) or
437: nvl(per_rei_shd.g_old_rec.cei_information8, hr_api.g_varchar2) <>
438: nvl(p_rec.cei_information8, hr_api.g_varchar2) or
439: nvl(per_rei_shd.g_old_rec.cei_information9, hr_api.g_varchar2) <>
440: nvl(p_rec.cei_information9, hr_api.g_varchar2) or
441: nvl(per_rei_shd.g_old_rec.cei_information10, hr_api.g_varchar2) <>
442: nvl(p_rec.cei_information10, hr_api.g_varchar2) or
443: nvl(per_rei_shd.g_old_rec.cei_information11, hr_api.g_varchar2) <>

Line 441: nvl(per_rei_shd.g_old_rec.cei_information10, hr_api.g_varchar2) <>

437: nvl(per_rei_shd.g_old_rec.cei_information8, hr_api.g_varchar2) <>
438: nvl(p_rec.cei_information8, hr_api.g_varchar2) or
439: nvl(per_rei_shd.g_old_rec.cei_information9, hr_api.g_varchar2) <>
440: nvl(p_rec.cei_information9, hr_api.g_varchar2) or
441: nvl(per_rei_shd.g_old_rec.cei_information10, hr_api.g_varchar2) <>
442: nvl(p_rec.cei_information10, hr_api.g_varchar2) or
443: nvl(per_rei_shd.g_old_rec.cei_information11, hr_api.g_varchar2) <>
444: nvl(p_rec.cei_information11, hr_api.g_varchar2) or
445: nvl(per_rei_shd.g_old_rec.cei_information12, hr_api.g_varchar2) <>

Line 443: nvl(per_rei_shd.g_old_rec.cei_information11, hr_api.g_varchar2) <>

439: nvl(per_rei_shd.g_old_rec.cei_information9, hr_api.g_varchar2) <>
440: nvl(p_rec.cei_information9, hr_api.g_varchar2) or
441: nvl(per_rei_shd.g_old_rec.cei_information10, hr_api.g_varchar2) <>
442: nvl(p_rec.cei_information10, hr_api.g_varchar2) or
443: nvl(per_rei_shd.g_old_rec.cei_information11, hr_api.g_varchar2) <>
444: nvl(p_rec.cei_information11, hr_api.g_varchar2) or
445: nvl(per_rei_shd.g_old_rec.cei_information12, hr_api.g_varchar2) <>
446: nvl(p_rec.cei_information12, hr_api.g_varchar2) or
447: nvl(per_rei_shd.g_old_rec.cei_information13, hr_api.g_varchar2) <>

Line 445: nvl(per_rei_shd.g_old_rec.cei_information12, hr_api.g_varchar2) <>

441: nvl(per_rei_shd.g_old_rec.cei_information10, hr_api.g_varchar2) <>
442: nvl(p_rec.cei_information10, hr_api.g_varchar2) or
443: nvl(per_rei_shd.g_old_rec.cei_information11, hr_api.g_varchar2) <>
444: nvl(p_rec.cei_information11, hr_api.g_varchar2) or
445: nvl(per_rei_shd.g_old_rec.cei_information12, hr_api.g_varchar2) <>
446: nvl(p_rec.cei_information12, hr_api.g_varchar2) or
447: nvl(per_rei_shd.g_old_rec.cei_information13, hr_api.g_varchar2) <>
448: nvl(p_rec.cei_information13, hr_api.g_varchar2) or
449: nvl(per_rei_shd.g_old_rec.cei_information14, hr_api.g_varchar2) <>

Line 447: nvl(per_rei_shd.g_old_rec.cei_information13, hr_api.g_varchar2) <>

443: nvl(per_rei_shd.g_old_rec.cei_information11, hr_api.g_varchar2) <>
444: nvl(p_rec.cei_information11, hr_api.g_varchar2) or
445: nvl(per_rei_shd.g_old_rec.cei_information12, hr_api.g_varchar2) <>
446: nvl(p_rec.cei_information12, hr_api.g_varchar2) or
447: nvl(per_rei_shd.g_old_rec.cei_information13, hr_api.g_varchar2) <>
448: nvl(p_rec.cei_information13, hr_api.g_varchar2) or
449: nvl(per_rei_shd.g_old_rec.cei_information14, hr_api.g_varchar2) <>
450: nvl(p_rec.cei_information14, hr_api.g_varchar2) or
451: nvl(per_rei_shd.g_old_rec.cei_information15, hr_api.g_varchar2) <>

Line 449: nvl(per_rei_shd.g_old_rec.cei_information14, hr_api.g_varchar2) <>

445: nvl(per_rei_shd.g_old_rec.cei_information12, hr_api.g_varchar2) <>
446: nvl(p_rec.cei_information12, hr_api.g_varchar2) or
447: nvl(per_rei_shd.g_old_rec.cei_information13, hr_api.g_varchar2) <>
448: nvl(p_rec.cei_information13, hr_api.g_varchar2) or
449: nvl(per_rei_shd.g_old_rec.cei_information14, hr_api.g_varchar2) <>
450: nvl(p_rec.cei_information14, hr_api.g_varchar2) or
451: nvl(per_rei_shd.g_old_rec.cei_information15, hr_api.g_varchar2) <>
452: nvl(p_rec.cei_information15, hr_api.g_varchar2) or
453: nvl(per_rei_shd.g_old_rec.cei_information16, hr_api.g_varchar2) <>

Line 451: nvl(per_rei_shd.g_old_rec.cei_information15, hr_api.g_varchar2) <>

447: nvl(per_rei_shd.g_old_rec.cei_information13, hr_api.g_varchar2) <>
448: nvl(p_rec.cei_information13, hr_api.g_varchar2) or
449: nvl(per_rei_shd.g_old_rec.cei_information14, hr_api.g_varchar2) <>
450: nvl(p_rec.cei_information14, hr_api.g_varchar2) or
451: nvl(per_rei_shd.g_old_rec.cei_information15, hr_api.g_varchar2) <>
452: nvl(p_rec.cei_information15, hr_api.g_varchar2) or
453: nvl(per_rei_shd.g_old_rec.cei_information16, hr_api.g_varchar2) <>
454: nvl(p_rec.cei_information16, hr_api.g_varchar2) or
455: nvl(per_rei_shd.g_old_rec.cei_information17, hr_api.g_varchar2) <>

Line 453: nvl(per_rei_shd.g_old_rec.cei_information16, hr_api.g_varchar2) <>

449: nvl(per_rei_shd.g_old_rec.cei_information14, hr_api.g_varchar2) <>
450: nvl(p_rec.cei_information14, hr_api.g_varchar2) or
451: nvl(per_rei_shd.g_old_rec.cei_information15, hr_api.g_varchar2) <>
452: nvl(p_rec.cei_information15, hr_api.g_varchar2) or
453: nvl(per_rei_shd.g_old_rec.cei_information16, hr_api.g_varchar2) <>
454: nvl(p_rec.cei_information16, hr_api.g_varchar2) or
455: nvl(per_rei_shd.g_old_rec.cei_information17, hr_api.g_varchar2) <>
456: nvl(p_rec.cei_information17, hr_api.g_varchar2) or
457: nvl(per_rei_shd.g_old_rec.cei_information18, hr_api.g_varchar2) <>

Line 455: nvl(per_rei_shd.g_old_rec.cei_information17, hr_api.g_varchar2) <>

451: nvl(per_rei_shd.g_old_rec.cei_information15, hr_api.g_varchar2) <>
452: nvl(p_rec.cei_information15, hr_api.g_varchar2) or
453: nvl(per_rei_shd.g_old_rec.cei_information16, hr_api.g_varchar2) <>
454: nvl(p_rec.cei_information16, hr_api.g_varchar2) or
455: nvl(per_rei_shd.g_old_rec.cei_information17, hr_api.g_varchar2) <>
456: nvl(p_rec.cei_information17, hr_api.g_varchar2) or
457: nvl(per_rei_shd.g_old_rec.cei_information18, hr_api.g_varchar2) <>
458: nvl(p_rec.cei_information18, hr_api.g_varchar2) or
459: nvl(per_rei_shd.g_old_rec.cei_information19, hr_api.g_varchar2) <>

Line 457: nvl(per_rei_shd.g_old_rec.cei_information18, hr_api.g_varchar2) <>

453: nvl(per_rei_shd.g_old_rec.cei_information16, hr_api.g_varchar2) <>
454: nvl(p_rec.cei_information16, hr_api.g_varchar2) or
455: nvl(per_rei_shd.g_old_rec.cei_information17, hr_api.g_varchar2) <>
456: nvl(p_rec.cei_information17, hr_api.g_varchar2) or
457: nvl(per_rei_shd.g_old_rec.cei_information18, hr_api.g_varchar2) <>
458: nvl(p_rec.cei_information18, hr_api.g_varchar2) or
459: nvl(per_rei_shd.g_old_rec.cei_information19, hr_api.g_varchar2) <>
460: nvl(p_rec.cei_information19, hr_api.g_varchar2) or
461: nvl(per_rei_shd.g_old_rec.cei_information20, hr_api.g_varchar2) <>

Line 459: nvl(per_rei_shd.g_old_rec.cei_information19, hr_api.g_varchar2) <>

455: nvl(per_rei_shd.g_old_rec.cei_information17, hr_api.g_varchar2) <>
456: nvl(p_rec.cei_information17, hr_api.g_varchar2) or
457: nvl(per_rei_shd.g_old_rec.cei_information18, hr_api.g_varchar2) <>
458: nvl(p_rec.cei_information18, hr_api.g_varchar2) or
459: nvl(per_rei_shd.g_old_rec.cei_information19, hr_api.g_varchar2) <>
460: nvl(p_rec.cei_information19, hr_api.g_varchar2) or
461: nvl(per_rei_shd.g_old_rec.cei_information20, hr_api.g_varchar2) <>
462: nvl(p_rec.cei_information20, hr_api.g_varchar2) or
463: nvl(per_rei_shd.g_old_rec.cei_information21, hr_api.g_varchar2) <>

Line 461: nvl(per_rei_shd.g_old_rec.cei_information20, hr_api.g_varchar2) <>

457: nvl(per_rei_shd.g_old_rec.cei_information18, hr_api.g_varchar2) <>
458: nvl(p_rec.cei_information18, hr_api.g_varchar2) or
459: nvl(per_rei_shd.g_old_rec.cei_information19, hr_api.g_varchar2) <>
460: nvl(p_rec.cei_information19, hr_api.g_varchar2) or
461: nvl(per_rei_shd.g_old_rec.cei_information20, hr_api.g_varchar2) <>
462: nvl(p_rec.cei_information20, hr_api.g_varchar2) or
463: nvl(per_rei_shd.g_old_rec.cei_information21, hr_api.g_varchar2) <>
464: nvl(p_rec.cei_information21, hr_api.g_varchar2) or
465: nvl(per_rei_shd.g_old_rec.cei_information22, hr_api.g_varchar2) <>

Line 463: nvl(per_rei_shd.g_old_rec.cei_information21, hr_api.g_varchar2) <>

459: nvl(per_rei_shd.g_old_rec.cei_information19, hr_api.g_varchar2) <>
460: nvl(p_rec.cei_information19, hr_api.g_varchar2) or
461: nvl(per_rei_shd.g_old_rec.cei_information20, hr_api.g_varchar2) <>
462: nvl(p_rec.cei_information20, hr_api.g_varchar2) or
463: nvl(per_rei_shd.g_old_rec.cei_information21, hr_api.g_varchar2) <>
464: nvl(p_rec.cei_information21, hr_api.g_varchar2) or
465: nvl(per_rei_shd.g_old_rec.cei_information22, hr_api.g_varchar2) <>
466: nvl(p_rec.cei_information22, hr_api.g_varchar2) or
467: nvl(per_rei_shd.g_old_rec.cei_information23, hr_api.g_varchar2) <>

Line 465: nvl(per_rei_shd.g_old_rec.cei_information22, hr_api.g_varchar2) <>

461: nvl(per_rei_shd.g_old_rec.cei_information20, hr_api.g_varchar2) <>
462: nvl(p_rec.cei_information20, hr_api.g_varchar2) or
463: nvl(per_rei_shd.g_old_rec.cei_information21, hr_api.g_varchar2) <>
464: nvl(p_rec.cei_information21, hr_api.g_varchar2) or
465: nvl(per_rei_shd.g_old_rec.cei_information22, hr_api.g_varchar2) <>
466: nvl(p_rec.cei_information22, hr_api.g_varchar2) or
467: nvl(per_rei_shd.g_old_rec.cei_information23, hr_api.g_varchar2) <>
468: nvl(p_rec.cei_information23, hr_api.g_varchar2) or
469: nvl(per_rei_shd.g_old_rec.cei_information24, hr_api.g_varchar2) <>

Line 467: nvl(per_rei_shd.g_old_rec.cei_information23, hr_api.g_varchar2) <>

463: nvl(per_rei_shd.g_old_rec.cei_information21, hr_api.g_varchar2) <>
464: nvl(p_rec.cei_information21, hr_api.g_varchar2) or
465: nvl(per_rei_shd.g_old_rec.cei_information22, hr_api.g_varchar2) <>
466: nvl(p_rec.cei_information22, hr_api.g_varchar2) or
467: nvl(per_rei_shd.g_old_rec.cei_information23, hr_api.g_varchar2) <>
468: nvl(p_rec.cei_information23, hr_api.g_varchar2) or
469: nvl(per_rei_shd.g_old_rec.cei_information24, hr_api.g_varchar2) <>
470: nvl(p_rec.cei_information24, hr_api.g_varchar2) or
471: nvl(per_rei_shd.g_old_rec.cei_information25, hr_api.g_varchar2) <>

Line 469: nvl(per_rei_shd.g_old_rec.cei_information24, hr_api.g_varchar2) <>

465: nvl(per_rei_shd.g_old_rec.cei_information22, hr_api.g_varchar2) <>
466: nvl(p_rec.cei_information22, hr_api.g_varchar2) or
467: nvl(per_rei_shd.g_old_rec.cei_information23, hr_api.g_varchar2) <>
468: nvl(p_rec.cei_information23, hr_api.g_varchar2) or
469: nvl(per_rei_shd.g_old_rec.cei_information24, hr_api.g_varchar2) <>
470: nvl(p_rec.cei_information24, hr_api.g_varchar2) or
471: nvl(per_rei_shd.g_old_rec.cei_information25, hr_api.g_varchar2) <>
472: nvl(p_rec.cei_information25, hr_api.g_varchar2) or
473: nvl(per_rei_shd.g_old_rec.cei_information26, hr_api.g_varchar2) <>

Line 471: nvl(per_rei_shd.g_old_rec.cei_information25, hr_api.g_varchar2) <>

467: nvl(per_rei_shd.g_old_rec.cei_information23, hr_api.g_varchar2) <>
468: nvl(p_rec.cei_information23, hr_api.g_varchar2) or
469: nvl(per_rei_shd.g_old_rec.cei_information24, hr_api.g_varchar2) <>
470: nvl(p_rec.cei_information24, hr_api.g_varchar2) or
471: nvl(per_rei_shd.g_old_rec.cei_information25, hr_api.g_varchar2) <>
472: nvl(p_rec.cei_information25, hr_api.g_varchar2) or
473: nvl(per_rei_shd.g_old_rec.cei_information26, hr_api.g_varchar2) <>
474: nvl(p_rec.cei_information26, hr_api.g_varchar2) or
475: nvl(per_rei_shd.g_old_rec.cei_information27, hr_api.g_varchar2) <>

Line 473: nvl(per_rei_shd.g_old_rec.cei_information26, hr_api.g_varchar2) <>

469: nvl(per_rei_shd.g_old_rec.cei_information24, hr_api.g_varchar2) <>
470: nvl(p_rec.cei_information24, hr_api.g_varchar2) or
471: nvl(per_rei_shd.g_old_rec.cei_information25, hr_api.g_varchar2) <>
472: nvl(p_rec.cei_information25, hr_api.g_varchar2) or
473: nvl(per_rei_shd.g_old_rec.cei_information26, hr_api.g_varchar2) <>
474: nvl(p_rec.cei_information26, hr_api.g_varchar2) or
475: nvl(per_rei_shd.g_old_rec.cei_information27, hr_api.g_varchar2) <>
476: nvl(p_rec.cei_information27, hr_api.g_varchar2) or
477: nvl(per_rei_shd.g_old_rec.cei_information28, hr_api.g_varchar2) <>

Line 475: nvl(per_rei_shd.g_old_rec.cei_information27, hr_api.g_varchar2) <>

471: nvl(per_rei_shd.g_old_rec.cei_information25, hr_api.g_varchar2) <>
472: nvl(p_rec.cei_information25, hr_api.g_varchar2) or
473: nvl(per_rei_shd.g_old_rec.cei_information26, hr_api.g_varchar2) <>
474: nvl(p_rec.cei_information26, hr_api.g_varchar2) or
475: nvl(per_rei_shd.g_old_rec.cei_information27, hr_api.g_varchar2) <>
476: nvl(p_rec.cei_information27, hr_api.g_varchar2) or
477: nvl(per_rei_shd.g_old_rec.cei_information28, hr_api.g_varchar2) <>
478: nvl(p_rec.cei_information28, hr_api.g_varchar2) or
479: nvl(per_rei_shd.g_old_rec.cei_information29, hr_api.g_varchar2) <>

Line 477: nvl(per_rei_shd.g_old_rec.cei_information28, hr_api.g_varchar2) <>

473: nvl(per_rei_shd.g_old_rec.cei_information26, hr_api.g_varchar2) <>
474: nvl(p_rec.cei_information26, hr_api.g_varchar2) or
475: nvl(per_rei_shd.g_old_rec.cei_information27, hr_api.g_varchar2) <>
476: nvl(p_rec.cei_information27, hr_api.g_varchar2) or
477: nvl(per_rei_shd.g_old_rec.cei_information28, hr_api.g_varchar2) <>
478: nvl(p_rec.cei_information28, hr_api.g_varchar2) or
479: nvl(per_rei_shd.g_old_rec.cei_information29, hr_api.g_varchar2) <>
480: nvl(p_rec.cei_information29, hr_api.g_varchar2) or
481: nvl(per_rei_shd.g_old_rec.cei_information30, hr_api.g_varchar2) <>

Line 479: nvl(per_rei_shd.g_old_rec.cei_information29, hr_api.g_varchar2) <>

475: nvl(per_rei_shd.g_old_rec.cei_information27, hr_api.g_varchar2) <>
476: nvl(p_rec.cei_information27, hr_api.g_varchar2) or
477: nvl(per_rei_shd.g_old_rec.cei_information28, hr_api.g_varchar2) <>
478: nvl(p_rec.cei_information28, hr_api.g_varchar2) or
479: nvl(per_rei_shd.g_old_rec.cei_information29, hr_api.g_varchar2) <>
480: nvl(p_rec.cei_information29, hr_api.g_varchar2) or
481: nvl(per_rei_shd.g_old_rec.cei_information30, hr_api.g_varchar2) <>
482: nvl(p_rec.cei_information30, hr_api.g_varchar2) ))
483: or (p_rec.contact_extra_info_id is null) then

Line 481: nvl(per_rei_shd.g_old_rec.cei_information30, hr_api.g_varchar2) <>

477: nvl(per_rei_shd.g_old_rec.cei_information28, hr_api.g_varchar2) <>
478: nvl(p_rec.cei_information28, hr_api.g_varchar2) or
479: nvl(per_rei_shd.g_old_rec.cei_information29, hr_api.g_varchar2) <>
480: nvl(p_rec.cei_information29, hr_api.g_varchar2) or
481: nvl(per_rei_shd.g_old_rec.cei_information30, hr_api.g_varchar2) <>
482: nvl(p_rec.cei_information30, hr_api.g_varchar2) ))
483: or (p_rec.contact_extra_info_id is null) then
484: --
485: -- Only execute the validation if absolutely necessary:

Line 591: (p_rec in per_rei_shd.g_rec_type

587: -- Internal Row Handler Use Only.
588: --
589: -- ----------------------------------------------------------------------------
590: procedure chk_df
591: (p_rec in per_rei_shd.g_rec_type
592: ) is
593: --
594: l_proc varchar2(72) := g_package || 'chk_df';
595: --

Line 600: nvl(per_rei_shd.g_old_rec.cei_attribute_category, hr_api.g_varchar2) <>

596: begin
597: hr_utility.set_location('Entering:'||l_proc,10);
598: --
599: if ((p_rec.contact_extra_info_id is not null) and (
600: nvl(per_rei_shd.g_old_rec.cei_attribute_category, hr_api.g_varchar2) <>
601: nvl(p_rec.cei_attribute_category, hr_api.g_varchar2) or
602: nvl(per_rei_shd.g_old_rec.cei_attribute1, hr_api.g_varchar2) <>
603: nvl(p_rec.cei_attribute1, hr_api.g_varchar2) or
604: nvl(per_rei_shd.g_old_rec.cei_attribute2, hr_api.g_varchar2) <>

Line 602: nvl(per_rei_shd.g_old_rec.cei_attribute1, hr_api.g_varchar2) <>

598: --
599: if ((p_rec.contact_extra_info_id is not null) and (
600: nvl(per_rei_shd.g_old_rec.cei_attribute_category, hr_api.g_varchar2) <>
601: nvl(p_rec.cei_attribute_category, hr_api.g_varchar2) or
602: nvl(per_rei_shd.g_old_rec.cei_attribute1, hr_api.g_varchar2) <>
603: nvl(p_rec.cei_attribute1, hr_api.g_varchar2) or
604: nvl(per_rei_shd.g_old_rec.cei_attribute2, hr_api.g_varchar2) <>
605: nvl(p_rec.cei_attribute2, hr_api.g_varchar2) or
606: nvl(per_rei_shd.g_old_rec.cei_attribute3, hr_api.g_varchar2) <>

Line 604: nvl(per_rei_shd.g_old_rec.cei_attribute2, hr_api.g_varchar2) <>

600: nvl(per_rei_shd.g_old_rec.cei_attribute_category, hr_api.g_varchar2) <>
601: nvl(p_rec.cei_attribute_category, hr_api.g_varchar2) or
602: nvl(per_rei_shd.g_old_rec.cei_attribute1, hr_api.g_varchar2) <>
603: nvl(p_rec.cei_attribute1, hr_api.g_varchar2) or
604: nvl(per_rei_shd.g_old_rec.cei_attribute2, hr_api.g_varchar2) <>
605: nvl(p_rec.cei_attribute2, hr_api.g_varchar2) or
606: nvl(per_rei_shd.g_old_rec.cei_attribute3, hr_api.g_varchar2) <>
607: nvl(p_rec.cei_attribute3, hr_api.g_varchar2) or
608: nvl(per_rei_shd.g_old_rec.cei_attribute4, hr_api.g_varchar2) <>

Line 606: nvl(per_rei_shd.g_old_rec.cei_attribute3, hr_api.g_varchar2) <>

602: nvl(per_rei_shd.g_old_rec.cei_attribute1, hr_api.g_varchar2) <>
603: nvl(p_rec.cei_attribute1, hr_api.g_varchar2) or
604: nvl(per_rei_shd.g_old_rec.cei_attribute2, hr_api.g_varchar2) <>
605: nvl(p_rec.cei_attribute2, hr_api.g_varchar2) or
606: nvl(per_rei_shd.g_old_rec.cei_attribute3, hr_api.g_varchar2) <>
607: nvl(p_rec.cei_attribute3, hr_api.g_varchar2) or
608: nvl(per_rei_shd.g_old_rec.cei_attribute4, hr_api.g_varchar2) <>
609: nvl(p_rec.cei_attribute4, hr_api.g_varchar2) or
610: nvl(per_rei_shd.g_old_rec.cei_attribute5, hr_api.g_varchar2) <>

Line 608: nvl(per_rei_shd.g_old_rec.cei_attribute4, hr_api.g_varchar2) <>

604: nvl(per_rei_shd.g_old_rec.cei_attribute2, hr_api.g_varchar2) <>
605: nvl(p_rec.cei_attribute2, hr_api.g_varchar2) or
606: nvl(per_rei_shd.g_old_rec.cei_attribute3, hr_api.g_varchar2) <>
607: nvl(p_rec.cei_attribute3, hr_api.g_varchar2) or
608: nvl(per_rei_shd.g_old_rec.cei_attribute4, hr_api.g_varchar2) <>
609: nvl(p_rec.cei_attribute4, hr_api.g_varchar2) or
610: nvl(per_rei_shd.g_old_rec.cei_attribute5, hr_api.g_varchar2) <>
611: nvl(p_rec.cei_attribute5, hr_api.g_varchar2) or
612: nvl(per_rei_shd.g_old_rec.cei_attribute6, hr_api.g_varchar2) <>

Line 610: nvl(per_rei_shd.g_old_rec.cei_attribute5, hr_api.g_varchar2) <>

606: nvl(per_rei_shd.g_old_rec.cei_attribute3, hr_api.g_varchar2) <>
607: nvl(p_rec.cei_attribute3, hr_api.g_varchar2) or
608: nvl(per_rei_shd.g_old_rec.cei_attribute4, hr_api.g_varchar2) <>
609: nvl(p_rec.cei_attribute4, hr_api.g_varchar2) or
610: nvl(per_rei_shd.g_old_rec.cei_attribute5, hr_api.g_varchar2) <>
611: nvl(p_rec.cei_attribute5, hr_api.g_varchar2) or
612: nvl(per_rei_shd.g_old_rec.cei_attribute6, hr_api.g_varchar2) <>
613: nvl(p_rec.cei_attribute6, hr_api.g_varchar2) or
614: nvl(per_rei_shd.g_old_rec.cei_attribute7, hr_api.g_varchar2) <>

Line 612: nvl(per_rei_shd.g_old_rec.cei_attribute6, hr_api.g_varchar2) <>

608: nvl(per_rei_shd.g_old_rec.cei_attribute4, hr_api.g_varchar2) <>
609: nvl(p_rec.cei_attribute4, hr_api.g_varchar2) or
610: nvl(per_rei_shd.g_old_rec.cei_attribute5, hr_api.g_varchar2) <>
611: nvl(p_rec.cei_attribute5, hr_api.g_varchar2) or
612: nvl(per_rei_shd.g_old_rec.cei_attribute6, hr_api.g_varchar2) <>
613: nvl(p_rec.cei_attribute6, hr_api.g_varchar2) or
614: nvl(per_rei_shd.g_old_rec.cei_attribute7, hr_api.g_varchar2) <>
615: nvl(p_rec.cei_attribute7, hr_api.g_varchar2) or
616: nvl(per_rei_shd.g_old_rec.cei_attribute8, hr_api.g_varchar2) <>

Line 614: nvl(per_rei_shd.g_old_rec.cei_attribute7, hr_api.g_varchar2) <>

610: nvl(per_rei_shd.g_old_rec.cei_attribute5, hr_api.g_varchar2) <>
611: nvl(p_rec.cei_attribute5, hr_api.g_varchar2) or
612: nvl(per_rei_shd.g_old_rec.cei_attribute6, hr_api.g_varchar2) <>
613: nvl(p_rec.cei_attribute6, hr_api.g_varchar2) or
614: nvl(per_rei_shd.g_old_rec.cei_attribute7, hr_api.g_varchar2) <>
615: nvl(p_rec.cei_attribute7, hr_api.g_varchar2) or
616: nvl(per_rei_shd.g_old_rec.cei_attribute8, hr_api.g_varchar2) <>
617: nvl(p_rec.cei_attribute8, hr_api.g_varchar2) or
618: nvl(per_rei_shd.g_old_rec.cei_attribute9, hr_api.g_varchar2) <>

Line 616: nvl(per_rei_shd.g_old_rec.cei_attribute8, hr_api.g_varchar2) <>

612: nvl(per_rei_shd.g_old_rec.cei_attribute6, hr_api.g_varchar2) <>
613: nvl(p_rec.cei_attribute6, hr_api.g_varchar2) or
614: nvl(per_rei_shd.g_old_rec.cei_attribute7, hr_api.g_varchar2) <>
615: nvl(p_rec.cei_attribute7, hr_api.g_varchar2) or
616: nvl(per_rei_shd.g_old_rec.cei_attribute8, hr_api.g_varchar2) <>
617: nvl(p_rec.cei_attribute8, hr_api.g_varchar2) or
618: nvl(per_rei_shd.g_old_rec.cei_attribute9, hr_api.g_varchar2) <>
619: nvl(p_rec.cei_attribute9, hr_api.g_varchar2) or
620: nvl(per_rei_shd.g_old_rec.cei_attribute10, hr_api.g_varchar2) <>

Line 618: nvl(per_rei_shd.g_old_rec.cei_attribute9, hr_api.g_varchar2) <>

614: nvl(per_rei_shd.g_old_rec.cei_attribute7, hr_api.g_varchar2) <>
615: nvl(p_rec.cei_attribute7, hr_api.g_varchar2) or
616: nvl(per_rei_shd.g_old_rec.cei_attribute8, hr_api.g_varchar2) <>
617: nvl(p_rec.cei_attribute8, hr_api.g_varchar2) or
618: nvl(per_rei_shd.g_old_rec.cei_attribute9, hr_api.g_varchar2) <>
619: nvl(p_rec.cei_attribute9, hr_api.g_varchar2) or
620: nvl(per_rei_shd.g_old_rec.cei_attribute10, hr_api.g_varchar2) <>
621: nvl(p_rec.cei_attribute10, hr_api.g_varchar2) or
622: nvl(per_rei_shd.g_old_rec.cei_attribute11, hr_api.g_varchar2) <>

Line 620: nvl(per_rei_shd.g_old_rec.cei_attribute10, hr_api.g_varchar2) <>

616: nvl(per_rei_shd.g_old_rec.cei_attribute8, hr_api.g_varchar2) <>
617: nvl(p_rec.cei_attribute8, hr_api.g_varchar2) or
618: nvl(per_rei_shd.g_old_rec.cei_attribute9, hr_api.g_varchar2) <>
619: nvl(p_rec.cei_attribute9, hr_api.g_varchar2) or
620: nvl(per_rei_shd.g_old_rec.cei_attribute10, hr_api.g_varchar2) <>
621: nvl(p_rec.cei_attribute10, hr_api.g_varchar2) or
622: nvl(per_rei_shd.g_old_rec.cei_attribute11, hr_api.g_varchar2) <>
623: nvl(p_rec.cei_attribute11, hr_api.g_varchar2) or
624: nvl(per_rei_shd.g_old_rec.cei_attribute12, hr_api.g_varchar2) <>

Line 622: nvl(per_rei_shd.g_old_rec.cei_attribute11, hr_api.g_varchar2) <>

618: nvl(per_rei_shd.g_old_rec.cei_attribute9, hr_api.g_varchar2) <>
619: nvl(p_rec.cei_attribute9, hr_api.g_varchar2) or
620: nvl(per_rei_shd.g_old_rec.cei_attribute10, hr_api.g_varchar2) <>
621: nvl(p_rec.cei_attribute10, hr_api.g_varchar2) or
622: nvl(per_rei_shd.g_old_rec.cei_attribute11, hr_api.g_varchar2) <>
623: nvl(p_rec.cei_attribute11, hr_api.g_varchar2) or
624: nvl(per_rei_shd.g_old_rec.cei_attribute12, hr_api.g_varchar2) <>
625: nvl(p_rec.cei_attribute12, hr_api.g_varchar2) or
626: nvl(per_rei_shd.g_old_rec.cei_attribute13, hr_api.g_varchar2) <>

Line 624: nvl(per_rei_shd.g_old_rec.cei_attribute12, hr_api.g_varchar2) <>

620: nvl(per_rei_shd.g_old_rec.cei_attribute10, hr_api.g_varchar2) <>
621: nvl(p_rec.cei_attribute10, hr_api.g_varchar2) or
622: nvl(per_rei_shd.g_old_rec.cei_attribute11, hr_api.g_varchar2) <>
623: nvl(p_rec.cei_attribute11, hr_api.g_varchar2) or
624: nvl(per_rei_shd.g_old_rec.cei_attribute12, hr_api.g_varchar2) <>
625: nvl(p_rec.cei_attribute12, hr_api.g_varchar2) or
626: nvl(per_rei_shd.g_old_rec.cei_attribute13, hr_api.g_varchar2) <>
627: nvl(p_rec.cei_attribute13, hr_api.g_varchar2) or
628: nvl(per_rei_shd.g_old_rec.cei_attribute14, hr_api.g_varchar2) <>

Line 626: nvl(per_rei_shd.g_old_rec.cei_attribute13, hr_api.g_varchar2) <>

622: nvl(per_rei_shd.g_old_rec.cei_attribute11, hr_api.g_varchar2) <>
623: nvl(p_rec.cei_attribute11, hr_api.g_varchar2) or
624: nvl(per_rei_shd.g_old_rec.cei_attribute12, hr_api.g_varchar2) <>
625: nvl(p_rec.cei_attribute12, hr_api.g_varchar2) or
626: nvl(per_rei_shd.g_old_rec.cei_attribute13, hr_api.g_varchar2) <>
627: nvl(p_rec.cei_attribute13, hr_api.g_varchar2) or
628: nvl(per_rei_shd.g_old_rec.cei_attribute14, hr_api.g_varchar2) <>
629: nvl(p_rec.cei_attribute14, hr_api.g_varchar2) or
630: nvl(per_rei_shd.g_old_rec.cei_attribute15, hr_api.g_varchar2) <>

Line 628: nvl(per_rei_shd.g_old_rec.cei_attribute14, hr_api.g_varchar2) <>

624: nvl(per_rei_shd.g_old_rec.cei_attribute12, hr_api.g_varchar2) <>
625: nvl(p_rec.cei_attribute12, hr_api.g_varchar2) or
626: nvl(per_rei_shd.g_old_rec.cei_attribute13, hr_api.g_varchar2) <>
627: nvl(p_rec.cei_attribute13, hr_api.g_varchar2) or
628: nvl(per_rei_shd.g_old_rec.cei_attribute14, hr_api.g_varchar2) <>
629: nvl(p_rec.cei_attribute14, hr_api.g_varchar2) or
630: nvl(per_rei_shd.g_old_rec.cei_attribute15, hr_api.g_varchar2) <>
631: nvl(p_rec.cei_attribute15, hr_api.g_varchar2) or
632: nvl(per_rei_shd.g_old_rec.cei_attribute16, hr_api.g_varchar2) <>

Line 630: nvl(per_rei_shd.g_old_rec.cei_attribute15, hr_api.g_varchar2) <>

626: nvl(per_rei_shd.g_old_rec.cei_attribute13, hr_api.g_varchar2) <>
627: nvl(p_rec.cei_attribute13, hr_api.g_varchar2) or
628: nvl(per_rei_shd.g_old_rec.cei_attribute14, hr_api.g_varchar2) <>
629: nvl(p_rec.cei_attribute14, hr_api.g_varchar2) or
630: nvl(per_rei_shd.g_old_rec.cei_attribute15, hr_api.g_varchar2) <>
631: nvl(p_rec.cei_attribute15, hr_api.g_varchar2) or
632: nvl(per_rei_shd.g_old_rec.cei_attribute16, hr_api.g_varchar2) <>
633: nvl(p_rec.cei_attribute16, hr_api.g_varchar2) or
634: nvl(per_rei_shd.g_old_rec.cei_attribute17, hr_api.g_varchar2) <>

Line 632: nvl(per_rei_shd.g_old_rec.cei_attribute16, hr_api.g_varchar2) <>

628: nvl(per_rei_shd.g_old_rec.cei_attribute14, hr_api.g_varchar2) <>
629: nvl(p_rec.cei_attribute14, hr_api.g_varchar2) or
630: nvl(per_rei_shd.g_old_rec.cei_attribute15, hr_api.g_varchar2) <>
631: nvl(p_rec.cei_attribute15, hr_api.g_varchar2) or
632: nvl(per_rei_shd.g_old_rec.cei_attribute16, hr_api.g_varchar2) <>
633: nvl(p_rec.cei_attribute16, hr_api.g_varchar2) or
634: nvl(per_rei_shd.g_old_rec.cei_attribute17, hr_api.g_varchar2) <>
635: nvl(p_rec.cei_attribute17, hr_api.g_varchar2) or
636: nvl(per_rei_shd.g_old_rec.cei_attribute18, hr_api.g_varchar2) <>

Line 634: nvl(per_rei_shd.g_old_rec.cei_attribute17, hr_api.g_varchar2) <>

630: nvl(per_rei_shd.g_old_rec.cei_attribute15, hr_api.g_varchar2) <>
631: nvl(p_rec.cei_attribute15, hr_api.g_varchar2) or
632: nvl(per_rei_shd.g_old_rec.cei_attribute16, hr_api.g_varchar2) <>
633: nvl(p_rec.cei_attribute16, hr_api.g_varchar2) or
634: nvl(per_rei_shd.g_old_rec.cei_attribute17, hr_api.g_varchar2) <>
635: nvl(p_rec.cei_attribute17, hr_api.g_varchar2) or
636: nvl(per_rei_shd.g_old_rec.cei_attribute18, hr_api.g_varchar2) <>
637: nvl(p_rec.cei_attribute18, hr_api.g_varchar2) or
638: nvl(per_rei_shd.g_old_rec.cei_attribute19, hr_api.g_varchar2) <>

Line 636: nvl(per_rei_shd.g_old_rec.cei_attribute18, hr_api.g_varchar2) <>

632: nvl(per_rei_shd.g_old_rec.cei_attribute16, hr_api.g_varchar2) <>
633: nvl(p_rec.cei_attribute16, hr_api.g_varchar2) or
634: nvl(per_rei_shd.g_old_rec.cei_attribute17, hr_api.g_varchar2) <>
635: nvl(p_rec.cei_attribute17, hr_api.g_varchar2) or
636: nvl(per_rei_shd.g_old_rec.cei_attribute18, hr_api.g_varchar2) <>
637: nvl(p_rec.cei_attribute18, hr_api.g_varchar2) or
638: nvl(per_rei_shd.g_old_rec.cei_attribute19, hr_api.g_varchar2) <>
639: nvl(p_rec.cei_attribute19, hr_api.g_varchar2) or
640: nvl(per_rei_shd.g_old_rec.cei_attribute20, hr_api.g_varchar2) <>

Line 638: nvl(per_rei_shd.g_old_rec.cei_attribute19, hr_api.g_varchar2) <>

634: nvl(per_rei_shd.g_old_rec.cei_attribute17, hr_api.g_varchar2) <>
635: nvl(p_rec.cei_attribute17, hr_api.g_varchar2) or
636: nvl(per_rei_shd.g_old_rec.cei_attribute18, hr_api.g_varchar2) <>
637: nvl(p_rec.cei_attribute18, hr_api.g_varchar2) or
638: nvl(per_rei_shd.g_old_rec.cei_attribute19, hr_api.g_varchar2) <>
639: nvl(p_rec.cei_attribute19, hr_api.g_varchar2) or
640: nvl(per_rei_shd.g_old_rec.cei_attribute20, hr_api.g_varchar2) <>
641: nvl(p_rec.cei_attribute20, hr_api.g_varchar2) ))
642: or (p_rec.contact_extra_info_id is null) then

Line 640: nvl(per_rei_shd.g_old_rec.cei_attribute20, hr_api.g_varchar2) <>

636: nvl(per_rei_shd.g_old_rec.cei_attribute18, hr_api.g_varchar2) <>
637: nvl(p_rec.cei_attribute18, hr_api.g_varchar2) or
638: nvl(per_rei_shd.g_old_rec.cei_attribute19, hr_api.g_varchar2) <>
639: nvl(p_rec.cei_attribute19, hr_api.g_varchar2) or
640: nvl(per_rei_shd.g_old_rec.cei_attribute20, hr_api.g_varchar2) <>
641: nvl(p_rec.cei_attribute20, hr_api.g_varchar2) ))
642: or (p_rec.contact_extra_info_id is null) then
643: --
644: -- Only execute the validation if absolutely necessary:

Line 730: ,p_rec in per_rei_shd.g_rec_type

726: -- {End Of Comments}
727: -- ----------------------------------------------------------------------------
728: Procedure chk_non_updateable_args
729: (p_effective_date in date
730: ,p_rec in per_rei_shd.g_rec_type
731: ) IS
732: --
733: l_argument VARCHAR2(30);
734: l_error EXCEPTION;

Line 743: IF NOT per_rei_shd.api_updating

739: --
740: -- Only proceed with the validation if a row exists for the current
741: -- record in the HR Schema.
742: --
743: IF NOT per_rei_shd.api_updating
744: (p_contact_extra_info_id => p_rec.contact_extra_info_id
745: ,p_effective_date => p_effective_date
746: ,p_object_version_number => p_rec.object_version_number
747: ) THEN

Line 759: NVL(per_rei_shd.g_old_rec.contact_relationship_id, hr_api.g_number) THEN

755: -- Raise an error when contact_relationship_id is updated.
756: --
757: hr_utility.set_location(l_proc, 20);
758: IF NVL(p_rec.contact_relationship_id, hr_api.g_number) <>
759: NVL(per_rei_shd.g_old_rec.contact_relationship_id, hr_api.g_number) THEN
760: --
761: l_argument := 'contact_relationship_id';
762: RAISE l_error;
763: END IF;

Line 770: NVL(per_rei_shd.g_old_rec.information_type, hr_api.g_varchar2) THEN

766: -- Raise an error when information_type is updated.
767: --
768: hr_utility.set_location(l_proc, 30);
769: IF NVL(p_rec.information_type, hr_api.g_varchar2) <>
770: NVL(per_rei_shd.g_old_rec.information_type, hr_api.g_varchar2) THEN
771: --
772: l_argument := 'information_type';
773: RAISE l_error;
774: END IF;

Line 781: NVL(per_rei_shd.g_old_rec.cei_information_category, hr_api.g_varchar2) THEN

777: -- Raise an error when information_type is updated.
778: --
779: hr_utility.set_location(l_proc, 40);
780: IF NVL(p_rec.cei_information_category, hr_api.g_varchar2) <>
781: NVL(per_rei_shd.g_old_rec.cei_information_category, hr_api.g_varchar2) THEN
782: --
783: l_argument := 'cei_information_category';
784: RAISE l_error;
785: END IF;

Line 980: (p_rec in per_rei_shd.g_rec_type

976: -- ----------------------------------------------------------------------------
977: -- |---------------------------< insert_validate >----------------------------|
978: -- ----------------------------------------------------------------------------
979: Procedure insert_validate
980: (p_rec in per_rei_shd.g_rec_type
981: ,p_effective_date in date
982: ,p_datetrack_mode in varchar2
983: ,p_validation_start_date in date
984: ,p_validation_end_date in out nocopy date

Line 1018: IF per_rei_shd.g_called_from_form = FALSE THEN

1014: p_validation_end_date => p_validation_end_date);
1015: --
1016: -- Skip descriptive flexfield validation when the API is called from form.
1017: --
1018: IF per_rei_shd.g_called_from_form = FALSE THEN
1019: hr_utility.set_location(l_proc, 10);
1020: --
1021: -- Bug.2770089
1022: -- Support dynamic profile option "PER_CONTACT_RELATIONSHIP_ID"

Line 1046: (p_rec in per_rei_shd.g_rec_type

1042: -- ----------------------------------------------------------------------------
1043: -- |---------------------------< update_validate >----------------------------|
1044: -- ----------------------------------------------------------------------------
1045: Procedure update_validate
1046: (p_rec in per_rei_shd.g_rec_type
1047: ,p_effective_date in date
1048: ,p_datetrack_mode in varchar2
1049: ,p_validation_start_date in date
1050: ,p_validation_end_date in date

Line 1083: IF per_rei_shd.g_called_from_form = FALSE THEN

1079: );
1080: --
1081: -- Skip descriptive flexfield validation when the API is called from form.
1082: --
1083: IF per_rei_shd.g_called_from_form = FALSE THEN
1084: hr_utility.set_location(l_proc, 7);
1085: --
1086: -- Bug.2770089
1087: -- Support dynamic profile option "PER_CONTACT_RELATIONSHIP_ID"

Line 1111: (p_rec in per_rei_shd.g_rec_type

1107: -- ----------------------------------------------------------------------------
1108: -- |---------------------------< delete_validate >----------------------------|
1109: -- ----------------------------------------------------------------------------
1110: Procedure delete_validate
1111: (p_rec in per_rei_shd.g_rec_type
1112: ,p_effective_date in date
1113: ,p_datetrack_mode in varchar2
1114: ,p_validation_start_date in date
1115: ,p_validation_end_date in out nocopy date

Line 1137: p_information_type => per_rei_shd.g_old_rec.information_type,

1133: -- This is non-updatable argument, but needs to validate
1134: -- whether this information is unique when information_type is multiple entries not allowed.
1135: --
1136: per_rei_bus.chk_information_type(
1137: p_information_type => per_rei_shd.g_old_rec.information_type,
1138: p_datetrack_mode => p_datetrack_mode,
1139: p_contact_relationship_id => per_rei_shd.g_old_rec.contact_relationship_id,
1140: p_contact_extra_info_id => p_rec.contact_extra_info_id,
1141: p_validation_start_date => p_validation_start_date,

Line 1139: p_contact_relationship_id => per_rei_shd.g_old_rec.contact_relationship_id,

1135: --
1136: per_rei_bus.chk_information_type(
1137: p_information_type => per_rei_shd.g_old_rec.information_type,
1138: p_datetrack_mode => p_datetrack_mode,
1139: p_contact_relationship_id => per_rei_shd.g_old_rec.contact_relationship_id,
1140: p_contact_extra_info_id => p_rec.contact_extra_info_id,
1141: p_validation_start_date => p_validation_start_date,
1142: p_validation_end_date => p_validation_end_date);
1143: --