[UpdateDb]
select fnc_update_cyumonsyo(&12, '{
  "dt_from":"&1"
, "dt_to":"&2"
, "den_no":"&3"
, "sir_cd":"&4"
, "hin_nm":"&5"
, "title":"&6"
, "ndt_from":"&8"
, "ndt_to":"&9"
, "cond_cyokus":"&10"
, "print_flg":"&11"
, "hide_kingaku_flg":"&13"
}')

[selectRecords]
select
  w.*
from fnc_query_cyumonsyo(&12, '{}') w

[SelectLogo]
select 
	koumoku2 as image_cd
	, koumoku3 as logo_row
	, koumoku4 as logo_col
from m_hanyo
where 1=1
and mst_kbn = '99' 
and han_cd = 'logo-r0040' 
and han_name = '1'

[SelectImage]
select 
	file_image
from m_image
where image_cd = '&1'

[SelectMeisaiType]
select * from fnc_query_basr004a_meisai('{
  "disc_per_mode":"&1"
, "hin_cd_mode":"&2"
, "hinnm_2line":"&3"
, "l_layout":"&4"
, "sir_su_dec":"&5"
, "no_irisu_mode":"&6"
}')


