DBA Data[Home] [Help]

APPS.CLN_WSH_SHIP_ORDER_OUT_PKG dependencies on DUAL

Line 83: SELECT cln_generic_s.nextval INTO l_event_key FROM dual;

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

Line 221: SELECT cln_generic_s.nextval INTO l_event_key FROM dual;

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