[loadOriginal]
select fnc_load_basv3110(:s_id, :shiji_no, ':login_id')

[updateOriginal]
select fnc_update_basv3110(:s_id)

[deleteOriginal]
delete from w_basv3110 where s_id = :s_id;
delete from w_basv3110_m where s_id = :s_id;
delete from w_basv3110_shiyou where s_id = :s_id;

[doDelete]
select fnc_delete_basv3110(:shiji_no, ':login_id')

[loadNewKey]
select shiji_no as w_new_den_no
from w_basv3110
where s_id = :s_id

[loadJucyu]
select
  um.jucyu_su as suryo
, uh.tan_cd as eigyou_tan_cd
, um.nonyu_ymd
, uh.tok_cd
, uh.tok_nm
, um.hin_cd
, um.hin_nm
, um.jucyu_su
, um.tanka
, um.kingaku
, um.size_l
, um.size_w
, um.size_h
from t_uri_m um
left join t_uri uh on (uh.den_no = um.den_no)
where um.den_no = :jucyu_no
and um.row_no = :jucyu_row_no



