USP_DATAFORMTEMPLATE_PRELOAD_BATCHWORKFLOWTASK

The load procedure used by the edit dataform template "Batch Workflow Task Add Form"

Parameters

Parameter Parameter Type Mode Description
@BATCHWORKFLOWSTATEID uniqueidentifier IN Input parameter indicating the context ID for the record being added.
@BATCHWORKFLOWID uniqueidentifier INOUT Batch workflow id
@BATCHWORKFLOWSTATE nvarchar(100) INOUT Current state

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_PRELOAD_BATCHWORKFLOWTASK
(
@BATCHWORKFLOWSTATEID uniqueidentifier,
@BATCHWORKFLOWID uniqueidentifier = null output,
@BATCHWORKFLOWSTATE nvarchar(100) = null output
)
as
set nocount on;                    
select @BATCHWORKFLOWID=BATCHWORKFLOWID, @BATCHWORKFLOWSTATE=NAME from dbo.BATCHWORKFLOWSTATE where ID = @BATCHWORKFLOWSTATEID;