1 2 3 4 5 6 7 8 9 10 11
| CREATE OR REPLACE TRIGGER SIR.TRG_V_SIR_PROG_PRIO_U_STA_NO_N
INSTEAD OF UPDATE ON SIR.V_SIR_PROG_PRIORISATION REFERENCING
NEW AS NEW
OLD AS OLD
FOR EACH ROW
BEGIN
IF :OLD.STATUT='N' THEN
UPDATE SIR_PROG_GL_OP_GENERAL SET STATUT=:NEW.STATUT,PRIORITE_MAND=:NEW.PRIORITE_MAND,ANNEE_PROG=:NEW.ANNEE_PROG,OBJET=:NEW.OBJET,NATURE=:NEW.NATURE,ESTIMATION=:NEW.ESTIMATION,CONVENTION=:NEW.CONVENTION,OBSERVATION_MAND=:NEW.OBSERVATION_MAND,OBSERVATION_TEMP=:NEW.OBSERVATION_TEMP,COP=:NEW.COP,MOE_ETUDE=:NEW.MOE_ETUDE,MOE_TRAVAUX=:NEW.MOE_TRAVAUX,MODE_DEVOLUTION_PRINCIPALE=:NEW.MODE_DEVOLUTION_PRINCIPALE,ETAT_AVANCEMENT=:NEW.ETAT_AVANCEMENT,DATE_DEBUT_TRAVAUX=:NEW.DATE_DEBUT_TRAVAUX,PROCEDURE_LOI_EAU=:NEW.PROCEDURE_LOI_EAU,PROCEDURE_FONCIER=:NEW.PROCEDURE_FONCIER,PROCEDURE_AUTRE=:NEW.PROCEDURE_AUTRE,PROCEDURE_DESC=:NEW.PROCEDURE_DESC,RISQUE=:NEW.RISQUE,UTILISATEUR_MODIF=:NEW.UTILISATEUR_MODIF,DATE_MODIF=:NEW.DATE_MODIF WHERE ID_SIR_PROG_GL_OP_GENERAL=:NEW.ID_SIR_PROG_GL_OP_GENERAL;
END IF;
END;
/ |
Partager