APPS.OE_ORDER_COPY_UTIL dependencies on DUAL

Line 2594: FROM dual;

2590:
2591: -- Pre-populate the line_id to load G_Line_Num_Rec
2592: SELECT OE_ORDER_LINES_S.NEXTVAL
2593: INTO p_x_line_tbl(k).line_id
2594: FROM dual;
2595: G_Line_Num_Rec.new_line_id(J) := p_x_line_tbl(k).line_id;
2596: IF l_debug_level > 0 THEN
2597: oe_debug_pub.add( 'NEW LINE ID IS '||P_X_LINE_TBL ( K ) .LINE_ID , 1 ) ;
2598: END IF;

Line 2643: FROM DUAL;

2639: l_line_set_tbl(x).line_set_id IS NULL
2640: THEN
2641: SELECT OE_SETS_S.NEXTVAL
2642: INTO l_line_set_tbl(x).line_set_id
2643: FROM DUAL;
2644: l_index := l_line_set_tbl(x).line_index;
2645: p_x_line_tbl(l_index).line_set_id :=
2646: l_line_set_tbl(x).line_set_id;
2647: END IF;

Line 3910: FROM DUAL;

3906:
3907: -- Pre-populate header_id on the header record.
3908: SELECT OE_ORDER_HEADERS_S.NEXTVAL
3909: INTO l_header_rec.header_id
3910: FROM DUAL;
3911:
3912: --R12 CC Encryption
3913: oe_debug_pub.add('New header id...'||l_header_rec.header_id);
3914: --oe_debug_pub.adD('Original trxn extn id'||l_x_header_payment_tbl(1).trxn_extension_id);

Line 4949: FROM DUAL;

4945: IF l_copied_rec.line_set_id(m) IS NULL THEN
4946:
4947: SELECT OE_SETS_S.NEXTVAL
4948: INTO l_copied_rec.line_set_id(m)
4949: FROM DUAL;
4950: /*
4951: Create_Line_Set(
4952: p_line_id => l_copied_rec.line_id(m),
4953: p_line_set_id => l_copied_rec.line_set_id(m)