USP_DATAFORMTEMPLATE_EDIT_SPONSORSHIPREASSIGN_3

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@REVENUECONSTITUENTID	uniqueidentifier	IN
@SPONSORSHIPCONSTITUENTID	uniqueidentifier	IN
@SPONSORSHIPREASONID	uniqueidentifier	IN
@AMOUNT	money	IN
@PAYMENTMETHODCODE	tinyint	IN
@REFERENCEDATE	UDT_FUZZYDATE	IN
@REFERENCENUMBER	nvarchar(20)	IN
@CARDHOLDERNAME	nvarchar(255)	IN
@CREDITCARDNUMBER	nvarchar(20)	IN
@CREDITTYPECODEID	uniqueidentifier	IN
@EXPIRESON	UDT_FUZZYDATE	IN
@CONSTITUENTACCOUNTID	uniqueidentifier	IN
@FREQUENCYCODE	tinyint	IN
@REVENUESCHEDULEENDDATE	datetime	IN
@REVENUESCHEDULESTARTDATE	datetime	IN
@AUTOPAY	bit	IN
@CREDITCARDTOKEN	uniqueidentifier	IN
@GIFTRECIPIENT	bit	IN
@PLANNEDENDDATE	date	IN
@SENDREMINDER	bit	IN
@FINDERNUMBER	bigint	IN
@SOURCECODE	nvarchar(50)	IN
@APPEALID	uniqueidentifier	IN
@MAILINGID	uniqueidentifier	IN
@CHANNELCODEID	uniqueidentifier	IN
@REFERENCE	nvarchar(255)	IN
@CATEGORYCODEID	uniqueidentifier	IN
@CARRYFORWARDPASTDUE	bit	IN
@CARRYFORWARDPASTDUEAMOUNT	money	IN
@EXPIRATIONREASONID	uniqueidentifier	IN
@TRANSACTIONCURRENCYID	uniqueidentifier	IN
@BASEEXCHANGERATEID	uniqueidentifier	IN
@EXCHANGERATE	decimal(20, 8)	IN
@CURRENTAPPUSERID	uniqueidentifier	IN
@DONOTACKNOWLEDGE	bit	IN

Definition

Copy



CREATE procedure USP_DATAFORMTEMPLATE_EDIT_SPONSORSHIPREASSIGN_3
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @REVENUECONSTITUENTID uniqueidentifier,
    @SPONSORSHIPCONSTITUENTID uniqueidentifier,
    @SPONSORSHIPREASONID uniqueidentifier,
    @AMOUNT money,
    @PAYMENTMETHODCODE tinyint,
    @REFERENCEDATE dbo.UDT_FUZZYDATE,
    @REFERENCENUMBER nvarchar(20),
    @CARDHOLDERNAME nvarchar(255),
    @CREDITCARDNUMBER nvarchar(20),
    @CREDITTYPECODEID uniqueidentifier,
    @EXPIRESON dbo.UDT_FUZZYDATE,
    @CONSTITUENTACCOUNTID uniqueidentifier,
    @FREQUENCYCODE tinyint,
    @REVENUESCHEDULEENDDATE datetime,
    @REVENUESCHEDULESTARTDATE datetime,
    @AUTOPAY bit,
    @CREDITCARDTOKEN uniqueidentifier,
    @GIFTRECIPIENT bit,
    @PLANNEDENDDATE date,
    @SENDREMINDER bit,
    @FINDERNUMBER bigint,
    @SOURCECODE nvarchar(50),
    @APPEALID uniqueidentifier,
    @MAILINGID uniqueidentifier,
    @CHANNELCODEID uniqueidentifier,
    @REFERENCE nvarchar(255),
    @CATEGORYCODEID uniqueidentifier,
    @CARRYFORWARDPASTDUE bit,
    @CARRYFORWARDPASTDUEAMOUNT money,
    @EXPIRATIONREASONID uniqueidentifier,
    @TRANSACTIONCURRENCYID uniqueidentifier,
    @BASEEXCHANGERATEID uniqueidentifier,
    @EXCHANGERATE decimal(20,8),
    @CURRENTAPPUSERID uniqueidentifier,
    @DONOTACKNOWLEDGE bit
)

as
  set nocount on;

    declare @SEPAMANDATEID uniqueidentifier;
    declare @OTHERPAYMENTMETHODCODEID uniqueidentifier;

  exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_SPONSORSHIPREASSIGN
        @ID = @ID,
        @SEPAMANDATEID = @SEPAMANDATEID output,
        @OTHERPAYMENTMETHODCODEID = @OTHERPAYMENTMETHODCODEID output;

  exec dbo.USP_DATAFORMTEMPLATE_EDIT_SPONSORSHIPREASSIGN_4
        @ID,
        @CHANGEAGENTID,
        @REVENUECONSTITUENTID,
        @SPONSORSHIPCONSTITUENTID,
        @SPONSORSHIPREASONID,
        @AMOUNT,
        @PAYMENTMETHODCODE,
        @REFERENCEDATE,
        @REFERENCENUMBER,
        @CARDHOLDERNAME,
        @CREDITCARDNUMBER,
        @CREDITTYPECODEID,
        @EXPIRESON,
        @CONSTITUENTACCOUNTID,
        @FREQUENCYCODE,
        @REVENUESCHEDULEENDDATE,
        @REVENUESCHEDULESTARTDATE,
        @AUTOPAY,
        @CREDITCARDTOKEN,
        @GIFTRECIPIENT,
        @PLANNEDENDDATE,
        @SENDREMINDER,
        @FINDERNUMBER,
        @SOURCECODE,
        @APPEALID,
        @MAILINGID,
        @CHANNELCODEID,
        @REFERENCE,
        @CATEGORYCODEID,
        @CARRYFORWARDPASTDUE,
        @CARRYFORWARDPASTDUEAMOUNT,
        @EXPIRATIONREASONID,
        @TRANSACTIONCURRENCYID,
        @BASEEXCHANGERATEID,
        @EXCHANGERATE,
        @CURRENTAPPUSERID,
        @DONOTACKNOWLEDGE,
        @SEPAMANDATEID,
        @OTHERPAYMENTMETHODCODEID;

  return 0;