USP_DATAFORMTEMPLATE_PRELOAD_ADD_MKTMARKETINGPLAN
The load procedure used by the edit dataform template "Marketing Plan Add Form"
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @CURRENTAPPUSERID | uniqueidentifier | IN | Input parameter indicating the ID of the current user. |
| @DEFAULTTEMPLATEID | uniqueidentifier | INOUT | Default template ID |
| @SITEID | uniqueidentifier | INOUT | Site |
| @SITEREQUIRED | bit | INOUT | Site required? |
Definition
Copy
CREATE procedure dbo.[USP_DATAFORMTEMPLATE_PRELOAD_ADD_MKTMARKETINGPLAN]
(
@CURRENTAPPUSERID uniqueidentifier,
@DEFAULTTEMPLATEID uniqueidentifier = null output,
@SITEID uniqueidentifier = null output,
@SITEREQUIRED bit = null output
)
as
set nocount on;
select top 1
@DEFAULTTEMPLATEID = [ID]
from dbo.[MKTMARKETINGPLANTEMPLATE]
where [ISDEFAULT] <> 0
and dbo.[UFN_SITEALLOWEDFORUSER](@CURRENTAPPUSERID, [SITEID]) = 1
order by [NAME];
set @SITEREQUIRED = dbo.[UFN_SITEREQUIREDFORUSERONFEATURE](@CURRENTAPPUSERID, 'BCAE5DF9-C4CB-419d-8E47-AC03A67CCAD3', 1);
set @SITEID = dbo.[UFN_APPUSER_DEFAULTSITEFORUSER](@CURRENTAPPUSERID);
return 0;