eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CLN_CH_COLLABORATION_PKG dependencies on ECX_TRANSACTIONS

Line 3784: FROM ECX_TRANSACTIONS ecxtrans, ECX_EXT_PROCESSES ecxproc, ECX_DOCLOGS doclogs

3780: doclogs.protocol_type, doclogs.message_standard, doclogs.message_type, doclogs.event_key
3781: INTO l_xmlg_internal_control_number, l_xmlg_msg_id, l_xmlg_transaction_type, l_xmlg_transaction_subtype,
3782: l_xmlg_document_id, l_tr_partner_type, l_tr_partner_id,l_tr_partner_site, l_doc_dir,
3783: l_sender_component, l_xmlg_msg_standard, l_xmlg_msg_type, l_xml_event_key
3784: FROM ECX_TRANSACTIONS ecxtrans, ECX_EXT_PROCESSES ecxproc, ECX_DOCLOGS doclogs
3785: WHERE ecxtrans.TRANSACTION_TYPE = NVL(p_xmlg_int_transaction_type,l_xmlg_int_transaction_type)
3786: AND ecxtrans.TRANSACTION_SUBTYPE = NVL(p_xmlg_int_transaction_subtype,l_xmlg_int_transaction_subtype)
3787: AND ecxproc.TRANSACTION_ID = ecxtrans.TRANSACTION_ID
3788: AND ecxproc.DIRECTION = NVL(p_doc_dir,ecxproc.direction)

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

3835:
3836: BEGIN
3837: SELECT ecxproc.EXT_TYPE,ecxproc.EXT_SUBTYPE, estd.standard_code
3838: INTO l_xmlg_transaction_type, l_xmlg_transaction_subtype, l_xmlg_msg_standard
3839: FROM ecx_tp_headers eth, ecx_tp_details etd, ECX_TRANSACTIONS ecxtrans, ECX_EXT_PROCESSES ecxproc, ecx_standards estd
3840: WHERE eth.party_id = p_tr_partner_id
3841: AND eth.party_site_id = p_tr_partner_site
3842: AND eth.party_type = nvl(l_tr_partner_type, eth.party_type)
3843: AND eth.tp_header_id = etd.tp_header_id

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

3848: AND ecxproc.direction = nvl(p_doc_dir,ecxproc.direction)
3849: AND estd.standard_id = ecxproc.standard_id;
3850:
3851: IF (l_Debug_Level <= 1) THEN
3852: ecx_cln_debug_pub.Add('====Parameters Received From ECX_TRANSACTIONS/ECX_EXT_PROCESSES====',1);
3853: ecx_cln_debug_pub.Add('XMLG EXT TRANSACTION TYPE ----- >>>'||l_xmlg_transaction_type,1);
3854: ecx_cln_debug_pub.Add('XMLG EXT TRANSACTION SUBTYPE ----- >>>'||l_xmlg_transaction_subtype,1);
3855: ecx_cln_debug_pub.Add('XMLG Message Standard ----- >>>'||l_xmlg_msg_standard,1);
3856: ecx_cln_debug_pub.Add('==================================================================',1);

Line 3888: FROM ECX_TRANSACTIONS ecxtrans, ECX_EXT_PROCESSES ecxproc

3884: ecx_cln_debug_pub.Add('Getting values for Internal Transaction type and SubType',1);
3885: BEGIN
3886: SELECT distinct ecxtrans.TRANSACTION_TYPE, ecxtrans.TRANSACTION_SUBTYPE
3887: INTO l_xmlg_int_transaction_type, l_xmlg_int_transaction_subtype
3888: FROM ECX_TRANSACTIONS ecxtrans, ECX_EXT_PROCESSES ecxproc
3889: WHERE ecxtrans.TRANSACTION_ID = ecxproc.TRANSACTION_ID
3890: AND ecxproc.EXT_TYPE = NVL(p_xmlg_transaction_type,l_xmlg_transaction_type)
3891: AND ecxproc.EXT_SUBTYPE = NVL(p_xmlg_transaction_subtype,l_xmlg_transaction_subtype)
3892: AND ecxproc.DIRECTION = NVL(p_doc_dir,l_doc_dir);

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

3890: AND ecxproc.EXT_TYPE = NVL(p_xmlg_transaction_type,l_xmlg_transaction_type)
3891: AND ecxproc.EXT_SUBTYPE = NVL(p_xmlg_transaction_subtype,l_xmlg_transaction_subtype)
3892: AND ecxproc.DIRECTION = NVL(p_doc_dir,l_doc_dir);
3893:
3894: ecx_cln_debug_pub.Add('====Parameters Received From ECX_TRANSACTIONS/ECX_EXT_PROCESSES====',1);
3895: ecx_cln_debug_pub.Add('XMLG INT TRANSACTION TYPE ----- >>>'||l_xmlg_int_transaction_type,1);
3896: ecx_cln_debug_pub.Add('XMLG INT TRANSACTION SUBTYPE ----- >>>'||l_xmlg_int_transaction_subtype,1);
3897: ecx_cln_debug_pub.Add('==================================================================',1);
3898: