DBA Data[Home] [Help]

APPS.BEN_HWF_BUS dependencies on BEN_HRS_WKD_IN_PERD_FCTR

Line 56: ben_hwf_shd.constraint_error('BEN_HRS_WKD_IN_PERD_FCTR_PK');

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

Line 66: ben_hwf_shd.constraint_error('BEN_HRS_WKD_IN_PERD_FCTR_PK');

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

Line 970: from ben_hrs_wkd_in_perd_fctr hwf

966: l_dummy varchar2(1);
967: --
968: cursor c1 is
969: select null
970: from ben_hrs_wkd_in_perd_fctr hwf
971: where hwf.business_group_id = p_business_group_id and
972: hwf.name = p_name;
973: Begin
974: --

Line 1183: -- when the user deletes the record in the BEN_HRS_WKD_IN_PERD_FCTR table.

1179: -- -------------------------------------------------------------------------
1180: --
1181: -- Description
1182: -- This procedure is used to check that Hours worked child records do not exist
1183: -- when the user deletes the record in the BEN_HRS_WKD_IN_PERD_FCTR table.
1184: --
1185: -- Pre Conditions
1186: -- None.
1187: --

Line 1492: ben_hrs_wkd_in_perd_fctr b

1488: --
1489: cursor csr_leg_code is
1490: select a.legislation_code
1491: from per_business_groups a,
1492: ben_hrs_wkd_in_perd_fctr b
1493: where b.hrs_wkd_in_perd_fctr_id = p_hrs_wkd_in_perd_fctr_id
1494: and a.business_group_id = b.business_group_id;
1495: --
1496: -- Declare local variables