• Home
• it.cnr.si.sigla
• sigla-backend
• 6.6.4
• source code
• bd_movimento_coge.trg

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

expsigladb.Trigger.bd_movimento_coge.trg Maven / Gradle / Ivy

CREATE OR REPLACE TRIGGER BD_MOVIMENTO_COGE
  BEFORE Delete
  ON MOVIMENTO_COGE
  FOR EACH ROW
DISABLE
Declare
aCHIUSURA CHIUSURA_COEP%rowtype;
tipo   VARCHAR2(20);
Begin

aCHIUSURA := cnrctb200.getChiusuraCoep(:old.Esercizio, :old.Cd_Cds);


 IF aCHIUSURA.stato in ('C', 'P') Then

  If aCHIUSURA.stato = 'C' Then
    tipo := 'Definitivamente';
  Elsif  aCHIUSURA.stato = 'P' Then
    tipo := 'Provvisoriamente';
  End If;

  IBMERR001.RAISE_ERR_GENERICO('Il CDS '||:old.cd_cds||' risulta chiuso '||tipo||' in Economica. Cancellazione non possibile.');
 END IF;
END;
/