USP_DATAFORMTEMPLATE_EDIT_SPONSORSHIPBATCH_5

Parameters

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

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_SPONSORSHIPBATCH_5
(
  @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,
  @SEPAMANDATEID uniqueidentifier,
  @ADDSEPAMANDATE bit,
  @SEPAMANDATECUSTOMIDENTIFIER nvarchar(35),
  @SEPAMANDATESIGNATUREDATE date,
  @SEPAMANDATETYPECODE tinyint,
  @OTHERPAYMENTMETHODCODEID uniqueidentifier
)
as
  set nocount on;

    declare @IMPORT bit;

  exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_SPONSORSHIPBATCH
    @ID = @ID,
    @IMPORT = @IMPORT output;

  exec dbo.USP_DATAFORMTEMPLATE_EDIT_SPONSORSHIPBATCH_6
        @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,
    @IMPORT = @IMPORT

    return 0;