-- ----------------------------------------------------- -- Afi_GP : Version 1.10.0 -- ----------------------------------------------------- SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0; SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0; SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO'; -- +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -- +++++++++++++++++++++++++++++++ PROCEDURES STOCKEES DE GESTION CADRES D'EMPLOI, GRADES, GRILLES INDICIAIIRES +++++++++++++++++++++++++++++++++++++ DELIMITER $ DROP PROCEDURE IF EXISTS SPINITLOG $ CREATE PROCEDURE SPINITLOG() BEGIN DROP TABLE IF EXISTS AFISPLOGS_GRHCAE; CREATE TABLE AFISPLOGS_GRHCAE ( ID int(11) NOT NULL auto_increment, MSG VARCHAR(250), DATELOG TIMESTAMP, PRIMARY KEY (`ID`)); END $ DROP PROCEDURE IF EXISTS SPLOG $ CREATE PROCEDURE SPLOG(p_message VARCHAR(250)) BEGIN INSERT INTO AFISPLOGS_GRHCAE (MSG, DATELOG) values (p_message, NOW()); END $ DROP PROCEDURE IF EXISTS SPSETVAR_IDGRILLE $ CREATE PROCEDURE SPSETVAR_IDGRILLE( p_nom_grille VARCHAR(64), p_datedebut DATE ) BEGIN -- Cette procédure doit être appelée 1 fois pour CHAQUE grille avant d'utiliser procédures SPAFIGPECHELON ou SPMAJ_AFIGPECHELON -- @v_idgrille est une variable utilisateur SET @v_idgrille = -1; IF p_datedebut IS NULL THEN SELECT ID FROM AFIGPGRILLE WHERE NOM = p_nom_grille AND DATEDEBUT IS NULL INTO @v_idgrille; ELSE SELECT ID FROM AFIGPGRILLE WHERE NOM = p_nom_grille AND DATEDEBUT = p_datedebut INTO @v_idgrille; END IF; IF @v_idgrille = -1 THEN CALL SPLOG(concat_ws(' ','*** SPSETVAR_IDGRILLE: ID grille NON TROUVE pour: nom grille=' , p_nom_grille, 'et date debut=', p_datedebut )); ELSE CALL SPLOG(concat_ws(' ','SPSETVAR_IDGRILLE: ID grille trouve et affecte @v_idgrille =' , @v_idgrille )); END IF; END $ DROP FUNCTION IF EXISTS SFGETVAR_IDGRILLE $ CREATE FUNCTION SFGETVAR_IDGRILLE( ) RETURNS INTEGER BEGIN -- BUT : Rend l'ID de la table AFIGPGRILLE (Il faut préalablement appeler SPSETVAR_IDGRILLE). IF @v_idgrille = -1 OR @v_idgrille IS NULL THEN CALL SPLOG(concat_ws(' ', '*** SFGETVAR_IDGRILLE: Erreur à l''appel de la fonction: Il faut d''abord appeler SPSETVAR_IDGRILLE')); IF @v_idgrille IS NULL THEN SET @v_idgrille = -1; END IF; END IF; RETURN @v_idgrille; END $ DROP FUNCTION IF EXISTS SFGETIDBRUT $ CREATE FUNCTION SFGETIDBRUT (p_brut INTEGER) RETURNS INTEGER BEGIN DECLARE v_idbrut INTEGER DEFAULT -1; DECLARE v_majore INTEGER DEFAULT -1; SELECT MAJ INTO v_majore FROM AFIGPBRUTMAJ_REF WHERE BRUT = p_brut; IF v_majore = -1 THEN CALL SPLOG(concat_ws(' ','*** SFGETIDBRUT: Indice majore de reference non trouve pour ind brut=' , p_brut)); ELSE SELECT MAX(ID) INTO v_idbrut FROM AFIGPBRUTMAJ WHERE BRUT = p_brut AND MAJORE = v_majore AND ARCHIVE = 0; IF v_idbrut = -1 THEN INSERT INTO AFIGPBRUTMAJ (BRUT,MAJORE,ARCHIVE) VALUES (p_brut, v_majore, 0); SELECT LAST_INSERT_ID() INTO v_idbrut; CALL SPLOG(concat_ws(' ','SFGETIDBRUT: Creation idbrut=', v_idbrut, ' pour brut=', p_brut, ', majore=', v_majore)); ELSE CALL SPLOG(concat_ws(' ','SFGETIDBRUT: Recuperation idbrut=' , v_idbrut , ' pour brut=' , p_brut , ', majore=' , v_majore)); END IF; END IF; IF v_idbrut = -1 THEN SET v_idbrut = 1; END IF; RETURN v_idbrut; END $ DROP PROCEDURE IF EXISTS SPCRE_AFIGPECHELON $ CREATE PROCEDURE SPCRE_AFIGPECHELON( p_echelon INTEGER, p_brut INTEGER, p_mini DECIMAL(8,2), p_maxi DECIMAL(8,2)) BEGIN DECLARE v_idbrut INTEGER DEFAULT SFGETIDBRUT(p_brut); -- BUT : Creation de la fiche AFIGPECHELON à partir des éléments passés en paramètre (Il faut préalablement appeler SPSETVAR_IDGRILLE). IF @v_idgrille = -1 OR @v_idgrille IS NULL THEN CALL SPLOG(concat_ws(' ', '*** SPCRE_AFIGPECHELON: Erreur à l''appel de la procedure: Il faut d''abord appeler SPSETVAR_IDGRILLE')); ELSE INSERT IGNORE INTO AFIGPECHELON (IDGRILLE, ECHELON, IDBRUT, MINI, MAXI) SELECT @v_idgrille, p_echelon, v_idbrut, p_mini, p_maxi FROM DUAL; CALL SPLOG(concat_ws(' ', 'SPCRE_AFIGPECHELON: Creation fiche: idgrille=', @v_idgrille, 'Echelon=', p_echelon, 'IDBRUT=', v_idbrut, 'Mini=', p_mini, 'Maxi =', p_maxi)); END IF; END $ DROP PROCEDURE IF EXISTS SPMAJ_AFIGPECHELON $ CREATE PROCEDURE SPMAJ_AFIGPECHELON( p_echelon INTEGER, p_brut INTEGER) BEGIN DECLARE v_idbrut INTEGER DEFAULT SFGETIDBRUT(p_brut); -- BUT : mise à jour de l'ID AFIGPECHELON.IDBRUT à partir de l''indice brut passe en parametre (Il faut préalablement appeler SPSETVAR_IDGRILLE). IF @v_idgrille = -1 OR @v_idgrille IS NULL THEN CALL SPLOG(concat_ws(' ', '*** SPMAJ_AFIGPECHELON: Erreur à l''appel de la procedure: Il faut d''abord appeler SPSETVAR_IDGRILLE')); ELSE UPDATE AFIGPECHELON SET IDBRUT = v_idbrut WHERE IDGRILLE = @v_idgrille AND ECHELON = p_echelon; CALL SPLOG(concat_ws(' ', 'SPMAJ_AFIGPECHELON: Mise a jour fiche: idgrille=', @v_idgrille, ', Echelon=', p_echelon, 'avec IDBRUT=', v_idbrut)); END IF; END $ DROP PROCEDURE IF EXISTS SPMAJ2_AFIGPECHELON $ CREATE PROCEDURE SPMAJ2_AFIGPECHELON( p_echelon INTEGER, p_brut INTEGER, p_mini DECIMAL(8,2), p_maxi DECIMAL(8,2)) BEGIN DECLARE v_idbrut INTEGER DEFAULT SFGETIDBRUT(p_brut); -- BUT : Creation de la fiche AFIGPECHELON à partir des éléments passés en paramètre (Il faut préalablement appeler SPSETVAR_IDGRILLE). IF @v_idgrille = -1 OR @v_idgrille IS NULL THEN CALL SPLOG(concat_ws(' ', '*** SPMAJ2_AFIGPECHELON: Erreur à l''appel de la procedure: Il faut d''abord appeler SPSETVAR_IDGRILLE')); ELSE UPDATE AFIGPECHELON SET IDBRUT = v_idbrut, MINI = p_mini, MAXI = p_maxi WHERE IDGRILLE = @v_idgrille AND ECHELON = p_echelon; CALL SPLOG(concat_ws(' ', 'SPMAJ2_AFIGPECHELON: Mise a jour fiche: idgrille=', @v_idgrille, ', Echelon=', p_echelon, 'avec IDBRUT=', v_idbrut, 'Mini=', p_mini, 'Maxi =', p_maxi)); END IF; END $ DROP PROCEDURE IF EXISTS SPDELETE_AFIGPECHELON $ CREATE PROCEDURE SPDELETE_AFIGPECHELON( p_echelon INTEGER ) BEGIN -- BUT : suppression de la fiche de AFIGPECHELON dont la clé est p_echelon et @v_idgrille (Il faut préalablement appeler SPSETVAR_IDGRILLE). IF @v_idgrille = -1 OR @v_idgrille IS NULL THEN CALL SPLOG(concat_ws(' ', '*** SPDELETE_AFIGPECHELON: Erreur à l''appel de la procedure: Il faut d''abord appeler SPSETVAR_IDGRILLE')); ELSE DELETE FROM AFIGPECHELON WHERE IDGRILLE = @v_idgrille AND ECHELON = p_echelon; CALL SPLOG(concat_ws(' ', 'SPDELETE_AFIGPECHELON: Suppression fiche: idgrille=', @v_idgrille, ', Echelon=', p_echelon) ); END IF; END $ -- ---------- Gestion des variables utilisateurs (globales pour la session) ---------- DROP PROCEDURE IF EXISTS SPSETVAR_NULL $ CREATE PROCEDURE SPSETVAR_NULL( ) BEGIN SET @v_idgrille = NULL; SET @v_datedebut = NULL; SET @v_libcaemp = NULL; SET @v_idcaemp = NULL; SET @v_idgrade_0 = NULL; SET @v_idgrade_1 = NULL; SET @v_idgrade_2 = NULL; SET @v_idgrade_3 = NULL; SET @v_idgrade_4 = NULL; SET @v_idgrade_5 = NULL; SET @v_idgrade_6 = NULL; SET @v_idgrade_7 = NULL; SET @v_idgrade_8 = NULL; SET @v_idgrade_9 = NULL; SET @v_lbgrade_0 = NULL; SET @v_lbgrade_1 = NULL; SET @v_lbgrade_2 = NULL; SET @v_lbgrade_3 = NULL; SET @v_lbgrade_4 = NULL; SET @v_lbgrade_5 = NULL; SET @v_lbgrade_6 = NULL; SET @v_lbgrade_7 = NULL; SET @v_lbgrade_8 = NULL; SET @v_lbgrade_9 = NULL; END $ DROP PROCEDURE IF EXISTS SPSETVAR_DATEDEB $ CREATE PROCEDURE SPSETVAR_DATEDEB( p_datedebut DATE ) BEGIN -- BUT affectation variable utilisateur (à faire en entete de chaque bloc de cadre d'emploi). -- p_datedebut : représente la date de mise en vigueur (date d'effet) du grade ou de la grille SET @v_datedebut = p_datedebut; CALL SPLOG(concat_ws(' ','SPSETVAR_DATEDEB: affectation @v_datedebut =', @v_datedebut )); END $ DROP FUNCTION IF EXISTS SFGETVAR_DATEDEB $ CREATE FUNCTION SFGETVAR_DATEDEB( ) RETURNS DATE BEGIN RETURN @v_datedebut; END $ DROP PROCEDURE IF EXISTS SPSETVAR_CAEMP $ CREATE PROCEDURE SPSETVAR_CAEMP( p_idcaemp VARCHAR(5), p_libcaemp VARCHAR(100) ) BEGIN -- BUT affectation variable utilisateur (à faire en entete de chaque bloc de cadre d'emploi). -- p_idcaemp : représente la clé du cadre d'emploi (AFIGPCADREMP) de la table du grade (AFIGPGRADE) SET @v_idcaemp = p_idcaemp; SET @v_libcaemp = p_libcaemp; CALL SPLOG(concat_ws(' ','SPSETVAR_CAEMP: affectation @v_idcaemp =', @v_idcaemp, '@v_libcaemp =', @v_libcaemp )); END $ DROP FUNCTION IF EXISTS SFGETVAR_IDCAEMP $ CREATE FUNCTION SFGETVAR_IDCAEMP( ) RETURNS VARCHAR(5) BEGIN RETURN @v_idcaemp; END $ DROP FUNCTION IF EXISTS SFGETVAR_LIBCAEMP $ CREATE FUNCTION SFGETVAR_LIBCAEMP( ) RETURNS VARCHAR(100) BEGIN RETURN @v_libcaemp; END $ DROP PROCEDURE IF EXISTS SPSETVAR_GRADE_0 $ CREATE PROCEDURE SPSETVAR_GRADE_0( p_idgrade VARCHAR(8), p_lbgrade VARCHAR(40) ) BEGIN -- BUT affectation variable utilisateur (à faire en entete de chaque bloc de cadre d'emploi). -- p_id : réprésente l'ID du grade (clé). Il est utilisé pour créer le nouveau grade et aussi pour les conditions d'avancement de grade. -- p_lbgrade : réprésente le libellé du grade. Il est utilisé pour créer le nouveau grade et aussi pour le nom de la grille. SET @v_idgrade_0 = p_idgrade; SET @v_lbgrade_0 = p_lbgrade; CALL SPLOG(concat_ws(' ','SPSETVAR_GRADE_0: affectation @v_lbgrade_0 =', @v_lbgrade_0 )); END $ DROP FUNCTION IF EXISTS SFGETVAR_LBGRADE_0 $ CREATE FUNCTION SFGETVAR_LBGRADE_0( ) RETURNS VARCHAR(64) BEGIN RETURN @v_lbgrade_0; END $ DROP FUNCTION IF EXISTS SFGETVAR_IDGRADE_0 $ CREATE FUNCTION SFGETVAR_IDGRADE_0( ) RETURNS VARCHAR(64) BEGIN RETURN @v_idgrade_0; END $ DROP PROCEDURE IF EXISTS SPSETVAR_GRADE_1 $ CREATE PROCEDURE SPSETVAR_GRADE_1( p_idgrade VARCHAR(8), p_lbgrade VARCHAR(40) ) BEGIN SET @v_idgrade_1 = p_idgrade; SET @v_lbgrade_1 = p_lbgrade; CALL SPLOG(concat_ws(' ','SPSETVAR_GRADE_1: affectation @v_lbgrade_1 =', @v_lbgrade_1 )); END $ DROP FUNCTION IF EXISTS SFGETVAR_LBGRADE_1 $ CREATE FUNCTION SFGETVAR_LBGRADE_1( ) RETURNS VARCHAR(64) BEGIN RETURN @v_lbgrade_1; END $ DROP FUNCTION IF EXISTS SFGETVAR_IDGRADE_1 $ CREATE FUNCTION SFGETVAR_IDGRADE_1( ) RETURNS VARCHAR(64) BEGIN RETURN @v_idgrade_1; END $ DROP PROCEDURE IF EXISTS SPSETVAR_GRADE_2 $ CREATE PROCEDURE SPSETVAR_GRADE_2( p_idgrade VARCHAR(8), p_lbgrade VARCHAR(40) ) BEGIN SET @v_idgrade_2 = p_idgrade; SET @v_lbgrade_2 = p_lbgrade; CALL SPLOG(concat_ws(' ','SPSETVAR_GRADE_2: affectation @v_lbgrade_2 =', @v_lbgrade_2 )); END $ DROP FUNCTION IF EXISTS SFGETVAR_LBGRADE_2 $ CREATE FUNCTION SFGETVAR_LBGRADE_2( ) RETURNS VARCHAR(64) BEGIN RETURN @v_lbgrade_2; END $ DROP FUNCTION IF EXISTS SFGETVAR_IDGRADE_2 $ CREATE FUNCTION SFGETVAR_IDGRADE_2( ) RETURNS VARCHAR(64) BEGIN RETURN @v_idgrade_2; END $ DROP PROCEDURE IF EXISTS SPSETVAR_GRADE_3 $ CREATE PROCEDURE SPSETVAR_GRADE_3( p_idgrade VARCHAR(8), p_lbgrade VARCHAR(40) ) BEGIN SET @v_idgrade_3 = p_idgrade; SET @v_lbgrade_3 = p_lbgrade; CALL SPLOG(concat_ws(' ','SPSETVAR_GRADE_3: affectation @v_lbgrade_3 =', @v_lbgrade_3 )); END $ DROP FUNCTION IF EXISTS SFGETVAR_LBGRADE_3 $ CREATE FUNCTION SFGETVAR_LBGRADE_3( ) RETURNS VARCHAR(64) BEGIN RETURN @v_lbgrade_3; END $ DROP FUNCTION IF EXISTS SFGETVAR_IDGRADE_3 $ CREATE FUNCTION SFGETVAR_IDGRADE_3( ) RETURNS VARCHAR(64) BEGIN RETURN @v_idgrade_3; END $ DROP PROCEDURE IF EXISTS SPSETVAR_GRADE_4 $ CREATE PROCEDURE SPSETVAR_GRADE_4( p_idgrade VARCHAR(8), p_lbgrade VARCHAR(40) ) BEGIN SET @v_idgrade_4 = p_idgrade; SET @v_lbgrade_4 = p_lbgrade; CALL SPLOG(concat_ws(' ','SPSETVAR_GRADE_4: affectation @v_lbgrade_4 =', @v_lbgrade_4 )); END $ DROP FUNCTION IF EXISTS SFGETVAR_LBGRADE_4 $ CREATE FUNCTION SFGETVAR_LBGRADE_4( ) RETURNS VARCHAR(64) BEGIN RETURN @v_lbgrade_4; END $ DROP FUNCTION IF EXISTS SFGETVAR_IDGRADE_4 $ CREATE FUNCTION SFGETVAR_IDGRADE_4( ) RETURNS VARCHAR(64) BEGIN RETURN @v_idgrade_4; END $ DROP PROCEDURE IF EXISTS SPSETVAR_GRADE_5 $ CREATE PROCEDURE SPSETVAR_GRADE_5( p_idgrade VARCHAR(8), p_lbgrade VARCHAR(40) ) BEGIN SET @v_idgrade_5 = p_idgrade; SET @v_lbgrade_5 = p_lbgrade; CALL SPLOG(concat_ws(' ','SPSETVAR_GRADE_5: affectation @v_lbgrade_5 =', @v_lbgrade_5 )); END $ DROP FUNCTION IF EXISTS SFGETVAR_LBGRADE_5 $ CREATE FUNCTION SFGETVAR_LBGRADE_5( ) RETURNS VARCHAR(64) BEGIN RETURN @v_lbgrade_5; END $ DROP FUNCTION IF EXISTS SFGETVAR_IDGRADE_5 $ CREATE FUNCTION SFGETVAR_IDGRADE_5( ) RETURNS VARCHAR(64) BEGIN RETURN @v_idgrade_5; END $ DROP PROCEDURE IF EXISTS SPSETVAR_GRADE_6 $ CREATE PROCEDURE SPSETVAR_GRADE_6( p_idgrade VARCHAR(8), p_lbgrade VARCHAR(40) ) BEGIN SET @v_idgrade_6 = p_idgrade; SET @v_lbgrade_6 = p_lbgrade; CALL SPLOG(concat_ws(' ','SPSETVAR_GRADE_6: affectation @v_lbgrade_6 =', @v_lbgrade_6 )); END $ DROP FUNCTION IF EXISTS SFGETVAR_LBGRADE_6 $ CREATE FUNCTION SFGETVAR_LBGRADE_6( ) RETURNS VARCHAR(64) BEGIN RETURN @v_lbgrade_6; END $ DROP FUNCTION IF EXISTS SFGETVAR_IDGRADE_6 $ CREATE FUNCTION SFGETVAR_IDGRADE_6( ) RETURNS VARCHAR(64) BEGIN RETURN @v_idgrade_6; END $ DROP PROCEDURE IF EXISTS SPSETVAR_GRADE_7 $ CREATE PROCEDURE SPSETVAR_GRADE_7( p_idgrade VARCHAR(8), p_lbgrade VARCHAR(40) ) BEGIN SET @v_idgrade_7 = p_idgrade; SET @v_lbgrade_7 = p_lbgrade; CALL SPLOG(concat_ws(' ','SPSETVAR_GRADE_7: affectation @v_lbgrade_7 =', @v_lbgrade_7 )); END $ DROP FUNCTION IF EXISTS SFGETVAR_LBGRADE_7 $ CREATE FUNCTION SFGETVAR_LBGRADE_7( ) RETURNS VARCHAR(64) BEGIN RETURN @v_lbgrade_7; END $ DROP FUNCTION IF EXISTS SFGETVAR_IDGRADE_7 $ CREATE FUNCTION SFGETVAR_IDGRADE_7( ) RETURNS VARCHAR(64) BEGIN RETURN @v_idgrade_7; END $ DROP PROCEDURE IF EXISTS SPSETVAR_GRADE_8 $ CREATE PROCEDURE SPSETVAR_GRADE_8( p_idgrade VARCHAR(8), p_lbgrade VARCHAR(40) ) BEGIN SET @v_idgrade_8 = p_idgrade; SET @v_lbgrade_8 = p_lbgrade; CALL SPLOG(concat_ws(' ','SPSETVAR_GRADE_8: affectation @v_lbgrade_8 =', @v_lbgrade_8 )); END $ DROP FUNCTION IF EXISTS SFGETVAR_LBGRADE_8 $ CREATE FUNCTION SFGETVAR_LBGRADE_8( ) RETURNS VARCHAR(64) BEGIN RETURN @v_lbgrade_8; END $ DROP FUNCTION IF EXISTS SFGETVAR_IDGRADE_8 $ CREATE FUNCTION SFGETVAR_IDGRADE_8( ) RETURNS VARCHAR(64) BEGIN RETURN @v_idgrade_8; END $ DROP PROCEDURE IF EXISTS SPSETVAR_GRADE_9 $ CREATE PROCEDURE SPSETVAR_GRADE_9( p_idgrade VARCHAR(8), p_lbgrade VARCHAR(40) ) BEGIN SET @v_idgrade_9 = p_idgrade; SET @v_lbgrade_9 = p_lbgrade; CALL SPLOG(concat_ws(' ','SPSETVAR_GRADE_9: affectation @v_lbgrade_9 =', @v_lbgrade_9 )); END $ DROP FUNCTION IF EXISTS SFGETVAR_LBGRADE_9 $ CREATE FUNCTION SFGETVAR_LBGRADE_9( ) RETURNS VARCHAR(64) BEGIN RETURN @v_lbgrade_9; END $ DROP FUNCTION IF EXISTS SFGETVAR_IDGRADE_9 $ CREATE FUNCTION SFGETVAR_IDGRADE_9( ) RETURNS VARCHAR(64) BEGIN RETURN @v_idgrade_9; END $ DELIMITER ; CALL SPINITLOG; -- +++++++++++++++++++++++++++++++ FIN prodécures stockées cadres d'emplois,grades, grilles indiciaires ++++++++++++++++++++++++++++++++++++++++++++ -- +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -- =================================================================================================================================================== -- ======================================== CREATION CORRESPONDANCE INDICES BRUT -> MAJORE (JANVIER 2011)============================================= -- ---------- Actualisation correspondance indices BRUT -> MAJORE selon valeurs de JANVIER 2011 ---------- DELETE FROM AFIGPBRUTMAJ_REF; INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (100, 203); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (101, 204); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (102, 204); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (103, 205); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (104, 206); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (105, 207); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (106, 207); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (107, 208); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (108, 209); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (109, 210); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (110, 210); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (111, 211); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (112, 212); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (113, 213); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (114, 213); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (115, 214); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (116, 215); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (117, 215); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (118, 216); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (119, 217); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (120, 218); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (121, 219); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (122, 220); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (123, 221); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (124, 222); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (125, 222); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (126, 223); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (127, 224); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (128, 225); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (129, 225); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (130, 226); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (131, 227); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (132, 228); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (133, 228); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (134, 229); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (135, 230); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (136, 230); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (137, 231); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (138, 231); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (139, 231); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (140, 232); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (141, 232); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (142, 233); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (143, 233); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (144, 234); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (145, 234); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (146, 235); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (147, 236); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (148, 236); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (149, 237); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (150, 237); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (151, 238); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (152, 238); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (153, 238); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (154, 239); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (155, 239); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (156, 239); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (157, 240); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (158, 240); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (159, 241); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (160, 241); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (161, 241); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (162, 242); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (163, 242); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (164, 243); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (165, 244); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (166, 244); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (167, 244); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (168, 245); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (169, 245); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (170, 246); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (171, 246); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (172, 246); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (173, 247); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (174, 247); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (175, 247); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (176, 248); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (177, 248); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (178, 248); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (179, 249); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (180, 249); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (181, 250); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (182, 251); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (183, 251); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (184, 252); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (185, 252); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (186, 252); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (187, 253); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (188, 253); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (189, 253); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (190, 254); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (191, 254); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (192, 255); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (193, 256); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (194, 257); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (195, 257); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (196, 258); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (197, 259); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (198, 259); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (199, 260); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (200, 261); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (201, 261); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (202, 262); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (203, 263); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (204, 264); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (205, 265); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (206, 266); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (207, 266); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (208, 267); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (209, 268); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (210, 268); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (211, 269); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (212, 270); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (213, 271); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (214, 272); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (215, 273); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (216, 274); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (217, 275); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (218, 276); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (219, 277); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (220, 278); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (221, 279); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (222, 280); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (223, 281); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (224, 282); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (225, 283); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (226, 284); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (227, 285); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (228, 286); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (229, 287); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (230, 288); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (231, 289); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (232, 290); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (233, 291); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (234, 292); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (235, 293); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (236, 294); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (237, 295); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (238, 296); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (239, 297); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (240, 298); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (241, 299); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (242, 300); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (243, 301); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (244, 302); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (245, 302); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (246, 302); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (247, 302); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (248, 302); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (249, 302); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (250, 302); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (251, 302); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (252, 302); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (253, 302); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (254, 302); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (255, 302); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (256, 302); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (257, 302); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (258, 302); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (259, 302); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (260, 302); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (261, 302); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (262, 302); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (263, 302); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (264, 302); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (265, 302); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (266, 302); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (267, 302); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (268, 302); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (269, 302); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (270, 302); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (271, 302); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (272, 302); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (273, 302); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (274, 302); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (275, 302); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (276, 302); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (277, 302); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (278, 302); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (279, 302); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (280, 302); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (281, 302); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (282, 302); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (283, 302); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (284, 302); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (285, 302); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (286, 302); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (287, 302); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (288, 302); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (289, 302); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (290, 302); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (291, 302); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (292, 302); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (293, 302); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (294, 302); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (295, 302); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (296, 302); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (297, 302); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (298, 303); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (299, 304); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (300, 304); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (301, 304); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (302, 305); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (303, 305); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (304, 305); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (305, 305); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (306, 305); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (307, 306); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (308, 306); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (309, 306); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (310, 306); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (311, 306); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (312, 306); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (313, 306); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (314, 306); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (315, 306); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (316, 306); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (317, 306); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (318, 307); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (319, 307); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (320, 307); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (321, 307); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (322, 308); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (323, 308); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (324, 309); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (325, 310); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (326, 311); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (327, 311); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (328, 312); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (329, 313); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (330, 314); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (331, 314); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (332, 315); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (333, 316); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (334, 317); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (335, 317); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (336, 318); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (337, 319); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (338, 319); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (339, 320); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (340, 321); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (341, 322); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (342, 323); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (343, 324); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (344, 324); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (345, 324); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (346, 324); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (347, 325); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (348, 326); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (349, 327); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (350, 327); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (351, 328); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (352, 329); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (353, 329); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (354, 330); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (355, 331); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (356, 332); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (357, 332); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (358, 333); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (359, 334); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (360, 335); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (361, 335); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (362, 336); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (363, 337); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (364, 338); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (365, 338); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (366, 339); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (367, 340); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (368, 341); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (369, 341); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (370, 342); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (371, 343); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (372, 343); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (373, 344); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (374, 345); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (375, 346); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (376, 346); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (377, 347); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (378, 348); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (379, 349); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (380, 350); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (381, 351); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (382, 352); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (383, 352); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (384, 352); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (385, 353); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (386, 354); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (387, 354); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (388, 355); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (389, 356); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (390, 357); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (391, 357); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (392, 357); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (393, 358); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (394, 359); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (395, 359); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (396, 360); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (397, 361); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (398, 362); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (399, 362); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (400, 363); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (401, 363); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (402, 364); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (403, 364); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (404, 365); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (405, 366); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (406, 366); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (407, 367); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (408, 367); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (409, 368); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (410, 368); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (411, 368); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (412, 368); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (413, 369); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (414, 369); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (415, 369); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (416, 370); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (417, 371); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (418, 371); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (419, 372); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (420, 373); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (421, 374); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (422, 375); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (423, 376); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (424, 377); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (425, 377); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (426, 378); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (427, 379); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (428, 379); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (429, 379); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (430, 380); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (431, 381); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (432, 382); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (433, 382); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (434, 383); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (435, 384); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (436, 384); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (437, 385); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (438, 386); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (439, 387); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (440, 387); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (441, 388); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (442, 389); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (443, 390); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (444, 390); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (445, 391); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (446, 392); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (447, 393); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (448, 393); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (449, 394); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (450, 395); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (451, 396); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (452, 396); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (453, 397); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (454, 398); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (455, 398); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (456, 399); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (457, 400); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (458, 401); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (459, 402); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (460, 403); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (461, 404); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (462, 405); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (463, 405); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (464, 406); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (465, 407); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (466, 408); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (467, 408); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (468, 409); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (469, 410); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (470, 411); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (471, 411); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (472, 412); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (473, 412); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (474, 413); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (475, 413); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (476, 414); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (477, 415); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (478, 415); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (479, 416); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (480, 416); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (481, 417); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (482, 417); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (483, 418); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (484, 419); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (485, 420); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (486, 420); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (487, 421); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (488, 422); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (489, 422); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (490, 423); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (491, 424); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (492, 425); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (493, 425); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (494, 426); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (495, 427); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (496, 428); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (497, 428); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (498, 429); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (499, 430); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (500, 431); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (501, 432); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (502, 433); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (503, 434); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (504, 434); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (505, 435); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (506, 436); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (507, 437); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (508, 437); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (509, 438); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (510, 439); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (511, 440); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (512, 440); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (513, 441); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (514, 442); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (515, 443); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (516, 443); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (517, 444); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (518, 445); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (519, 446); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (520, 446); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (521, 447); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (522, 448); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (523, 448); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (524, 449); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (525, 450); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (526, 451); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (527, 451); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (528, 452); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (529, 453); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (530, 454); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (531, 454); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (532, 455); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (533, 456); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (534, 456); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (535, 456); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (536, 457); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (537, 457); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (538, 457); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (539, 458); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (540, 459); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (541, 460); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (542, 461); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (543, 462); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (544, 463); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (545, 464); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (546, 464); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (547, 465); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (548, 466); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (549, 467); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (550, 467); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (551, 468); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (552, 469); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (553, 469); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (554, 470); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (555, 471); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (556, 472); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (557, 472); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (558, 473); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (559, 474); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (560, 475); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (561, 475); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (562, 476); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (563, 477); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (564, 478); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (565, 478); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (566, 479); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (567, 480); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (568, 481); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (569, 481); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (570, 482); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (571, 483); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (572, 483); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (573, 484); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (574, 485); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (575, 486); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (576, 486); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (577, 487); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (578, 488); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (579, 489); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (580, 490); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (581, 491); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (582, 492); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (583, 493); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (584, 493); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (585, 494); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (586, 495); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (587, 495); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (588, 496); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (589, 497); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (590, 498); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (591, 498); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (592, 499); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (593, 500); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (594, 501); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (595, 501); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (596, 502); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (597, 503); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (598, 504); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (599, 504); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (600, 505); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (601, 506); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (602, 507); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (603, 507); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (604, 508); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (605, 509); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (606, 509); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (607, 510); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (608, 511); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (609, 512); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (610, 512); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (611, 513); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (612, 514); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (613, 515); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (614, 515); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (615, 516); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (616, 517); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (617, 518); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (618, 518); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (619, 519); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (620, 520); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (621, 521); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (622, 522); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (623, 523); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (624, 524); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (625, 524); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (626, 525); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (627, 526); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (628, 527); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (629, 527); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (630, 528); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (631, 529); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (632, 530); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (633, 530); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (634, 531); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (635, 532); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (636, 533); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (637, 533); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (638, 534); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (639, 535); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (640, 535); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (641, 536); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (642, 537); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (643, 538); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (644, 538); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (645, 539); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (646, 540); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (647, 541); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (648, 541); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (649, 542); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (650, 543); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (651, 544); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (652, 544); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (653, 545); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (654, 546); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (655, 546); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (656, 547); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (657, 548); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (658, 549); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (659, 550); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (660, 551); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (661, 552); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (662, 553); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (663, 553); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (664, 554); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (665, 555); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (666, 556); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (667, 556); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (668, 557); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (669, 558); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (670, 559); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (671, 559); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (672, 560); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (673, 561); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (674, 561); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (675, 562); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (676, 563); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (677, 564); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (678, 564); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (679, 565); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (680, 566); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (681, 567); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (682, 567); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (683, 568); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (684, 569); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (685, 570); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (686, 570); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (687, 571); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (688, 572); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (689, 572); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (690, 573); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (691, 574); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (692, 575); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (693, 575); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (694, 576); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (695, 577); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (696, 578); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (697, 578); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (698, 579); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (699, 580); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (700, 581); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (701, 582); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (702, 583); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (703, 584); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (704, 584); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (705, 585); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (706, 586); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (707, 587); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (708, 587); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (709, 588); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (710, 589); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (711, 590); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (712, 590); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (713, 591); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (714, 592); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (715, 593); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (716, 593); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (717, 594); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (718, 595); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (719, 596); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (720, 596); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (721, 597); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (722, 598); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (723, 598); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (724, 599); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (725, 600); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (726, 601); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (727, 601); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (728, 602); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (729, 603); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (730, 604); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (731, 604); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (732, 605); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (733, 606); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (734, 607); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (735, 607); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (736, 608); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (737, 609); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (738, 610); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (739, 610); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (740, 611); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (741, 612); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (742, 613); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (743, 614); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (744, 615); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (745, 616); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (746, 616); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (747, 617); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (748, 618); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (749, 619); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (750, 619); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (751, 620); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (752, 621); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (753, 622); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (754, 622); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (755, 623); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (756, 624); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (757, 624); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (758, 625); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (759, 626); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (760, 627); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (761, 627); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (762, 628); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (763, 629); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (764, 630); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (765, 630); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (766, 631); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (767, 632); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (768, 633); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (769, 633); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (770, 634); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (771, 635); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (772, 635); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (773, 636); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (774, 637); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (775, 638); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (776, 638); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (777, 639); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (778, 640); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (779, 641); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (780, 642); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (781, 643); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (782, 644); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (783, 645); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (784, 645); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (785, 646); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (786, 647); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (787, 648); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (788, 648); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (789, 649); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (790, 650); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (791, 650); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (792, 651); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (793, 652); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (794, 653); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (795, 653); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (796, 654); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (797, 655); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (798, 656); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (799, 656); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (800, 657); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (801, 658); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (802, 659); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (803, 659); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (804, 660); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (805, 661); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (806, 661); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (807, 662); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (808, 663); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (809, 664); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (810, 664); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (811, 665); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (812, 666); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (813, 667); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (814, 667); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (815, 668); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (816, 669); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (817, 670); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (818, 670); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (819, 671); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (820, 672); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (821, 673); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (822, 674); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (823, 675); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (824, 676); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (825, 676); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (826, 677); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (827, 678); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (828, 679); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (829, 679); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (830, 680); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (831, 681); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (832, 682); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (833, 682); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (834, 683); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (835, 684); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (836, 685); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (837, 685); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (838, 686); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (839, 687); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (840, 687); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (841, 688); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (842, 689); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (843, 690); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (844, 690); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (845, 691); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (846, 692); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (847, 693); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (848, 693); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (849, 694); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (850, 695); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (851, 696); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (852, 696); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (853, 697); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (854, 698); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (855, 699); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (856, 699); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (857, 700); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (858, 701); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (859, 702); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (860, 703); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (861, 704); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (862, 705); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (863, 705); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (864, 706); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (865, 707); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (866, 708); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (867, 708); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (868, 709); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (869, 710); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (870, 711); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (871, 711); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (872, 712); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (873, 713); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (874, 713); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (875, 714); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (876, 715); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (877, 716); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (878, 716); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (879, 717); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (880, 718); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (881, 719); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (882, 719); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (883, 720); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (884, 721); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (885, 722); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (886, 722); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (887, 723); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (888, 724); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (889, 725); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (890, 725); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (891, 726); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (892, 727); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (893, 727); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (894, 728); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (895, 729); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (896, 730); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (897, 730); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (898, 731); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (899, 732); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (900, 733); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (901, 734); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (902, 735); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (903, 735); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (904, 736); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (905, 737); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (906, 738); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (907, 739); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (908, 739); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (909, 740); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (910, 741); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (911, 742); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (912, 743); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (913, 743); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (914, 744); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (915, 745); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (916, 746); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (917, 747); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (918, 747); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (919, 748); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (920, 749); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (921, 750); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (922, 750); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (923, 751); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (924, 751); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (925, 752); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (926, 753); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (927, 754); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (928, 754); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (929, 755); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (930, 756); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (931, 757); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (932, 758); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (933, 758); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (934, 759); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (935, 760); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (936, 761); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (937, 762); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (938, 762); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (939, 763); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (940, 764); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (941, 765); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (942, 765); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (943, 766); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (944, 766); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (945, 767); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (946, 768); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (947, 769); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (948, 769); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (949, 770); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (950, 771); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (951, 772); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (952, 772); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (953, 773); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (954, 773); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (955, 774); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (956, 775); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (957, 776); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (958, 776); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (959, 777); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (960, 778); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (961, 779); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (962, 780); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (963, 780); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (964, 781); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (965, 782); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (966, 783); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (967, 784); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (968, 784); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (969, 785); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (970, 786); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (971, 787); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (972, 788); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (973, 788); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (974, 789); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (975, 790); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (976, 791); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (977, 792); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (978, 792); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (979, 793); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (980, 794); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (981, 795); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (982, 796); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (983, 796); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (984, 797); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (985, 798); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (986, 799); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (987, 800); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (988, 800); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (989, 801); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (990, 802); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (991, 803); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (992, 804); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (993, 804); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (994, 805); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (995, 806); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (996, 807); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (997, 807); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (998, 808); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (999, 808); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (1000, 809); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (1001, 810); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (1002, 811); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (1003, 811); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (1004, 812); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (1005, 813); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (1006, 814); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (1007, 814); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (1008, 815); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (1009, 816); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (1010, 817); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (1011, 817); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (1012, 818); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (1013, 819); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (1014, 820); INSERT INTO AFIGPBRUTMAJ_REF (BRUT, MAJ) VALUES (1015, 821); -- ========================================= FIN table de correspondance indices BRUT -> MAJORE ===================================================== -- ================================================================================================================================================== -- =================================================================================================================================================== -- --------------------------------------------------------------------------------------------------------------------------------------------------- -- ------------------------------------- MODIFICATION de grilles indiciaires déjà existantes -------------------------------------------------------- -- ------------------------ #3667 Réaffectation BRUT MAJORE DANS LES GRILLES pour les 2 derniers échelons (10 et 11) --------------------------------- -- Pour échelon 10 : Anciennes valeurs Brut 640 Majoré 535 Nouvelles valeurs Brut 646 Majoré 540 -- Pour échelon 11 : Anciennes valeurs Brut 660 Majoré 551 Nouvelles valeurs Brut 675 Majoré 562 -- --------------------------------------------------------------------------------------------------------------------------------------------------- -- Note : afin que la reconnaissance puisse se faire, ne pas mettre les accentués dans les libellés de grille (cas libellés existants avec accents) CALL SPSETVAR_DATEDEB( '2010-12-01' ); CALL SPSETVAR_IDGRILLE('Technicien Princip. 1 cl', SFGETVAR_DATEDEB()); CALL SPMAJ_AFIGPECHELON( 10, 646 ); CALL SPMAJ_AFIGPECHELON( 11, 675 ); UPDATE AFIGPGRILLE SET DATEDEBUT = '2011-12-01' WHERE NOM = 'Technicien Princip. 1 cl'; CALL SPSETVAR_DATEDEB( '2011-06-01' ); CALL SPSETVAR_IDGRILLE('Educateur APS principal 1ere classe', SFGETVAR_DATEDEB()); CALL SPMAJ_AFIGPECHELON( 10, 646 ); CALL SPMAJ_AFIGPECHELON( 11, 675 ); UPDATE AFIGPGRILLE SET DATEDEBUT = '2011-12-01' WHERE NOM = 'Technicien Princip. 1 cl'; CALL SPSETVAR_DATEDEB( '2011-06-01' ); CALL SPSETVAR_IDGRILLE('Animateur principal de 1ere classe', SFGETVAR_DATEDEB()); CALL SPMAJ_AFIGPECHELON( 10, 646 ); CALL SPMAJ_AFIGPECHELON( 11, 675 ); UPDATE AFIGPGRILLE SET DATEDEBUT = '2011-12-01' WHERE NOM = 'Technicien Princip. 1 cl'; CALL SPSETVAR_DATEDEB( '2011-05-01' ); CALL SPSETVAR_IDGRILLE('Chef service police muni. prin. 1ere cls', SFGETVAR_DATEDEB()); CALL SPMAJ_AFIGPECHELON( 10, 646 ); CALL SPMAJ_AFIGPECHELON( 11, 675 ); UPDATE AFIGPGRILLE SET DATEDEBUT = '2011-12-01' WHERE NOM = 'Technicien Princip. 1 cl'; CALL SPSETVAR_NULL( ); -- --------------------------------------------------------------------------------------------------------------------------------------------------- -- #3338 Reclassement des assistants qualifiés de conservation du patrimoine et des bibliothèques dans le nouveau cadre d'emploi : -- ASSISTANTS TERRITORIAUX DE CONSERVATION DU PATRIMOINE ET DES BIBLIOTHEQUES (Décret n° 2011-1642 du 23/11/2011 date d'effet 1er décembre 2011 -- --------------------------------------------------------------------------------------------------------------------------------------------------- UPDATE AFIGPCADREMP SET ARCHIVE = 1 WHERE ID = 'ASCP'; UPDATE AFIGPGRADE SET ARCHIVE = 1 WHERE ID IN ('ASCPH', 'ASCP1', 'ASCP2'); UPDATE AFIGPGRILLE SET ARCHIVE = 1 WHERE NOM IN ('ASCPH', 'ASCP1', 'ASCP2'); UPDATE AFIGPCADREMP SET ARCHIVE = 1 WHERE ID = 'ASQC'; UPDATE AFIGPGRADE SET ARCHIVE = 1 WHERE ID IN ('ASQCH', 'ASQC1', 'ASQC2'); UPDATE AFIGPGRILLE SET ARCHIVE = 1 WHERE NOM IN ('ASQCH', 'ASQC1', 'ASQC2'); UPDATE AFIGPAVGRADE SET ARCHIVE = 1 WHERE ( GRADE_A IN (SELECT ID FROM AFIGPGRADE WHERE ARCHIVE = 1 AND IDCAEMP IN ('ASCP', 'ASQC' )) OR GRADE_N IN (SELECT ID FROM AFIGPGRADE WHERE ARCHIVE = 1 AND IDCAEMP IN ('ASCP', 'ASQC' )) ); CALL SPSETVAR_DATEDEB( '2011-12-01' ); CALL SPSETVAR_CAEMP('AC_PB', 'Assistants conservation patrimoine et bibliotheques'); CALL SPSETVAR_GRADE_0('AC_PB0', 'Assistants conservation'); CALL SPSETVAR_GRADE_1('AC_PB1', 'Assistants conserva. princ. 2eme classe'); CALL SPSETVAR_GRADE_2('AC_PB2', 'Assistants conserva. princ. 1ere classe'); -- ----------------------------------------------------- -- AFIGPCADREMP -- ----------------------------------------------------- INSERT IGNORE INTO AFIGPCADREMP (ID, IDFILIERE, LIBCAEMP, OBSERVATION, CATEGORIE, ARCHIVE) VALUES (SFGETVAR_IDCAEMP(), '3', SFGETVAR_LIBCAEMP(), '2011-1642 du 23 novembre 2011', 'B', '0'); -- ----------------------------------------------------- -- AFIGPGRILLE -- ----------------------------------------------------- INSERT INTO AFIGPGRILLE (ARCHIVE, DATEDEBUT, NOM) SELECT '0', SFGETVAR_DATEDEB(), SFGETVAR_LBGRADE_0() FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM AFIGPGRILLE WHERE NOM = SFGETVAR_LBGRADE_0() AND IF( SFGETVAR_DATEDEB() IS NOT NULL, DATEDEBUT = SFGETVAR_DATEDEB(), DATEDEBUT IS NULL)); INSERT INTO AFIGPGRILLE (ARCHIVE, DATEDEBUT, NOM) SELECT '0', SFGETVAR_DATEDEB(), SFGETVAR_LBGRADE_1() FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM AFIGPGRILLE WHERE NOM = SFGETVAR_LBGRADE_1() AND IF( SFGETVAR_DATEDEB() IS NOT NULL, DATEDEBUT = SFGETVAR_DATEDEB(), DATEDEBUT IS NULL)); INSERT INTO AFIGPGRILLE (ARCHIVE, DATEDEBUT, NOM) SELECT '0', SFGETVAR_DATEDEB(), SFGETVAR_LBGRADE_2() FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM AFIGPGRILLE WHERE NOM = SFGETVAR_LBGRADE_2() AND IF( SFGETVAR_DATEDEB() IS NOT NULL, DATEDEBUT = SFGETVAR_DATEDEB(), DATEDEBUT IS NULL)); -- ----------------------------------------------------- -- AFIGPGRADE -- ----------------------------------------------------- INSERT IGNORE INTO AFIGPGRADE (ID, IDGRILLE, IDCAEMP, LBGRADE, POSIT, ARCHIVE, DATEDEBUT) SELECT SFGETVAR_IDGRADE_0(), ID, SFGETVAR_IDCAEMP(), SFGETVAR_LBGRADE_0(), '1', '0', SFGETVAR_DATEDEB() FROM AFIGPGRILLE WHERE NOM = SFGETVAR_LBGRADE_0() AND IF( SFGETVAR_DATEDEB() IS NOT NULL, DATEDEBUT = SFGETVAR_DATEDEB(), DATEDEBUT IS NULL); INSERT IGNORE INTO AFIGPGRADE (ID, IDGRILLE, IDCAEMP, LBGRADE, POSIT, ARCHIVE, DATEDEBUT) SELECT SFGETVAR_IDGRADE_1(), ID, SFGETVAR_IDCAEMP(), SFGETVAR_LBGRADE_1(), '2', '0', SFGETVAR_DATEDEB() FROM AFIGPGRILLE WHERE NOM = SFGETVAR_LBGRADE_1() AND IF( SFGETVAR_DATEDEB() IS NOT NULL, DATEDEBUT = SFGETVAR_DATEDEB(), DATEDEBUT IS NULL); INSERT IGNORE INTO AFIGPGRADE (ID, IDGRILLE, IDCAEMP, LBGRADE, POSIT, ARCHIVE, DATEDEBUT) SELECT SFGETVAR_IDGRADE_2(), ID, SFGETVAR_IDCAEMP(), SFGETVAR_LBGRADE_2(), '3', '0', SFGETVAR_DATEDEB() FROM AFIGPGRILLE WHERE NOM = SFGETVAR_LBGRADE_2() AND IF( SFGETVAR_DATEDEB() IS NOT NULL, DATEDEBUT = SFGETVAR_DATEDEB(), DATEDEBUT IS NULL); -- ----------------------------------------------------- -- AFIGPECHELON -- ----------------------------------------------------- CALL SPSETVAR_IDGRILLE(SFGETVAR_LBGRADE_0(), SFGETVAR_DATEDEB()); CALL SPCRE_AFIGPECHELON( 1, 325, 12.00, 12.00 ); CALL SPCRE_AFIGPECHELON( 2, 333, 24.00, 24.00 ); CALL SPCRE_AFIGPECHELON( 3, 347, 24.00, 24.00 ); CALL SPCRE_AFIGPECHELON( 4, 359, 24.00, 24.00 ); CALL SPCRE_AFIGPECHELON( 5, 374, 31.00, 36.00 ); CALL SPCRE_AFIGPECHELON( 6, 393, 31.00, 36.00 ); CALL SPCRE_AFIGPECHELON( 7, 418, 31.00, 36.00 ); CALL SPCRE_AFIGPECHELON( 8, 436, 31.00, 36.00 ); CALL SPCRE_AFIGPECHELON( 9, 457, 31.00, 36.00 ); CALL SPCRE_AFIGPECHELON( 10, 486, 31.00, 36.00 ); CALL SPCRE_AFIGPECHELON( 11, 516, 39.00, 48.00 ); CALL SPCRE_AFIGPECHELON( 12, 548, 39.00, 48.00 ); CALL SPCRE_AFIGPECHELON( 13, 576, 0.00, 0.00 ); CALL SPSETVAR_IDGRILLE(SFGETVAR_LBGRADE_1(), SFGETVAR_DATEDEB()); CALL SPCRE_AFIGPECHELON( 1, 350, 12.00, 12.00 ); CALL SPCRE_AFIGPECHELON( 2, 357, 24.00, 24.00 ); CALL SPCRE_AFIGPECHELON( 3, 367, 24.00, 24.00 ); CALL SPCRE_AFIGPECHELON( 4, 378, 24.00, 24.00 ); CALL SPCRE_AFIGPECHELON( 5, 397, 31.00, 36.00 ); CALL SPCRE_AFIGPECHELON( 6, 422, 31.00, 36.00 ); CALL SPCRE_AFIGPECHELON( 7, 444, 31.00, 36.00 ); CALL SPCRE_AFIGPECHELON( 8, 463, 31.00, 36.00 ); CALL SPCRE_AFIGPECHELON( 9, 493, 31.00, 36.00 ); CALL SPCRE_AFIGPECHELON( 10, 518, 31.00, 36.00 ); CALL SPCRE_AFIGPECHELON( 11, 551, 39.00, 48.00 ); CALL SPCRE_AFIGPECHELON( 12, 581, 39.00, 48.00 ); CALL SPCRE_AFIGPECHELON( 13, 614, 0.00, 0.00 ); CALL SPSETVAR_IDGRILLE(SFGETVAR_LBGRADE_2(), SFGETVAR_DATEDEB()); CALL SPCRE_AFIGPECHELON( 1, 404, 12.00, 12.00 ); CALL SPCRE_AFIGPECHELON( 2, 430, 20.00, 24.00 ); CALL SPCRE_AFIGPECHELON( 3, 450, 20.00, 24.00 ); CALL SPCRE_AFIGPECHELON( 4, 469, 20.00, 24.00 ); CALL SPCRE_AFIGPECHELON( 5, 497, 20.00, 24.00 ); CALL SPCRE_AFIGPECHELON( 6, 524, 20.00, 24.00 ); CALL SPCRE_AFIGPECHELON( 7, 555, 29.00, 36.00 ); CALL SPCRE_AFIGPECHELON( 8, 585, 29.00, 36.00 ); CALL SPCRE_AFIGPECHELON( 9, 619, 29.00, 36.00 ); CALL SPCRE_AFIGPECHELON( 10, 646, 29.00, 36.00 ); CALL SPCRE_AFIGPECHELON( 11, 675, 0.00, 0.00 ); -- ----------------------------------------------------- -- AFIGPAVGRADE -- ----------------------------------------------------- INSERT INTO AFIGPAVGRADE (GRADE_A, GRADE_N, ECH_MINI, AGE_MINI, AGE_MAXI, ANC_CADRE, ANC_GRADE, ANC_ECH, EXAMEN, ARCHIVE, DTE_DEB, PROMOTION) SELECT SFGETVAR_IDGRADE_0(), SFGETVAR_IDGRADE_1(), 4, 0, 0, 36, 0, 12, 1, 0, SFGETVAR_DATEDEB(), 0 FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM AFIGPAVGRADE WHERE GRADE_A = SFGETVAR_IDGRADE_0() AND GRADE_N = SFGETVAR_IDGRADE_1() AND EXAMEN = 1); INSERT INTO AFIGPAVGRADE (GRADE_A, GRADE_N, ECH_MINI, AGE_MINI, AGE_MAXI, ANC_CADRE, ANC_GRADE, ANC_ECH, EXAMEN, ARCHIVE, DTE_DEB, PROMOTION) SELECT SFGETVAR_IDGRADE_0(), SFGETVAR_IDGRADE_1(), 6, 0, 0, 60, 0, 12, 0, 0, SFGETVAR_DATEDEB(), 0 FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM AFIGPAVGRADE WHERE GRADE_A = SFGETVAR_IDGRADE_0() AND GRADE_N = SFGETVAR_IDGRADE_1() AND EXAMEN = 0); INSERT INTO AFIGPAVGRADE (GRADE_A, GRADE_N, ECH_MINI, AGE_MINI, AGE_MAXI, ANC_CADRE, ANC_GRADE, ANC_ECH, EXAMEN, ARCHIVE, DTE_DEB, PROMOTION) SELECT SFGETVAR_IDGRADE_1(), SFGETVAR_IDGRADE_2(), 5, 0, 0, 36, 0, 24, 1, 0, SFGETVAR_DATEDEB(), 0 FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM AFIGPAVGRADE WHERE GRADE_A = SFGETVAR_IDGRADE_1() AND GRADE_N = SFGETVAR_IDGRADE_2() AND EXAMEN = 1); INSERT INTO AFIGPAVGRADE (GRADE_A, GRADE_N, ECH_MINI, AGE_MINI, AGE_MAXI, ANC_CADRE, ANC_GRADE, ANC_ECH, EXAMEN, ARCHIVE, DTE_DEB, PROMOTION) SELECT SFGETVAR_IDGRADE_1(), SFGETVAR_IDGRADE_2(), 6, 0, 0, 60, 0, 12, 0, 0, SFGETVAR_DATEDEB(), 0 FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM AFIGPAVGRADE WHERE GRADE_A = SFGETVAR_IDGRADE_1() AND GRADE_N = SFGETVAR_IDGRADE_2() AND EXAMEN = 0); CALL SPSETVAR_NULL( ); -- ---------------------------------------------------------------------------------------------------------------------------------------------------- -- --------------------- CONSERVATEURS DES BIBLIOTHEQUES (decret 2009-1582 et 2009-1583 du 17 décembre 2009 - effet au 1er janvier 2010) -------------- -- Grille "Conservateur bibliothèques (titulaire)" Cette grille concerne le grade C_B1 de même libellé. -- #3337 CORRECTION de la grille : les échelons 6, 7, 8 sont décalés vers les échelons 5, 6, 7 -- Répercution dans les situations et mouvements de carrière : Affectation de l'échelon en conséquence. -- Suppression de l'échelon 8 dans la grille. -- ---------------------------------------------------------------------------------------------------------------------------------------------------- -- Note : afin que la reconnaissance puisse se faire, ne pas mettre les accentués dans les libellés de grille (cas libellés existants avec accents) CALL SPSETVAR_DATEDEB( '2010-01-01' ); CALL SPSETVAR_GRADE_1('C_B1', 'Conservateur bibliotheques (titulaire)'); -- ----- Correction grille conservateurs des bibliotheques ------ CALL SPSETVAR_IDGRILLE(SFGETVAR_LBGRADE_1(), SFGETVAR_DATEDEB()); CALL SPCRE_AFIGPECHELON( 5, 701, 29.00, 31.00 ); CALL SPMAJ2_AFIGPECHELON( 6, 777, 35.00, 37.00 ); CALL SPMAJ2_AFIGPECHELON( 7, 852, 0.00, 0.00 ); -- ----- Affectation échelon dans la situation ------ CREATE TABLE IF NOT EXISTS `afigpTMP2012_02a` ( `IDSITU` INTEGER NOT NULL, `UPDATE_OK` TINYINT(1), `IDGRILLE` INTEGER, `IDECHELON` INTEGER, `DTUPDATE` TIMESTAMP, PRIMARY KEY (`IDSITU`) ) COMMENT = 'Carriere: script correction échelon AFIGPSITU'; INSERT IGNORE INTO afigpTMP2012_02a (IDSITU, UPDATE_OK, IDGRILLE, IDECHELON, DTUPDATE) SELECT ID, 0, IDGRILLE, IDECHELON, NOW() FROM AFIGPSITU WHERE IDECHELON = 8 AND IDGRILLE = SFGETVAR_IDGRILLE() AND IDGRILLE IS NOT NULL; UPDATE AFIGPSITU SET IDECHELON = 7 WHERE IDECHELON = 8 AND IDGRILLE = SFGETVAR_IDGRILLE() AND IDGRILLE IS NOT NULL AND ID IN (Select IDSITU From afigpTMP2012_02a Where UPDATE_OK = 0); UPDATE afigpTMP2012_02a SET UPDATE_OK = 1; -- ----- Affectation échelon dans les mouvements de carrière ------ CREATE TABLE IF NOT EXISTS `afigpTMP2012_02b` ( `IDSITU` INTEGER NOT NULL, `UPDATE_OK` TINYINT(1), `IDGRILLE` INTEGER, `IDECHELON` INTEGER, `DTUPDATE` TIMESTAMP, PRIMARY KEY (`IDSITU`) ) COMMENT = 'Carriere: script correction échelon AFIGPSITU'; INSERT IGNORE INTO afigpTMP2012_02b (IDSITU, UPDATE_OK, IDGRILLE, IDECHELON, DTUPDATE) SELECT ID, 0, IDGRILLE, IDECHELON, NOW() FROM AFIGPMVTCAR WHERE IDECHELON = 8 AND IDGRILLE = SFGETVAR_IDGRILLE() AND IDGRILLE IS NOT NULL; UPDATE AFIGPMVTCAR SET IDECHELON = 7 WHERE IDECHELON = 8 AND IDGRILLE = SFGETVAR_IDGRILLE() AND IDGRILLE IS NOT NULL AND ID IN (Select IDSITU From afigpTMP2012_02b Where UPDATE_OK = 0); UPDATE afigpTMP2012_02b SET UPDATE_OK = 1; -- ----- Suppression de l'échelon 8 dans la grille ------ CALL SPDELETE_AFIGPECHELON( 8 ); CALL SPSETVAR_NULL( ); -- ---------------------------------------------------------------------------------------------------------------------------------------------------- -- ---------------- Grille indiciaire du DIRECTEUR GENERAL DES SERVICES d'une commune de 10 000 à 20 000 habitants -------------------------------- -- #4014 CORRECTION de la grille : Actualisation de la grille complète avec les bonnes valeurs. -- Par rapport à l'ancienne grille erronée : L'ancien échelon 1 disparait, toutes les valeurs de l'ancien échelon 2 vont sur l'échelon 1, -- l'ancien 3 vont sur le 2 etc.. et la fin nouvelle affection de l'échelon 9. -- Répercution dans les situations et mouvements de carrière : Affectation de l'échelon en conséquence. -- ---------------------------------------------------------------------------------------------------------------------------------------------------- -- Note : afin que la reconnaissance puisse se faire, ne pas mettre les accentués dans les libellés de grille (cas libellés existants avec accents) CALL SPSETVAR_DATEDEB( NULL ); -- On met en 2ième paramètre 'SG2' parce qu'ici la grille a pour nom le code grade CALL SPSETVAR_GRADE_1('SG2', 'SG2'); -- ----- Correction grille Directeur général des services 10000 à 20000 ------ CALL SPSETVAR_IDGRILLE(SFGETVAR_LBGRADE_1(), SFGETVAR_DATEDEB()); CALL SPMAJ2_AFIGPECHELON( 1, 620, 12.00, 24.00 ); CALL SPMAJ2_AFIGPECHELON( 2, 670, 15.00, 21.00 ); CALL SPMAJ2_AFIGPECHELON( 3, 720, 15.00, 21.00 ); CALL SPMAJ2_AFIGPECHELON( 4, 771, 21.00, 27.00 ); CALL SPMAJ2_AFIGPECHELON( 5, 821, 21.00, 27.00 ); CALL SPMAJ2_AFIGPECHELON( 6, 871, 21.00, 27.00 ); CALL SPMAJ2_AFIGPECHELON( 7, 920, 24.00, 36.00 ); CALL SPMAJ2_AFIGPECHELON( 8, 966, 27.00, 39.00 ); CALL SPMAJ2_AFIGPECHELON( 9, 985, 0.00, 0.00 ); -- ----- Affectation échelon dans la situation ------ CREATE TABLE IF NOT EXISTS `afigpTMP2012_02c` ( `IDSITU` INTEGER NOT NULL, `UPDATE_OK` TINYINT(1), `IDGRILLE` INTEGER, `IDECHELON` INTEGER, `DTUPDATE` TIMESTAMP, PRIMARY KEY (`IDSITU`) ) COMMENT = 'Carriere: script correction échelon AFIGPSITU'; INSERT IGNORE INTO afigpTMP2012_02c (IDSITU, UPDATE_OK, IDGRILLE, IDECHELON, DTUPDATE) SELECT ID, 0, IDGRILLE, IDECHELON, NOW() FROM AFIGPSITU WHERE IDECHELON BETWEEN 2 and 9 AND IDGRILLE = SFGETVAR_IDGRILLE() AND IDGRILLE IS NOT NULL; UPDATE AFIGPSITU SET IDECHELON = 1 WHERE IDECHELON = 2 AND IDGRILLE = SFGETVAR_IDGRILLE() AND IDGRILLE IS NOT NULL AND ID IN (Select IDSITU From afigpTMP2012_02c Where UPDATE_OK = 0); UPDATE AFIGPSITU SET IDECHELON = 2 WHERE IDECHELON = 3 AND IDGRILLE = SFGETVAR_IDGRILLE() AND IDGRILLE IS NOT NULL AND ID IN (Select IDSITU From afigpTMP2012_02c Where UPDATE_OK = 0); UPDATE AFIGPSITU SET IDECHELON = 3 WHERE IDECHELON = 4 AND IDGRILLE = SFGETVAR_IDGRILLE() AND IDGRILLE IS NOT NULL AND ID IN (Select IDSITU From afigpTMP2012_02c Where UPDATE_OK = 0); UPDATE AFIGPSITU SET IDECHELON = 4 WHERE IDECHELON = 5 AND IDGRILLE = SFGETVAR_IDGRILLE() AND IDGRILLE IS NOT NULL AND ID IN (Select IDSITU From afigpTMP2012_02c Where UPDATE_OK = 0); UPDATE AFIGPSITU SET IDECHELON = 5 WHERE IDECHELON = 6 AND IDGRILLE = SFGETVAR_IDGRILLE() AND IDGRILLE IS NOT NULL AND ID IN (Select IDSITU From afigpTMP2012_02c Where UPDATE_OK = 0); UPDATE AFIGPSITU SET IDECHELON = 6 WHERE IDECHELON = 7 AND IDGRILLE = SFGETVAR_IDGRILLE() AND IDGRILLE IS NOT NULL AND ID IN (Select IDSITU From afigpTMP2012_02c Where UPDATE_OK = 0); UPDATE AFIGPSITU SET IDECHELON = 7 WHERE IDECHELON = 8 AND IDGRILLE = SFGETVAR_IDGRILLE() AND IDGRILLE IS NOT NULL AND ID IN (Select IDSITU From afigpTMP2012_02c Where UPDATE_OK = 0); UPDATE AFIGPSITU SET IDECHELON = 8 WHERE IDECHELON = 9 AND IDGRILLE = SFGETVAR_IDGRILLE() AND IDGRILLE IS NOT NULL AND ID IN (Select IDSITU From afigpTMP2012_02c Where UPDATE_OK = 0); UPDATE afigpTMP2012_02c SET UPDATE_OK = 1; -- ----- Affectation échelon dans les mouvements de carrière ------ CREATE TABLE IF NOT EXISTS `afigpTMP2012_02d` ( `IDSITU` INTEGER NOT NULL, `UPDATE_OK` TINYINT(1), `IDGRILLE` INTEGER, `IDECHELON` INTEGER, `DTUPDATE` TIMESTAMP, PRIMARY KEY (`IDSITU`) ) COMMENT = 'Carriere: script correction échelon AFIGPMVTCAR'; INSERT IGNORE INTO afigpTMP2012_02d (IDSITU, UPDATE_OK, IDGRILLE, IDECHELON, DTUPDATE) SELECT ID, 0, IDGRILLE, IDECHELON, NOW() FROM AFIGPMVTCAR WHERE IDECHELON BETWEEN 2 and 9 AND IDGRILLE = SFGETVAR_IDGRILLE() AND IDGRILLE IS NOT NULL; UPDATE AFIGPMVTCAR SET IDECHELON = 1 WHERE IDECHELON = 2 AND IDGRILLE = SFGETVAR_IDGRILLE() AND IDGRILLE IS NOT NULL AND ID IN (Select IDSITU From afigpTMP2012_02d Where UPDATE_OK = 0); UPDATE AFIGPMVTCAR SET IDECHELON = 2 WHERE IDECHELON = 3 AND IDGRILLE = SFGETVAR_IDGRILLE() AND IDGRILLE IS NOT NULL AND ID IN (Select IDSITU From afigpTMP2012_02d Where UPDATE_OK = 0); UPDATE AFIGPMVTCAR SET IDECHELON = 3 WHERE IDECHELON = 4 AND IDGRILLE = SFGETVAR_IDGRILLE() AND IDGRILLE IS NOT NULL AND ID IN (Select IDSITU From afigpTMP2012_02d Where UPDATE_OK = 0); UPDATE AFIGPMVTCAR SET IDECHELON = 4 WHERE IDECHELON = 5 AND IDGRILLE = SFGETVAR_IDGRILLE() AND IDGRILLE IS NOT NULL AND ID IN (Select IDSITU From afigpTMP2012_02d Where UPDATE_OK = 0); UPDATE AFIGPMVTCAR SET IDECHELON = 4 WHERE IDECHELON = 5 AND IDGRILLE = SFGETVAR_IDGRILLE() AND IDGRILLE IS NOT NULL AND ID IN (Select IDSITU From afigpTMP2012_02d Where UPDATE_OK = 0); UPDATE AFIGPMVTCAR SET IDECHELON = 6 WHERE IDECHELON = 7 AND IDGRILLE = SFGETVAR_IDGRILLE() AND IDGRILLE IS NOT NULL AND ID IN (Select IDSITU From afigpTMP2012_02d Where UPDATE_OK = 0); UPDATE AFIGPMVTCAR SET IDECHELON = 7 WHERE IDECHELON = 8 AND IDGRILLE = SFGETVAR_IDGRILLE() AND IDGRILLE IS NOT NULL AND ID IN (Select IDSITU From afigpTMP2012_02d Where UPDATE_OK = 0); UPDATE AFIGPMVTCAR SET IDECHELON = 8 WHERE IDECHELON = 9 AND IDGRILLE = SFGETVAR_IDGRILLE() AND IDGRILLE IS NOT NULL AND ID IN (Select IDSITU From afigpTMP2012_02d Where UPDATE_OK = 0); UPDATE afigpTMP2012_02d SET UPDATE_OK = 1; CALL SPSETVAR_NULL( ); -- ---------------------------------------------------------------------------------------------------------------------------------------------------- -- ---------------- Conditions d'avancement du CADRE D'EMPLOI DES ATTACHES -------------------------------- -- #1875 Créations nouvelles conditions d'avancement Attaché vers Attaché principal et Attaché principal vers Directeur territorial -- Archivage des anciennes conditions d'avancement lié à ce cadre d'emploi -- ---------------------------------------------------------------------------------------------------------------------------------------------------- UPDATE AFIGPAVGRADE SET ARCHIVE = 1, DTE_FIN = '2008-12-31' WHERE GRADE_A ='AT' AND GRADE_N ='ATP2'; UPDATE AFIGPAVGRADE SET ARCHIVE = 1, DTE_FIN = '2008-12-31' WHERE GRADE_A ='ATP1' AND GRADE_N ='DT'; UPDATE AFIGPAVGRADE SET ARCHIVE = 1, DTE_FIN = '2008-12-31' WHERE GRADE_A ='ATP2' AND GRADE_N ='ATP1'; -- Note : afin que la reconnaissance puisse se faire, ne pas mettre les accentués dans les libellés de grille (cas libellés existants avec accents) CALL SPSETVAR_DATEDEB( '2009-01-01' ); CALL SPSETVAR_GRADE_0('AT', 'Attache'); CALL SPSETVAR_GRADE_1('ATP', 'Attache principal'); CALL SPSETVAR_GRADE_2('DT', 'Directeur territorial'); -- ----------------------------------------------------- -- AFIGPAVGRADE -- ----------------------------------------------------- INSERT INTO AFIGPAVGRADE (GRADE_A, GRADE_N, ECH_MINI, AGE_MINI, AGE_MAXI, ANC_CADRE, ANC_GRADE, ANC_ECH, EXAMEN, ARCHIVE, DTE_DEB, PROMOTION) SELECT SFGETVAR_IDGRADE_0(), SFGETVAR_IDGRADE_1(), 5, 0, 0, 36, 0, 12, 1, 0, SFGETVAR_DATEDEB(), 0 FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM AFIGPAVGRADE WHERE GRADE_A = SFGETVAR_IDGRADE_0() AND GRADE_N = SFGETVAR_IDGRADE_1() AND EXAMEN = 1); INSERT INTO AFIGPAVGRADE (GRADE_A, GRADE_N, ECH_MINI, AGE_MINI, AGE_MAXI, ANC_CADRE, ANC_GRADE, ANC_ECH, EXAMEN, ARCHIVE, DTE_DEB, PROMOTION) SELECT SFGETVAR_IDGRADE_0(), SFGETVAR_IDGRADE_1(), 9, 0, 0, 84, 0, 12, 0, 0, SFGETVAR_DATEDEB(), 0 FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM AFIGPAVGRADE WHERE GRADE_A = SFGETVAR_IDGRADE_0() AND GRADE_N = SFGETVAR_IDGRADE_1() AND EXAMEN = 0); INSERT INTO AFIGPAVGRADE (GRADE_A, GRADE_N, ECH_MINI, AGE_MINI, AGE_MAXI, ANC_CADRE, ANC_GRADE, ANC_ECH, EXAMEN, ARCHIVE, DTE_DEB, PROMOTION) SELECT SFGETVAR_IDGRADE_1(), SFGETVAR_IDGRADE_2(), 0, 0, 0, 0, 48, 0, 0, 0, SFGETVAR_DATEDEB(), 0 FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM AFIGPAVGRADE WHERE GRADE_A = SFGETVAR_IDGRADE_1() AND GRADE_N = SFGETVAR_IDGRADE_2() AND EXAMEN = 0); CALL SPSETVAR_NULL( ); -- +++++++++++++++++++++++++++++++++++++++++++++++++++++++++ SUPPRESSION PROCEDURES STOCKEES ++++++++++++++++++++++++++++++++++++++++++++++++++++++++ CALL SPSETVAR_NULL( ); DROP PROCEDURE SPINITLOG; DROP PROCEDURE SPLOG; DROP PROCEDURE SPSETVAR_IDGRILLE; DROP PROCEDURE SPCRE_AFIGPECHELON; DROP PROCEDURE SPMAJ_AFIGPECHELON; DROP PROCEDURE SPMAJ2_AFIGPECHELON; DROP PROCEDURE SPDELETE_AFIGPECHELON; DROP PROCEDURE SPSETVAR_NULL; DROP PROCEDURE SPSETVAR_DATEDEB; DROP PROCEDURE SPSETVAR_CAEMP; DROP PROCEDURE SPSETVAR_GRADE_0; DROP PROCEDURE SPSETVAR_GRADE_1; DROP PROCEDURE SPSETVAR_GRADE_2; DROP PROCEDURE SPSETVAR_GRADE_3; DROP PROCEDURE SPSETVAR_GRADE_4; DROP PROCEDURE SPSETVAR_GRADE_5; DROP PROCEDURE SPSETVAR_GRADE_6; DROP PROCEDURE SPSETVAR_GRADE_7; DROP PROCEDURE SPSETVAR_GRADE_8; DROP PROCEDURE SPSETVAR_GRADE_9; DROP FUNCTION SFGETIDBRUT; DROP FUNCTION SFGETVAR_DATEDEB; DROP FUNCTION SFGETVAR_IDCAEMP; DROP FUNCTION SFGETVAR_LIBCAEMP; DROP FUNCTION SFGETVAR_LBGRADE_0; DROP FUNCTION SFGETVAR_IDGRADE_0; DROP FUNCTION SFGETVAR_LBGRADE_1; DROP FUNCTION SFGETVAR_IDGRADE_1; DROP FUNCTION SFGETVAR_LBGRADE_2; DROP FUNCTION SFGETVAR_IDGRADE_2; DROP FUNCTION SFGETVAR_LBGRADE_3; DROP FUNCTION SFGETVAR_IDGRADE_3; DROP FUNCTION SFGETVAR_LBGRADE_4; DROP FUNCTION SFGETVAR_IDGRADE_4; DROP FUNCTION SFGETVAR_LBGRADE_5; DROP FUNCTION SFGETVAR_IDGRADE_5; DROP FUNCTION SFGETVAR_LBGRADE_6; DROP FUNCTION SFGETVAR_IDGRADE_6; DROP FUNCTION SFGETVAR_LBGRADE_7; DROP FUNCTION SFGETVAR_IDGRADE_7; DROP FUNCTION SFGETVAR_LBGRADE_8; DROP FUNCTION SFGETVAR_IDGRADE_8; DROP FUNCTION SFGETVAR_LBGRADE_9; DROP FUNCTION SFGETVAR_IDGRADE_9; -- +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -- --------------------------------------------------------------------------------------------------------------------------------------------------- -- Met en archive les événements liés à un changement d'indice brut qui ont une ancienne valeur à zéro ou une nouvelle valeur à zéro -- --------------------------------------------------------------------------------------------------------------------------------------------------- UPDATE AFIGPEVSITUL SET ARCHIVE = 1 WHERE ARCHIVE = 0 AND ID IN (SELECT IDEV FROM AFIGPEVSITU WHERE COLONNE = 'afigpbrutmaj.brut' AND (ANCVALEUR = 0 OR NOUVALEUR = 0 ) ); SET SQL_MODE=@OLD_SQL_MODE; SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS; SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;