USP_DATAFORMTEMPLATE_EDIT_EMAILADDRESS_4

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@EMAILADDRESSTYPECODEID	uniqueidentifier	IN	Type
@EMAILADDRESS	UDT_EMAILADDRESS	IN	Email address
@PRIMARY	bit	IN	Set as primary email address
@DONOTEMAIL	bit	IN	Do not send email to this address
@UPDATEMATCHINGSPOUSEEMAILADDRESS	bit	IN	Update matching email information for spouse
@UPDATEMATCHINGHOUSEHOLDEMAILADDRESS	bit	IN	Update matching email addresses in household
@INFOSOURCECODEID	uniqueidentifier	IN	Information source
@INFOSOURCECOMMENTS	nvarchar(256)	IN	Comments
@CONSTITUENTDATAREVIEWROLLBACKREASONID	uniqueidentifier	IN	Reason

Definition

Copy



      CREATE procedure USP_DATAFORMTEMPLATE_EDIT_EMAILADDRESS_4
      (
          @ID uniqueidentifier,
          @CHANGEAGENTID uniqueidentifier = null,
          @EMAILADDRESSTYPECODEID uniqueidentifier,
          @EMAILADDRESS dbo.UDT_EMAILADDRESS,
          @PRIMARY bit,
          @DONOTEMAIL bit,
          @UPDATEMATCHINGSPOUSEEMAILADDRESS bit,
          @UPDATEMATCHINGHOUSEHOLDEMAILADDRESS bit,
          @INFOSOURCECODEID uniqueidentifier,
          @INFOSOURCECOMMENTS nvarchar(256),
          @CONSTITUENTDATAREVIEWROLLBACKREASONID uniqueidentifier -- used by constituent data review

      )

      as
        set nocount on;

          declare @STARTDATE date;
          declare @ENDDATE date;

        exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_EMAILADDRESS_2
              @ID = @ID,
              @STARTDATE = @STARTDATE output,
              @ENDDATE = @ENDDATE output

        exec dbo.USP_DATAFORMTEMPLATE_EDIT_EMAILADDRESS_5
              @ID,
              @CHANGEAGENTID,
              @EMAILADDRESSTYPECODEID,
              @EMAILADDRESS,
              @PRIMARY,
              @DONOTEMAIL,
              @UPDATEMATCHINGSPOUSEEMAILADDRESS,
              @UPDATEMATCHINGHOUSEHOLDEMAILADDRESS,
              @INFOSOURCECODEID,
              @INFOSOURCECOMMENTS,
              @CONSTITUENTDATAREVIEWROLLBACKREASONID,
              @STARTDATE,
              @ENDDATE

        return 0;