USP_DATAFORMTEMPLATE_PRELOAD_ADD_COMMITMULTIPLEBATCHES2PROCESS

The load procedure used by the edit dataform template "Commit Multiple Batches Process Add Form 2"

Parameters

Parameter	Parameter Type	Mode	Description
@RECORDTYPEID	uniqueidentifier	INOUT
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@SITEID	uniqueidentifier	INOUT	Site

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_PRELOAD_ADD_COMMITMULTIPLEBATCHES2PROCESS
(
  @RECORDTYPEID uniqueidentifier = null output,
  @CURRENTAPPUSERID uniqueidentifier = null,
  @SITEID uniqueidentifier = null output
)
as
    begin            
    set nocount on;

    select 
        @RECORDTYPEID = ID,
        @SITEID = dbo.UFN_APPUSER_DEFAULTSITEFORUSER(@CURRENTAPPUSERID)
    from 
        dbo.RECORDTYPE 
    where 
        upper(NAME) = 'BATCH';

    return 0;
end