257: l_dummy varchar2(1);
258: --
259: cursor c1 is
260: select null
261: from pqh_budget_details a
262: where a.budget_detail_id = p_budget_detail_id;
263: --
264: Begin
265: --
273: and nvl(p_budget_detail_id,hr_api.g_number)
274: <> nvl(pqh_bpr_shd.g_old_rec.budget_detail_id,hr_api.g_number)
275: or not l_api_updating) then
276: --
277: -- check if budget_detail_id value exists in pqh_budget_details table
278: --
279: open c1;
280: --
281: fetch c1 into l_dummy;
282: if c1%notfound then
283: --
284: close c1;
285: --
286: -- raise error as FK does not relate to PK in pqh_budget_details
287: -- table.
288: --
289: pqh_bpr_shd.constraint_error('PQH_BUDGET_PERIODS_FK1');
290: --