USP_DATAFORMTEMPLATE_EDIT_MEMBERSHIPDETAILS

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@MEMBERSHIPLEVELTYPECODEID	uniqueidentifier	IN
@COMMENTS	nvarchar(1000)	IN
@AUTOMATICALLYRENEWMEMBERSHIP	bit	IN

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_MEMBERSHIPDETAILS
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @MEMBERSHIPLEVELTYPECODEID uniqueidentifier,
    @COMMENTS nvarchar(1000),
    @AUTOMATICALLYRENEWMEMBERSHIP bit
)
as
begin
    set nocount on;

    declare @MEMBERSHIPLEVELID uniqueidentifier;
    declare @MEMBERSHIPLEVELTERMID uniqueidentifier;
    declare @EXPIRATIONDATE datetime;

    exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_MEMBERSHIPDETAILS @ID=@ID, @MEMBERSHIPLEVELID=@MEMBERSHIPLEVELID output, @MEMBERSHIPLEVELTERMID=@MEMBERSHIPLEVELTERMID output, @EXPIRATIONDATE=@EXPIRATIONDATE output;

    exec dbo.USP_DATAFORMTEMPLATE_EDIT_MEMBERSHIPDETAILS_2
        @ID,
        @CHANGEAGENTID,
        @MEMBERSHIPLEVELTYPECODEID,
        @COMMENTS,
        @AUTOMATICALLYRENEWMEMBERSHIP,
        @MEMBERSHIPLEVELID,
        @MEMBERSHIPLEVELTERMID,
        @EXPIRATIONDATE;
end