APPS.CLN_NP_PROCESSOR_PKG dependencies on ECX_DOCLOGS

Line 369: -- Query ECX_DOCLOGS for message ID using transaction type , transaction subtype and document id

365:
366: -- We are assuming that the first message after any out bound will be delviery confirmation
367: IF (l_msg_id IS NULL ) OR (TRIM(l_msg_id) = '') THEN
368: BEGIN
369: -- Query ECX_DOCLOGS for message ID using transaction type , transaction subtype and document id
370: SELECT msgid
371: INTO l_msg_id
372: FROM ECX_DOCLOGS
373: WHERE transaction_type = l_xmlg_transaction_type AND

Line 372: FROM ECX_DOCLOGS

368: BEGIN
369: -- Query ECX_DOCLOGS for message ID using transaction type , transaction subtype and document id
370: SELECT msgid
371: INTO l_msg_id
372: FROM ECX_DOCLOGS
373: WHERE transaction_type = l_xmlg_transaction_type AND
374: transaction_subtype = l_xmlg_transaction_subtype AND document_number = l_xmlg_document_id
375: AND direction = 'OUT';
376: IF (l_Debug_Level <= 1) THEN

Line 377: ecx_cln_debug_pub.Add('Quried ECX_DOCLOGS for l_msg_id:' || l_msg_id, 1);

373: WHERE transaction_type = l_xmlg_transaction_type AND
374: transaction_subtype = l_xmlg_transaction_subtype AND document_number = l_xmlg_document_id
375: AND direction = 'OUT';
376: IF (l_Debug_Level <= 1) THEN
377: ecx_cln_debug_pub.Add('Quried ECX_DOCLOGS for l_msg_id:' || l_msg_id, 1);
378: END IF;
379:
380: EXCEPTION
381: WHEN NO_DATA_FOUND THEN

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