USP_DATAFORMTEMPLATE_EDIT_MEMBERSHIPTRANSACTION

The save procedure used by the edit dataform template "Membership Transaction Edit Data 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.
@MEMBERSHIPLEVELID	uniqueidentifier	IN	Level
@MEMBERSHIPLEVELTERMID	uniqueidentifier	IN	Term
@TRANSACTIONDATE	datetime	IN	Transaction date
@EXPIRATIONDATE	datetime	IN	Expiration date

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_MEMBERSHIPTRANSACTION
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @MEMBERSHIPLEVELID uniqueidentifier,
    @MEMBERSHIPLEVELTERMID uniqueidentifier,
    @TRANSACTIONDATE datetime,
    @EXPIRATIONDATE datetime
)
as
set nocount on;

declare @CANCELLATIONREASONCODE uniqueidentifier;

exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_MEMBERSHIPTRANSACTION @ID=@ID, @CANCELLATIONREASONCODE=@CANCELLATIONREASONCODE output;

exec dbo.USP_DATAFORMTEMPLATE_EDIT_MEMBERSHIPTRANSACTION_2
    @ID,
    @CHANGEAGENTID,
    @MEMBERSHIPLEVELID,
    @MEMBERSHIPLEVELTERMID,
    @TRANSACTIONDATE,
    @EXPIRATIONDATE,
    @CANCELLATIONREASONCODE;