APPS.PQH_GEN_FORM dependencies on PQH_COPY_ENTITY_TXNS

Line 91: from pqh_copy_entity_txns e

87: , replace(a.information30, '''','''''') information30
88: , t.from_clause
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

Line 571: l_replacement_type_cd pqh_copy_entity_txns.replacement_type_cd%type ;

567: , p_ln2 varchar2 default null
568: , p_batch_status out nocopy varchar2 ) is
569: --
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;

Line 572: l_start_with pqh_copy_entity_txns.start_with%type;

568: , p_batch_status out nocopy varchar2 ) is
569: --
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);

Line 573: l_increment_by pqh_copy_entity_txns.increment_by%type;

569: --
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);

Line 589: from pqh_copy_entity_txns cet

585: , cet.increment_by
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: --

Line 2280: from pqh_copy_entity_txns cet,

2276: procedure populate_context(p_copy_entity_txn_id in number)
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: --

Line 2330: from pqh_copy_entity_txns

2326: where transaction_category_id = p_transaction_category_id;
2327: --
2328: cursor c_txn_id is
2329: select transaction_category_id
2330: from pqh_copy_entity_txns
2331: where copy_entity_txn_id = p_transaction_id ;
2332:
2333: l_short_name varchar2(30) := p_short_name;
2334: l_transaction_category_id number := p_transaction_category_id;

Line 2552: from pqh_copy_entity_txns

2548: is
2549: --
2550: cursor c_bg is
2551: select context_business_group_id
2552: from pqh_copy_entity_txns
2553: where copy_entity_txn_id = pqh_gen_form.g_txn_id;
2554: begin
2555:
2556: if pqh_gen_form.g_txn_id is not null then