#-----------------------------------------------------------
#--業務規制時更新電文(CC_T_WKSIJ_UPD_DNBN-CC_DELETE_001)
#-----------------------------------------------------------

--KEY:CC_DELETE_001

DELETE FROM CC_T_WKSIJ_UPD_DNBN
WHERE (DENBUN_TRKM_STAT_CD = '02'
OR DENBUN_TRKM_STAT_CD = '04')
AND UPD_DTM < ?

#-

#-----------------------------------------------------------
#--業務規制時更新電文(CC_T_WKSIJ_UPD_DNBN-CC_SELECT_001)
#-----------------------------------------------------------

--KEY:CC_SELECT_001

SELECT 
WKSIJ_UPD_DNBN_NO,
SVC_ID,
PARAM_MAP,
INPUT_DATA_MAP,
ADD_OPEACNT,
ADD_TRN_ID
FROM CC_T_WKSIJ_UPD_DNBN
WHERE DENBUN_TRKM_STAT_CD = '01' 
AND MK_FLG = '0'
ORDER BY WKSIJ_UPD_DNBN_NO

#-

#-----------------------------------------------------------
#--業務規制時更新電文(CC_T_WKSIJ_UPD_DNBN-CC_SELECT_002)
#-----------------------------------------------------------

--KEY:CC_SELECT_002

SELECT
WKSIJ_UPD_DNBN_NO,
SVC_ID,
PARAM_MAP,
INPUT_DATA_MAP,
ERR_OUTPUT_DATA_MAP,
ADD_OPEACNT,
ADD_TRN_ID
FROM CC_T_WKSIJ_UPD_DNBN
WHERE WKSIJ_UPD_DNBN_NO = ?
AND DENBUN_TRKM_STAT_CD = '03'
AND MK_FLG = '0'

#-

#-----------------------------------------------------------
#--業務規制時更新電文(CC_T_WKSIJ_UPD_DNBN-CC_UPDATE_001)
#-----------------------------------------------------------

--KEY:CC_UPDATE_001

UPDATE CC_T_WKSIJ_UPD_DNBN
SET DENBUN_TRKM_STAT_CD = ?,
ERR_OUTPUT_DATA_MAP = ?,
UPD_DTM = ?,
UPD_OPEACNT = ?,
UPD_UNYO_YMD = 'UPD_UNYO',
UPD_TRN_ID   = 'UPD_TRN'
WHERE WKSIJ_UPD_DNBN_NO = ?

#-

#-----------------------------------------------------------
#--業務規制時更新電文(CC_T_WKSIJ_UPD_DNBN-CC_UPDATE_002)
#-----------------------------------------------------------

--KEY:CC_UPDATE_002

UPDATE CC_T_WKSIJ_UPD_DNBN
SET DENBUN_TRKM_STAT_CD = ?,
UPD_DTM = ?,
UPD_OPEACNT = ?,
UPD_UNYO_YMD = 'UPD_UNYO',
UPD_TRN_ID   = 'UPD_TRN'
WHERE WKSIJ_UPD_DNBN_NO = ?

#-

#-----------------------------------------------------------
#--業務規制時更新電文(CC_T_WKSIJ_UPD_DNBN-CC_UPDATE_003)
#-----------------------------------------------------------

--KEY:CC_UPDATE_003

UPDATE CC_T_WKSIJ_UPD_DNBN
SET 
PARAM_MAP = ?,
INPUT_DATA_MAP = ?,
UPD_DTM = ?,
UPD_OPEACNT = ?,
UPD_UNYO_YMD = 'UPD_UNYO',
UPD_TRN_ID   = 'UPD_TRN'
WHERE WKSIJ_UPD_DNBN_NO = ?

#-