USP_DATAFORMTEMPLATE_EDIT_MEMBERSHIPPROGRAMRENEWAL

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@MEMBERSHIPTERMTYPE	tinyint	IN
@DUESBASEDEXPIRATIONDATETYPE	tinyint	IN
@EXPIRATIONENDOFPRIORMONTH	bit	IN
@EXPIRATIONENDOFPRIORMONTHCUTOFF	tinyint	IN
@RENEWALWINDOWSTART	tinyint	IN
@RENEWALWINDOWEND	tinyint	IN
@AUTOMATICRENEWALRADIO	tinyint	IN
@AUTOMATICRENEWALTIMETYPE	tinyint	IN
@RENEWALWINDOWSTARTCUTOFFDAY	tinyint	IN
@AFTEREXPIRATIONTIMEPERIOD1	tinyint	IN
@AFTEREXPIRATIONCLASSIFICATION1	tinyint	IN
@AFTEREXPIRATIONTIMEPERIOD2	tinyint	IN
@AFTEREXPIRATIONCLASSIFICATION2	tinyint	IN
@AFTEREXPIRATIONTIMEPERIOD3	tinyint	IN
@AFTEREXPIRATIONCLASSIFICATION3	tinyint	IN
@CLASSIFICATIONAFTERRENEWALWINDOWTYPE	tinyint	IN
@REVENUEAFTERRENEWALWINDOWTYPE	tinyint	IN
@DUESBASEDEXPIRATIONDATE	UDT_MONTHDAY	IN
@AUTOMATICRENEWALNUMBERDAY	tinyint	IN
@AUTOMATICRENEWALNUMBERMONTH	tinyint	IN
@AUTOMATICRENEWALDAYOFMONTH	int	IN
@PROGRAMBASEDONCODE	tinyint	IN

Definition

Copy



CREATE procedure USP_DATAFORMTEMPLATE_EDIT_MEMBERSHIPPROGRAMRENEWAL
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @MEMBERSHIPTERMTYPE tinyint,
    @DUESBASEDEXPIRATIONDATETYPE tinyint,
    @EXPIRATIONENDOFPRIORMONTH bit,
    @EXPIRATIONENDOFPRIORMONTHCUTOFF tinyint,
    @RENEWALWINDOWSTART tinyint,
    @RENEWALWINDOWEND tinyint,
    @AUTOMATICRENEWALRADIO tinyint,
    @AUTOMATICRENEWALTIMETYPE tinyint,
    @RENEWALWINDOWSTARTCUTOFFDAY tinyint,
    @AFTEREXPIRATIONTIMEPERIOD1 tinyint,
    @AFTEREXPIRATIONCLASSIFICATION1 tinyint,
    @AFTEREXPIRATIONTIMEPERIOD2 tinyint,
    @AFTEREXPIRATIONCLASSIFICATION2 tinyint,
    @AFTEREXPIRATIONTIMEPERIOD3 tinyint,
    @AFTEREXPIRATIONCLASSIFICATION3 tinyint,
    @CLASSIFICATIONAFTERRENEWALWINDOWTYPE tinyint,
    @REVENUEAFTERRENEWALWINDOWTYPE tinyint,
    @DUESBASEDEXPIRATIONDATE dbo.UDT_MONTHDAY,
    @AUTOMATICRENEWALNUMBERDAY tinyint,
    @AUTOMATICRENEWALNUMBERMONTH tinyint,
    @AUTOMATICRENEWALDAYOFMONTH int,
    @PROGRAMBASEDONCODE tinyint
)

as
  set nocount on;

    declare @EXPIRATIONDATES xml;

  exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_MEMBERSHIPPROGRAMRENEWAL
        @ID = @ID,
        @EXPIRATIONDATES = @EXPIRATIONDATES output

  exec dbo.USP_DATAFORMTEMPLATE_EDIT_MEMBERSHIPPROGRAMRENEWAL_2
        @ID,
        @CHANGEAGENTID,
        @MEMBERSHIPTERMTYPE,
        @DUESBASEDEXPIRATIONDATETYPE,
        @EXPIRATIONENDOFPRIORMONTH,
        @EXPIRATIONENDOFPRIORMONTHCUTOFF,
        @RENEWALWINDOWSTART,
        @RENEWALWINDOWEND,
        @AUTOMATICRENEWALRADIO,
        @AUTOMATICRENEWALTIMETYPE,
        @RENEWALWINDOWSTARTCUTOFFDAY,
        @AFTEREXPIRATIONTIMEPERIOD1,
        @AFTEREXPIRATIONCLASSIFICATION1,
        @AFTEREXPIRATIONTIMEPERIOD2,
        @AFTEREXPIRATIONCLASSIFICATION2,
        @AFTEREXPIRATIONTIMEPERIOD3,
        @AFTEREXPIRATIONCLASSIFICATION3,
        @CLASSIFICATIONAFTERRENEWALWINDOWTYPE,
        @REVENUEAFTERRENEWALWINDOWTYPE,
        @DUESBASEDEXPIRATIONDATE,
        @AUTOMATICRENEWALNUMBERDAY,
        @AUTOMATICRENEWALNUMBERMONTH,
        @AUTOMATICRENEWALDAYOFMONTH,
        @PROGRAMBASEDONCODE,
        @EXPIRATIONDATES

  return 0;