430:
431: CURSOR c_order_line (p_line_id IN NUMBER) IS
432: SELECT line_category_code, shipped_quantity, flow_status_code,
433: invoice_interface_status_code, invoiced_quantity, actual_shipment_date
434: FROM oe_order_lines_all
435: WHERE line_id = p_line_id;
436:
437: CURSOR c_order_num (p_header_id IN NUMBER) IS
438: SELECT order_number