USP_DATALIST_REVENUEBATCH_RAISEEXCEPTIONFORAUTOMATCHES

CREATE procedure dbo.USP_DATALIST_REVENUEBATCH_RAISEEXCEPTIONFORAUTOMATCHES(
  @BATCHROWID uniqueidentifier,
  @AUTOMATCHRECORDID uniqueidentifier,
  @CURRENTAPPUSERID uniqueidentifier = null
)
as
    set nocount on;
    declare @DOMANUALREVIEWFORAUTOMATCH bit = 0;
    declare @ORIGINALCONSTITUENTID uniqueidentifier;
    -- get rules settings from the batch row

    declare @NAMECODE tinyint;
    declare @SIMILARADDRESSCODE tinyint;
    declare @UNSIMILARADDRESSCODE tinyint;
    declare @DIFFERENTPHONECODE tinyint;
    declare @DIFFERENTEMAILCODE tinyint;

    select 
      @NAMECODE = NAMECODE,
      @SIMILARADDRESSCODE = SIMILARADDRESSCODE,
      @UNSIMILARADDRESSCODE = UNSIMILARADDRESSCODE,
      @DIFFERENTPHONECODE = DIFFERENTPHONECODE,
      @DIFFERENTEMAILCODE = DIFFERENTEMAILCODE,      
      @ORIGINALCONSTITUENTID = CONSTITUENTID
    from dbo.BATCHREVENUE
    where ID = @BATCHROWID;    

    -- first load the new constituent's data and save the matched constituent to the CUB tables

    exec dbo.USP_REVENUEBATCH_DUPLICATEMATCH_EDITSAVE_CONSTITUENT @BATCHROWID, @ORIGINALCONSTITUENTID, @AUTOMATCHRECORDID, @CURRENTAPPUSERID;

    exec dbo.USP_CONSTITUENTUPDATEBATCH_DOMANUALREVIEWFORAUTOMATCH @BATCHROWID, @AUTOMATCHRECORDID, @NAMECODE, @SIMILARADDRESSCODE, @UNSIMILARADDRESSCODE, @DIFFERENTPHONECODE, @DIFFERENTEMAILCODE, @DOMANUALREVIEWFORAUTOMATCH output;   

    update dbo.BATCHCONSTITUENTUPDATE set 
      DOMANUALREVIEWFORAUTOMATCH = @DOMANUALREVIEWFORAUTOMATCH
    where ID = @BATCHROWID; 

      select @DOMANUALREVIEWFORAUTOMATCH as DOMANUALREVIEWFORAUTOMATCH