USP_DATAFORMTEMPLATE_EDIT_BATCHCONSTITUENTUPDATEBATCHCOMMIT_15

CREATE procedure USP_DATAFORMTEMPLATE_EDIT_BATCHCONSTITUENTUPDATEBATCHCOMMIT_15
(
  @ID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier,
  @VALIDATEONLY bit,
  @CONSTITUENTTYPECODE tinyint,
  @BIRTHDATE dbo.UDT_FUZZYDATE,
  @FIRSTNAME nvarchar(50),
  @GENDERCODE tinyint,
  @GIVESANONYMOUSLY bit,
  @KEYNAME nvarchar(100),
  @LOOKUP_ID 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,
  @PHONES xml,
  @EMAILADDRESSES xml,
  @CONSTITUENCIES xml,
  @GROUPTYPEID uniqueidentifier,
  @GROUPDESCRIPTION nvarchar(300),
  @GROUPSTARTDATE datetime,
  @ORG_INDUSTRYCODEID uniqueidentifier,
  @ORG_NUMEMPLOYEES int,
  @ORG_NUMSUBSIDIARIES int,
  @ORG_PARENTCORPID uniqueidentifier,
  @MARITALSTATUSCODEID uniqueidentifier,
  @SPOUSE_ID uniqueidentifier,
  @SPOUSE_TITLECODEID uniqueidentifier,
  @SPOUSE_FIRSTNAME nvarchar(50),
  @SPOUSE_NICKNAME nvarchar(50),
  @SPOUSE_MIDDLENAME nvarchar(50),
  @SPOUSE_MAIDENNAME nvarchar(100),
  @SPOUSE_LASTNAME nvarchar(100),
  @SPOUSE_SUFFIXCODEID uniqueidentifier,
  @SPOUSE_BIRTHDATE dbo.UDT_FUZZYDATE,
  @SPOUSE_GENDERCODE tinyint,
  @SPOUSE_LOOKUPID nvarchar(100),
  @SPOUSE_RELATIONSHIPTYPECODEID uniqueidentifier,
  @SPOUSE_RECIPROCALTYPECODEID uniqueidentifier,
  @BUSINESS_ID 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_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,
  @DUPLICATERECORDID uniqueidentifier,
  @SOCIALMEDIAACCOUNTS xml,
  @RELATIONSHIPS xml,
  @NETCOMMUNITYTRANSACTIONPROCESSORID uniqueidentifier,
  @NAMECODE tinyint,
  @SIMILARADDRESSCODE tinyint,
  @UNSIMILARADDRESSCODE tinyint,
  @NEWADDRESSENDDATECODE tinyint,
  @NEWADDRESSPRIMARYCODE tinyint,
  @BIRTHDATERULECODE tinyint,
  @DIFFERENTPHONECODE tinyint,
  @NEWPHONEENDDATECODE tinyint,
  @NEWPHONEPRIMARYCODE tinyint,
  @DIFFERENTEMAILCODE tinyint,
  @NEWEMAILENDDATECODE tinyint,
  @NEWEMAILPRIMARYCODE tinyint,
  @USEGLOBALSETTINGS bit,
  @CREATEHISTORICALNAMECODE tinyint,
  @NAMEFORMATS xml,
  @REQUESTSNOEMAIL bit,
  @ORIGINAL_KEYNAME nvarchar(100),
  @ORIGINAL_FIRSTNAME nvarchar(50),
  @SOLICITCODES xml
)

as
  set nocount on;

  declare @GENDERCODEID uniqueidentifier;
  declare @SPOUSE_GENDERCODEID uniqueidentifier;

  exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_BATCHCONSTITUENTUPDATEBATCHCOMMIT
    @ID = @ID,
    @GENDERCODEID = @GENDERCODEID output,
    @SPOUSE_GENDERCODEID = @SPOUSE_GENDERCODEID output

  exec dbo.USP_DATAFORMTEMPLATE_EDIT_BATCHCONSTITUENTUPDATEBATCHCOMMIT_16
    @ID,
    @CHANGEAGENTID,
    @VALIDATEONLY,
    @CONSTITUENTTYPECODE,
    @BIRTHDATE,
    @FIRSTNAME,
    @GENDERCODE,
    @GIVESANONYMOUSLY,
    @KEYNAME,
    @LOOKUP_ID,
    @MAIDENNAME,
    @MIDDLENAME,
    @NICKNAME,
    @SUFFIXCODEID,
    @TITLECODEID,
    @WEBADDRESS,
    @ALTERNATELOOKUPIDS,
    @SECURITYATTRIBUTES,
    @DECEASED,
    @DECEASEDDATE,
    @CONSTITUENT_SITEID,
    @INTERESTS,
    @PROSPECTMANAGERFUNDRAISERID,
    @ADDRESSES,
    @PHONES,
    @EMAILADDRESSES,
    @CONSTITUENCIES,
    @GROUPTYPEID,
    @GROUPDESCRIPTION,
    @GROUPSTARTDATE,
    @ORG_INDUSTRYCODEID,
    @ORG_NUMEMPLOYEES,
    @ORG_NUMSUBSIDIARIES,
    @ORG_PARENTCORPID,
    @MARITALSTATUSCODEID,
    @SPOUSE_ID,
    @SPOUSE_TITLECODEID,
    @SPOUSE_FIRSTNAME,
    @SPOUSE_NICKNAME,
    @SPOUSE_MIDDLENAME,
    @SPOUSE_MAIDENNAME,
    @SPOUSE_LASTNAME,
    @SPOUSE_SUFFIXCODEID,
    @SPOUSE_BIRTHDATE,
    @SPOUSE_GENDERCODE,
    @SPOUSE_LOOKUPID,
    @SPOUSE_RELATIONSHIPTYPECODEID,
    @SPOUSE_RECIPROCALTYPECODEID,
    @BUSINESS_ID,
    @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_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,
    @BATCHOWNERID,
    @BATCHROWID,
    @SPOUSE_ALTERNATELOOKUPIDS,
    @SPOUSE_IMPORTLOOKUPID,
    @ROWFROMBATCHUI,
    @BBNCTRANID,
    @REMOVESPOUSE,
    @DUPLICATERECORDID,
    @SOCIALMEDIAACCOUNTS,
    @RELATIONSHIPS,
    @NETCOMMUNITYTRANSACTIONPROCESSORID,
    @NAMECODE,
    @SIMILARADDRESSCODE,
    @UNSIMILARADDRESSCODE,
    @NEWADDRESSENDDATECODE,
    @NEWADDRESSPRIMARYCODE,
    @BIRTHDATERULECODE,
    @DIFFERENTPHONECODE,
    @NEWPHONEENDDATECODE,
    @NEWPHONEPRIMARYCODE,
    @DIFFERENTEMAILCODE,
    @NEWEMAILENDDATECODE,
    @NEWEMAILPRIMARYCODE,
    @USEGLOBALSETTINGS,
    @CREATEHISTORICALNAMECODE,
    @NAMEFORMATS,
    @REQUESTSNOEMAIL,
    @ORIGINAL_KEYNAME,
    @ORIGINAL_FIRSTNAME,
    @SOLICITCODES,
    @GENDERCODEID,
    @SPOUSE_GENDERCODEID

  return 0;