USP_DATAFORMTEMPLATE_EDIT_SPONSORSHIPREASSIGN

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.
@REVENUECONSTITUENTID	uniqueidentifier	IN	Financial sponsor
@SPONSORSHIPCONSTITUENTID	uniqueidentifier	IN	Corresponding sponsor
@SPONSORSHIPREASONID	uniqueidentifier	IN	Reason
@AMOUNT	money	IN	Amount
@PAYMENTMETHODCODE	tinyint	IN	Payment method
@REFERENCEDATE	UDT_FUZZYDATE	IN	Reference date
@REFERENCENUMBER	nvarchar(20)	IN	Reference no.
@CARDHOLDERNAME	nvarchar(255)	IN	Name on card
@CREDITCARDNUMBER	nvarchar(20)	IN	Card number
@CREDITTYPECODEID	uniqueidentifier	IN	Card type
@EXPIRESON	UDT_FUZZYDATE	IN	Expires on
@CONSTITUENTACCOUNTID	uniqueidentifier	IN	Account
@FREQUENCYCODE	tinyint	IN	Frequency
@REVENUESCHEDULEENDDATE	datetime	IN	Ending on
@REVENUESCHEDULESTARTDATE	datetime	IN	Starting on
@AUTOPAY	bit	IN	Pay installments automatically by:
@CREDITCARDTOKEN	uniqueidentifier	IN
@GIFTRECIPIENT	bit	IN	Gift
@PLANNEDENDDATE	datetime	IN	Expiration date
@SENDREMINDER	bit	IN	Send reminders
@FINDERNUMBER	bigint	IN	Finder number
@SOURCECODE	nvarchar(50)	IN	Source code
@APPEALID	uniqueidentifier	IN	Appeal
@MAILINGID	uniqueidentifier	IN	Effort
@CHANNELCODEID	uniqueidentifier	IN	Inbound channel
@REFERENCE	nvarchar(255)	IN	Reference
@CATEGORYCODEID	uniqueidentifier	IN	Revenue category
@CARRYFORWARDPASTDUE	bit	IN	Carry forward
@CARRYFORWARDPASTDUEAMOUNT	money	IN
@EXPIRATIONREASONID	uniqueidentifier	IN	Reason

Definition

Copy



CREATE procedure USP_DATAFORMTEMPLATE_EDIT_SPONSORSHIPREASSIGN
(
    @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 datetime,
    @SENDREMINDER bit,
    @FINDERNUMBER bigint,
    @SOURCECODE nvarchar(50),
    @APPEALID uniqueidentifier,
    @MAILINGID uniqueidentifier,
    @CHANNELCODEID uniqueidentifier,
    @REFERENCE nvarchar(255),
    @CATEGORYCODEID uniqueidentifier,
    @CARRYFORWARDPASTDUE bit,
    @CARRYFORWARDPASTDUEAMOUNT money,
    @EXPIRATIONREASONID uniqueidentifier
)

as
    set nocount on;

    declare @TRANSACTIONCURRENCYID uniqueidentifier;
    declare @BASEEXCHANGERATEID uniqueidentifier;
    declare @EXCHANGERATE decimal(20,8);
    declare @CURRENTAPPUSERID uniqueidentifier;

    exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_SPONSORSHIPREASSIGN
        @ID = @ID,
        @TRANSACTIONCURRENCYID = @TRANSACTIONCURRENCYID output,
        @BASEEXCHANGERATEID = @BASEEXCHANGERATEID output,
        @EXCHANGERATE = @EXCHANGERATE output,
        @CURRENTAPPUSERID = @CURRENTAPPUSERID output

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

    return 0;