APPS.OE_ACKNOWLEDGMENT_PUB dependencies on DUAL

Line 222: From dual;

218: END IF;
219: END IF;
220: Select Oe_Xml_Message_Seq_S.nextval
221: Into l_itemkey
222: From dual;
223: IF l_debug_level > 0 THEN
224: oe_debug_pub.add( 'L_ITEMKEY = '||L_ITEMKEY || ' ORG ID passed in is ' || p_org_id ) ;
225: END IF;
226:

Line 368: from dual;

364: end if;
365:
366: select OE_XML_MESSAGE_SEQ_S.nextval
367: into l_itemkey
368: from dual;
369: else
370:
371: l_itemkey := p_itemkey;
372:

Line 1796: from dual;

1792: l_line_tbl := p_line_tbl;
1793:
1794: select OE_XML_MESSAGE_SEQ_S.nextval
1795: into l_itemkey_sso
1796: from dual;
1797:
1798: select OE_XML_MESSAGE_SEQ_S.nextval
1799: into l_itemkey_cso
1800: from dual;

Line 1800: from dual;

1796: from dual;
1797:
1798: select OE_XML_MESSAGE_SEQ_S.nextval
1799: into l_itemkey_cso
1800: from dual;
1801:
1802: -- no longer needed, and we also are using the actual request_id
1803: -- to detect which lines were changed by the buyer for 3a7
1804:

Line 3051: FROM dual;

3047:
3048: --generating a unique event key
3049: SELECT OE_XML_MESSAGE_SEQ_S.nextval
3050: INTO l_eventkey
3051: FROM dual;
3052:
3053:
3054: -- { begin code release level
3055: IF OE_Code_Control.Code_Release_Level >= '110510' THEN

Line 3085: NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))) into l_org_id from DUAL; */

3081: END IF;
3082: IF l_org_id = FND_API.G_MISS_NUM THEN
3083:
3084: /* SELECT TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ',
3085: NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))) into l_org_id from DUAL; */
3086: l_org_id := MO_GLOBAL.Get_Current_Org_Id; --moac
3087: l_converted := l_converted || 'ORG_ID, ';
3088: END IF;
3089:

Line 3918: FROM dual;

3914: p_parameterlist=> l_parameter_list);
3915:
3916: SELECT OE_XML_MESSAGE_SEQ_S.nextval
3917: INTO l_eventkey
3918: FROM dual;
3919:
3920: wf_event.raise( p_event_name => 'oracle.apps.ont.oi.cbod_out.confirm',
3921: p_event_key => l_eventkey,
3922: p_parameters => l_parameter_list);