create or replace package body dealingchk_pac is
function itemchk(p_itemno n_3ditemb.item_no%type default null,
p_type n_3ditemb.type%type default null,
p_symbol n_3ditembrec.trade_symbol%type default null,
p_code n_3duser.code%type default null,
p_sttime n_3ditembrec.time%type default null,
p_endtime n_3ditembrec.time%type default null)
return chk_rec
is
v_itemno n_3ditemb.item_no%type:=null;
v_type n_3ditemb.type%type:=null;
v_symbol n_3ditembrec.trade_symbol%type:=null;
v_code n_3duser.code%type:=null;
v_time n_3ditembrec.time%type:=null;
begin
if p_itemno is not null then
v_itemno:=' and b.item_no='||p_itemno;
end if;
if p_type is not null then
v_type:=' and b.type='||p_ty