USP_DATAFORMTEMPLATE_ADD_MKTACKNOWLEDGEMENTMAILINGTEMPLATEASKLADDEROVERRIDE_PRELOAD
The load procedure used by the edit dataform template "Marketing Acknowledgement Template Ask Ladder Override Add Form"
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @CURRENTAPPUSERID | uniqueidentifier | IN | Input parameter indicating the ID of the current user. |
| @ACKNOWLEDGEMENTMAILINGTEMPLATEID | 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_MKTACKNOWLEDGEMENTMAILINGTEMPLATEASKLADDEROVERRIDE_PRELOAD]
(
@CURRENTAPPUSERID uniqueidentifier,
@ACKNOWLEDGEMENTMAILINGTEMPLATEID 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.[MKTACKNOWLEDGEMENTMAILINGTEMPLATE]
where [ID] = @ACKNOWLEDGEMENTMAILINGTEMPLATEID;
return 0;