259: l_dummy varchar2(1);
260: --
261: cursor c1 is
262: select null
263: from per_jobs a
264: where a.job_id = p_job_id;
265: --
266: Begin
267: --
276: <> nvl(pqh_ptx_shd.g_old_rec.job_id,hr_api.g_number)
277: or not l_api_updating) and
278: p_job_id is not null then
279: --
280: -- check if job_id value exists in per_jobs table
281: --
282: open c1;
283: --
284: fetch c1 into l_dummy;
285: if c1%notfound then
286: --
287: close c1;
288: --
289: -- raise error as FK does not relate to PK in per_jobs
290: -- table.
291: --
292: pqh_ptx_shd.constraint_error('PQH_POSITION_TRANSACTIONS_FK5');
293: --