-- ========== 데이터 초기화 ========== -- 단속 파일 삭제 SELECT @thisDay := '2025%'; DELETE FROM TB_ATCH_FILE WHERE REG_DT LIKE @thisDay; DELETE FROM TB_CNTC_SNDNG_DETAIL WHERE REGIST_DT LIKE @thisDay; DELETE FROM TB_CNTC_SNDNG_MASTR WHERE REGIST_DT LIKE @thisDay; DELETE FROM TB_CNTC_SNDNG_RESULT WHERE REGIST_DT LIKE @thisDay; DELETE FROM TB_CRDN WHERE REG_DT LIKE @thisDay; DELETE FROM TB_CRDN_ADI WHERE REG_DT LIKE @thisDay; DELETE FROM TB_CRDN_FILE_LINK WHERE REG_DT LIKE @thisDay; DELETE FROM TB_CRDN_PAYER_ADDR_HSTRY WHERE REG_DT LIKE @thisDay; DELETE FROM TB_CRDN_PAYER_HSTRY WHERE REG_DT LIKE @thisDay; DELETE FROM TB_CRDN_RE_REG WHERE REG_DT LIKE @thisDay; DELETE FROM TB_CRDN_STTS_HSTRY WHERE REG_DT LIKE @thisDay; DELETE FROM TB_FILE WHERE REG_DT LIKE @thisDay; DELETE FROM TB_FILE_MOSC WHERE REG_DT LIKE @thisDay; DELETE FROM TB_LEVY WHERE REG_DT LIKE @thisDay; DELETE FROM TB_LEVY_EXCL WHERE REG_DT LIKE @thisDay; DELETE FROM TB_CAR_BSC_MTTR WHERE REG_DT LIKE @thisDay; DELETE FROM TB_PAYER WHERE REG_DT LIKE @thisDay; DELETE FROM TB_PAYER_ADDR WHERE REG_DT LIKE @thisDay; DELETE FROM TB_PAYER_HSTRY WHERE REG_DT LIKE @thisDay; DELETE FROM TB_PAYER_ORG WHERE REG_DT LIKE @thisDay; DELETE FROM TB_SNDNG_HSTRY WHERE REG_DT LIKE @thisDay; DELETE FROM TB_SNDNG_DTL WHERE REG_DT LIKE @thisDay; DELETE FROM TB_SNDNG WHERE REG_DT LIKE @thisDay; DELETE FROM TB_SYS_LOG WHERE REG_DT LIKE @thisDay; COMMIT; -- ============================ UPDATE TB_AMT SET TASK_SE_CD = 'RVS' WHERE TASK_SE_CD = 'PVS'; UPDATE TB_CNTC_SNDNG_MASTR SET FFNLG_CODE = 'RVS' WHERE FFNLG_CODE = 'PVS'; UPDATE TB_CNTC_SNDNG_DETAIL SET FFNLG_CODE = 'RVS' WHERE FFNLG_CODE = 'PVS'; UPDATE TB_CRDN SET TASK_SE_CD = 'RVS' WHERE TASK_SE_CD = 'PVS'; UPDATE TB_CRDN_FILE_LAYOUT SET TASK_SE_CD = 'RVS' WHERE TASK_SE_CD = 'PVS'; UPDATE TB_CVLCPT_ANS_WORDS SET TASK_SE_CD = 'RVS' WHERE TASK_SE_CD = 'PVS'; UPDATE TB_CVLCPT_BSC_WORDS SET TASK_SE_CD = 'RVS' WHERE TASK_SE_CD = 'PVS'; UPDATE TB_CVLCPT_DSCSN SET TASK_SE_CD = 'RVS' WHERE TASK_SE_CD = 'PVS'; UPDATE TB_EPOST_GDNTC SET TASK_SE_CD = 'RVS' WHERE TASK_SE_CD = 'PVS'; UPDATE TB_EPOST_RG_NO SET TASK_SE_CD = 'RVS' WHERE TASK_SE_CD = 'PVS'; UPDATE TB_EXTR_BSC_STNG SET TASK_SE_CD = 'RVS' WHERE TASK_SE_CD = 'PVS'; UPDATE TB_EXTR_FORM_STNG SET TASK_SE_CD = 'RVS' WHERE TASK_SE_CD = 'PVS'; UPDATE TB_FIN_SYS_FTP SET TASK_SE_CD = 'RVS' WHERE TASK_SE_CD = 'PVS'; UPDATE TB_LEVY SET TASK_SE_CD = 'RVS' WHERE TASK_SE_CD = 'PVS'; UPDATE TB_LSCT SET TASK_SE_CD = 'RVS' WHERE TASK_SE_CD = 'PVS'; UPDATE TB_LSCT_MPNG SET TASK_SE_CD = 'RVS' WHERE TASK_SE_CD = 'PVS'; UPDATE TB_NIS_INDIV_A01 SET TASK_SE_CD = 'RVS' WHERE TASK_SE_CD = 'PVS'; UPDATE TB_NIS_INDIV_A03 SET TASK_SE_CD = 'RVS' WHERE TASK_SE_CD = 'PVS'; UPDATE TB_NIS_INDIV_B01 SET TASK_SE_CD = 'RVS' WHERE TASK_SE_CD = 'PVS'; UPDATE TB_NIS_INDIV_C01 SET TASK_SE_CD = 'RVS' WHERE TASK_SE_CD = 'PVS'; UPDATE TB_NIS_INDIV_D01 SET TASK_SE_CD = 'RVS' WHERE TASK_SE_CD = 'PVS'; UPDATE TB_NIS_INDIV_D02 SET TASK_SE_CD = 'RVS' WHERE TASK_SE_CD = 'PVS'; UPDATE TB_NIS_SPCL_B01 SET TASK_SE_CD = 'RVS' WHERE TASK_SE_CD = 'PVS'; UPDATE TB_NIS_SPCL_B02 SET TASK_SE_CD = 'RVS' WHERE TASK_SE_CD = 'PVS'; UPDATE TB_NIS_SPCL_B03 SET TASK_SE_CD = 'RVS' WHERE TASK_SE_CD = 'PVS'; UPDATE TB_NIS_SPCL_B04 SET TASK_SE_CD = 'RVS' WHERE TASK_SE_CD = 'PVS'; UPDATE TB_NIS_SPCL_B05 SET TASK_SE_CD = 'RVS' WHERE TASK_SE_CD = 'PVS'; UPDATE TB_NIS_SPCL_B06 SET TASK_SE_CD = 'RVS' WHERE TASK_SE_CD = 'PVS'; UPDATE TB_NIS_SPCL_B07 SET TASK_SE_CD = 'RVS' WHERE TASK_SE_CD = 'PVS'; UPDATE TB_NIS_SPCL_B08 SET TASK_SE_CD = 'RVS' WHERE TASK_SE_CD = 'PVS'; UPDATE TB_NIS_SPCL_B09 SET TASK_SE_CD = 'RVS' WHERE TASK_SE_CD = 'PVS'; UPDATE TB_NIS_SPCL_B10 SET TASK_SE_CD = 'RVS' WHERE TASK_SE_CD = 'PVS'; UPDATE TB_NIS_SPCL_B11 SET TASK_SE_CD = 'RVS' WHERE TASK_SE_CD = 'PVS'; UPDATE TB_NIS_SPCL_B12 SET TASK_SE_CD = 'RVS' WHERE TASK_SE_CD = 'PVS'; UPDATE TB_NIS_SPCL_B13 SET TASK_SE_CD = 'RVS' WHERE TASK_SE_CD = 'PVS'; UPDATE TB_NIS_SPCL_B14 SET TASK_SE_CD = 'RVS' WHERE TASK_SE_CD = 'PVS'; UPDATE TB_NIS_SPCL_B15 SET TASK_SE_CD = 'RVS' WHERE TASK_SE_CD = 'PVS'; UPDATE TB_NIS_SPCL_B16 SET TASK_SE_CD = 'RVS' WHERE TASK_SE_CD = 'PVS'; UPDATE TB_OPNN_DLBR_MBR SET TASK_SE_CD = 'RVS' WHERE TASK_SE_CD = 'PVS'; UPDATE TB_OTPT_BSC_STNG SET TASK_SE_CD = 'RVS' WHERE TASK_SE_CD = 'PVS'; UPDATE TB_OTPT_FORM_STNG SET TASK_SE_CD = 'RVS' WHERE TASK_SE_CD = 'PVS'; UPDATE TB_OUTSOURCING_FORM_STNG SET TASK_SE_CD = 'RVS' WHERE TASK_SE_CD = 'PVS'; UPDATE TB_RCVMT SET TASK_SE_CD = 'RVS' WHERE TASK_SE_CD = 'PVS'; UPDATE TB_SAEOL_CVLCPT_INDIV_DMND SET TASK_SE_CD = 'RVS' WHERE TASK_SE_CD = 'PVS'; UPDATE TB_SNDNG SET TASK_SE_CD = 'RVS' WHERE TASK_SE_CD = 'PVS'; UPDATE TB_SVBTC SET TASK_SE_CD = 'RVS' WHERE TASK_SE_CD = 'PVS'; UPDATE TB_SYS_ALRM SET TASK_SE_CD = 'RVS' WHERE TASK_SE_CD = 'PVS'; UPDATE TB_TASK SET TASK_SE_CD = 'RVS' WHERE TASK_SE_CD = 'PVS'; UPDATE TB_TASK_MTCHG SET TASK_SE_CD = 'RVS' WHERE TASK_SE_CD = 'PVS'; UPDATE TB_TEAM SET TASK_SE_CD = 'RVS' WHERE TASK_SE_CD = 'PVS'; UPDATE TB_VLTN SET TASK_SE_CD = 'RVS' WHERE TASK_SE_CD = 'PVS'; UPDATE TB_CMN_CODE SET CODE = 'PVS' WHERE CODE = 'RVS'; UPDATE TB_GRP_ACTION SET ACTION = REPLACE(ACTION, 'PVS', 'RVS') WHERE ACTION LIKE '%PVS%'; UPDATE TB_AUTHORITY SET AUTH_ID = REPLACE(AUTH_ID, 'PVS', 'RVS') WHERE AUTH_ID LIKE '%PVS%'; UPDATE TB_AUTH_ACTION SET AUTH_ID = REPLACE(AUTH_ID, 'PVS', 'RVS') WHERE AUTH_ID LIKE '%PVS%'; UPDATE TB_AUTH_USER SET AUTH_ID = REPLACE(AUTH_ID, 'PVS', 'RVS') WHERE AUTH_ID LIKE '%PVS%'; INSERT INTO TB_ACTION_GRP (GRP_ID, GRP_NM, REG_DT) SELECT GRP_ID, GRP_NM, NOW FROM ( SELECT 'fileActions' GRP_ID, '파일' GRP_NM FROM DUAL UNION SELECT 'fileLayoutActions' GRP_ID, '장비단속 레이아웃 설정' GRP_NM FROM DUAL UNION SELECT 'inspectionActions' GRP_ID, '단속자료 검사' GRP_NM FROM DUAL UNION SELECT 'tagInfoActions' GRP_ID, '표지정보 미확인 자료' GRP_NM FROM DUAL UNION SELECT 'dansokRegActions' GRP_ID, '단속자료 등록' GRP_NM FROM DUAL UNION SELECT 'dansokActions' GRP_ID, '단속' GRP_NM FROM DUAL UNION SELECT 'teamActions' GRP_ID, '단속팀' GRP_NM FROM DUAL UNION SELECT 'exemptionActions' GRP_ID, '면제차량' GRP_NM FROM DUAL UNION SELECT 'minwonRegActions' GRP_ID, '민원접수 자료' GRP_NM FROM DUAL UNION SELECT 'minwonAnswerActions' GRP_ID, '민원답변 대상자료' GRP_NM FROM DUAL UNION SELECT 'minwonActions' GRP_ID, '민원' GRP_NM FROM DUAL UNION SELECT 'minwonIndivActions' GRP_ID, '민원 개별 등록' GRP_NM FROM DUAL UNION SELECT 'answerTextActions' GRP_ID, '민원신고 답변문구' GRP_NM FROM DUAL UNION SELECT 'gyedoTextActions' GRP_ID, '계도문 문구' GRP_NM FROM DUAL UNION SELECT 'epostRegActions' GRP_ID, '전자우편 접수' GRP_NM FROM DUAL UNION SELECT 'epostGuidanceActions' GRP_ID, '전자우편 안내문' GRP_NM FROM DUAL UNION SELECT 'exclusionActions' GRP_ID, '부과제외' GRP_NM FROM DUAL UNION SELECT 'opinionActions' GRP_ID, '의견제출' GRP_NM FROM DUAL UNION SELECT 'dansokReregActions' GRP_ID, '단속 재등록' GRP_NM FROM DUAL UNION SELECT 'levyActions' GRP_ID, '부과/감경부과' GRP_NM FROM DUAL UNION SELECT 'reductionActions' GRP_ID, '과태료 감경' GRP_NM FROM DUAL UNION SELECT 'lntrisInterfaces' GRP_ID, '차세대 세외수입 연계' GRP_NM FROM DUAL UNION SELECT 'payerActions' GRP_ID, '납부자' GRP_NM FROM DUAL UNION SELECT 'receiptActions' GRP_ID, '수납대장' GRP_NM FROM DUAL UNION SELECT 'sendingActions' GRP_ID, '발송대장' GRP_NM FROM DUAL UNION SELECT 'integratedQueryActions' GRP_ID, '통합 조회' GRP_NM FROM DUAL UNION SELECT 'dansokOverviewActions' GRP_ID, '개별 총정보' GRP_NM FROM DUAL UNION SELECT 'videoActions' GRP_ID, '동영상 재생' GRP_NM FROM DUAL UNION SELECT 'minwonConsultingActions' GRP_ID, '민원상담' GRP_NM FROM DUAL UNION SELECT 'statActions' GRP_ID, '통계' GRP_NM FROM DUAL UNION SELECT 'announcementActions' GRP_ID, '공지사항' GRP_NM FROM DUAL UNION SELECT 'scheduleActions' GRP_ID, '일정' GRP_NM FROM DUAL ) A , (SELECT DATE_FORMAT(CURRENT_TIMESTAMP, '%Y%m%d%H%i%s') NOW FROM DUAL) B; INSERT INTO TB_GRP_ACTION (GRP_ID, ACTION, REG_DT, RGTR) SELECT GRP_ID, ACTION, NOW, RGTR FROM ( SELECT 'fileActions' GRP_ID, '/file/changeOrderCrdnImageFile.do' ACTION FROM DUAL UNION SELECT 'fileActions' GRP_ID, '/file/create.do' ACTION FROM DUAL UNION SELECT 'fileActions' GRP_ID, '/file/delete.do' ACTION FROM DUAL UNION SELECT 'fileActions' GRP_ID, '/file/deleteCrdnImageFile.do' ACTION FROM DUAL UNION SELECT 'fileActions' GRP_ID, '/file/deleteOf.do' ACTION FROM DUAL UNION SELECT 'fileActions' GRP_ID, '/file/download.do' ACTION FROM DUAL UNION SELECT 'fileActions' GRP_ID, '/file/downloadMenual.do' ACTION FROM DUAL UNION SELECT 'fileActions' GRP_ID, '/file/insertCrdnImageFile.do' ACTION FROM DUAL UNION SELECT 'fileActions' GRP_ID, '/file/list.do' ACTION FROM DUAL UNION SELECT 'fileActions' GRP_ID, '/file/remove.do' ACTION FROM DUAL UNION SELECT 'fileActions' GRP_ID, '/file/removeLinked.do' ACTION FROM DUAL UNION SELECT 'fileActions' GRP_ID, '/file/reorder.do' ACTION FROM DUAL UNION SELECT 'fileActions' GRP_ID, '/file/updateCrdnImageFile.do' ACTION FROM DUAL UNION SELECT 'fileActions' GRP_ID, '/file/uploadBeforeProcess.do' ACTION FROM DUAL UNION SELECT 'fileLayoutActions' GRP_ID, '/crdn/crdn01/010/main.do' ACTION FROM DUAL UNION SELECT 'fileLayoutActions' GRP_ID, '/crdn/crdn01/010/list.do' ACTION FROM DUAL UNION SELECT 'fileLayoutActions' GRP_ID, '/crdn/crdn01/020/info.do' ACTION FROM DUAL UNION SELECT 'fileLayoutActions' GRP_ID, '/crdn/crdn01/020/create.do' ACTION FROM DUAL UNION SELECT 'fileLayoutActions' GRP_ID, '/crdn/crdn01/020/update.do' ACTION FROM DUAL UNION SELECT 'fileLayoutActions' GRP_ID, '/crdn/crdn01/020/remove.do' ACTION FROM DUAL UNION SELECT 'inspectionActions' GRP_ID, '/crdn/crdn02/010/main.do' ACTION FROM DUAL UNION SELECT 'inspectionActions' GRP_ID, '/crdn/crdn02/020/list.do' ACTION FROM DUAL UNION SELECT 'inspectionActions' GRP_ID, '/crdn/crdn02/050/info.do' ACTION FROM DUAL UNION SELECT 'inspectionActions' GRP_ID, '/crdn/crdn02/050/update.do' ACTION FROM DUAL UNION SELECT 'tagInfoActions' GRP_ID, '/crdn/crdn03/010/main.do' ACTION FROM DUAL UNION SELECT 'tagInfoActions' GRP_ID, '/crdn/crdn03/030/list.do' ACTION FROM DUAL UNION SELECT 'tagInfoActions' GRP_ID, '/crdn/crdn03/030/update.do' ACTION FROM DUAL UNION SELECT 'dansokRegActions' GRP_ID, '/crdn/crdn05/010/main.do' ACTION FROM DUAL UNION SELECT 'dansokRegActions' GRP_ID, '/crdn/crdn05/010/list.do' ACTION FROM DUAL UNION SELECT 'dansokRegActions' GRP_ID, '/crdn/crdn05/020/list.do' ACTION FROM DUAL UNION SELECT 'dansokRegActions' GRP_ID, '/crdn/crdn05/020/create.do' ACTION FROM DUAL UNION SELECT 'dansokRegActions' GRP_ID, '/crdn/crdn05/020/info.do' ACTION FROM DUAL UNION SELECT 'dansokRegActions' GRP_ID, '/crdn/crdn05/020/importFileFromClient.do' ACTION FROM DUAL UNION SELECT 'dansokRegActions' GRP_ID, '/crdn/crdn05/020/importFileFromServer.do' ACTION FROM DUAL UNION SELECT 'dansokRegActions' GRP_ID, '/crdn/crdn05/020/remove.do' ACTION FROM DUAL UNION SELECT 'dansokRegActions' GRP_ID, '/crdn/crdn05/030/info.do' ACTION FROM DUAL UNION SELECT 'dansokRegActions' GRP_ID, '/crdn/crdn05/030/create.do' ACTION FROM DUAL UNION SELECT 'dansokActions' GRP_ID, '/crdn/crdn06/010/main.do' ACTION FROM DUAL UNION SELECT 'dansokActions' GRP_ID, '/crdn/crdn06/010/list.do' ACTION FROM DUAL UNION SELECT 'dansokActions' GRP_ID, '/crdn/crdn06/010/nocs.do' ACTION FROM DUAL UNION SELECT 'dansokActions' GRP_ID, '/crdn/crdn06/010/remove.do' ACTION FROM DUAL UNION SELECT 'dansokActions' GRP_ID, '/crdn/crdn06/010/removeCrdnPayer.do' ACTION FROM DUAL UNION SELECT 'dansokActions' GRP_ID, '/crdn/crdn06/020/info.do' ACTION FROM DUAL UNION SELECT 'dansokActions' GRP_ID, '/crdn/crdn06/020/update.do' ACTION FROM DUAL UNION SELECT 'dansokActions' GRP_ID, '/crdn/crdn06/030/info.do' ACTION FROM DUAL UNION SELECT 'dansokActions' GRP_ID, '/crdn/crdn06/030/update.do' ACTION FROM DUAL UNION SELECT 'dansokActions' GRP_ID, '/crdn/crdn06/fileList.do' ACTION FROM DUAL UNION SELECT 'dansokActions' GRP_ID, '/crdn/crdn06/insertCrdnImageFile.do' ACTION FROM DUAL UNION SELECT 'dansokActions' GRP_ID, '/crdn/crdn06/updateCrdnImageFile.do' ACTION FROM DUAL UNION SELECT 'dansokActions' GRP_ID, '/crdn/crdn06/changeOrderCrdnImageFile.do' ACTION FROM DUAL UNION SELECT 'dansokActions' GRP_ID, '/crdn/crdn06/deleteCrdnImageFile.do' ACTION FROM DUAL UNION SELECT 'teamActions' GRP_ID, '/crdn/crdn07/010/main.do' ACTION FROM DUAL UNION SELECT 'teamActions' GRP_ID, '/crdn/crdn07/010/list.do' ACTION FROM DUAL UNION SELECT 'teamActions' GRP_ID, '/crdn/crdn07/010/info.do' ACTION FROM DUAL UNION SELECT 'teamActions' GRP_ID, '/crdn/crdn07/010/save.do' ACTION FROM DUAL UNION SELECT 'teamActions' GRP_ID, '/crdn/crdn07/010/remove.do' ACTION FROM DUAL UNION SELECT 'teamActions' GRP_ID, '/crdn/crdn07/010/removedTeamList.do' ACTION FROM DUAL UNION SELECT 'exemptionActions' GRP_ID, '/crdn/crdn08/010/main.do' ACTION FROM DUAL UNION SELECT 'exemptionActions' GRP_ID, '/crdn/crdn08/010/list.do' ACTION FROM DUAL UNION SELECT 'exemptionActions' GRP_ID, '/crdn/crdn08/010/remove.do' ACTION FROM DUAL UNION SELECT 'exemptionActions' GRP_ID, '/crdn/crdn08/020/info.do' ACTION FROM DUAL UNION SELECT 'exemptionActions' GRP_ID, '/crdn/crdn08/020/create.do' ACTION FROM DUAL UNION SELECT 'exemptionActions' GRP_ID, '/crdn/crdn08/020/update.do' ACTION FROM DUAL UNION SELECT 'exemptionActions' GRP_ID, '/crdn/crdn08/030/list.do' ACTION FROM DUAL UNION SELECT 'minwonRegActions' GRP_ID, '/cvlc/cvlc01/010/main.do' ACTION FROM DUAL UNION SELECT 'minwonRegActions' GRP_ID, '/cvlc/cvlc01/010/list.do' ACTION FROM DUAL UNION SELECT 'minwonRegActions' GRP_ID, '/cvlc/cvlc01/010/remove.do' ACTION FROM DUAL UNION SELECT 'minwonRegActions' GRP_ID, '/cvlc/cvlc01/020/info.do' ACTION FROM DUAL UNION SELECT 'minwonRegActions' GRP_ID, '/cvlc/cvlc01/020/create.do' ACTION FROM DUAL UNION SELECT 'minwonRegActions' GRP_ID, '/cvlc/cvlc01/020/update.do' ACTION FROM DUAL UNION SELECT 'minwonRegActions' GRP_ID, '/cvlc/cvlc01/020/remove.do' ACTION FROM DUAL UNION SELECT 'minwonRegActions' GRP_ID, '/cvlc/cvlc01/050/info.do' ACTION FROM DUAL UNION SELECT 'minwonRegActions' GRP_ID, '/cvlc/cvlc01/050/makeFileFromHwpFormat.do' ACTION FROM DUAL UNION SELECT 'minwonAnswerActions' GRP_ID, '/cvlc/cvlc02/010/main.do' ACTION FROM DUAL UNION SELECT 'minwonAnswerActions' GRP_ID, '/cvlc/cvlc02/030/list.do' ACTION FROM DUAL UNION SELECT 'minwonAnswerActions' GRP_ID, '/cvlc/cvlc02/030/update.do' ACTION FROM DUAL UNION SELECT 'minwonAnswerActions' GRP_ID, '/cvlc/cvlc02/040/update.do' ACTION FROM DUAL UNION SELECT 'minwonAnswerActions' GRP_ID, '/cvlc/cvlc02/060/info.do' ACTION FROM DUAL UNION SELECT 'minwonAnswerActions' GRP_ID, '/cvlc/cvlc02/060/update.do' ACTION FROM DUAL UNION SELECT 'minwonActions' GRP_ID, '/cvlc/cvlc03/010/main.do' ACTION FROM DUAL UNION SELECT 'minwonActions' GRP_ID, '/cvlc/cvlc03/010/list.do' ACTION FROM DUAL UNION SELECT 'minwonIndivActions' GRP_ID, '/cvlc/cvlc04/010/main.do' ACTION FROM DUAL UNION SELECT 'minwonIndivActions' GRP_ID, '/cvlc/cvlc04/010/list.do' ACTION FROM DUAL UNION SELECT 'minwonIndivActions' GRP_ID, '/cvlc/cvlc04/010/create.do' ACTION FROM DUAL UNION SELECT 'minwonIndivActions' GRP_ID, '/cvlc/cvlc04/010/remove.do' ACTION FROM DUAL UNION SELECT 'answerTextActions' GRP_ID, '/cvlc/cvlc05/010/main.do' ACTION FROM DUAL UNION SELECT 'answerTextActions' GRP_ID, '/cvlc/cvlc05/010/info.do' ACTION FROM DUAL UNION SELECT 'answerTextActions' GRP_ID, '/cvlc/cvlc05/010/save.do' ACTION FROM DUAL UNION SELECT 'answerTextActions' GRP_ID, '/cvlc/cvlc05/010/remove.do' ACTION FROM DUAL UNION SELECT 'gyedoTextActions' GRP_ID, '/cvlc/cvlc06/010/main.do' ACTION FROM DUAL UNION SELECT 'gyedoTextActions' GRP_ID, '/cvlc/cvlc06/010/list.do' ACTION FROM DUAL UNION SELECT 'gyedoTextActions' GRP_ID, '/cvlc/cvlc06/010/save.do' ACTION FROM DUAL UNION SELECT 'epostRegActions' GRP_ID, '/epst/epst01/010/create.do' ACTION FROM DUAL UNION SELECT 'epostRegActions' GRP_ID, '/epst/epst01/010/update.do' ACTION FROM DUAL UNION SELECT 'epostRegActions' GRP_ID, '/epst/epst01/010/remove.do' ACTION FROM DUAL UNION SELECT 'epostGuidanceActions' GRP_ID, '/epst/epst02/010/main.do' ACTION FROM DUAL UNION SELECT 'epostGuidanceActions' GRP_ID, '/epst/epst02/010/list.do' ACTION FROM DUAL UNION SELECT 'epostGuidanceActions' GRP_ID, '/epst/epst02/020/create.do' ACTION FROM DUAL UNION SELECT 'epostGuidanceActions' GRP_ID, '/epst/epst02/010/remove.do' ACTION FROM DUAL UNION SELECT 'epostGuidanceActions' GRP_ID, '/epst/epst02/020/info.do' ACTION FROM DUAL UNION SELECT 'epostGuidanceActions' GRP_ID, '/epst/epst02/020/update.do' ACTION FROM DUAL UNION SELECT 'epostGuidanceActions' GRP_ID, '/epst/epst02/030/main.do' ACTION FROM DUAL UNION SELECT 'epostGuidanceActions' GRP_ID, '/epst/epst02/030/list.do' ACTION FROM DUAL UNION SELECT 'epostGuidanceActions' GRP_ID, '/epst/epst02/030/updateSttsCd.do' ACTION FROM DUAL UNION SELECT 'epostGuidanceActions' GRP_ID, '/epst/epst02/030/remove.do' ACTION FROM DUAL UNION SELECT 'epostGuidanceActions' GRP_ID, '/epst/epst02/040/list.do' ACTION FROM DUAL UNION SELECT 'epostGuidanceActions' GRP_ID, '/epst/epst02/040/info.do' ACTION FROM DUAL UNION SELECT 'epostGuidanceActions' GRP_ID, '/epst/epst02/050/main.do' ACTION FROM DUAL UNION SELECT 'epostGuidanceActions' GRP_ID, '/epst/epst02/050/list.do' ACTION FROM DUAL UNION SELECT 'epostGuidanceActions' GRP_ID, '/epst/epst02/050/sumAmt.do' ACTION FROM DUAL UNION SELECT 'exclusionActions' GRP_ID, '/excl/excl01/010/main.do' ACTION FROM DUAL UNION SELECT 'exclusionActions' GRP_ID, '/excl/excl01/010/list.do' ACTION FROM DUAL UNION SELECT 'exclusionActions' GRP_ID, '/excl/excl01/020/info.do' ACTION FROM DUAL UNION SELECT 'exclusionActions' GRP_ID, '/excl/excl01/020/create.do' ACTION FROM DUAL UNION SELECT 'exclusionActions' GRP_ID, '/excl/excl01/020/update.do' ACTION FROM DUAL UNION SELECT 'exclusionActions' GRP_ID, '/excl/excl01/010/remove.do' ACTION FROM DUAL UNION SELECT 'opinionActions' GRP_ID, '/excl/excl02/010/main.do' ACTION FROM DUAL UNION SELECT 'opinionActions' GRP_ID, '/excl/excl02/010/list.do' ACTION FROM DUAL UNION SELECT 'opinionActions' GRP_ID, '/excl/excl02/010/makeHwp.do' ACTION FROM DUAL UNION SELECT 'opinionActions' GRP_ID, '/excl/excl02/010/remove.do' ACTION FROM DUAL UNION SELECT 'opinionActions' GRP_ID, '/excl/excl02/020/info.do' ACTION FROM DUAL UNION SELECT 'opinionActions' GRP_ID, '/excl/excl02/020/create.do' ACTION FROM DUAL UNION SELECT 'opinionActions' GRP_ID, '/excl/excl02/020/update.do' ACTION FROM DUAL UNION SELECT 'opinionActions' GRP_ID, '/excl/excl02/030/info.do' ACTION FROM DUAL UNION SELECT 'opinionActions' GRP_ID, '/excl/excl02/040/create.do' ACTION FROM DUAL UNION SELECT 'opinionActions' GRP_ID, '/excl/excl02/030/update.do' ACTION FROM DUAL UNION SELECT 'opinionActions' GRP_ID, '/excl/excl02/040/info.do' ACTION FROM DUAL UNION SELECT 'opinionActions' GRP_ID, '/excl/excl02/040/update.do' ACTION FROM DUAL UNION SELECT 'dansokReregActions' GRP_ID, '/excl/excl03/010/main.do' ACTION FROM DUAL UNION SELECT 'dansokReregActions' GRP_ID, '/excl/excl03/010/list.do' ACTION FROM DUAL UNION SELECT 'dansokReregActions' GRP_ID, '/excl/excl03/010/create.do' ACTION FROM DUAL UNION SELECT 'dansokReregActions' GRP_ID, '/intf/fims/smg/petition/receive.do' ACTION FROM DUAL UNION SELECT 'levyActions' GRP_ID, '/levy/levy01/010/main.do' ACTION FROM DUAL UNION SELECT 'levyActions' GRP_ID, '/levy/levy01/010/list.do' ACTION FROM DUAL UNION SELECT 'levyActions' GRP_ID, '/levy/levy01/020/createRdctLevyList.do' ACTION FROM DUAL UNION SELECT 'levyActions' GRP_ID, '/levy/levy01/020/info.do' ACTION FROM DUAL UNION SELECT 'levyActions' GRP_ID, '/levy/levy01/050/main.do' ACTION FROM DUAL UNION SELECT 'levyActions' GRP_ID, '/levy/levy01/050/list.do' ACTION FROM DUAL UNION SELECT 'reductionActions' GRP_ID, '/levy/levy02/010/main.do' ACTION FROM DUAL UNION SELECT 'reductionActions' GRP_ID, '/levy/levy02/010/list.do' ACTION FROM DUAL UNION SELECT 'reductionActions' GRP_ID, '/levy/levy02/010/remove.do' ACTION FROM DUAL UNION SELECT 'reductionActions' GRP_ID, '/levy/levy02/010/removes.do' ACTION FROM DUAL UNION SELECT 'reductionActions' GRP_ID, '/levy/levy02/020/info.do' ACTION FROM DUAL UNION SELECT 'reductionActions' GRP_ID, '/levy/levy02/020/create.do' ACTION FROM DUAL UNION SELECT 'reductionActions' GRP_ID, '/levy/levy02/020/update.do' ACTION FROM DUAL UNION SELECT 'reductionActions' GRP_ID, '/link/fileProcess.do' ACTION FROM DUAL UNION SELECT 'lntrisInterfaces' GRP_ID, '/nxrp/nxrp01/010/createIndivA01.do' ACTION FROM DUAL UNION SELECT 'lntrisInterfaces' GRP_ID, '/nxrp/nxrp01/010/createIndivB01.do' ACTION FROM DUAL UNION SELECT 'lntrisInterfaces' GRP_ID, '/nxrp/nxrp01/010/createIndivC01.do' ACTION FROM DUAL UNION SELECT 'payerActions' GRP_ID, '/payer/main.do' ACTION FROM DUAL UNION SELECT 'payerActions' GRP_ID, '/payer/list.do' ACTION FROM DUAL UNION SELECT 'payerActions' GRP_ID, '/payer/info.do' ACTION FROM DUAL UNION SELECT 'payerActions' GRP_ID, '/payer/crdnPayerInfo.do' ACTION FROM DUAL UNION SELECT 'payerActions' GRP_ID, '/payer/getLastInfo.do' ACTION FROM DUAL UNION SELECT 'payerActions' GRP_ID, '/payer/getPayerHstrys.do' ACTION FROM DUAL UNION SELECT 'payerActions' GRP_ID, '/payer/vehicle.do' ACTION FROM DUAL UNION SELECT 'payerActions' GRP_ID, '/payer/create.do' ACTION FROM DUAL UNION SELECT 'payerActions' GRP_ID, '/payer/createCrdnPayer.do' ACTION FROM DUAL UNION SELECT 'payerActions' GRP_ID, '/payer/update.do' ACTION FROM DUAL UNION SELECT 'payerActions' GRP_ID, '/payer/remove.do' ACTION FROM DUAL UNION SELECT 'receiptActions' GRP_ID, '/rcvm/rcvm01/010/main.do' ACTION FROM DUAL UNION SELECT 'receiptActions' GRP_ID, '/rcvm/rcvm01/010/list.do' ACTION FROM DUAL UNION SELECT 'receiptActions' GRP_ID, '/rcvm/rcvm01/020/info.do' ACTION FROM DUAL UNION SELECT 'receiptActions' GRP_ID, '/rcvm/rcvm01/010/updateRcvmtRtrcn.do' ACTION FROM DUAL UNION SELECT 'receiptActions' GRP_ID, '/rcvm/rcvm01/020/create.do' ACTION FROM DUAL UNION SELECT 'receiptActions' GRP_ID, '/rcvm/rcvm01/010/remove.do' ACTION FROM DUAL UNION SELECT 'sendingActions' GRP_ID, '/sndb/sndb01/010/main.do' ACTION FROM DUAL UNION SELECT 'sendingActions' GRP_ID, '/sndb/sndb01/010/list.do' ACTION FROM DUAL UNION SELECT 'sendingActions' GRP_ID, '/sndb/sndb01/020/info.do' ACTION FROM DUAL UNION SELECT 'sendingActions' GRP_ID, '/sndb/sndb01/020/createList.do' ACTION FROM DUAL UNION SELECT 'sendingActions' GRP_ID, '/sndb/sndb01/030/main.do' ACTION FROM DUAL UNION SELECT 'sendingActions' GRP_ID, '/sndb/sndb01/030/list.do' ACTION FROM DUAL UNION SELECT 'sendingActions' GRP_ID, '/sndb/sndb01/040/list.do' ACTION FROM DUAL UNION SELECT 'sendingActions' GRP_ID, '/sndb/sndb01/040/info.do' ACTION FROM DUAL UNION SELECT 'sendingActions' GRP_ID, '/sndb/sndb01/050/main.do' ACTION FROM DUAL UNION SELECT 'sendingActions' GRP_ID, '/sndb/sndb01/050/list.do' ACTION FROM DUAL UNION SELECT 'sendingActions' GRP_ID, '/sndb/sndb01/060/info.do' ACTION FROM DUAL UNION SELECT 'sendingActions' GRP_ID, '/sndb/sndb01/060/createList.do' ACTION FROM DUAL UNION SELECT 'sendingActions' GRP_ID, '/sndb/sndb01/070/main.do' ACTION FROM DUAL UNION SELECT 'sendingActions' GRP_ID, '/sndb/sndb01/070/list.do' ACTION FROM DUAL UNION SELECT 'sendingActions' GRP_ID, '/sndb/sndb01/080/list.do' ACTION FROM DUAL UNION SELECT 'sendingActions' GRP_ID, '/sndb/sndb01/080/info.do' ACTION FROM DUAL UNION SELECT 'sendingActions' GRP_ID, '/sndb/sndb01/080/createSndbkList.do' ACTION FROM DUAL UNION SELECT 'sendingActions' GRP_ID, '/sndb/sndb01/080/createSndngLink.do' ACTION FROM DUAL UNION SELECT 'sendingActions' GRP_ID, '/sndb/sndb01/080/makeAdvntceOutsourcing.do' ACTION FROM DUAL UNION SELECT 'sendingActions' GRP_ID, '/sndb/sndb01/080/makeAdvntcePdf.do' ACTION FROM DUAL UNION SELECT 'sendingActions' GRP_ID, '/sndb/sndb01/090/main.do' ACTION FROM DUAL UNION SELECT 'sendingActions' GRP_ID, '/sndb/sndb01/090/list.do' ACTION FROM DUAL UNION SELECT 'sendingActions' GRP_ID, '/sndb/sndb01/100/info.do' ACTION FROM DUAL UNION SELECT 'sendingActions' GRP_ID, '/sndb/sndb01/100/createList.do' ACTION FROM DUAL UNION SELECT 'sendingActions' GRP_ID, '/sndb/sndb01/110/main.do' ACTION FROM DUAL UNION SELECT 'sendingActions' GRP_ID, '/sndb/sndb01/110/list.do' ACTION FROM DUAL UNION SELECT 'sendingActions' GRP_ID, '/sndb/sndb01/110/remove.do' ACTION FROM DUAL UNION SELECT 'sendingActions' GRP_ID, '/sndb/sndb01/120/list.do' ACTION FROM DUAL UNION SELECT 'sendingActions' GRP_ID, '/sndb/sndb01/120/info.do' ACTION FROM DUAL UNION SELECT 'sendingActions' GRP_ID, '/sndb/sndb01/220/main.do' ACTION FROM DUAL UNION SELECT 'sendingActions' GRP_ID, '/sndb/sndb01/220/list.do' ACTION FROM DUAL UNION SELECT 'sendingActions' GRP_ID, '/sndb/sndb01/220/remove.do' ACTION FROM DUAL UNION SELECT 'sendingActions' GRP_ID, '/sndb/sndb01/230/info.do' ACTION FROM DUAL UNION SELECT 'sendingActions' GRP_ID, '/sndb/sndb01/230/create.do' ACTION FROM DUAL UNION SELECT 'sendingActions' GRP_ID, '/sndb/sndb01/230/update.do' ACTION FROM DUAL UNION SELECT 'sendingActions' GRP_ID, '/sndb/sndb01/240/main.do' ACTION FROM DUAL UNION SELECT 'sendingActions' GRP_ID, '/sndb/sndb01/240/list.do' ACTION FROM DUAL UNION SELECT 'sendingActions' GRP_ID, '/sndb/sndb01/240/makeSvbtcHwp.do' ACTION FROM DUAL UNION SELECT 'sendingActions' GRP_ID, '/sndb/sndb01/240/remove.do' ACTION FROM DUAL UNION SELECT 'sendingActions' GRP_ID, '/sndb/sndb01/250/list.do' ACTION FROM DUAL UNION SELECT 'sendingActions' GRP_ID, '/sndb/sndb01/250/info.do' ACTION FROM DUAL UNION SELECT 'sendingActions' GRP_ID, '/sndb/sndb01/250/remove.do' ACTION FROM DUAL UNION SELECT 'sendingActions' GRP_ID, '/sndb/sndb01/260/info.do' ACTION FROM DUAL UNION SELECT 'sendingActions' GRP_ID, '/sndb/sndb01/260/create.do' ACTION FROM DUAL UNION SELECT 'sendingActions' GRP_ID, '/sndb/sndb01/260/update.do' ACTION FROM DUAL UNION SELECT 'sendingActions' GRP_ID, '/sndb/sndb01/991/nxrpA01List.do' ACTION FROM DUAL UNION SELECT 'sendingActions' GRP_ID, '/sndb/sndb01/991/nxrpA03List.do' ACTION FROM DUAL UNION SELECT 'sendingActions' GRP_ID, '/sndb/sndb01/991/nxrpB01List.do' ACTION FROM DUAL UNION SELECT 'integratedQueryActions' GRP_ID, '/sprt/sprt01/010/main.do' ACTION FROM DUAL UNION SELECT 'integratedQueryActions' GRP_ID, '/sprt/sprt01/010/list.do' ACTION FROM DUAL UNION SELECT 'integratedQueryActions' GRP_ID, '/sprt/sprt01/100/info.do' ACTION FROM DUAL UNION SELECT 'integratedQueryActions' GRP_ID, '/sprt/sprt01/100/update.do' ACTION FROM DUAL UNION SELECT 'integratedQueryActions' GRP_ID, '/sprt/sprt01/110/info.do' ACTION FROM DUAL UNION SELECT 'integratedQueryActions' GRP_ID, '/sprt/sprt01/110/makeCrdnConfirmFileFromHwpFormat.do' ACTION FROM DUAL UNION SELECT 'integratedQueryActions' GRP_ID, '/sprt/sprt01/110/makeCrdnListFileFromHwpFormat.do' ACTION FROM DUAL UNION SELECT 'integratedQueryActions' GRP_ID, '/sprt/sprt01/120/info.do' ACTION FROM DUAL UNION SELECT 'integratedQueryActions' GRP_ID, '/sprt/sprt01/120/makeReportOnClaimsFileFromHwpFormat.do' ACTION FROM DUAL UNION SELECT 'integratedQueryActions' GRP_ID, '/sprt/sprt01/120/makeRequestForDeliveryFileFromHwpFormat.do' ACTION FROM DUAL UNION SELECT 'integratedQueryActions' GRP_ID, '/sprt/sprt01/130/makeRcvmtConfirmFileFromHwpFormat.do' ACTION FROM DUAL UNION SELECT 'integratedQueryActions' GRP_ID, '/sprt/sprt01/140/info.do' ACTION FROM DUAL UNION SELECT 'integratedQueryActions' GRP_ID, '/sprt/sprt01/140/makeAdvntceOutsourcing.do' ACTION FROM DUAL UNION SELECT 'integratedQueryActions' GRP_ID, '/sprt/sprt01/140/makeAdvntcePdf.do' ACTION FROM DUAL UNION SELECT 'integratedQueryActions' GRP_ID, '/sprt/sprt01/150/info.do' ACTION FROM DUAL UNION SELECT 'integratedQueryActions' GRP_ID, '/sprt/sprt01/150/makeNhtOutsourcing.do' ACTION FROM DUAL UNION SELECT 'integratedQueryActions' GRP_ID, '/sprt/sprt01/150/makeNhtPdf.do' ACTION FROM DUAL UNION SELECT 'dansokOverviewActions' GRP_ID, '/sprt/sprt02/010/main.do' ACTION FROM DUAL UNION SELECT 'dansokOverviewActions' GRP_ID, '/sprt/sprt02/020/info.do' ACTION FROM DUAL UNION SELECT 'dansokOverviewActions' GRP_ID, '/sprt/sprt02/030/info.do' ACTION FROM DUAL UNION SELECT 'dansokOverviewActions' GRP_ID, '/sprt/sprt02/040/info.do' ACTION FROM DUAL UNION SELECT 'dansokOverviewActions' GRP_ID, '/sprt/sprt02/050/info.do' ACTION FROM DUAL UNION SELECT 'dansokOverviewActions' GRP_ID, '/sprt/sprt02/060/info.do' ACTION FROM DUAL UNION SELECT 'dansokOverviewActions' GRP_ID, '/sprt/sprt02/070/info.do' ACTION FROM DUAL UNION SELECT 'dansokOverviewActions' GRP_ID, '/sprt/sprt02/080/info.do' ACTION FROM DUAL UNION SELECT 'videoActions' GRP_ID, '/sprt/sprt03/010/main.do' ACTION FROM DUAL UNION SELECT 'videoActions' GRP_ID, '/sprt/sprt03/020/main.do' ACTION FROM DUAL UNION SELECT 'minwonConsultingActions' GRP_ID, '/sprt/sprt04/010/main.do' ACTION FROM DUAL UNION SELECT 'minwonConsultingActions' GRP_ID, '/sprt/sprt04/010/list.do' ACTION FROM DUAL UNION SELECT 'minwonConsultingActions' GRP_ID, '/sprt/sprt04/010/nocs.do' ACTION FROM DUAL UNION SELECT 'minwonConsultingActions' GRP_ID, '/sprt/sprt04/010/remove.do' ACTION FROM DUAL UNION SELECT 'minwonConsultingActions' GRP_ID, '/sprt/sprt04/010/removes.do' ACTION FROM DUAL UNION SELECT 'minwonConsultingActions' GRP_ID, '/sprt/sprt04/020/info.do' ACTION FROM DUAL UNION SELECT 'minwonConsultingActions' GRP_ID, '/sprt/sprt04/020/create.do' ACTION FROM DUAL UNION SELECT 'minwonConsultingActions' GRP_ID, '/sprt/sprt04/020/update.do' ACTION FROM DUAL UNION SELECT 'statActions' GRP_ID, '/stat/stat01/010/main.do' ACTION FROM DUAL UNION SELECT 'statActions' GRP_ID, '/stat/stat01/010/info.do' ACTION FROM DUAL UNION SELECT 'statActions' GRP_ID, '/stat/stat01/020/main.do' ACTION FROM DUAL UNION SELECT 'statActions' GRP_ID, '/stat/stat01/030/main.do' ACTION FROM DUAL UNION SELECT 'statActions' GRP_ID, '/stat/stat01/040/main.do' ACTION FROM DUAL UNION SELECT 'statActions' GRP_ID, '/stat/stat01/050/main.do' ACTION FROM DUAL UNION SELECT 'announcementActions' GRP_ID, '/mngt/mngt01/010/main.do' ACTION FROM DUAL UNION SELECT 'announcementActions' GRP_ID, '/mngt/mngt01/010/list.do' ACTION FROM DUAL UNION SELECT 'announcementActions' GRP_ID, '/mngt/mngt01/020/info.do' ACTION FROM DUAL UNION SELECT 'announcementActions' GRP_ID, '/mngt/mngt01/020/create.do' ACTION FROM DUAL UNION SELECT 'announcementActions' GRP_ID, '/mngt/mngt01/020/update.do' ACTION FROM DUAL UNION SELECT 'announcementActions' GRP_ID, '/mngt/mngt01/020/remove.do' ACTION FROM DUAL UNION SELECT 'scheduleActions' GRP_ID, '/mngt/mngt02/010/main.do' ACTION FROM DUAL UNION SELECT 'scheduleActions' GRP_ID, '/mngt/mngt02/010/list.do' ACTION FROM DUAL UNION SELECT 'scheduleActions' GRP_ID, '/mngt/mngt02/020/info.do' ACTION FROM DUAL UNION SELECT 'scheduleActions' GRP_ID, '/mngt/mngt02/020/create.do' ACTION FROM DUAL UNION SELECT 'scheduleActions' GRP_ID, '/mngt/mngt02/020/update.do' ACTION FROM DUAL UNION SELECT 'scheduleActions' GRP_ID, '/mngt/mngt02/020/remove.do' ACTION FROM DUAL ) A , (SELECT DATE_FORMAT(CURRENT_TIMESTAMP, '%Y%m%d%H%i%s') NOW , '0000000070' RGTR FROM DUAL ) B; COMMIT;