USP_DATAFORMTEMPLATE_EDIT_BENEFITGLDISTRIBUTIONBACKOUTADJUST

The save procedure used by the edit dataform template "Posted Benefit Backout 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 Benefit GL distribution
@ADJUSTMENTDATE datetime IN Adjustment date
@ADJUSTMENTPOSTDATE datetime IN Adjustment post date
@ADJUSTMENTREASON nvarchar(300) IN Adjustment details
@CHANGEAGENTID uniqueidentifier IN Input parameter indicating the ID of the change agent invoking the procedure.
@ADJUSTMENTREASONCODEID uniqueidentifier IN Adjustment reason

Definition

Copy

                CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_BENEFITGLDISTRIBUTIONBACKOUTADJUST 
                    (
                        @ID uniqueidentifier,
                        @GLDISTRIBUTION xml,
                        @ADJUSTMENTDATE datetime,
                        @ADJUSTMENTPOSTDATE datetime,
                        @ADJUSTMENTREASON nvarchar(300),
                        @CHANGEAGENTID uniqueidentifier = null,
                        @ADJUSTMENTREASONCODEID uniqueidentifier
                    )
                as
                    exec USP_SAVE_BENEFITGLDISTRIBUTION_ADJUSTMENT @ID, @GLDISTRIBUTION, @ADJUSTMENTDATE, @ADJUSTMENTPOSTDATE,
                        @ADJUSTMENTREASONCODEID, @ADJUSTMENTREASON, 3, @CHANGEAGENTID

                    return 0;