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_EXT_PROCESSES

Line 3197: ecx_ext_processes eep

3193: BEGIN
3194: SELECT protocol_type,hub_user_id
3195: INTO l_protocol_type, l_hub_user_id
3196: FROM ecx_tp_details etd, ecx_tp_headers eth,
3197: ecx_ext_processes eep
3198: WHERE (eth.party_id = p_tr_partner_id or p_tr_partner_id is null )
3199: AND eth.party_site_id = p_tr_partner_site
3200: AND eth.party_type = p_tr_partner_type
3201: AND eth.tp_header_id = etd.tp_header_id

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:

Line 3932: ecx_cln_debug_pub.Add('-- Before SQL query to find the trading partner set up from ecx_ext_processes /ecx_tp_details /ecx_tp_headers',1);

3928: IF (p_tr_partner_type IS NULL OR p_tr_partner_id IS NULL OR p_tr_partner_site IS NULL or l_xmlg_msg_standard is null )
3929: THEN -- based on the ecx doclogs values we have to get actual TP values
3930: BEGIN
3931: IF (l_Debug_Level <= 1) THEN
3932: ecx_cln_debug_pub.Add('-- Before SQL query to find the trading partner set up from ecx_ext_processes /ecx_tp_details /ecx_tp_headers',1);
3933: END IF;
3934:
3935:
3936: SELECT eth.party_id, eth.party_site_id, eth.party_type, estd.standard_code

Line 3938: FROM ecx_ext_processes eep, ecx_tp_details etd, ecx_tp_headers eth, ecx_standards estd

3934:
3935:
3936: SELECT eth.party_id, eth.party_site_id, eth.party_type, estd.standard_code
3937: INTO l_txn_partner_id, l_txn_partner_site, l_txn_partner_type, l_xmlg_msg_standard
3938: FROM ecx_ext_processes eep, ecx_tp_details etd, ecx_tp_headers eth, ecx_standards estd
3939: WHERE eep.ext_type = l_xmlg_transaction_type
3940: AND eep.ext_subtype = l_xmlg_transaction_subtype
3941: AND eep.standard_id = estd.standard_id
3942: AND estd.standard_code = l_xmlg_msg_standard

Line 3956: ecx_cln_debug_pub.Add('====Trading Partner Parameters Changed To IDs Using ecx_ext_processes /ecx_tp_details /ecx_tp_headers =====',1);

3952: END IF;
3953:
3954:
3955: IF (l_Debug_Level <= 1) THEN
3956: ecx_cln_debug_pub.Add('====Trading Partner Parameters Changed To IDs Using ecx_ext_processes /ecx_tp_details /ecx_tp_headers =====',1);
3957: ecx_cln_debug_pub.Add('TRADING PARTNER TYPE ----- >>>'||l_txn_partner_id,1);
3958: ecx_cln_debug_pub.Add('TRADING PARTNER ID ----- >>>'||l_txn_partner_site,1);
3959: ecx_cln_debug_pub.Add('TRADING PARTNER SITE ----- >>>'||l_txn_partner_type,1);
3960: ecx_cln_debug_pub.Add('Message Standard ----- >>>'||l_xmlg_msg_standard,1);

Line 3977: FROM ecx_ext_processes eep, ecx_tp_details etd, ecx_tp_headers eth, ecx_standards estd

3973:
3974: BEGIN
3975: SELECT eth.party_id, eth.party_site_id, eth.party_type, estd.standard_code
3976: INTO l_txn_partner_id, l_txn_partner_site, l_txn_partner_type, l_xmlg_msg_standard
3977: FROM ecx_ext_processes eep, ecx_tp_details etd, ecx_tp_headers eth, ecx_standards estd
3978: WHERE eep.ext_type = l_xmlg_transaction_type
3979: AND eep.ext_subtype = l_xmlg_transaction_subtype
3980: AND eep.standard_id = estd.standard_id
3981: AND estd.standard_code = l_xmlg_msg_standard

Line 4665: FROM ecx_doclogs doclogs, ecx_ext_processes eep, ecx_tp_details etd, ecx_tp_headers eth, ecx_standards estd

4661: END IF;
4662:
4663: SELECT doclogs.internal_control_number
4664: INTO l_corrspnd_internal_cntrl_num
4665: FROM ecx_doclogs doclogs, ecx_ext_processes eep, ecx_tp_details etd, ecx_tp_headers eth, ecx_standards estd
4666: WHERE doclogs.direction = 'IN' and doclogs.field7 = l_data_area_refid
4667: AND eep.ext_type = doclogs.transaction_type
4668: AND eep.ext_subtype = doclogs.transaction_subtype
4669: AND eep.standard_id = estd.standard_id