APPS.PQH_TCA_BUS dependencies on PQH_TRANSACTION_CATEGORIES

Line 263: from pqh_transaction_categories a

259: l_dummy varchar2(1);
260: --
261: cursor c1 is
262: select null
263: from pqh_transaction_categories a
264: where a.transaction_category_id = p_transaction_category_id;
265: --
266: Begin
267: --

Line 279: -- check if transaction_category_id value exists in pqh_transaction_categories table

275: and nvl(p_transaction_category_id,hr_api.g_number)
276: <> nvl(pqh_tca_shd.g_old_rec.transaction_category_id,hr_api.g_number)
277: or not l_api_updating) then
278: --
279: -- check if transaction_category_id value exists in pqh_transaction_categories table
280: --
281: open c1;
282: --
283: fetch c1 into l_dummy;

Line 288: -- raise error as FK does not relate to PK in pqh_transaction_categories

284: if c1%notfound then
285: --
286: close c1;
287: --
288: -- raise error as FK does not relate to PK in pqh_transaction_categories
289: -- table.
290: --
291: pqh_tca_shd.constraint_error('PQH_TXN_CATEGORY_ATTRIBUTE_FK2');
292: --

Line 896: l_freeze_status_cd pqh_transaction_categories.freeze_status_cd%type;

892: p_object_version_number in number) is
893: --
894: l_proc varchar2(72) := g_package||'chk_transaction_cat_status';
895: l_api_updating boolean;
896: l_freeze_status_cd pqh_transaction_categories.freeze_status_cd%type;
897: --
898: cursor c1 is
899: select nvl(b.freeze_status_cd,hr_api.g_varchar2)
900: from pqh_txn_category_attributes a, pqh_transaction_categories b

Line 900: from pqh_txn_category_attributes a, pqh_transaction_categories b

896: l_freeze_status_cd pqh_transaction_categories.freeze_status_cd%type;
897: --
898: cursor c1 is
899: select nvl(b.freeze_status_cd,hr_api.g_varchar2)
900: from pqh_txn_category_attributes a, pqh_transaction_categories b
901: where a.attribute_id = p_attribute_id
902: AND a.transaction_category_id = b.transaction_category_id;
903: --
904: --