--- /dev/null
+checkTableIndexPatchExists=SELECT 1 FROM USER_TABLES WHERE TABLE_NAME='INDEX_PATCH'
+
+createTableIndexPatch=\
+ begin \
+ execute immediate 'CREATE TABLE INDEX_PATCH ( \
+ IND_ANNEE_GEST VARCHAR(2) not null, \
+ IND_TRI_GEST VARCHAR(1) not null, \
+ IND_COMPTABLE VARCHAR(6) not null, \
+ IND_IMPUTATION VARCHAR(1) not null, \
+ IND_MINISTERE VARCHAR(2) not null, \
+ IND_COMPTESPE VARCHAR(5) not null, \
+ IND_LOCALE VARCHAR(4) not null, \
+ IND_ANNEE_TRSP VARCHAR(2) not null, \
+ IND_TRI_TRSP VARCHAR(1) not null, \
+ IND_SECTION_BUDG VARCHAR(2), \
+ IND_CPTESPENAT VARCHAR(5) not null, \
+ IND_NATIONALE VARCHAR(6) \
+ )'; \
+ \
+ execute immediate 'CREATE INDEX IX_INDEX ON INDEX_PATCH(IND_ANNEE_GEST,IND_TRI_GEST,IND_COMPTABLE,IND_IMPUTATION,IND_MINISTERE,IND_LOCALE)'; \
+ end;
+
+request=\
+ SELECT edmn.COLLECTIVITE, edmn.BUDGET, edmn.DOC_ID \
+ FROM EDMN_ETAT edmn \
+ WHERE NOT EXISTS( \
+ SELECT 1 \
+ FROM EDMN_ETAT_LIASSES liasse \
+ WHERE edmn.COLLECTIVITE=liasse.COLLECTIVITE \
+ AND edmn.BUDGET=liasse.BUDGET \
+ AND edmn.DOC_ID=liasse.DOC_ID \
+ )
+
+requestCount=\
+ SELECT COUNT(*) FROM ( \
+ SELECT edmn.COLLECTIVITE, edmn.BUDGET, edmn.DOC_ID \
+ FROM EDMN_ETAT edmn \
+ WHERE NOT EXISTS( \
+ SELECT 1 \
+ FROM EDMN_ETAT_LIASSES liasse \
+ WHERE edmn.COLLECTIVITE=liasse.COLLECTIVITE \
+ AND edmn.BUDGET=liasse.BUDGET \
+ AND edmn.DOC_ID=liasse.DOC_ID \
+ ) \
+ )
+
+truncateTableIndexPatch=TRUNCATE TABLE INDEX_PATCH
+
+insertIndexPatch=\
+ INSERT INTO INDEX_PATCH ( \
+ IND_ANNEE_GEST, \
+ IND_TRI_GEST, \
+ IND_COMPTABLE, \
+ IND_IMPUTATION, \
+ IND_MINISTERE, \
+ IND_COMPTESPE, \
+ IND_LOCALE, \
+ IND_ANNEE_TRSP, \
+ IND_TRI_TRSP, \
+ IND_SECTION_BUDG, \
+ IND_CPTESPENAT, \
+ IND_NATIONALE \
+ ) VALUES (?,?,?,?,?,?,?,?,?,?,?,?)
+
+
+selectLiasseLocale=\
+ SELECT \
+ edmn.COMPTABLE, \
+ edmn.IMPUTATION, \
+ edmn.MINISTERE, \
+ edmn.ANNEE_BUDG, \
+ edmn.TRIMESTRE, \
+ edmn.NUM_LIASSE_DEB, \
+ edmn.NUM_LIASSE_FIN \
+ FROM EDMN_ETAT edmn \
+ WHERE edmn.COLLECTIVITE = ? \
+ AND edmn.BUDGET = ? \
+ AND edmn.DOC_ID = ?
+
+selectIndexPatch=\
+ SELECT \
+ IND_ANNEE_GEST, \
+ IND_TRI_GEST, \
+ IND_COMPTABLE, \
+ IND_IMPUTATION, \
+ IND_MINISTERE, \
+ IND_COMPTESPE, \
+ IND_LOCALE, \
+ IND_ANNEE_TRSP, \
+ IND_TRI_TRSP, \
+ IND_SECTION_BUDG, \
+ IND_CPTESPENAT, \
+ IND_NATIONALE \
+ FROM INDEX_PATCH \
+ WHERE IND_ANNEE_GEST = ? \
+ AND IND_TRI_GEST = ? \
+ AND IND_COMPTABLE = ? \
+ AND IND_IMPUTATION=? \
+ AND IND_MINISTERE=? \
+ AND IND_LOCALE IN {:liasse} \
+ ORDER BY IND_LOCALE
+
+insertLiasse=INSERT INTO EDMN_ETAT_LIASSES (COLLECTIVITE,BUDGET,DOC_ID,NUM_LIASSE,ANNEE_GESTION) VALUES(?,?,?,?,?)
+
+selectEdmn=SELECT DOC, 'ISO-8859-1' FROM EDMN_ETAT_DOCS WHERE COLLECTIVITE = ? AND BUDGET = ? AND DOC_ID = ?
+
+updateEdmn=UPDATE EDMN_ETAT_DOCS SET DOC = ? WHERE COLLECTIVITE = ? AND BUDGET = ? AND DOC_ID = ?