USP_DATAFORMTEMPLATE_EDITLOAD_MKTMEMBERSHIPMAILINGTEMPLATESEED_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_MKTMEMBERSHIPMAILINGTEMPLATESEED_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.[MKTMEMBERSHIPMAILINGTEMPLATE]
  where [ID] = @ID;

  exec @SEEDS = dbo.[UFN_MKTMEMBERSHIPMAILINGTEMPLATESEED_GETSEEDS_2_TOITEMLISTXML] @ID, @CURRENTAPPUSERID, 0, '6A550217-C092-4260-B90D-4D2E2CE20489', 1;

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

  return 0;