USP_DATAFORMTEMPLATE_ADJUST_REVENUEBENEFITS

The save procedure used by the edit dataform template "Posted Revenue Benefits Edit Data 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.
@BENEFITS	xml	IN
@BENEFITSWAIVED	bit	IN	Benefits waived
@ADJUSTMENTDATE	datetime	IN	Adjusted date
@ADJUSTMENTPOSTDATE	datetime	IN	Adjusted post date
@ADJUSTMENTREASON	nvarchar(300)	IN	Adjustment details
@ADJUSTMENTREASONCODEID	uniqueidentifier	IN	Adjustment reason
@PERCENTAGEBENEFITS	xml	IN	Benefits

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADJUST_REVENUEBENEFITS
                    (
                        @ID uniqueidentifier,
                        @CHANGEAGENTID uniqueidentifier = null,
                        @BENEFITS xml,
                        @BENEFITSWAIVED bit,
                        @ADJUSTMENTDATE datetime,
                        @ADJUSTMENTPOSTDATE datetime,
                        @ADJUSTMENTREASON nvarchar(300),
                        @ADJUSTMENTREASONCODEID uniqueidentifier,
                        @PERCENTAGEBENEFITS xml
                    )
                as
                begin

                    declare @ADJUSTMENTPOSTSTATUSCODE tinyint;
                    exec USP_DATAFORMTEMPLATE_ADJUSTLOAD_REVENUEBENEFITS @ID=@ID output,
                        @CHANGEAGENTID=@CHANGEAGENTID output,
                        @BENEFITS=@BENEFITS output,
                        @BENEFITSWAIVED=@BENEFITSWAIVED output,
                        @ADJUSTMENTDATE=@ADJUSTMENTDATE output,
                        @ADJUSTMENTPOSTDATE=@ADJUSTMENTPOSTDATE output,
                        @ADJUSTMENTREASON=@ADJUSTMENTREASON output,
                        @ADJUSTMENTREASONCODEID=@ADJUSTMENTREASONCODEID output,
                        @PERCENTAGEBENEFITS=@PERCENTAGEBENEFITS output,
                        @ADJUSTMENTPOSTSTATUSCODE=@ADJUSTMENTPOSTSTATUSCODE output

                    if @ADJUSTMENTPOSTSTATUSCODE is null
                    begin
                        set @ADJUSTMENTPOSTSTATUSCODE = 1;
                    end

                    exec USP_DATAFORMTEMPLATE_ADJUST_REVENUEBENEFITS_2 @ID=@ID,
                        @CHANGEAGENTID=@CHANGEAGENTID,
                        @BENEFITS=@BENEFITS,
                        @BENEFITSWAIVED=@BENEFITSWAIVED,
                        @ADJUSTMENTDATE=@ADJUSTMENTDATE,
                        @ADJUSTMENTPOSTDATE=@ADJUSTMENTPOSTDATE,
                        @ADJUSTMENTREASON=@ADJUSTMENTREASON,
                        @ADJUSTMENTREASONCODEID=@ADJUSTMENTREASONCODEID,
                        @PERCENTAGEBENEFITS=@PERCENTAGEBENEFITS,
                        @ADJUSTMENTPOSTSTATUSCODE=@ADJUSTMENTPOSTSTATUSCODE

                    return 0;

                end