APPS.OE_DELAYED_REQUESTS_UTIL dependencies on DUAL

Line 3297: select oe_sets_s.nextval into l_fulfillment_set_id from dual;

3293: l_number := l_number + 1;
3294:
3295: l_line_tbl(l_number) := OE_ORDER_PUB.G_MISS_LINE_REC;
3296: IF l_number = 1 THEN
3297: select oe_sets_s.nextval into l_fulfillment_set_id from dual;
3298:
3299: insert into oe_sets
3300: ( SET_ID, SET_NAME, SET_TYPE, HEADER_ID, SHIP_FROM_ORG_ID,
3301: SHIP_TO_ORG_ID,SCHEDULE_SHIP_DATE, SCHEDULE_ARRIVAL_DATE,

Line 5695: SELECT OE_PRICE_ADJUSTMENTS_S.nextval INTO l_price_adjustment_id FROM DUAL;

5691: /* end if condition for line level freight charge */
5692: END LOOP; --l_l_line_adj_tbl for
5693: END IF; --l_l_line_adj_tbl.COUNT > 0
5694: IF l_match_flag = 'N' THEN
5695: SELECT OE_PRICE_ADJUSTMENTS_S.nextval INTO l_price_adjustment_id FROM DUAL;
5696: l_adj_rec.parent_adjustment_id := NULL;
5697: l_adj_rec.price_adjustment_id := l_price_adjustment_id;
5698: l_adj_rec.header_id := l_tax_rec_out_tbl(i).trx_id;
5699: l_adj_rec.last_update_date := SYSDATE;

Line 5893: SELECT OE_PRICE_ADJUSTMENTS_S.nextval INTO l_price_adjustment_id FROM DUAL;

5889: END IF;
5890: /* end if condition for Header level freight charge */
5891: END LOOP; --l_l_header_adj_tbl for
5892: IF l_match_flag = 'N' AND l_tax_rec_out_tbl(i).line_id IS NULL THEN --TaxER
5893: SELECT OE_PRICE_ADJUSTMENTS_S.nextval INTO l_price_adjustment_id FROM DUAL;
5894: --TaxER start
5895: l_h_adj_rec.parent_adjustment_id := NULL;
5896: l_h_adj_rec.price_adjustment_id := l_price_adjustment_id;
5897: l_h_adj_rec.header_id := l_tax_rec_out_tbl(i).trx_id;

Line 6548: from dual;

6544:
6545: IF l_reciever_code IN ('C', 'B') THEN --start of check for customer ack request
6546: select OE_XML_MESSAGE_SEQ_S.nextval
6547: into l_itemkey
6548: from dual;
6549:
6550: IF l_debug_level > 0 THEN
6551: oe_debug_pub.add( 'sequence value: ' || l_itemkey) ;
6552: end if;