APPS.OE_SYNC_ORDER_PVT dependencies on DUAL

Line 511: from dual;

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,
514: p_change_type => p_change_type,
515: p_req_id => l_itemkey, -- XXXX

Line 558: from dual;

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,
561: p_change_type => p_change_type,
562: p_req_id => l_itemkey, --XXXX

Line 610: from dual;

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
613: oe_debug_pub.add('sync_header_line - l_itemkey '|| l_itemkey);
614: END IF;

Line 656: from dual;

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
659: oe_debug_pub.add('sync_header_line-l_prev_header_id=' || l_prev_header_id);
660: oe_debug_pub.add('sync_header_line-hdr_rec.header_id=' || hdr_rec.header_id);

Line 781: from dual;

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
784: oe_debug_pub.add('sync_header_line -RELEASE-BEFORE INSERTING HEADER ');
785: END IF;

Line 819: from dual;

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,
822: p_change_type => p_change_type,
823: p_req_id => l_itemkey, --XXXX

Line 1126: FROM DUAL;

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
1129: oe_debug_pub.add('raise_bpel_out_event - Generated value of l_itemkey: '||l_itemkey);
1130: END IF;