DBA Data[Home] [Help]

APPS.PQH_WDT_BUS dependencies on PQH_POSITION_TRANSACTIONS

Line 449: from pqh_position_transactions a

445: l_dummy varchar2(1);
446: --
447: cursor c1 is
448: select null
449: from pqh_position_transactions a
450: where a.position_transaction_id = p_position_transaction_id;
451: --
452: Begin
453: --

Line 466: -- check if position_transaction_id value exists in pqh_position_transactions table

462: <> nvl(pqh_wdt_shd.g_old_rec.position_transaction_id,hr_api.g_number)
463: or not l_api_updating) and
464: p_position_transaction_id is not null then
465: --
466: -- check if position_transaction_id value exists in pqh_position_transactions table
467: --
468: open c1;
469: --
470: fetch c1 into l_dummy;

Line 475: -- raise error as FK does not relate to PK in pqh_position_transactions

471: if c1%notfound then
472: --
473: close c1;
474: --
475: -- raise error as FK does not relate to PK in pqh_position_transactions
476: -- table.
477: --
478: pqh_wdt_shd.constraint_error('PQH_WORKSHEET_DETAILS_FK4');
479: --