The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT m4u_wlqid_s.NEXTVAL
INTO l_event_key
FROM dual;
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_gtin_query_id,
p_msg_text => l_fnd_msg,
p_xmlg_msg_id => NULL,
p_xmlg_transaction_type => 'M4U',
p_xmlg_transaction_subtype => 'RESP_GTIN',
p_xmlg_int_transaction_type => 'M4U',
p_xmlg_int_transaction_subtype => 'RESP_GTIN',
p_doc_dir => 'IN',
p_doc_type => 'M4U_RESP_GTIN',
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_attribute2 => p_target_market,
p_attribute3 => p_gtin,
p_attribute4 => p_name_of_info_provider,
p_attribute6 => p_brand_owner_gln,
p_attribute7 => p_brand_owner_name,
p_attribute8 => p_ucc_doc_unique_id,
p_attribute9 => p_trade_item_unit_desc,
p_attribute10 => p_eanucc_code||'-'||p_eanucc_type,
p_attribute11 => p_success_flag,
p_attribute13 => p_delivery_method,
p_attribute14 => p_is_info_pvt,
p_attribute15 => p_brand_name,
p_dattribute1 => sysdate,
p_dattribute2 => null,
p_rosettanet_check_required => false,
x_dtl_coll_id => l_collab_detail_id );
cln_debug_pub.Add('-- Update Collab API returns Values -' ,1);