USP_DATAFORMTEMPLATE_EDIT_SPONSORSHIPBATCH_4

The save procedure used by the edit dataform template "Sponsorship Batch Edit Form".

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.
@SEQUENCE	int	IN	Sequence
@CONSTITUENTID	uniqueidentifier	IN	Corresponding sponsor
@DONORID	uniqueidentifier	IN	Financial sponsor
@PLANNEDENDDATE	datetime	IN	Expiration date
@SPONSORSHIPPROGRAMID	uniqueidentifier	IN	Sponsorship 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
@SPONSORSHIPOPPORTUNITYTYPECODE	tinyint	IN	Sponsorship Opportunity Type
@ISSOLESPONSORSHIP	bit	IN	Sole sponsorship
@STARTDATE	datetime	IN	Start Date
@ENDDATE	datetime	IN	End Date
@AMOUNT	money	IN	Amount
@PAYMENTMETHODCODE	tinyint	IN	Payment method
@FREQUENCYCODE	tinyint	IN	Frequency
@AUTOPAY	bit	IN	Pay installments automatically
@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
@REVENUESCHEDULEENDDATE	datetime	IN	Payment end date
@REVENUESCHEDULESTARTDATE	datetime	IN	Payment start date
@CREDITCARDTOKEN	uniqueidentifier	IN	Credit card token
@ISTRANSIENTCARD	bit	IN	Is transient credit card
@RESERVATIONKEYID	uniqueidentifier	IN	Reservation key
@RESERVEDOPPORTUNITYID	uniqueidentifier	IN	Reserved child
@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
@REVENUECATEGORYCODEID	uniqueidentifier	IN	Revenue category
@ISGIFTSPONSORSHIP	bit	IN	Is gift sponsorship
@EXPIRATIONREASONID	uniqueidentifier	IN	Expiration reason
@BID	uniqueidentifier	IN	Batch helper id
@FINANCIALSPONSORLOOKUPID	uniqueidentifier	IN	Financial sponsor ID
@CORRESPONDINGSPONSORLOOKUPID	uniqueidentifier	IN	Corresponding sponsor ID
@PARTIALCREDITCARDNUMBER	nvarchar(4)	IN	Partial card number
@NEWCONSTITUENT	xml	IN	New corresponding sponsor
@NEWDONORCONSTITUENT	xml	IN	New financial sponsor
@TRANSACTIONCURRENCYID	uniqueidentifier	IN	Transaction currency
@BASECURRENCYID	uniqueidentifier	IN	Base currency
@BASEEXCHANGERATEID	uniqueidentifier	IN	Base exchange rate
@EXCHANGERATE	decimal(20, 8)	IN	Exchange rate
@COMMITMENTID	nvarchar(100)	IN	Commitment Id
@CURRENTAPPUSERID	uniqueidentifier	IN

Definition

Copy



CREATE procedure USP_DATAFORMTEMPLATE_EDIT_SPONSORSHIPBATCH_4
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @SEQUENCE int,
    @CONSTITUENTID uniqueidentifier,
    @DONORID uniqueidentifier,
    @PLANNEDENDDATE datetime,
    @SPONSORSHIPPROGRAMID uniqueidentifier,
    @SPONSORSHIPLOCATIONID uniqueidentifier,
    @GENDERCODE int,
    @SPROPPAGERANGEID uniqueidentifier,
    @ISHIVPOSITIVECODE int,
    @HASCONDITIONCODE int,
    @ISORPHANEDCODE int,
    @SPROPPPROJECTCATEGORYCODEID uniqueidentifier,
    @SPONSORSHIPOPPORTUNITYIDCHILD uniqueidentifier,
    @SPONSORSHIPOPPORTUNITYIDPROJECT uniqueidentifier,
    @SPONSORSHIPOPPORTUNITYTYPECODE tinyint,
    @ISSOLESPONSORSHIP bit ,
    @STARTDATE datetime,
    @ENDDATE datetime,
    @AMOUNT money,
    @PAYMENTMETHODCODE tinyint,
    @FREQUENCYCODE tinyint,
    @AUTOPAY bit,
    @REFERENCEDATE dbo.UDT_FUZZYDATE,
    @REFERENCENUMBER nvarchar(20),
    @CARDHOLDERNAME nvarchar(255),
    @CREDITCARDNUMBER nvarchar(20),
    @CREDITTYPECODEID uniqueidentifier,
    @EXPIRESON dbo.UDT_FUZZYDATE,
    @CONSTITUENTACCOUNTID uniqueidentifier,
    @REVENUESCHEDULEENDDATE datetime,
    @REVENUESCHEDULESTARTDATE datetime,
    @CREDITCARDTOKEN uniqueidentifier,
    @ISTRANSIENTCARD bit,
    @RESERVATIONKEYID uniqueidentifier,
    @RESERVEDOPPORTUNITYID uniqueidentifier,
    @SENDREMINDER bit,
    @FINDERNUMBER bigint,
    @SOURCECODE nvarchar(50),
    @APPEALID uniqueidentifier,
    @MAILINGID uniqueidentifier,
    @CHANNELCODEID uniqueidentifier,
    @REFERENCE nvarchar(255),
    @REVENUECATEGORYCODEID uniqueidentifier,
    @ISGIFTSPONSORSHIP bit,
    @EXPIRATIONREASONID uniqueidentifier,
    @BID uniqueidentifier,
    @FINANCIALSPONSORLOOKUPID uniqueidentifier,
    @CORRESPONDINGSPONSORLOOKUPID uniqueidentifier,
    @PARTIALCREDITCARDNUMBER nvarchar(4),
    @NEWCONSTITUENT xml,
    @NEWDONORCONSTITUENT xml,
    @TRANSACTIONCURRENCYID uniqueidentifier,
    @BASECURRENCYID uniqueidentifier,
    @BASEEXCHANGERATEID uniqueidentifier,
    @EXCHANGERATE decimal(20,8),
    @COMMITMENTID nvarchar(100),
    @CURRENTAPPUSERID uniqueidentifier = null
)

as
  set nocount on;

    declare @SEPAMANDATEID uniqueidentifier;
    declare @ADDSEPAMANDATE bit;
    declare @SEPAMANDATECUSTOMIDENTIFIER nvarchar(35);
    declare @SEPAMANDATESIGNATUREDATE date;
    declare @SEPAMANDATETYPECODE tinyint;
    declare @OTHERPAYMENTMETHODCODEID uniqueidentifier;

  exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_SPONSORSHIPBATCH
        @ID = @ID,
        @SEPAMANDATEID = @SEPAMANDATEID output,
        @ADDSEPAMANDATE = @ADDSEPAMANDATE output,
        @SEPAMANDATECUSTOMIDENTIFIER = @SEPAMANDATECUSTOMIDENTIFIER output,
        @SEPAMANDATESIGNATUREDATE = @SEPAMANDATESIGNATUREDATE output,
        @SEPAMANDATETYPECODE = @SEPAMANDATETYPECODE output,
        @OTHERPAYMENTMETHODCODEID = @OTHERPAYMENTMETHODCODEID output;

  exec dbo.USP_DATAFORMTEMPLATE_EDIT_SPONSORSHIPBATCH_5
        @ID,
        @CHANGEAGENTID,
        @SEQUENCE,
        @CONSTITUENTID,
        @DONORID,
        @PLANNEDENDDATE,
        @SPONSORSHIPPROGRAMID,
        @SPONSORSHIPLOCATIONID,
        @GENDERCODE,
        @SPROPPAGERANGEID,
        @ISHIVPOSITIVECODE,
        @HASCONDITIONCODE,
        @ISORPHANEDCODE,
        @SPROPPPROJECTCATEGORYCODEID,
        @SPONSORSHIPOPPORTUNITYIDCHILD,
        @SPONSORSHIPOPPORTUNITYIDPROJECT,
        @SPONSORSHIPOPPORTUNITYTYPECODE,
        @ISSOLESPONSORSHIP,
        @STARTDATE,
        @ENDDATE,
        @AMOUNT,
        @PAYMENTMETHODCODE,
        @FREQUENCYCODE,
        @AUTOPAY,
        @REFERENCEDATE,
        @REFERENCENUMBER,
        @CARDHOLDERNAME,
        @CREDITCARDNUMBER,
        @CREDITTYPECODEID,
        @EXPIRESON,
        @CONSTITUENTACCOUNTID,
        @REVENUESCHEDULEENDDATE,
        @REVENUESCHEDULESTARTDATE,
        @CREDITCARDTOKEN,
        @ISTRANSIENTCARD,
        @RESERVATIONKEYID,
        @RESERVEDOPPORTUNITYID,
        @SENDREMINDER,
        @FINDERNUMBER,
        @SOURCECODE,
        @APPEALID,
        @MAILINGID,
        @CHANNELCODEID,
        @REFERENCE,
        @REVENUECATEGORYCODEID,
        @ISGIFTSPONSORSHIP,
        @EXPIRATIONREASONID,
        @BID,
        @FINANCIALSPONSORLOOKUPID,
        @CORRESPONDINGSPONSORLOOKUPID,
        @PARTIALCREDITCARDNUMBER,
        @NEWCONSTITUENT,
        @NEWDONORCONSTITUENT,
        @TRANSACTIONCURRENCYID,
        @BASECURRENCYID,
        @BASEEXCHANGERATEID,
        @EXCHANGERATE,
        @COMMITMENTID,
        @CURRENTAPPUSERID,
        @SEPAMANDATEID,
        @ADDSEPAMANDATE,
        @SEPAMANDATECUSTOMIDENTIFIER,
        @SEPAMANDATESIGNATUREDATE,
        @SEPAMANDATETYPECODE,
        @OTHERPAYMENTMETHODCODEID

  return 0;