APPS.OE_ACKNOWLEDGMENT_PUB dependencies on DUAL

Line 227: From dual;

223: END IF;
224: END IF;
225: Select Oe_Xml_Message_Seq_S.nextval
226: Into l_itemkey
227: From dual;
228: IF l_debug_level > 0 THEN
229: oe_debug_pub.add( 'L_ITEMKEY = '||L_ITEMKEY || ' ORG ID passed in is ' || p_org_id ) ;
230: END IF;
231:

Line 373: from dual;

369: end if;
370:
371: select OE_XML_MESSAGE_SEQ_S.nextval
372: into l_itemkey
373: from dual;
374: else
375:
376: l_itemkey := p_itemkey;
377:

Line 1808: from dual;

1804: l_line_tbl := p_line_tbl;
1805:
1806: select OE_XML_MESSAGE_SEQ_S.nextval
1807: into l_itemkey_sso
1808: from dual;
1809:
1810: select OE_XML_MESSAGE_SEQ_S.nextval
1811: into l_itemkey_cso
1812: from dual;

Line 1812: from dual;

1808: from dual;
1809:
1810: select OE_XML_MESSAGE_SEQ_S.nextval
1811: into l_itemkey_cso
1812: from dual;
1813:
1814: -- no longer needed, and we also are using the actual request_id
1815: -- to detect which lines were changed by the buyer for 3a7
1816:

Line 3167: FROM dual;

3163:
3164: --generating a unique event key
3165: SELECT OE_XML_MESSAGE_SEQ_S.nextval
3166: INTO l_eventkey
3167: FROM dual;
3168:
3169:
3170: -- { begin code release level
3171: IF OE_Code_Control.Code_Release_Level >= '110510' THEN

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

3197: END IF;
3198: IF l_org_id = FND_API.G_MISS_NUM THEN
3199:
3200: /* SELECT TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ',
3201: NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))) into l_org_id from DUAL; */
3202: l_org_id := MO_GLOBAL.Get_Current_Org_Id; --moac
3203: l_converted := l_converted || 'ORG_ID, ';
3204: END IF;
3205:

Line 4034: FROM dual;

4030: p_parameterlist=> l_parameter_list);
4031:
4032: SELECT OE_XML_MESSAGE_SEQ_S.nextval
4033: INTO l_eventkey
4034: FROM dual;
4035:
4036: wf_event.raise( p_event_name => 'oracle.apps.ont.oi.cbod_out.confirm',
4037: p_event_key => l_eventkey,
4038: p_parameters => l_parameter_list);