APPS.OE_SYNC_ORDER_PVT dependencies on DUAL

Line 617: from dual;

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,
620: p_change_type => p_change_type,
621: p_req_id => l_itemkey, -- XXXX

Line 665: from dual;

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,
668: p_change_type => p_change_type,
669: p_req_id => l_itemkey, --XXXX

Line 725: from dual;

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

Line 771: from dual;

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

Line 919: from dual;

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

Line 957: from dual;

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,
960: p_change_type => p_change_type,
961: p_req_id => l_itemkey, --XXXX

Line 1289: FROM DUAL;

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