APPS.CLN_NP_PROCESSOR_PKG dependencies on ECX_TRANSACTIONS

Line 1627: FROM ecx_tp_headers eth, ecx_tp_details etd, ECX_TRANSACTIONS ecxtrans, ECX_EXT_PROCESSES ecxproc, ecx_standards estd

1623:
1624: BEGIN
1625: SELECT ecxproc.EXT_TYPE,ecxproc.EXT_SUBTYPE
1626: INTO l_xmlg_transaction_type, l_xmlg_transaction_subtype
1627: FROM ecx_tp_headers eth, ecx_tp_details etd, ECX_TRANSACTIONS ecxtrans, ECX_EXT_PROCESSES ecxproc, ecx_standards estd
1628: WHERE eth.party_id = l_tr_partner_id
1629: AND eth.party_site_id = l_tr_partner_site
1630: AND eth.party_type = nvl(l_tr_partner_type, eth.party_type)
1631: AND eth.tp_header_id = etd.tp_header_id

Line 1640: ecx_cln_debug_pub.Add('====Parameters Received From ECX_TRANSACTIONS/ECX_EXT_PROCESSES====',1);

1636: AND ecxproc.direction = nvl(l_doc_dir,ecxproc.direction)
1637: AND estd.standard_id = ecxproc.standard_id;
1638:
1639: IF (l_Debug_Level <= 1) THEN
1640: ecx_cln_debug_pub.Add('====Parameters Received From ECX_TRANSACTIONS/ECX_EXT_PROCESSES====',1);
1641: ecx_cln_debug_pub.Add('XMLG EXT TRANSACTION TYPE ----- >>>'||l_xmlg_transaction_type,1);
1642: ecx_cln_debug_pub.Add('XMLG EXT TRANSACTION SUBTYPE ----- >>>'||l_xmlg_transaction_subtype,1);
1643: ecx_cln_debug_pub.Add('==================================================================',1);
1644: END IF;