USP_DATAFORMTEMPLATE_EDIT_RECURRINGGIFTPAYMENTDETAILS_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.
@PAYMENTMETHODCODE	tinyint	IN	Payment method
@AUTOPAY	bit	IN	Pay automatically by:
@CARDHOLDERNAME	nvarchar(100)	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	Send instruction
@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
@UPDATEOTHERTRANSACTIONSTOUSENEWCREDITCARD	bit	IN	Update other transactions to use new credit card

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_RECURRINGGIFTPAYMENTDETAILS_4
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @PAYMENTMETHODCODE tinyint,
    @AUTOPAY bit,
    @CARDHOLDERNAME nvarchar(100),
    @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,
    @UPDATEOTHERTRANSACTIONSTOUSENEWCREDITCARD bit
)

as
    set nocount on;

    declare @USESYSTEMGENERATEDREFERENCENUMBER bit;
    declare @STANDINGORDERREFERENCENUMBER nvarchar(18);

    exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_RECURRINGGIFTPAYMENTDETAILS_3
        @ID = @ID,
        @USESYSTEMGENERATEDREFERENCENUMBER = @USESYSTEMGENERATEDREFERENCENUMBER output,
        @STANDINGORDERREFERENCENUMBER = @STANDINGORDERREFERENCENUMBER output

    exec dbo.USP_DATAFORMTEMPLATE_EDIT_RECURRINGGIFTPAYMENTDETAILS_5
        @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,
        @USESYSTEMGENERATEDREFERENCENUMBER,
        @STANDINGORDERREFERENCENUMBER

    return 0;