The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT resend_count
INTO l_resend_count
FROM cln_coll_hist_hdr
WHERE collaboration_id = p_collaboration_id;
SELECT COLLABORATION_DOCUMENT_TYPE, XMLG_MSG_ID, collaboration_dtl_id,
XMLG_TRANSACTION_TYPE, XMLG_TRANSACTION_SUBTYPE, XMLG_DOCUMENT_ID, XML_EVENT_KEY
INTO l_collaboration_doc_type,l_xmlg_msgid, l_coll_dtl_id,
l_xmlg_transaction_type, l_xmlg_transaction_subtype, l_xmlg_doc_id, l_xml_event_key
FROM CLN_COLL_HIST_DTL
WHERE
collaboration_dtl_id = (SELECT MAX(collaboration_dtl_id) FROM CLN_COLL_HIST_DTL
WHERE DOCUMENT_DIRECTION = 'OUT'
AND (XMLG_MSG_ID IS NOT NULL
OR (DOCUMENT_DIRECTION IS NOT NULL AND
XMLG_TRANSACTION_TYPE IS NOT NULL AND
XMLG_TRANSACTION_SUBTYPE IS NOT NULL AND
XMLG_DOCUMENT_ID IS NOT NULL)
)
AND COLLABORATION_ID = p_collaboration_id
AND COLLABORATION_DOCUMENT_TYPE <> 'CONFIRM_BOD');
SELECT MSGID
INTO l_xmlg_msgid
FROM ECX_DOCLOGS dlogs
WHERE dlogs.TRANSACTION_TYPE = l_xmlg_transaction_type AND
dlogs.TRANSACTION_SUBTYPE = l_xmlg_transaction_subtype AND
dlogs.DIRECTION = 'OUT' AND
dlogs.DOCUMENT_NUMBER = l_xmlg_doc_id AND
(event_key is null OR l_xml_event_key is null OR event_key = l_xml_event_key);
cln_debug_pub.Add('----- Before calling Update Collaboration -------',1);
CLN_CH_COLLABORATION_PKG.UPDATE_COLLABORATION(
x_return_status => l_return_status,
x_msg_data => l_msg_data,
p_coll_id => p_collaboration_id,
p_app_id => NULL,
p_ref_id => NULL,
p_rel_no => NULL,
p_doc_no => NULL,
p_doc_rev_no => NULL,
p_xmlg_transaction_type => NULL,
p_xmlg_transaction_subtype => NULL,
p_xmlg_document_id => NULL,
p_resend_flag => 'Y',
p_resend_count => l_resend_count,
p_disposition => NULL,
p_coll_status => 'RESENT',
p_doc_type => l_collaboration_doc_type,
p_doc_dir => NULL,
p_coll_pt => NULL,
p_org_ref => NULL,
p_doc_status => 'SUCCESS',
p_notification_id => NULL,
p_msg_text => 'CLN_CH_RESEND_MSG',
p_bsr_verb => NULL,
p_bsr_noun => NULL,
p_bsr_rev => NULL,
p_sdr_logical_id => NULL,
p_sdr_component => NULL,
p_sdr_task => NULL,
p_sdr_refid => NULL,
p_sdr_confirmation => NULL,
p_sdr_language => NULL,
p_sdr_codepage => NULL,
p_sdr_authid => NULL,
p_sdr_datetime_qualifier => NULL,
p_sdr_datetime => NULL,
p_sdr_timezone => NULL,
p_attr1 => NULL,
p_attr2 => NULL,
p_attr3 => NULL,
p_attr4 => NULL,
p_attr5 => NULL,
p_attr6 => NULL,
p_attr7 => NULL,
p_attr8 => NULL,
p_attr9 => NULL,
p_attr10 => NULL,
p_attr11 => NULL,
p_attr12 => NULL,
p_attr13 => NULL,
p_attr14 => NULL,
p_attr15 => NULL,
p_xmlg_msg_id => l_xmlg_msgid ,
p_unique1 => NULL,
p_unique2 => NULL,
p_unique3 => NULL,
p_unique4 => NULL,
p_unique5 => NULL,
p_tr_partner_type => NULL,
p_tr_partner_id => NULL,
p_tr_partner_site => NULL,
p_sender_component => NULL,
p_rosettanet_check_required => NULL,
x_dtl_coll_id => l_dtl_coll_id
);