create or replace procedure Scan_Customer_Orders
is

begin
  for j in (
    select order_ref, vendor_id, scu, quantity from customer_orders
      where status is null )
  loop

    Submit_Order ( j.order_ref, j.vendor_id, j.scu, j.quantity );
  end loop;
end Scan_Customer_Orders;
/
Show Errors