USP_DATAFORMTEMPLATE_EDIT_BATCHEVENTSPONSORSHIPROW_3

Parameters

Parameter	Parameter Type	Mode
@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
@BNUMBER	nvarchar(100)	IN

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_BATCHEVENTSPONSORSHIPROW_3 (
    @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,
    @BNUMBER nvarchar(100)
)
as
begin
    set nocount on;

    declare @VENDORID nvarchar(50);

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

    exec dbo.USP_DATAFORMTEMPLATE_EDIT_BATCHEVENTSPONSORSHIPROW_4
        @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,
        @VENDORID
end