USP_DATAFORMTEMPLATE_EDIT_BBNCDONATIONBATCHROW_5

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
@ORIGINAPPEALID	uniqueidentifier	IN	Origin appeal ID
@ADDEDBY	nvarchar(255)	IN	Added by hidden
@DONORID	uniqueidentifier	IN	Individual
@LOGGEDINUSER	bit	IN	BBNC user was logged in
@CORPORATEDONORID	uniqueidentifier	IN	Organization
@APPEALID	uniqueidentifier	IN	Appeal
@ISTEAMFUNDRAISINGOFFLINEGIFT	bit	IN	Offline gift
@DONORINFORMATION	xml	IN	Donor information
@DONORADDRESSINFORMATION	xml	IN	Donor address information
@DONORADDRESSINFORMATIONALLFIELDS	xml	IN	Donor address information all fields
@PHONETYPES	xml	IN	Phone type codes hidden
@GIFTINFORMATION	xml	IN	Gift information
@GIFTATTRIBUTEINFORMATION	xml	IN	Attribute information
@MGINFORMATIONFROMMFO	bit	IN	From MatchFinder Online
@MGINFORMATION	xml	IN	Matching gift information
@MGCONSTITUENTID	uniqueidentifier	IN	Matching gift constituent
@DONORADDRESSINFORMATIONUPDATE	bit	IN	Update address information
@DONORADDRESSINFORMATIONCREATENEW	bit	IN	Create new address
@DONORADDRESSINFORMATIONMAKEPRIMARY	bit	IN	Make address primary
@DONORADDRESSINFORMATIONADDRESSTYPECODEID	uniqueidentifier	IN	Previous address type
@DONOTRECEIPT	bit	IN	Do not receipt
@DONOTACKNOWLEDGE	bit	IN	Do not acknowledge
@UPDATEMGINFORMATIONFROMMFO	bit	IN	Update MG Info from MFO
@SOLICITORS	xml	IN	Solicitors
@SPLITS	xml	IN	Splits
@DONORIDAUTOMATCH	nvarchar(255)	IN	Individual auto-match
@CORPORATEDONORIDAUTOMATCH	nvarchar(255)	IN	Corporate donor auto-match
@MGCONSTITUENTIDAUTOMATCH	nvarchar(255)	IN	MG auto-match
@DONORINFORMATIONALLFIELDS	xml	IN	Donor information all fields
@ORIGINALDONORID	uniqueidentifier	IN	Original individual
@ORIGINALCORPORATEDONORID	uniqueidentifier	IN	Original organization
@DONORSECURITYID	uniqueidentifier	IN	Donor constituent security group
@CORPORATEDONORSECURITYID	uniqueidentifier	IN	Corporate donor security group
@MGCOMPANYSECURITYID	uniqueidentifier	IN	Matching gift company security group
@TRIBUTENAME	nvarchar(500)	IN	Tribute name
@TRIBUTEDESCRIPTION	nvarchar(500)	IN	Tribute description
@TRIBUTETYPECODEID	uniqueidentifier	IN	Tribute type
@TRIBUTEID	uniqueidentifier	IN	Tribute
@APPLYTRIBUTETODONATION	bit	IN	Apply tribute to donation
@ADDTRIBUTEACKNOWLEDGEE	bit	IN	Add acknowledgee to tribute
@TRIBUTEACKNOWLEDGEESECURITYID	uniqueidentifier	IN	Tribute acknowledgee security group
@UPDATETRIBUTEACKNOWLEDGEEADDRESS	bit	IN	Update acknowledgee's address
@TRIBUTEACKNOWLEDGEENAME	nvarchar(250)	IN	Acknowledgee name
@TRIBUTEACKNOWLEDGEEEMAIL	nvarchar(100)	IN	Acknowledgee email
@TRIBUTEACKNOWLEDGEESTREETADDRESS	nvarchar(300)	IN	Acknowledgee address
@TRIBUTEACKNOWLEDGEECITY	nvarchar(100)	IN	Acknowledgee city
@TRIBUTEACKNOWLEDGEESTATE	nvarchar(100)	IN	Acknowledgee state
@TRIBUTEACKNOWLEDGEEPOSTCODE	nvarchar(12)	IN	Acknowledgee post code
@TRIBUTEACKNOWLEDGEECOUNTRY	nvarchar(100)	IN	Acknowledgee country
@TRIBUTEACKNOWLEDGEEPHONE	nvarchar(100)	IN	Acknowledgee phone
@TRIBUTEACKNOWLEDGEELINKID	uniqueidentifier	IN	Existing constituent
@DONORSITEID	uniqueidentifier	IN	Donor site
@CORPORATEDONORSITEID	uniqueidentifier	IN	Corporate donor site
@MGCOMPANYSITEID	uniqueidentifier	IN	Matching gift company site
@TRIBUTEACKNOWLEDGEESITEID	uniqueidentifier	IN	Tribute acknowledgee site
@REMOVESPOUSE	bit	IN	Remove Spouse
@SPOUSEINFORMATION	xml	IN	Spouse information
@SAMESPOUSE	bit	IN	Update the existing spouse with the downloaded information
@SPOUSELINKID	uniqueidentifier	IN	Spouse
@SPOUSEOLDNAME	nvarchar(200)	IN	Previous spouse
@SPOUSESECURITYID	uniqueidentifier	IN	Spouse constituent security group
@SPOUSESITEID	uniqueidentifier	IN	Spouse site
@SEQUENCE	int	IN	Sequence
@APPLICATIONS	xml	IN	Applications
@PDACCOUNTSYSTEMID	uniqueidentifier	IN	Account system
@ATTRIBUTECURRENCYID	uniqueidentifier	IN	Attribute currency

Definition

Copy



        CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_BBNCDONATIONBATCHROW_5
            (
                @ID uniqueidentifier,
                @CHANGEAGENTID uniqueidentifier,
                @NETCOMMUNITYTRANSACTIONPROCESSORID uniqueidentifier,
                @BBNCID int,
                @BBNCTRANID int,
                @ORIGINPAGE nvarchar(1000),
                @ORIGINPAGEID int,
                @ORIGINAPPEALID uniqueidentifier,
                @ADDEDBY nvarchar(255),
                @DONORID uniqueidentifier,
                @LOGGEDINUSER bit,
                @CORPORATEDONORID uniqueidentifier,
                @APPEALID uniqueidentifier,
                @ISTEAMFUNDRAISINGOFFLINEGIFT bit,
                @DONORINFORMATION xml,
                @DONORADDRESSINFORMATION xml,
                @DONORADDRESSINFORMATIONALLFIELDS xml,
                @PHONETYPES xml,
                @GIFTINFORMATION xml,
                @GIFTATTRIBUTEINFORMATION xml,
                @MGINFORMATIONFROMMFO bit,
                @MGINFORMATION xml,
                @MGCONSTITUENTID uniqueidentifier,

                @DONORADDRESSINFORMATIONUPDATE bit,
                @DONORADDRESSINFORMATIONCREATENEW bit,
                @DONORADDRESSINFORMATIONMAKEPRIMARY bit,
                @DONORADDRESSINFORMATIONADDRESSTYPECODEID uniqueidentifier,
                @DONOTRECEIPT bit,
                @DONOTACKNOWLEDGE bit,
                @UPDATEMGINFORMATIONFROMMFO bit,

                @SOLICITORS xml,
                @SPLITS xml,

                @DONORIDAUTOMATCH nvarchar(255),
                @CORPORATEDONORIDAUTOMATCH nvarchar(255),
                @MGCONSTITUENTIDAUTOMATCH nvarchar(255),

                @DONORINFORMATIONALLFIELDS xml,
                @ORIGINALDONORID uniqueidentifier,
                @ORIGINALCORPORATEDONORID uniqueidentifier,

                @DONORSECURITYID uniqueidentifier,
                @CORPORATEDONORSECURITYID uniqueidentifier,
                @MGCOMPANYSECURITYID uniqueidentifier,

                @TRIBUTENAME nvarchar(500),
                @TRIBUTEDESCRIPTION nvarchar(500),
                @TRIBUTETYPECODEID uniqueidentifier,
                @TRIBUTEID uniqueidentifier,
                @APPLYTRIBUTETODONATION bit, 

                @ADDTRIBUTEACKNOWLEDGEE bit,
                @TRIBUTEACKNOWLEDGEESECURITYID uniqueidentifier,
                @UPDATETRIBUTEACKNOWLEDGEEADDRESS bit,
                @TRIBUTEACKNOWLEDGEENAME nvarchar(250),
                @TRIBUTEACKNOWLEDGEEEMAIL nvarchar(100),
                @TRIBUTEACKNOWLEDGEESTREETADDRESS nvarchar(300),
                @TRIBUTEACKNOWLEDGEECITY nvarchar(100),
                @TRIBUTEACKNOWLEDGEESTATE nvarchar(100),
                @TRIBUTEACKNOWLEDGEEPOSTCODE nvarchar(12),
                @TRIBUTEACKNOWLEDGEECOUNTRY nvarchar(100),
                @TRIBUTEACKNOWLEDGEEPHONE nvarchar(100),
                @TRIBUTEACKNOWLEDGEELINKID uniqueidentifier,

                @DONORSITEID uniqueidentifier,
                @CORPORATEDONORSITEID uniqueidentifier,
                @MGCOMPANYSITEID uniqueidentifier,
                @TRIBUTEACKNOWLEDGEESITEID uniqueidentifier,

                @REMOVESPOUSE bit,
                @SPOUSEINFORMATION xml,
                @SAMESPOUSE bit,
                @SPOUSELINKID uniqueidentifier,
                @SPOUSEOLDNAME nvarchar(200),
                @SPOUSESECURITYID uniqueidentifier,
                @SPOUSESITEID uniqueidentifier,

                @SEQUENCE int,


                @APPLICATIONS xml,
                @PDACCOUNTSYSTEMID uniqueidentifier,
                @ATTRIBUTECURRENCYID uniqueidentifier
            )
            as
            set nocount on;

            declare @CATEGORYCODEID uniqueidentifier = null;

            exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_BBNCDONATIONBATCHROW_4
                @CATEGORYCODEID = @CATEGORYCODEID;

            exec dbo.USP_DATAFORMTEMPLATE_EDIT_BBNCDONATIONBATCHROW_6
                    @ID,
                    @CHANGEAGENTID,
                    @NETCOMMUNITYTRANSACTIONPROCESSORID,
                    @BBNCID,
                    @BBNCTRANID,
                    @ORIGINPAGE,
                    @ORIGINPAGEID,
                    @ORIGINAPPEALID,
                    @ADDEDBY,
                    @DONORID,
                    @LOGGEDINUSER,
                    @CORPORATEDONORID,
                    @APPEALID,
                    @ISTEAMFUNDRAISINGOFFLINEGIFT,
                    @DONORINFORMATION,
                    @DONORADDRESSINFORMATION,
                    @DONORADDRESSINFORMATIONALLFIELDS,
                    @PHONETYPES,
                    @GIFTINFORMATION,
                    @GIFTATTRIBUTEINFORMATION,
                    @MGINFORMATIONFROMMFO,
                    @MGINFORMATION,
                    @MGCONSTITUENTID,
                    @DONORADDRESSINFORMATIONUPDATE,
                    @DONORADDRESSINFORMATIONCREATENEW,
                    @DONORADDRESSINFORMATIONMAKEPRIMARY,
                    @DONORADDRESSINFORMATIONADDRESSTYPECODEID,
                    @DONOTRECEIPT,
                    @DONOTACKNOWLEDGE,
                    @UPDATEMGINFORMATIONFROMMFO,    
                    @SOLICITORS,
                    @SPLITS,
                    @DONORIDAUTOMATCH,
                    @CORPORATEDONORIDAUTOMATCH,
                    @MGCONSTITUENTIDAUTOMATCH,    
                    @DONORINFORMATIONALLFIELDS,
                    @ORIGINALDONORID,
                    @ORIGINALCORPORATEDONORID,
                    @DONORSECURITYID,
                    @CORPORATEDONORSECURITYID,
                    @MGCOMPANYSECURITYID,
                    @TRIBUTENAME,
                    @TRIBUTEDESCRIPTION,
                    @TRIBUTETYPECODEID,
                    @TRIBUTEID,
                    @APPLYTRIBUTETODONATION,
                    @ADDTRIBUTEACKNOWLEDGEE,
                    @TRIBUTEACKNOWLEDGEESECURITYID,
                    @UPDATETRIBUTEACKNOWLEDGEEADDRESS,
                    @TRIBUTEACKNOWLEDGEENAME,
                    @TRIBUTEACKNOWLEDGEEEMAIL,
                    @TRIBUTEACKNOWLEDGEESTREETADDRESS,
                    @TRIBUTEACKNOWLEDGEECITY,
                    @TRIBUTEACKNOWLEDGEESTATE,
                    @TRIBUTEACKNOWLEDGEEPOSTCODE,
                    @TRIBUTEACKNOWLEDGEECOUNTRY,
                    @TRIBUTEACKNOWLEDGEEPHONE,
                    @TRIBUTEACKNOWLEDGEELINKID,
                    @DONORSITEID,
                    @CORPORATEDONORSITEID,
                    @MGCOMPANYSITEID,
                    @TRIBUTEACKNOWLEDGEESITEID,
                    @REMOVESPOUSE,
                    @SPOUSEINFORMATION,
                    @SAMESPOUSE,
                    @SPOUSELINKID,
                    @SPOUSEOLDNAME,
                    @SPOUSESECURITYID,
                    @SPOUSESITEID,
                    @SEQUENCE,
                    @APPLICATIONS,
                    @PDACCOUNTSYSTEMID,
                    @ATTRIBUTECURRENCYID,
                    @CATEGORYCODEID;

                return 0;