USP_DATAFORMTEMPLATE_EDIT_MEMBERSHIPPROGRAM

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
@SITEID	uniqueidentifier	IN	Site
@CARDFORMAT	nvarchar(255)	IN	Card format
@EXPIRESONCODE	tinyint	IN	Expiration date
@BACKDATEMEMBERSHIPS	bit	IN
@ALLOWMULTIPLEMEMBERSHIPS	bit	IN	Allow multiple memberships
@CUTOFFDAY	tinyint	IN	Cutoff day
@CUTOFFDATEFORYEAR	char(4)	IN	Cutoff day
@EXPIRATIONDATES	xml	IN	Expiration dates

Definition

Copy



CREATE procedure USP_DATAFORMTEMPLATE_EDIT_MEMBERSHIPPROGRAM
(
    @ID uniqueidentifier,
    @CURRENTAPPUSERID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @NAME nvarchar(100),
    @DESCRIPTION nvarchar(255),
    @SITEID uniqueidentifier,
    @CARDFORMAT nvarchar(255),
    @EXPIRESONCODE tinyint,
    @BACKDATEMEMBERSHIPS bit,
    @ALLOWMULTIPLEMEMBERSHIPS bit,
    @CUTOFFDAY tinyint,
    @CUTOFFDATEFORYEAR char(4),
    @EXPIRATIONDATES xml
)

as
    set nocount on;

    declare @LETTERTEMPLATEID uniqueidentifier;

    exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_MEMBERSHIPPROGRAM
        @ID = @ID,
        @LETTERTEMPLATEID = @LETTERTEMPLATEID output

    exec dbo.USP_DATAFORMTEMPLATE_EDIT_MEMBERSHIPPROGRAM_2
        @ID,
        @CURRENTAPPUSERID,
        @CHANGEAGENTID,
        @NAME,
        @DESCRIPTION,
        @SITEID,
        @CARDFORMAT,
        @EXPIRESONCODE,
        @BACKDATEMEMBERSHIPS,
        @ALLOWMULTIPLEMEMBERSHIPS,
        @CUTOFFDAY,
        @CUTOFFDATEFORYEAR,
        @EXPIRATIONDATES,
        @LETTERTEMPLATEID

    return 0;