APPS.OE_ACKNOWLEDGMENT_PUB dependencies on OE_XML_MESSAGE_SEQ_S

Line 220: Select Oe_Xml_Message_Seq_S.nextval

216: return;
217: End If;
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 ) ;

Line 366: select OE_XML_MESSAGE_SEQ_S.nextval

362: IF l_debug_level > 0 THEN
363: oe_debug_pub.add( 'passed-in itemkey was null...pulling value from sequence') ;
364: end if;
365:
366: select OE_XML_MESSAGE_SEQ_S.nextval
367: into l_itemkey
368: from dual;
369: else
370:

Line 1794: select OE_XML_MESSAGE_SEQ_S.nextval

1790:
1791: l_header_rec := p_header_rec;
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

Line 1798: select OE_XML_MESSAGE_SEQ_S.nextval

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

Line 3049: SELECT OE_XML_MESSAGE_SEQ_S.nextval

3045: oe_debug_pub.add( 'ADDING PARAMETERS TO XML INTEGRATION EVENT' ) ;
3046: END IF;
3047:
3048: --generating a unique event key
3049: SELECT OE_XML_MESSAGE_SEQ_S.nextval
3050: INTO l_eventkey
3051: FROM dual;
3052:
3053:

Line 3916: SELECT OE_XML_MESSAGE_SEQ_S.nextval

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