DBA Data[Home] [Help]

APPS.BEN_BRR_BUS dependencies on BEN_BRR_SHD

Line 48: l_api_updating := ben_brr_shd.api_updating

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

Line 55: <> ben_brr_shd.g_old_rec.bnft_vrbl_rt_rl_id) then

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

Line 59: ben_brr_shd.constraint_error('BEN_BNFT_VRBL_RT_RL_F_PK');

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

Line 69: ben_brr_shd.constraint_error('BEN_BNFT_VRBL_RT_RL_F_PK');

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

Line 188: l_api_updating := ben_brr_shd.api_updating

184: Begin
185: --
186: hr_utility.set_location('Entering:'||l_proc, 5);
187: --
188: l_api_updating := ben_brr_shd.api_updating
189: (p_effective_date => p_effective_date,
190: p_bnft_vrbl_rt_rl_id => p_bnft_vrbl_rt_rl_id,
191: p_object_version_number => p_object_version_number);
192: --

Line 276: l_api_updating := ben_brr_shd.api_updating

272: Begin
273: --
274: hr_utility.set_location('Entering:'||l_proc, 5);
275: --
276: l_api_updating := ben_brr_shd.api_updating
277: (p_bnft_vrbl_rt_rl_id => p_bnft_vrbl_rt_rl_id,
278: p_effective_date => p_effective_date,
279: p_object_version_number => p_object_version_number);
280: --

Line 283: <> ben_brr_shd.g_old_rec.formula_id

279: p_object_version_number => p_object_version_number);
280: --
281: if (l_api_updating
282: and nvl(p_formula_id,hr_api.g_number)
283: <> ben_brr_shd.g_old_rec.formula_id
284: or not l_api_updating)
285: and p_formula_id is not null then
286: --
287: -- check if value of formula rule is valid.

Line 522: (p_rec in ben_brr_shd.g_rec_type,

518: -- ----------------------------------------------------------------------------
519: -- |---------------------------< insert_validate >----------------------------|
520: -- ----------------------------------------------------------------------------
521: Procedure insert_validate
522: (p_rec in ben_brr_shd.g_rec_type,
523: p_effective_date in date,
524: p_datetrack_mode in varchar2,
525: p_validation_start_date in date,
526: p_validation_end_date in date) is

Line 570: (p_rec in ben_brr_shd.g_rec_type,

566: -- ----------------------------------------------------------------------------
567: -- |---------------------------< update_validate >----------------------------|
568: -- ----------------------------------------------------------------------------
569: Procedure update_validate
570: (p_rec in ben_brr_shd.g_rec_type,
571: p_effective_date in date,
572: p_datetrack_mode in varchar2,
573: p_validation_start_date in date,
574: p_validation_end_date in date) is

Line 626: (p_rec in ben_brr_shd.g_rec_type,

622: -- ----------------------------------------------------------------------------
623: -- |---------------------------< delete_validate >----------------------------|
624: -- ----------------------------------------------------------------------------
625: Procedure delete_validate
626: (p_rec in ben_brr_shd.g_rec_type,
627: p_effective_date in date,
628: p_datetrack_mode in varchar2,
629: p_validation_start_date in date,
630: p_validation_end_date in date) is