USP_DATAFORMTEMPLATE_VIEW_MKTPACKAGEDOCUMENT
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN | |
| @DATALOADED | bit | INOUT | |
| @NAME | nvarchar(100) | INOUT | |
| @DESCRIPTION | nvarchar(255) | INOUT | |
| @SITEID | uniqueidentifier | INOUT | |
| @COST | money | INOUT | |
| @COSTDISTRIBUTIONMETHODCODE | tinyint | INOUT | |
| @DOCUMENTTYPECODEID | uniqueidentifier | INOUT | |
| @FILEURL | UDT_WEBADDRESS | INOUT | |
| @FILE | varbinary | INOUT | |
| @FILENAME | nvarchar(255) | INOUT | |
| @BASECURRENCYID | uniqueidentifier | INOUT | |
| @CURRENCY | nvarchar(110) | INOUT | |
| @DOCUMENTTYPE | nvarchar(255) | INOUT | |
| @SITE | nvarchar(1024) | INOUT | |
| @COSTDISTRIBUTIONMETHOD | nvarchar(255) | INOUT |
Definition
Copy
create procedure dbo.[USP_DATAFORMTEMPLATE_VIEW_MKTPACKAGEDOCUMENT]
(
@ID uniqueidentifier,
@DATALOADED bit = 0 output,
@NAME nvarchar(100) = null output,
@DESCRIPTION nvarchar(255) = null output,
@SITEID uniqueidentifier = null output,
@COST money = null output,
@COSTDISTRIBUTIONMETHODCODE tinyint = null output,
@DOCUMENTTYPECODEID uniqueidentifier = null output,
@FILEURL dbo.[UDT_WEBADDRESS] = null output,
@FILE varbinary(max) = null output,
@FILENAME nvarchar(255) = null output,
@BASECURRENCYID uniqueidentifier = null output,
@CURRENCY nvarchar(110) = null output,
@DOCUMENTTYPE nvarchar(255) = null output,
@SITE nvarchar(1024) = null output,
@COSTDISTRIBUTIONMETHOD nvarchar(255) = null output
)
as
set nocount on;
set @DATALOADED = 0;
declare @DOCUMENTID uniqueidentifier;
select
@DATALOADED = 1,
@NAME = [DOCUMENTVIEW].[NAME],
@DESCRIPTION = [DOCUMENTVIEW].[DESCRIPTION],
@SITEID = [DOCUMENTVIEW].[SITEID],
@COST = [DOCUMENTVIEW].[COST],
@COSTDISTRIBUTIONMETHODCODE = [DOCUMENTVIEW].[COSTDISTRIBUTIONMETHODCODE],
@DOCUMENTTYPECODEID = [DOCUMENTVIEW].[DOCUMENTTYPECODEID],
@FILEURL = [DOCUMENTVIEW].[FILEURL],
@FILE = [DOCUMENTVIEW].[FILE],
@FILENAME = [DOCUMENTVIEW].[FILENAME],
@BASECURRENCYID = [DOCUMENTVIEW].[BASECURRENCYID],
@CURRENCY = [DOCUMENTVIEW].[CURRENCY],
@DOCUMENTTYPE = [DOCUMENTVIEW].[DOCUMENTTYPE],
@SITE = [DOCUMENTVIEW].[SITE],
@COSTDISTRIBUTIONMETHOD = [DOCUMENTVIEW].[COSTDISTRIBUTIONMETHOD]
from dbo.[UFN_MKTDOCUMENT_GETVIEW](@ID) as [DOCUMENTVIEW];
return 0;