APPS.PER_CHK_BUS dependencies on PER_CHK_SHD

Line 179: ,p_rec in per_chk_shd.g_rec_type) is

175: -- Access Status:
176: -- Internal Table Handler Use Only.
177: --
178: Procedure chk_non_updateable_args( p_effective_date in date
179: ,p_rec in per_chk_shd.g_rec_type) is
180: --
181: l_proc varchar2(72) := g_package||'chk_non_updateable_args';
182: l_error exception;
183: l_argument varchar2(30);

Line 191: if not per_chk_shd.api_updating

187: --
188: -- Only proceed with validation if a row exists for
189: -- the current record in the HR Schema
190: --
191: if not per_chk_shd.api_updating
192: (p_checklist_item_id => p_rec.checklist_item_id,
193: p_object_version_number => p_rec.object_version_number) then
194: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
195: fnd_message.set_token('PROCEDURE', l_proc);

Line 202: <> nvl(per_chk_shd.g_old_rec.checklist_item_id,hr_api.g_number) then

198: --
199: hr_utility.set_location(l_proc, 6);
200: --
201: if nvl(p_rec.checklist_item_id,hr_api.g_number)
202: <> nvl(per_chk_shd.g_old_rec.checklist_item_id,hr_api.g_number) then
203: l_argument := 'checklist_item_id';
204: raise l_error;
205: end if;
206: hr_utility.set_location(l_proc, 7);

Line 209: <> nvl(per_chk_shd.g_old_rec.person_id,hr_api.g_number) then

205: end if;
206: hr_utility.set_location(l_proc, 7);
207: --
208: if nvl(p_rec.person_id,hr_api.g_number)
209: <> nvl(per_chk_shd.g_old_rec.person_id,hr_api.g_number) then
210: l_argument := 'person_id';
211: raise l_error;
212: end if;
213: hr_utility.set_location(l_proc, 8);

Line 216: <> nvl(per_chk_shd.g_old_rec.item_code,hr_api.g_varchar2) then

212: end if;
213: hr_utility.set_location(l_proc, 8);
214: --
215: if nvl(p_rec.item_code,hr_api.g_varchar2)
216: <> nvl(per_chk_shd.g_old_rec.item_code,hr_api.g_varchar2) then
217: l_argument := 'item_code';
218: raise l_error;
219: end if;
220: hr_utility.set_location(l_proc, 9);

Line 322: (nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)

318: --
319: hr_utility.set_location('Entering:'||l_proc, 5);
320: --
321: if (p_checklist_item_id is not null and p_status is not null and
322: (nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
323: <> nvl(p_status,hr_api.g_varchar2)))
324: or ( p_checklist_item_id is null and p_status is not null)
325: then
326:

Line 425: (p_rec in per_chk_shd.g_rec_type

421: -- Internal Row Handler Use Only.
422: --
423: -- ---------------------------------------------------------------------------
424: procedure chk_df
425: (p_rec in per_chk_shd.g_rec_type
426: ,p_validate_df_flex in boolean default true) is
427: --
428: l_proc varchar2(72) := g_package||'chk_df';
429: --

Line 489: ( (nvl(per_chk_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

485: --
486: --
487: If ( (p_rec.checklist_item_id is not null)
488: and
489: ( (nvl(per_chk_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
490: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
491: nvl(per_chk_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
492: nvl(p_rec.attribute1, hr_api.g_varchar2) or
493: nvl(per_chk_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

Line 491: nvl(per_chk_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

487: If ( (p_rec.checklist_item_id is not null)
488: and
489: ( (nvl(per_chk_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
490: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
491: nvl(per_chk_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
492: nvl(p_rec.attribute1, hr_api.g_varchar2) or
493: nvl(per_chk_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
494: nvl(p_rec.attribute2, hr_api.g_varchar2) or
495: nvl(per_chk_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

Line 493: nvl(per_chk_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

489: ( (nvl(per_chk_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
490: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
491: nvl(per_chk_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
492: nvl(p_rec.attribute1, hr_api.g_varchar2) or
493: nvl(per_chk_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
494: nvl(p_rec.attribute2, hr_api.g_varchar2) or
495: nvl(per_chk_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
496: nvl(p_rec.attribute3, hr_api.g_varchar2) or
497: nvl(per_chk_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

Line 495: nvl(per_chk_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

491: nvl(per_chk_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
492: nvl(p_rec.attribute1, hr_api.g_varchar2) or
493: nvl(per_chk_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
494: nvl(p_rec.attribute2, hr_api.g_varchar2) or
495: nvl(per_chk_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
496: nvl(p_rec.attribute3, hr_api.g_varchar2) or
497: nvl(per_chk_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
498: nvl(p_rec.attribute4, hr_api.g_varchar2) or
499: nvl(per_chk_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

Line 497: nvl(per_chk_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

493: nvl(per_chk_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
494: nvl(p_rec.attribute2, hr_api.g_varchar2) or
495: nvl(per_chk_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
496: nvl(p_rec.attribute3, hr_api.g_varchar2) or
497: nvl(per_chk_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
498: nvl(p_rec.attribute4, hr_api.g_varchar2) or
499: nvl(per_chk_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
500: nvl(p_rec.attribute5, hr_api.g_varchar2) or
501: nvl(per_chk_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

Line 499: nvl(per_chk_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

495: nvl(per_chk_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
496: nvl(p_rec.attribute3, hr_api.g_varchar2) or
497: nvl(per_chk_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
498: nvl(p_rec.attribute4, hr_api.g_varchar2) or
499: nvl(per_chk_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
500: nvl(p_rec.attribute5, hr_api.g_varchar2) or
501: nvl(per_chk_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
502: nvl(p_rec.attribute6, hr_api.g_varchar2) or
503: nvl(per_chk_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

Line 501: nvl(per_chk_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

497: nvl(per_chk_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
498: nvl(p_rec.attribute4, hr_api.g_varchar2) or
499: nvl(per_chk_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
500: nvl(p_rec.attribute5, hr_api.g_varchar2) or
501: nvl(per_chk_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
502: nvl(p_rec.attribute6, hr_api.g_varchar2) or
503: nvl(per_chk_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
504: nvl(p_rec.attribute7, hr_api.g_varchar2) or
505: nvl(per_chk_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

Line 503: nvl(per_chk_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

499: nvl(per_chk_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
500: nvl(p_rec.attribute5, hr_api.g_varchar2) or
501: nvl(per_chk_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
502: nvl(p_rec.attribute6, hr_api.g_varchar2) or
503: nvl(per_chk_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
504: nvl(p_rec.attribute7, hr_api.g_varchar2) or
505: nvl(per_chk_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
506: nvl(p_rec.attribute8, hr_api.g_varchar2) or
507: nvl(per_chk_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

Line 505: nvl(per_chk_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

501: nvl(per_chk_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
502: nvl(p_rec.attribute6, hr_api.g_varchar2) or
503: nvl(per_chk_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
504: nvl(p_rec.attribute7, hr_api.g_varchar2) or
505: nvl(per_chk_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
506: nvl(p_rec.attribute8, hr_api.g_varchar2) or
507: nvl(per_chk_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
508: nvl(p_rec.attribute9, hr_api.g_varchar2) or
509: nvl(per_chk_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

Line 507: nvl(per_chk_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

503: nvl(per_chk_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
504: nvl(p_rec.attribute7, hr_api.g_varchar2) or
505: nvl(per_chk_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
506: nvl(p_rec.attribute8, hr_api.g_varchar2) or
507: nvl(per_chk_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
508: nvl(p_rec.attribute9, hr_api.g_varchar2) or
509: nvl(per_chk_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
510: nvl(p_rec.attribute10, hr_api.g_varchar2) or
511: nvl(per_chk_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

Line 509: nvl(per_chk_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

505: nvl(per_chk_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
506: nvl(p_rec.attribute8, hr_api.g_varchar2) or
507: nvl(per_chk_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
508: nvl(p_rec.attribute9, hr_api.g_varchar2) or
509: nvl(per_chk_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
510: nvl(p_rec.attribute10, hr_api.g_varchar2) or
511: nvl(per_chk_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
512: nvl(p_rec.attribute11, hr_api.g_varchar2) or
513: nvl(per_chk_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

Line 511: nvl(per_chk_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

507: nvl(per_chk_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
508: nvl(p_rec.attribute9, hr_api.g_varchar2) or
509: nvl(per_chk_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
510: nvl(p_rec.attribute10, hr_api.g_varchar2) or
511: nvl(per_chk_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
512: nvl(p_rec.attribute11, hr_api.g_varchar2) or
513: nvl(per_chk_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
514: nvl(p_rec.attribute12, hr_api.g_varchar2) or
515: nvl(per_chk_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

Line 513: nvl(per_chk_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

509: nvl(per_chk_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
510: nvl(p_rec.attribute10, hr_api.g_varchar2) or
511: nvl(per_chk_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
512: nvl(p_rec.attribute11, hr_api.g_varchar2) or
513: nvl(per_chk_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
514: nvl(p_rec.attribute12, hr_api.g_varchar2) or
515: nvl(per_chk_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
516: nvl(p_rec.attribute13, hr_api.g_varchar2) or
517: nvl(per_chk_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

Line 515: nvl(per_chk_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

511: nvl(per_chk_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
512: nvl(p_rec.attribute11, hr_api.g_varchar2) or
513: nvl(per_chk_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
514: nvl(p_rec.attribute12, hr_api.g_varchar2) or
515: nvl(per_chk_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
516: nvl(p_rec.attribute13, hr_api.g_varchar2) or
517: nvl(per_chk_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
518: nvl(p_rec.attribute14, hr_api.g_varchar2) or
519: nvl(per_chk_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

Line 517: nvl(per_chk_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

513: nvl(per_chk_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
514: nvl(p_rec.attribute12, hr_api.g_varchar2) or
515: nvl(per_chk_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
516: nvl(p_rec.attribute13, hr_api.g_varchar2) or
517: nvl(per_chk_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
518: nvl(p_rec.attribute14, hr_api.g_varchar2) or
519: nvl(per_chk_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
520: nvl(p_rec.attribute15, hr_api.g_varchar2) or
521: nvl(per_chk_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

Line 519: nvl(per_chk_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

515: nvl(per_chk_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
516: nvl(p_rec.attribute13, hr_api.g_varchar2) or
517: nvl(per_chk_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
518: nvl(p_rec.attribute14, hr_api.g_varchar2) or
519: nvl(per_chk_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
520: nvl(p_rec.attribute15, hr_api.g_varchar2) or
521: nvl(per_chk_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
522: nvl(p_rec.attribute16, hr_api.g_varchar2) or
523: nvl(per_chk_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

Line 521: nvl(per_chk_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

517: nvl(per_chk_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
518: nvl(p_rec.attribute14, hr_api.g_varchar2) or
519: nvl(per_chk_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
520: nvl(p_rec.attribute15, hr_api.g_varchar2) or
521: nvl(per_chk_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
522: nvl(p_rec.attribute16, hr_api.g_varchar2) or
523: nvl(per_chk_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
524: nvl(p_rec.attribute17, hr_api.g_varchar2) or
525: nvl(per_chk_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

Line 523: nvl(per_chk_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

519: nvl(per_chk_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
520: nvl(p_rec.attribute15, hr_api.g_varchar2) or
521: nvl(per_chk_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
522: nvl(p_rec.attribute16, hr_api.g_varchar2) or
523: nvl(per_chk_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
524: nvl(p_rec.attribute17, hr_api.g_varchar2) or
525: nvl(per_chk_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
526: nvl(p_rec.attribute18, hr_api.g_varchar2) or
527: nvl(per_chk_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

Line 525: nvl(per_chk_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

521: nvl(per_chk_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
522: nvl(p_rec.attribute16, hr_api.g_varchar2) or
523: nvl(per_chk_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
524: nvl(p_rec.attribute17, hr_api.g_varchar2) or
525: nvl(per_chk_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
526: nvl(p_rec.attribute18, hr_api.g_varchar2) or
527: nvl(per_chk_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
528: nvl(p_rec.attribute19, hr_api.g_varchar2) or
529: nvl(per_chk_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

Line 527: nvl(per_chk_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

523: nvl(per_chk_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
524: nvl(p_rec.attribute17, hr_api.g_varchar2) or
525: nvl(per_chk_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
526: nvl(p_rec.attribute18, hr_api.g_varchar2) or
527: nvl(per_chk_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
528: nvl(p_rec.attribute19, hr_api.g_varchar2) or
529: nvl(per_chk_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
530: nvl(p_rec.attribute20, hr_api.g_varchar2) or
531: nvl(per_chk_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>

Line 529: nvl(per_chk_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

525: nvl(per_chk_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
526: nvl(p_rec.attribute18, hr_api.g_varchar2) or
527: nvl(per_chk_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
528: nvl(p_rec.attribute19, hr_api.g_varchar2) or
529: nvl(per_chk_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
530: nvl(p_rec.attribute20, hr_api.g_varchar2) or
531: nvl(per_chk_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
532: nvl(p_rec.attribute21, hr_api.g_varchar2) or
533: nvl(per_chk_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>

Line 531: nvl(per_chk_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>

527: nvl(per_chk_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
528: nvl(p_rec.attribute19, hr_api.g_varchar2) or
529: nvl(per_chk_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
530: nvl(p_rec.attribute20, hr_api.g_varchar2) or
531: nvl(per_chk_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
532: nvl(p_rec.attribute21, hr_api.g_varchar2) or
533: nvl(per_chk_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
534: nvl(p_rec.attribute22, hr_api.g_varchar2) or
535: nvl(per_chk_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>

Line 533: nvl(per_chk_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>

529: nvl(per_chk_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
530: nvl(p_rec.attribute20, hr_api.g_varchar2) or
531: nvl(per_chk_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
532: nvl(p_rec.attribute21, hr_api.g_varchar2) or
533: nvl(per_chk_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
534: nvl(p_rec.attribute22, hr_api.g_varchar2) or
535: nvl(per_chk_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
536: nvl(p_rec.attribute23, hr_api.g_varchar2) or
537: nvl(per_chk_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>

Line 535: nvl(per_chk_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>

531: nvl(per_chk_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
532: nvl(p_rec.attribute21, hr_api.g_varchar2) or
533: nvl(per_chk_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
534: nvl(p_rec.attribute22, hr_api.g_varchar2) or
535: nvl(per_chk_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
536: nvl(p_rec.attribute23, hr_api.g_varchar2) or
537: nvl(per_chk_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
538: nvl(p_rec.attribute24, hr_api.g_varchar2) or
539: nvl(per_chk_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>

Line 537: nvl(per_chk_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>

533: nvl(per_chk_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
534: nvl(p_rec.attribute22, hr_api.g_varchar2) or
535: nvl(per_chk_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
536: nvl(p_rec.attribute23, hr_api.g_varchar2) or
537: nvl(per_chk_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
538: nvl(p_rec.attribute24, hr_api.g_varchar2) or
539: nvl(per_chk_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
540: nvl(p_rec.attribute25, hr_api.g_varchar2) or
541: nvl(per_chk_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>

Line 539: nvl(per_chk_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>

535: nvl(per_chk_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
536: nvl(p_rec.attribute23, hr_api.g_varchar2) or
537: nvl(per_chk_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
538: nvl(p_rec.attribute24, hr_api.g_varchar2) or
539: nvl(per_chk_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
540: nvl(p_rec.attribute25, hr_api.g_varchar2) or
541: nvl(per_chk_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
542: nvl(p_rec.attribute26, hr_api.g_varchar2) or
543: nvl(per_chk_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>

Line 541: nvl(per_chk_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>

537: nvl(per_chk_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
538: nvl(p_rec.attribute24, hr_api.g_varchar2) or
539: nvl(per_chk_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
540: nvl(p_rec.attribute25, hr_api.g_varchar2) or
541: nvl(per_chk_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
542: nvl(p_rec.attribute26, hr_api.g_varchar2) or
543: nvl(per_chk_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
544: nvl(p_rec.attribute27, hr_api.g_varchar2) or
545: nvl(per_chk_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>

Line 543: nvl(per_chk_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>

539: nvl(per_chk_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
540: nvl(p_rec.attribute25, hr_api.g_varchar2) or
541: nvl(per_chk_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
542: nvl(p_rec.attribute26, hr_api.g_varchar2) or
543: nvl(per_chk_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
544: nvl(p_rec.attribute27, hr_api.g_varchar2) or
545: nvl(per_chk_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
546: nvl(p_rec.attribute28, hr_api.g_varchar2) or
547: nvl(per_chk_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>

Line 545: nvl(per_chk_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>

541: nvl(per_chk_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
542: nvl(p_rec.attribute26, hr_api.g_varchar2) or
543: nvl(per_chk_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
544: nvl(p_rec.attribute27, hr_api.g_varchar2) or
545: nvl(per_chk_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
546: nvl(p_rec.attribute28, hr_api.g_varchar2) or
547: nvl(per_chk_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
548: nvl(p_rec.attribute29, hr_api.g_varchar2) or
549: nvl(per_chk_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>

Line 547: nvl(per_chk_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>

543: nvl(per_chk_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
544: nvl(p_rec.attribute27, hr_api.g_varchar2) or
545: nvl(per_chk_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
546: nvl(p_rec.attribute28, hr_api.g_varchar2) or
547: nvl(per_chk_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
548: nvl(p_rec.attribute29, hr_api.g_varchar2) or
549: nvl(per_chk_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
550: nvl(p_rec.attribute30, hr_api.g_varchar2)
551: )

Line 549: nvl(per_chk_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>

545: nvl(per_chk_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
546: nvl(p_rec.attribute28, hr_api.g_varchar2) or
547: nvl(per_chk_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
548: nvl(p_rec.attribute29, hr_api.g_varchar2) or
549: nvl(per_chk_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
550: nvl(p_rec.attribute30, hr_api.g_varchar2)
551: )
552: or
553: (

Line 670: p_rec in per_chk_shd.g_rec_type) is

666: -- ----------------------------------------------------------------------------
667: -- |---------------------------< insert_validate >----------------------------|
668: -- ----------------------------------------------------------------------------
669: Procedure insert_validate(p_effective_date in date,
670: p_rec in per_chk_shd.g_rec_type) is
671: --
672: l_proc varchar2(72) := g_package||'insert_validate';
673: --
674: Begin

Line 747: p_rec in per_chk_shd.g_rec_type) is

743: -- ----------------------------------------------------------------------------
744: -- |---------------------------< update_validate >----------------------------|
745: -- ----------------------------------------------------------------------------
746: Procedure update_validate(p_effective_date in date,
747: p_rec in per_chk_shd.g_rec_type) is
748: --
749: l_proc varchar2(72) := g_package||'update_validate';
750: --
751: Begin

Line 807: Procedure delete_validate(p_rec in per_chk_shd.g_rec_type) is

803: --
804: -- ----------------------------------------------------------------------------
805: -- |---------------------------< delete_validate >----------------------------|
806: -- ----------------------------------------------------------------------------
807: Procedure delete_validate(p_rec in per_chk_shd.g_rec_type) is
808: --
809: l_proc varchar2(72) := g_package||'delete_validate';
810: --
811: Begin