USP_REVENUEBATCH_CONSTITUENTAPPEAL_ADD

create procedure dbo.USP_REVENUEBATCH_CONSTITUENTAPPEAL_ADD
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
  @BATCHCONSTITUENTID uniqueidentifier,
  @FINDERNUMBER bigint
) as begin

    set nocount on;

    declare @CURRENTDATE datetime;
    declare @CURRENTAPPUSERID uniqueidentifier;

    if @CHANGEAGENTID is null
        exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

    set @CURRENTDATE = getdate();

    begin try
        insert into dbo.[CONSTITUENTAPPEAL]
        (
            [ID],
            [CONSTITUENTID],
            [APPEALID],
            [MKTSEGMENTATIONID],
            [SOURCECODE],
            [FINDERNUMBER],
            [DATESENT],
            [COMMENTS],
            [MKTPACKAGEID],
            [MKTSEGMENTATIONSEGMENTID],
            [MKTSEGMENTATIONTESTSEGMENTID],
            [ADDEDBYID],
            [CHANGEDBYID],
            [DATEADDED],
            [DATECHANGED]
        )

        (select
            [ID],
            @ID,
            [APPEALID],
            [MKTSEGMENTATIONID],
            [SOURCECODE],
            [FINDERNUMBER],
            [DATESENT],
            [COMMENTS],
            [MKTPACKAGEID],
            [MKTSEGMENTATIONSEGMENTID],
            [MKTSEGMENTATIONTESTSEGMENTID],
        @CHANGEAGENTID,
        @CHANGEAGENTID,
        @CURRENTDATE,
        @CURRENTDATE
       from dbo.[BATCHREVENUECONSTITUENTAPPEAL]
       where [FINDERNUMBER] = @FINDERNUMBER
       and [CONSTITUENTID] = @BATCHCONSTITUENTID
        );
    end try


    begin catch
        exec dbo.USP_RAISE_ERROR;
        return 1;
    end catch

    return 0;

end;