APPS.PQH_SYNCHRONIZE_LOCAL_TCT dependencies on PQH_TXN_CATEGORY_ATTRIBUTES

Line 11: from pqh_txn_category_attributes

7: , p_short_name in varchar2) is
8: --
9: cursor c1 (p_transaction_category_id number) is
10: select *
11: from pqh_txn_category_attributes
12: where transaction_category_id = p_transaction_category_id;
13: cursor c2 (p_short_name varchar2)is
14: select transaction_category_id,business_group_id
15: from pqh_transaction_categories

Line 23: l_lcl_txn_cat_attr_id pqh_txn_category_attributes.txn_category_attribute_id%type;

19: l_txn_cat_attr_id number;
20: l_glb_txn_cat_id number;
21: l_check varchar2(30);
22: --
23: l_lcl_txn_cat_attr_id pqh_txn_category_attributes.txn_category_attribute_id%type;
24: l_lcl_txn_cat_attr_ovn pqh_txn_category_attributes.object_version_number%type;
25: --
26: begin
27: -- idea of pulling short_name is that same script can be reused for

Line 24: l_lcl_txn_cat_attr_ovn pqh_txn_category_attributes.object_version_number%type;

20: l_glb_txn_cat_id number;
21: l_check varchar2(30);
22: --
23: l_lcl_txn_cat_attr_id pqh_txn_category_attributes.txn_category_attribute_id%type;
24: l_lcl_txn_cat_attr_ovn pqh_txn_category_attributes.object_version_number%type;
25: --
26: begin
27: -- idea of pulling short_name is that same script can be reused for
28: -- other transaction categories, if required.

Line 42: from pqh_txn_category_attributes

38: begin
39: select txn_category_attribute_id,
40: object_version_number
41: into l_lcl_txn_cat_attr_id, l_lcl_txn_cat_attr_ovn
42: from pqh_txn_category_attributes
43: where transaction_category_id = j.transaction_category_id
44: and attribute_id = i.attribute_id;
45: --
46: -- If the attribute exists for the local transaction category, update its value set.