DBA Data[Home] [Help]

APPS.PQH_CEP_BUS dependencies on PQH_COPY_ENTITY_TXNS

Line 186: from pqh_copy_entity_txns a

182: l_dummy varchar2(1);
183: --
184: cursor c1 is
185: select null
186: from pqh_copy_entity_txns a
187: where a.copy_entity_txn_id = p_copy_entity_txn_id;
188: --
189: Begin
190: --

Line 202: -- check if copy_entity_txn_id value exists in pqh_copy_entity_txns table

198: and nvl(p_copy_entity_txn_id,hr_api.g_number)
199: <> nvl(pqh_cep_shd.g_old_rec.copy_entity_txn_id,hr_api.g_number)
200: or not l_api_updating) then
201: --
202: -- check if copy_entity_txn_id value exists in pqh_copy_entity_txns table
203: --
204: open c1;
205: --
206: fetch c1 into l_dummy;

Line 211: -- raise error as FK does not relate to PK in pqh_copy_entity_txns

207: if c1%notfound then
208: --
209: close c1;
210: --
211: -- raise error as FK does not relate to PK in pqh_copy_entity_txns
212: -- table.
213: --
214: pqh_cep_shd.constraint_error('PQH_COPY_ENTITY_PREFS_FK1');
215: --