USP_BUSINESSPROCESSINSTANCE_DELETE
Deletes an instance of a business process.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @BUSINESSPROCESSCATALOGID | uniqueidentifier | IN | |
| @BUSINESSPROCESSPARAMETERSETID | uniqueidentifier | IN | |
| @CHANGEAGENTID | uniqueidentifier | IN |
Definition
Copy
CREATE procedure dbo.USP_BUSINESSPROCESSINSTANCE_DELETE(
@BUSINESSPROCESSCATALOGID uniqueidentifier,
@BUSINESSPROCESSPARAMETERSETID uniqueidentifier,
@CHANGEAGENTID uniqueidentifier
)
as
begin
set nocount on;
declare @ID uniqueidentifier;
select @ID = ID from dbo.BUSINESSPROCESSINSTANCE
where BUSINESSPROCESSCATALOGID = @BUSINESSPROCESSCATALOGID and BUSINESSPROCESSPARAMETERSETID = @BUSINESSPROCESSPARAMETERSETID;
exec dbo.USP_BUSINESSPROCESSINSTANCE_DELETEBYID_WITHCHANGEAGENTID @ID, @CHANGEAGENTID;
return 0;
end