USP_DATAFORMTEMPLATE_EDITLOAD_SPONSORSHIPOVERRIDETRANSFER

The load procedure used by the edit dataform template "Override Pending Sponsorship Transfer Edit Form"

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.
@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.
@FORMTITLE	nvarchar(100)	INOUT
@ORIGINALOPPORTUNITYID	uniqueidentifier	INOUT
@REVENUECONSTITUENTID	uniqueidentifier	INOUT	Financial sponsor
@SPONSORSHIPCONSTITUENTID	uniqueidentifier	INOUT	Corresponding sponsor
@SPONSORSHIPPROGRAMID	uniqueidentifier	INOUT	Program
@SPONSORSHIPLOCATIONID	uniqueidentifier	INOUT	Location
@GENDERCODE	int	INOUT	Gender
@SPROPPAGERANGEID	uniqueidentifier	INOUT	Age range
@ISHIVPOSITIVECODE	int	INOUT	HIV positive
@HASCONDITIONCODE	int	INOUT	Disability/Illness
@ISORPHANEDCODE	int	INOUT	Orphaned
@ISSOLESPONSORSHIP	bit	INOUT	Sole sponsorship
@STARTDATE	date	INOUT	Transfer date
@SPROPPPROJECTCATEGORYCODEID	uniqueidentifier	INOUT	Category
@AMOUNT	money	INOUT	Amount
@PAYMENTMETHODCODE	tinyint	INOUT	Payment method
@REFERENCEDATE	UDT_FUZZYDATE	INOUT	Reference date
@REFERENCENUMBER	nvarchar(20)	INOUT	Reference no.
@CARDHOLDERNAME	nvarchar(100)	INOUT	Name on card
@CREDITCARDNUMBER	nvarchar(20)	INOUT	Card number
@CREDITTYPECODEID	uniqueidentifier	INOUT	Card type
@EXPIRESON	UDT_FUZZYDATE	INOUT	Expires on
@CONSTITUENTACCOUNTID	uniqueidentifier	INOUT	Account
@FREQUENCYCODE	tinyint	INOUT	Frequency
@REVENUESCHEDULEENDDATE	datetime	INOUT	Ending on
@REVENUESCHEDULESTARTDATE	datetime	INOUT	Starting on
@AUTOPAY	bit	INOUT	Pay installments automatically by:
@CREDITCARDTOKEN	uniqueidentifier	INOUT
@SPONSORSHIPREASONID	uniqueidentifier	INOUT	Reason
@SPONSORSHIPOPPORTUNITYIDCHILD	uniqueidentifier	INOUT	Child
@SPONSORSHIPOPPORTUNITYIDPROJECT	uniqueidentifier	INOUT	Project
@GIFTRECIPIENT	bit	INOUT	Gift
@PLANNEDENDDATE	date	INOUT	Expiration date
@RESERVEDOPPORTUNITYIDCHILD	uniqueidentifier	INOUT	Child
@RESERVATIONKEY	uniqueidentifier	INOUT	Reservation key
@MATCHEDOPPORTUNITYID	uniqueidentifier	INOUT
@SENDREMINDER	bit	INOUT	Send reminders
@NEXTINSTALLMENTID	uniqueidentifier	INOUT
@FINDERNUMBER	bigint	INOUT	Finder number
@SOURCECODE	nvarchar(50)	INOUT	Source code
@APPEALID	uniqueidentifier	INOUT	Appeal
@MAILINGID	uniqueidentifier	INOUT	Effort
@CHANNELCODEID	uniqueidentifier	INOUT	Inbound channel
@REFERENCE	nvarchar(255)	INOUT	Reference
@CATEGORYCODEID	uniqueidentifier	INOUT	Revenue category
@REVENUEDEVELOPMENTFUNCTIONCODEID	uniqueidentifier	INOUT	Revenue function
@EDITSTARTDATE	bit	INOUT
@LASTACTIVITYDATE	date	INOUT
@EXPIRATIONREASONID	uniqueidentifier	INOUT	Reason
@BASECURRENCYID	uniqueidentifier	INOUT
@TRANSACTIONCURRENCYID	uniqueidentifier	INOUT	Transaction currency
@BASEEXCHANGERATEID	uniqueidentifier	INOUT	Exchange rate
@EXCHANGERATE	decimal(20, 8)	INOUT	Exchange rate
@HADSPOTRATE	bit	INOUT	Had spot rate
@RATECHANGED	bit	INOUT	Rate changed
@BASECURRENCYDECIMALDIGITS	tinyint	INOUT	Base currency decimal digits
@BASECURRENCYROUNDINGTYPECODE	tinyint	INOUT	Base currency rounding type code
@BASEAMOUNT	money	INOUT	Base amount
@UPDATERECOGNITIONOPTION	bit	INOUT
@DONOTACKNOWLEDGE	bit	INOUT
@SEPAMANDATEID	uniqueidentifier	INOUT
@OTHERPAYMENTMETHODCODEID	uniqueidentifier	INOUT

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_SPONSORSHIPOVERRIDETRANSFER(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @TSLONG bigint = 0 output,
    @FORMTITLE nvarchar(100) = null output,
    @ORIGINALOPPORTUNITYID uniqueidentifier = null output,
    @REVENUECONSTITUENTID uniqueidentifier = null output,
    @SPONSORSHIPCONSTITUENTID uniqueidentifier = null output,
    @SPONSORSHIPPROGRAMID uniqueidentifier = null output,
    @SPONSORSHIPLOCATIONID uniqueidentifier = null output,
    @GENDERCODE int = null output,
    @SPROPPAGERANGEID uniqueidentifier = null output,
    @ISHIVPOSITIVECODE int = null output,
    @HASCONDITIONCODE int = null output,
    @ISORPHANEDCODE int = null output,
    @ISSOLESPONSORSHIP bit = null output,
    @STARTDATE date = null output,
    @SPROPPPROJECTCATEGORYCODEID uniqueidentifier = null output,
    @AMOUNT money = null output,
    @PAYMENTMETHODCODE tinyint = null output,
    @REFERENCEDATE dbo.UDT_FUZZYDATE = null output,
    @REFERENCENUMBER nvarchar(20) = null output,
    @CARDHOLDERNAME nvarchar(100) = null output,
    @CREDITCARDNUMBER nvarchar(20) = null output,
    @CREDITTYPECODEID uniqueidentifier = null output,
    @EXPIRESON dbo.UDT_FUZZYDATE = null output,
    @CONSTITUENTACCOUNTID uniqueidentifier = null output,
    @FREQUENCYCODE tinyint = null output,
    @REVENUESCHEDULEENDDATE datetime = null output,
    @REVENUESCHEDULESTARTDATE datetime = null output,
    @AUTOPAY bit = null output,
    @CREDITCARDTOKEN uniqueidentifier = null output,
    -- not set, just satisfying the req's of an Edit Form

    @SPONSORSHIPREASONID uniqueidentifier = null output,
    @SPONSORSHIPOPPORTUNITYIDCHILD uniqueidentifier = null output,
    @SPONSORSHIPOPPORTUNITYIDPROJECT uniqueidentifier = null output,
    @GIFTRECIPIENT bit = null output,
    @PLANNEDENDDATE date = null output,
    @RESERVEDOPPORTUNITYIDCHILD uniqueidentifier = null output,
    @RESERVATIONKEY uniqueidentifier = null output,
    @MATCHEDOPPORTUNITYID uniqueidentifier = null output,
    @SENDREMINDER bit = null output,
    @NEXTINSTALLMENTID uniqueidentifier = null output,
    @FINDERNUMBER bigint = null output,
    @SOURCECODE nvarchar(50) = null output,
    @APPEALID uniqueidentifier = null output,
    @MAILINGID uniqueidentifier = null output,
    @CHANNELCODEID uniqueidentifier = null output,
    @REFERENCE nvarchar(255) = null output,
    @CATEGORYCODEID uniqueidentifier = null output,
    @REVENUEDEVELOPMENTFUNCTIONCODEID uniqueidentifier = null output,
    @EDITSTARTDATE bit = null output,
    @LASTACTIVITYDATE date = null output,
    @EXPIRATIONREASONID uniqueidentifier = null output,
    @BASECURRENCYID uniqueidentifier = null output,
    @TRANSACTIONCURRENCYID uniqueidentifier = null output,
    @BASEEXCHANGERATEID uniqueidentifier = null output,
    @EXCHANGERATE decimal(20,8) = null output,
    @HADSPOTRATE bit = null output,
    @RATECHANGED bit = null output,
    @BASECURRENCYDECIMALDIGITS tinyint = null output,
    @BASECURRENCYROUNDINGTYPECODE tinyint = null output,
    @BASEAMOUNT money = null output,
    @UPDATERECOGNITIONOPTION bit = null output,
    @DONOTACKNOWLEDGE bit = null output,
    @SEPAMANDATEID uniqueidentifier = null output,
    @OTHERPAYMENTMETHODCODEID uniqueidentifier = null output
)
as

    set nocount on;

    declare @FROMSPONSORSHIPID uniqueidentifier
    declare @TOSPONSORSHIPID uniqueidentifier

    exec dbo.USP_GETPENDINGTRANSFERSPONSORSHIPS
        @ID,
        @FROMSPONSORSHIPID output,
        @TOSPONSORSHIPID output

    if @FROMSPONSORSHIPID is not null and
       @TOSPONSORSHIPID is not null
    begin
        exec dbo.USP_SPONSORSHIP_TRANSFER_EDITLOAD
            @FROMSPONSORSHIPID,
            1,
            @DATALOADED output,
            @TSLONG output,
            @FORMTITLE output,
            @ORIGINALOPPORTUNITYID output,
            @REVENUECONSTITUENTID output,
            @SPONSORSHIPCONSTITUENTID output,
            @SPONSORSHIPPROGRAMID output,
            @SPONSORSHIPLOCATIONID output,
            @GENDERCODE output,
            @SPROPPAGERANGEID output,
            @ISHIVPOSITIVECODE output,
            @HASCONDITIONCODE output,
            @ISORPHANEDCODE output,
            @SPROPPPROJECTCATEGORYCODEID output,
            @ISSOLESPONSORSHIP output,
            @STARTDATE output,
            @AMOUNT output,
            @PAYMENTMETHODCODE output,
            @REFERENCEDATE output,
            @REFERENCENUMBER output,
            @CARDHOLDERNAME output,
            @CREDITCARDNUMBER output,
            @CREDITTYPECODEID output,
            @EXPIRESON output,
            @CONSTITUENTACCOUNTID output,
            @FREQUENCYCODE output,
            @REVENUESCHEDULEENDDATE output,
            @REVENUESCHEDULESTARTDATE output,
            @AUTOPAY output,
            @CREDITCARDTOKEN output,
            @GIFTRECIPIENT output,
            @PLANNEDENDDATE output,
            @SENDREMINDER output,
            @NEXTINSTALLMENTID output,
            @FINDERNUMBER output,
            @SOURCECODE output,
            @APPEALID output,
            @MAILINGID output,
            @CHANNELCODEID output,
            @REFERENCE output,
            @CATEGORYCODEID output,
            @EDITSTARTDATE output,
            @LASTACTIVITYDATE output,
            @EXPIRATIONREASONID output,
            @BASECURRENCYID output,
            @TRANSACTIONCURRENCYID output,
            @BASEEXCHANGERATEID output,
            @EXCHANGERATE output,
            @HADSPOTRATE output,
            @RATECHANGED output,
            @BASECURRENCYDECIMALDIGITS output,
            @BASECURRENCYROUNDINGTYPECODE output,
            @BASEAMOUNT output,
            @UPDATERECOGNITIONOPTION output,
            @DONOTACKNOWLEDGE output,
            @SEPAMANDATEID output,
            @OTHERPAYMENTMETHODCODEID output;

        -- bug 39664:  Set Original opportunity ID to the overridden sponsorship's opportunity.

        select @ORIGINALOPPORTUNITYID = SPONSORSHIPOPPORTUNITYID
        from dbo.SPONSORSHIP
        where ID = @TOSPONSORSHIPID;
    end

    return 0;