USP_DATAFORMTEMPLATE_EDIT_EMAILADDRESS_6

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@EMAILADDRESSTYPECODEID	uniqueidentifier	IN
@EMAILADDRESS	UDT_EMAILADDRESS	IN
@PRIMARY	bit	IN
@DONOTEMAIL	bit	IN
@UPDATEMATCHINGSPOUSEEMAILADDRESS	bit	IN
@UPDATEMATCHINGHOUSEHOLDEMAILADDRESS	bit	IN
@INFOSOURCECODEID	uniqueidentifier	IN
@INFOSOURCECOMMENTS	nvarchar(256)	IN
@CONSTITUENTDATAREVIEWROLLBACKREASONID	uniqueidentifier	IN
@STARTDATE	date	IN
@ENDDATE	date	IN
@EMAILISCONFIDENTIAL	bit	IN

Definition

Copy



create procedure USP_DATAFORMTEMPLATE_EDIT_EMAILADDRESS_6
(
    @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,
  @EMAILISCONFIDENTIAL bit
)

as
  set nocount on;

    declare @DONOTEMAILREASONCODEID uniqueidentifier;

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

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

  return 0;