APPS.PQH_GENERIC dependencies on PQH_COPY_ENTITY_TXNS

Line 41: l_status pqh_copy_entity_txns.status%TYPE;

37: l_reset_flag varchar2(10) ;
38: l_cet number ;
39: l_cer1 number ;
40: l_cer2 number ;
41: l_status pqh_copy_entity_txns.status%TYPE;
42: l_transaction_category_id pqh_transaction_categories.transaction_category_id%TYPE;
43: l_transaction_short_name pqh_transaction_categories.short_name%TYPE;
44: l_name pqh_copy_entity_txns.display_name%TYPE;
45: l_master_table_route_id pqh_table_route.table_route_id%TYPE;

Line 44: l_name pqh_copy_entity_txns.display_name%TYPE;

40: l_cer2 number ;
41: l_status pqh_copy_entity_txns.status%TYPE;
42: l_transaction_category_id pqh_transaction_categories.transaction_category_id%TYPE;
43: l_transaction_short_name pqh_transaction_categories.short_name%TYPE;
44: l_name pqh_copy_entity_txns.display_name%TYPE;
45: l_master_table_route_id pqh_table_route.table_route_id%TYPE;
46: l_effective_date varchar2(30); -- would hold date in char format
47: l_function_context pqh_copy_entity_contexts.context%TYPE;
48: l_context pqh_copy_entity_txns.context%TYPE;

Line 48: l_context pqh_copy_entity_txns.context%TYPE;

44: l_name pqh_copy_entity_txns.display_name%TYPE;
45: l_master_table_route_id pqh_table_route.table_route_id%TYPE;
46: l_effective_date varchar2(30); -- would hold date in char format
47: l_function_context pqh_copy_entity_contexts.context%TYPE;
48: l_context pqh_copy_entity_txns.context%TYPE;
49: l_function_type_cd pqh_copy_entity_functions.function_type_cd%TYPE;
50: l_pre_copy_function_name pqh_copy_entity_functions.pre_copy_function_name%TYPE;
51: l_copy_function_name pqh_copy_entity_functions.copy_function_name%TYPE;
52: l_post_copy_function_name pqh_copy_entity_functions.post_copy_function_name%TYPE;

Line 67: from pqh_copy_entity_txns cet

63: , tct.master_table_route_id
64: , to_char(nvl(cet.src_effective_date,sysdate),'RRRR/MM/DD HH24:MI:SS') effective_date
65: , cet.context -- application_id
66: , cec.context gbl_context
67: from pqh_copy_entity_txns cet
68: , pqh_transaction_categories_vl tct
69: , pqh_copy_entity_contexts cec
70: where tct.transaction_category_id = cet.transaction_category_id
71: and cec.transaction_short_name = tct.short_name

Line 124: , pqh_copy_entity_txns cet

120: , upper(sat.ddf_column_name) ddf_column_name
121: from pqh_attributes att
122: , pqh_special_attributes sat
123: , pqh_txn_category_attributes tca
124: , pqh_copy_entity_txns cet
125: where att.attribute_id = tca.attribute_id
126: and att.master_table_route_id = v_table_route_id
127: and tca.txn_category_attribute_id = sat.txn_category_attribute_id
128: and cet.transaction_category_id = tca.transaction_category_id

Line 150: , pqh_copy_entity_txns cet

146: from pqh_attributes att
147: , pqh_special_attributes sat
148: , pqh_special_attributes sat1
149: , pqh_txn_category_attributes tca
150: , pqh_copy_entity_txns cet
151: where att.attribute_id = tca.attribute_id
152: and att.master_table_route_id = v_table_route_id
153: and tca.txn_category_attribute_id = sat.txn_category_attribute_id
154: and cet.transaction_category_id = tca.transaction_category_id

Line 365: update pqh_copy_entity_txns

361: and result_type_cd = 'TARGET'
362: and number_of_copies = 0
363: and status = 'TGT_ERR' ;
364: --
365: update pqh_copy_entity_txns
366: set status = nvl(l_status, 'COMPLETED')
367: where copy_entity_txn_id = rec1.copy_entity_txn_id;
368: --
369: exit;

Line 793: , pqh_copy_entity_txns cet

789: , 'B' ,'L_'||get_alias(pa.column_name)||' BOOLEAN'
790: , 'L_'||get_alias(pa.column_name)||' '||pa.column_type||'('||pa.width||')') var_def
791: from pqh_attributes pa
792: , pqh_txn_category_attributes tca
793: , pqh_copy_entity_txns cet
794: , pqh_special_attributes sat
795: where pa.master_table_route_id = p_table_route_id
796: and pa.attribute_id = tca.attribute_id
797: and cet.copy_entity_txn_id = p_copy_entity_txn_id

Line 1521: update pqh_copy_entity_txns

1517: update pqh_copy_entity_results
1518: set status = l_status
1519: where copy_entity_result_id = i.copy_entity_result_id;
1520: --
1521: update pqh_copy_entity_txns
1522: set status = l_status
1523: where copy_entity_txn_id = i.copy_entity_txn_id
1524: and status <> 'TGT_ERR';
1525: --