USP_DATAFORMTEMPLATE_EDIT_SPONSORSHIPOVERRIDETRANSFER

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.
@SPONSORSHIPREASONID	uniqueidentifier	IN	Reason
@SPONSORSHIPPROGRAMID	uniqueidentifier	IN	Program
@SPONSORSHIPLOCATIONID	uniqueidentifier	IN	Location
@GENDERCODE	int	IN	Gender
@SPROPPAGERANGEID	uniqueidentifier	IN	Age range
@ISHIVPOSITIVECODE	int	IN	HIV positive
@HASCONDITIONCODE	int	IN	Disability/Illness
@ISORPHANEDCODE	int	IN	Orphaned
@SPROPPPROJECTCATEGORYCODEID	uniqueidentifier	IN	Category
@SPONSORSHIPOPPORTUNITYIDCHILD	uniqueidentifier	IN	Child
@SPONSORSHIPOPPORTUNITYIDPROJECT	uniqueidentifier	IN	Project
@ISSOLESPONSORSHIP	bit	IN	Sole sponsorship
@AMOUNT	money	IN	Amount
@FREQUENCYCODE	tinyint	IN	Frequency
@REVENUESCHEDULESTARTDATE	datetime	IN	Starting on
@REVENUESCHEDULEENDDATE	datetime	IN	Ending on
@PLANNEDENDDATE	datetime	IN	Expiration date
@RESERVEDOPPORTUNITYIDCHILD	uniqueidentifier	IN	Child
@RESERVATIONKEY	uniqueidentifier	IN	Reservation key
@MATCHEDOPPORTUNITYID	uniqueidentifier	IN
@SENDREMINDER	bit	IN	Send reminders
@NEXTINSTALLMENTID	uniqueidentifier	IN
@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
@REVENUEDEVELOPMENTFUNCTIONCODEID	uniqueidentifier	IN	Revenue function
@EXPIRATIONREASONID	uniqueidentifier	IN	Reason

Definition

Copy



CREATE procedure USP_DATAFORMTEMPLATE_EDIT_SPONSORSHIPOVERRIDETRANSFER
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @SPONSORSHIPREASONID uniqueidentifier,
    --@MATCHRULE tinyint,

    @SPONSORSHIPPROGRAMID uniqueidentifier,
    @SPONSORSHIPLOCATIONID uniqueidentifier,
    @GENDERCODE int,
    @SPROPPAGERANGEID uniqueidentifier,
    @ISHIVPOSITIVECODE int,
    @HASCONDITIONCODE int,
    @ISORPHANEDCODE int,
    @SPROPPPROJECTCATEGORYCODEID uniqueidentifier,
    @SPONSORSHIPOPPORTUNITYIDCHILD uniqueidentifier,
    @SPONSORSHIPOPPORTUNITYIDPROJECT uniqueidentifier,
    @ISSOLESPONSORSHIP bit,
    @AMOUNT money,
    @FREQUENCYCODE tinyint,
    @REVENUESCHEDULESTARTDATE datetime,
    @REVENUESCHEDULEENDDATE datetime,
    @PLANNEDENDDATE datetime,
    @RESERVEDOPPORTUNITYIDCHILD uniqueidentifier,
    @RESERVATIONKEY uniqueidentifier,
    @MATCHEDOPPORTUNITYID uniqueidentifier,
    @SENDREMINDER bit,
    @NEXTINSTALLMENTID uniqueidentifier,
    @FINDERNUMBER bigint,
    @SOURCECODE nvarchar(50),
    @APPEALID uniqueidentifier,
    @MAILINGID uniqueidentifier,
    @CHANNELCODEID uniqueidentifier,
    @REFERENCE nvarchar(255),
    @CATEGORYCODEID uniqueidentifier,
    @REVENUEDEVELOPMENTFUNCTIONCODEID uniqueidentifier,
    @EXPIRATIONREASONID uniqueidentifier
)

as
    set nocount on;

    declare @TRANSACTIONCURRENCYID uniqueidentifier;
    declare @BASEEXCHANGERATEID uniqueidentifier;
    declare @EXCHANGERATE decimal(20,8);
    declare @HADSPOTRATE bit;
    declare @RATECHANGED bit;

    exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_SPONSORSHIPOVERRIDETRANSFER
        @ID = @ID,
        @TRANSACTIONCURRENCYID = @TRANSACTIONCURRENCYID output,
        @BASEEXCHANGERATEID = @BASEEXCHANGERATEID output,
        @EXCHANGERATE = @EXCHANGERATE output,
        @HADSPOTRATE = @HADSPOTRATE output,
        @RATECHANGED = @RATECHANGED output

    exec dbo.USP_DATAFORMTEMPLATE_EDIT_SPONSORSHIPOVERRIDETRANSFER_2
        @ID,
        @CHANGEAGENTID,
        @SPONSORSHIPREASONID,
        --@MATCHRULE,

        @SPONSORSHIPPROGRAMID,
        @SPONSORSHIPLOCATIONID,
        @GENDERCODE,
        @SPROPPAGERANGEID,
        @ISHIVPOSITIVECODE,
        @HASCONDITIONCODE,
        @ISORPHANEDCODE,
        @SPROPPPROJECTCATEGORYCODEID,
        @SPONSORSHIPOPPORTUNITYIDCHILD,
        @SPONSORSHIPOPPORTUNITYIDPROJECT,
        @ISSOLESPONSORSHIP,
        @AMOUNT,
        @FREQUENCYCODE,
        @REVENUESCHEDULESTARTDATE,
        @REVENUESCHEDULEENDDATE,
        @PLANNEDENDDATE,
        @RESERVEDOPPORTUNITYIDCHILD,
        @RESERVATIONKEY,
        @MATCHEDOPPORTUNITYID,
        @SENDREMINDER,
        @NEXTINSTALLMENTID,
        @FINDERNUMBER,
        @SOURCECODE,
        @APPEALID,
        @MAILINGID,
        @CHANNELCODEID,
        @REFERENCE,
        @CATEGORYCODEID,
        @REVENUEDEVELOPMENTFUNCTIONCODEID,
        @EXPIRATIONREASONID,
        @TRANSACTIONCURRENCYID,
        @BASEEXCHANGERATEID,
        @EXCHANGERATE,
        @HADSPOTRATE,
        @RATECHANGED

    return 0;