USP_DATAFORMTEMPLATE_EDITLOAD_MKTSPONSORSHIPMAILINGTEMPLATESEED_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_MKTSPONSORSHIPMAILINGTEMPLATESEED_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.[MKTSPONSORSHIPMAILINGTEMPLATE]
  where [ID] = @ID;

  if @DATALOADED = 1
    exec @SEEDS = dbo.[UFN_MKTSPONSORSHIPMAILINGTEMPLATESEED_GETSEEDS_2_TOITEMLISTXML] @ID, @CURRENTAPPUSERID, 0, '0567011A-7E9A-4953-B215-F93CA38363B2', 1;

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

  return 0;