[Home] [Help]
89: , t.where_clause
90: , c.master_table_route_id
91: from pqh_copy_entity_txns e
92: , pqh_copy_entity_attribs a
93: , pqh_transaction_categories c
94: , pqh_table_route t
95: where e.copy_entity_txn_id = a.copy_entity_txn_id
96: and a.row_type_cd = 'CRITERIA'
97: and c.transaction_category_id = e.transaction_category_id
570: l_txn_category_attribute_id pqh_special_attributes.txn_category_attribute_id%type;
571: l_replacement_type_cd pqh_copy_entity_txns.replacement_type_cd%type ;
572: l_start_with pqh_copy_entity_txns.start_with%type;
573: l_increment_by pqh_copy_entity_txns.increment_by%type;
574: l_mast_trt_id pqh_transaction_categories.master_table_route_id%type;
575: l_transaction_id pqh_transaction_categories.transaction_category_id%type;
576: l_warn number(15);
577: l_copies number(15);
578: l_copy_entity_result_id number(15);
571: l_replacement_type_cd pqh_copy_entity_txns.replacement_type_cd%type ;
572: l_start_with pqh_copy_entity_txns.start_with%type;
573: l_increment_by pqh_copy_entity_txns.increment_by%type;
574: l_mast_trt_id pqh_transaction_categories.master_table_route_id%type;
575: l_transaction_id pqh_transaction_categories.transaction_category_id%type;
576: l_warn number(15);
577: l_copies number(15);
578: l_copy_entity_result_id number(15);
579: l_ovn number(15);
586: , cet.transaction_category_id
587: , tct.master_table_route_id
588: , cet.context context -- application_id
589: from pqh_copy_entity_txns cet
590: , pqh_transaction_categories tct
591: where copy_entity_txn_id = p_copy_entity_txn_id
592: and tct.transaction_category_id = cet.transaction_category_id;
593: --
594: cursor c_change is
862: sat.context context, -- application_id
863: sat1.context context_s1 -- application_id
864: from pqh_special_attributes sat,
865: pqh_txn_category_attributes tca,
866: pqh_transaction_categories tct,
867: pqh_attributes att,
868: pqh_special_attributes sat1
869: where sat.txn_category_attribute_id = tca.txn_category_attribute_id
870: and tca.attribute_id = att.attribute_id
2049: select distinct tr.table_route_id, tr.display_name
2050: from pqh_table_route tr
2051: , pqh_attributes_vl a
2052: , pqh_txn_category_attributes c
2053: , pqh_transaction_categories cat
2054: where a.master_table_route_id = tr.table_route_id
2055: and a.attribute_id = c.attribute_id
2056: and tr.table_route_id <> cat.master_table_route_id
2057: and cat.transaction_category_id = c.transaction_category_id
2277: is
2278: cursor c_txn is
2279: select short_name, context
2280: from pqh_copy_entity_txns cet,
2281: pqh_transaction_categories tct
2282: where cet.transaction_category_id = tct.transaction_category_id
2283: and cet.copy_entity_txn_id = p_copy_entity_txn_id ;
2284: --
2285: cursor c_gbl(v_context in varchar2) is
2313: cursor c_short_name is
2314: select transaction_category_id,
2315: member_cd,
2316: name
2317: from pqh_transaction_categories_vl
2318: where short_name = p_short_name
2319: and business_group_id is null ;
2320: --
2321: cursor c_txn_cat_id is
2321: cursor c_txn_cat_id is
2322: select short_name,
2323: member_cd,
2324: name
2325: from pqh_transaction_categories_vl
2326: where transaction_category_id = p_transaction_category_id;
2327: --
2328: cursor c_txn_id is
2329: select transaction_category_id
2365: return varchar2
2366: is
2367: cursor c_tran is
2368: select function_type_cd
2369: from pqh_transaction_categories tct
2370: ,pqh_copy_entity_functions cef
2371: where tct.master_table_route_id = cef.table_route_id
2372: and cef.context = p_context
2373: and tct.transaction_category_id = p_transaction_category_id ;