DROP PROCEDURE  IF EXISTS uspUpdateNapTipus 
GO
  CREATE PROCEDURE uspUpdateNapTipus
  
   @pIsSorszamozando CHAR(1)
  ,@pIsTanorai CHAR(1)
  ,@pIsTanorankivuli CHAR(1)
  ,@pIsLeNemKotottMunkaido  CHAR(1)
  ,@pId INT
  ,@pIntezmenyId INT
  ,@pTanevId INT
  ,@pUserId INT
  AS
  BEGIN
    SET NOCOUNT ON;  
      UPDATE
            T_NAPTIPUS_OSSZES
          SET
            C_ISSORSZAMOZANDO = @pIsSorszamozando
            ,C_ISTANORAI = @pIsTanorai
            ,C_ISTANORANKIVULI = @pIsTanorankivuli
            ,C_ISLENEMKOTOTTMUNKAIDO = @pIsLeNemKotottMunkaido
            ,SERIAL = SERIAL + 1
            ,LASTCHANGED = GETDATE()
            ,MODIFIER = @pUserId
          WHERE
            ID = @pId AND
            C_ALINTEZMENYID = @pIntezmenyId AND
            C_ALTANEVID = @pTanevId
    
  END
GO