USP_EDITSAVE_BATCHCONSTITUENTUPDATEBATCHROW_3

CREATE procedure dbo.USP_EDITSAVE_BATCHCONSTITUENTUPDATEBATCHROW_3(
  @ID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier,
  @SEQUENCE int,
  @PRIMARYRECORDID uniqueidentifier, 
  @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),
  @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,
  @SPOUSE_ALTERNATELOOKUPIDS xml,
  @SPOUSE_IMPORTLOOKUPID nvarchar(100),
  @ROWFROMBATCHUI bit, 
  @BBNCTRANID int, 
  @PAGEID int, 
  @PAGENAME nvarchar(100), 
  @BBNCUSERID int, 
  @REMOVESPOUSE bit, 
  @DUPLICATERECORDID uniqueidentifier,
  @SOCIALMEDIAACCOUNTS xml,
  @RELATIONSHIPS xml,
  @NETCOMMUNITYTRANSACTIONPROCESSORID uniqueidentifier,
  @BBNCID int,
  @NAMECODE tinyint = 1,
  @SIMILARADDRESSCODE tinyint = 3,
  @UNSIMILARADDRESSCODE tinyint = 3,
  @NEWADDRESSENDDATECODE tinyint = 0,
  @NEWADDRESSPRIMARYCODE tinyint = 1,
  @BIRTHDATERULECODE tinyint = 1,
  @DIFFERENTPHONECODE tinyint = 3 ,
  @NEWPHONEENDDATECODE tinyint = 0 ,
  @NEWPHONEPRIMARYCODE tinyint = 1 ,
  @DIFFERENTEMAILCODE tinyint = 3 ,
  @NEWEMAILENDDATECODE tinyint = 0 ,
  @NEWEMAILPRIMARYCODE tinyint = 1 ,
  @USEGLOBALSETTINGS bit = 1,
  @CREATEHISTORICALNAMECODE tinyint = 1,
  @NAMEFORMATS xml,
  @REQUESTSNOEMAIL bit = 0,
  @ORIGINAL_KEYNAME nvarchar(100),
  @ORIGINAL_FIRSTNAME nvarchar(50),
  @SOLICITCODES xml
) as
set nocount on;

declare @GENDERCODEID uniqueidentifier;
declare @SPOUSE_GENDERCODEID uniqueidentifier;

exec dbo.USP_EDITLOAD_BATCHCONSTITUENTUPDATEBATCHROW
    @ID = @ID,
    @GENDERCODEID = @GENDERCODEID output,
    @SPOUSE_GENDERCODEID = @SPOUSE_GENDERCODEID output;

exec dbo.USP_EDITSAVE_BATCHCONSTITUENTUPDATEBATCHROW_4
    @ID, @CHANGEAGENTID, @SEQUENCE, @PRIMARYRECORDID, @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, 
    @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, @SPOUSE_ALTERNATELOOKUPIDS, 
    @SPOUSE_IMPORTLOOKUPID, @ROWFROMBATCHUI, @BBNCTRANID, @PAGEID, @PAGENAME, @BBNCUSERID, 
    @REMOVESPOUSE, @DUPLICATERECORDID,@SOCIALMEDIAACCOUNTS, @RELATIONSHIPS, @NETCOMMUNITYTRANSACTIONPROCESSORID, @BBNCID,
    @NAMECODE, @SIMILARADDRESSCODE,
    @UNSIMILARADDRESSCODE, @NEWADDRESSENDDATECODE,
    @NEWADDRESSPRIMARYCODE, @BIRTHDATERULECODE,
    @DIFFERENTPHONECODE, @NEWPHONEENDDATECODE, @NEWPHONEPRIMARYCODE, @DIFFERENTEMAILCODE, @NEWEMAILENDDATECODE, 
    @NEWEMAILPRIMARYCODE, @USEGLOBALSETTINGS, @CREATEHISTORICALNAMECODE, @NAMEFORMATS,
    @REQUESTSNOEMAIL, @ORIGINAL_KEYNAME, @ORIGINAL_FIRSTNAME, @SOLICITCODES, @GENDERCODEID, @SPOUSE_GENDERCODEID;