--- /dev/null
+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 = ?
+
+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 = ?
+declareMapping.insert=INSERT INTO ARCHIVE_BUDGET(ARCHIVE_NAME, IDCOLL, EXERCICE) VALUES(?, ?, ?)
+declareMapping.update=UPDATE ARCHIVE_BUDGET SET ARCHIVE_NAME = ? WHERE IDCOLL = ? AND EXERCICE = ?
+
+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