USP_DATAFORMTEMPLATE_EDIT_EMAILADDRESS_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

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_EMAILADDRESS_2
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @EMAILADDRESSTYPECODEID uniqueidentifier,
    @EMAILADDRESS dbo.UDT_EMAILADDRESS,
    @PRIMARY bit,
    @DONOTEMAIL bit,
    @UPDATEMATCHINGSPOUSEEMAILADDRESS bit,
    @UPDATEMATCHINGHOUSEHOLDEMAILADDRESS bit
)
as
    set nocount on;

    declare @INFOSOURCECODEID uniqueidentifier;
    declare @INFOSOURCECOMMENTS nvarchar(256);

    exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_EMAILADDRESS_2 
        @ID = @ID,
        @INFOSOURCECODEID = @INFOSOURCECODEID output,
        @INFOSOURCECOMMENTS = @INFOSOURCECOMMENTS output;

    exec dbo.USP_DATAFORMTEMPLATE_EDIT_EMAILADDRESS_3 @ID, @CHANGEAGENTID, @EMAILADDRESSTYPECODEID, @EMAILADDRESS, @PRIMARY, 
        @DONOTEMAIL, @UPDATEMATCHINGSPOUSEEMAILADDRESS, @UPDATEMATCHINGHOUSEHOLDEMAILADDRESS, @INFOSOURCECODEID, @INFOSOURCECOMMENTS;

    return 0;