USP_DATAFORMTEMPLATE_EDITLOAD_MKTSEGMENTATIONEXPORT_4

The load procedure used by the edit dataform template "Marketing Effort Export Edit Form 4"

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.
@SEGMENTATIONID	uniqueidentifier	INOUT	Marketing effort
@DESCRIPTION	nvarchar(255)	INOUT	Description
@MAILINGTYPECODE	tinyint	INOUT	Type
@EXPORTDEFINITIONRECORDTYPE	nvarchar(50)	INOUT	Export definition record type
@EXPORTDEFINITIONRECORDTYPEID	uniqueidentifier	INOUT	Export definition record type ID
@EXPORTDEFINITIONQUERYVIEWID	uniqueidentifier	INOUT	Export definition query view ID
@MAILEXPORTDEFINITIONID	uniqueidentifier	INOUT	Mail export definition
@EMAILEXPORTDEFINITIONID	uniqueidentifier	INOUT	Email export definition
@PHONEEXPORTDEFINITIONID	uniqueidentifier	INOUT	Phone export definition
@HASMAILPACKAGES	bit	INOUT	Has mail packages?
@HASEMAILPACKAGES	bit	INOUT	Has email packages?
@HASPHONEPACKAGES	bit	INOUT	Has phone packages?
@HASUNDEFINEDMAILPACKAGES	bit	INOUT	Has undefined mail packages?
@HASUNDEFINEDEMAILPACKAGES	bit	INOUT	Has undefined email packages?
@HASUNDEFINEDPHONEPACKAGES	bit	INOUT	Has undefined phone packages?
@HASDEFINEDPACKAGES	bit	INOUT	Has defined packages?
@DEFINEDPACKAGES	xml	INOUT	Defined packages
@ORGANIZATIONCURRENCYID	uniqueidentifier	INOUT	Organization currency 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.
@EXPORTACTIVESEGMENTS	bit	INOUT	Export active segments
@EXPORTINLINEEXCLUSIONS	bit	INOUT	Export exclusion segments
@INLINEEXCLUSIONEXPORTDEFINITIONID	uniqueidentifier	INOUT	Export definition
@HASEXCLUDEDRECORDS	bit	INOUT	Has excluded records?

Definition

Copy


CREATE procedure dbo.[USP_DATAFORMTEMPLATE_EDITLOAD_MKTSEGMENTATIONEXPORT_4]
(
  @ID uniqueidentifier,
  @DATALOADED bit = 0 output,
  @SEGMENTATIONID uniqueidentifier = null output,
  @DESCRIPTION nvarchar(255) = null output,
  @MAILINGTYPECODE tinyint = null output,
  @EXPORTDEFINITIONRECORDTYPE nvarchar(50) = null output,
  @EXPORTDEFINITIONRECORDTYPEID uniqueidentifier = null output,
  @EXPORTDEFINITIONQUERYVIEWID uniqueidentifier = null output,
  @MAILEXPORTDEFINITIONID uniqueidentifier = null output,
  @EMAILEXPORTDEFINITIONID uniqueidentifier = null output,
  @PHONEEXPORTDEFINITIONID uniqueidentifier = null output,
  @HASMAILPACKAGES bit = null output,
  @HASEMAILPACKAGES bit = null output,
  @HASPHONEPACKAGES bit = null output,
  @HASUNDEFINEDMAILPACKAGES bit = null output,
  @HASUNDEFINEDEMAILPACKAGES bit = null output,
  @HASUNDEFINEDPHONEPACKAGES bit = null output,
  @HASDEFINEDPACKAGES bit = null output,
  @DEFINEDPACKAGES xml = null output,
  @ORGANIZATIONCURRENCYID uniqueidentifier = null output,
  @TSLONG bigint = 0 output,
  @EXPORTACTIVESEGMENTS bit = null output,
  @EXPORTINLINEEXCLUSIONS bit = null output,
  @INLINEEXCLUSIONEXPORTDEFINITIONID uniqueidentifier = null output,
  @HASEXCLUDEDRECORDS bit = null output
)
as
  set nocount on;

  exec dbo.[USP_DATAFORMTEMPLATE_EDITLOAD_MKTSEGMENTATIONEXPORTPROCESS_4]
    @ID,
    @DATALOADED output,
    @SEGMENTATIONID output,
    @DESCRIPTION output,
    @MAILINGTYPECODE output,
    @EXPORTDEFINITIONRECORDTYPE output,
    @EXPORTDEFINITIONRECORDTYPEID output,
    @EXPORTDEFINITIONQUERYVIEWID output,
    @MAILEXPORTDEFINITIONID output,
    @EMAILEXPORTDEFINITIONID output,
    @PHONEEXPORTDEFINITIONID output,
    @HASMAILPACKAGES output,
    @HASEMAILPACKAGES output,
    @HASPHONEPACKAGES output,
    @HASUNDEFINEDMAILPACKAGES output,
    @HASUNDEFINEDEMAILPACKAGES output,
    @HASUNDEFINEDPHONEPACKAGES output,
    @HASDEFINEDPACKAGES output,
    @DEFINEDPACKAGES output,
    @ORGANIZATIONCURRENCYID output,
    @TSLONG output,
    @EXPORTACTIVESEGMENTS output,
    @EXPORTINLINEEXCLUSIONS output,
    @INLINEEXCLUSIONEXPORTDEFINITIONID output,
    @HASEXCLUDEDRECORDS output;

  return 0;