APPS.OE_ACKNOWLEDGMENT_PUB dependencies on OE_XML_MESSAGE_SEQ_S

Line 225: Select Oe_Xml_Message_Seq_S.nextval

221: return;
222: End If;
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 ) ;

Line 371: select OE_XML_MESSAGE_SEQ_S.nextval

367: IF l_debug_level > 0 THEN
368: oe_debug_pub.add( 'passed-in itemkey was null...pulling value from sequence') ;
369: end if;
370:
371: select OE_XML_MESSAGE_SEQ_S.nextval
372: into l_itemkey
373: from dual;
374: else
375:

Line 1806: select OE_XML_MESSAGE_SEQ_S.nextval

1802:
1803: l_header_rec := p_header_rec;
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

Line 1810: select OE_XML_MESSAGE_SEQ_S.nextval

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;
1813:
1814: -- no longer needed, and we also are using the actual request_id

Line 3165: SELECT OE_XML_MESSAGE_SEQ_S.nextval

3161: oe_debug_pub.add( 'ADDING PARAMETERS TO XML INTEGRATION EVENT' ) ;
3162: END IF;
3163:
3164: --generating a unique event key
3165: SELECT OE_XML_MESSAGE_SEQ_S.nextval
3166: INTO l_eventkey
3167: FROM dual;
3168:
3169:

Line 4032: SELECT OE_XML_MESSAGE_SEQ_S.nextval

4028: wf_event.AddParameterToList(p_name=> 'PARAMETER7',
4029: p_value=> p_change_sequence,
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',