USP_R68_CLEARRESULTS

Executes the "R68 Process: Clear Results" record operation.

Parameters

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

Definition

Copy



create procedure dbo.USP_R68_CLEARRESULTS
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier
)
as
    set nocount on;

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

    declare @CHANGEDATE as datetime = getDate();

    begin try
        update dbo.REVENUESPLITGIFTAID set
            PENDINGR68STATUSID = null,
            CHANGEDBYID = @CHANGEAGENTID,
            DATECHANGED = @CHANGEDATE
        where PENDINGR68STATUSID = @ID;

        update dbo.REVENUESPLITGIFTAIDREFUND set
            PENDINGR68STATUSID = null,
            CHANGEDBYID = @CHANGEAGENTID,
            DATECHANGED = @CHANGEDATE
        where PENDINGR68STATUSID = @ID;

        -- update the status

        update dbo.BUSINESSPROCESSSTATUS set
            STATUSCODE = 3,
            CHANGEDBYID = @CHANGEAGENTID,
            DATECHANGED = @CHANGEDATE
        where ID = @ID;

    end try

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