USP_DATAFORMTEMPLATE_EDITLOAD_MKTSEGMENTATIONSEED_2

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

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

  select 
    @DATALOADED = 1,
    @SEGMENTATIONACTIVE = [ACTIVE]
  from dbo.[MKTSEGMENTATION]
  where [ID] = @ID;

  if @DATALOADED = 1 and @SEGMENTATIONACTIVE = 0
    begin
      declare @R int;
      exec @R = dbo.[USP_MKTSEGMENTATION_CHECKACTIVATION] @ID;
      if @R <> 0
        begin
          set @DATALOADED = 0;
          return 1;
        end
    end

  exec @SEEDS = dbo.[UFN_MKTSEGMENTATIONSEED_GETSEEDS_2_TOITEMLISTXML] @ID, @CURRENTAPPUSERID, 0, '10D455C6-7430-472A-BB7C-96E75B77C7C0', 1;

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

  return 0;