USP_DATAFORMTEMPLATE_EDIT_APPEAL_2

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@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
@APPEALCATEGORYCODEID	uniqueidentifier	IN	Category
@BUSINESSUNITCODEID	uniqueidentifier	IN	Business unit
@STARTDATE	datetime	IN	Start date
@ENDDATE	datetime	IN	End date
@GOAL	money	IN	Goal
@APPEALREPORT1CODEID	uniqueidentifier	IN	Report code
@SITEID	uniqueidentifier	IN	Site
@MEMBERSHIPPROGRAMID	uniqueidentifier	IN	Membership

Definition

Copy



    CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_APPEAL_2
                (
                    @ID uniqueidentifier,
                    @CURRENTAPPUSERID uniqueidentifier,
                    @CHANGEAGENTID uniqueidentifier = null,
                    @NAME nvarchar(100),
                    @DESCRIPTION nvarchar(255),
                    @APPEALCATEGORYCODEID uniqueidentifier,
                    @BUSINESSUNITCODEID uniqueidentifier,
                    @STARTDATE datetime,
                    @ENDDATE datetime,
                    @GOAL money,
                    @APPEALREPORT1CODEID uniqueidentifier,
                    @SITEID uniqueidentifier,
                    @MEMBERSHIPPROGRAMID uniqueidentifier
                )
                as                
                begin                
                    set nocount on;
                    declare @BUSINESSUNITS xml;

                  exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_APPEAL_2
            @ID=@ID,
            @CURRENTAPPUSERID =@CURRENTAPPUSERID,
            @CHANGEAGENTID = @CHANGEAGENTID output,
            @NAME =@NAME output,
            @DESCRIPTION=@DESCRIPTION output,
            @APPEALCATEGORYCODEID= @APPEALCATEGORYCODEID output,
            @BUSINESSUNITCODEID = @BUSINESSUNITCODEID output,
            @STARTDATE =@STARTDATE output,
            @ENDDATE =@ENDDATE output,
            @GOAL=@GOAL output,
            @APPEALREPORT1CODEID = @APPEALREPORT1CODEID output,
            @SITEID = @SITEID output,
            @MEMBERSHIPPROGRAMID = @MEMBERSHIPPROGRAMID output,
            @BUSINESSUNITS = @BUSINESSUNITS output;

         exec dbo.USP_DATAFORMTEMPLATE_EDIT_APPEAL_3
            @ID,
                      @CURRENTAPPUSERID,
                      @CHANGEAGENTID,
                      @NAME,
                      @DESCRIPTION,
                      @APPEALCATEGORYCODEID,
                      @BUSINESSUNITCODEID,
                      @STARTDATE,
                      @ENDDATE,
                      @GOAL,
                      @APPEALREPORT1CODEID,
                      @SITEID,
                      @MEMBERSHIPPROGRAMID,
            @BUSINESSUNITS;

                end