APPS.CLN_RESEND dependencies on CLN_COLL_HIST_DTL

Line 57: cln_debug_pub.Add('Before Sql Query - cln_coll_hist_dtl',1);

53: WHERE collaboration_id = p_collaboration_id;
54: IF (l_Debug_Level <= 1) THEN
55: cln_debug_pub.Add('After Sql Query - cln_coll_hist_hdr',1);
56: cln_debug_pub.Add('Resend Count -'||l_resend_count,1);
57: cln_debug_pub.Add('Before Sql Query - cln_coll_hist_dtl',1);
58: END IF;
59: EXCEPTION
60: WHEN OTHERS THEN
61: l_error_code :=SQLCODE;

Line 78: FROM CLN_COLL_HIST_DTL

74: SELECT COLLABORATION_DOCUMENT_TYPE, XMLG_MSG_ID, collaboration_dtl_id,
75: XMLG_TRANSACTION_TYPE, XMLG_TRANSACTION_SUBTYPE, XMLG_DOCUMENT_ID, XML_EVENT_KEY
76: INTO l_collaboration_doc_type,l_xmlg_msgid, l_coll_dtl_id,
77: l_xmlg_transaction_type, l_xmlg_transaction_subtype, l_xmlg_doc_id, l_xml_event_key
78: FROM CLN_COLL_HIST_DTL
79: WHERE
80: collaboration_dtl_id = (SELECT MAX(collaboration_dtl_id) FROM CLN_COLL_HIST_DTL
81: WHERE DOCUMENT_DIRECTION = 'OUT'
82: AND (XMLG_MSG_ID IS NOT NULL

Line 80: collaboration_dtl_id = (SELECT MAX(collaboration_dtl_id) FROM CLN_COLL_HIST_DTL

76: INTO l_collaboration_doc_type,l_xmlg_msgid, l_coll_dtl_id,
77: l_xmlg_transaction_type, l_xmlg_transaction_subtype, l_xmlg_doc_id, l_xml_event_key
78: FROM CLN_COLL_HIST_DTL
79: WHERE
80: collaboration_dtl_id = (SELECT MAX(collaboration_dtl_id) FROM CLN_COLL_HIST_DTL
81: WHERE DOCUMENT_DIRECTION = 'OUT'
82: AND (XMLG_MSG_ID IS NOT NULL
83: OR (DOCUMENT_DIRECTION IS NOT NULL AND
84: XMLG_TRANSACTION_TYPE IS NOT NULL AND

Line 104: cln_debug_pub.Add('After Sql Query - cln_coll_hist_dtl',1);

100: END IF;
101: RETURN;
102: END;
103: IF (l_Debug_Level <= 1) THEN
104: cln_debug_pub.Add('After Sql Query - cln_coll_hist_dtl',1);
105: cln_debug_pub.Add('--------- Parameters Obtained ----------------',1);
106: cln_debug_pub.Add('XMLG TRANSACTION TYPE -'||l_xmlg_transaction_type,1);
107: cln_debug_pub.Add('XMLG TRANSACTION SUB TYPE -'||l_xmlg_transaction_subtype,1);
108: cln_debug_pub.Add('XMLG DOCUMENT ID -'||l_xmlg_doc_id,1);