APPS.BEN_PCG_BUS dependencies on BEN_PRTT_CLM_GD_OR_SVC_TYP

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 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 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 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 400: ben_prtt_clm_gd_or_svc_typ b

396: --
397: cursor csr_leg_code is
398: select a.legislation_code
399: from per_business_groups a,
400: ben_prtt_clm_gd_or_svc_typ b
401: where b.prtt_clm_gd_or_svc_typ_id = p_prtt_clm_gd_or_svc_typ_id
402: and a.business_group_id = b.business_group_id;
403: --
404: -- Declare local variables