DBA Data[Home] [Help]

APPS.PQH_BPR_BUS dependencies on PQH_BUDGET_DETAILS

Line 261: from pqh_budget_details a

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: --

Line 277: -- check if budget_detail_id value exists in pqh_budget_details table

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;

Line 286: -- raise error as FK does not relate to PK in pqh_budget_details

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: --