APPS.BEN_PRY_BUS dependencies on BEN_PRY_SHD

Line 156: (p_rec in ben_pry_shd.g_rec_type

152: -- ----------------------------------------------------------------------------
153: --
154: -- ----------------------------------------------------------------------------
155: procedure chk_pymt_amt
156: (p_rec in ben_pry_shd.g_rec_type
157: ,p_effective_date in date
158: ) is
159: --
160: l_proc varchar2(72) := g_package || 'chk_pymt_amt';

Line 383: hr_utility.set_location(' old mount '|| nvl(ben_pry_shd.g_old_rec.aprvd_fr_pymt_amt,0) ,20);

379: end if;
380: end if;
381:
382: hr_utility.set_location(' total for the yr '|| l_rqst_amt ,20);
383: hr_utility.set_location(' old mount '|| nvl(ben_pry_shd.g_old_rec.aprvd_fr_pymt_amt,0) ,20);
384:
385: else
386: --
387: open c_yr_perd (l_popl_yr_perd_id_1);

Line 435: hr_utility.set_location(' old mount '|| nvl(ben_pry_shd.g_old_rec.aprvd_fr_pymt_amt,0) ,22);

431: end if;
432: --
433: end if;
434: hr_utility.set_location(' total for the yr '|| l_rqst_amt ,21);
435: hr_utility.set_location(' old mount '|| nvl(ben_pry_shd.g_old_rec.aprvd_fr_pymt_amt,0) ,22);
436: --
437: if l_amt_year2 is not null then
438: --
439: l_total_pymt_amt := l_total_pymt_amt +

Line 488: if nvl(l_rqst_amt,0) + nvl(p_rec.aprvd_fr_pymt_amt,0)- nvl(ben_pry_shd.g_old_rec.aprvd_fr_pymt_amt,0)

484:
485: end if;
486: --
487:
488: if nvl(l_rqst_amt,0) + nvl(p_rec.aprvd_fr_pymt_amt,0)- nvl(ben_pry_shd.g_old_rec.aprvd_fr_pymt_amt,0)
489: > l_total_pymt_amt then
490:
491: fnd_message.set_name('BEN','BEN_92662_AMT_EXCEEDS_BAL');
492: fnd_message.set_token('BAL', l_total_pymt_amt );

Line 535: (p_rec in ben_pry_shd.g_rec_type

531: -- Internal Row Handler Use Only.
532: --
533: -- ----------------------------------------------------------------------------
534: procedure chk_df
535: (p_rec in ben_pry_shd.g_rec_type
536: ) is
537: --
538: l_proc varchar2(72) := g_package || 'chk_df';
539: --

Line 544: nvl(ben_pry_shd.g_old_rec.pry_attribute_category, hr_api.g_varchar2) <>

540: begin
541: hr_utility.set_location('Entering:'||l_proc,10);
542: --
543: if ((p_rec.prtt_rmt_aprvd_fr_pymt_id is not null) and (
544: nvl(ben_pry_shd.g_old_rec.pry_attribute_category, hr_api.g_varchar2) <>
545: nvl(p_rec.pry_attribute_category, hr_api.g_varchar2) or
546: nvl(ben_pry_shd.g_old_rec.pry_attribute1, hr_api.g_varchar2) <>
547: nvl(p_rec.pry_attribute1, hr_api.g_varchar2) or
548: nvl(ben_pry_shd.g_old_rec.pry_attribute2, hr_api.g_varchar2) <>

Line 546: nvl(ben_pry_shd.g_old_rec.pry_attribute1, hr_api.g_varchar2) <>

542: --
543: if ((p_rec.prtt_rmt_aprvd_fr_pymt_id is not null) and (
544: nvl(ben_pry_shd.g_old_rec.pry_attribute_category, hr_api.g_varchar2) <>
545: nvl(p_rec.pry_attribute_category, hr_api.g_varchar2) or
546: nvl(ben_pry_shd.g_old_rec.pry_attribute1, hr_api.g_varchar2) <>
547: nvl(p_rec.pry_attribute1, hr_api.g_varchar2) or
548: nvl(ben_pry_shd.g_old_rec.pry_attribute2, hr_api.g_varchar2) <>
549: nvl(p_rec.pry_attribute2, hr_api.g_varchar2) or
550: nvl(ben_pry_shd.g_old_rec.pry_attribute3, hr_api.g_varchar2) <>

Line 548: nvl(ben_pry_shd.g_old_rec.pry_attribute2, hr_api.g_varchar2) <>

544: nvl(ben_pry_shd.g_old_rec.pry_attribute_category, hr_api.g_varchar2) <>
545: nvl(p_rec.pry_attribute_category, hr_api.g_varchar2) or
546: nvl(ben_pry_shd.g_old_rec.pry_attribute1, hr_api.g_varchar2) <>
547: nvl(p_rec.pry_attribute1, hr_api.g_varchar2) or
548: nvl(ben_pry_shd.g_old_rec.pry_attribute2, hr_api.g_varchar2) <>
549: nvl(p_rec.pry_attribute2, hr_api.g_varchar2) or
550: nvl(ben_pry_shd.g_old_rec.pry_attribute3, hr_api.g_varchar2) <>
551: nvl(p_rec.pry_attribute3, hr_api.g_varchar2) or
552: nvl(ben_pry_shd.g_old_rec.pry_attribute4, hr_api.g_varchar2) <>

Line 550: nvl(ben_pry_shd.g_old_rec.pry_attribute3, hr_api.g_varchar2) <>

546: nvl(ben_pry_shd.g_old_rec.pry_attribute1, hr_api.g_varchar2) <>
547: nvl(p_rec.pry_attribute1, hr_api.g_varchar2) or
548: nvl(ben_pry_shd.g_old_rec.pry_attribute2, hr_api.g_varchar2) <>
549: nvl(p_rec.pry_attribute2, hr_api.g_varchar2) or
550: nvl(ben_pry_shd.g_old_rec.pry_attribute3, hr_api.g_varchar2) <>
551: nvl(p_rec.pry_attribute3, hr_api.g_varchar2) or
552: nvl(ben_pry_shd.g_old_rec.pry_attribute4, hr_api.g_varchar2) <>
553: nvl(p_rec.pry_attribute4, hr_api.g_varchar2) or
554: nvl(ben_pry_shd.g_old_rec.pry_attribute5, hr_api.g_varchar2) <>

Line 552: nvl(ben_pry_shd.g_old_rec.pry_attribute4, hr_api.g_varchar2) <>

548: nvl(ben_pry_shd.g_old_rec.pry_attribute2, hr_api.g_varchar2) <>
549: nvl(p_rec.pry_attribute2, hr_api.g_varchar2) or
550: nvl(ben_pry_shd.g_old_rec.pry_attribute3, hr_api.g_varchar2) <>
551: nvl(p_rec.pry_attribute3, hr_api.g_varchar2) or
552: nvl(ben_pry_shd.g_old_rec.pry_attribute4, hr_api.g_varchar2) <>
553: nvl(p_rec.pry_attribute4, hr_api.g_varchar2) or
554: nvl(ben_pry_shd.g_old_rec.pry_attribute5, hr_api.g_varchar2) <>
555: nvl(p_rec.pry_attribute5, hr_api.g_varchar2) or
556: nvl(ben_pry_shd.g_old_rec.pry_attribute6, hr_api.g_varchar2) <>

Line 554: nvl(ben_pry_shd.g_old_rec.pry_attribute5, hr_api.g_varchar2) <>

550: nvl(ben_pry_shd.g_old_rec.pry_attribute3, hr_api.g_varchar2) <>
551: nvl(p_rec.pry_attribute3, hr_api.g_varchar2) or
552: nvl(ben_pry_shd.g_old_rec.pry_attribute4, hr_api.g_varchar2) <>
553: nvl(p_rec.pry_attribute4, hr_api.g_varchar2) or
554: nvl(ben_pry_shd.g_old_rec.pry_attribute5, hr_api.g_varchar2) <>
555: nvl(p_rec.pry_attribute5, hr_api.g_varchar2) or
556: nvl(ben_pry_shd.g_old_rec.pry_attribute6, hr_api.g_varchar2) <>
557: nvl(p_rec.pry_attribute6, hr_api.g_varchar2) or
558: nvl(ben_pry_shd.g_old_rec.pry_attribute7, hr_api.g_varchar2) <>

Line 556: nvl(ben_pry_shd.g_old_rec.pry_attribute6, hr_api.g_varchar2) <>

552: nvl(ben_pry_shd.g_old_rec.pry_attribute4, hr_api.g_varchar2) <>
553: nvl(p_rec.pry_attribute4, hr_api.g_varchar2) or
554: nvl(ben_pry_shd.g_old_rec.pry_attribute5, hr_api.g_varchar2) <>
555: nvl(p_rec.pry_attribute5, hr_api.g_varchar2) or
556: nvl(ben_pry_shd.g_old_rec.pry_attribute6, hr_api.g_varchar2) <>
557: nvl(p_rec.pry_attribute6, hr_api.g_varchar2) or
558: nvl(ben_pry_shd.g_old_rec.pry_attribute7, hr_api.g_varchar2) <>
559: nvl(p_rec.pry_attribute7, hr_api.g_varchar2) or
560: nvl(ben_pry_shd.g_old_rec.pry_attribute8, hr_api.g_varchar2) <>

Line 558: nvl(ben_pry_shd.g_old_rec.pry_attribute7, hr_api.g_varchar2) <>

554: nvl(ben_pry_shd.g_old_rec.pry_attribute5, hr_api.g_varchar2) <>
555: nvl(p_rec.pry_attribute5, hr_api.g_varchar2) or
556: nvl(ben_pry_shd.g_old_rec.pry_attribute6, hr_api.g_varchar2) <>
557: nvl(p_rec.pry_attribute6, hr_api.g_varchar2) or
558: nvl(ben_pry_shd.g_old_rec.pry_attribute7, hr_api.g_varchar2) <>
559: nvl(p_rec.pry_attribute7, hr_api.g_varchar2) or
560: nvl(ben_pry_shd.g_old_rec.pry_attribute8, hr_api.g_varchar2) <>
561: nvl(p_rec.pry_attribute8, hr_api.g_varchar2) or
562: nvl(ben_pry_shd.g_old_rec.pry_attribute9, hr_api.g_varchar2) <>

Line 560: nvl(ben_pry_shd.g_old_rec.pry_attribute8, hr_api.g_varchar2) <>

556: nvl(ben_pry_shd.g_old_rec.pry_attribute6, hr_api.g_varchar2) <>
557: nvl(p_rec.pry_attribute6, hr_api.g_varchar2) or
558: nvl(ben_pry_shd.g_old_rec.pry_attribute7, hr_api.g_varchar2) <>
559: nvl(p_rec.pry_attribute7, hr_api.g_varchar2) or
560: nvl(ben_pry_shd.g_old_rec.pry_attribute8, hr_api.g_varchar2) <>
561: nvl(p_rec.pry_attribute8, hr_api.g_varchar2) or
562: nvl(ben_pry_shd.g_old_rec.pry_attribute9, hr_api.g_varchar2) <>
563: nvl(p_rec.pry_attribute9, hr_api.g_varchar2) or
564: nvl(ben_pry_shd.g_old_rec.pry_attribute10, hr_api.g_varchar2) <>

Line 562: nvl(ben_pry_shd.g_old_rec.pry_attribute9, hr_api.g_varchar2) <>

558: nvl(ben_pry_shd.g_old_rec.pry_attribute7, hr_api.g_varchar2) <>
559: nvl(p_rec.pry_attribute7, hr_api.g_varchar2) or
560: nvl(ben_pry_shd.g_old_rec.pry_attribute8, hr_api.g_varchar2) <>
561: nvl(p_rec.pry_attribute8, hr_api.g_varchar2) or
562: nvl(ben_pry_shd.g_old_rec.pry_attribute9, hr_api.g_varchar2) <>
563: nvl(p_rec.pry_attribute9, hr_api.g_varchar2) or
564: nvl(ben_pry_shd.g_old_rec.pry_attribute10, hr_api.g_varchar2) <>
565: nvl(p_rec.pry_attribute10, hr_api.g_varchar2) or
566: nvl(ben_pry_shd.g_old_rec.pry_attribute11, hr_api.g_varchar2) <>

Line 564: nvl(ben_pry_shd.g_old_rec.pry_attribute10, hr_api.g_varchar2) <>

560: nvl(ben_pry_shd.g_old_rec.pry_attribute8, hr_api.g_varchar2) <>
561: nvl(p_rec.pry_attribute8, hr_api.g_varchar2) or
562: nvl(ben_pry_shd.g_old_rec.pry_attribute9, hr_api.g_varchar2) <>
563: nvl(p_rec.pry_attribute9, hr_api.g_varchar2) or
564: nvl(ben_pry_shd.g_old_rec.pry_attribute10, hr_api.g_varchar2) <>
565: nvl(p_rec.pry_attribute10, hr_api.g_varchar2) or
566: nvl(ben_pry_shd.g_old_rec.pry_attribute11, hr_api.g_varchar2) <>
567: nvl(p_rec.pry_attribute11, hr_api.g_varchar2) or
568: nvl(ben_pry_shd.g_old_rec.pry_attribute12, hr_api.g_varchar2) <>

Line 566: nvl(ben_pry_shd.g_old_rec.pry_attribute11, hr_api.g_varchar2) <>

562: nvl(ben_pry_shd.g_old_rec.pry_attribute9, hr_api.g_varchar2) <>
563: nvl(p_rec.pry_attribute9, hr_api.g_varchar2) or
564: nvl(ben_pry_shd.g_old_rec.pry_attribute10, hr_api.g_varchar2) <>
565: nvl(p_rec.pry_attribute10, hr_api.g_varchar2) or
566: nvl(ben_pry_shd.g_old_rec.pry_attribute11, hr_api.g_varchar2) <>
567: nvl(p_rec.pry_attribute11, hr_api.g_varchar2) or
568: nvl(ben_pry_shd.g_old_rec.pry_attribute12, hr_api.g_varchar2) <>
569: nvl(p_rec.pry_attribute12, hr_api.g_varchar2) or
570: nvl(ben_pry_shd.g_old_rec.pry_attribute13, hr_api.g_varchar2) <>

Line 568: nvl(ben_pry_shd.g_old_rec.pry_attribute12, hr_api.g_varchar2) <>

564: nvl(ben_pry_shd.g_old_rec.pry_attribute10, hr_api.g_varchar2) <>
565: nvl(p_rec.pry_attribute10, hr_api.g_varchar2) or
566: nvl(ben_pry_shd.g_old_rec.pry_attribute11, hr_api.g_varchar2) <>
567: nvl(p_rec.pry_attribute11, hr_api.g_varchar2) or
568: nvl(ben_pry_shd.g_old_rec.pry_attribute12, hr_api.g_varchar2) <>
569: nvl(p_rec.pry_attribute12, hr_api.g_varchar2) or
570: nvl(ben_pry_shd.g_old_rec.pry_attribute13, hr_api.g_varchar2) <>
571: nvl(p_rec.pry_attribute13, hr_api.g_varchar2) or
572: nvl(ben_pry_shd.g_old_rec.pry_attribute14, hr_api.g_varchar2) <>

Line 570: nvl(ben_pry_shd.g_old_rec.pry_attribute13, hr_api.g_varchar2) <>

566: nvl(ben_pry_shd.g_old_rec.pry_attribute11, hr_api.g_varchar2) <>
567: nvl(p_rec.pry_attribute11, hr_api.g_varchar2) or
568: nvl(ben_pry_shd.g_old_rec.pry_attribute12, hr_api.g_varchar2) <>
569: nvl(p_rec.pry_attribute12, hr_api.g_varchar2) or
570: nvl(ben_pry_shd.g_old_rec.pry_attribute13, hr_api.g_varchar2) <>
571: nvl(p_rec.pry_attribute13, hr_api.g_varchar2) or
572: nvl(ben_pry_shd.g_old_rec.pry_attribute14, hr_api.g_varchar2) <>
573: nvl(p_rec.pry_attribute14, hr_api.g_varchar2) or
574: nvl(ben_pry_shd.g_old_rec.pry_attribute15, hr_api.g_varchar2) <>

Line 572: nvl(ben_pry_shd.g_old_rec.pry_attribute14, hr_api.g_varchar2) <>

568: nvl(ben_pry_shd.g_old_rec.pry_attribute12, hr_api.g_varchar2) <>
569: nvl(p_rec.pry_attribute12, hr_api.g_varchar2) or
570: nvl(ben_pry_shd.g_old_rec.pry_attribute13, hr_api.g_varchar2) <>
571: nvl(p_rec.pry_attribute13, hr_api.g_varchar2) or
572: nvl(ben_pry_shd.g_old_rec.pry_attribute14, hr_api.g_varchar2) <>
573: nvl(p_rec.pry_attribute14, hr_api.g_varchar2) or
574: nvl(ben_pry_shd.g_old_rec.pry_attribute15, hr_api.g_varchar2) <>
575: nvl(p_rec.pry_attribute15, hr_api.g_varchar2) or
576: nvl(ben_pry_shd.g_old_rec.pry_attribute16, hr_api.g_varchar2) <>

Line 574: nvl(ben_pry_shd.g_old_rec.pry_attribute15, hr_api.g_varchar2) <>

570: nvl(ben_pry_shd.g_old_rec.pry_attribute13, hr_api.g_varchar2) <>
571: nvl(p_rec.pry_attribute13, hr_api.g_varchar2) or
572: nvl(ben_pry_shd.g_old_rec.pry_attribute14, hr_api.g_varchar2) <>
573: nvl(p_rec.pry_attribute14, hr_api.g_varchar2) or
574: nvl(ben_pry_shd.g_old_rec.pry_attribute15, hr_api.g_varchar2) <>
575: nvl(p_rec.pry_attribute15, hr_api.g_varchar2) or
576: nvl(ben_pry_shd.g_old_rec.pry_attribute16, hr_api.g_varchar2) <>
577: nvl(p_rec.pry_attribute16, hr_api.g_varchar2) or
578: nvl(ben_pry_shd.g_old_rec.pry_attribute17, hr_api.g_varchar2) <>

Line 576: nvl(ben_pry_shd.g_old_rec.pry_attribute16, hr_api.g_varchar2) <>

572: nvl(ben_pry_shd.g_old_rec.pry_attribute14, hr_api.g_varchar2) <>
573: nvl(p_rec.pry_attribute14, hr_api.g_varchar2) or
574: nvl(ben_pry_shd.g_old_rec.pry_attribute15, hr_api.g_varchar2) <>
575: nvl(p_rec.pry_attribute15, hr_api.g_varchar2) or
576: nvl(ben_pry_shd.g_old_rec.pry_attribute16, hr_api.g_varchar2) <>
577: nvl(p_rec.pry_attribute16, hr_api.g_varchar2) or
578: nvl(ben_pry_shd.g_old_rec.pry_attribute17, hr_api.g_varchar2) <>
579: nvl(p_rec.pry_attribute17, hr_api.g_varchar2) or
580: nvl(ben_pry_shd.g_old_rec.pry_attribute18, hr_api.g_varchar2) <>

Line 578: nvl(ben_pry_shd.g_old_rec.pry_attribute17, hr_api.g_varchar2) <>

574: nvl(ben_pry_shd.g_old_rec.pry_attribute15, hr_api.g_varchar2) <>
575: nvl(p_rec.pry_attribute15, hr_api.g_varchar2) or
576: nvl(ben_pry_shd.g_old_rec.pry_attribute16, hr_api.g_varchar2) <>
577: nvl(p_rec.pry_attribute16, hr_api.g_varchar2) or
578: nvl(ben_pry_shd.g_old_rec.pry_attribute17, hr_api.g_varchar2) <>
579: nvl(p_rec.pry_attribute17, hr_api.g_varchar2) or
580: nvl(ben_pry_shd.g_old_rec.pry_attribute18, hr_api.g_varchar2) <>
581: nvl(p_rec.pry_attribute18, hr_api.g_varchar2) or
582: nvl(ben_pry_shd.g_old_rec.pry_attribute19, hr_api.g_varchar2) <>

Line 580: nvl(ben_pry_shd.g_old_rec.pry_attribute18, hr_api.g_varchar2) <>

576: nvl(ben_pry_shd.g_old_rec.pry_attribute16, hr_api.g_varchar2) <>
577: nvl(p_rec.pry_attribute16, hr_api.g_varchar2) or
578: nvl(ben_pry_shd.g_old_rec.pry_attribute17, hr_api.g_varchar2) <>
579: nvl(p_rec.pry_attribute17, hr_api.g_varchar2) or
580: nvl(ben_pry_shd.g_old_rec.pry_attribute18, hr_api.g_varchar2) <>
581: nvl(p_rec.pry_attribute18, hr_api.g_varchar2) or
582: nvl(ben_pry_shd.g_old_rec.pry_attribute19, hr_api.g_varchar2) <>
583: nvl(p_rec.pry_attribute19, hr_api.g_varchar2) or
584: nvl(ben_pry_shd.g_old_rec.pry_attribute20, hr_api.g_varchar2) <>

Line 582: nvl(ben_pry_shd.g_old_rec.pry_attribute19, hr_api.g_varchar2) <>

578: nvl(ben_pry_shd.g_old_rec.pry_attribute17, hr_api.g_varchar2) <>
579: nvl(p_rec.pry_attribute17, hr_api.g_varchar2) or
580: nvl(ben_pry_shd.g_old_rec.pry_attribute18, hr_api.g_varchar2) <>
581: nvl(p_rec.pry_attribute18, hr_api.g_varchar2) or
582: nvl(ben_pry_shd.g_old_rec.pry_attribute19, hr_api.g_varchar2) <>
583: nvl(p_rec.pry_attribute19, hr_api.g_varchar2) or
584: nvl(ben_pry_shd.g_old_rec.pry_attribute20, hr_api.g_varchar2) <>
585: nvl(p_rec.pry_attribute20, hr_api.g_varchar2) or
586: nvl(ben_pry_shd.g_old_rec.pry_attribute21, hr_api.g_varchar2) <>

Line 584: nvl(ben_pry_shd.g_old_rec.pry_attribute20, hr_api.g_varchar2) <>

580: nvl(ben_pry_shd.g_old_rec.pry_attribute18, hr_api.g_varchar2) <>
581: nvl(p_rec.pry_attribute18, hr_api.g_varchar2) or
582: nvl(ben_pry_shd.g_old_rec.pry_attribute19, hr_api.g_varchar2) <>
583: nvl(p_rec.pry_attribute19, hr_api.g_varchar2) or
584: nvl(ben_pry_shd.g_old_rec.pry_attribute20, hr_api.g_varchar2) <>
585: nvl(p_rec.pry_attribute20, hr_api.g_varchar2) or
586: nvl(ben_pry_shd.g_old_rec.pry_attribute21, hr_api.g_varchar2) <>
587: nvl(p_rec.pry_attribute21, hr_api.g_varchar2) or
588: nvl(ben_pry_shd.g_old_rec.pry_attribute22, hr_api.g_varchar2) <>

Line 586: nvl(ben_pry_shd.g_old_rec.pry_attribute21, hr_api.g_varchar2) <>

582: nvl(ben_pry_shd.g_old_rec.pry_attribute19, hr_api.g_varchar2) <>
583: nvl(p_rec.pry_attribute19, hr_api.g_varchar2) or
584: nvl(ben_pry_shd.g_old_rec.pry_attribute20, hr_api.g_varchar2) <>
585: nvl(p_rec.pry_attribute20, hr_api.g_varchar2) or
586: nvl(ben_pry_shd.g_old_rec.pry_attribute21, hr_api.g_varchar2) <>
587: nvl(p_rec.pry_attribute21, hr_api.g_varchar2) or
588: nvl(ben_pry_shd.g_old_rec.pry_attribute22, hr_api.g_varchar2) <>
589: nvl(p_rec.pry_attribute22, hr_api.g_varchar2) or
590: nvl(ben_pry_shd.g_old_rec.pry_attribute23, hr_api.g_varchar2) <>

Line 588: nvl(ben_pry_shd.g_old_rec.pry_attribute22, hr_api.g_varchar2) <>

584: nvl(ben_pry_shd.g_old_rec.pry_attribute20, hr_api.g_varchar2) <>
585: nvl(p_rec.pry_attribute20, hr_api.g_varchar2) or
586: nvl(ben_pry_shd.g_old_rec.pry_attribute21, hr_api.g_varchar2) <>
587: nvl(p_rec.pry_attribute21, hr_api.g_varchar2) or
588: nvl(ben_pry_shd.g_old_rec.pry_attribute22, hr_api.g_varchar2) <>
589: nvl(p_rec.pry_attribute22, hr_api.g_varchar2) or
590: nvl(ben_pry_shd.g_old_rec.pry_attribute23, hr_api.g_varchar2) <>
591: nvl(p_rec.pry_attribute23, hr_api.g_varchar2) or
592: nvl(ben_pry_shd.g_old_rec.pry_attribute24, hr_api.g_varchar2) <>

Line 590: nvl(ben_pry_shd.g_old_rec.pry_attribute23, hr_api.g_varchar2) <>

586: nvl(ben_pry_shd.g_old_rec.pry_attribute21, hr_api.g_varchar2) <>
587: nvl(p_rec.pry_attribute21, hr_api.g_varchar2) or
588: nvl(ben_pry_shd.g_old_rec.pry_attribute22, hr_api.g_varchar2) <>
589: nvl(p_rec.pry_attribute22, hr_api.g_varchar2) or
590: nvl(ben_pry_shd.g_old_rec.pry_attribute23, hr_api.g_varchar2) <>
591: nvl(p_rec.pry_attribute23, hr_api.g_varchar2) or
592: nvl(ben_pry_shd.g_old_rec.pry_attribute24, hr_api.g_varchar2) <>
593: nvl(p_rec.pry_attribute24, hr_api.g_varchar2) or
594: nvl(ben_pry_shd.g_old_rec.pry_attribute25, hr_api.g_varchar2) <>

Line 592: nvl(ben_pry_shd.g_old_rec.pry_attribute24, hr_api.g_varchar2) <>

588: nvl(ben_pry_shd.g_old_rec.pry_attribute22, hr_api.g_varchar2) <>
589: nvl(p_rec.pry_attribute22, hr_api.g_varchar2) or
590: nvl(ben_pry_shd.g_old_rec.pry_attribute23, hr_api.g_varchar2) <>
591: nvl(p_rec.pry_attribute23, hr_api.g_varchar2) or
592: nvl(ben_pry_shd.g_old_rec.pry_attribute24, hr_api.g_varchar2) <>
593: nvl(p_rec.pry_attribute24, hr_api.g_varchar2) or
594: nvl(ben_pry_shd.g_old_rec.pry_attribute25, hr_api.g_varchar2) <>
595: nvl(p_rec.pry_attribute25, hr_api.g_varchar2) or
596: nvl(ben_pry_shd.g_old_rec.pry_attribute26, hr_api.g_varchar2) <>

Line 594: nvl(ben_pry_shd.g_old_rec.pry_attribute25, hr_api.g_varchar2) <>

590: nvl(ben_pry_shd.g_old_rec.pry_attribute23, hr_api.g_varchar2) <>
591: nvl(p_rec.pry_attribute23, hr_api.g_varchar2) or
592: nvl(ben_pry_shd.g_old_rec.pry_attribute24, hr_api.g_varchar2) <>
593: nvl(p_rec.pry_attribute24, hr_api.g_varchar2) or
594: nvl(ben_pry_shd.g_old_rec.pry_attribute25, hr_api.g_varchar2) <>
595: nvl(p_rec.pry_attribute25, hr_api.g_varchar2) or
596: nvl(ben_pry_shd.g_old_rec.pry_attribute26, hr_api.g_varchar2) <>
597: nvl(p_rec.pry_attribute26, hr_api.g_varchar2) or
598: nvl(ben_pry_shd.g_old_rec.pry_attribute27, hr_api.g_varchar2) <>

Line 596: nvl(ben_pry_shd.g_old_rec.pry_attribute26, hr_api.g_varchar2) <>

592: nvl(ben_pry_shd.g_old_rec.pry_attribute24, hr_api.g_varchar2) <>
593: nvl(p_rec.pry_attribute24, hr_api.g_varchar2) or
594: nvl(ben_pry_shd.g_old_rec.pry_attribute25, hr_api.g_varchar2) <>
595: nvl(p_rec.pry_attribute25, hr_api.g_varchar2) or
596: nvl(ben_pry_shd.g_old_rec.pry_attribute26, hr_api.g_varchar2) <>
597: nvl(p_rec.pry_attribute26, hr_api.g_varchar2) or
598: nvl(ben_pry_shd.g_old_rec.pry_attribute27, hr_api.g_varchar2) <>
599: nvl(p_rec.pry_attribute27, hr_api.g_varchar2) or
600: nvl(ben_pry_shd.g_old_rec.pry_attribute28, hr_api.g_varchar2) <>

Line 598: nvl(ben_pry_shd.g_old_rec.pry_attribute27, hr_api.g_varchar2) <>

594: nvl(ben_pry_shd.g_old_rec.pry_attribute25, hr_api.g_varchar2) <>
595: nvl(p_rec.pry_attribute25, hr_api.g_varchar2) or
596: nvl(ben_pry_shd.g_old_rec.pry_attribute26, hr_api.g_varchar2) <>
597: nvl(p_rec.pry_attribute26, hr_api.g_varchar2) or
598: nvl(ben_pry_shd.g_old_rec.pry_attribute27, hr_api.g_varchar2) <>
599: nvl(p_rec.pry_attribute27, hr_api.g_varchar2) or
600: nvl(ben_pry_shd.g_old_rec.pry_attribute28, hr_api.g_varchar2) <>
601: nvl(p_rec.pry_attribute28, hr_api.g_varchar2) or
602: nvl(ben_pry_shd.g_old_rec.pry_attribute29, hr_api.g_varchar2) <>

Line 600: nvl(ben_pry_shd.g_old_rec.pry_attribute28, hr_api.g_varchar2) <>

596: nvl(ben_pry_shd.g_old_rec.pry_attribute26, hr_api.g_varchar2) <>
597: nvl(p_rec.pry_attribute26, hr_api.g_varchar2) or
598: nvl(ben_pry_shd.g_old_rec.pry_attribute27, hr_api.g_varchar2) <>
599: nvl(p_rec.pry_attribute27, hr_api.g_varchar2) or
600: nvl(ben_pry_shd.g_old_rec.pry_attribute28, hr_api.g_varchar2) <>
601: nvl(p_rec.pry_attribute28, hr_api.g_varchar2) or
602: nvl(ben_pry_shd.g_old_rec.pry_attribute29, hr_api.g_varchar2) <>
603: nvl(p_rec.pry_attribute29, hr_api.g_varchar2) or
604: nvl(ben_pry_shd.g_old_rec.pry_attribute30, hr_api.g_varchar2) <>

Line 602: nvl(ben_pry_shd.g_old_rec.pry_attribute29, hr_api.g_varchar2) <>

598: nvl(ben_pry_shd.g_old_rec.pry_attribute27, hr_api.g_varchar2) <>
599: nvl(p_rec.pry_attribute27, hr_api.g_varchar2) or
600: nvl(ben_pry_shd.g_old_rec.pry_attribute28, hr_api.g_varchar2) <>
601: nvl(p_rec.pry_attribute28, hr_api.g_varchar2) or
602: nvl(ben_pry_shd.g_old_rec.pry_attribute29, hr_api.g_varchar2) <>
603: nvl(p_rec.pry_attribute29, hr_api.g_varchar2) or
604: nvl(ben_pry_shd.g_old_rec.pry_attribute30, hr_api.g_varchar2) <>
605: nvl(p_rec.pry_attribute30, hr_api.g_varchar2) ))
606: or (p_rec.prtt_rmt_aprvd_fr_pymt_id is null) then

Line 604: nvl(ben_pry_shd.g_old_rec.pry_attribute30, hr_api.g_varchar2) <>

600: nvl(ben_pry_shd.g_old_rec.pry_attribute28, hr_api.g_varchar2) <>
601: nvl(p_rec.pry_attribute28, hr_api.g_varchar2) or
602: nvl(ben_pry_shd.g_old_rec.pry_attribute29, hr_api.g_varchar2) <>
603: nvl(p_rec.pry_attribute29, hr_api.g_varchar2) or
604: nvl(ben_pry_shd.g_old_rec.pry_attribute30, hr_api.g_varchar2) <>
605: nvl(p_rec.pry_attribute30, hr_api.g_varchar2) ))
606: or (p_rec.prtt_rmt_aprvd_fr_pymt_id is null) then
607: --
608: -- Only execute the validation if absolutely necessary:

Line 712: ,p_rec in ben_pry_shd.g_rec_type

708: -- {End Of Comments}
709: -- ----------------------------------------------------------------------------
710: Procedure chk_non_updateable_args
711: (p_effective_date in date
712: ,p_rec in ben_pry_shd.g_rec_type
713: ) IS
714: --
715: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
716: l_error EXCEPTION;

Line 724: IF NOT ben_pry_shd.api_updating

720: --
721: -- Only proceed with the validation if a row exists for the current
722: -- record in the HR Schema.
723: --
724: IF NOT ben_pry_shd.api_updating
725: (p_prtt_rmt_aprvd_fr_pymt_id => p_rec.prtt_rmt_aprvd_fr_pymt_id
726: ,p_effective_date => p_effective_date
727: ,p_object_version_number => p_rec.object_version_number
728: ) THEN

Line 956: (p_rec in ben_pry_shd.g_rec_type

952: -- ----------------------------------------------------------------------------
953: -- |---------------------------< insert_validate >----------------------------|
954: -- ----------------------------------------------------------------------------
955: Procedure insert_validate
956: (p_rec in ben_pry_shd.g_rec_type
957: ,p_effective_date in date
958: ,p_datetrack_mode in varchar2
959: ,p_validation_start_date in date
960: ,p_validation_end_date in date

Line 1002: (p_rec in ben_pry_shd.g_rec_type

998: -- ----------------------------------------------------------------------------
999: -- |---------------------------< update_validate >----------------------------|
1000: -- ----------------------------------------------------------------------------
1001: Procedure update_validate
1002: (p_rec in ben_pry_shd.g_rec_type
1003: ,p_effective_date in date
1004: ,p_datetrack_mode in varchar2
1005: ,p_validation_start_date in date
1006: ,p_validation_end_date in date

Line 1061: (p_rec in ben_pry_shd.g_rec_type

1057: -- ----------------------------------------------------------------------------
1058: -- |---------------------------< delete_validate >----------------------------|
1059: -- ----------------------------------------------------------------------------
1060: Procedure delete_validate
1061: (p_rec in ben_pry_shd.g_rec_type
1062: ,p_effective_date in date
1063: ,p_datetrack_mode in varchar2
1064: ,p_validation_start_date in date
1065: ,p_validation_end_date in date