USP_DATAFORMTEMPLATE_EDIT_REVENUEBENEFITS

The save procedure used by the edit dataform template "Revenue Benefits Edit 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
@PERCENTAGEBENEFITS xml IN Benefits

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_REVENUEBENEFITS
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @BENEFITS xml,
    @BENEFITSWAIVED bit,
    @PERCENTAGEBENEFITS xml
)
as
begin
    declare @UPDATEGIFTFEEOPTION bit = 0;
    declare @ADJUSTMATCHINGGIFTCLAIMS tinyint = 3;

    exec dbo.USP_DATAFORMTEMPLATE_EDIT_REVENUEBENEFITS2
        @ID
        ,@CHANGEAGENTID
        ,@BENEFITS
        ,@BENEFITSWAIVED
        ,@PERCENTAGEBENEFITS
        ,@ADJUSTMATCHINGGIFTCLAIMS
        ,@UPDATEGIFTFEEOPTION;
end