USP_DATAFORMTEMPLATE_EDITLOAD_MKTCOMMUNICATIONNAMESCHEME

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CURRENTAPPUSERID	uniqueidentifier	IN
@DATALOADED	bit	INOUT
@TSLONG	bigint	INOUT
@NAME	nvarchar(100)	INOUT
@SITEID	uniqueidentifier	INOUT
@NAMEPARTS	xml	INOUT
@SAMPLEAPPEALCODE	nvarchar(100)	INOUT
@SAMPLESITENAME	nvarchar(250)	INOUT
@ISACTIVE	bit	INOUT

Definition

Copy



CREATE procedure dbo.[USP_DATAFORMTEMPLATE_EDITLOAD_MKTCOMMUNICATIONNAMESCHEME]
(
  @ID uniqueidentifier,
  @CURRENTAPPUSERID uniqueidentifier,
  @DATALOADED bit = 0 output,
  @TSLONG bigint = 0 output,
  @NAME nvarchar(100) = null output,
  @SITEID uniqueidentifier = null output,
  @NAMEPARTS xml = null output,
  @SAMPLEAPPEALCODE nvarchar(100) = null output,
  @SAMPLESITENAME nvarchar(250) = null output,
  @ISACTIVE bit = null output
)
as
  set nocount on;

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

  set @NAMEPARTS = dbo.[UFN_MKTCOMMUNICATIONNAMESCHEME_GETNAMEPARTS_TOITEMLISTXML](@ID);

  select
    @DATALOADED = 1,
    @TSLONG = [TSLONG],
    @NAME = [NAME],
    @SITEID = [SITEID],
    @ISACTIVE = [ISACTIVE]
  from dbo.[MKTCOMMUNICATIONNAMESCHEME]
  where [ID] = @ID;

  if @DATALOADED = 1
    begin

      exec dbo.[USP_MKTCOMMUNICATIONNAMESCHEME_GETPARTSAMPLES]
        @APPEALCODE = @SAMPLEAPPEALCODE output,
        @SITENAME = @SAMPLESITENAME output;

    end

  return 0;