USP_DATAFORMTEMPLATE_EDIT_REVENUEBATCHCONSTITUENTINBATCH

CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_REVENUEBATCHCONSTITUENTINBATCH (
    @ID nvarchar(110),
    @CHANGEAGENTID uniqueidentifier,
    @LASTNAME nvarchar(100),
    @ORGANIZATIONNAME nvarchar(100),
    @FIRSTNAME nvarchar(50),
    @MIDDLENAME nvarchar(50),
    @MAIDENNAME nvarchar(100),
    @NICKNAME nvarchar(50),
    @TITLECODEID uniqueidentifier,
    @SUFFIXCODEID uniqueidentifier,
    @GENDERCODE tinyint,
    @BIRTHDATE dbo.UDT_FUZZYDATE,
    @ADDRESS_ADDRESSTYPECODEID uniqueidentifier,
    @ADDRESS_DONOTMAIL bit,
    @ADDRESS_DONOTMAILREASONCODEID uniqueidentifier,
    @ADDRESS_COUNTRYID uniqueidentifier,
    @ADDRESS_STATEID uniqueidentifier,
    @ADDRESS_ADDRESSBLOCK nvarchar(150),
    @ADDRESS_CITY nvarchar(50),
    @ADDRESS_POSTCODE nvarchar(12),
    @ADDRESS_UPDATEMATCHINGHOUSEHOLDADDRESSES bit,
    -- Address Validation

    @ADDRESS_OMITFROMVALIDATION bit,
    @ADDRESS_CART nvarchar(10),
    @ADDRESS_DPC nvarchar(8),
    @ADDRESS_LOT nvarchar(5),
    @ADDRESS_COUNTYCODEID uniqueidentifier,
    @ADDRESS_CONGRESSIONALDISTRICTCODEID uniqueidentifier,
    @ADDRESS_LASTVALIDATIONATTEMPTDATE datetime,
    @ADDRESS_VALIDATIONMESSAGE nvarchar(100),
    @ADDRESS_CERTIFICATIONDATA integer,
    @PHONE_PHONETYPECODEID uniqueidentifier,
    @PHONE_NUMBER nvarchar(100),
    @EMAILADDRESS_EMAILADDRESSTYPECODEID uniqueidentifier,
    @EMAILADDRESS_EMAILADDRESS dbo.UDT_EMAILADDRESS,
    @MARITALSTATUSCODEID uniqueidentifier,
    @ORGANIZATION_ADDRESSTYPECODEID uniqueidentifier,
    @ORGANIZATION_DONOTMAIL bit,
    @ORGANIZATION_DONOTMAILREASONCODEID uniqueidentifier,
    @ORGANIZATION_COUNTRYID uniqueidentifier,
    @ORGANIZATION_STATEID uniqueidentifier,
    @ORGANIZATION_ADDRESSBLOCK nvarchar(150),
    @ORGANIZATION_CITY nvarchar(50),
    @ORGANIZATION_POSTCODE nvarchar(12),
    -- Address Validation

    @ORGANIZATION_OMITFROMVALIDATION bit,
    @ORGANIZATION_CART nvarchar(10),
    @ORGANIZATION_DPC nvarchar(8),
    @ORGANIZATION_LOT nvarchar(5),
    @ORGANIZATION_COUNTYCODEID uniqueidentifier,
    @ORGANIZATION_CONGRESSIONALDISTRICTCODEID uniqueidentifier,
    @ORGANIZATION_LASTVALIDATIONATTEMPTDATE datetime,
    @ORGANIZATION_VALIDATIONMESSAGE nvarchar(100),
    @ORGANIZATION_CERTIFICATIONDATA integer,
    @ORGANIZATION_PHONETYPECODEID uniqueidentifier,
    @ORGANIZATION_NUMBER nvarchar(100),
    @ORGANIZATION_EMAILADDRESSTYPECODEID uniqueidentifier,
    @ORGANIZATION_EMAILADDRESS dbo.UDT_EMAILADDRESS,
    @WEBADDRESS dbo.UDT_WEBADDRESS,
    @INDUSTRYCODEID uniqueidentifier,
    @NUMEMPLOYEES int,
    @NUMSUBSIDIARIES int,
    @PARENTCORPID uniqueidentifier,
    --Individual's relationship Variables

    @BATCHSPOUSEID uniqueidentifier,
    @BATCHSPOUSERELATIONID uniqueidentifier,
    @SPOUSEID uniqueidentifier,
    @EXISTINGSPOUSE bit,
    @SPOUSE_LASTNAME nvarchar(100),
    @SPOUSE_FIRSTNAME nvarchar(50),
    @SPOUSE_MIDDLENAME nvarchar(50),
    @SPOUSE_MAIDENNAME nvarchar(100),
    @SPOUSE_NICKNAME nvarchar(50),
    @SPOUSE_TITLECODEID uniqueidentifier,
    @SPOUSE_SUFFIXCODEID uniqueidentifier,
    @SPOUSE_GENDERCODE tinyint,
    @SPOUSE_BIRTHDATE dbo.UDT_FUZZYDATE,
    @SPOUSE_RECIPROCALTYPECODEID uniqueidentifier,
    @SPOUSE_RELATIONSHIPTYPECODEID uniqueidentifier,
    @COPYPRIMARYINFORMATION bit,
    @SPOUSE_STARTDATE datetime,
    @ISSPOUSERELATIONSHIP bit,
    --Organization variables

    @BATCHBUSINESSID uniqueidentifier,
    @BATCHBUSINESSRELATIONID uniqueidentifier,
    @BUSINESSID uniqueidentifier,
    @EXISTINGBUSINESS bit,
    @BUSINESS_NAME nvarchar(100),
    @BUSINESS_ADDRESSTYPECODEID uniqueidentifier,
    @BUSINESS_COUNTRYID uniqueidentifier,
    @BUSINESS_STATEID uniqueidentifier,
    @BUSINESS_ADDRESSBLOCK nvarchar(150),
    @BUSINESS_CITY nvarchar(50),
    @BUSINESS_POSTCODE nvarchar(12),
    @BUSINESS_DONOTMAIL bit,
    @BUSINESS_DONOTMAILREASONCODEID uniqueidentifier,
    -- Address Validation

    @BUSINESS_OMITFROMVALIDATION bit,
    @BUSINESS_CART nvarchar(10),
    @BUSINESS_DPC nvarchar(8),
    @BUSINESS_LOT nvarchar(5),
    @BUSINESS_COUNTYCODEID uniqueidentifier,
    @BUSINESS_CONGRESSIONALDISTRICTCODEID uniqueidentifier,
    @BUSINESS_LASTVALIDATIONATTEMPTDATE datetime,
    @BUSINESS_VALIDATIONMESSAGE nvarchar(100),
    @BUSINESS_CERTIFICATIONDATA integer,
    @BUSINESS_PHONETYPECODEID uniqueidentifier,
    @BUSINESS_NUMBER nvarchar(100),
    @BUSINESS_RECIPROCALTYPECODEID uniqueidentifier,
    @BUSINESS_RELATIONSHIPTYPECODEID uniqueidentifier,
    @BUSINESS_STARTDATE datetime,
    @ISCONTACT bit,
    @ISPRIMARYCONTACT bit,
    @CONTACTTYPECODEID uniqueidentifier,
    @POSITION nvarchar(100),
    @ISMATCHINGGIFTRELATIONSHIP bit,
    @CURRENTAPPUSERID uniqueidentifier,
    -- Group/Household variables

    @GROUP_NAME nvarchar(100),
    @GROUP_DESCRIPTION nvarchar(300),
    @GROUP_GIVESANONYMOUSLY bit,
    @GROUP_ADDRESSTYPECODEID uniqueidentifier,
    @GROUP_COUNTRYID uniqueidentifier,
    @GROUP_ADDRESSBLOCK nvarchar(150),
    @GROUP_CITY nvarchar(50),
    @GROUP_STATEID uniqueidentifier,
    @GROUP_OMITFROMVALIDATION bit,
    @GROUP_CART nvarchar(10),
    @GROUP_DPC nvarchar(8),
    @GROUP_LOT nvarchar(5),
    @GROUP_COUNTYCODEID uniqueidentifier,
    @GROUP_CONGRESSIONALDISTRICTCODEID uniqueidentifier,
    @GROUP_LASTVALIDATIONATTEMPTDATE datetime,
    @GROUP_VALIDATIONMESSAGE nvarchar(100),
    @GROUP_CERTIFICATIONDATA integer,
    @GROUP_POSTCODE nvarchar(12),
    @GROUP_PHONETYPECODEID uniqueidentifier,
    @GROUP_NUMBER nvarchar(100),
    @GROUP_EMAILADDRESSTYPECODEID uniqueidentifier,
    @GROUP_EMAILADDRESS dbo.UDT_EMAILADDRESS,
    @GROUP_WEBADDRESS dbo.UDT_WEBADDRESS,
    @GROUP_DONOTMAIL bit,
    @GROUP_DONOTMAILREASONCODEID uniqueidentifier,
    @GROUP_UPDATEMATCHINGHOUSEHOLDADDRESSES bit,
    -- Group variables

    @GROUP_GROUPTYPEID uniqueidentifier,
    @GROUP_PRIMARYCONTACTID uniqueidentifier,
    @GROUP_MEMBERS xml,
    @GROUP_NEWMEMBERSEARCHID uniqueidentifier, -- Not used in save operation, only exists to setup new member lookup control.

    @GROUP_STARTDATE datetime,
    -- Household Primary Member variables

    @HOUSEHOLD_PRIMARYCONTACTID uniqueidentifier,
    @HOUSEHOLD_PRIMARYCONTACT_KEYNAME nvarchar(100),
    @HOUSEHOLD_PRIMARYCONTACT_FIRSTNAME nvarchar(50),
    @HOUSEHOLD_PRIMARYCONTACT_MIDDLENAME nvarchar(50),
    @HOUSEHOLD_PRIMARYCONTACT_TITLECODEID uniqueidentifier,
    @HOUSEHOLD_PRIMARYCONTACT_SUFFIXCODEID uniqueidentifier,
    @HOUSEHOLD_PRIMARYCONTACT_COPYHOUSEHOLDCONTACT bit,
    -- Household Second Member variables

    @HOUSEHOLD_SECONDMEMBERID uniqueidentifier,
    @HOUSEHOLD_SECONDMEMBER_KEYNAME nvarchar(100),
    @HOUSEHOLD_SECONDMEMBER_FIRSTNAME nvarchar(50),
    @HOUSEHOLD_SECONDMEMBER_MIDDLENAME nvarchar(50),
    @HOUSEHOLD_SECONDMEMBER_TITLECODEID uniqueidentifier,
    @HOUSEHOLD_SECONDMEMBER_SUFFIXCODEID uniqueidentifier,
    @HOUSEHOLD_SECONDMEMBER_COPYHOUSEHOLDCONTACT bit,
    -- Household Second Member Relationship variables

    @HOUSEHOLD_SECONDMEMBER_RELATIONSHIP_RECIPROCALTYPECODEID uniqueidentifier,
    @HOUSEHOLD_SECONDMEMBER_RELATIONSHIP_RELATIONSHIPTYPECODEID uniqueidentifier,
    @HOUSEHOLD_SECONDMEMBER_RELATIONSHIP_STARTDATE datetime,
    @HOUSEHOLD_SECONDMEMBER_RELATIONSHIP_ISSPOUSE bit,
    -- Individual's household fields

    @HOUSEHOLDCOPYPRIMARYCONTACTINFO bit,
    @JOBCATEGORYCODEID uniqueidentifier,
    @CAREERLEVELCODEID uniqueidentifier,
    @GROUP_DONOTCALL bit,
    @GROUP_DONOTEMAIL bit,
    -- The records that were shown on the form.

    @ADDRESSID uniqueidentifier,
    @PHONEID uniqueidentifier,
    @EMAILADDRESSID uniqueidentifier,
    -- Fields specific to BBIS created ERB

    @SITEID uniqueidentifier,
    @CONSTITUENTSECURITYGROUPID uniqueidentifier,
    @CONSTITUENCYCODEID uniqueidentifier,
    @INFOSOURCECODEID uniqueidentifier,
    @NAMEFORMATS xml,
    @PHONE_COUNTRYID uniqueidentifier
    )
as
begin
    declare @SPOUSE_LOOKUPID nvarchar(100)

    exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_REVENUEBATCHCONSTITUENTINBATCH 
        @ID = @ID,
        @CURRENTAPPUSERID = @CURRENTAPPUSERID,
        @SPOUSE_LOOKUPID = @SPOUSE_LOOKUPID output,
    @SPOUSEID = @SPOUSEID output


    exec dbo.USP_DATAFORMTEMPLATE_EDIT_REVENUEBATCHCONSTITUENTINBATCH_2 
        @ID,
        @CHANGEAGENTID,
        @LASTNAME,
        @ORGANIZATIONNAME,
        @FIRSTNAME,
        @MIDDLENAME,
        @MAIDENNAME,
        @NICKNAME,
        @TITLECODEID,
        @SUFFIXCODEID,
        @GENDERCODE,
        @BIRTHDATE,
        @ADDRESS_ADDRESSTYPECODEID,
        @ADDRESS_DONOTMAIL,
        @ADDRESS_DONOTMAILREASONCODEID,
        @ADDRESS_COUNTRYID,
        @ADDRESS_STATEID,
        @ADDRESS_ADDRESSBLOCK,
        @ADDRESS_CITY,
        @ADDRESS_POSTCODE,
        @ADDRESS_UPDATEMATCHINGHOUSEHOLDADDRESSES,
        -- Address Validation

        @ADDRESS_OMITFROMVALIDATION,
        @ADDRESS_CART,
        @ADDRESS_DPC,
        @ADDRESS_LOT,
        @ADDRESS_COUNTYCODEID,
        @ADDRESS_CONGRESSIONALDISTRICTCODEID,
        @ADDRESS_LASTVALIDATIONATTEMPTDATE,
        @ADDRESS_VALIDATIONMESSAGE,
        @ADDRESS_CERTIFICATIONDATA,
        @PHONE_PHONETYPECODEID,
        @PHONE_NUMBER,
        @EMAILADDRESS_EMAILADDRESSTYPECODEID,
        @EMAILADDRESS_EMAILADDRESS,
        @MARITALSTATUSCODEID,
        @ORGANIZATION_ADDRESSTYPECODEID,
        @ORGANIZATION_DONOTMAIL,
        @ORGANIZATION_DONOTMAILREASONCODEID,
        @ORGANIZATION_COUNTRYID,
        @ORGANIZATION_STATEID,
        @ORGANIZATION_ADDRESSBLOCK,
        @ORGANIZATION_CITY,
        @ORGANIZATION_POSTCODE,
        -- Address Validation

        @ORGANIZATION_OMITFROMVALIDATION,
        @ORGANIZATION_CART,
        @ORGANIZATION_DPC,
        @ORGANIZATION_LOT,
        @ORGANIZATION_COUNTYCODEID,
        @ORGANIZATION_CONGRESSIONALDISTRICTCODEID,
        @ORGANIZATION_LASTVALIDATIONATTEMPTDATE,
        @ORGANIZATION_VALIDATIONMESSAGE,
        @ORGANIZATION_CERTIFICATIONDATA,
        @ORGANIZATION_PHONETYPECODEID,
        @ORGANIZATION_NUMBER,
        @ORGANIZATION_EMAILADDRESSTYPECODEID,
        @ORGANIZATION_EMAILADDRESS,
        @WEBADDRESS,
        @INDUSTRYCODEID,
        @NUMEMPLOYEES,
        @NUMSUBSIDIARIES,
        @PARENTCORPID,
        --Individual's relationship Variables

        @BATCHSPOUSEID,
        @BATCHSPOUSERELATIONID,
        @SPOUSEID,
        @EXISTINGSPOUSE,
        @SPOUSE_LASTNAME,
        @SPOUSE_FIRSTNAME,
        @SPOUSE_MIDDLENAME,
        @SPOUSE_MAIDENNAME,
        @SPOUSE_NICKNAME,
        @SPOUSE_TITLECODEID,
        @SPOUSE_SUFFIXCODEID,
        @SPOUSE_GENDERCODE,
        @SPOUSE_BIRTHDATE,
        @SPOUSE_RECIPROCALTYPECODEID,
        @SPOUSE_RELATIONSHIPTYPECODEID,
        @COPYPRIMARYINFORMATION,
        @SPOUSE_STARTDATE,
        @ISSPOUSERELATIONSHIP,
        --Organization variables

        @BATCHBUSINESSID,
        @BATCHBUSINESSRELATIONID,
        @BUSINESSID,
        @EXISTINGBUSINESS,
        @BUSINESS_NAME,
        @BUSINESS_ADDRESSTYPECODEID,
        @BUSINESS_COUNTRYID,
        @BUSINESS_STATEID,
        @BUSINESS_ADDRESSBLOCK,
        @BUSINESS_CITY,
        @BUSINESS_POSTCODE,
        @BUSINESS_DONOTMAIL,
        @BUSINESS_DONOTMAILREASONCODEID,
        -- Address Validation

        @BUSINESS_OMITFROMVALIDATION,
        @BUSINESS_CART,
        @BUSINESS_DPC,
        @BUSINESS_LOT,
        @BUSINESS_COUNTYCODEID,
        @BUSINESS_CONGRESSIONALDISTRICTCODEID,
        @BUSINESS_LASTVALIDATIONATTEMPTDATE,
        @BUSINESS_VALIDATIONMESSAGE,
        @BUSINESS_CERTIFICATIONDATA,
        @BUSINESS_PHONETYPECODEID,
        @BUSINESS_NUMBER,
        @BUSINESS_RECIPROCALTYPECODEID,
        @BUSINESS_RELATIONSHIPTYPECODEID,
        @BUSINESS_STARTDATE,
        @ISCONTACT,
        @ISPRIMARYCONTACT,
        @CONTACTTYPECODEID,
        @POSITION,
        @ISMATCHINGGIFTRELATIONSHIP,
        @CURRENTAPPUSERID,
        -- Group/Household variables

        @GROUP_NAME,
        @GROUP_DESCRIPTION,
        @GROUP_GIVESANONYMOUSLY,
        @GROUP_ADDRESSTYPECODEID,
        @GROUP_COUNTRYID,
        @GROUP_ADDRESSBLOCK,
        @GROUP_CITY,
        @GROUP_STATEID,
        @GROUP_OMITFROMVALIDATION,
        @GROUP_CART,
        @GROUP_DPC,
        @GROUP_LOT,
        @GROUP_COUNTYCODEID,
        @GROUP_CONGRESSIONALDISTRICTCODEID,
        @GROUP_LASTVALIDATIONATTEMPTDATE,
        @GROUP_VALIDATIONMESSAGE,
        @GROUP_CERTIFICATIONDATA,
        @GROUP_POSTCODE,
        @GROUP_PHONETYPECODEID,
        @GROUP_NUMBER,
        @GROUP_EMAILADDRESSTYPECODEID,
        @GROUP_EMAILADDRESS,
        @GROUP_WEBADDRESS,
        @GROUP_DONOTMAIL,
        @GROUP_DONOTMAILREASONCODEID,
        @GROUP_UPDATEMATCHINGHOUSEHOLDADDRESSES,
        -- Group variables

        @GROUP_GROUPTYPEID,
        @GROUP_PRIMARYCONTACTID,
        @GROUP_MEMBERS,
        @GROUP_NEWMEMBERSEARCHID,
        @GROUP_STARTDATE,
        -- Household Primary Member variables

        @HOUSEHOLD_PRIMARYCONTACTID,
        @HOUSEHOLD_PRIMARYCONTACT_KEYNAME,
        @HOUSEHOLD_PRIMARYCONTACT_FIRSTNAME,
        @HOUSEHOLD_PRIMARYCONTACT_MIDDLENAME,
        @HOUSEHOLD_PRIMARYCONTACT_TITLECODEID,
        @HOUSEHOLD_PRIMARYCONTACT_SUFFIXCODEID,
        @HOUSEHOLD_PRIMARYCONTACT_COPYHOUSEHOLDCONTACT,
        -- Household Second Member variables

        @HOUSEHOLD_SECONDMEMBERID,
        @HOUSEHOLD_SECONDMEMBER_KEYNAME,
        @HOUSEHOLD_SECONDMEMBER_FIRSTNAME,
        @HOUSEHOLD_SECONDMEMBER_MIDDLENAME,
        @HOUSEHOLD_SECONDMEMBER_TITLECODEID,
        @HOUSEHOLD_SECONDMEMBER_SUFFIXCODEID,
        @HOUSEHOLD_SECONDMEMBER_COPYHOUSEHOLDCONTACT,
        -- Household Second Member Relationship variables

        @HOUSEHOLD_SECONDMEMBER_RELATIONSHIP_RECIPROCALTYPECODEID,
        @HOUSEHOLD_SECONDMEMBER_RELATIONSHIP_RELATIONSHIPTYPECODEID,
        @HOUSEHOLD_SECONDMEMBER_RELATIONSHIP_STARTDATE,
        @HOUSEHOLD_SECONDMEMBER_RELATIONSHIP_ISSPOUSE,
        -- Individual's household fields

        @HOUSEHOLDCOPYPRIMARYCONTACTINFO,
        @JOBCATEGORYCODEID,
        @CAREERLEVELCODEID,
        @GROUP_DONOTCALL,
        @GROUP_DONOTEMAIL,
        -- The records that were shown on the form.

        @ADDRESSID,
        @PHONEID,
        @EMAILADDRESSID,
        -- Fields specific to BBIS created ERB

        @SITEID,
        @CONSTITUENTSECURITYGROUPID,
        @CONSTITUENCYCODEID,
        @INFOSOURCECODEID,
        @NAMEFORMATS,
        @PHONE_COUNTRYID,
        @SPOUSE_LOOKUPID
end