USP_DATAFORMTEMPLATE_ADD_SPONSORSHIP_WRAPPED

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

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	INOUT	The output parameter indicating the ID of the record added.
@CONTEXTID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being 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	Effort
@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_WRAPPED 
(
  @ID uniqueidentifier = null output,
  @CONTEXTID uniqueidentifier,
  @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,
  @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,
  @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
  set nocount on;

  /* invoke the default implementation */
  declare @r int
  exec @r = dbo.USP_DATAFORMTEMPLATE_ADD_SPONSORSHIP 
    @ID = @ID output, 
    @CHANGEAGENTID = @CHANGEAGENTID, 
    @REVENUECONSTITUENTID = @REVENUECONSTITUENTID, 
    @SPONSORSHIPCONSTITUENTID = @SPONSORSHIPCONSTITUENTID, 
    @SPONSORSHIPPROGRAMID = @SPONSORSHIPPROGRAMID, 
    @SPONSORSHIPLOCATIONID = @SPONSORSHIPLOCATIONID, 
    @GENDERCODE = @GENDERCODE, 
    @SPROPPAGERANGEID = @SPROPPAGERANGEID, 
    @ISHIVPOSITIVECODE = @ISHIVPOSITIVECODE, 
    @HASCONDITIONCODE = @HASCONDITIONCODE, 
    @ISORPHANEDCODE = @ISORPHANEDCODE, 
    @SPROPPPROJECTCATEGORYCODEID = @SPROPPPROJECTCATEGORYCODEID, 
    @SPONSORSHIPOPPORTUNITYIDCHILD = @SPONSORSHIPOPPORTUNITYIDCHILD, 
    @SPONSORSHIPOPPORTUNITYIDPROJECT = @SPONSORSHIPOPPORTUNITYIDPROJECT, 
    @ISSOLESPONSORSHIP = @ISSOLESPONSORSHIP, 
    @STARTDATE = @STARTDATE, 
    @AMOUNT = @AMOUNT, 
    @PAYMENTMETHODCODE = @PAYMENTMETHODCODE, 
    @REFERENCEDATE = @REFERENCEDATE, 
    @REFERENCENUMBER = @REFERENCENUMBER, 
    @CARDHOLDERNAME = @CARDHOLDERNAME, 
    @CREDITCARDNUMBER = @CREDITCARDNUMBER, 
    @CREDITTYPECODEID = @CREDITTYPECODEID, 
    @EXPIRESON = @EXPIRESON, 
    @CONSTITUENTACCOUNTID = @CONSTITUENTACCOUNTID, 
    @FREQUENCYCODE = @FREQUENCYCODE, 
    @REVENUESCHEDULEENDDATE = @REVENUESCHEDULEENDDATE, 
    @REVENUESCHEDULESTARTDATE = @REVENUESCHEDULESTARTDATE, 
    @AUTOPAY = @AUTOPAY, 
    @CREDITCARDTOKEN = @CREDITCARDTOKEN, 
    @GIFTRECIPIENT = @GIFTRECIPIENT, 
    @PLANNEDENDDATE = @PLANNEDENDDATE, 
    @RESERVEDOPPORTUNITYIDCHILD = @RESERVEDOPPORTUNITYIDCHILD, 
    @RESERVATIONKEY = @RESERVATIONKEY, 
    @MATCHEDOPPORTUNITYID = @MATCHEDOPPORTUNITYID,
    @SENDREMINDER = @SENDREMINDER,
    @FINDERNUMBER= @FINDERNUMBER,
    @SOURCECODE  = @SOURCECODE,
    @APPEALID  = @APPEALID,
    @MAILINGID = @MAILINGID,
    @CHANNELCODEID  = @CHANNELCODEID,
    @REFERENCE = @REFERENCE,
    @CATEGORYCODEID = @CATEGORYCODEID,
    @EXPIRATIONREASONID = @EXPIRATIONREASONID,
    @TRANSACTIONCURRENCYID = @TRANSACTIONCURRENCYID,
    @BASEEXCHANGERATEID = @BASEEXCHANGERATEID,
    @EXCHANGERATE = @EXCHANGERATE,
    @CURRENTAPPUSERID = @CURRENTAPPUSERID,
    @BATCHNUMBER = @BATCHNUMBER,
    @DONOTACKNOWLEDGE = @DONOTACKNOWLEDGE,
    @SEPAMANDATEID = @SEPAMANDATEID,
    @OTHERPAYMENTMETHODCODEID = @OTHERPAYMENTMETHODCODEID;

  if @@error <> 0 
    begin
      if @r <> 0 return @r
      return 1;
    end

  return @r;