USP_DATAFORMTEMPLATE_ADD_MKTMARKETINGPLANITEMEXPENSE_PRELOAD
The load procedure used by the edit dataform template "Marketing Plan Item Expense Add Form"
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @MARKETINGPLANITEMID | uniqueidentifier | IN | Input parameter indicating the context ID for the record being added. |
| @CURRENTAPPUSERID | uniqueidentifier | IN | Input parameter indicating the ID of the current user. |
| @QUANTITY | decimal(18, 0) | INOUT | Quantity |
| @RESPONSES | decimal(18, 0) | INOUT | Responses |
| @BASECURRENCYID | uniqueidentifier | INOUT | Base currency ID |
Definition
Copy
CREATE procedure dbo.[USP_DATAFORMTEMPLATE_ADD_MKTMARKETINGPLANITEMEXPENSE_PRELOAD]
(
@MARKETINGPLANITEMID uniqueidentifier,
@CURRENTAPPUSERID uniqueidentifier,
@QUANTITY decimal = null output,
@RESPONSES decimal = null output,
@BASECURRENCYID uniqueidentifier = null output
)
as
set nocount on;
select
@BASECURRENCYID = [BASECURRENCYID],
@QUANTITY = [QUANTITY],
@RESPONSES = [TOTALTRANSACTIONSGOAL]
from dbo.[MKTMARKETINGPLANITEM]
where [ID] = @MARKETINGPLANITEMID;
return 0;