USP_DATAFORMTEMPLATE_PRELOAD_ADD_MKTMARKETINGPLANITEM
The load procedure used by the edit dataform template "Marketing Plan Item Add Form"
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @PARENTMARKETINGPLANITEMID | uniqueidentifier | IN | Input parameter indicating the context ID for the record being added. |
| @CAPTION | nvarchar(50) | INOUT | Caption |
| @LEVEL | int | INOUT | Level |
| @MARKETINGPLANID | uniqueidentifier | INOUT | Marketing plan ID |
| @APPEALLEVEL | bit | INOUT | Appeal level |
Definition
Copy
CREATE procedure dbo.[USP_DATAFORMTEMPLATE_PRELOAD_ADD_MKTMARKETINGPLANITEM]
(
@PARENTMARKETINGPLANITEMID uniqueidentifier,
@CAPTION nvarchar(50) = null output,
@LEVEL integer = null output,
@MARKETINGPLANID uniqueidentifier = null output,
@APPEALLEVEL bit = null output
)
as
set nocount on;
select
@LEVEL = [LEVEL] + 1,
@MARKETINGPLANID = [MARKETINGPLANID]
from dbo.[MKTMARKETINGPLANITEM]
where [ID] = @PARENTMARKETINGPLANITEMID;
select
@CAPTION = [CAPTION],
@APPEALLEVEL = (case when (select max([LEVEL]) - 1 from dbo.[MKTMARKETINGPLANITEMTEMPLATEITEM] where [MARKETINGPLANID] = @MARKETINGPLANID) = [LEVEL] then 1 else 0 end)
from dbo.[MKTMARKETINGPLANITEMTEMPLATEITEM]
where [MARKETINGPLANID] = @MARKETINGPLANID and [LEVEL] = @LEVEL;
return 0;