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_DCL_BUS dependencies on BEN_DCL_SHD

Line 48: l_api_updating := ben_dcl_shd.api_updating

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

Line 55: <> ben_dcl_shd.g_old_rec.dpnt_cvrd_othr_pl_rt_id) then

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

Line 59: ben_dcl_shd.constraint_error('BEN_DPNT_CVRD_OTHR_PL_RT_PK');

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

Line 69: ben_dcl_shd.constraint_error('BEN_DPNT_CVRD_OTHR_PL_RT_PK');

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

Line 143: l_api_updating := ben_dcl_shd.api_updating

139: Begin
140: --
141: hr_utility.set_location('Entering:'||l_proc,5);
142: --
143: l_api_updating := ben_dcl_shd.api_updating
144: (p_dpnt_cvrd_othr_pl_rt_id => p_dpnt_cvrd_othr_pl_rt_id,
145: p_effective_date => p_effective_date,
146: p_object_version_number => p_object_version_number);
147: --

Line 150: <> nvl(ben_dcl_shd.g_old_rec.pl_id,hr_api.g_number)

146: p_object_version_number => p_object_version_number);
147: --
148: if (l_api_updating
149: and nvl(p_pl_id,hr_api.g_number)
150: <> nvl(ben_dcl_shd.g_old_rec.pl_id,hr_api.g_number)
151: or not l_api_updating) then
152: --
153: -- check if pl_id value exists in the plan table
154: open c1;

Line 164: ben_dcl_shd.constraint_error('BEN_DPNT_CVRD_OTHR_PL_RT_DT2');

160: --
161: -- raise error as FK does not relate to PK in the plan
162: -- table.
163: --
164: ben_dcl_shd.constraint_error('BEN_DPNT_CVRD_OTHR_PL_RT_DT2');
165: --
166: end if;
167: --
168: close c1;

Line 230: l_api_updating := ben_dcl_shd.api_updating

226: Begin
227: --
228: hr_utility.set_location('Entering:'||l_proc, 5);
229: --
230: l_api_updating := ben_dcl_shd.api_updating
231: (p_dpnt_cvrd_othr_pl_rt_id => p_dpnt_cvrd_othr_pl_rt_id,
232: p_effective_date => p_effective_date,
233: p_object_version_number => p_object_version_number);
234: --

Line 237: <> nvl(ben_dcl_shd.g_old_rec.cvg_det_dt_cd,hr_api.g_varchar2)

233: p_object_version_number => p_object_version_number);
234: --
235: if (l_api_updating
236: and p_cvg_det_dt_cd
237: <> nvl(ben_dcl_shd.g_old_rec.cvg_det_dt_cd,hr_api.g_varchar2)
238: or not l_api_updating)
239: and p_cvg_det_dt_cd is not null then
240: --
241: -- check if value of lookup falls within lookup type.

Line 301: l_api_updating := ben_dcl_shd.api_updating

297: Begin
298: --
299: hr_utility.set_location('Entering:'||l_proc, 5);
300: --
301: l_api_updating := ben_dcl_shd.api_updating
302: (p_dpnt_cvrd_othr_pl_rt_id => p_dpnt_cvrd_othr_pl_rt_id,
303: p_effective_date => p_effective_date,
304: p_object_version_number => p_object_version_number);
305: --

Line 308: <> nvl(ben_dcl_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

304: p_object_version_number => p_object_version_number);
305: --
306: if (l_api_updating
307: and p_excld_flag
308: <> nvl(ben_dcl_shd.g_old_rec.excld_flag,hr_api.g_varchar2)
309: or not l_api_updating) then
310: --
311: -- check if value of lookup falls within lookup type.
312: --

Line 619: (p_rec in ben_dcl_shd.g_rec_type,

615: -- ----------------------------------------------------------------------------
616: -- |---------------------------< insert_validate >----------------------------|
617: -- ----------------------------------------------------------------------------
618: Procedure insert_validate
619: (p_rec in ben_dcl_shd.g_rec_type,
620: p_effective_date in date,
621: p_datetrack_mode in varchar2,
622: p_validation_start_date in date,
623: p_validation_end_date in date) is

Line 679: (p_rec in ben_dcl_shd.g_rec_type,

675: -- ----------------------------------------------------------------------------
676: -- |---------------------------< update_validate >----------------------------|
677: -- ----------------------------------------------------------------------------
678: Procedure update_validate
679: (p_rec in ben_dcl_shd.g_rec_type,
680: p_effective_date in date,
681: p_datetrack_mode in varchar2,
682: p_validation_start_date in date,
683: p_validation_end_date in date) is

Line 748: (p_rec in ben_dcl_shd.g_rec_type,

744: -- ----------------------------------------------------------------------------
745: -- |---------------------------< delete_validate >----------------------------|
746: -- ----------------------------------------------------------------------------
747: Procedure delete_validate
748: (p_rec in ben_dcl_shd.g_rec_type,
749: p_effective_date in date,
750: p_datetrack_mode in varchar2,
751: p_validation_start_date in date,
752: p_validation_end_date in date) is