APPS.OE_SYNC_ORDER_PVT dependencies on OE_XML_MESSAGE_SEQ_S

Line 615: select OE_XML_MESSAGE_SEQ_S.nextval

611: IF l_debug_level > 0 THEN
612: oe_debug_pub.add('sync_header_line- APPLY- Inserting row into oe_line_acks for p_line_id');
613: END IF;
614:
615: select OE_XML_MESSAGE_SEQ_S.nextval
616: into l_itemkey
617: from dual;
618:
619: INSERT_SYNC_lINE(P_LINE_rec => P_LINE_rec,

Line 663: select OE_XML_MESSAGE_SEQ_S.nextval

659:
660: IF l_debug_level > 0 THEN
661: oe_debug_pub.add('sync_header_line - Inserting row into oe_header_acks for header_id');
662: END IF;
663: select OE_XML_MESSAGE_SEQ_S.nextval
664: into l_itemkey
665: from dual;
666:
667: INSERT_SYNC_HEADER(p_header_rec => p_header_rec,

Line 723: select OE_XML_MESSAGE_SEQ_S.nextval

719:
720:
721: IF hdr_rec.line_id IS NULL THEN
722:
723: select OE_XML_MESSAGE_SEQ_S.nextval
724: into l_itemkey
725: from dual;
726:
727: IF l_debug_level > 0 THEN

Line 769: select OE_XML_MESSAGE_SEQ_S.nextval

765: oe_debug_pub.add('sync_header_line - hdr_rec.header_id'||hdr_rec.header_id);
766: oe_debug_pub.add('sync_header_line - l_prev_header_id'||l_prev_header_id);
767: END IF;
768: If hdr_rec.header_id <> nvl(l_prev_header_id,-1) THEN
769: select OE_XML_MESSAGE_SEQ_S.nextval
770: into l_itemkey
771: from dual;
772:
773: IF l_debug_level > 0 THEN

Line 917: select OE_XML_MESSAGE_SEQ_S.nextval

913: oe_debug_pub.add('... Assigning from passed in parameters...');
914: l_line_rec := p_line_rec;
915: end if;
916:
917: select OE_XML_MESSAGE_SEQ_S.nextval
918: into l_itemkey
919: from dual;
920:
921: IF l_debug_level > 0 THEN

Line 955: select OE_XML_MESSAGE_SEQ_S.nextval

951: END IF;
952: ELSIF ord_rec.line_id IS NULL AND
953: ord_rec.header_id IS NOT NULL THEN
954:
955: select OE_XML_MESSAGE_SEQ_S.nextval
956: into l_itemkey
957: from dual;
958:
959: INSERT_SYNC_HEADER(p_header_rec => l_header_rec,

Line 1287: SELECT OE_XML_MESSAGE_SEQ_S.nextval /* New one to be seeded */

1283: IF l_debug_level > 0 THEN
1284: oe_debug_pub.add('raise_bpel_out_event - Finished adding parameters to l_parameter_list');
1285: END IF;
1286:
1287: SELECT OE_XML_MESSAGE_SEQ_S.nextval /* New one to be seeded */
1288: INTO l_itemkey
1289: FROM DUAL;
1290:
1291: IF l_debug_level > 0 THEN