USP_DATAFORMTEMPLATE_ADJUST_REVENUEBENEFITS_2

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@BENEFITS	xml	IN
@BENEFITSWAIVED	bit	IN
@ADJUSTMENTDATE	datetime	IN
@ADJUSTMENTPOSTDATE	datetime	IN
@ADJUSTMENTREASON	nvarchar(300)	IN
@ADJUSTMENTREASONCODEID	uniqueidentifier	IN
@PERCENTAGEBENEFITS	xml	IN
@ADJUSTMENTPOSTSTATUSCODE	tinyint	IN

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADJUST_REVENUEBENEFITS_2
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @BENEFITS xml,
    @BENEFITSWAIVED bit,
    @ADJUSTMENTDATE datetime,
    @ADJUSTMENTPOSTDATE datetime,
    @ADJUSTMENTREASON nvarchar(300),
    @ADJUSTMENTREASONCODEID uniqueidentifier,
    @PERCENTAGEBENEFITS xml,
    @ADJUSTMENTPOSTSTATUSCODE tinyint
)
as
begin
    declare @UPDATEGIFTFEEOPTION bit;

    exec dbo.USP_DATAFORMTEMPLATE_ADJUSTLOAD_REVENUEBENEFITS @ID=@ID, @UPDATEGIFTFEEOPTION=@UPDATEGIFTFEEOPTION output;

    exec dbo.USP_DATAFORMTEMPLATE_ADJUST_REVENUEBENEFITS_3
        @ID,
        @CHANGEAGENTID,
        @BENEFITS,
        @BENEFITSWAIVED,
        @ADJUSTMENTDATE,
        @ADJUSTMENTPOSTDATE,
        @ADJUSTMENTREASON,
        @ADJUSTMENTREASONCODEID,
        @PERCENTAGEBENEFITS,
        @ADJUSTMENTPOSTSTATUSCODE,
        @UPDATEGIFTFEEOPTION;
end