USP_DATAFORMTEMPLATE_EDIT_BBNCMEMBERSHIPBATCHROW_2

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.
@NETCOMMUNITYTRANSACTIONPROCESSORID	uniqueidentifier	IN	Processor
@BBNCID	int	IN	NetCommunity ID
@BBNCTRANID	int	IN	NetCommunity transaction ID
@ORIGINPAGE	nvarchar(1000)	IN	Origin page
@ORIGINPAGEID	int	IN	Origin page ID
@EMAILSUBJECT	nvarchar(4000)	IN	Email subject
@EMAILID	int	IN	Email ID
@ADDEDBY	nvarchar(255)	IN	Added by hidden
@SEQUENCE	int	IN	Sequence
@MEMBERSHIPID	uniqueidentifier	IN	Membership
@MEMBERSHIPLEVELID	uniqueidentifier	IN	Membership level
@MEMBERSHIPLEVELTERMID	uniqueidentifier	IN	Membership level term
@MEMBERSHIPLEVELTYPECODEID	uniqueidentifier	IN	Membership level type
@MEMBERSHIPPROGRAMID	uniqueidentifier	IN	Membership program
@MEMBERSHIPPROGRAMINFO	xml	IN	Membership program info
@PAYMENTINFO	xml	IN	Payment info
@MEMBERSINFO	xml	IN	Members info
@MEMBERSECURITYID	uniqueidentifier	IN	Member constituent security group
@MEMBERSITEID	uniqueidentifier	IN	Guest site

Definition

Copy



CREATE procedure USP_DATAFORMTEMPLATE_EDIT_BBNCMEMBERSHIPBATCHROW_2
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier,
    @NETCOMMUNITYTRANSACTIONPROCESSORID uniqueidentifier,
    @BBNCID int,
    @BBNCTRANID int,
    @ORIGINPAGE nvarchar(1000),
    @ORIGINPAGEID int,
    @EMAILSUBJECT nvarchar(4000),
    @EMAILID int,
    @ADDEDBY nvarchar(255),
    @SEQUENCE int,
    @MEMBERSHIPID uniqueidentifier,
    @MEMBERSHIPLEVELID uniqueidentifier,
    @MEMBERSHIPLEVELTERMID uniqueidentifier,
    @MEMBERSHIPLEVELTYPECODEID uniqueidentifier,
    @MEMBERSHIPPROGRAMID uniqueidentifier,
    @MEMBERSHIPPROGRAMINFO xml,
    @PAYMENTINFO xml,
    @MEMBERSINFO xml,
    @MEMBERSECURITYID uniqueidentifier,
    @MEMBERSITEID uniqueidentifier
)

as
  set nocount on;

    declare @PDACCOUNTSYSTEMID uniqueidentifier;

  exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_BBNCMEMBERSHIPBATCHROW_2
        @ID = @ID,
        @PDACCOUNTSYSTEMID = @PDACCOUNTSYSTEMID output

  exec dbo.USP_DATAFORMTEMPLATE_EDIT_BBNCMEMBERSHIPBATCHROW_3
        @ID,
        @CHANGEAGENTID,
        @NETCOMMUNITYTRANSACTIONPROCESSORID,
        @BBNCID,
        @BBNCTRANID,
        @ORIGINPAGE,
        @ORIGINPAGEID,
        @EMAILSUBJECT,
        @EMAILID,
        @ADDEDBY,
        @SEQUENCE,
        @MEMBERSHIPID,
        @MEMBERSHIPLEVELID,
        @MEMBERSHIPLEVELTERMID,
        @MEMBERSHIPLEVELTYPECODEID,
        @MEMBERSHIPPROGRAMID,
        @MEMBERSHIPPROGRAMINFO,
        @PAYMENTINFO,
        @MEMBERSINFO,
        @MEMBERSECURITYID,
        @MEMBERSITEID,
        @PDACCOUNTSYSTEMID

  return 0;