USP_DATAFORMTEMPLATE_EDITLOAD_MKTACKNOWLEDGEMENTMAILINGTEMPLATESEED_2

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CURRENTAPPUSERID	uniqueidentifier	IN
@DATALOADED	bit	INOUT
@SEEDS	xml	INOUT
@DEFAULTCOUNTRYID	uniqueidentifier	INOUT
@TSLONG	bigint	INOUT

Definition

Copy


create procedure dbo.[USP_DATAFORMTEMPLATE_EDITLOAD_MKTACKNOWLEDGEMENTMAILINGTEMPLATESEED_2]
(
  @ID uniqueidentifier,
  @CURRENTAPPUSERID uniqueidentifier,
  @DATALOADED bit = 0 output,
  @SEEDS xml = null output,
  @DEFAULTCOUNTRYID uniqueidentifier = null output,
  @TSLONG bigint = 0 output
)
as
  set nocount on;

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

  select 
    @DATALOADED = 1
  from dbo.[MKTACKNOWLEDGEMENTMAILINGTEMPLATE]
  where [ID] = @ID;

  exec @SEEDS = dbo.[UFN_MKTACKNOWLEDGEMENTMAILINGTEMPLATESEED_GETSEEDS_2_TOITEMLISTXML] @ID, @CURRENTAPPUSERID, 0, '2C964A33-914E-4AD8-9137-8FB8FA1439CF', 1;

  set @DEFAULTCOUNTRYID = dbo.[UFN_COUNTRY_GETDEFAULT]();

  return 0;