USP_DATAFORMTEMPLATE_EDIT_BBNCDEFAULTCODEMAP_8

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@BUSINESSPHONECODEID	uniqueidentifier	IN
@RELATIONSHIPTYPECODEID	uniqueidentifier	IN
@SPOUSEREMOVEDRELATIONSHIPTYPECODEID	uniqueidentifier	IN
@PRIMARYBUSINESSRELATIONSHIPTYPECODEID	uniqueidentifier	IN
@PRIMARYBUSINESSRECIPROCALTYPECODEID	uniqueidentifier	IN
@PRIMARYADDRESSTYPECODEID	uniqueidentifier	IN
@BUSINESSADDRESSTYPECODEID	uniqueidentifier	IN
@ORGANIZATIONPRIMARYADDRESSTYPECODEID	uniqueidentifier	IN
@MGCONDITIONTYPECODEID	uniqueidentifier	IN
@REVENUENOTETYPECODEID	uniqueidentifier	IN
@CONSTITUENTLINKPAGEID	uniqueidentifier	IN
@CONTACTTYPECODEID	uniqueidentifier	IN
@CHANNELCODEID	uniqueidentifier	IN
@MGALIASTYPECODEID	uniqueidentifier	IN
@DONOTEMAILSOLICITCODEID	uniqueidentifier	IN
@AUTOMATCHUSELASTNAME	bit	IN
@AUTOMATCHUSEFIRSTNAME	bit	IN
@AUTOMATCHUSEMAIDENNAME	bit	IN
@AUTOMATCHUSEBIRTHDATE	bit	IN
@AUTOMATCHUSEGENDER	bit	IN
@AUTOMATCHUSEMIDDLENAME	bit	IN
@AUTOMATCHUSEADDRESS	bit	IN
@AUTOMATCHUSECITY	bit	IN
@AUTOMATCHUSECOUNTRY	bit	IN
@AUTOMATCHUSECOUNTY	bit	IN
@AUTOMATCHUSENZCITY	bit	IN
@AUTOMATCHUSENZSUBURB	bit	IN
@AUTOMATCHUSESTATE	bit	IN
@AUTOMATCHUSEZIP	bit	IN
@AUTOMATCHUSEPHONE	bit	IN
@AUTOMATCHUSELOOKUPID	bit	IN
@AUTOMATCHEXACTMATCHONLY	bit	IN
@AUTOMATCHINCLUDEINACTIVE	bit	IN
@AUTOMATCHINCLUDEDECEASED	bit	IN
@PLUGINSERVICEURL	UDT_WEBADDRESS	IN
@INFOSOURCECODEID	uniqueidentifier	IN
@FORMERADDRESSTYPECODEID	uniqueidentifier	IN
@AUTOMATCHUSEEMAIL	bit	IN
@EMAILADDRESSTYPECODEID	uniqueidentifier	IN

Definition

Copy



CREATE procedure dbo.[USP_DATAFORMTEMPLATE_EDIT_BBNCDEFAULTCODEMAP_8]
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @BUSINESSPHONECODEID uniqueidentifier,
    @RELATIONSHIPTYPECODEID uniqueidentifier,
    @SPOUSEREMOVEDRELATIONSHIPTYPECODEID uniqueidentifier,
    @PRIMARYBUSINESSRELATIONSHIPTYPECODEID uniqueidentifier,
    @PRIMARYBUSINESSRECIPROCALTYPECODEID uniqueidentifier,
    @PRIMARYADDRESSTYPECODEID uniqueidentifier,
    @BUSINESSADDRESSTYPECODEID uniqueidentifier,
    @ORGANIZATIONPRIMARYADDRESSTYPECODEID uniqueidentifier,
    @MGCONDITIONTYPECODEID uniqueidentifier,
    @REVENUENOTETYPECODEID uniqueidentifier,
    @CONSTITUENTLINKPAGEID uniqueidentifier,
    @CONTACTTYPECODEID uniqueidentifier,
    @CHANNELCODEID uniqueidentifier,
    @MGALIASTYPECODEID uniqueidentifier,
    @DONOTEMAILSOLICITCODEID uniqueidentifier,
    @AUTOMATCHUSELASTNAME bit,
    @AUTOMATCHUSEFIRSTNAME bit,
    @AUTOMATCHUSEMAIDENNAME bit,
    @AUTOMATCHUSEBIRTHDATE bit,
    @AUTOMATCHUSEGENDER bit,
    @AUTOMATCHUSEMIDDLENAME bit,
    @AUTOMATCHUSEADDRESS bit,
    @AUTOMATCHUSECITY bit,
    @AUTOMATCHUSECOUNTRY bit,
    @AUTOMATCHUSECOUNTY bit,
  @AUTOMATCHUSENZCITY bit,
  @AUTOMATCHUSENZSUBURB bit,
    @AUTOMATCHUSESTATE bit,
    @AUTOMATCHUSEZIP bit,
    @AUTOMATCHUSEPHONE bit,
    @AUTOMATCHUSELOOKUPID bit,
    @AUTOMATCHEXACTMATCHONLY bit,
    @AUTOMATCHINCLUDEINACTIVE bit,
    @AUTOMATCHINCLUDEDECEASED bit,
    @PLUGINSERVICEURL dbo.UDT_WEBADDRESS,
    @INFOSOURCECODEID uniqueidentifier,
    @FORMERADDRESSTYPECODEID uniqueidentifier,
    @AUTOMATCHUSEEMAIL bit,
  @EMAILADDRESSTYPECODEID uniqueidentifier
)
as
  set nocount on;

    declare @DONOTEMAILCONSENTSOLICITCODEID uniqueidentifier;
  declare @DATAPROTECTIONEVIDENCESOURCECODEID uniqueidentifier;
  declare @AUTOMATCHUSESUFFIX bit;

  exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_BBNCDEFAULTCODEMAP_4
        @ID = @ID, 
    @AUTOMATCHUSESUFFIX = @AUTOMATCHUSESUFFIX output,
        @DONOTEMAILCONSENTSOLICITCODEID= @DONOTEMAILCONSENTSOLICITCODEID output,
    @DATAPROTECTIONEVIDENCESOURCECODEID = @DATAPROTECTIONEVIDENCESOURCECODEID output;

  exec dbo.USP_DATAFORMTEMPLATE_EDIT_BBNCDEFAULTCODEMAP_9
        @ID,
        @CHANGEAGENTID,
        @BUSINESSPHONECODEID,
        @RELATIONSHIPTYPECODEID,
        @SPOUSEREMOVEDRELATIONSHIPTYPECODEID,
        @PRIMARYBUSINESSRELATIONSHIPTYPECODEID,
        @PRIMARYBUSINESSRECIPROCALTYPECODEID,
        @PRIMARYADDRESSTYPECODEID,
        @BUSINESSADDRESSTYPECODEID,
        @ORGANIZATIONPRIMARYADDRESSTYPECODEID,
        @MGCONDITIONTYPECODEID,
        @REVENUENOTETYPECODEID,
        @CONSTITUENTLINKPAGEID,
        @CONTACTTYPECODEID,
        @CHANNELCODEID,
        @MGALIASTYPECODEID,
        @DONOTEMAILSOLICITCODEID,
        @AUTOMATCHUSELASTNAME,
        @AUTOMATCHUSEFIRSTNAME,
        @AUTOMATCHUSEMAIDENNAME,
        @AUTOMATCHUSEBIRTHDATE,
        @AUTOMATCHUSEGENDER,
        @AUTOMATCHUSEMIDDLENAME,
        @AUTOMATCHUSEADDRESS,
        @AUTOMATCHUSECITY,
        @AUTOMATCHUSECOUNTRY,
        @AUTOMATCHUSECOUNTY,
        @AUTOMATCHUSENZCITY,
        @AUTOMATCHUSENZSUBURB,
        @AUTOMATCHUSESTATE,
        @AUTOMATCHUSEZIP,
        @AUTOMATCHUSEPHONE,
        @AUTOMATCHUSELOOKUPID,
        @AUTOMATCHEXACTMATCHONLY,
        @AUTOMATCHINCLUDEINACTIVE,
        @AUTOMATCHINCLUDEDECEASED,
        @PLUGINSERVICEURL,
        @INFOSOURCECODEID,
        @FORMERADDRESSTYPECODEID,
        @AUTOMATCHUSEEMAIL,
        @EMAILADDRESSTYPECODEID,
        @AUTOMATCHUSESUFFIX,
    @DONOTEMAILCONSENTSOLICITCODEID,
    @DATAPROTECTIONEVIDENCESOURCECODEID;

  return 0;