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 683: (p_rec in ben_vep_shd.g_rec_type

679: -- Internal Row Handler Use Only.
680: --
681: -- ----------------------------------------------------------------------------
682: procedure chk_df
683: (p_rec in ben_vep_shd.g_rec_type
684: ) is
685: --
686: l_proc varchar2(72) := g_package || 'chk_df';
687: --

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

688: begin
689: hr_utility.set_location('Entering:'||l_proc,10);
690: --
691: if ((p_rec.vrbl_rt_elig_prfl_id is not null) and (
692: nvl(ben_vep_shd.g_old_rec.vep_attribute_category, hr_api.g_varchar2) <>
693: nvl(p_rec.vep_attribute_category, hr_api.g_varchar2) or
694: nvl(ben_vep_shd.g_old_rec.vep_attribute1, hr_api.g_varchar2) <>
695: nvl(p_rec.vep_attribute1, hr_api.g_varchar2) or
696: nvl(ben_vep_shd.g_old_rec.vep_attribute2, hr_api.g_varchar2) <>

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

690: --
691: if ((p_rec.vrbl_rt_elig_prfl_id is not null) and (
692: nvl(ben_vep_shd.g_old_rec.vep_attribute_category, hr_api.g_varchar2) <>
693: nvl(p_rec.vep_attribute_category, hr_api.g_varchar2) or
694: nvl(ben_vep_shd.g_old_rec.vep_attribute1, hr_api.g_varchar2) <>
695: nvl(p_rec.vep_attribute1, hr_api.g_varchar2) or
696: nvl(ben_vep_shd.g_old_rec.vep_attribute2, hr_api.g_varchar2) <>
697: nvl(p_rec.vep_attribute2, hr_api.g_varchar2) or
698: nvl(ben_vep_shd.g_old_rec.vep_attribute3, hr_api.g_varchar2) <>

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

692: nvl(ben_vep_shd.g_old_rec.vep_attribute_category, hr_api.g_varchar2) <>
693: nvl(p_rec.vep_attribute_category, hr_api.g_varchar2) or
694: nvl(ben_vep_shd.g_old_rec.vep_attribute1, hr_api.g_varchar2) <>
695: nvl(p_rec.vep_attribute1, hr_api.g_varchar2) or
696: nvl(ben_vep_shd.g_old_rec.vep_attribute2, hr_api.g_varchar2) <>
697: nvl(p_rec.vep_attribute2, hr_api.g_varchar2) or
698: nvl(ben_vep_shd.g_old_rec.vep_attribute3, hr_api.g_varchar2) <>
699: nvl(p_rec.vep_attribute3, hr_api.g_varchar2) or
700: nvl(ben_vep_shd.g_old_rec.vep_attribute4, hr_api.g_varchar2) <>

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

694: nvl(ben_vep_shd.g_old_rec.vep_attribute1, hr_api.g_varchar2) <>
695: nvl(p_rec.vep_attribute1, hr_api.g_varchar2) or
696: nvl(ben_vep_shd.g_old_rec.vep_attribute2, hr_api.g_varchar2) <>
697: nvl(p_rec.vep_attribute2, hr_api.g_varchar2) or
698: nvl(ben_vep_shd.g_old_rec.vep_attribute3, hr_api.g_varchar2) <>
699: nvl(p_rec.vep_attribute3, hr_api.g_varchar2) or
700: nvl(ben_vep_shd.g_old_rec.vep_attribute4, hr_api.g_varchar2) <>
701: nvl(p_rec.vep_attribute4, hr_api.g_varchar2) or
702: nvl(ben_vep_shd.g_old_rec.vep_attribute5, hr_api.g_varchar2) <>

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

696: nvl(ben_vep_shd.g_old_rec.vep_attribute2, hr_api.g_varchar2) <>
697: nvl(p_rec.vep_attribute2, hr_api.g_varchar2) or
698: nvl(ben_vep_shd.g_old_rec.vep_attribute3, hr_api.g_varchar2) <>
699: nvl(p_rec.vep_attribute3, hr_api.g_varchar2) or
700: nvl(ben_vep_shd.g_old_rec.vep_attribute4, hr_api.g_varchar2) <>
701: nvl(p_rec.vep_attribute4, hr_api.g_varchar2) or
702: nvl(ben_vep_shd.g_old_rec.vep_attribute5, hr_api.g_varchar2) <>
703: nvl(p_rec.vep_attribute5, hr_api.g_varchar2) or
704: nvl(ben_vep_shd.g_old_rec.vep_attribute6, hr_api.g_varchar2) <>

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

698: nvl(ben_vep_shd.g_old_rec.vep_attribute3, hr_api.g_varchar2) <>
699: nvl(p_rec.vep_attribute3, hr_api.g_varchar2) or
700: nvl(ben_vep_shd.g_old_rec.vep_attribute4, hr_api.g_varchar2) <>
701: nvl(p_rec.vep_attribute4, hr_api.g_varchar2) or
702: nvl(ben_vep_shd.g_old_rec.vep_attribute5, hr_api.g_varchar2) <>
703: nvl(p_rec.vep_attribute5, hr_api.g_varchar2) or
704: nvl(ben_vep_shd.g_old_rec.vep_attribute6, hr_api.g_varchar2) <>
705: nvl(p_rec.vep_attribute6, hr_api.g_varchar2) or
706: nvl(ben_vep_shd.g_old_rec.vep_attribute7, hr_api.g_varchar2) <>

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

700: nvl(ben_vep_shd.g_old_rec.vep_attribute4, hr_api.g_varchar2) <>
701: nvl(p_rec.vep_attribute4, hr_api.g_varchar2) or
702: nvl(ben_vep_shd.g_old_rec.vep_attribute5, hr_api.g_varchar2) <>
703: nvl(p_rec.vep_attribute5, hr_api.g_varchar2) or
704: nvl(ben_vep_shd.g_old_rec.vep_attribute6, hr_api.g_varchar2) <>
705: nvl(p_rec.vep_attribute6, hr_api.g_varchar2) or
706: nvl(ben_vep_shd.g_old_rec.vep_attribute7, hr_api.g_varchar2) <>
707: nvl(p_rec.vep_attribute7, hr_api.g_varchar2) or
708: nvl(ben_vep_shd.g_old_rec.vep_attribute8, hr_api.g_varchar2) <>

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

702: nvl(ben_vep_shd.g_old_rec.vep_attribute5, hr_api.g_varchar2) <>
703: nvl(p_rec.vep_attribute5, hr_api.g_varchar2) or
704: nvl(ben_vep_shd.g_old_rec.vep_attribute6, hr_api.g_varchar2) <>
705: nvl(p_rec.vep_attribute6, hr_api.g_varchar2) or
706: nvl(ben_vep_shd.g_old_rec.vep_attribute7, hr_api.g_varchar2) <>
707: nvl(p_rec.vep_attribute7, hr_api.g_varchar2) or
708: nvl(ben_vep_shd.g_old_rec.vep_attribute8, hr_api.g_varchar2) <>
709: nvl(p_rec.vep_attribute8, hr_api.g_varchar2) or
710: nvl(ben_vep_shd.g_old_rec.vep_attribute9, hr_api.g_varchar2) <>

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

704: nvl(ben_vep_shd.g_old_rec.vep_attribute6, hr_api.g_varchar2) <>
705: nvl(p_rec.vep_attribute6, hr_api.g_varchar2) or
706: nvl(ben_vep_shd.g_old_rec.vep_attribute7, hr_api.g_varchar2) <>
707: nvl(p_rec.vep_attribute7, hr_api.g_varchar2) or
708: nvl(ben_vep_shd.g_old_rec.vep_attribute8, hr_api.g_varchar2) <>
709: nvl(p_rec.vep_attribute8, hr_api.g_varchar2) or
710: nvl(ben_vep_shd.g_old_rec.vep_attribute9, hr_api.g_varchar2) <>
711: nvl(p_rec.vep_attribute9, hr_api.g_varchar2) or
712: nvl(ben_vep_shd.g_old_rec.vep_attribute10, hr_api.g_varchar2) <>

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

706: nvl(ben_vep_shd.g_old_rec.vep_attribute7, hr_api.g_varchar2) <>
707: nvl(p_rec.vep_attribute7, hr_api.g_varchar2) or
708: nvl(ben_vep_shd.g_old_rec.vep_attribute8, hr_api.g_varchar2) <>
709: nvl(p_rec.vep_attribute8, hr_api.g_varchar2) or
710: nvl(ben_vep_shd.g_old_rec.vep_attribute9, hr_api.g_varchar2) <>
711: nvl(p_rec.vep_attribute9, hr_api.g_varchar2) or
712: nvl(ben_vep_shd.g_old_rec.vep_attribute10, hr_api.g_varchar2) <>
713: nvl(p_rec.vep_attribute10, hr_api.g_varchar2) or
714: nvl(ben_vep_shd.g_old_rec.vep_attribute11, hr_api.g_varchar2) <>

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

708: nvl(ben_vep_shd.g_old_rec.vep_attribute8, hr_api.g_varchar2) <>
709: nvl(p_rec.vep_attribute8, hr_api.g_varchar2) or
710: nvl(ben_vep_shd.g_old_rec.vep_attribute9, hr_api.g_varchar2) <>
711: nvl(p_rec.vep_attribute9, hr_api.g_varchar2) or
712: nvl(ben_vep_shd.g_old_rec.vep_attribute10, hr_api.g_varchar2) <>
713: nvl(p_rec.vep_attribute10, hr_api.g_varchar2) or
714: nvl(ben_vep_shd.g_old_rec.vep_attribute11, hr_api.g_varchar2) <>
715: nvl(p_rec.vep_attribute11, hr_api.g_varchar2) or
716: nvl(ben_vep_shd.g_old_rec.vep_attribute12, hr_api.g_varchar2) <>

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

710: nvl(ben_vep_shd.g_old_rec.vep_attribute9, hr_api.g_varchar2) <>
711: nvl(p_rec.vep_attribute9, hr_api.g_varchar2) or
712: nvl(ben_vep_shd.g_old_rec.vep_attribute10, hr_api.g_varchar2) <>
713: nvl(p_rec.vep_attribute10, hr_api.g_varchar2) or
714: nvl(ben_vep_shd.g_old_rec.vep_attribute11, hr_api.g_varchar2) <>
715: nvl(p_rec.vep_attribute11, hr_api.g_varchar2) or
716: nvl(ben_vep_shd.g_old_rec.vep_attribute12, hr_api.g_varchar2) <>
717: nvl(p_rec.vep_attribute12, hr_api.g_varchar2) or
718: nvl(ben_vep_shd.g_old_rec.vep_attribute13, hr_api.g_varchar2) <>

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

712: nvl(ben_vep_shd.g_old_rec.vep_attribute10, hr_api.g_varchar2) <>
713: nvl(p_rec.vep_attribute10, hr_api.g_varchar2) or
714: nvl(ben_vep_shd.g_old_rec.vep_attribute11, hr_api.g_varchar2) <>
715: nvl(p_rec.vep_attribute11, hr_api.g_varchar2) or
716: nvl(ben_vep_shd.g_old_rec.vep_attribute12, hr_api.g_varchar2) <>
717: nvl(p_rec.vep_attribute12, hr_api.g_varchar2) or
718: nvl(ben_vep_shd.g_old_rec.vep_attribute13, hr_api.g_varchar2) <>
719: nvl(p_rec.vep_attribute13, hr_api.g_varchar2) or
720: nvl(ben_vep_shd.g_old_rec.vep_attribute14, hr_api.g_varchar2) <>

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

714: nvl(ben_vep_shd.g_old_rec.vep_attribute11, hr_api.g_varchar2) <>
715: nvl(p_rec.vep_attribute11, hr_api.g_varchar2) or
716: nvl(ben_vep_shd.g_old_rec.vep_attribute12, hr_api.g_varchar2) <>
717: nvl(p_rec.vep_attribute12, hr_api.g_varchar2) or
718: nvl(ben_vep_shd.g_old_rec.vep_attribute13, hr_api.g_varchar2) <>
719: nvl(p_rec.vep_attribute13, hr_api.g_varchar2) or
720: nvl(ben_vep_shd.g_old_rec.vep_attribute14, hr_api.g_varchar2) <>
721: nvl(p_rec.vep_attribute14, hr_api.g_varchar2) or
722: nvl(ben_vep_shd.g_old_rec.vep_attribute15, hr_api.g_varchar2) <>

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

716: nvl(ben_vep_shd.g_old_rec.vep_attribute12, hr_api.g_varchar2) <>
717: nvl(p_rec.vep_attribute12, hr_api.g_varchar2) or
718: nvl(ben_vep_shd.g_old_rec.vep_attribute13, hr_api.g_varchar2) <>
719: nvl(p_rec.vep_attribute13, hr_api.g_varchar2) or
720: nvl(ben_vep_shd.g_old_rec.vep_attribute14, hr_api.g_varchar2) <>
721: nvl(p_rec.vep_attribute14, hr_api.g_varchar2) or
722: nvl(ben_vep_shd.g_old_rec.vep_attribute15, hr_api.g_varchar2) <>
723: nvl(p_rec.vep_attribute15, hr_api.g_varchar2) or
724: nvl(ben_vep_shd.g_old_rec.vep_attribute16, hr_api.g_varchar2) <>

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

718: nvl(ben_vep_shd.g_old_rec.vep_attribute13, hr_api.g_varchar2) <>
719: nvl(p_rec.vep_attribute13, hr_api.g_varchar2) or
720: nvl(ben_vep_shd.g_old_rec.vep_attribute14, hr_api.g_varchar2) <>
721: nvl(p_rec.vep_attribute14, hr_api.g_varchar2) or
722: nvl(ben_vep_shd.g_old_rec.vep_attribute15, hr_api.g_varchar2) <>
723: nvl(p_rec.vep_attribute15, hr_api.g_varchar2) or
724: nvl(ben_vep_shd.g_old_rec.vep_attribute16, hr_api.g_varchar2) <>
725: nvl(p_rec.vep_attribute16, hr_api.g_varchar2) or
726: nvl(ben_vep_shd.g_old_rec.vep_attribute17, hr_api.g_varchar2) <>

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

720: nvl(ben_vep_shd.g_old_rec.vep_attribute14, hr_api.g_varchar2) <>
721: nvl(p_rec.vep_attribute14, hr_api.g_varchar2) or
722: nvl(ben_vep_shd.g_old_rec.vep_attribute15, hr_api.g_varchar2) <>
723: nvl(p_rec.vep_attribute15, hr_api.g_varchar2) or
724: nvl(ben_vep_shd.g_old_rec.vep_attribute16, hr_api.g_varchar2) <>
725: nvl(p_rec.vep_attribute16, hr_api.g_varchar2) or
726: nvl(ben_vep_shd.g_old_rec.vep_attribute17, hr_api.g_varchar2) <>
727: nvl(p_rec.vep_attribute17, hr_api.g_varchar2) or
728: nvl(ben_vep_shd.g_old_rec.vep_attribute18, hr_api.g_varchar2) <>

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

722: nvl(ben_vep_shd.g_old_rec.vep_attribute15, hr_api.g_varchar2) <>
723: nvl(p_rec.vep_attribute15, hr_api.g_varchar2) or
724: nvl(ben_vep_shd.g_old_rec.vep_attribute16, hr_api.g_varchar2) <>
725: nvl(p_rec.vep_attribute16, hr_api.g_varchar2) or
726: nvl(ben_vep_shd.g_old_rec.vep_attribute17, hr_api.g_varchar2) <>
727: nvl(p_rec.vep_attribute17, hr_api.g_varchar2) or
728: nvl(ben_vep_shd.g_old_rec.vep_attribute18, hr_api.g_varchar2) <>
729: nvl(p_rec.vep_attribute18, hr_api.g_varchar2) or
730: nvl(ben_vep_shd.g_old_rec.vep_attribute19, hr_api.g_varchar2) <>

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

724: nvl(ben_vep_shd.g_old_rec.vep_attribute16, hr_api.g_varchar2) <>
725: nvl(p_rec.vep_attribute16, hr_api.g_varchar2) or
726: nvl(ben_vep_shd.g_old_rec.vep_attribute17, hr_api.g_varchar2) <>
727: nvl(p_rec.vep_attribute17, hr_api.g_varchar2) or
728: nvl(ben_vep_shd.g_old_rec.vep_attribute18, hr_api.g_varchar2) <>
729: nvl(p_rec.vep_attribute18, hr_api.g_varchar2) or
730: nvl(ben_vep_shd.g_old_rec.vep_attribute19, hr_api.g_varchar2) <>
731: nvl(p_rec.vep_attribute19, hr_api.g_varchar2) or
732: nvl(ben_vep_shd.g_old_rec.vep_attribute20, hr_api.g_varchar2) <>

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

726: nvl(ben_vep_shd.g_old_rec.vep_attribute17, hr_api.g_varchar2) <>
727: nvl(p_rec.vep_attribute17, hr_api.g_varchar2) or
728: nvl(ben_vep_shd.g_old_rec.vep_attribute18, hr_api.g_varchar2) <>
729: nvl(p_rec.vep_attribute18, hr_api.g_varchar2) or
730: nvl(ben_vep_shd.g_old_rec.vep_attribute19, hr_api.g_varchar2) <>
731: nvl(p_rec.vep_attribute19, hr_api.g_varchar2) or
732: nvl(ben_vep_shd.g_old_rec.vep_attribute20, hr_api.g_varchar2) <>
733: nvl(p_rec.vep_attribute20, hr_api.g_varchar2) or
734: nvl(ben_vep_shd.g_old_rec.vep_attribute21, hr_api.g_varchar2) <>

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

728: nvl(ben_vep_shd.g_old_rec.vep_attribute18, hr_api.g_varchar2) <>
729: nvl(p_rec.vep_attribute18, hr_api.g_varchar2) or
730: nvl(ben_vep_shd.g_old_rec.vep_attribute19, hr_api.g_varchar2) <>
731: nvl(p_rec.vep_attribute19, hr_api.g_varchar2) or
732: nvl(ben_vep_shd.g_old_rec.vep_attribute20, hr_api.g_varchar2) <>
733: nvl(p_rec.vep_attribute20, hr_api.g_varchar2) or
734: nvl(ben_vep_shd.g_old_rec.vep_attribute21, hr_api.g_varchar2) <>
735: nvl(p_rec.vep_attribute21, hr_api.g_varchar2) or
736: nvl(ben_vep_shd.g_old_rec.vep_attribute22, hr_api.g_varchar2) <>

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

730: nvl(ben_vep_shd.g_old_rec.vep_attribute19, hr_api.g_varchar2) <>
731: nvl(p_rec.vep_attribute19, hr_api.g_varchar2) or
732: nvl(ben_vep_shd.g_old_rec.vep_attribute20, hr_api.g_varchar2) <>
733: nvl(p_rec.vep_attribute20, hr_api.g_varchar2) or
734: nvl(ben_vep_shd.g_old_rec.vep_attribute21, hr_api.g_varchar2) <>
735: nvl(p_rec.vep_attribute21, hr_api.g_varchar2) or
736: nvl(ben_vep_shd.g_old_rec.vep_attribute22, hr_api.g_varchar2) <>
737: nvl(p_rec.vep_attribute22, hr_api.g_varchar2) or
738: nvl(ben_vep_shd.g_old_rec.vep_attribute23, hr_api.g_varchar2) <>

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

732: nvl(ben_vep_shd.g_old_rec.vep_attribute20, hr_api.g_varchar2) <>
733: nvl(p_rec.vep_attribute20, hr_api.g_varchar2) or
734: nvl(ben_vep_shd.g_old_rec.vep_attribute21, hr_api.g_varchar2) <>
735: nvl(p_rec.vep_attribute21, hr_api.g_varchar2) or
736: nvl(ben_vep_shd.g_old_rec.vep_attribute22, hr_api.g_varchar2) <>
737: nvl(p_rec.vep_attribute22, hr_api.g_varchar2) or
738: nvl(ben_vep_shd.g_old_rec.vep_attribute23, hr_api.g_varchar2) <>
739: nvl(p_rec.vep_attribute23, hr_api.g_varchar2) or
740: nvl(ben_vep_shd.g_old_rec.vep_attribute24, hr_api.g_varchar2) <>

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

734: nvl(ben_vep_shd.g_old_rec.vep_attribute21, hr_api.g_varchar2) <>
735: nvl(p_rec.vep_attribute21, hr_api.g_varchar2) or
736: nvl(ben_vep_shd.g_old_rec.vep_attribute22, hr_api.g_varchar2) <>
737: nvl(p_rec.vep_attribute22, hr_api.g_varchar2) or
738: nvl(ben_vep_shd.g_old_rec.vep_attribute23, hr_api.g_varchar2) <>
739: nvl(p_rec.vep_attribute23, hr_api.g_varchar2) or
740: nvl(ben_vep_shd.g_old_rec.vep_attribute24, hr_api.g_varchar2) <>
741: nvl(p_rec.vep_attribute24, hr_api.g_varchar2) or
742: nvl(ben_vep_shd.g_old_rec.vep_attribute25, hr_api.g_varchar2) <>

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

736: nvl(ben_vep_shd.g_old_rec.vep_attribute22, hr_api.g_varchar2) <>
737: nvl(p_rec.vep_attribute22, hr_api.g_varchar2) or
738: nvl(ben_vep_shd.g_old_rec.vep_attribute23, hr_api.g_varchar2) <>
739: nvl(p_rec.vep_attribute23, hr_api.g_varchar2) or
740: nvl(ben_vep_shd.g_old_rec.vep_attribute24, hr_api.g_varchar2) <>
741: nvl(p_rec.vep_attribute24, hr_api.g_varchar2) or
742: nvl(ben_vep_shd.g_old_rec.vep_attribute25, hr_api.g_varchar2) <>
743: nvl(p_rec.vep_attribute25, hr_api.g_varchar2) or
744: nvl(ben_vep_shd.g_old_rec.vep_attribute26, hr_api.g_varchar2) <>

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

738: nvl(ben_vep_shd.g_old_rec.vep_attribute23, hr_api.g_varchar2) <>
739: nvl(p_rec.vep_attribute23, hr_api.g_varchar2) or
740: nvl(ben_vep_shd.g_old_rec.vep_attribute24, hr_api.g_varchar2) <>
741: nvl(p_rec.vep_attribute24, hr_api.g_varchar2) or
742: nvl(ben_vep_shd.g_old_rec.vep_attribute25, hr_api.g_varchar2) <>
743: nvl(p_rec.vep_attribute25, hr_api.g_varchar2) or
744: nvl(ben_vep_shd.g_old_rec.vep_attribute26, hr_api.g_varchar2) <>
745: nvl(p_rec.vep_attribute26, hr_api.g_varchar2) or
746: nvl(ben_vep_shd.g_old_rec.vep_attribute27, hr_api.g_varchar2) <>

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

740: nvl(ben_vep_shd.g_old_rec.vep_attribute24, hr_api.g_varchar2) <>
741: nvl(p_rec.vep_attribute24, hr_api.g_varchar2) or
742: nvl(ben_vep_shd.g_old_rec.vep_attribute25, hr_api.g_varchar2) <>
743: nvl(p_rec.vep_attribute25, hr_api.g_varchar2) or
744: nvl(ben_vep_shd.g_old_rec.vep_attribute26, hr_api.g_varchar2) <>
745: nvl(p_rec.vep_attribute26, hr_api.g_varchar2) or
746: nvl(ben_vep_shd.g_old_rec.vep_attribute27, hr_api.g_varchar2) <>
747: nvl(p_rec.vep_attribute27, hr_api.g_varchar2) or
748: nvl(ben_vep_shd.g_old_rec.vep_attribute28, hr_api.g_varchar2) <>

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

742: nvl(ben_vep_shd.g_old_rec.vep_attribute25, hr_api.g_varchar2) <>
743: nvl(p_rec.vep_attribute25, hr_api.g_varchar2) or
744: nvl(ben_vep_shd.g_old_rec.vep_attribute26, hr_api.g_varchar2) <>
745: nvl(p_rec.vep_attribute26, hr_api.g_varchar2) or
746: nvl(ben_vep_shd.g_old_rec.vep_attribute27, hr_api.g_varchar2) <>
747: nvl(p_rec.vep_attribute27, hr_api.g_varchar2) or
748: nvl(ben_vep_shd.g_old_rec.vep_attribute28, hr_api.g_varchar2) <>
749: nvl(p_rec.vep_attribute28, hr_api.g_varchar2) or
750: nvl(ben_vep_shd.g_old_rec.vep_attribute29, hr_api.g_varchar2) <>

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

744: nvl(ben_vep_shd.g_old_rec.vep_attribute26, hr_api.g_varchar2) <>
745: nvl(p_rec.vep_attribute26, hr_api.g_varchar2) or
746: nvl(ben_vep_shd.g_old_rec.vep_attribute27, hr_api.g_varchar2) <>
747: nvl(p_rec.vep_attribute27, hr_api.g_varchar2) or
748: nvl(ben_vep_shd.g_old_rec.vep_attribute28, hr_api.g_varchar2) <>
749: nvl(p_rec.vep_attribute28, hr_api.g_varchar2) or
750: nvl(ben_vep_shd.g_old_rec.vep_attribute29, hr_api.g_varchar2) <>
751: nvl(p_rec.vep_attribute29, hr_api.g_varchar2) or
752: nvl(ben_vep_shd.g_old_rec.vep_attribute30, hr_api.g_varchar2) <>

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

746: nvl(ben_vep_shd.g_old_rec.vep_attribute27, hr_api.g_varchar2) <>
747: nvl(p_rec.vep_attribute27, hr_api.g_varchar2) or
748: nvl(ben_vep_shd.g_old_rec.vep_attribute28, hr_api.g_varchar2) <>
749: nvl(p_rec.vep_attribute28, hr_api.g_varchar2) or
750: nvl(ben_vep_shd.g_old_rec.vep_attribute29, hr_api.g_varchar2) <>
751: nvl(p_rec.vep_attribute29, hr_api.g_varchar2) or
752: nvl(ben_vep_shd.g_old_rec.vep_attribute30, hr_api.g_varchar2) <>
753: nvl(p_rec.vep_attribute30, hr_api.g_varchar2) ))
754: or (p_rec.vrbl_rt_elig_prfl_idis null) then

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

748: nvl(ben_vep_shd.g_old_rec.vep_attribute28, hr_api.g_varchar2) <>
749: nvl(p_rec.vep_attribute28, hr_api.g_varchar2) or
750: nvl(ben_vep_shd.g_old_rec.vep_attribute29, hr_api.g_varchar2) <>
751: nvl(p_rec.vep_attribute29, hr_api.g_varchar2) or
752: nvl(ben_vep_shd.g_old_rec.vep_attribute30, hr_api.g_varchar2) <>
753: nvl(p_rec.vep_attribute30, hr_api.g_varchar2) ))
754: or (p_rec.vrbl_rt_elig_prfl_idis null) then
755: --
756: -- Only execute the validation if absolutely necessary:

Line 862: ,p_rec in ben_vep_shd.g_rec_type

858: -- {End Of Comments}
859: -- ----------------------------------------------------------------------------
860: Procedure chk_non_updateable_args
861: (p_effective_date in date
862: ,p_rec in ben_vep_shd.g_rec_type
863: ) IS
864: --
865: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
866: l_error EXCEPTION;

Line 874: IF NOT ben_vep_shd.api_updating

870: --
871: -- Only proceed with the validation if a row exists for the current
872: -- record in the HR Schema.
873: --
874: IF NOT ben_vep_shd.api_updating
875: (p_vrbl_rt_elig_prfl_id => p_rec.vrbl_rt_elig_prfl_id
876: ,p_effective_date => p_effective_date
877: ,p_object_version_number => p_rec.object_version_number
878: ) THEN

Line 1249: (p_rec in ben_vep_shd.g_rec_type

1245: -- ----------------------------------------------------------------------------
1246: -- |---------------------------< insert_validate >----------------------------|
1247: -- ----------------------------------------------------------------------------
1248: Procedure insert_validate
1249: (p_rec in ben_vep_shd.g_rec_type
1250: ,p_effective_date in date
1251: ,p_datetrack_mode in varchar2
1252: ,p_validation_start_date in date
1253: ,p_validation_end_date in date

Line 1318: (p_rec in ben_vep_shd.g_rec_type

1314: -- ----------------------------------------------------------------------------
1315: -- |---------------------------< update_validate >----------------------------|
1316: -- ----------------------------------------------------------------------------
1317: Procedure update_validate
1318: (p_rec in ben_vep_shd.g_rec_type
1319: ,p_effective_date in date
1320: ,p_datetrack_mode in varchar2
1321: ,p_validation_start_date in date
1322: ,p_validation_end_date in date

Line 1401: (p_rec in ben_vep_shd.g_rec_type

1397: -- ----------------------------------------------------------------------------
1398: -- |---------------------------< delete_validate >----------------------------|
1399: -- ----------------------------------------------------------------------------
1400: Procedure delete_validate
1401: (p_rec in ben_vep_shd.g_rec_type
1402: ,p_effective_date in date
1403: ,p_datetrack_mode in varchar2
1404: ,p_validation_start_date in date
1405: ,p_validation_end_date in date