USP_DATAFORMTEMPLATE_VIEW_AWARDMANAGEMENTINTEGRATIONPROCESS

Parameters

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

Definition

Copy



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

          -- be sure to set this, in case the select returns no rows

          set @DATALOADED = 0;

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

          return 0;