The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT m4u_wlqid_s.NEXTVAL
INTO l_event_key
FROM dual;
SELECT attribute14
INTO l_org_status_db
FROM CLN_COLL_HIST_HDR
WHERE collaboration_id = ( SELECT collaboration_id
FROM CLN_COLL_HIST_DTL
WHERE collaboration_dtl_id = p_collab_dtl_id);
/* NO PROCESSING/UPDATE DEFINED */
--create unique key for each event using CLN sequence
SELECT cln_collaboration_msg_id_s.nextval INTO l_event_key FROM dual ;
/* NO PROCESSING/UPDATE DEFINED */
/* IN-FUTURE THIS CAN BE EXTENDED */
x_return_status := FND_API.G_RET_STS_SUCCESS;
cln_debug_pub.Add('-- Update collaboration parameters set -',1);
cln_ch_collaboration_pkg.update_collaboration(
x_return_status => x_return_status,
x_msg_data => x_msg_data,
p_coll_id => p_party_query_id,
p_msg_text => l_fnd_msg,
p_xmlg_msg_id => NULL,
p_xmlg_transaction_type => 'M4U',
p_xmlg_transaction_subtype => 'RESP_PARTY',
p_xmlg_int_transaction_type => 'M4U',
p_xmlg_int_transaction_subtype => 'RESP_PARTY',
p_doc_dir => 'IN',
p_doc_type => 'M4U_RESP_PARTY',
p_disposition => l_disposition,
p_doc_status => l_doc_status,
p_coll_status => l_coll_status,
p_xmlg_document_id => NULL,
p_xmlg_internal_control_number => p_xmlg_internal_control_no,
p_tr_partner_type => m4u_ucc_utils.c_party_type,
p_tr_partner_id => m4u_ucc_utils.g_party_id,
p_tr_partner_site => m4u_ucc_utils.g_party_site_id,
p_attribute8 => p_ucc_doc_unique_id,
p_attribute9 => null,
p_dattribute1 => sysdate,
p_rosettanet_check_required => false,
x_dtl_coll_id => x_collab_detail_id );
cln_debug_pub.Add('-- Update Collab API returns Values -' ,1);