240: RETURN ;
241: END IF ;
242:
243: -- Insert the XDP Order Line
244: INSERT INTO XDP_OE_ORDER_LINES (
245: ORDER_NUMBER,
246: ORDER_VERSION,
247: LINE_NUMBER,
248: LINE_ITEM_NAME,
367: -- AND ORDER_VERSION IS NULL;
368:
369: CURSOR lc_line IS
370: SELECT *
371: FROM XDP_OE_ORDER_LINES
372: WHERE ORDER_NUMBER = p_oe_order_number
373: AND ORDER_VERSION = p_oe_order_version;
374:
375: /* p_oe_order_version made mandatory. This cursor is never opened.
377: ** 02/27/2001. skilaru
378: */
379: -- CURSOR lc_line2 IS
380: -- SELECT *
381: -- FROM XDP_OE_ORDER_LINES
382: -- WHERE ORDER_NUMBER = p_oe_order_number
383: -- AND ORDER_VERSION IS NULL;
384:
385: CURSOR lc_line_param IS