USP_DATAFORMTEMPLATE_ADD_MKTCOMMUNICATIONTEMPLATE

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	INOUT
@CURRENTAPPUSERID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@BASECURRENCYID	uniqueidentifier	IN
@NAME	nvarchar(100)	IN
@DESCRIPTION	nvarchar(255)	IN
@SITEID	uniqueidentifier	IN
@TEMPLATETYPECODE	tinyint	IN
@OVERRIDEASKLADDERS	bit	IN
@OVERRIDEAPPEALBUSINESSUNITS	bit	IN
@INCLUDESEEDS	bit	IN
@ISACTIVE	bit	IN
@COMMUNICATIONNAMESCHEMEID	uniqueidentifier	IN
@DESCRIPTIONDEFAULT	nvarchar(255)	IN
@DESCRIPTIONLOCKED	bit	IN
@APPEALINFORMATION	xml	IN
@APPEALLOCKED	bit	IN
@CHANNELCODEDEFAULT	tinyint	IN
@CHANNELCODELOCKED	bit	IN
@ALLOWRESERVINGFINDERNUMBERS	bit	IN
@ALLOWRESERVINGFINDERNUMBERSLOCKED	bit	IN
@ALLOWSPECIFYBUDGET	bit	IN
@ALLOWSPECIFYBUDGETLOCKED	bit	IN
@ALLOWEXCLUDEPREVIOUSEFFORTS	bit	IN
@ALLOWEXCLUDEPREVIOUSEFFORTSLOCKED	bit	IN
@SOURCECODEIDDEFAULT	uniqueidentifier	IN
@SOURCECODELOCKED	bit	IN
@MAILEXPORTDEFINITIONID	uniqueidentifier	IN
@MAILEXPORTDEFINITIONIDLOCKED	bit	IN
@PHONEEXPORTDEFINITIONID	uniqueidentifier	IN
@PHONEEXPORTDEFINITIONIDLOCKED	bit	IN
@EMAILEXPORTDEFINITIONID	uniqueidentifier	IN
@EMAILEXPORTDEFINITIONIDLOCKED	bit	IN
@EXPORTDESCRIPTION	nvarchar(255)	IN
@EXPORTDESCRIPTIONLOCKED	bit	IN
@CURRENCYSYMBOLDISPLAYSETTINGCODE	tinyint	IN
@CURRENCYSYMBOLDISPLAYSETTINGCODELOCKED	bit	IN
@CURRENCYDECIMALDIGITSDISPLAYSETTINGCODE	tinyint	IN
@CURRENCYDECIMALDIGITSDISPLAYSETTINGCODELOCKED	bit	IN
@CURRENCYDECIMALDIGITS	int	IN
@CURRENCYGROUPSEPARATORDISPLAYSETTINGCODE	tinyint	IN
@CURRENCYGROUPSEPARATORDISPLAYSETTINGCODELOCKED	bit	IN
@CURRENCYGROUPSEPARATOR	nvarchar(4)	IN
@CURRENCYDECIMALSEPARATORDISPLAYSETTINGCODE	tinyint	IN
@CURRENCYDECIMALSEPARATORDISPLAYSETTINGCODELOCKED	bit	IN
@CURRENCYDECIMALSEPARATOR	nvarchar(4)	IN
@DATEFORMAT	nvarchar(50)	IN
@DATEFORMATLOCKED	bit	IN
@FUZZYDATEFORMAT	nvarchar(50)	IN
@FUZZYDATEFORMATLOCKED	bit	IN
@MONTHDAYFORMAT	nvarchar(50)	IN
@MONTHDAYFORMATLOCKED	bit	IN
@HOURMINUTEFORMAT	nvarchar(50)	IN
@HOURMINUTEFORMATLOCKED	bit	IN
@CSVLINEBREAKCODE	tinyint	IN
@CSVLINEBREAKCODELOCKED	bit	IN
@RUNSEGMENTATIONSEGMENTREFRESHPROCESS	bit	IN
@RUNSEGMENTATIONSEGMENTREFRESHPROCESSLOCKED	bit	IN
@RUNMARKETINGEXCLUSIONSREPORT	bit	IN
@RUNMARKETINGEXCLUSIONSREPORTLOCKED	bit	IN
@CACHESOURCEANALYSISRULEDATA	bit	IN
@CACHESOURCEANALYSISRULEDATALOCKED	bit	IN
@RUNSEGMENTATIONSEGMENTCALCULATEPROCESS	bit	IN
@RUNSEGMENTATIONSEGMENTREFRESHPROCESSACTIVATE	bit	IN
@RUNMARKETINGEXCLUSIONSREPORTACTIVATE	bit	IN
@CACHESOURCEANALYSISRULEDATAACTIVATE	bit	IN
@ACTIVATEOPTIONSLOCKED	bit	IN
@EXPORTAFTERACTIVATE	bit	IN
@EXPORTAFTERACTIVATELOCKED	bit	IN
@USEADDRESSPROCESSING	bit	IN
@ADDRESSPROCESSINGOPTIONID	uniqueidentifier	IN
@NAMEFORMATPARAMETERID	uniqueidentifier	IN
@ADDRESSPROCESSINGOPTIONSEASONALASOFDATETYPECODE	tinyint	IN
@ADDRESSPROCESSINGOPTIONSEASONALASOFDATE	datetime	IN
@ADDRESSPROCESSINGLOCKED	bit	IN
@HOUSEHOLDINGTYPECODE	tinyint	IN
@HOUSEHOLDINGINCLUDEHOUSEHOLDSWITHNOMEMBERS	bit	IN
@HOUSEHOLDINGONERECORDPERHOUSEHOLD	bit	IN
@HOUSEHOLDINGINCLUDEINDIVIDUALSWITHNOHOUSEHOLD	bit	IN
@HOUSEHOLDINGLOCKED	bit	IN
@DEFAULTKPIS	xml	IN
@KPISLOCKED	bit	IN
@INCLUDESELECTIONS	xml	IN
@INCLUDESELECTIONSLOCKED	bit	IN
@EXCLUDESELECTIONS	xml	IN
@EXCLUDESELECTIONSLOCKED	bit	IN
@EXCLUDEDECEASED	bit	IN
@EXCLUDEDECEASEDLOCKED	bit	IN
@EXCLUDEINACTIVE	bit	IN
@EXCLUDEINACTIVELOCKED	bit	IN
@EXCLUSIONASOFDATE	datetime	IN
@EXCLUSIONDATETYPECODE	tinyint	IN
@EXCLUSIONASOFDATELOCKED	bit	IN
@EXCLUSIONS	xml	IN
@EXCLUSIONSLOCKED	bit	IN
@ASKLADDEROVERRIDES	xml	IN
@ASKLADDEROVERRIDESLOCKED	bit	IN
@SEEDS	xml	IN
@SEEDSLOCKED	bit	IN
@BUSINESSUNITSLOCKED	bit	IN
@BUSINESSUNITS	xml	IN
@MKTSEGMENTATIONID	uniqueidentifier	IN
@PARENTCOMMUNICATIONTEMPLATEID	uniqueidentifier	IN
@CACHESOURCEANALYSISRULEDATAACTIVATELOCKED	bit	IN
@ALLOWEFFORTBUSINESSUNITSOVERRIDE	bit	IN
@ALLOWEFFORTADDRESSPROCESSINGOVERRIDE	bit	IN

Definition

Copy



CREATE procedure dbo.[USP_DATAFORMTEMPLATE_ADD_MKTCOMMUNICATIONTEMPLATE]
(
  @ID uniqueidentifier = null output,
  @CURRENTAPPUSERID uniqueidentifier = null,
  @CHANGEAGENTID uniqueidentifier = null,
  @BASECURRENCYID uniqueidentifier = null,
  @NAME nvarchar(100) = '',
  @DESCRIPTION nvarchar(255) = '',
  @SITEID uniqueidentifier = null,
  @TEMPLATETYPECODE tinyint = 0,
  @OVERRIDEASKLADDERS bit = 0,
  @OVERRIDEAPPEALBUSINESSUNITS bit = 0,
  @INCLUDESEEDS bit = 0,
  @ISACTIVE bit = 0,
  @COMMUNICATIONNAMESCHEMEID uniqueidentifier = null,
  @DESCRIPTIONDEFAULT nvarchar(255) = '',
  @DESCRIPTIONLOCKED bit = 0,
  @APPEALINFORMATION xml = null,
  @APPEALLOCKED bit = 0,
  @CHANNELCODEDEFAULT tinyint = 255, --multi-channel

  @CHANNELCODELOCKED bit = 0,
  @ALLOWRESERVINGFINDERNUMBERS bit = 0,
  @ALLOWRESERVINGFINDERNUMBERSLOCKED bit = 0,
  @ALLOWSPECIFYBUDGET bit = 0,
  @ALLOWSPECIFYBUDGETLOCKED bit = 0,
  @ALLOWEXCLUDEPREVIOUSEFFORTS bit = 0,
  @ALLOWEXCLUDEPREVIOUSEFFORTSLOCKED bit = 0,
  @SOURCECODEIDDEFAULT uniqueidentifier = null,
  @SOURCECODELOCKED bit = 0,
  @MAILEXPORTDEFINITIONID uniqueidentifier = null,
  @MAILEXPORTDEFINITIONIDLOCKED bit = 0,
  @PHONEEXPORTDEFINITIONID uniqueidentifier = null,
  @PHONEEXPORTDEFINITIONIDLOCKED bit = 0,
  @EMAILEXPORTDEFINITIONID uniqueidentifier = null,
  @EMAILEXPORTDEFINITIONIDLOCKED bit = 0,
  @EXPORTDESCRIPTION nvarchar(255) = '',
  @EXPORTDESCRIPTIONLOCKED bit = 0,
  @CURRENCYSYMBOLDISPLAYSETTINGCODE tinyint = 0,
  @CURRENCYSYMBOLDISPLAYSETTINGCODELOCKED bit = 0,
  @CURRENCYDECIMALDIGITSDISPLAYSETTINGCODE tinyint = 0,
  @CURRENCYDECIMALDIGITSDISPLAYSETTINGCODELOCKED bit = 0,
  @CURRENCYDECIMALDIGITS int = 2,
  @CURRENCYGROUPSEPARATORDISPLAYSETTINGCODE tinyint = 0,
  @CURRENCYGROUPSEPARATORDISPLAYSETTINGCODELOCKED bit = 0,
  @CURRENCYGROUPSEPARATOR nvarchar(4) = ',',
  @CURRENCYDECIMALSEPARATORDISPLAYSETTINGCODE tinyint = 0,
  @CURRENCYDECIMALSEPARATORDISPLAYSETTINGCODELOCKED bit = 0,
  @CURRENCYDECIMALSEPARATOR nvarchar(4) = '.',
  @DATEFORMAT nvarchar(50) = 'M/d/yyyy',
  @DATEFORMATLOCKED bit = 0,
  @FUZZYDATEFORMAT nvarchar(50) = 'M/d/yyyy',
  @FUZZYDATEFORMATLOCKED bit = 0,
  @MONTHDAYFORMAT nvarchar(50) = 'M/d',
  @MONTHDAYFORMATLOCKED bit = 0,
  @HOURMINUTEFORMAT nvarchar(50) = 'hh:mm tt',
  @HOURMINUTEFORMATLOCKED bit = 0,
  @CSVLINEBREAKCODE tinyint = 0,
  @CSVLINEBREAKCODELOCKED bit = 0,
  @RUNSEGMENTATIONSEGMENTREFRESHPROCESS bit = 0,
  @RUNSEGMENTATIONSEGMENTREFRESHPROCESSLOCKED bit = 0,
  @RUNMARKETINGEXCLUSIONSREPORT bit = 1,
  @RUNMARKETINGEXCLUSIONSREPORTLOCKED bit = 0,
  @CACHESOURCEANALYSISRULEDATA bit = 0,
  @CACHESOURCEANALYSISRULEDATALOCKED bit = 0,
  @RUNSEGMENTATIONSEGMENTCALCULATEPROCESS bit = 1,
  @RUNSEGMENTATIONSEGMENTREFRESHPROCESSACTIVATE bit = 0,
  @RUNMARKETINGEXCLUSIONSREPORTACTIVATE bit = 1,
  @CACHESOURCEANALYSISRULEDATAACTIVATE bit = 1,
  @ACTIVATEOPTIONSLOCKED bit = 0,
  @EXPORTAFTERACTIVATE bit = 0,
  @EXPORTAFTERACTIVATELOCKED bit = 0,
  @USEADDRESSPROCESSING bit = 0,
  @ADDRESSPROCESSINGOPTIONID uniqueidentifier = null,
  @NAMEFORMATPARAMETERID uniqueidentifier = null,
  @ADDRESSPROCESSINGOPTIONSEASONALASOFDATETYPECODE tinyint = 0,
  @ADDRESSPROCESSINGOPTIONSEASONALASOFDATE datetime = null,
  @ADDRESSPROCESSINGLOCKED bit = 0,
  @HOUSEHOLDINGTYPECODE tinyint = 0,
  @HOUSEHOLDINGINCLUDEHOUSEHOLDSWITHNOMEMBERS bit = 0,
  @HOUSEHOLDINGONERECORDPERHOUSEHOLD bit = 0,
  @HOUSEHOLDINGINCLUDEINDIVIDUALSWITHNOHOUSEHOLD bit = 0,
  @HOUSEHOLDINGLOCKED bit = 0,
  @DEFAULTKPIS xml = null,
  @KPISLOCKED bit = 0,
  @INCLUDESELECTIONS xml = null,
  @INCLUDESELECTIONSLOCKED bit = 0,
  @EXCLUDESELECTIONS xml = null,
  @EXCLUDESELECTIONSLOCKED bit = 0,
  @EXCLUDEDECEASED bit = 1,
  @EXCLUDEDECEASEDLOCKED bit = 0,
  @EXCLUDEINACTIVE bit = 1,
  @EXCLUDEINACTIVELOCKED bit = 0,
  @EXCLUSIONASOFDATE datetime = null,
  @EXCLUSIONDATETYPECODE tinyint = 0,
  @EXCLUSIONASOFDATELOCKED bit = 0,
  @EXCLUSIONS xml = null,
  @EXCLUSIONSLOCKED bit = 0,
  @ASKLADDEROVERRIDES xml = null,
  @ASKLADDEROVERRIDESLOCKED bit = 0,
  @SEEDS xml = null,
  @SEEDSLOCKED bit = 0,
  @BUSINESSUNITSLOCKED bit = 0,
  @BUSINESSUNITS xml = null,
  @MKTSEGMENTATIONID uniqueidentifier = null,
  @PARENTCOMMUNICATIONTEMPLATEID uniqueidentifier = null,
  @CACHESOURCEANALYSISRULEDATAACTIVATELOCKED bit = 0,
  @ALLOWEFFORTBUSINESSUNITSOVERRIDE bit = 0,
  @ALLOWEFFORTADDRESSPROCESSINGOVERRIDE bit = 0
)
as
  set nocount on;

  if @ID is null
    set @ID = newid();

  declare @CURRENTDATE datetime = getdate();
  declare @BUSINESSPROCESSEXPORTFORMATID uniqueidentifier = newid();

  if @BASECURRENCYID is null
    set @BASECURRENCYID = dbo.[UFN_APPUSER_GETBASECURRENCY](@CURRENTAPPUSERID);

  if @OVERRIDEAPPEALBUSINESSUNITS = 0
    set @ALLOWEFFORTBUSINESSUNITSOVERRIDE = 0;

  insert into dbo.[MKTCOMMUNICATIONTEMPLATE] (
    [ID],
    [NAME],
    [DESCRIPTION],
    [SITEID],
    [TEMPLATETYPECODE],
    [OVERRIDEASKLADDERS],
    [OVERRIDEAPPEALBUSINESSUNITS],
    [ALLOWEFFORTBUSINESSUNITSOVERRIDE],
    [INCLUDESEEDS],
    [ISACTIVE],
    [ADDEDBYID],
    [CHANGEDBYID],
    [DATEADDED],
    [DATECHANGED],
    [BASECURRENCYID],
    [MKTSEGMENTATIONID],
    [PARENTCOMMUNICATIONTEMPLATEID],
    [ALLOWEFFORTADDRESSPROCESSINGOVERRIDE]
  )
  values (
    @ID,
    @NAME,
    @DESCRIPTION,
    @SITEID,
    @TEMPLATETYPECODE,
    @OVERRIDEASKLADDERS,
    @OVERRIDEAPPEALBUSINESSUNITS,
    @ALLOWEFFORTBUSINESSUNITSOVERRIDE,
    @INCLUDESEEDS,
    @ISACTIVE,
    @CHANGEAGENTID,
    @CHANGEAGENTID,
    @CURRENTDATE,
    @CURRENTDATE,
    @BASECURRENCYID,
    @MKTSEGMENTATIONID,
    @PARENTCOMMUNICATIONTEMPLATEID,
    @ALLOWEFFORTADDRESSPROCESSINGOVERRIDE
  );

  -- save export format defaults

  insert into dbo.[BUSINESSPROCESSEXPORTFORMAT] (
    [ID],
    [CURRENCYSYMBOLDISPLAYSETTINGCODE],
    [CURRENCYDECIMALDIGITSDISPLAYSETTINGCODE],
    [CURRENCYDECIMALDIGITS],
    [CURRENCYGROUPSEPARATORDISPLAYSETTINGCODE],
    [CURRENCYGROUPSEPARATOR],
    [CURRENCYDECIMALSEPARATORDISPLAYSETTINGCODE],
    [CURRENCYDECIMALSEPARATOR],
    [DATEFORMAT],
    [FUZZYDATEFORMAT],
    [MONTHDAYFORMAT],
    [HOURMINUTEFORMAT],
    [CSVLINEBREAKCODE],
    [ADDEDBYID],
    [CHANGEDBYID],
    [DATEADDED],
    [DATECHANGED]
  )
  values (
    @BUSINESSPROCESSEXPORTFORMATID,
    @CURRENCYSYMBOLDISPLAYSETTINGCODE,
    @CURRENCYDECIMALDIGITSDISPLAYSETTINGCODE,
    @CURRENCYDECIMALDIGITS,
    @CURRENCYGROUPSEPARATORDISPLAYSETTINGCODE,
    @CURRENCYGROUPSEPARATOR,
    @CURRENCYDECIMALSEPARATORDISPLAYSETTINGCODE,
    @CURRENCYDECIMALSEPARATOR,
    @DATEFORMAT,
    @FUZZYDATEFORMAT,
    @MONTHDAYFORMAT,
    @HOURMINUTEFORMAT,
    @CSVLINEBREAKCODE,
    @CHANGEAGENTID,
    @CHANGEAGENTID,
    @CURRENTDATE,
    @CURRENTDATE
  );

  /* Save KPIs */
  exec dbo.[USP_MKTCOMMUNICATIONTEMPLATEDEFAULTKPI_SAVEFIELD_FROMXML] 
    @ID, 
    @DEFAULTKPIS, 
    @CHANGEAGENTID,
    @CURRENTAPPUSERID;

  /* Save the appeal information */
  exec dbo.[USP_MKTCOMMUNICATIONTEMPLATEDEFAULTAPPEAL_SAVEFIELD_FROMXML]
    @ID,
    @APPEALINFORMATION,
    @CHANGEAGENTID;

  /* Save include selection filter information */
  exec dbo.[USP_MKTCOMMUNICATIONTEMPLATEDEFAULTFILTERSELECTION_GETINCLUDESELECTIONS_ADDFROMXML]
    @ID, 
    @INCLUDESELECTIONS, 
    @CHANGEAGENTID, 
    @CURRENTDATE;

  /* Save exclude selection filter information */
  exec dbo.[USP_MKTCOMMUNICATIONTEMPLATEDEFAULTFILTERSELECTION_GETEXCLUDESELECTIONS_ADDFROMXML]
    @ID, 
    @EXCLUDESELECTIONS, 
    @CHANGEAGENTID, 
    @CURRENTDATE;

  /* Save solicid code exclusion information */
  exec dbo.[USP_MKTCOMMUNICATIONTEMPLATEDEFAULTSOLICITCODES_GETEXCLUDESOLICITCODES_ADDFROMXML]
    @ID, 
    @EXCLUSIONS, 
    @CHANGEAGENTID, 
    @CURRENTDATE;

  -- insert default values

  insert into dbo.[MKTCOMMUNICATIONTEMPLATEDEFAULT] (
    [ID],
    [COMMUNICATIONTEMPLATEID],
    [COMMUNICATIONNAMESCHEMEID],
    [DESCRIPTION],
    [DESCRIPTIONLOCKED],
    [APPEALLOCKED],
    [CHANNELCODE],
    [CHANNELCODELOCKED],
    [ALLOWRESERVINGFINDERNUMBERS],
    [ALLOWRESERVINGFINDERNUMBERSLOCKED],
    [ALLOWSPECIFYBUDGET],
    [ALLOWSPECIFYBUDGETLOCKED],
    [ALLOWEXCLUDEPREVIOUSEFFORTS],
    [ALLOWEXCLUDEPREVIOUSEFFORTSLOCKED],
    [SOURCECODEID],
    [SOURCECODELOCKED],
    [MAILEXPORTDEFINITIONID],
    [MAILEXPORTDEFINITIONIDLOCKED],
    [PHONEEXPORTDEFINITIONID],
    [PHONEEXPORTDEFINITIONIDLOCKED],
    [EMAILEXPORTDEFINITIONID],
    [EMAILEXPORTDEFINITIONIDLOCKED],
    [EXPORTDESCRIPTION],
    [EXPORTDESCRIPTIONLOCKED],
    [BUSINESSPROCESSEXPORTFORMATID],
    [CURRENCYSYMBOLDISPLAYSETTINGCODELOCKED],
    [CURRENCYDECIMALDIGITSDISPLAYSETTINGCODELOCKED],
    [CURRENCYGROUPSEPARATORDISPLAYSETTINGCODELOCKED],
    [CURRENCYDECIMALSEPARATORDISPLAYSETTINGCODELOCKED],  
    [DATEFORMATLOCKED],
    [FUZZYDATEFORMATLOCKED],
    [MONTHDAYFORMATLOCKED],
    [HOURMINUTEFORMATLOCKED],
    [CSVLINEBREAKCODELOCKED],
    [RUNSEGMENTATIONSEGMENTREFRESHPROCESS],
    [RUNSEGMENTATIONSEGMENTREFRESHPROCESSLOCKED],
    [RUNMARKETINGEXCLUSIONSREPORT],
    [RUNMARKETINGEXCLUSIONSREPORTLOCKED],
    [CACHESOURCEANALYSISRULEDATA],
    [CACHESOURCEANALYSISRULEDATALOCKED],
    [RUNSEGMENTATIONSEGMENTCALCULATEPROCESS],
    [RUNSEGMENTATIONSEGMENTREFRESHPROCESSACTIVATE],    
    [RUNMARKETINGEXCLUSIONSREPORTACTIVATE],
    [CACHESOURCEANALYSISRULEDATAACTIVATE],
    [CACHESOURCEANALYSISRULEDATAACTIVATELOCKED],
    [ACTIVATEOPTIONSLOCKED],
    [EXPORTAFTERACTIVATE],
    [EXPORTAFTERACTIVATELOCKED],
    [USEADDRESSPROCESSING],
    [ADDRESSPROCESSINGOPTIONID],
    [NAMEFORMATPARAMETERID],
    [ADDRESSPROCESSINGOPTIONSEASONALASOFDATETYPECODE],
    [ADDRESSPROCESSINGOPTIONSEASONALASOFDATE],
    [ADDRESSPROCESSINGLOCKED],
    [KPISLOCKED],
    [HOUSEHOLDINGTYPECODE],
    [HOUSEHOLDINGINCLUDEINDIVIDUALSWITHNOHOUSEHOLD],
    [HOUSEHOLDINGINCLUDEHOUSEHOLDSWITHNOMEMBERS],
    [HOUSEHOLDINGONERECORDPERHOUSEHOLD],
    [HOUSEHOLDINGLOCKED],
    [INCLUDESELECTIONSLOCKED],
    [EXCLUDESELECTIONSLOCKED],    
    [EXCLUDEDECEASED],
    [EXCLUDEDECEASEDLOCKED],
    [EXCLUDEINACTIVE],
    [EXCLUDEINACTIVELOCKED],
    [EXCLUSIONASOFDATE],
    [EXCLUSIONDATETYPECODE],
    [EXCLUSIONASOFDATELOCKED],
    [EXCLUSIONSLOCKED],
    [ASKLADDEROVERRIDESLOCKED],
    [SEEDSLOCKED],
    [BUSINESSUNITSLOCKED],
    [ADDEDBYID],
    [CHANGEDBYID],
    [DATEADDED],
    [DATECHANGED]
  )
  values (
    newid(),
    @ID,
    @COMMUNICATIONNAMESCHEMEID,
    @DESCRIPTIONDEFAULT,
    @DESCRIPTIONLOCKED,
    @APPEALLOCKED,
    @CHANNELCODEDEFAULT,
    @CHANNELCODELOCKED,
    @ALLOWRESERVINGFINDERNUMBERS,
    @ALLOWRESERVINGFINDERNUMBERSLOCKED,
    @ALLOWSPECIFYBUDGET,
    @ALLOWSPECIFYBUDGETLOCKED,
    @ALLOWEXCLUDEPREVIOUSEFFORTS,
    @ALLOWEXCLUDEPREVIOUSEFFORTSLOCKED,
    @SOURCECODEIDDEFAULT,
    @SOURCECODELOCKED,
    @MAILEXPORTDEFINITIONID,
    @MAILEXPORTDEFINITIONIDLOCKED,
    @PHONEEXPORTDEFINITIONID,
    @PHONEEXPORTDEFINITIONIDLOCKED,
    @EMAILEXPORTDEFINITIONID,
    @EMAILEXPORTDEFINITIONIDLOCKED,
    @EXPORTDESCRIPTION,
    @EXPORTDESCRIPTIONLOCKED,
    @BUSINESSPROCESSEXPORTFORMATID,
    @CURRENCYSYMBOLDISPLAYSETTINGCODELOCKED,
    @CURRENCYDECIMALDIGITSDISPLAYSETTINGCODELOCKED,
    @CURRENCYGROUPSEPARATORDISPLAYSETTINGCODELOCKED,
    @CURRENCYDECIMALSEPARATORDISPLAYSETTINGCODELOCKED,
    @DATEFORMATLOCKED,
    @FUZZYDATEFORMATLOCKED,
    @MONTHDAYFORMATLOCKED,
    @HOURMINUTEFORMATLOCKED,
    @CSVLINEBREAKCODELOCKED,
    @RUNSEGMENTATIONSEGMENTREFRESHPROCESS,
    @RUNSEGMENTATIONSEGMENTREFRESHPROCESSLOCKED,
    @RUNMARKETINGEXCLUSIONSREPORT,
    @RUNMARKETINGEXCLUSIONSREPORTLOCKED,
    @CACHESOURCEANALYSISRULEDATA,
    @CACHESOURCEANALYSISRULEDATALOCKED,
    @RUNSEGMENTATIONSEGMENTCALCULATEPROCESS,
    @RUNSEGMENTATIONSEGMENTREFRESHPROCESSACTIVATE,
    @RUNMARKETINGEXCLUSIONSREPORTACTIVATE,
    @CACHESOURCEANALYSISRULEDATAACTIVATE,
    @CACHESOURCEANALYSISRULEDATAACTIVATELOCKED,
    @ACTIVATEOPTIONSLOCKED,
    @EXPORTAFTERACTIVATE,
    @EXPORTAFTERACTIVATELOCKED,
    @USEADDRESSPROCESSING,
    case when @USEADDRESSPROCESSING = 1 then @ADDRESSPROCESSINGOPTIONID else null end,
    case when @USEADDRESSPROCESSING = 1 then @NAMEFORMATPARAMETERID else null end,
    case when @USEADDRESSPROCESSING = 1 then @ADDRESSPROCESSINGOPTIONSEASONALASOFDATETYPECODE else 0 end,
    case when @USEADDRESSPROCESSING = 1 then @ADDRESSPROCESSINGOPTIONSEASONALASOFDATE else null end,
    @ADDRESSPROCESSINGLOCKED,
    @KPISLOCKED,
    @HOUSEHOLDINGTYPECODE,
    @HOUSEHOLDINGINCLUDEINDIVIDUALSWITHNOHOUSEHOLD,
    @HOUSEHOLDINGINCLUDEHOUSEHOLDSWITHNOMEMBERS,
    @HOUSEHOLDINGONERECORDPERHOUSEHOLD,
    @HOUSEHOLDINGLOCKED,
    @INCLUDESELECTIONSLOCKED,
    @EXCLUDESELECTIONSLOCKED,
    @EXCLUDEDECEASED,
    @EXCLUDEDECEASEDLOCKED,
    @EXCLUDEINACTIVE,
    @EXCLUDEINACTIVELOCKED,
    @EXCLUSIONASOFDATE,
    @EXCLUSIONDATETYPECODE,
    @EXCLUSIONASOFDATELOCKED,
    @EXCLUSIONSLOCKED,
    @ASKLADDEROVERRIDESLOCKED,
    @SEEDSLOCKED,
    @BUSINESSUNITSLOCKED,
    @CHANGEAGENTID,
    @CHANGEAGENTID,
    @CURRENTDATE,
    @CURRENTDATE
  );

  /* Save Ask ladder overrides */
  if @ASKLADDEROVERRIDES is not null
    exec dbo.[USP_MKTCOMMUNICATIONTEMPLATEDEFAULTASKLADDEROVERRIDE_GETITEMLIST_ADDFROMXML] @ID, @ASKLADDEROVERRIDES, @CHANGEAGENTID, @CURRENTDATE;

  /* Save Seeds */
  if @SEEDS is not null
    exec dbo.[USP_MKTCOMMUNICATIONTEMPLATEDEFAULTSEED_GETITEMLIST_ADDFROMXML] @ID, @SEEDS, @CHANGEAGENTID, @CURRENTDATE;

  /* Save Business units */
  if @BUSINESSUNITS is not null
    exec dbo.[USP_MKTCOMMUNICATIONTEMPLATEDEFAULTBUSINESSUNIT_GETBUSINESSUNITS_ADDFROMXML] @ID, @BUSINESSUNITS, @CHANGEAGENTID;

  return 0;