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_PCG_BUS dependencies on BEN_PCG_SHD

Line 47: l_api_updating := ben_pcg_shd.api_updating

43: Begin
44: --
45: hr_utility.set_location('Entering:'||l_proc, 5);
46: --
47: l_api_updating := ben_pcg_shd.api_updating
48: (p_prtt_clm_gd_or_svc_typ_id => p_prtt_clm_gd_or_svc_typ_id,
49: p_object_version_number => p_object_version_number);
50: --
51: if (l_api_updating

Line 53: <> ben_pcg_shd.g_old_rec.prtt_clm_gd_or_svc_typ_id) then

49: p_object_version_number => p_object_version_number);
50: --
51: if (l_api_updating
52: and nvl(p_prtt_clm_gd_or_svc_typ_id,hr_api.g_number)
53: <> ben_pcg_shd.g_old_rec.prtt_clm_gd_or_svc_typ_id) then
54: --
55: -- raise error as PK has changed
56: --
57: ben_pcg_shd.constraint_error('BEN_PRTT_CLM_GD_OR_SVC_TYP_PK');

Line 57: ben_pcg_shd.constraint_error('BEN_PRTT_CLM_GD_OR_SVC_TYP_PK');

53: <> ben_pcg_shd.g_old_rec.prtt_clm_gd_or_svc_typ_id) then
54: --
55: -- raise error as PK has changed
56: --
57: ben_pcg_shd.constraint_error('BEN_PRTT_CLM_GD_OR_SVC_TYP_PK');
58: --
59: elsif not l_api_updating then
60: --
61: -- check if PK is null

Line 67: ben_pcg_shd.constraint_error('BEN_PRTT_CLM_GD_OR_SVC_TYP_PK');

63: if p_prtt_clm_gd_or_svc_typ_id is not null then
64: --
65: -- raise error as PK is not null
66: --
67: ben_pcg_shd.constraint_error('BEN_PRTT_CLM_GD_OR_SVC_TYP_PK');
68: --
69: end if;
70: --
71: end if;

Line 125: l_api_updating := ben_pcg_shd.api_updating

121: Begin
122: --
123: hr_utility.set_location('Entering:'||l_proc,5);
124: --
125: l_api_updating := ben_pcg_shd.api_updating
126: (p_prtt_clm_gd_or_svc_typ_id => p_prtt_clm_gd_or_svc_typ_id,
127: p_object_version_number => p_object_version_number);
128: --
129: if (l_api_updating

Line 131: <> nvl(ben_pcg_shd.g_old_rec.prtt_reimbmt_rqst_id,hr_api.g_number)

127: p_object_version_number => p_object_version_number);
128: --
129: if (l_api_updating
130: and nvl(p_prtt_reimbmt_rqst_id,hr_api.g_number)
131: <> nvl(ben_pcg_shd.g_old_rec.prtt_reimbmt_rqst_id,hr_api.g_number)
132: or not l_api_updating) then
133: --
134: -- check if prtt_reimbmt_rqst_id value exists in ben_prtt_reimbmt_rqst_f table
135: --

Line 146: ben_pcg_shd.constraint_error('BEN_PRTT_CLM_GD_OR_SVC_TYP_DT1');

142: --
143: -- raise error as FK does not relate to PK in ben_prtt_reimbmt_rqst_f
144: -- table.
145: --
146: ben_pcg_shd.constraint_error('BEN_PRTT_CLM_GD_OR_SVC_TYP_DT1');
147: --
148: end if;
149: --
150: close c1;

Line 206: l_api_updating := ben_pcg_shd.api_updating

202: Begin
203: --
204: hr_utility.set_location('Entering:'||l_proc,5);
205: --
206: l_api_updating := ben_pcg_shd.api_updating
207: (p_prtt_clm_gd_or_svc_typ_id => p_prtt_clm_gd_or_svc_typ_id,
208: p_object_version_number => p_object_version_number);
209: --
210: if (l_api_updating

Line 212: <> nvl(ben_pcg_shd.g_old_rec.pl_gd_or_svc_id,hr_api.g_number)

208: p_object_version_number => p_object_version_number);
209: --
210: if (l_api_updating
211: and nvl(p_pl_gd_or_svc_id,hr_api.g_number)
212: <> nvl(ben_pcg_shd.g_old_rec.pl_gd_or_svc_id,hr_api.g_number)
213: or not l_api_updating) then
214: --
215: -- check if prtt_reimbmt_rqst_id value exists in ben_prtt_reimbmt_rqst_f table
216: --

Line 227: ben_pcg_shd.constraint_error('BEN_PRTT_CLM_GD_OR_SVC_TYP_DT1');

223: --
224: -- raise error as FK does not relate to PK in ben_prtt_reimbmt_rqst_f
225: -- table.
226: --
227: ben_pcg_shd.constraint_error('BEN_PRTT_CLM_GD_OR_SVC_TYP_DT1');
228: --
229: end if;
230: --
231: close c1;

Line 284: l_api_updating := ben_pcg_shd.api_updating

280: Begin
281: --
282: hr_utility.set_location('Entering:'||l_proc,5);
283: --
284: l_api_updating := ben_pcg_shd.api_updating
285: (p_prtt_clm_gd_or_svc_typ_id => p_prtt_clm_gd_or_svc_typ_id,
286: p_object_version_number => p_object_version_number);
287: --
288: if (l_api_updating

Line 290: <> nvl(ben_pcg_shd.g_old_rec.gd_or_svc_typ_id,hr_api.g_number)

286: p_object_version_number => p_object_version_number);
287: --
288: if (l_api_updating
289: and nvl(p_gd_or_svc_typ_id,hr_api.g_number)
290: <> nvl(ben_pcg_shd.g_old_rec.gd_or_svc_typ_id,hr_api.g_number)
291: or not l_api_updating) and
292: p_gd_or_svc_typ_id is not null then
293: --
294: -- check if gd_or_svc_typ_id value exists in ben_gd_or_svc_typ table

Line 306: ben_pcg_shd.constraint_error('BEN_PRTT_CLM_GD_OR_SVC_TYP_FK3');

302: --
303: -- raise error as FK does not relate to PK in ben_gd_or_svc_typ
304: -- table.
305: --
306: ben_pcg_shd.constraint_error('BEN_PRTT_CLM_GD_OR_SVC_TYP_FK3');
307: --
308: end if;
309: --
310: close c1;

Line 321: Procedure insert_validate(p_rec in ben_pcg_shd.g_rec_type) is

317: --
318: -- ----------------------------------------------------------------------------
319: -- |---------------------------< insert_validate >----------------------------|
320: -- ----------------------------------------------------------------------------
321: Procedure insert_validate(p_rec in ben_pcg_shd.g_rec_type) is
322: --
323: l_proc varchar2(72) := g_package||'insert_validate';
324: --
325: Begin

Line 348: Procedure update_validate(p_rec in ben_pcg_shd.g_rec_type) is

344: --
345: -- ----------------------------------------------------------------------------
346: -- |---------------------------< update_validate >----------------------------|
347: -- ----------------------------------------------------------------------------
348: Procedure update_validate(p_rec in ben_pcg_shd.g_rec_type) is
349: --
350: l_proc varchar2(72) := g_package||'update_validate';
351: --
352: Begin

Line 375: Procedure delete_validate(p_rec in ben_pcg_shd.g_rec_type) is

371: --
372: -- ----------------------------------------------------------------------------
373: -- |---------------------------< delete_validate >----------------------------|
374: -- ----------------------------------------------------------------------------
375: Procedure delete_validate(p_rec in ben_pcg_shd.g_rec_type) is
376: --
377: l_proc varchar2(72) := g_package||'delete_validate';
378: --
379: Begin