USP_DATAFORMTEMPLATE_EDITLOAD_SPONSORSHIPTRANSFER

The load procedure used by the edit dataform template "Transfer Sponsorship 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
@SPROPPPROJECTCATEGORYCODEID	uniqueidentifier	INOUT	Category
@ISSOLESPONSORSHIP	bit	INOUT	Sole sponsorship
@STARTDATE	date	INOUT	Transfer date
@AMOUNT	money	INOUT	Amount
@PAYMENTMETHODCODE	tinyint	INOUT	Payment method
@REFERENCEDATE	UDT_FUZZYDATE	INOUT	Reference date
@REFERENCENUMBER	nvarchar(20)	INOUT	Reference no.
@CARDHOLDERNAME	nvarchar(255)	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	tinyint	INOUT
@DONOTACKNOWLEDGE	bit	INOUT
@SEPAMANDATEID	uniqueidentifier	INOUT
@OTHERPAYMENTMETHODCODEID	uniqueidentifier	INOUT

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_SPONSORSHIPTRANSFER(
    @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,
    @SPROPPPROJECTCATEGORYCODEID uniqueidentifier = null output,
    @ISSOLESPONSORSHIP bit = null output,
    @STARTDATE date = null output,
    @AMOUNT money = null output,
    @PAYMENTMETHODCODE tinyint = null output,
    @REFERENCEDATE dbo.UDT_FUZZYDATE = null output,
    @REFERENCENUMBER nvarchar(20) = null output,
    @CARDHOLDERNAME nvarchar(255) = 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 tinyint = null output,
    @DONOTACKNOWLEDGE bit = null output,
    @SEPAMANDATEID uniqueidentifier = null output,
    @OTHERPAYMENTMETHODCODEID uniqueidentifier = null output
)
as
    exec dbo.USP_SPONSORSHIP_TRANSFER_EDITLOAD
        @ID,
        0,
        @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;

    return 0;