USP_BBWORKFLOW_WORKFLOW_INSTANCE_UPDATE_STATUS

Updates the completion status of a BBWORKFLOWINSTANCEINFO record.

Parameters

Parameter	Parameter Type	Mode
@BBWORKFLOWINSTANCEINFOID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@COMPLETIONSTATECODE	tinyint	IN
@REASON	nvarchar(max)	IN

Definition

Copy



create procedure dbo.USP_BBWORKFLOW_WORKFLOW_INSTANCE_UPDATE_STATUS

@BBWORKFLOWINSTANCEINFOID uniqueidentifier,
@CHANGEAGENTID uniqueidentifier = null,
@COMPLETIONSTATECODE tinyint ,
@REASON nvarchar(max)

/*
Updates the completion status of a BBWORKFLOWINSTANCEINFO record.
*/

as

    set nocount on;

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

    declare @r int;


    if @COMPLETIONSTATECODE=1
    BEGIN
    exec @r=dbo.USP_BBWORKFLOW_WORKFLOW_INSTANCE_UPDATE_STATUS_COMPLETED @BBWORKFLOWINSTANCEINFOID, @CHANGEAGENTID;
    return @r;
    END;

    if @COMPLETIONSTATECODE=2
    BEGIN
    exec @r=dbo.USP_BBWORKFLOW_WORKFLOW_INSTANCE_UPDATE_STATUS_CANCELLED @BBWORKFLOWINSTANCEINFOID, @CHANGEAGENTID, @REASON;
    return @r;
    END;


    if @COMPLETIONSTATECODE=3
    BEGIN
    exec @r=dbo.USP_BBWORKFLOW_WORKFLOW_INSTANCE_UPDATE_STATUS_FAULTED @BBWORKFLOWINSTANCEINFOID, @CHANGEAGENTID, @REASON;
    return @r;
    END;


    return 500;