USP_DATAFORMTEMPLATE_EDITLOAD_AWARDMANAGEMENTINTEGRATIONPROCESS

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@DATALOADED	bit	INOUT
@TSLONG	bigint	INOUT
@NAME	nvarchar(100)	INOUT
@DESCRIPTION	nvarchar(255)	INOUT
@INTEGRATIONTYPECODE	tinyint	INOUT

Definition

Copy



          CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_AWARDMANAGEMENTINTEGRATIONPROCESS
          (
            @ID uniqueidentifier,
            @DATALOADED bit = 0 output,
            @TSLONG bigint = 0 output,
            @NAME nvarchar(100) = null output,
            @DESCRIPTION nvarchar(255) = null output,
            @INTEGRATIONTYPECODE tinyint = null output
          )
          as
            set nocount on;

            select
              @DATALOADED = 0,
              @TSLONG = 0;

            select
              @DATALOADED = 1,
              @TSLONG = AWARDMANAGEMENTINTEGRATIONPROCESS.TSLONG,
              @NAME = NAME,
              @DESCRIPTION = DESCRIPTION,
              @INTEGRATIONTYPECODE = INTEGRATIONTYPECODE
            from 
              dbo.AWARDMANAGEMENTINTEGRATIONPROCESS
            where 
              ID = @ID;

            return 0;