APPS.OE_DELAYED_REQUESTS_UTIL dependencies on DUAL

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

3072: l_number := l_number + 1;
3073:
3074: l_line_tbl(l_number) := OE_ORDER_PUB.G_MISS_LINE_REC;
3075: IF l_number = 1 THEN
3076: select oe_sets_s.nextval into l_fulfillment_set_id from dual;
3077:
3078: insert into oe_sets
3079: ( SET_ID, SET_NAME, SET_TYPE, HEADER_ID, SHIP_FROM_ORG_ID,
3080: SHIP_TO_ORG_ID,SCHEDULE_SHIP_DATE, SCHEDULE_ARRIVAL_DATE,

Line 5503: FROM DUAL;

5499: IF l_match_flag = 'N' THEN
5500:
5501: select OE_PRICE_ADJUSTMENTS_S.nextval
5502: INTO l_price_adjustment_id
5503: FROM DUAL;
5504:
5505: l_Line_adj_rec.price_adjustment_id := l_price_adjustment_id;
5506: l_Line_adj_rec.header_id := l_header_id;
5507: l_Line_adj_rec.last_update_date := SYSDATE;

Line 6184: from dual;

6180:
6181: IF l_reciever_code IN ('C', 'B') THEN --start of check for customer ack request
6182: select OE_XML_MESSAGE_SEQ_S.nextval
6183: into l_itemkey
6184: from dual;
6185:
6186: IF l_debug_level > 0 THEN
6187: oe_debug_pub.add( 'sequence value: ' || l_itemkey) ;
6188: end if;