USP_DATAFORMTEMPLATE_EDIT_GIFTAIDGLDISTRIBUTIONADJUST

The save procedure used by the edit dataform template "Posted Gift Aid GL Distribution Edit Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@GLDISTRIBUTION	xml	IN	Gift aid GL distribution
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_GIFTAIDGLDISTRIBUTIONADJUST
(
    @ID uniqueidentifier,
    @GLDISTRIBUTION xml,
    @CHANGEAGENTID uniqueidentifier = null
)
as

    set nocount on;

    declare @ADJUSTMENTDATE datetime,
        @ADJUSTMENTPOSTDATE datetime,
        @ADJUSTMENTREASON nvarchar(300),
        @ADJUSTMENTREASONCODEID uniqueidentifier

    exec USP_DATAFORMTEMPLATE_EDITLOAD_GIFTAIDGLDISTRIBUTIONADJUST_2 @ID = @ID output,
        @GLDISTRIBUTION = @GLDISTRIBUTION output,
        @ADJUSTMENTDATE = @ADJUSTMENTDATE output,
        @ADJUSTMENTPOSTDATE = @ADJUSTMENTPOSTDATE output,
        @ADJUSTMENTREASON = @ADJUSTMENTREASON output,
        @ADJUSTMENTREASONCODEID = @ADJUSTMENTREASONCODEID output

    exec USP_DATAFORMTEMPLATE_EDIT_GIFTAIDGLDISTRIBUTIONADJUST_2 @ID = @ID,
        @GLDISTRIBUTION = @GLDISTRIBUTION,
        @ADJUSTMENTDATE = @ADJUSTMENTDATE,
        @ADJUSTMENTPOSTDATE = @ADJUSTMENTPOSTDATE,
        @ADJUSTMENTREASON = @ADJUSTMENTREASON,
        @ADJUSTMENTREASONCODEID = @ADJUSTMENTREASONCODEID

return 0;