DBA Data[Home] [Help]

APPS.BEN_VMR_BUS dependencies on BEN_VMR_SHD

Line 48: l_api_updating := ben_vmr_shd.api_updating

44: Begin
45: --
46: hr_utility.set_location('Entering:'||l_proc, 5);
47: --
48: l_api_updating := ben_vmr_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_vrbl_mtchg_rt_id => p_vrbl_mtchg_rt_id,
51: p_object_version_number => p_object_version_number);
52: --

Line 55: <> ben_vmr_shd.g_old_rec.vrbl_mtchg_rt_id) then

51: p_object_version_number => p_object_version_number);
52: --
53: if (l_api_updating
54: and nvl(p_vrbl_mtchg_rt_id,hr_api.g_number)
55: <> ben_vmr_shd.g_old_rec.vrbl_mtchg_rt_id) then
56: --
57: -- raise error as PK has changed
58: --
59: ben_vmr_shd.constraint_error('BEN_VRBL_MTCHG_RT_PK');

Line 59: ben_vmr_shd.constraint_error('BEN_VRBL_MTCHG_RT_PK');

55: <> ben_vmr_shd.g_old_rec.vrbl_mtchg_rt_id) then
56: --
57: -- raise error as PK has changed
58: --
59: ben_vmr_shd.constraint_error('BEN_VRBL_MTCHG_RT_PK');
60: --
61: elsif not l_api_updating then
62: --
63: -- check if PK is null

Line 69: ben_vmr_shd.constraint_error('BEN_VRBL_MTCHG_RT_PK');

65: if p_vrbl_mtchg_rt_id is not null then
66: --
67: -- raise error as PK is not null
68: --
69: ben_vmr_shd.constraint_error('BEN_VRBL_MTCHG_RT_PK');
70: --
71: end if;
72: --
73: end if;

Line 175: l_api_updating := ben_vmr_shd.api_updating

171: Begin
172: --
173: hr_utility.set_location('Entering:'||l_proc, 5);
174: --
175: l_api_updating := ben_vmr_shd.api_updating
176: (p_vrbl_mtchg_rt_id => p_vrbl_mtchg_rt_id,
177: p_effective_date => p_effective_date,
178: p_object_version_number => p_object_version_number);
179: --

Line 182: <> nvl(ben_vmr_shd.g_old_rec.no_mx_amt_of_py_num_flag,hr_api.g_varchar2)

178: p_object_version_number => p_object_version_number);
179: --
180: if (l_api_updating
181: and p_no_mx_amt_of_py_num_flag
182: <> nvl(ben_vmr_shd.g_old_rec.no_mx_amt_of_py_num_flag,hr_api.g_varchar2)
183: or not l_api_updating) then
184: --
185: -- check if value of lookup falls within lookup type.
186: --

Line 244: l_api_updating := ben_vmr_shd.api_updating

240: Begin
241: --
242: hr_utility.set_location('Entering:'||l_proc, 5);
243: --
244: l_api_updating := ben_vmr_shd.api_updating
245: (p_vrbl_mtchg_rt_id => p_vrbl_mtchg_rt_id,
246: p_effective_date => p_effective_date,
247: p_object_version_number => p_object_version_number);
248: --

Line 251: <> nvl(ben_vmr_shd.g_old_rec.no_mx_pct_of_py_num_flag,hr_api.g_varchar2)

247: p_object_version_number => p_object_version_number);
248: --
249: if (l_api_updating
250: and p_no_mx_pct_of_py_num_flag
251: <> nvl(ben_vmr_shd.g_old_rec.no_mx_pct_of_py_num_flag,hr_api.g_varchar2)
252: or not l_api_updating) then
253: --
254: -- check if value of lookup falls within lookup type.
255: --

Line 313: l_api_updating := ben_vmr_shd.api_updating

309: Begin
310: --
311: hr_utility.set_location('Entering:'||l_proc, 5);
312: --
313: l_api_updating := ben_vmr_shd.api_updating
314: (p_vrbl_mtchg_rt_id => p_vrbl_mtchg_rt_id,
315: p_effective_date => p_effective_date,
316: p_object_version_number => p_object_version_number);
317: --

Line 320: <> nvl(ben_vmr_shd.g_old_rec.cntnu_mtch_aftr_max_rl_flag,hr_api.g_varchar2)

316: p_object_version_number => p_object_version_number);
317: --
318: if (l_api_updating
319: and p_cntnu_mtch_aftr_max_rl_flag
320: <> nvl(ben_vmr_shd.g_old_rec.cntnu_mtch_aftr_max_rl_flag,hr_api.g_varchar2)
321: or not l_api_updating) then
322: --
323: -- check if value of lookup falls within lookup type.
324: --

Line 399: l_api_updating := ben_vmr_shd.api_updating

395: Begin
396: --
397: hr_utility.set_location('Entering:'||l_proc, 5);
398: --
399: l_api_updating := ben_vmr_shd.api_updating
400: (p_vrbl_mtchg_rt_id => p_vrbl_mtchg_rt_id,
401: p_effective_date => p_effective_date,
402: p_object_version_number => p_object_version_number);
403: --

Line 406: <> ben_vmr_shd.g_old_rec.mtchg_rt_calc_rl

402: p_object_version_number => p_object_version_number);
403: --
404: if (l_api_updating
405: and nvl(p_mtchg_rt_calc_rl,hr_api.g_number)
406: <> ben_vmr_shd.g_old_rec.mtchg_rt_calc_rl
407: or not l_api_updating)
408: and p_mtchg_rt_calc_rl is not null then
409: --
410: -- check if value of formula rule is valid.

Line 478: l_api_updating := ben_vmr_shd.api_updating

474: Begin
475: --
476: hr_utility.set_location('Entering:'||l_proc, 5);
477: --
478: l_api_updating := ben_vmr_shd.api_updating
479: (p_vrbl_mtchg_rt_id => p_vrbl_mtchg_rt_id,
480: p_effective_date => p_effective_date,
481: p_object_version_number => p_object_version_number);
482: --

Line 485: <> nvl(ben_vmr_shd.g_old_rec.no_mx_mtch_amt_flag,hr_api.g_varchar2)

481: p_object_version_number => p_object_version_number);
482: --
483: if (l_api_updating
484: and p_no_mx_mtch_amt_flag
485: <> nvl(ben_vmr_shd.g_old_rec.no_mx_mtch_amt_flag,hr_api.g_varchar2)
486: or not l_api_updating) then
487: --
488: -- check if value of lookup falls within lookup type.
489: --

Line 717: (p_rec in ben_vmr_shd.g_rec_type,

713: -- ----------------------------------------------------------------------------
714: -- |---------------------------< insert_validate >----------------------------|
715: -- ----------------------------------------------------------------------------
716: Procedure insert_validate
717: (p_rec in ben_vmr_shd.g_rec_type,
718: p_effective_date in date,
719: p_datetrack_mode in varchar2,
720: p_validation_start_date in date,
721: p_validation_end_date in date) is

Line 782: (p_rec in ben_vmr_shd.g_rec_type,

778: -- ----------------------------------------------------------------------------
779: -- |---------------------------< update_validate >----------------------------|
780: -- ----------------------------------------------------------------------------
781: Procedure update_validate
782: (p_rec in ben_vmr_shd.g_rec_type,
783: p_effective_date in date,
784: p_datetrack_mode in varchar2,
785: p_validation_start_date in date,
786: p_validation_end_date in date) is

Line 855: (p_rec in ben_vmr_shd.g_rec_type,

851: -- ----------------------------------------------------------------------------
852: -- |---------------------------< delete_validate >----------------------------|
853: -- ----------------------------------------------------------------------------
854: Procedure delete_validate
855: (p_rec in ben_vmr_shd.g_rec_type,
856: p_effective_date in date,
857: p_datetrack_mode in varchar2,
858: p_validation_start_date in date,
859: p_validation_end_date in date) is