APPS.PQH_TCA_BUS dependencies on PQH_TXN_CATEGORY_ATTRIBUTES

Line 56: pqh_tca_shd.constraint_error('PQH_TXN_CATEGORY_ATTRIBUTES_PK');

52: <> pqh_tca_shd.g_old_rec.txn_category_attribute_id) then
53: --
54: -- raise error as PK has changed
55: --
56: pqh_tca_shd.constraint_error('PQH_TXN_CATEGORY_ATTRIBUTES_PK');
57: --
58: elsif not l_api_updating then
59: --
60: -- check if PK is null

Line 66: pqh_tca_shd.constraint_error('PQH_TXN_CATEGORY_ATTRIBUTES_PK');

62: if p_txn_category_attribute_id is not null then
63: --
64: -- raise error as PK is not null
65: --
66: pqh_tca_shd.constraint_error('PQH_TXN_CATEGORY_ATTRIBUTES_PK');
67: --
68: end if;
69: --
70: end if;

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