USP_DATAFORMTEMPLATE_EDIT_CONSTITUENTUPDATEBATCHTEMPLATE_12

CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_CONSTITUENTUPDATEBATCHTEMPLATE_12
(
    @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,
    @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,
    @SPOUSE_PRIMARYSOFTCREDITRELATIONSHIPEXISTS bit,
    @SPOUSE_PRIMARYSOFTCREDITMATCHFACTOR decimal(5,2),
    @SPOUSE_RECIPROCALSOFTCREDITRELATIONSHIPEXISTS bit,
    @SPOUSE_RECIPROCALSOFTCREDITMATCHFACTOR decimal(5,2),
    @SPOUSE_PRIMARYRECOGNITIONTYPECODEID uniqueidentifier,
    @SPOUSE_RECIPROCALRECOGNITIONTYPECODEID uniqueidentifier,
      @CONSTITUENT_SITES xml,
      @BATCHOWNERID uniqueidentifier,
      @BATCHROWID uniqueidentifier,
    @SPOUSE_ALTERNATELOOKUPIDS xml,
    @SPOUSE_IMPORTLOOKUPID nvarchar(100),
      @ROWFROMBATCHUI bit, 
      @BBNCTRANID int,
    @REMOVESPOUSE bit,
      @SOCIALMEDIAACCOUNTS xml,
      @RELATIONSHIPS xml,
      @NETCOMMUNITYTRANSACTIONPROCESSORID uniqueidentifier,
    @NEWADDRESSENDDATECODE tinyint,
    @CREATEHISTORICALNAMECODE tinyint,
    @NEWPHONEENDDATECODE tinyint,
    @NEWEMAILENDDATECODE tinyint,
      @NAMEFORMATS xml
  )
as
begin

  declare @REQUESTSNOEMAIL bit;
  exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_CONSTITUENTUPDATEBATCHTEMPLATE 
        @ID = @ID, 
        @REQUESTSNOEMAIL = @REQUESTSNOEMAIL


exec dbo.USP_DATAFORMTEMPLATE_EDIT_CONSTITUENTUPDATEBATCHTEMPLATE_13
      @ID = @ID,
            @CHANGEAGENTID = @CHANGEAGENTID,
      @VALIDATEONLY = @VALIDATEONLY,
      @CONSTITUENTTYPECODE = @CONSTITUENTTYPECODE,
      @BIRTHDATE = @BIRTHDATE,
      @FIRSTNAME = @FIRSTNAME,
      @GENDERCODE = @GENDERCODE,
      @GIVESANONYMOUSLY = @GIVESANONYMOUSLY,
      @KEYNAME = @KEYNAME,
      @LOOKUPID = @LOOKUPID,
      @MAIDENNAME = @MAIDENNAME,
      @MIDDLENAME = @MIDDLENAME,
      @NICKNAME = @NICKNAME,
      @SUFFIXCODEID = @SUFFIXCODEID,
      @TITLECODEID = @TITLECODEID,
      @WEBADDRESS = @WEBADDRESS,
      @ALTERNATELOOKUPIDS = @ALTERNATELOOKUPIDS,
      @SECURITYATTRIBUTES = @SECURITYATTRIBUTES,
      @DECEASED = @DECEASED,
      @DECEASEDDATE = @DECEASEDDATE,
      @CONSTITUENT_SITEID = @CONSTITUENT_SITEID,
      @INTERESTS = @INTERESTS,
      @PROSPECTMANAGERFUNDRAISERID = @PROSPECTMANAGERFUNDRAISERID,
      @ADDRESSES = @ADDRESSES,
      @EMAILADDRESSES = @EMAILADDRESSES,
      @PHONES = @PHONES,
      @CONSTITUENCIES = @CONSTITUENCIES,
      @GROUPTYPEID = @GROUPTYPEID,
      @GROUPDESCRIPTION = @GROUPDESCRIPTION,
      @GROUPSTARTDATE = @GROUPSTARTDATE,
      @ORG_INDUSTRYCODEID = @ORG_INDUSTRYCODEID,
      @ORG_NUMEMPLOYEES = @ORG_NUMEMPLOYEES,
      @ORG_NUMSUBSIDIARIES = @ORG_NUMSUBSIDIARIES,
      @ORG_PARENTCORPID = @ORG_PARENTCORPID,
      @MARITALSTATUSCODEID = @MARITALSTATUSCODEID,    
      @SPOUSE_ID = @SPOUSE_ID,
      @SPOUSE_BIRTHDATE = @SPOUSE_BIRTHDATE,
      @SPOUSE_FIRSTNAME = @SPOUSE_FIRSTNAME,
      @SPOUSE_GENDERCODE = @SPOUSE_GENDERCODE,
      @SPOUSE_LASTNAME = @SPOUSE_LASTNAME,
      @SPOUSE_LOOKUPID = @SPOUSE_LOOKUPID,
      @SPOUSE_MAIDENNAME = @SPOUSE_MAIDENNAME,
      @SPOUSE_MIDDLENAME = @SPOUSE_MIDDLENAME,
      @SPOUSE_NICKNAME = @SPOUSE_NICKNAME,
      @SPOUSE_SUFFIXCODEID = @SPOUSE_SUFFIXCODEID,
      @SPOUSE_TITLECODEID = @SPOUSE_TITLECODEID,
      @SPOUSE_RELATIONSHIPTYPECODEID = @SPOUSE_RELATIONSHIPTYPECODEID,
      @SPOUSE_RECIPROCALTYPECODEID = @SPOUSE_RECIPROCALTYPECODEID,
      @BUSINESS_ADDRESSBLOCK = @BUSINESS_ADDRESSBLOCK,
      @BUSINESS_ADDRESSTYPECODEID = @BUSINESS_ADDRESSTYPECODEID,
      @BUSINESS_CART = @BUSINESS_CART,
      @BUSINESS_CITY = @BUSINESS_CITY,
      @BUSINESS_COUNTRYID = @BUSINESS_COUNTRYID,
      @BUSINESS_DONOTMAIL = @BUSINESS_DONOTMAIL,
      @BUSINESS_DONOTMAILREASONCODEID = @BUSINESS_DONOTMAILREASONCODEID,
      @BUSINESS_DPC = @BUSINESS_DPC,
      @BUSINESS_EMAILADDRESS = @BUSINESS_EMAILADDRESS,
      @BUSINESS_EMAILADDRESSTYPECODEID = @BUSINESS_EMAILADDRESSTYPECODEID,
      @BUSINESS_INDUSTRYCODEID = @BUSINESS_INDUSTRYCODEID,
      @BUSINESS_LOOKUPID = @BUSINESS_LOOKUPID,
      @BUSINESS_LOT = @BUSINESS_LOT,
      @BUSINESS_ID = @BUSINESS_ID,
      @BUSINESS_NAME = @BUSINESS_NAME,
      @BUSINESS_NUMEMPLOYEES = @BUSINESS_NUMEMPLOYEES,
      @BUSINESS_NUMSUBSIDIARIES = @BUSINESS_NUMSUBSIDIARIES,
      @BUSINESS_PARENTCORPID = @BUSINESS_PARENTCORPID,
      @BUSINESS_PHONENUMBER = @BUSINESS_PHONENUMBER,
      @BUSINESS_PHONE_COUNTRYID = @BUSINESS_PHONE_COUNTRYID,
      @BUSINESS_PHONETYPECODEID = @BUSINESS_PHONETYPECODEID,
      @BUSINESS_RELATIONSHIPTYPECODEID = @BUSINESS_RELATIONSHIPTYPECODEID,
      @BUSINESS_RECIPROCALTYPECODEID = @BUSINESS_RECIPROCALTYPECODEID,
@BUSINESS_STATEID = @BUSINESS_STATEID,
      @BUSINESS_WEBADDRESS = @BUSINESS_WEBADDRESS,
      @BUSINESS_POSTCODE = @BUSINESS_POSTCODE,
      @CURRENTAPPUSERID = @CURRENTAPPUSERID,
      @SPOUSE_RELATIONSHIPTYPECODEIDSIMPLELIST = @SPOUSE_RELATIONSHIPTYPECODEIDSIMPLELIST,
      @SPOUSE_RECIPROCALTYPECODEIDSIMPLELIST = @SPOUSE_RECIPROCALTYPECODEIDSIMPLELIST,
      @BUSINESS_RELATIONSHIPTYPECODEIDSIMPLELIST = @BUSINESS_RELATIONSHIPTYPECODEIDSIMPLELIST,
      @BUSINESS_RECIPROCALTYPECODEIDSIMPLELIST = @BUSINESS_RECIPROCALTYPECODEIDSIMPLELIST,
      @BUSINESS_PRIMARYSOFTCREDITRELATIONSHIPEXISTS = @BUSINESS_PRIMARYSOFTCREDITRELATIONSHIPEXISTS,
      @BUSINESS_PRIMARYSOFTCREDITMATCHFACTOR = @BUSINESS_PRIMARYSOFTCREDITMATCHFACTOR,
      @BUSINESS_RECIPROCALSOFTCREDITRELATIONSHIPEXISTS = @BUSINESS_RECIPROCALSOFTCREDITRELATIONSHIPEXISTS,
      @BUSINESS_RECIPROCALSOFTCREDITMATCHFACTOR = @BUSINESS_RECIPROCALSOFTCREDITMATCHFACTOR,
      @BUSINESS_PRIMARYRECOGNITIONTYPECODEID = @BUSINESS_PRIMARYRECOGNITIONTYPECODEID,
      @BUSINESS_RECIPROCALRECOGNITIONTYPECODEID = @BUSINESS_RECIPROCALRECOGNITIONTYPECODEID,
      @BUSINESS_EMAILADDRESSSTARTDATE = @BUSINESS_EMAILADDRESSSTARTDATE,
      @SPOUSE_PRIMARYSOFTCREDITRELATIONSHIPEXISTS = @SPOUSE_PRIMARYSOFTCREDITRELATIONSHIPEXISTS,
      @SPOUSE_PRIMARYSOFTCREDITMATCHFACTOR = @SPOUSE_PRIMARYSOFTCREDITMATCHFACTOR,
      @SPOUSE_RECIPROCALSOFTCREDITRELATIONSHIPEXISTS = @SPOUSE_RECIPROCALSOFTCREDITRELATIONSHIPEXISTS,
      @SPOUSE_RECIPROCALSOFTCREDITMATCHFACTOR = @SPOUSE_RECIPROCALSOFTCREDITMATCHFACTOR,
      @SPOUSE_PRIMARYRECOGNITIONTYPECODEID = @SPOUSE_PRIMARYRECOGNITIONTYPECODEID,
      @SPOUSE_RECIPROCALRECOGNITIONTYPECODEID = @SPOUSE_RECIPROCALRECOGNITIONTYPECODEID,
      @CONSTITUENT_SITES = @CONSTITUENT_SITES,
      @BATCHOWNERID = @BATCHOWNERID,
      @BATCHROWID = @BATCHROWID,
      @SPOUSE_ALTERNATELOOKUPIDS = @SPOUSE_ALTERNATELOOKUPIDS,
      @SPOUSE_IMPORTLOOKUPID = @SPOUSE_IMPORTLOOKUPID,
      @ROWFROMBATCHUI = @ROWFROMBATCHUI, 
      @BBNCTRANID = @BBNCTRANID,
      @REMOVESPOUSE = @REMOVESPOUSE,
      @SOCIALMEDIAACCOUNTS = @SOCIALMEDIAACCOUNTS,
      @RELATIONSHIPS = @RELATIONSHIPS,
      @NETCOMMUNITYTRANSACTIONPROCESSORID = @NETCOMMUNITYTRANSACTIONPROCESSORID,
      @NEWADDRESSENDDATECODE = @NEWADDRESSENDDATECODE,
      @CREATEHISTORICALNAMECODE = @CREATEHISTORICALNAMECODE,
      @NEWPHONEENDDATECODE = @NEWPHONEENDDATECODE,
      @NEWEMAILENDDATECODE = @NEWEMAILENDDATECODE,
      @NAMEFORMATS = @NAMEFORMATS,
      @REQUESTSNOEMAIL = @REQUESTSNOEMAIL

 return 0;
end