USP_DATAFORMTEMPLATE_ADD_MKTSPONSORSHIPMAILINGTEMPLATEASKLADDEROVERRIDE_PRELOAD
The load procedure used by the edit dataform template "Sponsorship Effort Template Ask Ladder Override Add Form"
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @SPONSORSHIPMAILINGTEMPLATEID | uniqueidentifier | IN | Input parameter indicating the context ID for the record being added. |
| @ASKLADDERID | uniqueidentifier | INOUT | Ask ladder |
| @BASECURRENCYID | uniqueidentifier | INOUT | Base currency ID |
Definition
Copy
CREATE procedure dbo.[USP_DATAFORMTEMPLATE_ADD_MKTSPONSORSHIPMAILINGTEMPLATEASKLADDEROVERRIDE_PRELOAD]
(
@SPONSORSHIPMAILINGTEMPLATEID uniqueidentifier,
@ASKLADDERID uniqueidentifier = null output,
@BASECURRENCYID uniqueidentifier = null output
)
as
set nocount on;
select top 1
@ASKLADDERID = [ID]
from dbo.[MKTASKLADDER]
where [ISACTIVE] = 1;
select
@BASECURRENCYID = [BASECURRENCYID]
from dbo.[MKTSPONSORSHIPMAILINGTEMPLATE]
where [ID] = @SPONSORSHIPMAILINGTEMPLATEID;
return 0;