#-----------------------------------------------------------
#--住所適用日補正(ZM_T_AD_APLY_HOSEI-ZM_INSERT_001)
#--Insert文を実行する
#-----------------------------------------------------------

--KEY:ZM_INSERT_001

INSERT INTO ZM_T_AD_APLY_HOSEI(
AD_CD_KAMI5,
AD_CD_SHIMO6,
NEW_AD_CD_KAMI5,
NEW_AD_CD_SHIMO6,
TRN_YM,
AD_CHG_SBT_CD,
HOSEI_TG_YMD,
KOSHO_CHG_FLG,
PCD_CHG_FLG,
AD_TRKM_FLG,
ADD_DTM,
ADD_UNYO_YMD,
ADD_TRN_ID,
ADD_OPEACNT,
UPD_DTM,
UPD_UNYO_YMD,
UPD_TRN_ID,
UPD_OPEACNT,
DEL_DTM,
DEL_UNYO_YMD,
DEL_TRN_ID,
DEL_OPEACNT,
MK_FLG
) VALUES (
?,
?,
?,
?,
?,
?,
?,
?,
?,
?,
?,
'ADD_UNYO',
'ADD_TRN',
?,
?,
'UPD_UNYO',
'UPD_TRN',
?,
?,
null,
null,
?,
?
)

#-

#-----------------------------------------------------------
#--住所適用日補正(ZM_T_AD_APLY_HOSEI-ZM_SELECT_001)
#--Select文を実行する
#-----------------------------------------------------------

--KEY:ZM_SELECT_001

SELECT 
AD_CD_KAMI5
,AD_CD_SHIMO6
,NEW_AD_CD_KAMI5
,AD_CHG_SBT_CD
,KOSHO_CHG_FLG
,PCD_CHG_FLG
,HOSEI_TG_YMD
,TRN_YM
FROM ZM_T_AD_APLY_HOSEI
 WHERE MK_FLG = '0'
 AND AD_TRKM_FLG = '0'

#-

#-----------------------------------------------------------
#--住所適用日補正(ZM_T_AD_APLY_HOSEI-ZM_UPDATE_001)
#--Update文を実行する
#-----------------------------------------------------------

--KEY:ZM_UPDATE_001

UPDATE ZM_T_AD_APLY_HOSEI SET
AD_TRKM_FLG = ?,
APLY_TG_YMD = ?,
UPD_DTM = 'UPD_DTM',
UPD_UNYO_YMD = 'UPD_UNYO',
UPD_TRN_ID = 'UPD_TRN',
UPD_OPEACNT = 'UPD_OPE'
WHERE
AD_CD_KAMI5 = ? AND 
AD_CD_SHIMO6 = ? AND
TRN_YM = ?

#-