[deleteWork]
delete from w_basv9930
where s_id = :s_id;

[insertWork]
delete from w_basv9930 where order_id = ':order_id' and dtl_no = :dtl_no;

insert into w_basv9930 (
  s_id,
	syori_ymd,
	order_id,
	dtl_no,
	user_id,
	chrg_id,
	ovrss_flg,
	order_stts,
	crdt_stts,
	scsv_stts,
	inqry_stts,
	pay_type,
	trn_id,
	item_price,
	net_weight,
	order_price,
	tax_rate,
	tax_price,
	pstg_price,
	cod_price,
	total_price,
	fee_expns,
	dlvry_hope,
	dlvry_time,
	order_date,
	dspth_date,
	dlvry_mthd,
	money_date,
	invc_code,
	total_weight,
	lngg_code,
	user_name,
	zip_code,
	cntry_code,
	cntry_name,
	state_id,
	state_name,
	address1,
	address2,
	address3,
	tel,
	y_memo,
	o_memo,
	o_a_memo,
	dtl_prdct_id,
	dtl_optn_flg,
	dtl_prdct_shape,
	dtl_mtrc_cnt,
	dtl_prdct_name,
	dtl_optn_name,
	dtl_color_name,
	dtl_size_name,
	dtl_a_prdct_name,
	dtl_a_optn_name,
	dtl_a_color_name,
	dtl_a_size_name,
	dtl_c_prdct_name,
	dtl_c_optn_name,
	dtl_c_color_name,
	dtl_c_size_name,
	dtl_unit_price,
	dtl_fr_pstg_flg,
	dtl_measure_flg,
	dtl_measure_unit,
	dtl_dscnt_src_flg,
	dtl_sale_flg,
	dtl_stock_flg,
	dtl_unit_weight,
	dtl_sale_weight,
	dtl_order_num,
	dtl_net_weight,
	dtl_qty,
	dtl_price,
	dtl_dscnt_rate,
	dtl_attin_price,
	dtl_attin_weight,
	dtl_a_memo,
	dtl_prdct_code,
	dtl_color_code,
	dtl_prdct_kind,
	usr_mail_address,
	usr_pass_wd,
	usr_user_type,
	usr_enrll_stts,
	usr_aplctn_date,
	usr_pay_type,
	usr_money_date,
	usr_enrll_date,
	usr_exprtn_date,
	usr_lngg_code,
	usr_user_name,
	usr_kana_name,
	usr_zip_code,
	usr_cntry_code,
	usr_cntry_name,
	usr_state_id,
	usr_state_name,
	usr_address1,
	usr_address2,
	usr_address3,
	usr_tel,
	usr_fax,
	usr_brth_month,
	usr_a_memo,
	usr_blcklst_stts,
	usr_mail_ng_flg,
	usr_mail_err_flg,
	usr_web_ragist_flg,
	usr_ragist_date,
	usr_tpass_wd,
	usr_old_type,
	usr_old_id,
	usr_old_day,
	del_flg,
	cre_id,
	cre_time,
	upd_id,
	upd_time
) values (
  :s_id,
	':syori_ymd',
	':order_id',
	:dtl_no,
	:user_id,
	:chrg_id,
	':ovrss_flg',
	':order_stts',
	':crdt_stts',
	':scsv_stts',
	':inqry_stts',
	':pay_type',
	':trn_id',
	:item_price,
	:net_weight,
	:order_price,
	:tax_rate,
	:tax_price,
	:pstg_price,
	:cod_price,
	:total_price,
	:fee_expns,
	':dlvry_hope',
	:dlvry_time,
	':order_date',
	':dspth_date',
	':dlvry_mthd',
	':money_date',
	':invc_code',
	:total_weight,
	':lngg_code',
	':user_name',
	':zip_code',
	':cntry_code',
	':cntry_name',
	':state_id',
	':state_name',
	':address1',
	':address2',
	':address3',
	':tel',
	':y_memo',
	':o_memo',
	':o_a_memo',
	':dtl_prdct_id',
	':dtl_optn_flg',
	':dtl_prdct_shape',
	':dtl_mtrc_cnt',
	':dtl_prdct_name',
	':dtl_optn_name',
	':dtl_color_name',
	':dtl_size_name',
	':dtl_a_prdct_name',
	':dtl_a_optn_name',
	':dtl_a_color_name',
	':dtl_a_size_name',
	':dtl_c_prdct_name',
	':dtl_c_optn_name',
	':dtl_c_color_name',
	':dtl_c_size_name',
	:dtl_unit_price,
	':dtl_fr_pstg_flg',
	':dtl_measure_flg',
	:dtl_measure_unit,
	':dtl_dscnt_src_flg',
	':dtl_sale_flg',
	':dtl_stock_flg',
	:dtl_unit_weight,
	:dtl_sale_weight,
	:dtl_order_num,
	:dtl_net_weight,
	:dtl_qty,
	:dtl_price,
	:dtl_dscnt_rate,
	:dtl_attin_price,
	:dtl_attin_weight,
	':dtl_a_memo',
	':dtl_prdct_code',
	':dtl_color_code',
	':dtl_prdct_kind',
	':usr_mail_address',
	':usr_pass_wd',
	:usr_user_type,
	:usr_enrll_stts,
	':usr_aplctn_date',
	':usr_pay_type',
	':usr_money_date',
	':usr_enrll_date',
	':usr_exprtn_date',
	':usr_lngg_code',
	':usr_user_name',
	':usr_kana_name',
	':usr_zip_code',
	':usr_cntry_code',
	':usr_cntry_name',
	:usr_state_id,
	':usr_state_name',
	':usr_address1',
	':usr_address2',
	':usr_address3',
	':usr_tel',
	':usr_fax',
	:usr_brth_month,
	':usr_a_memo',
	:usr_blcklst_stts,
	':usr_mail_ng_flg',
	':usr_mail_err_flg',
	':usr_web_ragist_flg',
	':usr_ragist_date',
	':usr_tpass_wd',
	:usr_old_type,
	:usr_old_id,
	':usr_old_day',
	0, --del_flg
	':login_id', --cre_id
	now(), --cre_time
	':login_id', --upd_id
	now() --upd_time
);

[doUpdate]
select fnc_update_basv9930(:s_id, ':login_id');

[getErr]
select
	l.den_no, wk.order_id, wk.usr_user_name as user_name
from w_basv9930 wk
left join t_other_link l on l.other_id = wk.order_id and l.link_kind = 'U'
left join t_uri u on l.den_no = u.den_no
where wk.err_flg = 1
and wk.s_id = :s_id
and u.del_flg <> 1
group by l.den_no, wk.order_id, wk.usr_user_name;

[getErr_hin]
select
	 case when wk.dtl_prdct_kind = 'Y' then wk.dtl_prdct_code || ' ' || wk.dtl_color_code else wk.dtl_prdct_code  end as hin_cd
	,case when wk.dtl_prdct_kind = 'Y' then wk.dtl_prdct_name || ' ' || wk.dtl_mtrc_cnt || ' ' || wk.dtl_color_name  else wk.dtl_prdct_name  end as hin_nm
from w_basv9930 wk
where wk.err_flg = 2
and wk.s_id = :s_id
group by case when wk.dtl_prdct_kind = 'Y' then wk.dtl_prdct_code || ' ' || wk.dtl_color_code else wk.dtl_prdct_code  end,
         case when wk.dtl_prdct_kind = 'Y' then wk.dtl_prdct_name || ' ' || wk.dtl_mtrc_cnt || ' ' || wk.dtl_color_name  else wk.dtl_prdct_name  end ;

[deleteWork_k]
delete from w_basv0210 where s_id = :s_id;
delete from w_basv0210_m where s_id = :s_id;

[insertRecord_H]
insert into w_uri
(s_id, den_no, henpin_flg, prc_sts, input_ymd, syori_ymd, tan_cd, 
	tok_cd, tok_nm, tok_tan, payment_term_cd, payment_term, biko1, biko2, 
	zeinuki_gaku, zei_gaku, zeikomi_gaku, genka_gaku, pay_kbn, haiso_kbn, 
	syukka_flg, zaiko_flg, jucyu_flg, jucyu_no, nonyu_no, 
	nonyu_nm, nonyu_zip_no, nonyu_addr1, nonyu_addr2, nonyu_addr3, 
	nonyu_addr4, nonyu_tel_no, nonyu_fax_no, nonyu_tan, kazei_gaku, 
	soto_gaku, uchi_gaku, zei_kbn, nonyu_ymd, mitsu_kigen_ymd, 
	del_flg, cre_id, cre_time, upd_id, upd_time)
values(:s_id, :w_den_no, 0, '', ':w_input_ymd', ':w_syori_ymd', ':w_tan_cd', 
	':w_tok_cd', ':w_tok_nm', '', '', '', ':w_biko1', '', 
	0, 0, 0, 0, '', ':w_haiso_kbn', 
--	1, 1, 0, null, :w_nonyu_no, 
	1, 1, 0, null, null, --納入先のコード長すぎ
	':w_nonyu_nm', '', '', '', '', 
	'', '', '', '', 0, 
	0, 0, '2', '', '', 
	0, 'basv9930', now(), 'basv9930', now());

[insertRecord_D]
insert into w_uri_m
(s_id, den_no, row_no, hin_cd, hin_nm, suryo, tanka, kingaku, zaiko_flg, 
	genka_gaku, hosoku1, hosoku2, jucyu_no, jucyu_row_no, jucyu_su, uri_su, 
	tok_hacyu_no, nonyu_ymd, syuko_flg, getsu_ymd, size_l, size_w, size_h, 
	htanka, disc_per, meisai_biko, nuki_tanka, kazei_tanka, uchi_tanka, 
	kazei_gaku, zeinuki_gaku, uchi_gaku, zei_kbn, tani_suryo, bante, 
	kei_suryo, kei_jucyu_su, iko_key, 
	del_flg, cre_id, cre_time, upd_id, upd_time)
values(:s_id, :w_den_no, :w_row_no, ':w_hin_cd', ':w_hin_nm', :w_suryo, :w_tanka, :w_kingaku, 1, 
	:w_genka_gaku, ':w_hosoku1', '', null, null, null, null, 
	'', '', 1, '', null, null, null,
	:w_htanka, null, ':w_meisai_biko', :w_nuki_tanka, :w_kazei_tanka, 0, --:w_uchi_tanka?
	:w_kazei_gaku, :w_zeinuki_gaku, 0, ':w_zei_kbn', null, null, 
	null, null, null, 
	0, 'basv9930', now(), 'basv9930', now());


[func_upd_uri]
select fnc_update_w_uri(:s_id);