USP_DATAFORMTEMPLATE_EDIT_BATCHEVENTSPONSORSHIPROW_2

Parameters

Parameter Parameter Type Mode Description
@ID uniqueidentifier IN
@EVENTID uniqueidentifier IN
@SEQUENCE int IN
@USERID nvarchar(100) IN
@PASSWORD nvarchar(510) IN
@LASTNAME nvarchar(100) IN
@FIRSTNAME nvarchar(100) IN
@MIDDLENAME nvarchar(100) IN
@TITLECODEID uniqueidentifier IN
@SUFFIXCODEID uniqueidentifier IN
@NICKNAME nvarchar(100) IN
@MAIDENNAME nvarchar(200) IN
@BIRTHDATE UDT_FUZZYDATE IN
@GENDERCODE int IN
@MARITALSTATUSCODEID uniqueidentifier IN
@ADDRESSTYPECODEID uniqueidentifier IN
@COUNTRYID uniqueidentifier IN
@ADDRESS nvarchar(300) IN
@CITY nvarchar(100) IN
@STATEID uniqueidentifier IN
@POSTCODE nvarchar(24) IN
@DONOTMAIL bit IN
@DONOTMAILREASONCODEID uniqueidentifier IN
@PHONETYPECODEID uniqueidentifier IN
@PHONENUMBER nvarchar(200) IN
@EMAILADDRESS UDT_EMAILADDRESS IN
@SUBSCRIBEDNEWSLETTERIDS xml IN
@MERCHANTACCOUNTID uniqueidentifier IN
@ISCOMPANYSPONSOR bit IN
@ORGANIZATIONCONSTITUENTID uniqueidentifier IN
@COMPANYNAME nvarchar(200) IN
@COMPANYURL UDT_WEBADDRESS IN
@COMPANY_ADDRESSTYPECODEID uniqueidentifier IN
@COMPANY_COUNTRYID uniqueidentifier IN
@COMPANY_ADDRESS nvarchar(300) IN
@COMPANY_CITY nvarchar(100) IN
@COMPANY_STATEID uniqueidentifier IN
@COMPANY_POSTCODE nvarchar(24) IN
@COMPANY_DONOTMAIL bit IN
@COMPANY_DONOTMAILREASONCODEID uniqueidentifier IN
@COMPANY_PHONETYPECODEID uniqueidentifier IN
@COMPANY_PHONENUMBER nvarchar(200) IN
@COMPANY_EMAILADDRESS UDT_EMAILADDRESS IN
@SPONSORSHIPTYPEID uniqueidentifier IN
@DECLINEBENEFITS bit IN
@SPONSORSHIPURL UDT_WEBADDRESS IN
@SPONSORSHIPMESSAGE nvarchar(2000) IN
@ADDITIONALDONATIONAMOUNT money IN
@PAYMENTMETHODCODE nvarchar(20) IN
@CREDITCARDHOLDER nvarchar(200) IN
@CREDITCARDNUMBER nvarchar(200) IN
@CREDITCARDTYPE uniqueidentifier IN
@EXPIRATIONDATE UDT_FUZZYDATE IN
@CREDITCARDTOKEN uniqueidentifier IN
@CREDITCARDID uniqueidentifier IN
@AUTHORIZATIONCODE nvarchar(20) IN
@TRANSACTIONID uniqueidentifier IN
@REJECTIONMESSAGE nvarchar(250) IN
@TYPECODE tinyint IN
@AMOUNT money IN
@CONSTITUENTID uniqueidentifier IN
@CHECKNUMBER nvarchar(20) IN
@CHECKDATE UDT_FUZZYDATE IN
@BANKACCOUNTTYPECODE nvarchar(20) IN
@BANKACCOUNTHOLDER nvarchar(200) IN
@BANKACCOUNTNUMBER nvarchar(200) IN
@BANKACCOUNTROUTINGCODE nvarchar(200) IN
@SAMEASPRIMARYADDRESS bit IN
@BILLING_ADDRESSTYPECODEID uniqueidentifier IN
@BILLING_COUNTRYID uniqueidentifier IN
@BILLING_ADDRESSBLOCK nvarchar(300) IN
@BILLING_CITY nvarchar(50) IN
@BILLING_STATEID uniqueidentifier IN
@BILLING_POSTCODE nvarchar(24) IN
@BILLING_STATE nvarchar(10) IN
@BILLING_COUNTRY nvarchar(4) IN
@ORIGINALCLIENTUSERID int IN
@ORIGINALCONSTITUENTID uniqueidentifier IN
@PHONEID uniqueidentifier IN
@ADDRESSID uniqueidentifier IN
@EMAILADDRESSID uniqueidentifier IN
@CHANGEAGENTID uniqueidentifier IN
@SENDNOTIFICATIONS bit IN

Definition

Copy 


CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_BATCHEVENTSPONSORSHIPROW_2 (
    @ID uniqueidentifier,
  @EVENTID uniqueidentifier,
  @SEQUENCE int,
  @USERID nvarchar(100),
  @PASSWORD nvarchar(510),
  @LASTNAME nvarchar(100),
  @FIRSTNAME nvarchar(100),
  @MIDDLENAME nvarchar(100),
  @TITLECODEID uniqueidentifier,
  @SUFFIXCODEID uniqueidentifier,
  @NICKNAME nvarchar(100),
  @MAIDENNAME nvarchar(200),
  @BIRTHDATE UDT_FUZZYDATE,
  @GENDERCODE int,
  @MARITALSTATUSCODEID uniqueidentifier,
  @ADDRESSTYPECODEID uniqueidentifier,
  @COUNTRYID uniqueidentifier,
  @ADDRESS nvarchar(300),
  @CITY nvarchar(100),
  @STATEID uniqueidentifier,
  @POSTCODE nvarchar(24),
  @DONOTMAIL bit,
  @DONOTMAILREASONCODEID uniqueidentifier,
  @PHONETYPECODEID uniqueidentifier,
  @PHONENUMBER nvarchar(200),
  @EMAILADDRESS UDT_EMAILADDRESS,

  @SUBSCRIBEDNEWSLETTERIDS xml,
  @MERCHANTACCOUNTID uniqueidentifier,

  @ISCOMPANYSPONSOR bit,
  @ORGANIZATIONCONSTITUENTID uniqueidentifier,
  @COMPANYNAME nvarchar(200),
  @COMPANYURL UDT_WEBADDRESS,
  @COMPANY_ADDRESSTYPECODEID uniqueidentifier,
  @COMPANY_COUNTRYID uniqueidentifier,
  @COMPANY_ADDRESS nvarchar(300),
  @COMPANY_CITY nvarchar(100),
  @COMPANY_STATEID uniqueidentifier,
  @COMPANY_POSTCODE nvarchar(24),
  @COMPANY_DONOTMAIL bit,
  @COMPANY_DONOTMAILREASONCODEID uniqueidentifier,
  @COMPANY_PHONETYPECODEID uniqueidentifier,
  @COMPANY_PHONENUMBER nvarchar(200),
  @COMPANY_EMAILADDRESS UDT_EMAILADDRESS,

  @SPONSORSHIPTYPEID uniqueidentifier,
  @DECLINEBENEFITS bit,
  @SPONSORSHIPURL UDT_WEBADDRESS,
  @SPONSORSHIPMESSAGE nvarchar(2000),

  @ADDITIONALDONATIONAMOUNT money,
  @PAYMENTMETHODCODE nvarchar(20),  
  @CREDITCARDHOLDER nvarchar(200),
  @CREDITCARDNUMBER nvarchar(200),
  @CREDITCARDTYPE uniqueidentifier,
  @EXPIRATIONDATE UDT_FUZZYDATE,
  @CREDITCARDTOKEN uniqueidentifier,
  @CREDITCARDID uniqueidentifier,
  @AUTHORIZATIONCODE nvarchar(20),
  @TRANSACTIONID uniqueidentifier,
  @REJECTIONMESSAGE nvarchar(250),
  @TYPECODE tinyint,
  @AMOUNT money,
  @CONSTITUENTID uniqueidentifier,

  @CHECKNUMBER nvarchar(20),
  @CHECKDATE UDT_FUZZYDATE,
  @BANKACCOUNTTYPECODE nvarchar(20),
  @BANKACCOUNTHOLDER nvarchar(200),
  @BANKACCOUNTNUMBER nvarchar(200),
  @BANKACCOUNTROUTINGCODE nvarchar(200),

  @SAMEASPRIMARYADDRESS bit,
  @BILLING_ADDRESSTYPECODEID uniqueidentifier,
  @BILLING_COUNTRYID uniqueidentifier,
  @BILLING_ADDRESSBLOCK nvarchar(300),
  @BILLING_CITY nvarchar(50),
  @BILLING_STATEID uniqueidentifier,
  @BILLING_POSTCODE nvarchar(24),
  @BILLING_STATE nvarchar(10),
  @BILLING_COUNTRY nvarchar(4),

  @ORIGINALCLIENTUSERID integer,
  @ORIGINALCONSTITUENTID uniqueidentifier,
  @PHONEID uniqueidentifier,
  @ADDRESSID uniqueidentifier,
  @EMAILADDRESSID uniqueidentifier,

  @CHANGEAGENTID uniqueidentifier,

  @SENDNOTIFICATIONS bit
)
as
begin
  set nocount on;

  declare @BNUMBER nvarchar(100);

  exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_BATCHEVENTSPONSORSHIPROW
        @ID = @ID,
        @BNUMBER = @BNUMBER output

  exec dbo.USP_DATAFORMTEMPLATE_EDIT_BATCHEVENTSPONSORSHIPROW_3
    @ID,
    @EVENTID,
    @SEQUENCE,
    @USERID,
    @PASSWORD,
    @LASTNAME,
    @FIRSTNAME,
    @MIDDLENAME,
    @TITLECODEID,
    @SUFFIXCODEID,
    @NICKNAME,
    @MAIDENNAME,
    @BIRTHDATE,
    @GENDERCODE,
    @MARITALSTATUSCODEID,
    @ADDRESSTYPECODEID,
    @COUNTRYID,
    @ADDRESS,
    @CITY,
    @STATEID,
    @POSTCODE,
    @DONOTMAIL,
    @DONOTMAILREASONCODEID,
    @PHONETYPECODEID,
    @PHONENUMBER,
    @EMAILADDRESS,

    @SUBSCRIBEDNEWSLETTERIDS,
    @MERCHANTACCOUNTID,

    @ISCOMPANYSPONSOR,
    @ORGANIZATIONCONSTITUENTID,
    @COMPANYNAME,
    @COMPANYURL,
    @COMPANY_ADDRESSTYPECODEID,
    @COMPANY_COUNTRYID,
    @COMPANY_ADDRESS,
    @COMPANY_CITY,
    @COMPANY_STATEID,
    @COMPANY_POSTCODE,
    @COMPANY_DONOTMAIL,
    @COMPANY_DONOTMAILREASONCODEID,
    @COMPANY_PHONETYPECODEID,
    @COMPANY_PHONENUMBER,
    @COMPANY_EMAILADDRESS,

    @SPONSORSHIPTYPEID,
    @DECLINEBENEFITS,
    @SPONSORSHIPURL,
    @SPONSORSHIPMESSAGE,

    @ADDITIONALDONATIONAMOUNT,
    @PAYMENTMETHODCODE,  
    @CREDITCARDHOLDER,
    @CREDITCARDNUMBER,
    @CREDITCARDTYPE,
    @EXPIRATIONDATE,
    @CREDITCARDTOKEN,
    @CREDITCARDID,
    @AUTHORIZATIONCODE,
    @TRANSACTIONID,
    @REJECTIONMESSAGE,
    @TYPECODE,
    @AMOUNT,
    @CONSTITUENTID,

    @CHECKNUMBER,
    @CHECKDATE,
    @BANKACCOUNTTYPECODE,
    @BANKACCOUNTHOLDER,
    @BANKACCOUNTNUMBER,
    @BANKACCOUNTROUTINGCODE,

    @SAMEASPRIMARYADDRESS,
    @BILLING_ADDRESSTYPECODEID,
    @BILLING_COUNTRYID,
    @BILLING_ADDRESSBLOCK,
    @BILLING_CITY,
    @BILLING_STATEID,
    @BILLING_POSTCODE,
    @BILLING_STATE,
    @BILLING_COUNTRY,

    @ORIGINALCLIENTUSERID,
    @ORIGINALCONSTITUENTID,
    @PHONEID,
    @ADDRESSID,
    @EMAILADDRESSID,

    @CHANGEAGENTID,

    @SENDNOTIFICATIONS,
    @BNUMBER
end