DBA Data[Home] [Help]

APPS.BEN_RVC_BUS dependencies on BEN_RVC_SHD

Line 46: l_api_updating := ben_rvc_shd.api_updating

42: Begin
43: --
44: hr_utility.set_location('Entering:'||l_proc, 5);
45: --
46: l_api_updating := ben_rvc_shd.api_updating
47: (p_prtt_rt_val_ctfn_prvdd_id => p_prtt_rt_val_ctfn_prvdd_id,
48: p_object_version_number => p_object_version_number);
49: --
50: if (l_api_updating

Line 52: <> ben_rvc_shd.g_old_rec.prtt_rt_val_ctfn_prvdd_id) then

48: p_object_version_number => p_object_version_number);
49: --
50: if (l_api_updating
51: and nvl(p_prtt_rt_val_ctfn_prvdd_id,hr_api.g_number)
52: <> ben_rvc_shd.g_old_rec.prtt_rt_val_ctfn_prvdd_id) then
53: --
54: -- raise error as PK has changed
55: --
56: ben_rvc_shd.constraint_error('BEN_prv_ctfn_prvdd_PK');

Line 56: ben_rvc_shd.constraint_error('BEN_prv_ctfn_prvdd_PK');

52: <> ben_rvc_shd.g_old_rec.prtt_rt_val_ctfn_prvdd_id) then
53: --
54: -- raise error as PK has changed
55: --
56: ben_rvc_shd.constraint_error('BEN_prv_ctfn_prvdd_PK');
57: --
58: elsif not l_api_updating then
59: --
60: -- check if PK is null

Line 66: ben_rvc_shd.constraint_error('BEN_prv_ctfn_prvdd_PK');

62: if p_prtt_rt_val_ctfn_prvdd_id is not null then
63: --
64: -- raise error as PK is not null
65: --
66: ben_rvc_shd.constraint_error('BEN_prv_ctfn_prvdd_PK');
67: --
68: end if;
69: --
70: end if;

Line 114: l_api_updating := ben_rvc_shd.api_updating

110: Begin
111: --
112: hr_utility.set_location('Entering:'||l_proc, 5);
113: --
114: l_api_updating := ben_rvc_shd.api_updating
115: (p_prtt_rt_val_ctfn_prvdd_id => p_prtt_rt_val_ctfn_prvdd_id,
116: p_object_version_number => p_object_version_number);
117: --
118: if (l_api_updating

Line 120: <> nvl(ben_rvc_shd.g_old_rec.enrt_ctfn_rqd_flag,hr_api.g_varchar2)

116: p_object_version_number => p_object_version_number);
117: --
118: if (l_api_updating
119: and p_enrt_ctfn_rqd_flag
120: <> nvl(ben_rvc_shd.g_old_rec.enrt_ctfn_rqd_flag,hr_api.g_varchar2)
121: or not l_api_updating) then
122: --
123: -- check if value of lookup falls within lookup type.
124: --

Line 182: l_api_updating := ben_rvc_shd.api_updating

178: Begin
179: --
180: hr_utility.set_location('Entering:'||l_proc, 5);
181: --
182: l_api_updating := ben_rvc_shd.api_updating
183: (p_prtt_rt_val_ctfn_prvdd_id => p_prtt_rt_val_ctfn_prvdd_id,
184: p_object_version_number => p_object_version_number);
185: --
186: if (l_api_updating

Line 188: <> nvl(ben_rvc_shd.g_old_rec.enrt_ctfn_typ_cd,hr_api.g_varchar2)

184: p_object_version_number => p_object_version_number);
185: --
186: if (l_api_updating
187: and p_enrt_ctfn_typ_cd
188: <> nvl(ben_rvc_shd.g_old_rec.enrt_ctfn_typ_cd,hr_api.g_varchar2)
189: or not l_api_updating) then
190: --
191: -- check if value of lookup falls within lookup type.
192: --

Line 215: Procedure insert_validate(p_rec in ben_rvc_shd.g_rec_type

211: --
212: -- ----------------------------------------------------------------------------
213: -- |---------------------------< insert_validate >----------------------------|
214: -- ----------------------------------------------------------------------------
215: Procedure insert_validate(p_rec in ben_rvc_shd.g_rec_type
216: ,p_effective_date in date) is
217: --
218: l_proc varchar2(72) := g_package||'insert_validate';
219: --

Line 250: Procedure update_validate(p_rec in ben_rvc_shd.g_rec_type

246: --
247: -- ----------------------------------------------------------------------------
248: -- |---------------------------< update_validate >----------------------------|
249: -- ----------------------------------------------------------------------------
250: Procedure update_validate(p_rec in ben_rvc_shd.g_rec_type
251: ,p_effective_date in date) is
252: --
253: l_proc varchar2(72) := g_package||'update_validate';
254: --

Line 285: Procedure delete_validate(p_rec in ben_rvc_shd.g_rec_type

281: --
282: -- ----------------------------------------------------------------------------
283: -- |---------------------------< delete_validate >----------------------------|
284: -- ----------------------------------------------------------------------------
285: Procedure delete_validate(p_rec in ben_rvc_shd.g_rec_type
286: ,p_effective_date in date) is
287: --
288: l_proc varchar2(72) := g_package||'delete_validate';
289: --