79: cln_debug_pub.Add('p_doc_creation_date:' || p_doc_creation_date, 1);
80: cln_debug_pub.Add('p_appl_ref_id:' || p_appl_ref_id, 1);
81: END IF;
82:
83: SELECT cln_generic_s.nextval INTO l_event_key FROM dual;
84:
85: l_cln_ch_parameters := wf_parameter_list_t();
86:
87: -- This query can never fail
217: WHERE ENTITY_TYPE ='DLVY'
218: AND DOCUMENT_NUMBER = p_delivery_number
219: AND ROWNUM < 2;
220:
221: SELECT cln_generic_s.nextval INTO l_event_key FROM dual;
222:
223: l_cln_ch_parameters := wf_parameter_list_t();
224:
225: -- Set event parameters