USP_DATAFORMTEMPLATE_ADD_SPONSORSHIP

The save procedure used by the add dataform template "Sponsorship Add Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	INOUT	The output parameter indicating the ID of the record added.
@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
@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
@STARTDATE	date	IN	Start date
@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	date	IN	Expiration date
@RESERVEDOPPORTUNITYIDCHILD	uniqueidentifier	IN	Child
@RESERVATIONKEY	uniqueidentifier	IN	Reservation key
@MATCHEDOPPORTUNITYID	uniqueidentifier	IN
@SENDREMINDER	bit	IN	Send reminders
@FINDERNUMBER	bigint	IN	Finder number
@SOURCECODE	nvarchar(50)	IN	Source code
@APPEALID	uniqueidentifier	IN	Appeal
@MAILINGID	uniqueidentifier	IN	Mailing
@CHANNELCODEID	uniqueidentifier	IN	Inbound channel
@REFERENCE	nvarchar(255)	IN	Reference
@CATEGORYCODEID	uniqueidentifier	IN	Revenue category
@EXPIRATIONREASONID	uniqueidentifier	IN	Reason
@TRANSACTIONCURRENCYID	uniqueidentifier	IN	Transaction currency
@BASEEXCHANGERATEID	uniqueidentifier	IN	Exchange rate
@EXCHANGERATE	decimal(20, 8)	IN	Exchange rate
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@BATCHNUMBER	nvarchar(100)	IN
@DONOTACKNOWLEDGE	bit	IN
@SEPAMANDATEID	uniqueidentifier	IN
@CARRYFORWARDPASTDUE	bit	IN
@CARRYFORWARDPASTDUEAMOUNT	money	IN
@OTHERPAYMENTMETHODCODEID	uniqueidentifier	IN

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_SPONSORSHIP
(
    @ID uniqueidentifier = null output,
    @CHANGEAGENTID uniqueidentifier = null,
    @REVENUECONSTITUENTID uniqueidentifier = null,
    @SPONSORSHIPCONSTITUENTID uniqueidentifier = null,
    @SPONSORSHIPPROGRAMID uniqueidentifier = null,
    @SPONSORSHIPLOCATIONID uniqueidentifier = null,
    @GENDERCODE int = 0,
    @SPROPPAGERANGEID uniqueidentifier = null,
    @ISHIVPOSITIVECODE int = 0,
    @HASCONDITIONCODE int = 0,
    @ISORPHANEDCODE int = 0,
    @SPROPPPROJECTCATEGORYCODEID uniqueidentifier = null,
    @SPONSORSHIPOPPORTUNITYIDCHILD uniqueidentifier = null,
    @SPONSORSHIPOPPORTUNITYIDPROJECT uniqueidentifier = null,
    @ISSOLESPONSORSHIP bit = 0,
    @STARTDATE date = null,
    @AMOUNT money = 0,
    @PAYMENTMETHODCODE tinyint = 2,
    @REFERENCEDATE dbo.UDT_FUZZYDATE = '00000000',
    @REFERENCENUMBER nvarchar(20) = '',
    @CARDHOLDERNAME nvarchar(255) = '',
    @CREDITCARDNUMBER nvarchar(20) = '',
    @CREDITTYPECODEID uniqueidentifier = null,
    @EXPIRESON dbo.UDT_FUZZYDATE = null,
    @CONSTITUENTACCOUNTID uniqueidentifier = null,
    @FREQUENCYCODE tinyint = 3,
    @REVENUESCHEDULEENDDATE datetime = null,
    @REVENUESCHEDULESTARTDATE datetime = null,
    @AUTOPAY bit = 1,
    @CREDITCARDTOKEN uniqueidentifier = null,
    @GIFTRECIPIENT bit = 0,
    @PLANNEDENDDATE date = null,
    @RESERVEDOPPORTUNITYIDCHILD uniqueidentifier = null,
    @RESERVATIONKEY uniqueidentifier = null,
    @MATCHEDOPPORTUNITYID uniqueidentifier = null,
    --Default is true

    @SENDREMINDER bit = 1,
    @FINDERNUMBER bigint = null,
    @SOURCECODE nvarchar(50) = null,
    @APPEALID uniqueidentifier = null,
    @MAILINGID uniqueidentifier = null,
    @CHANNELCODEID uniqueidentifier = null,
    @REFERENCE nvarchar(255) = null,
    @CATEGORYCODEID uniqueidentifier = null,
    @EXPIRATIONREASONID uniqueidentifier = null,
    -- multi-currency

    @TRANSACTIONCURRENCYID uniqueidentifier = null,
    @BASEEXCHANGERATEID uniqueidentifier = null,
    @EXCHANGERATE decimal(20,8) = null,
    @CURRENTAPPUSERID uniqueidentifier = null,
    @BATCHNUMBER nvarchar(100) = '',
    @DONOTACKNOWLEDGE bit = 0,
    @SEPAMANDATEID uniqueidentifier = null,
    @CARRYFORWARDPASTDUE bit = 0,
    @CARRYFORWARDPASTDUEAMOUNT money = null,
    @OTHERPAYMENTMETHODCODEID uniqueidentifier = null
)
as
begin
    if @BATCHNUMBER is null
        set @BATCHNUMBER = '';

    declare @SPONSORSHIPOPPORTUNITYID uniqueidentifier
    set @SPONSORSHIPOPPORTUNITYID = isnull(@SPONSORSHIPOPPORTUNITYIDCHILD,@SPONSORSHIPOPPORTUNITYIDPROJECT)

    if @SPONSORSHIPOPPORTUNITYID is null and @RESERVEDOPPORTUNITYIDCHILD is not null
        set @SPONSORSHIPOPPORTUNITYID = @RESERVEDOPPORTUNITYIDCHILD

    if @SPONSORSHIPOPPORTUNITYID is not null
    begin
        set @SPONSORSHIPLOCATIONID = null;
        set @GENDERCODE = 0;
        set @SPROPPAGERANGEID = null;
        set @ISHIVPOSITIVECODE = 0;
        set @HASCONDITIONCODE = 0;
        set @ISORPHANEDCODE = 0;
        set @SPROPPPROJECTCATEGORYCODEID = null;
    end

    if @SPONSORSHIPOPPORTUNITYID is null and @MATCHEDOPPORTUNITYID is not null
        set @SPONSORSHIPOPPORTUNITYID = @MATCHEDOPPORTUNITYID

    if @SPONSORSHIPOPPORTUNITYID is null
    begin
        raiserror('BBERR_NOOPPORTUNITYSPECIFIED',13,1);
        return 1
    end

    if @GENDERCODE is null
        set @GENDERCODE = 0
    if @ISHIVPOSITIVECODE is null
        set @ISHIVPOSITIVECODE = 0
    if @HASCONDITIONCODE is null
        set @HASCONDITIONCODE = 0
    if @ISORPHANEDCODE is null
        set @ISORPHANEDCODE = 0
    if @FINDERNUMBER is null
      set @FINDERNUMBER = 0

    begin try
        exec dbo.USP_SPONSORSHIP_CREATECOMMITMENT
            @ID output,
            @CHANGEAGENTID,
            @REVENUECONSTITUENTID,
            @SPONSORSHIPCONSTITUENTID,
            null,
            null,
            @SPONSORSHIPPROGRAMID,
            @SPONSORSHIPLOCATIONID,
            @GENDERCODE,
            @SPROPPAGERANGEID,
            @ISHIVPOSITIVECODE,
            @HASCONDITIONCODE,
            @ISORPHANEDCODE,
            @SPROPPPROJECTCATEGORYCODEID,
            @SPONSORSHIPOPPORTUNITYID,
            @ISSOLESPONSORSHIP,
            @STARTDATE,
            @AMOUNT,
            @PAYMENTMETHODCODE,
            @REFERENCEDATE,
            @REFERENCENUMBER,
            @CARDHOLDERNAME,
            @CREDITCARDNUMBER,
            @CREDITTYPECODEID,
            @EXPIRESON,
            @CONSTITUENTACCOUNTID,
            @FREQUENCYCODE,
            @REVENUESCHEDULEENDDATE,
            @REVENUESCHEDULESTARTDATE,
            @AUTOPAY,
            @CREDITCARDTOKEN,
            @PLANNEDENDDATE,
            @SENDREMINDER,
            @FINDERNUMBER,
            @SOURCECODE,
            @APPEALID,
            @MAILINGID,
            @CHANNELCODEID,
            @REFERENCE,
            @CATEGORYCODEID,
            @EXPIRATIONREASONID,
            @TRANSACTIONCURRENCYID,
            @BASEEXCHANGERATEID,
            @EXCHANGERATE,
            @CURRENTAPPUSERID,
            @BATCHNUMBER, 
            @DONOTACKNOWLEDGE,
            default, --DATA

            default, --BASECURRENCYID

            @SEPAMANDATEID,
            @OTHERPAYMENTMETHODCODEID

    end try
    begin catch
      exec dbo.USP_RAISE_ERROR;
      return 1;
    end catch

    return 0
end