USP_DATAFORMTEMPLATE_EDIT_FAFBENEFIT

The save procedure used by the edit dataform template "FAFBenefit 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.
@NAME	nvarchar(100)	IN	Name
@DESCRIPTION	nvarchar(255)	IN	Description
@BENEFITCATEGORYCODEID	uniqueidentifier	IN	Category
@VALUE	money	IN	Value
@BENEFITOPTIONS	xml	IN	Benefit options
@CURRENTAPPUSERID	uniqueidentifier	IN

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_FAFBENEFIT
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @NAME nvarchar(100),
    @DESCRIPTION nvarchar(255),
    @BENEFITCATEGORYCODEID uniqueidentifier,
    @VALUE money,
    --@SENDBENEFITCODE tinyint,

    @BENEFITOPTIONS xml,
    @CURRENTAPPUSERID uniqueidentifier = null
)
as
begin
set nocount on;

declare @SITES xml;

begin try

    exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_FAFBENEFIT @ID=@ID, @SITES=@SITES output;

    exec USP_DATAFORMTEMPLATE_EDIT_FAFBENEFIT_2
        @ID,
        @CHANGEAGENTID,
        @NAME,
        @DESCRIPTION,
        @BENEFITCATEGORYCODEID,
        @VALUE,
        @BENEFITOPTIONS,
        @SITES,
        @CURRENTAPPUSERID

end try

begin catch
    exec dbo.USP_RAISE_ERROR
    return 1
end catch

return 0
end