[lockSend]
select fnc_lock_send(':login_id')

[getLock]
select
  l.send_no
, s.send_param as fax_no
, s.doc_path
, s.send_page
, s.info_kind
, s.send_hoho
from t_sndlock l
inner join t_send s on (s.send_no = l.send_no)
where l.term_id = ':login_id'

[updateSts]
update t_send set
  send_sts = :send_sts
, port_no = :port_no
, send_time = now()
, upd_id = ':login_id'
, upd_time = now()
where send_no = :send_no
;
delete from t_sndlock where term_id = ':login_id'
;


