USP_DATAFORMTEMPLATE_EDIT_CONSTITUENTUPDATEBATCHTEMPLATE_4

CREATE procedure USP_DATAFORMTEMPLATE_EDIT_CONSTITUENTUPDATEBATCHTEMPLATE_4
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @VALIDATEONLY bit,
    @CONSTITUENTTYPECODE tinyint,
    @BIRTHDATE dbo.UDT_FUZZYDATE,
    @FIRSTNAME nvarchar(50),
    @GENDERCODE tinyint,
    @GIVESANONYMOUSLY bit,
    @KEYNAME nvarchar(100),
    @LOOKUPID nvarchar(100),
    @MAIDENNAME nvarchar(100),
    @MIDDLENAME nvarchar(50),
    @NICKNAME nvarchar(50),
    @SUFFIXCODEID uniqueidentifier,
    @TITLECODEID uniqueidentifier,
    @WEBADDRESS dbo.UDT_WEBADDRESS,
    @ALTERNATELOOKUPIDS xml,
    @SECURITYATTRIBUTES xml,
    @DECEASED bit,
    @DECEASEDDATE dbo.UDT_FUZZYDATE,
    @CONSTITUENT_SITEID uniqueidentifier,
    @INTERESTS xml,
    @PROSPECTMANAGERFUNDRAISERID uniqueidentifier,
    --@EDUCATIONALINVOLVEMENTS xml,

    @ADDRESSES xml,
    @EMAILADDRESSES xml,
    @PHONES xml,
    @CONSTITUENCIES xml,
    @GROUPTYPEID uniqueidentifier,
    @GROUPDESCRIPTION nvarchar(300),
    @GROUPSTARTDATE date,
    @ORG_INDUSTRYCODEID uniqueidentifier,
    @ORG_NUMEMPLOYEES int,
    @ORG_NUMSUBSIDIARIES int,
    @ORG_PARENTCORPID uniqueidentifier,
    @MARITALSTATUSCODEID uniqueidentifier,    
    @SPOUSE_ID uniqueidentifier,
    @SPOUSE_BIRTHDATE dbo.UDT_FUZZYDATE,
    @SPOUSE_FIRSTNAME nvarchar(50),
    @SPOUSE_GENDERCODE tinyint,
    @SPOUSE_LASTNAME nvarchar(100),
    @SPOUSE_LOOKUPID nvarchar(100),
    @SPOUSE_MAIDENNAME nvarchar(100),
    @SPOUSE_MIDDLENAME nvarchar(50),
    @SPOUSE_NICKNAME nvarchar(50),
    @SPOUSE_SUFFIXCODEID uniqueidentifier,
    @SPOUSE_TITLECODEID uniqueidentifier,
    @SPOUSE_RELATIONSHIPTYPECODEID uniqueidentifier,
    @SPOUSE_RECIPROCALTYPECODEID uniqueidentifier,
    @BUSINESS_ADDRESSBLOCK nvarchar(150),
    @BUSINESS_ADDRESSTYPECODEID uniqueidentifier,
    @BUSINESS_CART nvarchar(10),
    @BUSINESS_CITY nvarchar(50),
    @BUSINESS_COUNTRYID uniqueidentifier,
    @BUSINESS_DONOTMAIL bit,
    @BUSINESS_DONOTMAILREASONCODEID uniqueidentifier,
    @BUSINESS_DPC nvarchar(8),
    @BUSINESS_EMAILADDRESS dbo.UDT_EMAILADDRESS,
    @BUSINESS_EMAILADDRESSTYPECODEID uniqueidentifier,
    @BUSINESS_INDUSTRYCODEID uniqueidentifier,
    @BUSINESS_LOOKUPID nvarchar(100),
    @BUSINESS_LOT nvarchar(5),
    @BUSINESS_ID uniqueidentifier,
    @BUSINESS_NAME nvarchar(100),
    @BUSINESS_NUMEMPLOYEES int,
    @BUSINESS_NUMSUBSIDIARIES int,
    @BUSINESS_PARENTCORPID uniqueidentifier,
    @BUSINESS_PHONENUMBER nvarchar(100),
    @BUSINESS_PHONE_COUNTRYID uniqueidentifier,
    @BUSINESS_PHONETYPECODEID uniqueidentifier,
    @BUSINESS_RELATIONSHIPTYPECODEID uniqueidentifier,
    @BUSINESS_RECIPROCALTYPECODEID uniqueidentifier,
    @BUSINESS_STATEID uniqueidentifier,
    @BUSINESS_WEBADDRESS dbo.UDT_WEBADDRESS,
    @BUSINESS_POSTCODE nvarchar(12),
    @CURRENTAPPUSERID uniqueidentifier,
    @SPOUSE_RELATIONSHIPTYPECODEIDSIMPLELIST uniqueidentifier,
    @SPOUSE_RECIPROCALTYPECODEIDSIMPLELIST uniqueidentifier,
    @BUSINESS_RELATIONSHIPTYPECODEIDSIMPLELIST uniqueidentifier,
    @BUSINESS_RECIPROCALTYPECODEIDSIMPLELIST uniqueidentifier,
    @BUSINESS_PRIMARYSOFTCREDITRELATIONSHIPEXISTS bit,
    @BUSINESS_PRIMARYSOFTCREDITMATCHFACTOR decimal(5,2),
    @BUSINESS_RECIPROCALSOFTCREDITRELATIONSHIPEXISTS bit,
    @BUSINESS_RECIPROCALSOFTCREDITMATCHFACTOR decimal(5,2),
    @BUSINESS_PRIMARYRECOGNITIONTYPECODEID uniqueidentifier,
    @BUSINESS_RECIPROCALRECOGNITIONTYPECODEID uniqueidentifier,
    @BUSINESS_EMAILADDRESSSTARTDATE date
)

as
  set nocount on;

    declare @SPOUSE_PRIMARYSOFTCREDITRELATIONSHIPEXISTS bit;
    declare @SPOUSE_PRIMARYSOFTCREDITMATCHFACTOR decimal(5,2);
    declare @SPOUSE_RECIPROCALSOFTCREDITRELATIONSHIPEXISTS bit;
    declare @SPOUSE_RECIPROCALSOFTCREDITMATCHFACTOR decimal(5,2);
    declare @SPOUSE_PRIMARYRECOGNITIONTYPECODEID uniqueidentifier;
    declare @SPOUSE_RECIPROCALRECOGNITIONTYPECODEID uniqueidentifier;
    declare @CONSTITUENT_SITES xml;

  exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_CONSTITUENTUPDATEBATCHTEMPLATE
        @ID = @ID,
        @SPOUSE_PRIMARYSOFTCREDITRELATIONSHIPEXISTS = @SPOUSE_PRIMARYSOFTCREDITRELATIONSHIPEXISTS output,
        @SPOUSE_PRIMARYSOFTCREDITMATCHFACTOR = @SPOUSE_PRIMARYSOFTCREDITMATCHFACTOR output,
        @SPOUSE_RECIPROCALSOFTCREDITRELATIONSHIPEXISTS = @SPOUSE_RECIPROCALSOFTCREDITRELATIONSHIPEXISTS output,
        @SPOUSE_RECIPROCALSOFTCREDITMATCHFACTOR = @SPOUSE_RECIPROCALSOFTCREDITMATCHFACTOR output,
        @SPOUSE_PRIMARYRECOGNITIONTYPECODEID = @SPOUSE_PRIMARYRECOGNITIONTYPECODEID output,
        @SPOUSE_RECIPROCALRECOGNITIONTYPECODEID = @SPOUSE_RECIPROCALRECOGNITIONTYPECODEID output,
        @CONSTITUENT_SITES = @CONSTITUENT_SITES output

  exec dbo.USP_DATAFORMTEMPLATE_EDIT_CONSTITUENTUPDATEBATCHTEMPLATE_5
        @ID,
        @CHANGEAGENTID,
        @VALIDATEONLY,
        @CONSTITUENTTYPECODE,
        @BIRTHDATE,
        @FIRSTNAME,
        @GENDERCODE,
        @GIVESANONYMOUSLY,
        @KEYNAME,
        @LOOKUPID,
        @MAIDENNAME,
        @MIDDLENAME,
        @NICKNAME,
        @SUFFIXCODEID,
        @TITLECODEID,
        @WEBADDRESS,
        @ALTERNATELOOKUPIDS,
        @SECURITYATTRIBUTES,
        @DECEASED,
        @DECEASEDDATE,
        @CONSTITUENT_SITEID,
        @INTERESTS,
        @PROSPECTMANAGERFUNDRAISERID,
        --@EDUCATIONALINVOLVEMENTS,

        @ADDRESSES,
        @EMAILADDRESSES,
        @PHONES,
        @CONSTITUENCIES,
        @GROUPTYPEID,
        @GROUPDESCRIPTION,
        @GROUPSTARTDATE,
        @ORG_INDUSTRYCODEID,
        @ORG_NUMEMPLOYEES,
        @ORG_NUMSUBSIDIARIES,
        @ORG_PARENTCORPID,
        @MARITALSTATUSCODEID,
        @SPOUSE_ID,
        @SPOUSE_BIRTHDATE,
        @SPOUSE_FIRSTNAME,
        @SPOUSE_GENDERCODE,
        @SPOUSE_LASTNAME,
        @SPOUSE_LOOKUPID,
        @SPOUSE_MAIDENNAME,
        @SPOUSE_MIDDLENAME,
        @SPOUSE_NICKNAME,
        @SPOUSE_SUFFIXCODEID,
        @SPOUSE_TITLECODEID,
        @SPOUSE_RELATIONSHIPTYPECODEID,
        @SPOUSE_RECIPROCALTYPECODEID,
        @BUSINESS_ADDRESSBLOCK,
        @BUSINESS_ADDRESSTYPECODEID,
        @BUSINESS_CART,
        @BUSINESS_CITY,
        @BUSINESS_COUNTRYID,
        @BUSINESS_DONOTMAIL,
        @BUSINESS_DONOTMAILREASONCODEID,
        @BUSINESS_DPC,
        @BUSINESS_EMAILADDRESS,
        @BUSINESS_EMAILADDRESSTYPECODEID,
        @BUSINESS_INDUSTRYCODEID,
        @BUSINESS_LOOKUPID,
        @BUSINESS_LOT,
        @BUSINESS_ID,
        @BUSINESS_NAME,
        @BUSINESS_NUMEMPLOYEES,
        @BUSINESS_NUMSUBSIDIARIES,
        @BUSINESS_PARENTCORPID,
        @BUSINESS_PHONENUMBER,
        @BUSINESS_PHONE_COUNTRYID,
        @BUSINESS_PHONETYPECODEID,
        @BUSINESS_RELATIONSHIPTYPECODEID,
        @BUSINESS_RECIPROCALTYPECODEID,
        @BUSINESS_STATEID,
        @BUSINESS_WEBADDRESS,
        @BUSINESS_POSTCODE,
        @CURRENTAPPUSERID,
        @SPOUSE_RELATIONSHIPTYPECODEIDSIMPLELIST,
        @SPOUSE_RECIPROCALTYPECODEIDSIMPLELIST,
        @BUSINESS_RELATIONSHIPTYPECODEIDSIMPLELIST,
        @BUSINESS_RECIPROCALTYPECODEIDSIMPLELIST,
        @BUSINESS_PRIMARYSOFTCREDITRELATIONSHIPEXISTS,
        @BUSINESS_PRIMARYSOFTCREDITMATCHFACTOR,
        @BUSINESS_RECIPROCALSOFTCREDITRELATIONSHIPEXISTS,
        @BUSINESS_RECIPROCALSOFTCREDITMATCHFACTOR,
        @BUSINESS_PRIMARYRECOGNITIONTYPECODEID,
        @BUSINESS_RECIPROCALRECOGNITIONTYPECODEID,
        @BUSINESS_EMAILADDRESSSTARTDATE,
        @SPOUSE_PRIMARYSOFTCREDITRELATIONSHIPEXISTS,
        @SPOUSE_PRIMARYSOFTCREDITMATCHFACTOR,
        @SPOUSE_RECIPROCALSOFTCREDITRELATIONSHIPEXISTS,
        @SPOUSE_RECIPROCALSOFTCREDITMATCHFACTOR,
        @SPOUSE_PRIMARYRECOGNITIONTYPECODEID,
        @SPOUSE_RECIPROCALRECOGNITIONTYPECODEID,
        @CONSTITUENT_SITES

  return 0;