APPS.CLN_NP_PROCESSOR_PKG dependencies on ECX_EXT_PROCESSES

Line 1314: FROM ECX_DOCLOGS doclogs, ecx_ext_processes eep, ecx_tp_details etd, ecx_tp_headers eth, ecx_standards estd

1310:
1311: BEGIN
1312: SELECT to_char(eth.tp_header_id)
1313: INTO p_tr_partner_id
1314: FROM ECX_DOCLOGS doclogs, ecx_ext_processes eep, ecx_tp_details etd, ecx_tp_headers eth, ecx_standards estd
1315: WHERE doclogs.internal_control_number = p_xmlg_internal_control_number
1316: AND eep.ext_type = doclogs.transaction_type
1317: AND eep.ext_subtype = doclogs.transaction_subtype
1318: AND eep.standard_id = estd.standard_id

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;