USP_DATAFORMTEMPLATE_VIEW_MKTPACKAGES

The load procedure used by the view dataform template "Packages Page View"

Parameters

Parameter	Parameter Type	Mode	Description
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@ACKNOWLEDGEMENTMAILINGSINSTALLED	bit	INOUT	Marketing Acknowledgement installed?
@MEMBERSHIPMAILINGSINSTALLED	bit	INOUT	Membership renewal efforts installed?
@SPONSORSHIPMAILINGSINSTALLED	bit	INOUT	Sponsorship efforts installed?
@NETCOMMUNITYLINKESTABLISHED	bit	INOUT	Blackbaud Internet Solutions link established?
@ISBBEC	bit	INOUT	BBEC?
@ISBBDM	bit	INOUT	BBDM?
@ISBASICDEV	bit	INOUT

Definition

Copy


CREATE procedure dbo.[USP_DATAFORMTEMPLATE_VIEW_MKTPACKAGES]
(
  @DATALOADED bit = 0 output,
  @ACKNOWLEDGEMENTMAILINGSINSTALLED bit = null output,
  @MEMBERSHIPMAILINGSINSTALLED bit = null output,
  @SPONSORSHIPMAILINGSINSTALLED bit = null output,
  @NETCOMMUNITYLINKESTABLISHED bit = null output,
  @ISBBEC bit = null output,
  @ISBBDM bit = null output,
  @ISBASICDEV bit = null output

)
as
  begin
    set @ACKNOWLEDGEMENTMAILINGSINSTALLED = dbo.[UFN_MKTCOMMON_ACKNOWLEDGEMENTMAILINGSINSTALLED]();
    set @MEMBERSHIPMAILINGSINSTALLED = dbo.[UFN_MKTCOMMON_MEMBERSHIPMAILINGSINSTALLED]();
    set @SPONSORSHIPMAILINGSINSTALLED = dbo.[UFN_MKTCOMMON_SPONSORSHIPMAILINGSINSTALLED]();
    set @NETCOMMUNITYLINKESTABLISHED = dbo.[UFN_MKTNETCOMMUNITYINTEGRATION_LINKESTABLISHED]();
    set @ISBBEC = dbo.[UFN_INSTALLEDPRODUCTS_PRODUCTIS]('3117d2c8-7f46-42f2-abeb-b654f2f63046');
    set @ISBBDM = dbo.[UFN_INSTALLEDPRODUCTS_PRODUCTIS]('BB9873D7-F1ED-430A-8AB4-F09F47056538');
    set @ISBASICDEV = dbo.[UFN_INSTALLEDPRODUCTS_PRODUCTIS]('42c15648-749e-4859-a56d-3a6474814cc7');

    set @DATALOADED = 1;

    return 0;
  end