USP_DATAFORMTEMPLATE_VIEW_MKTASKLADDERS
The load procedure used by the view dataform template "Ask Ladders Page View"
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @DATALOADED | bit | INOUT | Output parameter indicating whether or not data was actually loaded. |
| @ACKNOWLEDGEMENTMAILINGSINSTALLED | bit | INOUT | Acknowledgement mailings installed? |
| @MEMBERSHIPMAILINGSINSTALLED | bit | INOUT | Membership renewal efforts installed? |
| @SPONSORSHIPMAILINGSINSTALLED | bit | INOUT | Sponsorship efforts installed? |
Definition
Copy
CREATE procedure dbo.[USP_DATAFORMTEMPLATE_VIEW_MKTASKLADDERS]
(
@DATALOADED bit = 0 output,
@ACKNOWLEDGEMENTMAILINGSINSTALLED bit = null output,
@MEMBERSHIPMAILINGSINSTALLED bit = null output,
@SPONSORSHIPMAILINGSINSTALLED bit = null output
)
as
begin
select
@ACKNOWLEDGEMENTMAILINGSINSTALLED = dbo.[UFN_MKTCOMMON_ACKNOWLEDGEMENTMAILINGSINSTALLED](),
@MEMBERSHIPMAILINGSINSTALLED = dbo.[UFN_MKTCOMMON_MEMBERSHIPMAILINGSINSTALLED](),
@SPONSORSHIPMAILINGSINSTALLED = dbo.[UFN_MKTCOMMON_SPONSORSHIPMAILINGSINSTALLED](),
@DATALOADED = 1;
return 0;
end