USP_DATAFORMTEMPLATE_EDIT_PURGECHECK

The save procedure used by the edit dataform template "Bank Account Disbursement Transaction Purge Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@REVERSALPOSTDATETYPECODE	tinyint	IN	Reversal post date
@REVERSALPOSTDATE	datetime	IN
@VOIDDATE	datetime	IN
@VOIDDATETYPECODE	tinyint	IN	Purge date
@CONSTITUENTID	uniqueidentifier	IN
@AMOUNT	money	IN
@DESCRIPTION	nvarchar(100)	IN
@TRANSACTIONS	xml	IN

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_PURGECHECK (
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @REVERSALPOSTDATETYPECODE tinyint,
    @REVERSALPOSTDATE datetime,
    @VOIDDATE datetime,
    @VOIDDATETYPECODE tinyint,
    @CONSTITUENTID uniqueidentifier,
    @AMOUNT money,
    @DESCRIPTION nvarchar(100),
    @TRANSACTIONS xml
)

as
    if exists(select * from dbo.BANKACCOUNTTRANSACTION BAT where BAT.ID = @ID and BAT.STATUSCODE != 4)
        exec dbo.USP_DATAFORMTEMPLATE_EDIT_VOIDCHECK
            @ID,
            @CHANGEAGENTID,
            @REVERSALPOSTDATETYPECODE,
            @REVERSALPOSTDATE,
            @VOIDDATE,
            @VOIDDATETYPECODE,
            @CONSTITUENTID,
            @AMOUNT,
            @DESCRIPTION,
            @TRANSACTIONS;

    -- put the ID in to the generic ID table
    declare @BANKACCOUNTTRANSACTIONIDS as udt_genericid;
    insert into @BANKACCOUNTTRANSACTIONIDS(ID) values(@ID);

    -- Purge - flag the bank account transaction and related financial transaction as deleted
    exec dbo.USP_BANKACCOUNTDISBURSEMENTS_PURGE @BANKACCOUNTTRANSACTIONIDS, @CHANGEAGENTID

    -- handle deleting the transactions
    exec dbo.USP_BANKACCOUNTDISBURSEMENTS_TRANSACTIONS_DELETE @TRANSACTIONS, @ID, @CHANGEAGENTID

return 0;