USP_DATAFORMTEMPLATE_ADD_EXPORTPROCESS_FROMSELECTION

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	INOUT
@SELECTIONID	uniqueidentifier	IN
@EXPORTDEFINITIONID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@NAME	nvarchar(255)	IN
@DESCRIPTION	nvarchar(1000)	IN
@CURRENTAPPUSERID	uniqueidentifier	IN
@SITEID	uniqueidentifier	IN

Definition

Copy


CREATE procedure dbo.[USP_DATAFORMTEMPLATE_ADD_EXPORTPROCESS_FROMSELECTION]
(
  @ID uniqueidentifier = null output,
  @SELECTIONID uniqueidentifier,
  @EXPORTDEFINITIONID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier = null,
  @NAME nvarchar(255) = '',
  @DESCRIPTION nvarchar(1000) = '',
  @CURRENTAPPUSERID uniqueidentifier = null,
  @SITEID uniqueidentifier = null
)
with execute as caller
as begin
  set nocount on;

  begin try
    if @SITEID is not null
      if dbo.UFN_SITEALLOWEDFORUSER(@CURRENTAPPUSERID, @SITEID) = 0
        begin
          raiserror ('ERR_SITE_NOACCESS',13,1);
          return 1;
        end

    exec dbo.[USP_EXPORTPROCESS_ADD] @ID output, null, null, @CHANGEAGENTID, @NAME, @DESCRIPTION, @EXPORTDEFINITIONID, @SELECTIONID;

    exec dbo.[USP_BUSINESSPROCESSINSTANCE_ADD]
      @CHANGEAGENTID = @CHANGEAGENTID,
      @BUSINESSPROCESSCATALOGID = '64FAA344-9C75-4C98-AFE3-A40EC2DF9249',
      @BUSINESSPROCESSPARAMETERSETID = @ID,
      @OWNERID = @CURRENTAPPUSERID, @SITEID = @SITEID;
  end try

  begin catch
    exec dbo.USP_RAISE_ERROR;
    return 1;
  end catch

  return 0;
end