USP_DATAFORMTEMPLATE_VIEW_MKTSPONSORSHIPMAILINGTEMPLATE_EXPRESSION

The load procedure used by the view dataform template "Sponsorship Effort 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
@SPONSORSHIPMAILINGPROCESSID	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
@CANCHANGEBASECURRENCY	bit	INOUT	Can change base currency?

Definition

Copy



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

  set @DATALOADED = 0;

  select
    @DATALOADED = 1,
    @NAME = [MKTSPONSORSHIPMAILINGTEMPLATE].[NAME],
    @DESCRIPTION = [MKTSPONSORSHIPMAILINGTEMPLATE].[DESCRIPTION],
    @SPONSORSHIPMAILINGPROCESSID = [MKTSPONSORSHIPMAILINGPROCESS].[ID],
    @NUMRULES = (select count([ID]) from dbo.[MKTSPONSORSHIPMAILINGTEMPLATERULE] where [MKTSPONSORSHIPMAILINGTEMPLATERULE].[SPONSORSHIPMAILINGTEMPLATEID] = [MKTSPONSORSHIPMAILINGTEMPLATE].[ID]),
    @SMARTQUERIESEXIST = dbo.[UFN_MKTSELECTION_SMARTQUERIESEXIST](1),
    @ADDRESSPROCESSINGOPTIONID = (case when [MKTSPONSORSHIPMAILINGTEMPLATE].[USEADDRESSPROCESSING] = 1 then [MKTSPONSORSHIPMAILINGTEMPLATE].[ADDRESSPROCESSINGOPTIONID] else null end),
    @NAMEFORMATPARAMETERID = (case when [MKTSPONSORSHIPMAILINGTEMPLATE].[USEADDRESSPROCESSING] = 1 then [MKTSPONSORSHIPMAILINGTEMPLATE].[NAMEFORMATPARAMETERID] else null end)
  from dbo.[MKTSPONSORSHIPMAILINGTEMPLATE]
  inner join dbo.[MKTSPONSORSHIPMAILINGPROCESS] on [MKTSPONSORSHIPMAILINGPROCESS].[SPONSORSHIPMAILINGTEMPLATEID] = [MKTSPONSORSHIPMAILINGTEMPLATE].[ID]
  where [MKTSPONSORSHIPMAILINGTEMPLATE].[ID] = @ID;

  if @DATALOADED = 1
    begin
      declare @ISBBEC bit = (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.[MKTSPONSORSHIPMAILINGTEMPLATEAPPEAL] where [SPONSORSHIPMAILINGTEMPLATEID] = @ID and dbo.[UFN_MKTRECORDSOURCE_VALIDFORBBEC]([RECORDSOURCEID]) = 1 and [APPEALSYSTEMID] <> '')
        set @CANCHANGEBASECURRENCY = 0;
      else if exists(select * from dbo.[MKTSPONSORSHIPMAILINGTEMPLATEASKLADDEROVERRIDE] where [SPONSORSHIPMAILINGTEMPLATEID] = @ID)
        set @CANCHANGEBASECURRENCY = 0;
      else
        set @CANCHANGEBASECURRENCY = 1;
    end

  return 0;