USP_STEWARDSHIPPACKAGEPROCESS_DELETE

Executes the "Stewardship Package: Delete" record operation.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	Input parameter indicating the ID of the record being deleted.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the delete.

Definition

Copy



                CREATE procedure dbo.USP_STEWARDSHIPPACKAGEPROCESS_DELETE
                (
                    @ID uniqueidentifier,
                    @CHANGEAGENTID uniqueidentifier
                )
                as 
                    set nocount on;

                    --check deletion rules

                    declare @NUMPURPOSES int;

                    select @NUMPURPOSES = count(*) 
                    from dbo.DESIGNATIONLEVEL
                    where DESIGNATIONLEVEL.STEWARDSHIPPACKAGEPROCESSID = @ID;

                    if @NUMPURPOSES > 0
                    begin
                        raiserror('This stewardship package has associated purposes and cannot be deleted.', 13, 1);
                        return 0;
                    end

                    exec dbo.USP_BUSINESSPROCESS_PARAMETERSETCANBEDELETED 'STEWARDSHIPPACKAGEPROCESSSTATUS', @ID;

                    exec dbo.USP_BUSINESSPROCESSINSTANCE_DELETE 'B4184ABE-C618-466F-90A2-B96B88644A17', @ID, @CHANGEAGENTID;

                    exec dbo.USP_BUSINESSPROCESSCOMMPREF_DELETE 'B4184ABE-C618-466F-90A2-B96B88644A17', @ID, @CHANGEAGENTID;                    

                    exec dbo.USP_STEWARDSHIPPACKAGEPROCESS_DELETEBYID_WITHCHANGEAGENTID @ID, @CHANGEAGENTID;
                    return 0;