The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE UPDATE_COLLABORATION(
x_return_status OUT NOCOPY VARCHAR2,
x_msg_data OUT NOCOPY VARCHAR2,
p_ref_id IN VARCHAR2,
p_doc_no IN VARCHAR2,
p_part_doc_no IN VARCHAR2,
p_msg_text IN VARCHAR2,
p_status_code IN NUMBER,
p_int_ctl_num IN NUMBER,
p_tp_header_id IN NUMBER)
IS
l_cln_ch_parameters wf_parameter_list_t;
cln_debug_pub.Add('ENTERING UPDATE_COLLABORATION', 2);
FND_MESSAGE.SET_TOKEN('EVENT','Update');
SELECT cln_generic_s.nextval INTO l_event_key FROM dual;
WF_EVENT.Raise('oracle.apps.cln.ch.collaboration.update',
l_event_key, NULL, l_cln_ch_parameters, NULL);
cln_debug_pub.Add('Workflow event- oracle.apps.cln.ch.collaboration.update raised', 1);
cln_debug_pub.Add('EXITING UPDATE_COLLABORATION', 2);
cln_debug_pub.Add('EXITING UPDATE_COLLABORATION', 2);
END UPDATE_COLLABORATION;
SELECT cln_generic_s.nextval INTO l_event_key FROM dual;