USP_DATAFORMTEMPLATE_EDITLOAD_BBNCDONATIONBATCHROW_4

The load procedure used by the edit dataform template "NetCommunity Donation Batch Row Edit Form 4"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@NETCOMMUNITYTRANSACTIONPROCESSORID	uniqueidentifier	INOUT	Processor
@BBNCID	int	INOUT	Blackbaud Internet Solutions ID
@BBNCTRANID	int	INOUT	Blackbaud Internet Solutions transaction ID
@ORIGINPAGE	nvarchar(1000)	INOUT	Origin page
@ORIGINPAGEID	int	INOUT	Origin page ID
@ORIGINAPPEALID	uniqueidentifier	INOUT	Origin appeal ID
@ADDEDBY	nvarchar(255)	INOUT	Added by hidden
@ADDEDBYFORDISPLAY	nvarchar(255)	INOUT	Added by
@DONORID	uniqueidentifier	INOUT	Individual
@LOGGEDINUSER	bit	INOUT	Blackbaud Internet Solutions user was logged in
@CORPORATEDONORID	uniqueidentifier	INOUT	Organization
@APPEALID	uniqueidentifier	INOUT	Appeal
@ISTEAMFUNDRAISINGOFFLINEGIFT	bit	INOUT	Offline gift
@DONORINFORMATION	xml	INOUT	Donor information
@DONORADDRESSINFORMATION	xml	INOUT	Donor address information
@DONORADDRESSINFORMATIONALLFIELDS	xml	INOUT	Donor address information all fields
@PHONETYPES	xml	INOUT	Phone type codes hidden
@GIFTINFORMATION	xml	INOUT	Gift information
@GIFTATTRIBUTEINFORMATION	xml	INOUT	Attribute information
@MGINFORMATIONFROMMFO	bit	INOUT	From MatchFinder Online
@MGINFORMATION	xml	INOUT	Matching gift information
@MGCONSTITUENTID	uniqueidentifier	INOUT	Matching gift constituent
@DONORADDRESSINFORMATIONUPDATE	bit	INOUT	Update address information
@DONORADDRESSINFORMATIONCREATENEW	bit	INOUT	Create new address
@DONORADDRESSINFORMATIONMAKEPRIMARY	bit	INOUT	Make address primary
@DONORADDRESSINFORMATIONADDRESSTYPECODEID	uniqueidentifier	INOUT	Previous address type
@DONOTRECEIPT	bit	INOUT	Do not receipt
@DONOTACKNOWLEDGE	bit	INOUT	Do not acknowledge
@UPDATEMGINFORMATIONFROMMFO	bit	INOUT	Update MG Info from MFO
@SOLICITORS	xml	INOUT	Solicitors
@SPLITS	xml	INOUT	Splits
@SUMMARY	nvarchar(255)	INOUT	Donation summary
@DONORSUMMARY	nvarchar(255)	INOUT	Donor
@CORPORATEDONORSUMMARY	nvarchar(255)	INOUT	Corporate donor
@DONORIDAUTOMATCH	nvarchar(255)	INOUT	Individual auto-match
@CORPORATEDONORIDAUTOMATCH	nvarchar(255)	INOUT	Corporate donor auto-match
@MGCONSTITUENTIDAUTOMATCH	nvarchar(255)	INOUT	MG auto-match
@DONORINFORMATIONALLFIELDS	xml	INOUT	Donor information all fields
@ORIGINALDONORID	uniqueidentifier	INOUT	Original individual
@ORIGINALCORPORATEDONORID	uniqueidentifier	INOUT	Original organization
@DONORSECURITYID	uniqueidentifier	INOUT	Donor constituent security group
@CORPORATEDONORSECURITYID	uniqueidentifier	INOUT	Corporate donor security group
@MGCOMPANYSECURITYID	uniqueidentifier	INOUT	Matching gift company security group
@TRIBUTENAME	nvarchar(500)	INOUT	Tribute name
@TRIBUTEDESCRIPTION	nvarchar(500)	INOUT	Tribute description
@TRIBUTETYPECODEID	uniqueidentifier	INOUT	Tribute type
@TRIBUTEID	uniqueidentifier	INOUT	Tribute
@APPLYTRIBUTETODONATION	bit	INOUT	Apply tribute to donation
@ADDTRIBUTEACKNOWLEDGEE	bit	INOUT	Add acknowledgee to tribute
@TRIBUTEACKNOWLEDGEESECURITYID	uniqueidentifier	INOUT	Tribute acknowledgee security group
@UPDATETRIBUTEACKNOWLEDGEEADDRESS	bit	INOUT	Update acknowledgee's address
@TRIBUTEACKNOWLEDGEENAME	nvarchar(250)	INOUT	Acknowledgee name
@TRIBUTEACKNOWLEDGEEEMAIL	nvarchar(100)	INOUT	Acknowledgee email
@TRIBUTEACKNOWLEDGEESTREETADDRESS	nvarchar(300)	INOUT	Acknowledgee address
@TRIBUTEACKNOWLEDGEECITY	nvarchar(100)	INOUT	Acknowledgee city
@TRIBUTEACKNOWLEDGEESTATE	nvarchar(100)	INOUT	Acknowledgee state
@TRIBUTEACKNOWLEDGEEPOSTCODE	nvarchar(12)	INOUT	Acknowledgee post code
@TRIBUTEACKNOWLEDGEECOUNTRY	nvarchar(100)	INOUT	Acknowledgee country
@TRIBUTEACKNOWLEDGEEPHONE	nvarchar(100)	INOUT	Acknowledgee phone
@TRIBUTEACKNOWLEDGEELINKID	uniqueidentifier	INOUT	Existing constituent
@DONORSITEID	uniqueidentifier	INOUT	Donor site
@CORPORATEDONORSITEID	uniqueidentifier	INOUT	Corporate donor site
@MGCOMPANYSITEID	uniqueidentifier	INOUT	Matching gift company site
@TRIBUTEACKNOWLEDGEESITEID	uniqueidentifier	INOUT	Tribute acknowledgee site
@REMOVESPOUSE	bit	INOUT	Remove Spouse
@SPOUSEINFORMATION	xml	INOUT	Spouse information
@SAMESPOUSE	bit	INOUT	Update the existing spouse with the downloaded information
@SPOUSELINKID	uniqueidentifier	INOUT	Spouse
@SPOUSEOLDNAME	nvarchar(200)	INOUT	Previous spouse
@SPOUSESECURITYID	uniqueidentifier	INOUT	Spouse constituent security group
@SPOUSESITEID	uniqueidentifier	INOUT	Spouse site
@SEQUENCE	int	INOUT	Sequence
@TSLONG	bigint	INOUT	Output parameter indicating the TSLONG value of the record being edited. This is used to manage multi-user concurrency issues when multiple users access the same record.
@APPLICATIONS	xml	INOUT	Applications
@TRANSACTIONCURRENCYID	uniqueidentifier	INOUT	Transaction Currency ID
@PDACCOUNTSYSTEMID	uniqueidentifier	INOUT	Account system
@ATTRIBUTECURRENCYID	uniqueidentifier	INOUT	Attribute currency
@CATEGORYCODEID	uniqueidentifier	INOUT	Revenue category
@OPENCOMMITMENTS	nvarchar(255)	INOUT	Open commitments

Definition

Copy


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

                        @DONORADDRESSINFORMATIONUPDATE bit = null output,
                        @DONORADDRESSINFORMATIONCREATENEW bit = null output,
                        @DONORADDRESSINFORMATIONMAKEPRIMARY bit = null output,
                        @DONORADDRESSINFORMATIONADDRESSTYPECODEID uniqueidentifier = null output,
                        @DONOTRECEIPT bit = null output,
                        @DONOTACKNOWLEDGE bit = null output,
                        @UPDATEMGINFORMATIONFROMMFO bit = null output,

                        @SOLICITORS xml = null output, 
                        @SPLITS xml = null output,

                        @SUMMARY nvarchar(255) = null output,
                        @DONORSUMMARY nvarchar(255) = null output,
                        @CORPORATEDONORSUMMARY nvarchar(255) = null output,

                        @DONORIDAUTOMATCH nvarchar(255) = null output,
                        @CORPORATEDONORIDAUTOMATCH nvarchar(255) = null output,
                        @MGCONSTITUENTIDAUTOMATCH nvarchar(255) = null output,

                        @DONORINFORMATIONALLFIELDS xml = null output,
                        @ORIGINALDONORID uniqueidentifier = null output,
                        @ORIGINALCORPORATEDONORID uniqueidentifier = null output,

                        @DONORSECURITYID uniqueidentifier = null output,
                        @CORPORATEDONORSECURITYID uniqueidentifier = null output,
                        @MGCOMPANYSECURITYID uniqueidentifier = null output,

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

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

                        @DONORSITEID uniqueidentifier = null output,
                        @CORPORATEDONORSITEID uniqueidentifier = null output,
                        @MGCOMPANYSITEID uniqueidentifier = null output,
                        @TRIBUTEACKNOWLEDGEESITEID uniqueidentifier = null output,

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

                        @SEQUENCE int = null output,
                        @TSLONG bigint = 0 output,

                        @APPLICATIONS xml = null output,
                        @TRANSACTIONCURRENCYID uniqueidentifier = null output,
                        @PDACCOUNTSYSTEMID uniqueidentifier = null output,
                        @ATTRIBUTECURRENCYID uniqueidentifier = null output,

                        @CATEGORYCODEID uniqueidentifier = null output,

                         @OPENCOMMITMENTS nvarchar(255) = null output

                    )
                    as
                    set nocount on;

                    set @DATALOADED = 0;
                    set @TSLONG = 0;

                    select
                        @DATALOADED = 1,
                        @NETCOMMUNITYTRANSACTIONPROCESSORID = NETCOMMUNITYTRANSACTIONPROCESSORID,
                        @BBNCID = BBNCID,
                        @BBNCTRANID = BBNCTRANID,
                        @ORIGINPAGE = ORIGINPAGE,
                        @ORIGINPAGEID = ORIGINPAGEID,
                        @ORIGINAPPEALID = ORIGINAPPEALID,
                        @ADDEDBY = ADDEDBY,
                        @ADDEDBYFORDISPLAY = ADDEDBY,
                        @DONORID = DONORID,
                        @ORIGINALDONORID = DONORID,
                        @LOGGEDINUSER = LOGGEDINUSER,
                        @CORPORATEDONORID = CORPORATEDONORID,
                        @ORIGINALCORPORATEDONORID = CORPORATEDONORID,
                        @APPEALID = APPEALID,
                        @ISTEAMFUNDRAISINGOFFLINEGIFT = ISTEAMFUNDRAISINGOFFLINEGIFT,
                        @DONORINFORMATION = DONORINFORMATION,
                        @DONORINFORMATIONALLFIELDS = DONORINFORMATIONALLFIELDS,
                        @DONORADDRESSINFORMATION = DONORADDRESSINFORMATION,
                        @DONORADDRESSINFORMATIONALLFIELDS = DONORADDRESSINFORMATIONALLFIELDS,
                        @PHONETYPES = PHONETYPES,
                        @GIFTINFORMATION = GIFTINFORMATION,
                        @GIFTATTRIBUTEINFORMATION = GIFTATTRIBUTEINFORMATION,
                        @MGINFORMATIONFROMMFO = MGINFORMATIONFROMMFO,
                        @MGINFORMATION = MGINFORMATION,
                        @MGCONSTITUENTID = MGCONSTITUENTID, 

                        @DONORADDRESSINFORMATIONUPDATE = DONORADDRESSINFORMATIONUPDATE,
                        @DONORADDRESSINFORMATIONCREATENEW = DONORADDRESSINFORMATIONCREATENEW,
                        @DONORADDRESSINFORMATIONMAKEPRIMARY = DONORADDRESSINFORMATIONMAKEPRIMARY,
                        @DONORADDRESSINFORMATIONADDRESSTYPECODEID = DONORADDRESSINFORMATIONADDRESSTYPECODEID,
                        @DONOTRECEIPT = DONOTRECEIPT,
                        @DONOTACKNOWLEDGE = DONOTACKNOWLEDGE,
                        @UPDATEMGINFORMATIONFROMMFO = 0, --JamesWill CR275482-051707 2007/05/21 The update from MFO checkbox is no longer used
                        @CATEGORYCODEID = CATEGORYCODEID,

                        @SOLICITORS = dbo.UFN_BATCHBBNCDONATION_GETSOLICITORS_TOITEMLISTXML(@ID),
                        @SPLITS = dbo.UFN_BATCHBBNCDONATION_GETSPLITS_TOITEMLISTXML(@ID),

                        @SUMMARY = '',
                        @DONORSUMMARY = '',
                        @OPENCOMMITMENTS = '',
                        @CORPORATEDONORSUMMARY = '',

                        @DONORIDAUTOMATCH = DONORIDAUTOMATCH,
                        @CORPORATEDONORIDAUTOMATCH = CORPORATEDONORIDAUTOMATCH,
                        @MGCONSTITUENTIDAUTOMATCH = MGCONSTITUENTIDAUTOMATCH,

                        @DONORSECURITYID = DONORSECURITYID,
                        @CORPORATEDONORSECURITYID = CORPORATEDONORSECURITYID,
                        @MGCOMPANYSECURITYID = MGCOMPANYSECURITYID,

                        @TRIBUTENAME = TRIBUTENAME,
                        @TRIBUTEDESCRIPTION = TRIBUTEDESCRIPTION,
                        @TRIBUTETYPECODEID = TRIBUTETYPECODEID,
                        @TRIBUTEID = TRIBUTEID,
                        @APPLYTRIBUTETODONATION = APPLYTRIBUTETODONATION,

                        @ADDTRIBUTEACKNOWLEDGEE = ADDTRIBUTEACKNOWLEDGEE,
                        @TRIBUTEACKNOWLEDGEESECURITYID = TRIBUTEACKNOWLEDGEESECURITYID,
                        @UPDATETRIBUTEACKNOWLEDGEEADDRESS= UPDATETRIBUTEACKNOWLEDGEEADDRESS,
                        @TRIBUTEACKNOWLEDGEENAME = TRIBUTEACKNOWLEDGEENAME,
                        @TRIBUTEACKNOWLEDGEEEMAIL = TRIBUTEACKNOWLEDGEEEMAIL,
                        @TRIBUTEACKNOWLEDGEESTREETADDRESS = TRIBUTEACKNOWLEDGEESTREETADDRESS,
                        @TRIBUTEACKNOWLEDGEECITY = TRIBUTEACKNOWLEDGEECITY,
                        @TRIBUTEACKNOWLEDGEESTATE = TRIBUTEACKNOWLEDGEESTATE,
                        @TRIBUTEACKNOWLEDGEEPOSTCODE = TRIBUTEACKNOWLEDGEEPOSTCODE,
                        @TRIBUTEACKNOWLEDGEECOUNTRY = TRIBUTEACKNOWLEDGEECOUNTRY,
                        @TRIBUTEACKNOWLEDGEEPHONE = TRIBUTEACKNOWLEDGEEPHONE,
                        @TRIBUTEACKNOWLEDGEELINKID = TRIBUTEACKNOWLEDGEELINKID,

                        @DONORSITEID = DONORSITEID,
                        @CORPORATEDONORSITEID = CORPORATEDONORSITEID,
                        @MGCOMPANYSITEID = MGCOMPANYSITEID,
                        @TRIBUTEACKNOWLEDGEESITEID = TRIBUTEACKNOWLEDGEESITEID,
                        @REMOVESPOUSE = REMOVESPOUSE,
                        @SPOUSEINFORMATION = SPOUSEINFORMATION,
                        @SAMESPOUSE = SAMESPOUSE,
                        @SPOUSELINKID = SPOUSELINKID,
                        @SPOUSEOLDNAME = SPOUSEOLDNAME,
                        @SPOUSESECURITYID = SPOUSESECURITYID,
                        @SPOUSESITEID = SPOUSESITEID,

                        @PDACCOUNTSYSTEMID = PDACCOUNTSYSTEMID,
                        @ATTRIBUTECURRENCYID = ATTRIBUTECURRENCYID,

                        @SEQUENCE = SEQUENCE,
                        @TSLONG = TSLONG,

                        @APPLICATIONS = dbo.UFN_BATCHBBNCDONATION_GETGIFTAPPLICATIONS_TOITEMLISTXML(@ID)
                    from dbo.BATCHBBNCDONATION
                    where ID = @ID;

                    declare @ISOCODE nvarchar(3);
                    set @ISOCODE =  @GIFTINFORMATION.value('(/GIFTINFORMATION/ITEM[2]/NEWVALUE/text())[1]','nvarchar(3)');
                    set @TRANSACTIONCURRENCYID = dbo.UFN_CURRENCY_GETCURRENCYFROMISO(@ISOCODE);

                    exec dbo.USP_BBNC_DECRYPTGIFTDATA @GIFTINFORMATION = @GIFTINFORMATION output, @KEYISALREADYOPEN = 1;

                    return 0;