USP_DATAFORMTEMPLATE_VIEW_MKTMEMBERSHIPMAILINGTEMPLATE_EXPRESSION

The load procedure used by the view dataform template "Membership Renewal 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
@MEMBERSHIPMAILINGPROCESSID	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_MKTMEMBERSHIPMAILINGTEMPLATE_EXPRESSION]
(
  @ID uniqueidentifier,
  @DATALOADED bit = 0 output,
  @NAME nvarchar(100) = null output,
  @DESCRIPTION nvarchar(100) = null output,
  @MEMBERSHIPMAILINGPROCESSID 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 = [MKTMEMBERSHIPMAILINGTEMPLATE].[NAME],
    @DESCRIPTION = [MKTMEMBERSHIPMAILINGTEMPLATE].[DESCRIPTION],
    @MEMBERSHIPMAILINGPROCESSID = [MKTMEMBERSHIPMAILINGPROCESS].[ID],
    @NUMRULES = (select count([ID]) from dbo.[MKTMEMBERSHIPMAILINGTEMPLATERULE] where [MKTMEMBERSHIPMAILINGTEMPLATERULE].[MEMBERSHIPMAILINGTEMPLATEID] = [MKTMEMBERSHIPMAILINGTEMPLATE].[ID]),
    @SMARTQUERIESEXIST = dbo.[UFN_MKTSELECTION_SMARTQUERIESEXIST](1),
    @ADDRESSPROCESSINGOPTIONID = (case when [MKTMEMBERSHIPMAILINGTEMPLATE].[USEADDRESSPROCESSING] = 1 then [MKTMEMBERSHIPMAILINGTEMPLATE].[ADDRESSPROCESSINGOPTIONID] else '00000000-0000-0000-0000-000000000000' end),
    @NAMEFORMATPARAMETERID = (case when [MKTMEMBERSHIPMAILINGTEMPLATE].[USEADDRESSPROCESSING] = 1 then [MKTMEMBERSHIPMAILINGTEMPLATE].[NAMEFORMATPARAMETERID] else '00000000-0000-0000-0000-000000000000' end)
  from dbo.[MKTMEMBERSHIPMAILINGTEMPLATE]
  inner join dbo.[MKTMEMBERSHIPMAILINGPROCESS] on [MKTMEMBERSHIPMAILINGPROCESS].[MEMBERSHIPMAILINGTEMPLATEID] = [MKTMEMBERSHIPMAILINGTEMPLATE].[ID]
  where [MKTMEMBERSHIPMAILINGTEMPLATE].[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.[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;