752: BEGIN
753:
754: SELECT nvl(sum(shipped_quantity),0)
755: INTO l_del_shipping_quantity
756: FROM wsh_delivery_details
757: where source_line_id in (SELECT line_id
758: FROM oe_order_lines
759: WHERE line_set_id = l_line_rec.line_set_id
760: AND shipped_quantity IS NULL