USP_DATAFORMTEMPLATE_EDIT_AWARDMANAGEMENTINTEGRATIONPROCESS

          CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_AWARDMANAGEMENTINTEGRATIONPROCESS
          (
            @ID uniqueidentifier,
            @CHANGEAGENTID uniqueidentifier = null,
            @NAME nvarchar(100),
            @DESCRIPTION nvarchar(255),
            @INTEGRATIONTYPECODE tinyint
          )
          as
            set nocount on;

            declare @CURRENTDATE datetime;
            set @CURRENTDATE = getdate();

            if @CHANGEAGENTID is null  
              exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

            begin try
              update 
                dbo.AWARDMANAGEMENTINTEGRATIONPROCESS 
              set 
                NAME = @NAME,
                DESCRIPTION = @DESCRIPTION,
                INTEGRATIONTYPECODE = @INTEGRATIONTYPECODE,
                DATECHANGED = @CURRENTDATE,
                CHANGEDBYID = @CHANGEAGENTID
              where 
                ID = @ID;
            end try                    
            begin catch
              exec dbo.USP_RAISE_ERROR;
              return 1;
            end catch

            return 0;