USP_DATAFORMTEMPLATE_EDIT_EMAILADDRESS_3

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

Definition

Copy



CREATE procedure USP_DATAFORMTEMPLATE_EDIT_EMAILADDRESS_3
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @EMAILADDRESSTYPECODEID uniqueidentifier,
    @EMAILADDRESS dbo.UDT_EMAILADDRESS,
    @PRIMARY bit,
    @DONOTEMAIL bit,
    @UPDATEMATCHINGSPOUSEEMAILADDRESS bit,
    @UPDATEMATCHINGHOUSEHOLDEMAILADDRESS bit,
    @INFOSOURCECODEID uniqueidentifier,
    @INFOSOURCECOMMENTS nvarchar(256)
)

as
    set nocount on;

    exec dbo.USP_DATAFORMTEMPLATE_EDIT_EMAILADDRESS_4
        @ID,
        @CHANGEAGENTID,
        @EMAILADDRESSTYPECODEID,
        @EMAILADDRESS,
        @PRIMARY,
        @DONOTEMAIL,
        @UPDATEMATCHINGSPOUSEEMAILADDRESS,
        @UPDATEMATCHINGHOUSEHOLDEMAILADDRESS,
        @INFOSOURCECODEID,
        @INFOSOURCECOMMENTS,
        null    -- field is not used, just pass in null


    return 0;