USP_DATAFORMTEMPLATE_VIEW_MKTNETCOMMUNITYTEMPLATES

The load procedure used by the view dataform template "Emails 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?

Definition

Copy


CREATE procedure dbo.[USP_DATAFORMTEMPLATE_VIEW_MKTNETCOMMUNITYTEMPLATES]
(
  @DATALOADED bit = 0 output,
  @ACKNOWLEDGEMENTMAILINGSINSTALLED bit = null output,
  @MEMBERSHIPMAILINGSINSTALLED bit = null output,
  @SPONSORSHIPMAILINGSINSTALLED bit = null output
)
as
  begin
    set @ACKNOWLEDGEMENTMAILINGSINSTALLED = dbo.[UFN_MKTCOMMON_ACKNOWLEDGEMENTMAILINGSINSTALLED]();
    set @MEMBERSHIPMAILINGSINSTALLED = dbo.[UFN_MKTCOMMON_MEMBERSHIPMAILINGSINSTALLED]();
    set @SPONSORSHIPMAILINGSINSTALLED = dbo.[UFN_MKTCOMMON_SPONSORSHIPMAILINGSINSTALLED]();

    set @DATALOADED = 1;

    return 0;
  end