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_CMD_BUS dependencies on BEN_CM_DLVRY_MED_TYP

Line 56: ben_cmd_shd.constraint_error('BEN_CM_DLVRY_MED_TYP_PK');

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

Line 66: ben_cmd_shd.constraint_error('BEN_CM_DLVRY_MED_TYP_PK');

62: if p_cm_dlvry_med_typ_id is not null then
63: --
64: -- raise error as PK is not null
65: --
66: ben_cmd_shd.constraint_error('BEN_CM_DLVRY_MED_TYP_PK');
67: --
68: end if;
69: --
70: end if;

Line 140: ben_cmd_shd.constraint_error('BEN_CM_DLVRY_MED_TYP_FK3');

136: --
137: -- raise error as FK does not relate to PK in ben_cm_dlvry_mthd_typ
138: -- table.
139: --
140: ben_cmd_shd.constraint_error('BEN_CM_DLVRY_MED_TYP_FK3');
141: --
142: end if;
143: --
144: close c1;

Line 399: from ben_cm_dlvry_med_typ

395: --
396: --
397: cursor crs_cm_dlvry_med is
398: select null
399: from ben_cm_dlvry_med_typ
400: where cm_dlvry_med_typ_cd = p_cm_dlvry_med_typ_cd
401: and cm_dlvry_mthd_typ_id = p_cm_dlvry_mthd_typ_id
402: and business_group_id + 0 = p_business_group_id ;
403: --

Line 580: ben_cm_dlvry_med_typ b

576: --
577: cursor csr_leg_code is
578: select a.legislation_code
579: from per_business_groups a,
580: ben_cm_dlvry_med_typ b
581: where b.cm_dlvry_med_typ_id = p_cm_dlvry_med_typ_id
582: and a.business_group_id = b.business_group_id;
583: --
584: -- Declare local variables