USP_DATAFORMTEMPLATE_EDIT_EMAILADDRESS_5

The save procedure used by the edit dataform template "Email Address Edit Form 2".

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
@STARTDATE	date	IN	Start date
@ENDDATE	date	IN	End date

Definition

Copy



CREATE procedure USP_DATAFORMTEMPLATE_EDIT_EMAILADDRESS_5
(
    @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,
    @STARTDATE date,
    @ENDDATE date
)

as
  set nocount on;

    declare @EMAILISCONFIDENTIAL bit;

  exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_EMAILADDRESS_2
        @ID = @ID,
        @EMAILISCONFIDENTIAL = @EMAILISCONFIDENTIAL output

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

  return 0;