APPS.OE_SYNC_ORDER_PVT dependencies on OE_XML_MESSAGE_SEQ_S

Line 509: select OE_XML_MESSAGE_SEQ_S.nextval

505: IF l_debug_level > 0 THEN
506: oe_debug_pub.add('sync_header_line- APPLY- Inserting row into oe_line_acks for p_line_id');
507: END IF;
508:
509: select OE_XML_MESSAGE_SEQ_S.nextval
510: into l_itemkey
511: from dual;
512:
513: INSERT_SYNC_lINE(P_LINE_rec => P_LINE_rec,

Line 556: select OE_XML_MESSAGE_SEQ_S.nextval

552:
553: IF l_debug_level > 0 THEN
554: oe_debug_pub.add('sync_header_line - Inserting row into oe_header_acks for header_id');
555: END IF;
556: select OE_XML_MESSAGE_SEQ_S.nextval
557: into l_itemkey
558: from dual;
559:
560: INSERT_SYNC_HEADER(p_header_rec => p_header_rec,

Line 608: select OE_XML_MESSAGE_SEQ_S.nextval

604:
605:
606: IF hdr_rec.line_id IS NULL THEN
607:
608: select OE_XML_MESSAGE_SEQ_S.nextval
609: into l_itemkey
610: from dual;
611:
612: IF l_debug_level > 0 THEN

Line 654: select OE_XML_MESSAGE_SEQ_S.nextval

650: oe_debug_pub.add('sync_header_line - hdr_rec.header_id'||hdr_rec.header_id);
651: oe_debug_pub.add('sync_header_line - l_prev_header_id'||l_prev_header_id);
652: END IF;
653: If hdr_rec.header_id <> nvl(l_prev_header_id,-1) THEN
654: select OE_XML_MESSAGE_SEQ_S.nextval
655: into l_itemkey
656: from dual;
657:
658: IF l_debug_level > 0 THEN

Line 779: select OE_XML_MESSAGE_SEQ_S.nextval

775: p_line_id => ord_rec.line_id
776: ,x_line_rec => l_line_rec
777: );
778:
779: select OE_XML_MESSAGE_SEQ_S.nextval
780: into l_itemkey
781: from dual;
782:
783: IF l_debug_level > 0 THEN

Line 817: select OE_XML_MESSAGE_SEQ_S.nextval

813: END IF;
814: ELSIF ord_rec.line_id IS NULL AND
815: ord_rec.header_id IS NOT NULL THEN
816:
817: select OE_XML_MESSAGE_SEQ_S.nextval
818: into l_itemkey
819: from dual;
820:
821: INSERT_SYNC_HEADER(p_header_rec => l_header_rec,

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

1120: IF l_debug_level > 0 THEN
1121: oe_debug_pub.add('raise_bpel_out_event - Finished adding parameters to l_parameter_list');
1122: END IF;
1123:
1124: SELECT OE_XML_MESSAGE_SEQ_S.nextval /* New one to be seeded */
1125: INTO l_itemkey
1126: FROM DUAL;
1127:
1128: IF l_debug_level > 0 THEN