APPS.OE_ORDER_COPY_UTIL dependencies on DUAL

Line 2713: FROM dual;

2709:
2710: -- Pre-populate the line_id to load G_Line_Num_Rec
2711: SELECT OE_ORDER_LINES_S.NEXTVAL
2712: INTO p_x_line_tbl(k).line_id
2713: FROM dual;
2714: G_Line_Num_Rec.new_line_id(J) := p_x_line_tbl(k).line_id;
2715: IF l_debug_level > 0 THEN
2716: oe_debug_pub.add( 'NEW LINE ID IS '||P_X_LINE_TBL ( K ) .LINE_ID , 1 ) ;
2717: END IF;

Line 2762: FROM DUAL;

2758: l_line_set_tbl(x).line_set_id IS NULL
2759: THEN
2760: SELECT OE_SETS_S.NEXTVAL
2761: INTO l_line_set_tbl(x).line_set_id
2762: FROM DUAL;
2763: l_index := l_line_set_tbl(x).line_index;
2764: p_x_line_tbl(l_index).line_set_id :=
2765: l_line_set_tbl(x).line_set_id;
2766: END IF;

Line 4060: FROM DUAL;

4056:
4057: -- Pre-populate header_id on the header record.
4058: SELECT OE_ORDER_HEADERS_S.NEXTVAL
4059: INTO l_header_rec.header_id
4060: FROM DUAL;
4061:
4062: --R12 CC Encryption
4063: oe_debug_pub.add('New header id...'||l_header_rec.header_id);
4064: --oe_debug_pub.adD('Original trxn extn id'||l_x_header_payment_tbl(1).trxn_extension_id);

Line 5116: FROM DUAL;

5112: IF l_copied_rec.line_set_id(m) IS NULL THEN
5113:
5114: SELECT OE_SETS_S.NEXTVAL
5115: INTO l_copied_rec.line_set_id(m)
5116: FROM DUAL;
5117: /*
5118: Create_Line_Set(
5119: p_line_id => l_copied_rec.line_id(m),
5120: p_line_set_id => l_copied_rec.line_set_id(m)