存储过程 入参为空的优化

 procedure SALE(para_s_rq in varchar2 ,

  para_e_rq in varchar2,

  para_reminder_id in varchar2,

  para_buyer_id in varchar2,

  para_goods_id in varchar2,

  para_supplier_id in varchar2,

  para_saler_id in varchar2,

  para_orgid in integer,

  para_p_cursor out t_cursor)   is

begin

 insert into A

select * from B

where b.date between(para_s_rq and para_e_rq)

(case when para_supplier_id is null or t.policy_supp_id =para_supplier_id then 1 else 0 end)=1

           and (case when para_reminder_id is null or t.policy_reminder_id =para_reminder_id then 1 else 0 end)=1

           and (case when para_orgid is null or b.org_id =para_orgid then 1 else 0 end)=1           

           and (case when para_goods_id is null or b.goodsid=para_goods_id then 1 else 0 end)=1

           and (case when para_buyer_id is null or b.SUPPLYERID=para_buyer_id then 1 else 0 end)=1

           and (case when para_reminder_id is null or t.policy_reminder_id=para_reminder_id then 1 else 0 end)=1

           and (case when para_saler_id is null or b.salerid=para_saler_id then 1 else 0 end)=1           

end SALE_REBATE_SETTLE;