USP_DATAFORMTEMPLATE_EDITLOAD_BBNCRECURRINGGIFTPAYMENTDETAILS

The load procedure used by the edit dataform template "Recurring Gift Payment Details Edit Form BBNC"

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.
@PAYMENTMETHODCODE	tinyint	INOUT	Payment method
@AUTOPAY	bit	INOUT	Pay automatically by:
@CARDHOLDERNAME	nvarchar(255)	INOUT	Name on card
@CREDITCARDNUMBER	nvarchar(20)	INOUT	Card number
@CREDITTYPECODEID	uniqueidentifier	INOUT	Card type
@EXPIRESON	UDT_FUZZYDATE	INOUT	Expires on
@REFERENCEDATE	UDT_FUZZYDATE	INOUT	Reference date
@REFERENCENUMBER	nvarchar(20)	INOUT	Reference number
@ACCOUNTID	uniqueidentifier	INOUT	Account
@CONSTITUENTID	uniqueidentifier	INOUT	Constituent
@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.
@CREDITCARDTOKEN	uniqueidentifier	INOUT	Card token
@STANDINGORDERSETUP	bit	INOUT	Standing order has been setup
@STANDINGORDERSETUPDATE	datetime	INOUT	Setup on
@DDISOURCECODEID	uniqueidentifier	INOUT	DDI source
@DDISOURCEDATE	date	INOUT	DDI source date
@SENDPMINSTRUCTION	bit	INOUT	Send instruction
@PMINSTRUCTIONTOSENDCODE	tinyint	INOUT	Send instruction
@PMINSTRUCTIONDATE_NEW	date	INOUT	New instruction sent
@PMINSTRUCTIONDATE_CANCEL	date	INOUT	Cancel instruction sent
@PMINSTRUCTIONDATE_SETUP	date	INOUT	Set-up instruction sent
@PMADVANCENOTICESENTDATE	date	INOUT	Advance notice sent
@UPDATEOTHERTRANSACTIONSTOUSENEWCREDITCARD	bit	INOUT	Update other transactions to use new credit card
@OTHERTRANSACTIONSUSEEXISTINGCREDITCARD	bit	INOUT	Other transactions use existing credit card?

Definition

Copy


                CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_BBNCRECURRINGGIFTPAYMENTDETAILS(
                    @ID uniqueidentifier,
                    @DATALOADED bit = 0 output,
                    @PAYMENTMETHODCODE tinyint = null output,
                    @AUTOPAY bit = null output,
                    @CARDHOLDERNAME nvarchar(255) = null output,
                    @CREDITCARDNUMBER nvarchar(20) = null output,
                    @CREDITTYPECODEID uniqueidentifier = null output,
                    @EXPIRESON dbo.UDT_FUZZYDATE = null output,
                    @REFERENCEDATE dbo.UDT_FUZZYDATE = null output,
                    @REFERENCENUMBER nvarchar(20) = null output,
                    @ACCOUNTID uniqueidentifier = null output,
                    @CONSTITUENTID uniqueidentifier = null output,
                    @TSLONG bigint = 0 output,
                    @CREDITCARDTOKEN uniqueidentifier = null output,
                    @STANDINGORDERSETUP bit = null output,
                    @STANDINGORDERSETUPDATE datetime = null output,
                    @DDISOURCECODEID uniqueidentifier = null output,
                    @DDISOURCEDATE date = null output,
                    @SENDPMINSTRUCTION bit = null output,
                    @PMINSTRUCTIONTOSENDCODE tinyint = null output,
                    @PMINSTRUCTIONDATE_NEW date = null output,
                    @PMINSTRUCTIONDATE_CANCEL date = null output,
                    @PMINSTRUCTIONDATE_SETUP date = null output,
                    @PMADVANCENOTICESENTDATE date = null output,
                    @UPDATEOTHERTRANSACTIONSTOUSENEWCREDITCARD bit = null output,
                    @OTHERTRANSACTIONSUSEEXISTINGCREDITCARD bit = null output
                )
                as
                    set nocount on;

                    set @DATALOADED = 0
                    set @TSLONG = 0

                    exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_RECURRINGGIFTPAYMENTDETAILS_3 
                        @ID = @ID,
                        @DATALOADED = @DATALOADED output,
                        @PAYMENTMETHODCODE = @PAYMENTMETHODCODE output,
                        @AUTOPAY = @AUTOPAY output,
                        @CARDHOLDERNAME = @CARDHOLDERNAME output,
                        @CREDITCARDNUMBER = @CREDITCARDNUMBER output,
                        @CREDITTYPECODEID = @CREDITTYPECODEID output,
                        @EXPIRESON = @EXPIRESON output,
                        @REFERENCEDATE = @REFERENCEDATE output,
                        @REFERENCENUMBER = @REFERENCENUMBER output,
                        @ACCOUNTID = @ACCOUNTID output,
                        @CONSTITUENTID = @CONSTITUENTID output,
                        @TSLONG = @TSLONG output,
                        @CREDITCARDTOKEN = @CREDITCARDTOKEN output,
                        @STANDINGORDERSETUP = @STANDINGORDERSETUP output,
                        @STANDINGORDERSETUPDATE = @STANDINGORDERSETUPDATE output,
                        @DDISOURCECODEID = @DDISOURCECODEID output,
                        @DDISOURCEDATE = @DDISOURCEDATE output,
                        @SENDPMINSTRUCTION = @SENDPMINSTRUCTION output,
                        @PMINSTRUCTIONTOSENDCODE = @PMINSTRUCTIONTOSENDCODE output,
                        @PMINSTRUCTIONDATE_NEW = @PMINSTRUCTIONDATE_NEW output,
                        @PMINSTRUCTIONDATE_CANCEL = @PMINSTRUCTIONDATE_CANCEL output,
                        @PMINSTRUCTIONDATE_SETUP = @PMINSTRUCTIONDATE_SETUP output,
                        @PMADVANCENOTICESENTDATE = @PMADVANCENOTICESENTDATE output,
                        @UPDATEOTHERTRANSACTIONSTOUSENEWCREDITCARD = @UPDATEOTHERTRANSACTIONSTOUSENEWCREDITCARD output,
                        @OTHERTRANSACTIONSUSEEXISTINGCREDITCARD = @OTHERTRANSACTIONSUSEEXISTINGCREDITCARD output

                    return 0;