USP_DATAFORMTEMPLATE_ADD_AWARDMANAGEMENTINTEGRATIONPROCESS

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

            if @ID is null
              set @ID = newid();

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

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

            begin try
              insert into dbo.AWARDMANAGEMENTINTEGRATIONPROCESS
              (
                ID, 
                NAME, 
                DESCRIPTION, 
                INTEGRATIONTYPECODE, 
                ADDEDBYID, 
                CHANGEDBYID, 
                DATEADDED, 
                DATECHANGED
              )
              values
              (
                @ID, 
                @NAME, 
                @DESCRIPTION, 
                @INTEGRATIONTYPECODE, 
                @CHANGEAGENTID, 
                @CHANGEAGENTID, 
                @CURRENTDATE, 
                @CURRENTDATE
              );

              exec dbo.USP_BUSINESSPROCESSINSTANCE_ADD 
                @CHANGEAGENTID = @CHANGEAGENTID, 
                @BUSINESSPROCESSCATALOGID = '015AAEEE-E1D8-4CD3-98C6-CD5046BC9CEB', 
                @BUSINESSPROCESSPARAMETERSETID = @ID, 
                @OWNERID = @CURRENTAPPUSERID;

            end try
            begin catch
              exec dbo.USP_RAISE_ERROR;
              return 1;
            end catch

            return 0;