Create or replace procedure New_Bill
(
	   p_BID in bills.BILL_ID %type,
	   p_BRID in bills.BRANCH_ID %type,
	   p_EMPID in bills.EMPLOYEE_ID%type,
	   p_CUSID in bills.CUSTOMER_ID%type,
           p_TOTAL in bills.TOTAL%type,
           p_DISCOUNT in bills.DISCOUNT%type,
           p_F_TOTAL in bills.FINAL_TOTAL%type,
           p_BDATE in bills.BILL_DATE%type,
           p_bill_id in bill_details.BILL_ID%type,
           p_pro_id in bill_details.PRODUCT_ID%type,
           p_cate_id in bill_details.CATEGORY_ID%type,
           p_price in bill_details.PRICE%type,
           p_disc in  bill_details.DISCOUNT%type,
           p_f_price in bill_details.FINAL_PRICE%type,
           p_quantity in bill_details.QUANTITY%type,
           p_tot in bill_details.TOTAL%type
 )
is
begin
  insert into bills
  values (p_BID,p_BRID,p_EMPID,p_CUSID,p_TOTAL,p_DISCOUNT,p_F_TOTAL,p_BDATE);
  insert into bill_details
  values (p_bill_id,p_pro_id,p_cate_id,p_price,p_disc,p_f_price,p_quantity,p_tot);
  commit;
END;

exec new_bill(..all your input values...);

new_bill(..all your input values...);