USP_REVENUEBATCH_ADDCONSTITUENTEDITINFO

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@BATCHCONSTITUENTUPDATEADDRESSESID	uniqueidentifier	IN
@BATCHCONSTITUENTUPDATEPHONESID	uniqueidentifier	IN
@BATCHCONSTITUENTUPDATEEMAILADDRESSESID	uniqueidentifier	IN

Definition

Copy



            create procedure dbo.USP_REVENUEBATCH_ADDCONSTITUENTEDITINFO (
        @ID uniqueidentifier,
        @CHANGEAGENTID uniqueidentifier = null,
        @BATCHCONSTITUENTUPDATEADDRESSESID uniqueidentifier = null,
        @BATCHCONSTITUENTUPDATEPHONESID uniqueidentifier = null,
        @BATCHCONSTITUENTUPDATEEMAILADDRESSESID uniqueidentifier = null
      ) as
      begin
        if @CHANGEAGENTID is null
          exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

                declare @CURRENTDATE datetime;
                set @CURRENTDATE = getdate();

        insert into dbo.BATCHREVENUECONSTITUENTEDITINFO (ID,
                                                         BATCHCONSTITUENTUPDATEADDRESSESID,
                                                         BATCHCONSTITUENTUPDATEPHONESID,
                                                         BATCHCONSTITUENTUPDATEEMAILADDRESSESID,
                                                         ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
        values (@ID,
                @BATCHCONSTITUENTUPDATEADDRESSESID,
                @BATCHCONSTITUENTUPDATEPHONESID,
                @BATCHCONSTITUENTUPDATEEMAILADDRESSESID,
                @CHANGEAGENTID,
                @CHANGEAGENTID,
                @CURRENTDATE,
                @CURRENTDATE);
      end