USP_DATAFORMTEMPLATE_EDITLOAD_APPEALMAILINGREVENUECALCULATOR

The load procedure used by the edit dataform template "Appeal Mailing Revenue Calculator Edit Data 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.
@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.
@LETTERCHANNELINSTANCES	xml	INOUT
@BUDGETAMOUNT	money	INOUT	Budget
@ESTIMATEDRESPONSERATE	decimal(5, 2)	INOUT	Estimated response rate
@ESTIMATEDAVERAGEGIFTAMOUNT	money	INOUT	Estimated average gift amount
@PREVIOUSYEARAVERAGES	xml	INOUT	Previous years' averages from this appeal
@ESTIMATEDNETREVENUE	money	INOUT	Estimated net revenue
@ACTIVE	bit	INOUT	Active
@UPDATECOUNTPARAMETERSETID	uniqueidentifier	INOUT
@BASECURRENCYID	uniqueidentifier	INOUT

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_APPEALMAILINGREVENUECALCULATOR
(
  @ID uniqueidentifier,
  @DATALOADED bit = 0 output,
  @TSLONG bigint = 0 output,
  @LETTERCHANNELINSTANCES xml = null output,
  @BUDGETAMOUNT money = null output,
  @ESTIMATEDRESPONSERATE decimal(5,2) = null output,
  @ESTIMATEDAVERAGEGIFTAMOUNT money = null output,
  @PREVIOUSYEARAVERAGES xml = null output,
  @ESTIMATEDNETREVENUE money = null output,
  @ACTIVE bit = null output,
  @UPDATECOUNTPARAMETERSETID uniqueidentifier = null output,
  @BASECURRENCYID uniqueidentifier = null output
)
as
  begin
    set nocount on;

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

    set @LETTERCHANNELINSTANCES = dbo.UFN_APPEALMAILING_GETLETTERCHANNELINSTANCES_TOITEMLISTXML(@ID);
    set @PREVIOUSYEARAVERAGES = dbo.UFN_APPEALMAILING_PREVIOUSYEARAVERAGES_TOITEMLISTXML(@ID);

    select 
      @DATALOADED = 1,
      @TSLONG = [APPEALMAILING].[TSLONG],
      @BUDGETAMOUNT = [MKTSEGMENTATIONBUDGET].[BUDGETAMOUNT],
      @ESTIMATEDAVERAGEGIFTAMOUNT = [APPEALMAILINGSETUP].[ESTIMATEDAVERAGEGIFTAMOUNT],
      @ESTIMATEDRESPONSERATE = [APPEALMAILINGSETUP].[ESTIMATEDRESPONSERATE],
      @ACTIVE = [MKTSEGMENTATION].[ACTIVE],
      @UPDATECOUNTPARAMETERSETID = [MKTSEGMENTATIONSEGMENTCALCULATEPROCESS].[ID],
      @BASECURRENCYID = [MKTSEGMENTATIONBUDGET].[BASECURRENCYID]
    from dbo.[APPEALMAILINGSETUP]
    inner join dbo.[APPEALMAILING] on [APPEALMAILING].[ID] = [APPEALMAILINGSETUP].[ID]
    inner join dbo.[MKTSEGMENTATION] on [APPEALMAILINGSETUP].[ID] = [MKTSEGMENTATION].[ID]
    inner join dbo.[MKTSEGMENTATIONBUDGET] on [MKTSEGMENTATIONBUDGET].[ID] = [APPEALMAILING].[ID]
    inner join dbo.[MKTSEGMENTATIONSEGMENTCALCULATEPROCESS] on [MKTSEGMENTATION].[ID] = [MKTSEGMENTATIONSEGMENTCALCULATEPROCESS].[SEGMENTATIONID]
    where [APPEALMAILINGSETUP].[ID] = @ID;
  end