The following lines contain the word 'select', 'insert', 'update' or 'delete':
FUNCTION UPDATE_EVENT_SUB(
p_subscription_guid IN RAW,
p_event IN OUT NOCOPY WF_EVENT_T
) RETURN VARCHAR2
IS
l_cln_ch_parameters wf_parameter_list_t;
ecx_cln_debug_pub.Add('============ENTERING CLN_UPDATE_EVENT_SUB============', 2);
CLN_CH_COLLABORATION_PKG.UPDATE_COLLABORATION(
x_return_status => l_return_status,
x_msg_data => l_msg_data,
p_coll_id => l_coll_id,
p_app_id => l_app_id,
p_ref_id => l_ref_id,
p_rel_no => l_rel_no,
p_doc_no => l_doc_no,
p_doc_rev_no => l_doc_rev_no,
p_xmlg_transaction_type => l_xmlg_transaction_type,
p_xmlg_transaction_subtype => l_xmlg_transaction_subtype,
p_xmlg_document_id => l_xmlg_document_id,
p_resend_flag => l_resend_flag,
p_resend_count => l_resend_count,
p_disposition => l_disposition,
p_coll_status => l_coll_status,
p_doc_type => l_doc_type,
p_doc_dir => l_doc_dir,
p_coll_pt => l_coll_pt,
p_org_ref => l_org_ref,
p_doc_status => l_doc_status,
p_notification_id => NULL,
p_msg_text => l_msg_text,
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_msg_id,
p_unique1 => l_unique1,
p_unique2 => l_unique2,
p_unique3 => l_unique3,
p_unique4 => l_unique4,
p_unique5 => l_unique5,
p_tr_partner_type => l_tr_partner_type,
p_tr_partner_id => l_tr_partner_id,
p_tr_partner_site => l_tr_partner_site,
p_sender_component => l_sender_protocol,
p_rosettanet_check_required => l_rosettanet_check_required_b,
x_dtl_coll_id => l_dtl_coll_id,
p_xmlg_internal_control_number => l_xmlg_internal_control_number,
p_partner_doc_no => l_partner_doc_no,
p_org_id => l_org_id,
p_doc_creation_date => l_doc_creation_date,
p_doc_revision_date => l_doc_revision_date,
p_doc_owner => l_doc_owner,
p_xmlg_int_transaction_type => l_xmlg_int_transaction_type,
p_xmlg_int_transaction_subtype => l_xmlg_int_transaction_subtype,
p_xml_event_key => l_xml_event_key,
p_collaboration_standard => l_collaboration_standard,
p_attribute1 => l_attribute1,
p_attribute2 => l_attribute2,
p_attribute3 => l_attribute3,
p_attribute4 => l_attribute4,
p_attribute5 => l_attribute5,
p_attribute6 => l_attribute6,
p_attribute7 => l_attribute7,
p_attribute8 => l_attribute8,
p_attribute9 => l_attribute9,
p_attribute10 => l_attribute10,
p_attribute11 => l_attribute11,
p_attribute12 => l_attribute12,
p_attribute13 => l_attribute13,
p_attribute14 => l_attribute14,
p_attribute15 => l_attribute15,
p_dattribute1 => l_dattribute1,
p_dattribute2 => l_dattribute2,
p_dattribute3 => l_dattribute3,
p_dattribute4 => l_dattribute4,
p_dattribute5 => l_dattribute5,
p_owner_role => l_owner_role );
ecx_cln_debug_pub.Add('============EXITING CLN_UPDATE_EVENT_SUB============', 2);
ecx_cln_debug_pub.Add('============EXITING CLN_UPDATE_EVENT_SUB============', 2);
ecx_cln_debug_pub.Add('============EXITING CLN_UPDATE_EVENT_SUB============', 2);
END UPDATE_EVENT_SUB;
ecx_cln_debug_pub.Add('============EXITING CLN_UPDATE_EVENT_SUB============', 2);
SELECT UPPER(l_batch_mode) INTO l_batch_mode FROM DUAL ;