-createImportJob=INSERT INTO IMPORT_JOBS(ARCHIVE_NAME, EXERCICE, USER_LOGIN, DATE_DEMANDE, IMPORT_STATUS, IMPORT_SCHEME, DATE_MESSAGE, DATE_RAPPEL, DATE_CONFIRM) VALUES (DEFAULT, ?, ?, ?, SYSDATE, 0, ?, NULL, NULL, NULL)
-
getParameterValue=SELECT PARAM_VALUE FROM PARAMETERS WHERE PARAM_NAME = ?
+setParameterValue.exists=SELECT 1 FROM PARAMETERS WHERE PARAM_NAME = ?
+setParameterValue.update=UPDATE PARAMETERS SET PARAM_VALUE = ? WHERE PARAM_NAME = ?
+setParameterValue.insert=INSERT INTO PARAMETERS(PARAM_NAME, PARAM_VALUE) VALUES (?, ?)
+
isAlreadyImportingArchive=SELECT IMPORT_ID FROM IMPORT_JOBS WHERE ARCHIVE_NAME=? AND EXERCICE=? AND IMPORT_STATUS IN (0, 1)
declareMapping.exists=SELECT 1 FROM ARCHIVE_BUDGET WHERE IDCOLL = ? AND EXERCICE = ? AND ARCHIVE_NAME = ?
updateArchiveStatus=UPDATE IMPORT_JOBS SET IMPORT_STATUS=? WHERE IMPORT_ID=?
-getArchiveToImport=SELECT IMPORT_ID, ARCHIVE_NAME, EXERCICE, USER_LOGIN, IMPORT_SCHEME FROM IMPORT_JOBS WHERE IMPORT_STATUS=? ORDER BY DATE_DEMANDE ASC
\ No newline at end of file
+getArchiveToImport=SELECT IMPORT_ID, ARCHIVE_NAME, EXERCICE, USER_LOGIN, IMPORT_SCHEME FROM IMPORT_JOBS WHERE IMPORT_STATUS=? ORDER BY DATE_DEMANDE ASC
+