USP_DATAFORMTEMPLATE_VIEW_MKTACKNOWLEDGEMENTMAILINGTEMPLATE_EXPRESSION

The load procedure used by the view dataform template "Marketing Acknowledgement Template Page Expression View Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@NAME	nvarchar(100)	INOUT	Name
@DESCRIPTION	nvarchar(100)	INOUT	Description
@ACKNOWLEDGEMENTMAILINGPROCESSID	uniqueidentifier	INOUT	Process ID
@NUMRULES	int	INOUT	Number of rules
@SMARTQUERIESEXIST	bit	INOUT	Smart queries exist?
@ADDRESSPROCESSINGOPTIONID	uniqueidentifier	INOUT	Address processing option ID
@NAMEFORMATPARAMETERID	uniqueidentifier	INOUT	Name format parameter ID
@ISBBEC	bit	INOUT	Is BBEC?
@CANCHANGEBASECURRENCY	bit	INOUT	Can change base currency?

Definition

Copy



CREATE procedure dbo.[USP_DATAFORMTEMPLATE_VIEW_MKTACKNOWLEDGEMENTMAILINGTEMPLATE_EXPRESSION]
(
  @ID uniqueidentifier,
  @DATALOADED bit = 0 output,
  @NAME nvarchar(100) = null output,
  @DESCRIPTION nvarchar(100) = null output,
  @ACKNOWLEDGEMENTMAILINGPROCESSID uniqueidentifier = null output,
  @NUMRULES int = null output,
  @SMARTQUERIESEXIST bit = null output,
  @ADDRESSPROCESSINGOPTIONID uniqueidentifier = null output,
  @NAMEFORMATPARAMETERID uniqueidentifier = null output,
  @ISBBEC bit = null output,
  @CANCHANGEBASECURRENCY bit = null output
)
as
  set nocount on;

  set @DATALOADED = 0;

  select
    @DATALOADED = 1,
    @NAME = [MKTACKNOWLEDGEMENTMAILINGTEMPLATE].[NAME],
    @DESCRIPTION = [MKTACKNOWLEDGEMENTMAILINGTEMPLATE].[DESCRIPTION],
    @ACKNOWLEDGEMENTMAILINGPROCESSID = [MKTACKNOWLEDGEMENTMAILINGPROCESS].[ID],
    @NUMRULES = (select count([ID]) from dbo.[MKTACKNOWLEDGEMENTMAILINGTEMPLATERULE] where [MKTACKNOWLEDGEMENTMAILINGTEMPLATERULE].[ACKNOWLEDGEMENTMAILINGTEMPLATEID] = [MKTACKNOWLEDGEMENTMAILINGTEMPLATE].[ID]),
    @SMARTQUERIESEXIST = dbo.[UFN_MKTSELECTION_SMARTQUERIESEXIST](1),
    @ADDRESSPROCESSINGOPTIONID = (case when [MKTACKNOWLEDGEMENTMAILINGTEMPLATE].[USEADDRESSPROCESSING] = 1 then [MKTACKNOWLEDGEMENTMAILINGTEMPLATE].[ADDRESSPROCESSINGOPTIONID] else null end),
    @NAMEFORMATPARAMETERID = (case when [MKTACKNOWLEDGEMENTMAILINGTEMPLATE].[USEADDRESSPROCESSING] = 1 then [MKTACKNOWLEDGEMENTMAILINGTEMPLATE].[NAMEFORMATPARAMETERID] else null end)
  from dbo.[MKTACKNOWLEDGEMENTMAILINGTEMPLATE]
  inner join dbo.[MKTACKNOWLEDGEMENTMAILINGPROCESS] on [MKTACKNOWLEDGEMENTMAILINGPROCESS].[ACKNOWLEDGEMENTMAILINGTEMPLATEID] = [MKTACKNOWLEDGEMENTMAILINGTEMPLATE].[ID]
  where [MKTACKNOWLEDGEMENTMAILINGTEMPLATE].[ID] = @ID;

  if @DATALOADED = 1
    begin
      set @ISBBEC = (case when dbo.[UFN_INSTALLEDPRODUCTS_PRODUCTIS]('BB9873D7-F1ED-430A-8AB4-F09F47056538') = 0 then 1 else 0 end);

      if @ISBBEC = 0 or @NUMRULES > 0
        set @CANCHANGEBASECURRENCY = 0;
      else if exists(select * from dbo.[MKTACKNOWLEDGEMENTMAILINGTEMPLATEAPPEAL] where [ACKNOWLEDGEMENTTEMPLATEID] = @ID and dbo.[UFN_MKTRECORDSOURCE_VALIDFORBBEC]([RECORDSOURCEID]) = 1 and [APPEALSYSTEMID] <> '')
        set @CANCHANGEBASECURRENCY = 0;
      else if exists(select * from dbo.[MKTACKNOWLEDGEMENTMAILINGTEMPLATEASKLADDEROVERRIDE] where [ACKNOWLEDGEMENTMAILINGTEMPLATEID] = @ID)
        set @CANCHANGEBASECURRENCY = 0;
      else
        set @CANCHANGEBASECURRENCY = 1;
    end

  return 0;