USP_DATAFORMTEMPLATE_EDIT_BBNCEVENTREGISTRATIONBATCHROW_4

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@DONORID	uniqueidentifier	IN
@LOGGEDINUSER	bit	IN
@NETCOMMUNITYTRANSACTIONPROCESSORID	uniqueidentifier	IN
@BBNCID	int	IN
@BBNCTRANID	int	IN
@ADDEDBY	nvarchar(255)	IN
@BBNCDONORNAME	nvarchar(154)	IN
@REGISTRATIONDATE	datetime	IN
@DONORINFORMATION	xml	IN
@DONORADDRESSINFORMATION	xml	IN
@DONORADDRESSUPDATE	bit	IN
@DONORADDRESSADD	bit	IN
@DONORADDRESSMAKEPRIMARY	bit	IN
@DONORADDRESSTYPECODEID	uniqueidentifier	IN
@PHONETYPES	xml	IN
@REGISTRATIONS	xml	IN
@GUESTS	xml	IN
@GIFTINFORMATION	xml	IN
@ORIGINPAGENAME	nvarchar(1000)	IN
@ORIGINPAGEID	int	IN
@SEQUENCE	int	IN
@DONORADDRESSINFORMATIONALLFIELDS	xml	IN
@DONORIDAUTOMATCH	nvarchar(255)	IN
@DONORINFORMATIONALLFIELDS	xml	IN
@ORIGINALDONORID	uniqueidentifier	IN
@DONORSECURITYID	uniqueidentifier	IN
@GUESTSECURITYID	uniqueidentifier	IN
@DONORSITEID	uniqueidentifier	IN
@GUESTSITEID	uniqueidentifier	IN
@ADDITIONALDONATION	xml	IN
@UNPAIDEVENTREGISTRATIONPAYMENT	bit	IN
@PDACCOUNTSYSTEMID	uniqueidentifier	IN
@ATTRIBUTECURRENCYID	uniqueidentifier	IN
@DONORORGANIZATIONID	uniqueidentifier	IN
@DONORORGANIZATIONIDAUTOMATCH	nvarchar(255)	IN
@APPEALCAMPAIGNS	xml	IN

Definition

Copy




CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_BBNCEVENTREGISTRATIONBATCHROW_4
                    (
                        @ID uniqueidentifier,
                        @CHANGEAGENTID uniqueidentifier,
                        @DONORID uniqueidentifier,
                        @LOGGEDINUSER bit,
                        @NETCOMMUNITYTRANSACTIONPROCESSORID uniqueidentifier,
                        @BBNCID int,
                        @BBNCTRANID int,
                        @ADDEDBY nvarchar(255),
                        @BBNCDONORNAME nvarchar(154),
                        @REGISTRATIONDATE datetime,
                        @DONORINFORMATION xml,
                        @DONORADDRESSINFORMATION xml,
                        @DONORADDRESSUPDATE bit,
                        @DONORADDRESSADD bit,
                        @DONORADDRESSMAKEPRIMARY bit,
                        @DONORADDRESSTYPECODEID uniqueidentifier,
                        @PHONETYPES xml,
                        @REGISTRATIONS xml,
                        @GUESTS xml,
                        @GIFTINFORMATION xml,
                        @ORIGINPAGENAME nvarchar(1000),
                        @ORIGINPAGEID int,
                        @SEQUENCE int,
                        @DONORADDRESSINFORMATIONALLFIELDS xml,
                        @DONORIDAUTOMATCH nvarchar(255),
                        @DONORINFORMATIONALLFIELDS xml,
                        @ORIGINALDONORID uniqueidentifier,
                        @DONORSECURITYID uniqueidentifier,
                        @GUESTSECURITYID uniqueidentifier,
                        @DONORSITEID uniqueidentifier,
                        @GUESTSITEID uniqueidentifier,
                        @ADDITIONALDONATION xml,
                        @UNPAIDEVENTREGISTRATIONPAYMENT bit,
                        @PDACCOUNTSYSTEMID uniqueidentifier,
                        @ATTRIBUTECURRENCYID uniqueidentifier,                        
                        @DONORORGANIZATIONID uniqueidentifier,
                        @DONORORGANIZATIONIDAUTOMATCH nvarchar(255),
                        @APPEALCAMPAIGNS XML
)
as
begin
    declare @BATCHSEPARATION as xml

    exec USP_DATAFORMTEMPLATE_EDITLOAD_BBNCEVENTREGISTRATIONBATCHROW_2 @ID =@ID, @BATCHSEPARATION = @BATCHSEPARATION output

    exec USP_DATAFORMTEMPLATE_EDIT_BBNCEVENTREGISTRATIONBATCHROW_5 @ID,
                        @CHANGEAGENTID,
                        @DONORID,
                        @LOGGEDINUSER,
                        @NETCOMMUNITYTRANSACTIONPROCESSORID,
                        @BBNCID,
                        @BBNCTRANID,
                        @ADDEDBY,
                        @BBNCDONORNAME,
                        @REGISTRATIONDATE,
                        @DONORINFORMATION,
                        @DONORADDRESSINFORMATION,
                        @DONORADDRESSUPDATE,
                        @DONORADDRESSADD,
                        @DONORADDRESSMAKEPRIMARY,
                        @DONORADDRESSTYPECODEID,
                        @PHONETYPES,
                        @REGISTRATIONS,
                        @GUESTS,
                        @GIFTINFORMATION,
                        @ORIGINPAGENAME,
                        @ORIGINPAGEID,
                        @SEQUENCE,
                        @DONORADDRESSINFORMATIONALLFIELDS,
                        @DONORIDAUTOMATCH ,
                        @DONORINFORMATIONALLFIELDS ,
                        @ORIGINALDONORID ,
                        @DONORSECURITYID ,
                        @GUESTSECURITYID ,
                        @DONORSITEID ,
                        @GUESTSITEID ,
                        @ADDITIONALDONATION ,
                        @UNPAIDEVENTREGISTRATIONPAYMENT ,
                        @PDACCOUNTSYSTEMID,
                        @ATTRIBUTECURRENCYID ,                        
                        @DONORORGANIZATIONID ,
                        @DONORORGANIZATIONIDAUTOMATCH,
                        @APPEALCAMPAIGNS,
            @BATCHSEPARATION
end