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_VGS_BUS dependencies on BEN_VGS_SHD

Line 48: l_api_updating := ben_vgs_shd.api_updating

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

Line 55: <> ben_vgs_shd.g_old_rec.pl_gd_or_svc_id) then

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

Line 59: ben_vgs_shd.constraint_error('BEN_PL_GD_OR_SVC_PK');

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

Line 69: ben_vgs_shd.constraint_error('BEN_PL_GD_OR_SVC_PK');

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

Line 123: l_api_updating := ben_vgs_shd.api_updating

119: Begin
120: --
121: hr_utility.set_location('Entering:'||l_proc,5);
122: --
123: l_api_updating := ben_vgs_shd.api_updating
124: (p_pl_gd_or_svc_id => p_pl_gd_or_svc_id,
125: p_effective_date => p_effective_date,
126: p_object_version_number => p_object_version_number);
127: --

Line 130: <> nvl(ben_vgs_shd.g_old_rec.gd_or_svc_typ_id,hr_api.g_number)

126: p_object_version_number => p_object_version_number);
127: --
128: if (l_api_updating
129: and nvl(p_gd_or_svc_typ_id,hr_api.g_number)
130: <> nvl(ben_vgs_shd.g_old_rec.gd_or_svc_typ_id,hr_api.g_number)
131: or not l_api_updating) then
132: --
133: -- check if gd_or_svc_typ_id value exists in ben_gd_or_svc_typ table
134: --

Line 145: ben_vgs_shd.constraint_error('BEN_PL_GD_OR_SVC_FK1');

141: --
142: -- raise error as FK does not relate to PK in ben_gd_or_svc_typ
143: -- table.
144: --
145: ben_vgs_shd.constraint_error('BEN_PL_GD_OR_SVC_FK1');
146: --
147: end if;
148: --
149: close c1;

Line 195: l_api_updating := ben_vgs_shd.api_updating

191: Begin
192: --
193: hr_utility.set_location('Entering:'||l_proc, 5);
194: --
195: l_api_updating := ben_vgs_shd.api_updating
196: (p_pl_gd_or_svc_id => p_pl_gd_or_svc_id,
197: p_effective_date => p_effective_date,
198: p_object_version_number => p_object_version_number);
199: --

Line 202: <> nvl(ben_vgs_shd.g_old_rec.alw_rcrrg_clms_flag,hr_api.g_varchar2)

198: p_object_version_number => p_object_version_number);
199: --
200: if (l_api_updating
201: and p_alw_rcrrg_clms_flag
202: <> nvl(ben_vgs_shd.g_old_rec.alw_rcrrg_clms_flag,hr_api.g_varchar2)
203: or not l_api_updating)
204: and p_alw_rcrrg_clms_flag is not null then
205: --
206: -- check if value of lookup falls within lookup type.

Line 266: l_api_updating := ben_vgs_shd.api_updating

262: Begin
263: --
264: hr_utility.set_location('Entering:'||l_proc, 5);
265: --
266: l_api_updating := ben_vgs_shd.api_updating
267: (p_pl_gd_or_svc_id => p_pl_gd_or_svc_id,
268: p_effective_date => p_effective_date,
269: p_object_version_number => p_object_version_number);
270: --

Line 274: <> nvl(ben_vgs_shd.g_old_rec.gd_svc_recd_basis_cd,hr_api.g_varchar2)

270: --
271:
272: if (l_api_updating
273: and (p_gd_svc_recd_basis_cd
274: <> nvl(ben_vgs_shd.g_old_rec.gd_svc_recd_basis_cd,hr_api.g_varchar2)
275: or p_gd_svc_recd_basis_dt
276: <> nvl(ben_vgs_shd.g_old_rec.gd_svc_recd_basis_dt,hr_api.g_date)
277: or p_gd_svc_recd_basis_mo
278: <> nvl(ben_vgs_shd.g_old_rec.gd_svc_recd_basis_mo,hr_api.g_number)

Line 276: <> nvl(ben_vgs_shd.g_old_rec.gd_svc_recd_basis_dt,hr_api.g_date)

272: if (l_api_updating
273: and (p_gd_svc_recd_basis_cd
274: <> nvl(ben_vgs_shd.g_old_rec.gd_svc_recd_basis_cd,hr_api.g_varchar2)
275: or p_gd_svc_recd_basis_dt
276: <> nvl(ben_vgs_shd.g_old_rec.gd_svc_recd_basis_dt,hr_api.g_date)
277: or p_gd_svc_recd_basis_mo
278: <> nvl(ben_vgs_shd.g_old_rec.gd_svc_recd_basis_mo,hr_api.g_number)
279: )
280: or not l_api_updating)

Line 278: <> nvl(ben_vgs_shd.g_old_rec.gd_svc_recd_basis_mo,hr_api.g_number)

274: <> nvl(ben_vgs_shd.g_old_rec.gd_svc_recd_basis_cd,hr_api.g_varchar2)
275: or p_gd_svc_recd_basis_dt
276: <> nvl(ben_vgs_shd.g_old_rec.gd_svc_recd_basis_dt,hr_api.g_date)
277: or p_gd_svc_recd_basis_mo
278: <> nvl(ben_vgs_shd.g_old_rec.gd_svc_recd_basis_mo,hr_api.g_number)
279: )
280: or not l_api_updating)
281: and ( p_gd_svc_recd_basis_cd is not null
282: and (p_gd_svc_recd_basis_dt is not null

Line 560: (p_rec in ben_vgs_shd.g_rec_type,

556: -- ----------------------------------------------------------------------------
557: -- |---------------------------< insert_validate >----------------------------|
558: -- ----------------------------------------------------------------------------
559: Procedure insert_validate
560: (p_rec in ben_vgs_shd.g_rec_type,
561: p_effective_date in date,
562: p_datetrack_mode in varchar2,
563: p_validation_start_date in date,
564: p_validation_end_date in date) is

Line 606: (p_rec in ben_vgs_shd.g_rec_type,

602: -- ----------------------------------------------------------------------------
603: -- |---------------------------< update_validate >----------------------------|
604: -- ----------------------------------------------------------------------------
605: Procedure update_validate
606: (p_rec in ben_vgs_shd.g_rec_type,
607: p_effective_date in date,
608: p_datetrack_mode in varchar2,
609: p_validation_start_date in date,
610: p_validation_end_date in date) is

Line 662: (p_rec in ben_vgs_shd.g_rec_type,

658: -- ----------------------------------------------------------------------------
659: -- |---------------------------< delete_validate >----------------------------|
660: -- ----------------------------------------------------------------------------
661: Procedure delete_validate
662: (p_rec in ben_vgs_shd.g_rec_type,
663: p_effective_date in date,
664: p_datetrack_mode in varchar2,
665: p_validation_start_date in date,
666: p_validation_end_date in date) is