USP_BUSINESSPROCESS_PARAMETERSETCANBEDELETED

CREATE procedure dbo.USP_BUSINESSPROCESS_PARAMETERSETCANBEDELETED
(
    @STATUSTABLENAME nvarchar(128), 
    @PARAMETERSETID uniqueidentifier
)
with execute AS CALLER
as
begin
    set nocount on

    exec dbo.USP_BUSINESSPROCESSSTATUS_VALIDATESTATUS;

    declare @SQL nvarchar(500)
    set @SQL = 'select @STATUS_OUT = BUSINESSPROCESSSTATUS.STATUSCODE from dbo.BUSINESSPROCESSSTATUS inner join dbo.' + @STATUSTABLENAME + ' as PARAMETERSTATUS on PARAMETERSTATUS.ID = BUSINESSPROCESSSTATUS.ID where PARAMETERSTATUS.PARAMETERSETID = @PARAMETERSETID_IN';

    declare @PARAMETERS nvarchar(500)
    set @PARAMETERS = '@PARAMETERSETID_IN uniqueidentifier, @STATUS_OUT tinyint output';

    declare @STATUSCODE tinyint
    exec sp_executesql @SQL, @PARAMETERS, @PARAMETERSETID_IN = @PARAMETERSETID, @STATUS_OUT = @STATUSCODE output;

    if @STATUSCODE = 1 begin
        raiserror('The parameter set cannot be deleted because the process is currently running.', 13, 1)
    end
end