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 94: FROM DUAL;

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

Line 1321: From dual;

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