eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_VEP_BUS dependencies on BEN_VEP_SHD

Line 54: l_api_updating := ben_vep_shd.api_updating

50: Begin
51: --
52: hr_utility.set_location('Entering:'||l_proc, 5);
53: --
54: l_api_updating := ben_vep_shd.api_updating
55: (p_effective_date => p_effective_date,
56: p_vrbl_rt_elig_prfl_id => p_vrbl_rt_elig_prfl_id,
57: p_object_version_number => p_object_version_number);
58: --

Line 61: <> ben_vep_shd.g_old_rec.vrbl_rt_elig_prfl_id) then

57: p_object_version_number => p_object_version_number);
58: --
59: if (l_api_updating
60: and nvl(p_vrbl_rt_elig_prfl_id,hr_api.g_number)
61: <> ben_vep_shd.g_old_rec.vrbl_rt_elig_prfl_id) then
62: -- raise error as PK has changed
63: --
64: ben_vep_shd.constraint_error('BEN_VRBL_RT_ELIG_PRFL_F_PK');
65: --

Line 64: ben_vep_shd.constraint_error('BEN_VRBL_RT_ELIG_PRFL_F_PK');

60: and nvl(p_vrbl_rt_elig_prfl_id,hr_api.g_number)
61: <> ben_vep_shd.g_old_rec.vrbl_rt_elig_prfl_id) then
62: -- raise error as PK has changed
63: --
64: ben_vep_shd.constraint_error('BEN_VRBL_RT_ELIG_PRFL_F_PK');
65: --
66: elsif not l_api_updating then
67: --
68: -- check if PK is null

Line 74: ben_vep_shd.constraint_error('BEN_VRBL_RT_ELIG_PRFL_F_PK');

70: if p_vrbl_rt_elig_prfl_id is not null then
71: --
72: -- raise error as PK is not null
73: --
74: ben_vep_shd.constraint_error('BEN_VRBL_RT_ELIG_PRFL_F_PK');
75: --
76: end if;
77: --
78: end if;

Line 125: l_api_updating := ben_vep_shd.api_updating

121: Begin
122: --
123: hr_utility.set_location('Entering:'||l_proc, 5);
124: --
125: l_api_updating := ben_vep_shd.api_updating
126: (p_vrbl_rt_elig_prfl_id => p_vrbl_rt_elig_prfl_id,
127: p_effective_date => p_effective_date,
128: p_object_version_number => p_object_version_number);
129: --

Line 132: <> nvl(ben_vep_shd.g_old_rec.mndtry_flag,hr_api.g_varchar2)

128: p_object_version_number => p_object_version_number);
129: --
130: if (l_api_updating
131: and p_mndtry_flag
132: <> nvl(ben_vep_shd.g_old_rec.mndtry_flag,hr_api.g_varchar2)
133: or not l_api_updating)
134: and p_mndtry_flag is not null then
135: --
136: -- check if value of lookup falls within lookup type.

Line 569: (p_rec in ben_vep_shd.g_rec_type

565: -- Internal Row Handler Use Only.
566: --
567: -- ----------------------------------------------------------------------------
568: procedure chk_df
569: (p_rec in ben_vep_shd.g_rec_type
570: ) is
571: --
572: l_proc varchar2(72) := g_package || 'chk_df';
573: --

Line 578: nvl(ben_vep_shd.g_old_rec.vep_attribute_category, hr_api.g_varchar2) <>

574: begin
575: hr_utility.set_location('Entering:'||l_proc,10);
576: --
577: if ((p_rec.vrbl_rt_elig_prfl_id is not null) and (
578: nvl(ben_vep_shd.g_old_rec.vep_attribute_category, hr_api.g_varchar2) <>
579: nvl(p_rec.vep_attribute_category, hr_api.g_varchar2) or
580: nvl(ben_vep_shd.g_old_rec.vep_attribute1, hr_api.g_varchar2) <>
581: nvl(p_rec.vep_attribute1, hr_api.g_varchar2) or
582: nvl(ben_vep_shd.g_old_rec.vep_attribute2, hr_api.g_varchar2) <>

Line 580: nvl(ben_vep_shd.g_old_rec.vep_attribute1, hr_api.g_varchar2) <>

576: --
577: if ((p_rec.vrbl_rt_elig_prfl_id is not null) and (
578: nvl(ben_vep_shd.g_old_rec.vep_attribute_category, hr_api.g_varchar2) <>
579: nvl(p_rec.vep_attribute_category, hr_api.g_varchar2) or
580: nvl(ben_vep_shd.g_old_rec.vep_attribute1, hr_api.g_varchar2) <>
581: nvl(p_rec.vep_attribute1, hr_api.g_varchar2) or
582: nvl(ben_vep_shd.g_old_rec.vep_attribute2, hr_api.g_varchar2) <>
583: nvl(p_rec.vep_attribute2, hr_api.g_varchar2) or
584: nvl(ben_vep_shd.g_old_rec.vep_attribute3, hr_api.g_varchar2) <>

Line 582: nvl(ben_vep_shd.g_old_rec.vep_attribute2, hr_api.g_varchar2) <>

578: nvl(ben_vep_shd.g_old_rec.vep_attribute_category, hr_api.g_varchar2) <>
579: nvl(p_rec.vep_attribute_category, hr_api.g_varchar2) or
580: nvl(ben_vep_shd.g_old_rec.vep_attribute1, hr_api.g_varchar2) <>
581: nvl(p_rec.vep_attribute1, hr_api.g_varchar2) or
582: nvl(ben_vep_shd.g_old_rec.vep_attribute2, hr_api.g_varchar2) <>
583: nvl(p_rec.vep_attribute2, hr_api.g_varchar2) or
584: nvl(ben_vep_shd.g_old_rec.vep_attribute3, hr_api.g_varchar2) <>
585: nvl(p_rec.vep_attribute3, hr_api.g_varchar2) or
586: nvl(ben_vep_shd.g_old_rec.vep_attribute4, hr_api.g_varchar2) <>

Line 584: nvl(ben_vep_shd.g_old_rec.vep_attribute3, hr_api.g_varchar2) <>

580: nvl(ben_vep_shd.g_old_rec.vep_attribute1, hr_api.g_varchar2) <>
581: nvl(p_rec.vep_attribute1, hr_api.g_varchar2) or
582: nvl(ben_vep_shd.g_old_rec.vep_attribute2, hr_api.g_varchar2) <>
583: nvl(p_rec.vep_attribute2, hr_api.g_varchar2) or
584: nvl(ben_vep_shd.g_old_rec.vep_attribute3, hr_api.g_varchar2) <>
585: nvl(p_rec.vep_attribute3, hr_api.g_varchar2) or
586: nvl(ben_vep_shd.g_old_rec.vep_attribute4, hr_api.g_varchar2) <>
587: nvl(p_rec.vep_attribute4, hr_api.g_varchar2) or
588: nvl(ben_vep_shd.g_old_rec.vep_attribute5, hr_api.g_varchar2) <>

Line 586: nvl(ben_vep_shd.g_old_rec.vep_attribute4, hr_api.g_varchar2) <>

582: nvl(ben_vep_shd.g_old_rec.vep_attribute2, hr_api.g_varchar2) <>
583: nvl(p_rec.vep_attribute2, hr_api.g_varchar2) or
584: nvl(ben_vep_shd.g_old_rec.vep_attribute3, hr_api.g_varchar2) <>
585: nvl(p_rec.vep_attribute3, hr_api.g_varchar2) or
586: nvl(ben_vep_shd.g_old_rec.vep_attribute4, hr_api.g_varchar2) <>
587: nvl(p_rec.vep_attribute4, hr_api.g_varchar2) or
588: nvl(ben_vep_shd.g_old_rec.vep_attribute5, hr_api.g_varchar2) <>
589: nvl(p_rec.vep_attribute5, hr_api.g_varchar2) or
590: nvl(ben_vep_shd.g_old_rec.vep_attribute6, hr_api.g_varchar2) <>

Line 588: nvl(ben_vep_shd.g_old_rec.vep_attribute5, hr_api.g_varchar2) <>

584: nvl(ben_vep_shd.g_old_rec.vep_attribute3, hr_api.g_varchar2) <>
585: nvl(p_rec.vep_attribute3, hr_api.g_varchar2) or
586: nvl(ben_vep_shd.g_old_rec.vep_attribute4, hr_api.g_varchar2) <>
587: nvl(p_rec.vep_attribute4, hr_api.g_varchar2) or
588: nvl(ben_vep_shd.g_old_rec.vep_attribute5, hr_api.g_varchar2) <>
589: nvl(p_rec.vep_attribute5, hr_api.g_varchar2) or
590: nvl(ben_vep_shd.g_old_rec.vep_attribute6, hr_api.g_varchar2) <>
591: nvl(p_rec.vep_attribute6, hr_api.g_varchar2) or
592: nvl(ben_vep_shd.g_old_rec.vep_attribute7, hr_api.g_varchar2) <>

Line 590: nvl(ben_vep_shd.g_old_rec.vep_attribute6, hr_api.g_varchar2) <>

586: nvl(ben_vep_shd.g_old_rec.vep_attribute4, hr_api.g_varchar2) <>
587: nvl(p_rec.vep_attribute4, hr_api.g_varchar2) or
588: nvl(ben_vep_shd.g_old_rec.vep_attribute5, hr_api.g_varchar2) <>
589: nvl(p_rec.vep_attribute5, hr_api.g_varchar2) or
590: nvl(ben_vep_shd.g_old_rec.vep_attribute6, hr_api.g_varchar2) <>
591: nvl(p_rec.vep_attribute6, hr_api.g_varchar2) or
592: nvl(ben_vep_shd.g_old_rec.vep_attribute7, hr_api.g_varchar2) <>
593: nvl(p_rec.vep_attribute7, hr_api.g_varchar2) or
594: nvl(ben_vep_shd.g_old_rec.vep_attribute8, hr_api.g_varchar2) <>

Line 592: nvl(ben_vep_shd.g_old_rec.vep_attribute7, hr_api.g_varchar2) <>

588: nvl(ben_vep_shd.g_old_rec.vep_attribute5, hr_api.g_varchar2) <>
589: nvl(p_rec.vep_attribute5, hr_api.g_varchar2) or
590: nvl(ben_vep_shd.g_old_rec.vep_attribute6, hr_api.g_varchar2) <>
591: nvl(p_rec.vep_attribute6, hr_api.g_varchar2) or
592: nvl(ben_vep_shd.g_old_rec.vep_attribute7, hr_api.g_varchar2) <>
593: nvl(p_rec.vep_attribute7, hr_api.g_varchar2) or
594: nvl(ben_vep_shd.g_old_rec.vep_attribute8, hr_api.g_varchar2) <>
595: nvl(p_rec.vep_attribute8, hr_api.g_varchar2) or
596: nvl(ben_vep_shd.g_old_rec.vep_attribute9, hr_api.g_varchar2) <>

Line 594: nvl(ben_vep_shd.g_old_rec.vep_attribute8, hr_api.g_varchar2) <>

590: nvl(ben_vep_shd.g_old_rec.vep_attribute6, hr_api.g_varchar2) <>
591: nvl(p_rec.vep_attribute6, hr_api.g_varchar2) or
592: nvl(ben_vep_shd.g_old_rec.vep_attribute7, hr_api.g_varchar2) <>
593: nvl(p_rec.vep_attribute7, hr_api.g_varchar2) or
594: nvl(ben_vep_shd.g_old_rec.vep_attribute8, hr_api.g_varchar2) <>
595: nvl(p_rec.vep_attribute8, hr_api.g_varchar2) or
596: nvl(ben_vep_shd.g_old_rec.vep_attribute9, hr_api.g_varchar2) <>
597: nvl(p_rec.vep_attribute9, hr_api.g_varchar2) or
598: nvl(ben_vep_shd.g_old_rec.vep_attribute10, hr_api.g_varchar2) <>

Line 596: nvl(ben_vep_shd.g_old_rec.vep_attribute9, hr_api.g_varchar2) <>

592: nvl(ben_vep_shd.g_old_rec.vep_attribute7, hr_api.g_varchar2) <>
593: nvl(p_rec.vep_attribute7, hr_api.g_varchar2) or
594: nvl(ben_vep_shd.g_old_rec.vep_attribute8, hr_api.g_varchar2) <>
595: nvl(p_rec.vep_attribute8, hr_api.g_varchar2) or
596: nvl(ben_vep_shd.g_old_rec.vep_attribute9, hr_api.g_varchar2) <>
597: nvl(p_rec.vep_attribute9, hr_api.g_varchar2) or
598: nvl(ben_vep_shd.g_old_rec.vep_attribute10, hr_api.g_varchar2) <>
599: nvl(p_rec.vep_attribute10, hr_api.g_varchar2) or
600: nvl(ben_vep_shd.g_old_rec.vep_attribute11, hr_api.g_varchar2) <>

Line 598: nvl(ben_vep_shd.g_old_rec.vep_attribute10, hr_api.g_varchar2) <>

594: nvl(ben_vep_shd.g_old_rec.vep_attribute8, hr_api.g_varchar2) <>
595: nvl(p_rec.vep_attribute8, hr_api.g_varchar2) or
596: nvl(ben_vep_shd.g_old_rec.vep_attribute9, hr_api.g_varchar2) <>
597: nvl(p_rec.vep_attribute9, hr_api.g_varchar2) or
598: nvl(ben_vep_shd.g_old_rec.vep_attribute10, hr_api.g_varchar2) <>
599: nvl(p_rec.vep_attribute10, hr_api.g_varchar2) or
600: nvl(ben_vep_shd.g_old_rec.vep_attribute11, hr_api.g_varchar2) <>
601: nvl(p_rec.vep_attribute11, hr_api.g_varchar2) or
602: nvl(ben_vep_shd.g_old_rec.vep_attribute12, hr_api.g_varchar2) <>

Line 600: nvl(ben_vep_shd.g_old_rec.vep_attribute11, hr_api.g_varchar2) <>

596: nvl(ben_vep_shd.g_old_rec.vep_attribute9, hr_api.g_varchar2) <>
597: nvl(p_rec.vep_attribute9, hr_api.g_varchar2) or
598: nvl(ben_vep_shd.g_old_rec.vep_attribute10, hr_api.g_varchar2) <>
599: nvl(p_rec.vep_attribute10, hr_api.g_varchar2) or
600: nvl(ben_vep_shd.g_old_rec.vep_attribute11, hr_api.g_varchar2) <>
601: nvl(p_rec.vep_attribute11, hr_api.g_varchar2) or
602: nvl(ben_vep_shd.g_old_rec.vep_attribute12, hr_api.g_varchar2) <>
603: nvl(p_rec.vep_attribute12, hr_api.g_varchar2) or
604: nvl(ben_vep_shd.g_old_rec.vep_attribute13, hr_api.g_varchar2) <>

Line 602: nvl(ben_vep_shd.g_old_rec.vep_attribute12, hr_api.g_varchar2) <>

598: nvl(ben_vep_shd.g_old_rec.vep_attribute10, hr_api.g_varchar2) <>
599: nvl(p_rec.vep_attribute10, hr_api.g_varchar2) or
600: nvl(ben_vep_shd.g_old_rec.vep_attribute11, hr_api.g_varchar2) <>
601: nvl(p_rec.vep_attribute11, hr_api.g_varchar2) or
602: nvl(ben_vep_shd.g_old_rec.vep_attribute12, hr_api.g_varchar2) <>
603: nvl(p_rec.vep_attribute12, hr_api.g_varchar2) or
604: nvl(ben_vep_shd.g_old_rec.vep_attribute13, hr_api.g_varchar2) <>
605: nvl(p_rec.vep_attribute13, hr_api.g_varchar2) or
606: nvl(ben_vep_shd.g_old_rec.vep_attribute14, hr_api.g_varchar2) <>

Line 604: nvl(ben_vep_shd.g_old_rec.vep_attribute13, hr_api.g_varchar2) <>

600: nvl(ben_vep_shd.g_old_rec.vep_attribute11, hr_api.g_varchar2) <>
601: nvl(p_rec.vep_attribute11, hr_api.g_varchar2) or
602: nvl(ben_vep_shd.g_old_rec.vep_attribute12, hr_api.g_varchar2) <>
603: nvl(p_rec.vep_attribute12, hr_api.g_varchar2) or
604: nvl(ben_vep_shd.g_old_rec.vep_attribute13, hr_api.g_varchar2) <>
605: nvl(p_rec.vep_attribute13, hr_api.g_varchar2) or
606: nvl(ben_vep_shd.g_old_rec.vep_attribute14, hr_api.g_varchar2) <>
607: nvl(p_rec.vep_attribute14, hr_api.g_varchar2) or
608: nvl(ben_vep_shd.g_old_rec.vep_attribute15, hr_api.g_varchar2) <>

Line 606: nvl(ben_vep_shd.g_old_rec.vep_attribute14, hr_api.g_varchar2) <>

602: nvl(ben_vep_shd.g_old_rec.vep_attribute12, hr_api.g_varchar2) <>
603: nvl(p_rec.vep_attribute12, hr_api.g_varchar2) or
604: nvl(ben_vep_shd.g_old_rec.vep_attribute13, hr_api.g_varchar2) <>
605: nvl(p_rec.vep_attribute13, hr_api.g_varchar2) or
606: nvl(ben_vep_shd.g_old_rec.vep_attribute14, hr_api.g_varchar2) <>
607: nvl(p_rec.vep_attribute14, hr_api.g_varchar2) or
608: nvl(ben_vep_shd.g_old_rec.vep_attribute15, hr_api.g_varchar2) <>
609: nvl(p_rec.vep_attribute15, hr_api.g_varchar2) or
610: nvl(ben_vep_shd.g_old_rec.vep_attribute16, hr_api.g_varchar2) <>

Line 608: nvl(ben_vep_shd.g_old_rec.vep_attribute15, hr_api.g_varchar2) <>

604: nvl(ben_vep_shd.g_old_rec.vep_attribute13, hr_api.g_varchar2) <>
605: nvl(p_rec.vep_attribute13, hr_api.g_varchar2) or
606: nvl(ben_vep_shd.g_old_rec.vep_attribute14, hr_api.g_varchar2) <>
607: nvl(p_rec.vep_attribute14, hr_api.g_varchar2) or
608: nvl(ben_vep_shd.g_old_rec.vep_attribute15, hr_api.g_varchar2) <>
609: nvl(p_rec.vep_attribute15, hr_api.g_varchar2) or
610: nvl(ben_vep_shd.g_old_rec.vep_attribute16, hr_api.g_varchar2) <>
611: nvl(p_rec.vep_attribute16, hr_api.g_varchar2) or
612: nvl(ben_vep_shd.g_old_rec.vep_attribute17, hr_api.g_varchar2) <>

Line 610: nvl(ben_vep_shd.g_old_rec.vep_attribute16, hr_api.g_varchar2) <>

606: nvl(ben_vep_shd.g_old_rec.vep_attribute14, hr_api.g_varchar2) <>
607: nvl(p_rec.vep_attribute14, hr_api.g_varchar2) or
608: nvl(ben_vep_shd.g_old_rec.vep_attribute15, hr_api.g_varchar2) <>
609: nvl(p_rec.vep_attribute15, hr_api.g_varchar2) or
610: nvl(ben_vep_shd.g_old_rec.vep_attribute16, hr_api.g_varchar2) <>
611: nvl(p_rec.vep_attribute16, hr_api.g_varchar2) or
612: nvl(ben_vep_shd.g_old_rec.vep_attribute17, hr_api.g_varchar2) <>
613: nvl(p_rec.vep_attribute17, hr_api.g_varchar2) or
614: nvl(ben_vep_shd.g_old_rec.vep_attribute18, hr_api.g_varchar2) <>

Line 612: nvl(ben_vep_shd.g_old_rec.vep_attribute17, hr_api.g_varchar2) <>

608: nvl(ben_vep_shd.g_old_rec.vep_attribute15, hr_api.g_varchar2) <>
609: nvl(p_rec.vep_attribute15, hr_api.g_varchar2) or
610: nvl(ben_vep_shd.g_old_rec.vep_attribute16, hr_api.g_varchar2) <>
611: nvl(p_rec.vep_attribute16, hr_api.g_varchar2) or
612: nvl(ben_vep_shd.g_old_rec.vep_attribute17, hr_api.g_varchar2) <>
613: nvl(p_rec.vep_attribute17, hr_api.g_varchar2) or
614: nvl(ben_vep_shd.g_old_rec.vep_attribute18, hr_api.g_varchar2) <>
615: nvl(p_rec.vep_attribute18, hr_api.g_varchar2) or
616: nvl(ben_vep_shd.g_old_rec.vep_attribute19, hr_api.g_varchar2) <>

Line 614: nvl(ben_vep_shd.g_old_rec.vep_attribute18, hr_api.g_varchar2) <>

610: nvl(ben_vep_shd.g_old_rec.vep_attribute16, hr_api.g_varchar2) <>
611: nvl(p_rec.vep_attribute16, hr_api.g_varchar2) or
612: nvl(ben_vep_shd.g_old_rec.vep_attribute17, hr_api.g_varchar2) <>
613: nvl(p_rec.vep_attribute17, hr_api.g_varchar2) or
614: nvl(ben_vep_shd.g_old_rec.vep_attribute18, hr_api.g_varchar2) <>
615: nvl(p_rec.vep_attribute18, hr_api.g_varchar2) or
616: nvl(ben_vep_shd.g_old_rec.vep_attribute19, hr_api.g_varchar2) <>
617: nvl(p_rec.vep_attribute19, hr_api.g_varchar2) or
618: nvl(ben_vep_shd.g_old_rec.vep_attribute20, hr_api.g_varchar2) <>

Line 616: nvl(ben_vep_shd.g_old_rec.vep_attribute19, hr_api.g_varchar2) <>

612: nvl(ben_vep_shd.g_old_rec.vep_attribute17, hr_api.g_varchar2) <>
613: nvl(p_rec.vep_attribute17, hr_api.g_varchar2) or
614: nvl(ben_vep_shd.g_old_rec.vep_attribute18, hr_api.g_varchar2) <>
615: nvl(p_rec.vep_attribute18, hr_api.g_varchar2) or
616: nvl(ben_vep_shd.g_old_rec.vep_attribute19, hr_api.g_varchar2) <>
617: nvl(p_rec.vep_attribute19, hr_api.g_varchar2) or
618: nvl(ben_vep_shd.g_old_rec.vep_attribute20, hr_api.g_varchar2) <>
619: nvl(p_rec.vep_attribute20, hr_api.g_varchar2) or
620: nvl(ben_vep_shd.g_old_rec.vep_attribute21, hr_api.g_varchar2) <>

Line 618: nvl(ben_vep_shd.g_old_rec.vep_attribute20, hr_api.g_varchar2) <>

614: nvl(ben_vep_shd.g_old_rec.vep_attribute18, hr_api.g_varchar2) <>
615: nvl(p_rec.vep_attribute18, hr_api.g_varchar2) or
616: nvl(ben_vep_shd.g_old_rec.vep_attribute19, hr_api.g_varchar2) <>
617: nvl(p_rec.vep_attribute19, hr_api.g_varchar2) or
618: nvl(ben_vep_shd.g_old_rec.vep_attribute20, hr_api.g_varchar2) <>
619: nvl(p_rec.vep_attribute20, hr_api.g_varchar2) or
620: nvl(ben_vep_shd.g_old_rec.vep_attribute21, hr_api.g_varchar2) <>
621: nvl(p_rec.vep_attribute21, hr_api.g_varchar2) or
622: nvl(ben_vep_shd.g_old_rec.vep_attribute22, hr_api.g_varchar2) <>

Line 620: nvl(ben_vep_shd.g_old_rec.vep_attribute21, hr_api.g_varchar2) <>

616: nvl(ben_vep_shd.g_old_rec.vep_attribute19, hr_api.g_varchar2) <>
617: nvl(p_rec.vep_attribute19, hr_api.g_varchar2) or
618: nvl(ben_vep_shd.g_old_rec.vep_attribute20, hr_api.g_varchar2) <>
619: nvl(p_rec.vep_attribute20, hr_api.g_varchar2) or
620: nvl(ben_vep_shd.g_old_rec.vep_attribute21, hr_api.g_varchar2) <>
621: nvl(p_rec.vep_attribute21, hr_api.g_varchar2) or
622: nvl(ben_vep_shd.g_old_rec.vep_attribute22, hr_api.g_varchar2) <>
623: nvl(p_rec.vep_attribute22, hr_api.g_varchar2) or
624: nvl(ben_vep_shd.g_old_rec.vep_attribute23, hr_api.g_varchar2) <>

Line 622: nvl(ben_vep_shd.g_old_rec.vep_attribute22, hr_api.g_varchar2) <>

618: nvl(ben_vep_shd.g_old_rec.vep_attribute20, hr_api.g_varchar2) <>
619: nvl(p_rec.vep_attribute20, hr_api.g_varchar2) or
620: nvl(ben_vep_shd.g_old_rec.vep_attribute21, hr_api.g_varchar2) <>
621: nvl(p_rec.vep_attribute21, hr_api.g_varchar2) or
622: nvl(ben_vep_shd.g_old_rec.vep_attribute22, hr_api.g_varchar2) <>
623: nvl(p_rec.vep_attribute22, hr_api.g_varchar2) or
624: nvl(ben_vep_shd.g_old_rec.vep_attribute23, hr_api.g_varchar2) <>
625: nvl(p_rec.vep_attribute23, hr_api.g_varchar2) or
626: nvl(ben_vep_shd.g_old_rec.vep_attribute24, hr_api.g_varchar2) <>

Line 624: nvl(ben_vep_shd.g_old_rec.vep_attribute23, hr_api.g_varchar2) <>

620: nvl(ben_vep_shd.g_old_rec.vep_attribute21, hr_api.g_varchar2) <>
621: nvl(p_rec.vep_attribute21, hr_api.g_varchar2) or
622: nvl(ben_vep_shd.g_old_rec.vep_attribute22, hr_api.g_varchar2) <>
623: nvl(p_rec.vep_attribute22, hr_api.g_varchar2) or
624: nvl(ben_vep_shd.g_old_rec.vep_attribute23, hr_api.g_varchar2) <>
625: nvl(p_rec.vep_attribute23, hr_api.g_varchar2) or
626: nvl(ben_vep_shd.g_old_rec.vep_attribute24, hr_api.g_varchar2) <>
627: nvl(p_rec.vep_attribute24, hr_api.g_varchar2) or
628: nvl(ben_vep_shd.g_old_rec.vep_attribute25, hr_api.g_varchar2) <>

Line 626: nvl(ben_vep_shd.g_old_rec.vep_attribute24, hr_api.g_varchar2) <>

622: nvl(ben_vep_shd.g_old_rec.vep_attribute22, hr_api.g_varchar2) <>
623: nvl(p_rec.vep_attribute22, hr_api.g_varchar2) or
624: nvl(ben_vep_shd.g_old_rec.vep_attribute23, hr_api.g_varchar2) <>
625: nvl(p_rec.vep_attribute23, hr_api.g_varchar2) or
626: nvl(ben_vep_shd.g_old_rec.vep_attribute24, hr_api.g_varchar2) <>
627: nvl(p_rec.vep_attribute24, hr_api.g_varchar2) or
628: nvl(ben_vep_shd.g_old_rec.vep_attribute25, hr_api.g_varchar2) <>
629: nvl(p_rec.vep_attribute25, hr_api.g_varchar2) or
630: nvl(ben_vep_shd.g_old_rec.vep_attribute26, hr_api.g_varchar2) <>

Line 628: nvl(ben_vep_shd.g_old_rec.vep_attribute25, hr_api.g_varchar2) <>

624: nvl(ben_vep_shd.g_old_rec.vep_attribute23, hr_api.g_varchar2) <>
625: nvl(p_rec.vep_attribute23, hr_api.g_varchar2) or
626: nvl(ben_vep_shd.g_old_rec.vep_attribute24, hr_api.g_varchar2) <>
627: nvl(p_rec.vep_attribute24, hr_api.g_varchar2) or
628: nvl(ben_vep_shd.g_old_rec.vep_attribute25, hr_api.g_varchar2) <>
629: nvl(p_rec.vep_attribute25, hr_api.g_varchar2) or
630: nvl(ben_vep_shd.g_old_rec.vep_attribute26, hr_api.g_varchar2) <>
631: nvl(p_rec.vep_attribute26, hr_api.g_varchar2) or
632: nvl(ben_vep_shd.g_old_rec.vep_attribute27, hr_api.g_varchar2) <>

Line 630: nvl(ben_vep_shd.g_old_rec.vep_attribute26, hr_api.g_varchar2) <>

626: nvl(ben_vep_shd.g_old_rec.vep_attribute24, hr_api.g_varchar2) <>
627: nvl(p_rec.vep_attribute24, hr_api.g_varchar2) or
628: nvl(ben_vep_shd.g_old_rec.vep_attribute25, hr_api.g_varchar2) <>
629: nvl(p_rec.vep_attribute25, hr_api.g_varchar2) or
630: nvl(ben_vep_shd.g_old_rec.vep_attribute26, hr_api.g_varchar2) <>
631: nvl(p_rec.vep_attribute26, hr_api.g_varchar2) or
632: nvl(ben_vep_shd.g_old_rec.vep_attribute27, hr_api.g_varchar2) <>
633: nvl(p_rec.vep_attribute27, hr_api.g_varchar2) or
634: nvl(ben_vep_shd.g_old_rec.vep_attribute28, hr_api.g_varchar2) <>

Line 632: nvl(ben_vep_shd.g_old_rec.vep_attribute27, hr_api.g_varchar2) <>

628: nvl(ben_vep_shd.g_old_rec.vep_attribute25, hr_api.g_varchar2) <>
629: nvl(p_rec.vep_attribute25, hr_api.g_varchar2) or
630: nvl(ben_vep_shd.g_old_rec.vep_attribute26, hr_api.g_varchar2) <>
631: nvl(p_rec.vep_attribute26, hr_api.g_varchar2) or
632: nvl(ben_vep_shd.g_old_rec.vep_attribute27, hr_api.g_varchar2) <>
633: nvl(p_rec.vep_attribute27, hr_api.g_varchar2) or
634: nvl(ben_vep_shd.g_old_rec.vep_attribute28, hr_api.g_varchar2) <>
635: nvl(p_rec.vep_attribute28, hr_api.g_varchar2) or
636: nvl(ben_vep_shd.g_old_rec.vep_attribute29, hr_api.g_varchar2) <>

Line 634: nvl(ben_vep_shd.g_old_rec.vep_attribute28, hr_api.g_varchar2) <>

630: nvl(ben_vep_shd.g_old_rec.vep_attribute26, hr_api.g_varchar2) <>
631: nvl(p_rec.vep_attribute26, hr_api.g_varchar2) or
632: nvl(ben_vep_shd.g_old_rec.vep_attribute27, hr_api.g_varchar2) <>
633: nvl(p_rec.vep_attribute27, hr_api.g_varchar2) or
634: nvl(ben_vep_shd.g_old_rec.vep_attribute28, hr_api.g_varchar2) <>
635: nvl(p_rec.vep_attribute28, hr_api.g_varchar2) or
636: nvl(ben_vep_shd.g_old_rec.vep_attribute29, hr_api.g_varchar2) <>
637: nvl(p_rec.vep_attribute29, hr_api.g_varchar2) or
638: nvl(ben_vep_shd.g_old_rec.vep_attribute30, hr_api.g_varchar2) <>

Line 636: nvl(ben_vep_shd.g_old_rec.vep_attribute29, hr_api.g_varchar2) <>

632: nvl(ben_vep_shd.g_old_rec.vep_attribute27, hr_api.g_varchar2) <>
633: nvl(p_rec.vep_attribute27, hr_api.g_varchar2) or
634: nvl(ben_vep_shd.g_old_rec.vep_attribute28, hr_api.g_varchar2) <>
635: nvl(p_rec.vep_attribute28, hr_api.g_varchar2) or
636: nvl(ben_vep_shd.g_old_rec.vep_attribute29, hr_api.g_varchar2) <>
637: nvl(p_rec.vep_attribute29, hr_api.g_varchar2) or
638: nvl(ben_vep_shd.g_old_rec.vep_attribute30, hr_api.g_varchar2) <>
639: nvl(p_rec.vep_attribute30, hr_api.g_varchar2) ))
640: or (p_rec.vrbl_rt_elig_prfl_idis null) then

Line 638: nvl(ben_vep_shd.g_old_rec.vep_attribute30, hr_api.g_varchar2) <>

634: nvl(ben_vep_shd.g_old_rec.vep_attribute28, hr_api.g_varchar2) <>
635: nvl(p_rec.vep_attribute28, hr_api.g_varchar2) or
636: nvl(ben_vep_shd.g_old_rec.vep_attribute29, hr_api.g_varchar2) <>
637: nvl(p_rec.vep_attribute29, hr_api.g_varchar2) or
638: nvl(ben_vep_shd.g_old_rec.vep_attribute30, hr_api.g_varchar2) <>
639: nvl(p_rec.vep_attribute30, hr_api.g_varchar2) ))
640: or (p_rec.vrbl_rt_elig_prfl_idis null) then
641: --
642: -- Only execute the validation if absolutely necessary:

Line 748: ,p_rec in ben_vep_shd.g_rec_type

744: -- {End Of Comments}
745: -- ----------------------------------------------------------------------------
746: Procedure chk_non_updateable_args
747: (p_effective_date in date
748: ,p_rec in ben_vep_shd.g_rec_type
749: ) IS
750: --
751: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
752: l_error EXCEPTION;

Line 760: IF NOT ben_vep_shd.api_updating

756: --
757: -- Only proceed with the validation if a row exists for the current
758: -- record in the HR Schema.
759: --
760: IF NOT ben_vep_shd.api_updating
761: (p_vrbl_rt_elig_prfl_id => p_rec.vrbl_rt_elig_prfl_id
762: ,p_effective_date => p_effective_date
763: ,p_object_version_number => p_rec.object_version_number
764: ) THEN

Line 1135: (p_rec in ben_vep_shd.g_rec_type

1131: -- ----------------------------------------------------------------------------
1132: -- |---------------------------< insert_validate >----------------------------|
1133: -- ----------------------------------------------------------------------------
1134: Procedure insert_validate
1135: (p_rec in ben_vep_shd.g_rec_type
1136: ,p_effective_date in date
1137: ,p_datetrack_mode in varchar2
1138: ,p_validation_start_date in date
1139: ,p_validation_end_date in date

Line 1204: (p_rec in ben_vep_shd.g_rec_type

1200: -- ----------------------------------------------------------------------------
1201: -- |---------------------------< update_validate >----------------------------|
1202: -- ----------------------------------------------------------------------------
1203: Procedure update_validate
1204: (p_rec in ben_vep_shd.g_rec_type
1205: ,p_effective_date in date
1206: ,p_datetrack_mode in varchar2
1207: ,p_validation_start_date in date
1208: ,p_validation_end_date in date

Line 1287: (p_rec in ben_vep_shd.g_rec_type

1283: -- ----------------------------------------------------------------------------
1284: -- |---------------------------< delete_validate >----------------------------|
1285: -- ----------------------------------------------------------------------------
1286: Procedure delete_validate
1287: (p_rec in ben_vep_shd.g_rec_type
1288: ,p_effective_date in date
1289: ,p_datetrack_mode in varchar2
1290: ,p_validation_start_date in date
1291: ,p_validation_end_date in date