APPS.OE_UPDATE_ACK_UTIL dependencies on DUAL

Line 25: FROM DUAL;

21: IF OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110510' THEN
22: -- bug 3392678
23: SELECT OE_XML_MESSAGE_SEQ_S.NEXTVAL
24: INTO l_em_message_id
25: FROM DUAL;
26: END IF;
27:
28: Select order_source_id, orig_sys_document_ref, request_id
29: into l_order_source_id, l_orig_sys_document_ref, l_request_id

Line 95: FROM DUAL;

91: IF OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110510' THEN
92: -- bug 3392678
93: SELECT OE_XML_MESSAGE_SEQ_S.NEXTVAL
94: INTO l_em_message_id
95: FROM DUAL;
96: END IF;
97:
98: select last_ack_code
99: into l_ack_code

Line 1322: From dual;

1318: l_event_name := 'oracle.apps.ont.oi.edi_ack_values.create';
1319:
1320: Select Oe_Xml_Message_Seq_S.nextval
1321: Into l_itemkey
1322: From dual;
1323:
1324: wf_event.AddParameterToList(p_name=> 'TRANSACTION_TYPE',
1325: p_value=> p_transaction_type,
1326: p_parameterlist=> l_parameter_list);