USP_DATAFORMTEMPLATE_VIEW_MKTMEMBERSHIPMAILINGS_EXPRESSION

The load procedure used by the view dataform template "Membership Renewal Efforts Page Expression View Form"

Parameters

Parameter	Parameter Type	Mode	Description
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@ISBBEC	bit	INOUT	Is BBEC?
@ACKNOWLEDGEMENTMAILINGSINSTALLED	bit	INOUT	Is acknowledgement marketing installed?
@MEMBERSHIPMAILINGSINSTALLED	bit	INOUT	Is membership renewal efforts installed
@SPONSORSHIPMAILINGSINSTALLED	bit	INOUT	Is sponsorship efforts installed?
@ISBASICPROGRAMS	bit	INOUT	ISBASICPROGRAMS

Definition

Copy


CREATE procedure dbo.[USP_DATAFORMTEMPLATE_VIEW_MKTMEMBERSHIPMAILINGS_EXPRESSION]
(
  @DATALOADED bit = 0 output,
  @ISBBEC bit = null output,
  @ACKNOWLEDGEMENTMAILINGSINSTALLED bit = null output,
  @MEMBERSHIPMAILINGSINSTALLED bit = null output,
  @SPONSORSHIPMAILINGSINSTALLED bit = null output,
  @ISBASICPROGRAMS bit = null output
)
as
  set nocount on;

  set @DATALOADED = 1;
  set @ISBBEC = (case when dbo.[UFN_INSTALLEDPRODUCTS_PRODUCTIS]('BB9873D7-F1ED-430A-8AB4-F09F47056538') = 0 then 1 else 0 end);
  set @ACKNOWLEDGEMENTMAILINGSINSTALLED = dbo.[UFN_MKTCOMMON_ACKNOWLEDGEMENTMAILINGSINSTALLED]();
  set @MEMBERSHIPMAILINGSINSTALLED = dbo.[UFN_MKTCOMMON_MEMBERSHIPMAILINGSINSTALLED]();
  set @SPONSORSHIPMAILINGSINSTALLED = dbo.[UFN_MKTCOMMON_SPONSORSHIPMAILINGSINSTALLED]();
  set @ISBASICPROGRAMS = dbo.UFN_INSTALLEDPRODUCTS_PRODUCTIS('bb1c17bc-9e0b-4683-b490-ee40d511fa05')

  return 0;