USP_DATAFORMTEMPLATE_EDITLOAD_MKTMARKETINGPLANBRIEFASSUMPTIONS

The load procedure used by the edit dataform template "Marketing Plan Segment Summary Assumptions Edit Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@MARKETINGPLANITEMID	uniqueidentifier	INOUT	Marketing plan item ID
@SOURCECODEID	uniqueidentifier	INOUT	Source code ID
@PACKAGEID	uniqueidentifier	INOUT	Package
@PACKAGECODE	nvarchar(10)	INOUT	Package code
@UNITCOST	money	INOUT	Cost
@BUDGETAMOUNT	money	INOUT	Budget amount
@TOTALREVENUEGOAL	money	INOUT	Revenue
@QUANTITY	int	INOUT	Quantity
@RESPONSERATEGOAL	decimal(20, 2)	INOUT	Response rate
@TOTALTRANSACTIONSGOAL	int	INOUT	Responses
@AVERAGEREVENUEGOAL	money	INOUT	Average amount
@MARKETINGPLANSITEID	uniqueidentifier	INOUT	Marketing plan site ID
@TSLONG	bigint	INOUT	Output parameter indicating the TSLONG value of the record being edited. This is used to manage multi-user concurrency issues when multiple users access the same record.
@BASECURRENCYID	uniqueidentifier	INOUT	Base currency ID
@PACKAGECOST	money	INOUT	Package cost
@PACKAGEADDDATAFORMCONTEXT	nvarchar(128)	INOUT	Package add data form context
@PACKAGECOSTDISTRIBUTIONMETHODCODE	tinyint	INOUT

Definition

Copy



CREATE procedure dbo.[USP_DATAFORMTEMPLATE_EDITLOAD_MKTMARKETINGPLANBRIEFASSUMPTIONS]
(
  @ID uniqueidentifier,
  @DATALOADED bit = 0 output,
  @MARKETINGPLANITEMID uniqueidentifier = null output,
  @SOURCECODEID uniqueidentifier = null output,
  @PACKAGEID uniqueidentifier = null output,
  @PACKAGECODE nvarchar(10) = null output,
  @UNITCOST money = null output,
  @BUDGETAMOUNT money = null output,
  @TOTALREVENUEGOAL money = null output,
  @QUANTITY int = null output,
  @RESPONSERATEGOAL decimal(20,2) = null output,
  @TOTALTRANSACTIONSGOAL int = null output,
  @AVERAGEREVENUEGOAL money = null output,
  @MARKETINGPLANSITEID uniqueidentifier = null output,
  @TSLONG bigint = 0 output,
  @BASECURRENCYID uniqueidentifier = null output,
  @PACKAGECOST money = null output,
  @PACKAGEADDDATAFORMCONTEXT nvarchar(128) = null output,
  @PACKAGECOSTDISTRIBUTIONMETHODCODE tinyint = null output
)
as
  set nocount on;

  set @DATALOADED = 0;
  set @TSLONG = 0;

  select
    @DATALOADED = 1,
    @MARKETINGPLANITEMID = [MPB].[MARKETINGPLANITEMID],
    @SOURCECODEID = [MPI].[SOURCECODEID],
    @PACKAGEID = [MPB].[PACKAGEID],
    @PACKAGECODE = isnull([P].[CODE], ''),
    @PACKAGECOST = isnull([P].[UNITCOST], 0),
    @PACKAGECOSTDISTRIBUTIONMETHODCODE = isnull([P].[COSTDISTRIBUTIONMETHODCODE], 0),
    @PACKAGEADDDATAFORMCONTEXT = '0|' + convert(nvarchar(36), [MPB].[BASECURRENCYID]),
    @BASECURRENCYID = [MPB].[BASECURRENCYID],
    @UNITCOST = [MPB].[UNITCOST],
    @BUDGETAMOUNT = [MPB].[BUDGETAMOUNT],
    @TOTALREVENUEGOAL = [MPB].[TOTALREVENUEGOAL],
    @QUANTITY = [MPB].[QUANTITY],
    @RESPONSERATEGOAL = [MPB].[RESPONSERATEGOAL],
    @TOTALTRANSACTIONSGOAL = [MPB].[TOTALTRANSACTIONSGOAL],
    @AVERAGEREVENUEGOAL = [MPB].[AVERAGEREVENUEGOAL], 
    @MARKETINGPLANSITEID = [MP].[SITEID],
    @TSLONG = [MPB].[TSLONG]
  from dbo.[MKTMARKETINGPLANBRIEF] as [MPB]
  inner join dbo.[MKTMARKETINGPLANITEM] as [MPI] on [MPI].[ID] = [MPB].[MARKETINGPLANITEMID]
  inner join dbo.[MKTMARKETINGPLAN] as [MP] on [MP].[ID] = [MPI].[MARKETINGPLANID]
  left join dbo.[MKTPACKAGE] as [P] on [P].[ID] = [MPB].[PACKAGEID]
  where [MPB].[ID] = @ID;

  return 0;