USP_DATAFORMTEMPLATE_VIEW_MKTCOMMUNICATIONTEMPLATE
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN | |
| @CURRENTAPPUSERID | uniqueidentifier | IN | |
| @DATALOADED | bit | INOUT | |
| @BASECURRENCYID | uniqueidentifier | INOUT | |
| @NAME | nvarchar(100) | INOUT | |
| @DESCRIPTION | nvarchar(255) | INOUT | |
| @SITEID | uniqueidentifier | INOUT | |
| @TEMPLATETYPECODE | tinyint | INOUT | |
| @OVERRIDEASKLADDERS | bit | INOUT | |
| @OVERRIDEAPPEALBUSINESSUNITS | bit | INOUT | |
| @INCLUDESEEDS | bit | INOUT | |
| @ISACTIVE | bit | INOUT | |
| @COMMUNICATIONNAMESCHEMEID | uniqueidentifier | INOUT | |
| @DESCRIPTIONDEFAULT | nvarchar(255) | INOUT | |
| @DESCRIPTIONLOCKED | bit | INOUT | |
| @APPEALINFORMATION | xml | INOUT | |
| @APPEALLOCKED | bit | INOUT | |
| @CHANNELCODEDEFAULT | tinyint | INOUT | |
| @CHANNELCODELOCKED | bit | INOUT | |
| @ALLOWRESERVINGFINDERNUMBERS | bit | INOUT | |
| @ALLOWRESERVINGFINDERNUMBERSLOCKED | bit | INOUT | |
| @ALLOWSPECIFYBUDGET | bit | INOUT | |
| @ALLOWSPECIFYBUDGETLOCKED | bit | INOUT | |
| @ALLOWEXCLUDEPREVIOUSEFFORTS | bit | INOUT | |
| @ALLOWEXCLUDEPREVIOUSEFFORTSLOCKED | bit | INOUT | |
| @SOURCECODEIDDEFAULT | uniqueidentifier | INOUT | |
| @SOURCECODELOCKED | bit | INOUT | |
| @EXPORTDEFINITIONRECORDTYPE | nvarchar(50) | INOUT | |
| @EXPORTDEFINITIONRECORDTYPEID | uniqueidentifier | INOUT | |
| @EXPORTDEFINITIONQUERYVIEWID | uniqueidentifier | INOUT | |
| @MAILEXPORTDEFINITIONID | uniqueidentifier | INOUT | |
| @MAILEXPORTDEFINITIONIDLOCKED | bit | INOUT | |
| @PHONEEXPORTDEFINITIONID | uniqueidentifier | INOUT | |
| @PHONEEXPORTDEFINITIONIDLOCKED | bit | INOUT | |
| @EMAILEXPORTDEFINITIONID | uniqueidentifier | INOUT | |
| @EMAILEXPORTDEFINITIONIDLOCKED | bit | INOUT | |
| @EXPORTDESCRIPTION | nvarchar(255) | INOUT | |
| @EXPORTDESCRIPTIONLOCKED | bit | INOUT | |
| @CURRENCYSYMBOLDISPLAYSETTINGCODE | tinyint | INOUT | |
| @CURRENCYSYMBOLDISPLAYSETTINGCODELOCKED | bit | INOUT | |
| @CURRENCYDECIMALDIGITSDISPLAYSETTINGCODE | tinyint | INOUT | |
| @CURRENCYDECIMALDIGITSDISPLAYSETTINGCODELOCKED | bit | INOUT | |
| @CURRENCYDECIMALDIGITS | int | INOUT | |
| @CURRENCYGROUPSEPARATORDISPLAYSETTINGCODE | tinyint | INOUT | |
| @CURRENCYGROUPSEPARATORDISPLAYSETTINGCODELOCKED | bit | INOUT | |
| @CURRENCYGROUPSEPARATOR | nvarchar(4) | INOUT | |
| @CURRENCYDECIMALSEPARATORDISPLAYSETTINGCODE | tinyint | INOUT | |
| @CURRENCYDECIMALSEPARATORDISPLAYSETTINGCODELOCKED | bit | INOUT | |
| @CURRENCYDECIMALSEPARATOR | nvarchar(4) | INOUT | |
| @ORGANIZATIONCURRENCYID | uniqueidentifier | INOUT | |
| @DATEFORMAT | nvarchar(50) | INOUT | |
| @DATEFORMATLOCKED | bit | INOUT | |
| @FUZZYDATEFORMAT | nvarchar(50) | INOUT | |
| @FUZZYDATEFORMATLOCKED | bit | INOUT | |
| @MONTHDAYFORMAT | nvarchar(50) | INOUT | |
| @MONTHDAYFORMATLOCKED | bit | INOUT | |
| @HOURMINUTEFORMAT | nvarchar(50) | INOUT | |
| @HOURMINUTEFORMATLOCKED | bit | INOUT | |
| @CSVLINEBREAKCODE | tinyint | INOUT | |
| @CSVLINEBREAKCODELOCKED | bit | INOUT | |
| @RUNSEGMENTATIONSEGMENTREFRESHPROCESS | bit | INOUT | |
| @RUNSEGMENTATIONSEGMENTREFRESHPROCESSLOCKED | bit | INOUT | |
| @RUNMARKETINGEXCLUSIONSREPORT | bit | INOUT | |
| @RUNMARKETINGEXCLUSIONSREPORTLOCKED | bit | INOUT | |
| @CACHESOURCEANALYSISRULEDATA | bit | INOUT | |
| @CACHESOURCEANALYSISRULEDATALOCKED | bit | INOUT | |
| @RUNSEGMENTATIONSEGMENTCALCULATEPROCESS | bit | INOUT | |
| @RUNSEGMENTATIONSEGMENTREFRESHPROCESSACTIVATE | bit | INOUT | |
| @RUNMARKETINGEXCLUSIONSREPORTACTIVATE | bit | INOUT | |
| @CACHESOURCEANALYSISRULEDATAACTIVATE | bit | INOUT | |
| @ACTIVATEOPTIONSLOCKED | bit | INOUT | |
| @EXPORTAFTERACTIVATE | bit | INOUT | |
| @EXPORTAFTERACTIVATELOCKED | bit | INOUT | |
| @USEADDRESSPROCESSING | bit | INOUT | |
| @ADDRESSPROCESSINGOPTIONID | uniqueidentifier | INOUT | |
| @NAMEFORMATPARAMETERID | uniqueidentifier | INOUT | |
| @ADDRESSPROCESSINGOPTIONSEASONALASOFDATETYPECODE | tinyint | INOUT | |
| @ADDRESSPROCESSINGOPTIONSEASONALASOFDATE | datetime | INOUT | |
| @ADDRESSPROCESSINGLOCKED | bit | INOUT | |
| @ENABLEHOUSEHOLDING | bit | INOUT | |
| @HOUSEHOLDINGTYPECODE | tinyint | INOUT | |
| @HOUSEHOLDINGINCLUDEHOUSEHOLDSWITHNOMEMBERS | bit | INOUT | |
| @HOUSEHOLDINGONERECORDPERHOUSEHOLD | bit | INOUT | |
| @HOUSEHOLDINGINCLUDEINDIVIDUALSWITHNOHOUSEHOLD | bit | INOUT | |
| @HOUSEHOLDINGLOCKED | bit | INOUT | |
| @DEFAULTKPIS | xml | INOUT | |
| @KPISLOCKED | bit | INOUT | |
| @INCLUDESELECTIONS | xml | INOUT | |
| @INCLUDESELECTIONSLOCKED | bit | INOUT | |
| @EXCLUDESELECTIONS | xml | INOUT | |
| @EXCLUDESELECTIONSLOCKED | bit | INOUT | |
| @EXCLUDEDECEASED | bit | INOUT | |
| @CANUPDATEEXCLUDEDECEASED | bit | INOUT | |
| @EXCLUDEDECEASEDLOCKED | bit | INOUT | |
| @EXCLUDEINACTIVE | bit | INOUT | |
| @CANUPDATEEXCLUDEINACTIVE | bit | INOUT | |
| @EXCLUDEINACTIVELOCKED | bit | INOUT | |
| @EXCLUSIONASOFDATE | datetime | INOUT | |
| @EXCLUSIONDATETYPECODE | tinyint | INOUT | |
| @EXCLUSIONASOFDATELOCKED | bit | INOUT | |
| @EXCLUSIONS | xml | INOUT | |
| @EXCLUSIONSLOCKED | bit | INOUT | |
| @ASKLADDEROVERRIDES | xml | INOUT | |
| @ASKLADDEROVERRIDESLOCKED | bit | INOUT | |
| @SEEDSLOCKED | bit | INOUT | |
| @SEEDS | xml | INOUT | |
| @BUSINESSUNITSLOCKED | bit | INOUT | |
| @BUSINESSUNITS | xml | INOUT | |
| @CURRENCY | nvarchar(110) | INOUT | |
| @CACHESOURCEANALYSISRULEDATAACTIVATELOCKED | bit | INOUT | |
| @ALLOWEFFORTBUSINESSUNITSOVERRIDE | bit | INOUT | |
| @ALLOWEFFORTADDRESSPROCESSINGOVERRIDE | bit | INOUT | |
| @ISBBEC | bit | INOUT |
Definition
Copy
CREATE procedure dbo.[USP_DATAFORMTEMPLATE_VIEW_MKTCOMMUNICATIONTEMPLATE]
(
@ID uniqueidentifier,
@CURRENTAPPUSERID uniqueidentifier,
@DATALOADED bit = 0 output,
@BASECURRENCYID uniqueidentifier = null output,
@NAME nvarchar(100) = null output,
@DESCRIPTION nvarchar(255) = null output,
@SITEID uniqueidentifier = null output,
@TEMPLATETYPECODE tinyint = null output,
@OVERRIDEASKLADDERS bit = null output,
@OVERRIDEAPPEALBUSINESSUNITS bit = null output,
@INCLUDESEEDS bit = null output,
@ISACTIVE bit = null output,
@COMMUNICATIONNAMESCHEMEID uniqueidentifier = null output,
@DESCRIPTIONDEFAULT nvarchar(255) = null output,
@DESCRIPTIONLOCKED bit = null output,
@APPEALINFORMATION xml = null output,
@APPEALLOCKED bit = null output,
@CHANNELCODEDEFAULT tinyint = null output,
@CHANNELCODELOCKED bit = null output,
@ALLOWRESERVINGFINDERNUMBERS bit = null output,
@ALLOWRESERVINGFINDERNUMBERSLOCKED bit = null output,
@ALLOWSPECIFYBUDGET bit = null output,
@ALLOWSPECIFYBUDGETLOCKED bit = null output,
@ALLOWEXCLUDEPREVIOUSEFFORTS bit = null output,
@ALLOWEXCLUDEPREVIOUSEFFORTSLOCKED bit = null output,
@SOURCECODEIDDEFAULT uniqueidentifier = null output,
@SOURCECODELOCKED bit = null output,
@EXPORTDEFINITIONRECORDTYPE nvarchar(50) = null output,
@EXPORTDEFINITIONRECORDTYPEID uniqueidentifier = null output,
@EXPORTDEFINITIONQUERYVIEWID uniqueidentifier = null output,
@MAILEXPORTDEFINITIONID uniqueidentifier = null output,
@MAILEXPORTDEFINITIONIDLOCKED bit = null output,
@PHONEEXPORTDEFINITIONID uniqueidentifier = null output,
@PHONEEXPORTDEFINITIONIDLOCKED bit = null output,
@EMAILEXPORTDEFINITIONID uniqueidentifier = null output,
@EMAILEXPORTDEFINITIONIDLOCKED bit = null output,
@EXPORTDESCRIPTION nvarchar(255) = null output,
@EXPORTDESCRIPTIONLOCKED bit = null output,
@CURRENCYSYMBOLDISPLAYSETTINGCODE tinyint = null output,
@CURRENCYSYMBOLDISPLAYSETTINGCODELOCKED bit = null output,
@CURRENCYDECIMALDIGITSDISPLAYSETTINGCODE tinyint = null output,
@CURRENCYDECIMALDIGITSDISPLAYSETTINGCODELOCKED bit = null output,
@CURRENCYDECIMALDIGITS int = null output,
@CURRENCYGROUPSEPARATORDISPLAYSETTINGCODE tinyint = null output,
@CURRENCYGROUPSEPARATORDISPLAYSETTINGCODELOCKED bit = null output,
@CURRENCYGROUPSEPARATOR nvarchar(4) = null output,
@CURRENCYDECIMALSEPARATORDISPLAYSETTINGCODE tinyint = null output,
@CURRENCYDECIMALSEPARATORDISPLAYSETTINGCODELOCKED bit = null output,
@CURRENCYDECIMALSEPARATOR nvarchar(4) = null output,
@ORGANIZATIONCURRENCYID uniqueidentifier = null output,
@DATEFORMAT nvarchar(50) = null output,
@DATEFORMATLOCKED bit = null output,
@FUZZYDATEFORMAT nvarchar(50) = null output,
@FUZZYDATEFORMATLOCKED bit = null output,
@MONTHDAYFORMAT nvarchar(50) = null output,
@MONTHDAYFORMATLOCKED bit = null output,
@HOURMINUTEFORMAT nvarchar(50) = null output,
@HOURMINUTEFORMATLOCKED bit = null output,
@CSVLINEBREAKCODE tinyint = null output,
@CSVLINEBREAKCODELOCKED bit = null output,
@RUNSEGMENTATIONSEGMENTREFRESHPROCESS bit = null output,
@RUNSEGMENTATIONSEGMENTREFRESHPROCESSLOCKED bit = null output,
@RUNMARKETINGEXCLUSIONSREPORT bit = null output,
@RUNMARKETINGEXCLUSIONSREPORTLOCKED bit = null output,
@CACHESOURCEANALYSISRULEDATA bit = null output,
@CACHESOURCEANALYSISRULEDATALOCKED bit = null output,
@RUNSEGMENTATIONSEGMENTCALCULATEPROCESS bit = null output,
@RUNSEGMENTATIONSEGMENTREFRESHPROCESSACTIVATE bit = null output,
@RUNMARKETINGEXCLUSIONSREPORTACTIVATE bit = null output,
@CACHESOURCEANALYSISRULEDATAACTIVATE bit = null output,
@ACTIVATEOPTIONSLOCKED bit = null output,
@EXPORTAFTERACTIVATE bit = null output,
@EXPORTAFTERACTIVATELOCKED bit = null output,
@USEADDRESSPROCESSING bit = null output,
@ADDRESSPROCESSINGOPTIONID uniqueidentifier = null output,
@NAMEFORMATPARAMETERID uniqueidentifier = null output,
@ADDRESSPROCESSINGOPTIONSEASONALASOFDATETYPECODE tinyint = null output,
@ADDRESSPROCESSINGOPTIONSEASONALASOFDATE datetime = null output,
@ADDRESSPROCESSINGLOCKED bit = null output,
@ENABLEHOUSEHOLDING bit = null output,
@HOUSEHOLDINGTYPECODE tinyint = null output,
@HOUSEHOLDINGINCLUDEHOUSEHOLDSWITHNOMEMBERS bit = null output,
@HOUSEHOLDINGONERECORDPERHOUSEHOLD bit = null output,
@HOUSEHOLDINGINCLUDEINDIVIDUALSWITHNOHOUSEHOLD bit = null output,
@HOUSEHOLDINGLOCKED bit = null output,
@DEFAULTKPIS xml = null output,
@KPISLOCKED bit = null output,
@INCLUDESELECTIONS xml = null output,
@INCLUDESELECTIONSLOCKED bit = null output,
@EXCLUDESELECTIONS xml = null output,
@EXCLUDESELECTIONSLOCKED bit = null output,
@EXCLUDEDECEASED bit = null output,
@CANUPDATEEXCLUDEDECEASED bit = null output,
@EXCLUDEDECEASEDLOCKED bit = null output,
@EXCLUDEINACTIVE bit = null output,
@CANUPDATEEXCLUDEINACTIVE bit = null output,
@EXCLUDEINACTIVELOCKED bit = null output,
@EXCLUSIONASOFDATE datetime = null output,
@EXCLUSIONDATETYPECODE tinyint = null output,
@EXCLUSIONASOFDATELOCKED bit = null output,
@EXCLUSIONS xml = null output,
@EXCLUSIONSLOCKED bit = null output,
@ASKLADDEROVERRIDES xml = null output,
@ASKLADDEROVERRIDESLOCKED bit = null output,
@SEEDSLOCKED bit = null output,
@SEEDS xml = null output,
@BUSINESSUNITSLOCKED bit = null output,
@BUSINESSUNITS xml = null output,
@CURRENCY nvarchar(110) = null output,
@CACHESOURCEANALYSISRULEDATAACTIVATELOCKED bit = null output,
@ALLOWEFFORTBUSINESSUNITSOVERRIDE bit = null output,
@ALLOWEFFORTADDRESSPROCESSINGOVERRIDE bit = null output,
@ISBBEC bit = null output
)
as
set nocount on;
declare @TSLONG bigint = 0;
set @DATALOADED = 0;
set @ISBBEC = (case when dbo.[UFN_INSTALLEDPRODUCTS_PRODUCTIS]('BB9873D7-F1ED-430A-8AB4-F09F47056538') = 0 then 1 else 0 end);
exec dbo.[USP_DATAFORMTEMPLATE_EDITLOAD_MKTCOMMUNICATIONTEMPLATE]
@ID,
@CURRENTAPPUSERID,
@DATALOADED output,
@TSLONG output,
@BASECURRENCYID output,
@NAME output,
@DESCRIPTION output,
@SITEID output,
@TEMPLATETYPECODE output,
@OVERRIDEASKLADDERS output,
@OVERRIDEAPPEALBUSINESSUNITS output,
@INCLUDESEEDS output,
@ISACTIVE output,
@COMMUNICATIONNAMESCHEMEID output,
@DESCRIPTIONDEFAULT output,
@DESCRIPTIONLOCKED output,
@APPEALINFORMATION output,
@APPEALLOCKED output,
@CHANNELCODEDEFAULT output,
@CHANNELCODELOCKED output,
@ALLOWRESERVINGFINDERNUMBERS output,
@ALLOWRESERVINGFINDERNUMBERSLOCKED output,
@ALLOWSPECIFYBUDGET output,
@ALLOWSPECIFYBUDGETLOCKED output,
@ALLOWEXCLUDEPREVIOUSEFFORTS output,
@ALLOWEXCLUDEPREVIOUSEFFORTSLOCKED output,
@SOURCECODEIDDEFAULT output,
@SOURCECODELOCKED output,
@EXPORTDEFINITIONRECORDTYPE output,
@EXPORTDEFINITIONRECORDTYPEID output,
@EXPORTDEFINITIONQUERYVIEWID output,
@MAILEXPORTDEFINITIONID output,
@MAILEXPORTDEFINITIONIDLOCKED output,
@PHONEEXPORTDEFINITIONID output,
@PHONEEXPORTDEFINITIONIDLOCKED output,
@EMAILEXPORTDEFINITIONID output,
@EMAILEXPORTDEFINITIONIDLOCKED output,
@EXPORTDESCRIPTION output,
@EXPORTDESCRIPTIONLOCKED output,
@CURRENCYSYMBOLDISPLAYSETTINGCODE output,
@CURRENCYSYMBOLDISPLAYSETTINGCODELOCKED output,
@CURRENCYDECIMALDIGITSDISPLAYSETTINGCODE output,
@CURRENCYDECIMALDIGITSDISPLAYSETTINGCODELOCKED output,
@CURRENCYDECIMALDIGITS output,
@CURRENCYGROUPSEPARATORDISPLAYSETTINGCODE output,
@CURRENCYGROUPSEPARATORDISPLAYSETTINGCODELOCKED output,
@CURRENCYGROUPSEPARATOR output,
@CURRENCYDECIMALSEPARATORDISPLAYSETTINGCODE output,
@CURRENCYDECIMALSEPARATORDISPLAYSETTINGCODELOCKED output,
@CURRENCYDECIMALSEPARATOR output,
@ORGANIZATIONCURRENCYID output,
@DATEFORMAT output,
@DATEFORMATLOCKED output,
@FUZZYDATEFORMAT output,
@FUZZYDATEFORMATLOCKED output,
@MONTHDAYFORMAT output,
@MONTHDAYFORMATLOCKED output,
@HOURMINUTEFORMAT output,
@HOURMINUTEFORMATLOCKED output,
@CSVLINEBREAKCODE output,
@CSVLINEBREAKCODELOCKED output,
@RUNSEGMENTATIONSEGMENTREFRESHPROCESS output,
@RUNSEGMENTATIONSEGMENTREFRESHPROCESSLOCKED output,
@RUNMARKETINGEXCLUSIONSREPORT output,
@RUNMARKETINGEXCLUSIONSREPORTLOCKED output,
@CACHESOURCEANALYSISRULEDATA output,
@CACHESOURCEANALYSISRULEDATALOCKED output,
@RUNSEGMENTATIONSEGMENTCALCULATEPROCESS output,
@RUNSEGMENTATIONSEGMENTREFRESHPROCESSACTIVATE output,
@RUNMARKETINGEXCLUSIONSREPORTACTIVATE output,
@CACHESOURCEANALYSISRULEDATAACTIVATE output,
@ACTIVATEOPTIONSLOCKED output,
@EXPORTAFTERACTIVATE output,
@EXPORTAFTERACTIVATELOCKED output,
@USEADDRESSPROCESSING output,
@ADDRESSPROCESSINGOPTIONID output,
@NAMEFORMATPARAMETERID output,
@ADDRESSPROCESSINGOPTIONSEASONALASOFDATETYPECODE output,
@ADDRESSPROCESSINGOPTIONSEASONALASOFDATE output,
@ADDRESSPROCESSINGLOCKED output,
@ENABLEHOUSEHOLDING output,
@HOUSEHOLDINGTYPECODE output,
@HOUSEHOLDINGINCLUDEHOUSEHOLDSWITHNOMEMBERS output,
@HOUSEHOLDINGONERECORDPERHOUSEHOLD output,
@HOUSEHOLDINGINCLUDEINDIVIDUALSWITHNOHOUSEHOLD output,
@HOUSEHOLDINGLOCKED output,
@DEFAULTKPIS output,
@KPISLOCKED output,
@INCLUDESELECTIONS output,
@INCLUDESELECTIONSLOCKED output,
@EXCLUDESELECTIONS output,
@EXCLUDESELECTIONSLOCKED output,
@EXCLUDEDECEASED output,
@CANUPDATEEXCLUDEDECEASED output,
@EXCLUDEDECEASEDLOCKED output,
@EXCLUDEINACTIVE output,
@CANUPDATEEXCLUDEINACTIVE output,
@EXCLUDEINACTIVELOCKED output,
@EXCLUSIONASOFDATE output,
@EXCLUSIONDATETYPECODE output,
@EXCLUSIONASOFDATELOCKED output,
@EXCLUSIONS output,
@EXCLUSIONSLOCKED output,
@ASKLADDEROVERRIDES output,
@ASKLADDEROVERRIDESLOCKED output,
@SEEDSLOCKED output,
@SEEDS output,
@BUSINESSUNITSLOCKED output,
@BUSINESSUNITS output,
@CURRENCY output,
@CACHESOURCEANALYSISRULEDATAACTIVATELOCKED output,
@ALLOWEFFORTBUSINESSUNITSOVERRIDE output,
@ALLOWEFFORTADDRESSPROCESSINGOVERRIDE output;
return 0;