USP_FEPSUBMITPROCESS_DELETE

Executes the "Fundraising Effectiveness Project Submit Process: 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_FEPSUBMITPROCESS_DELETE
        (
            @ID uniqueidentifier,
            @CHANGEAGENTID uniqueidentifier
        )
        as
            set nocount on;

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

            begin try
                declare @FEPPROCESSID uniqueidentifier;

                select 
                    @FEPPROCESSID = FEPPROCESSID
                from dbo.FEPSUBMITPROCESS
                where ID = @ID;

                exec dbo.USP_BUSINESSPROCESSINSTANCE_DELETE 'cad79b29-5309-4650-b452-d03f379bdc60', @ID, @CHANGEAGENTID;

                exec dbo.USP_FEPPROCESS_DELETEBYID_WITHCHANGEAGENTID @FEPPROCESSID, @CHANGEAGENTID;
                return 0;
            end try

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

            return 0;