Temporary Procedure extract

gistfile1.sql

USE sara_db
go
IF OBJECT_ID('dbo.proc_diu_tmp_doc_ent_comp') IS NOT NULL
BEGIN
    DROP PROCEDURE dbo.proc_diu_tmp_doc_ent_comp
    IF OBJECT_ID('dbo.proc_diu_tmp_doc_ent_comp') IS NOT NULL
        PRINT '<<< FAILED DROPPING PROCEDURE dbo.proc_diu_tmp_doc_ent_comp >>>'
    ELSE
        PRINT '<<< DROPPED PROCEDURE dbo.proc_diu_tmp_doc_ent_comp >>>'
END
go

CREATE PROCEDURE dbo.proc_diu_tmp_doc_ent_comp                       
(    
    @w_operacao             int,                     
    @w_dent_id              char(30), 
    @w_cid_id               int     = NULL,                     
    @w_dent_com_ie          char(25)= NULL, 
    @w_dent_com_total_ipi   numeric(18,4), 
    @w_dent_com_total_icms  numeric(18,4), 
    @w_dent_com_id_entrada  int, 
    @w_dent_com_total_vlr   numeric(18,4) 
)                    
AS             
begin 
    declare  
        @w_dent_com_id int      
         
    select @w_dent_com_id = isnull(max(dent_com_id),0)+1 from tab_tmp_doc_entrada_comp--Incrementa  
       
    BEGIN TRAN trandoc_ent_complemento              
                       
    if @w_operacao = 1/* Delete */                    
    begin                     
        delete from tab_tmp_doc_entrada_comp                      
        where dent_com_id = @w_dent_com_id_entrada          
    end                   
                     
    if @w_operacao = 2/* Insert */                     
    begin                     
        insert tab_tmp_doc_entrada_comp( 
            dent_com_id,  
            dent_id,  
            cid_id,  
            dent_com_ie,  
            dent_com_total_ipi,  
            dent_com_total_icms, 
            dent_com_total_vlr)         
        values( 
            @w_dent_com_id,  
            @w_dent_id,  
            @w_cid_id,  
            @w_dent_com_ie,  
            @w_dent_com_total_ipi,  
            @w_dent_com_total_icms, 
            @w_dent_com_total_vlr)               
    end                     
      
    if @w_operacao = 3/* Update */ 
    begin 
        update tab_tmp_doc_entrada_comp  
        set cid_id                = @w_cid_id, 
            dent_com_ie           = @w_dent_com_ie, 
            dent_com_total_ipi    = @w_dent_com_total_ipi, 
            dent_com_total_icms   = @w_dent_com_total_icms, 
            dent_com_total_vlr    = @w_dent_com_total_vlr 
        where dent_com_id         = @w_dent_com_id_entrada      
    end              
                     
   if @@error <> 0   
   begin   
      raiserror('Operacao Invalida. Verifique',16,0)
      ROLLBACK TRAN trandoc_ent_complemento   
      return 1   
   end   
    
   COMMIT TRAN trandoc_ent_complemento   
   return 0   
end
go
IF OBJECT_ID('dbo.proc_diu_tmp_doc_ent_comp') IS NOT NULL
    PRINT '<<< CREATED PROCEDURE dbo.proc_diu_tmp_doc_ent_comp >>>'
ELSE
    PRINT '<<< FAILED CREATING PROCEDURE dbo.proc_diu_tmp_doc_ent_comp >>>'
go