USP_DATAFORMTEMPLATE_EDIT_RECURRINGGIFTPAYMENTDETAILS_3

Edits payment information for recurring gifts.

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

Definition

Copy



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

                    declare @UPDATEOTHERTRANSACTIONSTOUSENEWCREDITCARD bit;
                    exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_RECURRINGGIFTPAYMENTDETAILS_3 @ID = @ID,
                                                                                         @UPDATEOTHERTRANSACTIONSTOUSENEWCREDITCARD = @UPDATEOTHERTRANSACTIONSTOUSENEWCREDITCARD output

                    exec dbo.USP_DATAFORMTEMPLATE_EDIT_RECURRINGGIFTPAYMENTDETAILS_4    @ID,
                                                                                        @CHANGEAGENTID,
                                                                                        @PAYMENTMETHODCODE,
                                                                                        @AUTOPAY,
                                                                                        @CARDHOLDERNAME,
                                                                                        @CREDITCARDNUMBER,
                                                                                        @CREDITTYPECODEID,
                                                                                        @EXPIRESON,
                                                                                        @REFERENCEDATE,
                                                                                        @REFERENCENUMBER,
                                                                                        @ACCOUNTID,
                                                                                        @CREDITCARDTOKEN,
                                                                                        @STANDINGORDERSETUP,
                                                                                        @STANDINGORDERSETUPDATE,
                                                                                        @DDISOURCECODEID,
                                                                                        @DDISOURCEDATE,
                                                                                        @SENDPMINSTRUCTION,
                                                                                        @PMINSTRUCTIONTOSENDCODE,
                                                                                        @PMINSTRUCTIONDATE_NEW,
                                                                                        @PMINSTRUCTIONDATE_CANCEL,
                                                                                        @PMINSTRUCTIONDATE_SETUP,
                                                                                        @PMADVANCENOTICESENTDATE,
                                                                                        @UPDATEOTHERTRANSACTIONSTOUSENEWCREDITCARD

                    return 0;