USP_DATAFORMTEMPLATE_EDIT_BBNCDONATIONBATCHROW_4

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
@SPOUSEINFORMATION	xml	IN
@SAMESPOUSE	bit	IN
@SPOUSELINKID	uniqueidentifier	IN
@SPOUSEOLDNAME	nvarchar(200)	IN
@SPOUSESECURITYID	uniqueidentifier	IN
@SPOUSESITEID	uniqueidentifier	IN
@SEQUENCE	int	IN	Sequence
@APPLICATIONS	xml	IN	Applications

Definition

Copy



CREATE procedure USP_DATAFORMTEMPLATE_EDIT_BBNCDONATIONBATCHROW_4
(
    @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
)

as
  set nocount on;

    declare @PDACCOUNTSYSTEMID uniqueidentifier;

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

  exec dbo.USP_DATAFORMTEMPLATE_EDIT_BBNCDONATIONBATCHROW_5
        @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

  return 0;