ITS_OP/VmsOprMain_XXXX/PLUGIN/VMSM800M/VMSM800MSRCF.h

//---------------------------------------------------------------------------

#ifndef VMSM800MSRCFH
#define VMSM800MSRCFH
//---------------------------------------------------------------------------

#if 0
    sQry = "MERGE INTO TB_VMS_FORM L                                        \r\n"
           "USING (SELECT :p01 AS VMS_FORM_ID,                              \r\n"
           "              :p02 AS VMS_TYPE_CD,                              \r\n"
           "              :p03 AS VMS_FORM_TYPE_CD,                         \r\n"
           "              :p04 AS VMS_FORM_NM,                              \r\n"
           "              :p05 AS VMS_FORM_EXPL,                            \r\n"
           "              :p06 AS VMS_FORM_BCKG_HUE_CD,                     \r\n"
           "              :p07 AS VMS_MSG_DSPL_DRCT_CD,                     \r\n"
           "              :p08 AS VMS_MSG_DSPL_MTHD_CD,                     \r\n"
           "              :p09 AS VMS_FORM_IMAG                             \r\n"
           "         FROM DUAL) M                                           \r\n"
           "        ON (L.VMS_FORM_ID = M.VMS_FORM_ID)                      \r\n"
           "WHEN MATCHED                                                    \r\n"
           "THEN                                                            \r\n"
           "   UPDATE SET L.VMS_FORM_NM          = M.VMS_FORM_NM,           \r\n"
           "              L.VMS_FORM_EXPL        = M.VMS_FORM_EXPL,         \r\n"
           "              L.VMS_FORM_BCKG_HUE_CD = M.VMS_FORM_BCKG_HUE_CD,  \r\n"
           "              L.VMS_MSG_DSPL_DRCT_CD = M.VMS_MSG_DSPL_DRCT_CD,  \r\n"
           "              L.VMS_MSG_DSPL_MTHD_CD = M.VMS_MSG_DSPL_MTHD_CD,  \r\n"
           "              L.VMS_FORM_IMAG        = M.VMS_FORM_IMAG          \r\n"
           "WHEN NOT MATCHED                                                \r\n"
           "THEN                                                            \r\n"
           "   INSERT (VMS_FORM_ID,                                         \r\n"
           "           VMS_TYPE_CD,                                         \r\n"
           "           VMS_FORM_TYPE_CD,                                    \r\n"
           "           VMS_FORM_NM,                                         \r\n"
           "           VMS_FORM_EXPL,                                       \r\n"
           "           VMS_FORM_BCKG_HUE_CD,                                \r\n"
           "           VMS_MSG_DSPL_DRCT_CD,                                \r\n"
           "           VMS_MSG_DSPL_MTHD_CD,                                \r\n"
           "           VMS_FORM_IMAG )                                      \r\n"
           "   VALUES (M.VMS_FORM_ID,                                       \r\n"
           "           M.VMS_TYPE_CD,                                       \r\n"
           "           M.VMS_FORM_TYPE_CD,                                  \r\n"
           "           M.VMS_FORM_NM,                                       \r\n"
           "           M.VMS_FORM_EXPL,                                     \r\n"
           "           M.VMS_FORM_BCKG_HUE_CD,                              \r\n"
           "           M.VMS_MSG_DSPL_DRCT_CD,                              \r\n"
           "           M.VMS_MSG_DSPL_MTHD_CD,                              \r\n"
           "           M.VMS_FORM_IMAG )                                    \r\n";
#endif

#endif