USP_BUSINESSPROCESSINSTANCE_ADD

Creates an instance of a business process.

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	INOUT
@CHANGEAGENTID	uniqueidentifier	IN
@BUSINESSPROCESSCATALOGID	uniqueidentifier	IN
@BUSINESSPROCESSPARAMETERSETID	uniqueidentifier	IN
@SECURITYLEVEL	tinyint	IN
@OWNERID	uniqueidentifier	IN
@SITEID	uniqueidentifier	IN

Definition

Copy



        CREATE procedure dbo.USP_BUSINESSPROCESSINSTANCE_ADD(
            @ID uniqueidentifier = null output,                        
            @CHANGEAGENTID uniqueidentifier = null,                        
            @BUSINESSPROCESSCATALOGID uniqueidentifier = null,
            @BUSINESSPROCESSPARAMETERSETID uniqueidentifier = null,
            @SECURITYLEVEL tinyint = 0,
            @OWNERID uniqueidentifier = null,
            @SITEID uniqueidentifier = null
        )
        as

        set nocount on;
        declare @CURRENTDATE datetime;
        set @CURRENTDATE = getdate();

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

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

        begin try                        
            insert into dbo.BUSINESSPROCESSINSTANCE 
                (ID, 
                BUSINESSPROCESSCATALOGID, 
                BUSINESSPROCESSPARAMETERSETID, 
                SECURITYLEVEL, 
                OWNERID,             
                ADDEDBYID, 
                CHANGEDBYID, 
                DATEADDED, 
                DATECHANGED,
                SITEID)
            values
                (@ID,
                @BUSINESSPROCESSCATALOGID,
                @BUSINESSPROCESSPARAMETERSETID,
                @SECURITYLEVEL,
                @OWNERID,
                @CHANGEAGENTID,
                @CHANGEAGENTID,
                @CURRENTDATE,
                @CURRENTDATE,
                @SITEID)
        end try

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

        return 0;