CREATE OR REPLACE PROCEDURE APAGA_ANALISERECEITAM
(P_CDFILIAL IN VARCHAR2, 
 P_NRGERACAO IN NUMBER
)
AS
BEGIN
   DELETE FROM ANALISERECMCUSTO 
    WHERE CDFILIAL = P_CDFILIAL
      AND NRGERACAO = P_NRGERACAO;    
      
   DELETE FROM ANALISERECMPROD 
    WHERE CDFILIAL = P_CDFILIAL
      AND NRGERACAO = P_NRGERACAO;
      
   DELETE FROM ANALISERECM 
    WHERE CDFILIAL = P_CDFILIAL
      AND NRGERACAO = P_NRGERACAO;
END;
/