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_DCO_BUS dependencies on BEN_DCO_SHD

Line 48: l_api_updating := ben_dco_shd.api_updating

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

Line 55: <> ben_dco_shd.g_old_rec.dpnt_cvrd_othr_ptip_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_ptip_rt_id,hr_api.g_number)
55: <> ben_dco_shd.g_old_rec.dpnt_cvrd_othr_ptip_rt_id) then
56: --
57: -- raise error as PK has changed
58: --
59: ben_dco_shd.constraint_error('BEN_DPNT_CVRD_OTHR_PTIP_F_PK');

Line 59: ben_dco_shd.constraint_error('BEN_DPNT_CVRD_OTHR_PTIP_F_PK');

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

Line 69: ben_dco_shd.constraint_error('BEN_DPNT_CVRD_OTHR_PTIP_F_PK');

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

Line 117: l_api_updating := ben_dco_shd.api_updating

113: Begin
114: --
115: hr_utility.set_location('Entering:'||l_proc, 5);
116: --
117: l_api_updating := ben_dco_shd.api_updating
118: (p_dpnt_cvrd_othr_ptip_rt_id => p_dpnt_cvrd_othr_ptip_rt_id,
119: p_effective_date => p_effective_date,
120: p_object_version_number => p_object_version_number);
121: --

Line 124: <> nvl(ben_dco_shd.g_old_rec.only_pls_subj_cobra_flag,hr_api.g_varchar2)

120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and p_only_pls_subj_cobra_flag
124: <> nvl(ben_dco_shd.g_old_rec.only_pls_subj_cobra_flag,hr_api.g_varchar2)
125: or not l_api_updating) then
126: --
127: -- check if value of lookup falls within lookup type.
128: --

Line 188: l_api_updating := ben_dco_shd.api_updating

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

Line 195: <> nvl(ben_dco_shd.g_old_rec.enrl_det_dt_cd,hr_api.g_varchar2)

191: p_object_version_number => p_object_version_number);
192: --
193: if (l_api_updating
194: and p_enrl_det_dt_cd
195: <> nvl(ben_dco_shd.g_old_rec.enrl_det_dt_cd,hr_api.g_varchar2)
196: or not l_api_updating)
197: and p_enrl_det_dt_cd is not null then
198: --
199: -- check if value of lookup falls within lookup type.

Line 284: l_api_updating := ben_dco_shd.api_updating

280: BEGIN
281: --
282: hr_utility.set_location('Entering:'||l_proc, 5);
283: --
284: l_api_updating := ben_dco_shd.api_updating
285: (p_dpnt_cvrd_othr_ptip_rt_id => p_dpnt_cvrd_othr_ptip_rt_id,
286: p_effective_date => p_effective_date,
287: p_object_version_number => p_object_version_number);
288: --

Line 290: and (p_ptip_id <> nvl(ben_dco_shd.g_old_rec.ptip_id,hr_api.g_number)

286: p_effective_date => p_effective_date,
287: p_object_version_number => p_object_version_number);
288: --
289: if (l_api_updating
290: and (p_ptip_id <> nvl(ben_dco_shd.g_old_rec.ptip_id,hr_api.g_number)
291: or p_enrl_det_dt_cd <> nvl(ben_dco_shd.g_old_rec.enrl_det_dt_cd,hr_api.g_varchar2))
292: or not l_api_updating) then
293:
294: open c_dup;

Line 291: or p_enrl_det_dt_cd <> nvl(ben_dco_shd.g_old_rec.enrl_det_dt_cd,hr_api.g_varchar2))

287: p_object_version_number => p_object_version_number);
288: --
289: if (l_api_updating
290: and (p_ptip_id <> nvl(ben_dco_shd.g_old_rec.ptip_id,hr_api.g_number)
291: or p_enrl_det_dt_cd <> nvl(ben_dco_shd.g_old_rec.enrl_det_dt_cd,hr_api.g_varchar2))
292: or not l_api_updating) then
293:
294: open c_dup;
295: fetch c_dup into l_exists;

Line 353: l_api_updating := ben_dco_shd.api_updating

349: Begin
350: --
351: hr_utility.set_location('Entering:'||l_proc, 5);
352: --
353: l_api_updating := ben_dco_shd.api_updating
354: (p_dpnt_cvrd_othr_ptip_rt_id => p_dpnt_cvrd_othr_ptip_rt_id,
355: p_effective_date => p_effective_date,
356: p_object_version_number => p_object_version_number);
357: --

Line 360: <> nvl(ben_dco_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

356: p_object_version_number => p_object_version_number);
357: --
358: if (l_api_updating
359: and p_excld_flag
360: <> nvl(ben_dco_shd.g_old_rec.excld_flag,hr_api.g_varchar2)
361: or not l_api_updating) then
362: --
363: -- check if value of lookup falls within lookup type.
364: --

Line 672: (p_rec in ben_dco_shd.g_rec_type,

668: -- ----------------------------------------------------------------------------
669: -- |---------------------------< insert_validate >----------------------------|
670: -- ----------------------------------------------------------------------------
671: Procedure insert_validate
672: (p_rec in ben_dco_shd.g_rec_type,
673: p_effective_date in date,
674: p_datetrack_mode in varchar2,
675: p_validation_start_date in date,
676: p_validation_end_date in date) is

Line 740: (p_rec in ben_dco_shd.g_rec_type,

736: -- ----------------------------------------------------------------------------
737: -- |---------------------------< update_validate >----------------------------|
738: -- ----------------------------------------------------------------------------
739: Procedure update_validate
740: (p_rec in ben_dco_shd.g_rec_type,
741: p_effective_date in date,
742: p_datetrack_mode in varchar2,
743: p_validation_start_date in date,
744: p_validation_end_date in date) is

Line 817: (p_rec in ben_dco_shd.g_rec_type,

813: -- ----------------------------------------------------------------------------
814: -- |---------------------------< delete_validate >----------------------------|
815: -- ----------------------------------------------------------------------------
816: Procedure delete_validate
817: (p_rec in ben_dco_shd.g_rec_type,
818: p_effective_date in date,
819: p_datetrack_mode in varchar2,
820: p_validation_start_date in date,
821: p_validation_end_date in date) is