USP_DATAFORMTEMPLATE_EDIT_CONSTITUENTBUSINESSRULESSETTINGS

Parameters

Parameter	Parameter Type	Mode
@CHANGEAGENTID	uniqueidentifier	IN
@NAMECODE	tinyint	IN
@SIMILARADDRESSCODE	tinyint	IN
@UNSIMILARADDRESSCODE	tinyint	IN
@NEWADDRESSENDDATECODE	tinyint	IN
@NEWADDRESSPRIMARYCODE	tinyint	IN
@BIRTHDATERULECODE	tinyint	IN
@DIFFERENTPHONECODE	tinyint	IN
@NEWPHONEENDDATECODE	tinyint	IN
@NEWPHONEPRIMARYCODE	tinyint	IN
@DIFFERENTEMAILCODE	tinyint	IN
@NEWEMAILENDDATECODE	tinyint	IN
@NEWEMAILPRIMARYCODE	tinyint	IN

Definition

Copy



CREATE procedure USP_DATAFORMTEMPLATE_EDIT_CONSTITUENTBUSINESSRULESSETTINGS
(
    @CHANGEAGENTID uniqueidentifier = null,
    @NAMECODE tinyint,
    @SIMILARADDRESSCODE tinyint,
    @UNSIMILARADDRESSCODE tinyint,
    @NEWADDRESSENDDATECODE tinyint,
    @NEWADDRESSPRIMARYCODE tinyint,
    @BIRTHDATERULECODE tinyint,
    @DIFFERENTPHONECODE tinyint,
    @NEWPHONEENDDATECODE tinyint,
    @NEWPHONEPRIMARYCODE tinyint,
    @DIFFERENTEMAILCODE tinyint,
    @NEWEMAILENDDATECODE tinyint,
    @NEWEMAILPRIMARYCODE tinyint
)

as
  set nocount on;

    declare @CREATEHISTORICALNAMECODE tinyint;
  declare @BATCHTEMPLATEID uniqueidentifier;

  exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_CONSTITUENTBUSINESSRULESSETTINGS
        @CREATEHISTORICALNAMECODE = @CREATEHISTORICALNAMECODE output,
    @BATCHTEMPLATEID = @BATCHTEMPLATEID;

  exec dbo.USP_DATAFORMTEMPLATE_EDIT_CONSTITUENTBUSINESSRULESSETTINGS_2
        @CHANGEAGENTID,
        @NAMECODE,
        @SIMILARADDRESSCODE,
        @UNSIMILARADDRESSCODE,
        @NEWADDRESSENDDATECODE,
        @NEWADDRESSPRIMARYCODE,
        @BIRTHDATERULECODE,
        @DIFFERENTPHONECODE,
        @NEWPHONEENDDATECODE,
        @NEWPHONEPRIMARYCODE,
        @DIFFERENTEMAILCODE,
        @NEWEMAILENDDATECODE,
        @NEWEMAILPRIMARYCODE,
        @CREATEHISTORICALNAMECODE,
    @BATCHTEMPLATEID;

  return 0;