USP_DATAFORMTEMPLATE_VIEW_BATCHCOMMITPARAMETERS

The load procedure used by the view dataform template "Batch Commit Parameters View Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@BATCHNUMBER	nvarchar(100)	INOUT	Batch number
@CREATEOUTPUTIDSET	bit	INOUT	Create output selection
@OUTPUTIDSETNAME	nvarchar(100)	INOUT	Output selection name
@OVERWRITEOUTPUTIDSET	bit	INOUT	Overwrite existing selection
@CREATEEXCEPTIONBATCH	bit	INOUT	Create exception batch
@EXCEPTIONBATCHNAME	nvarchar(100)	INOUT	Exception batch number
@PURGEBATCH	bit	INOUT	Delete batch after committing
@BUSINESSPROCESSCATALOGID	uniqueidentifier	INOUT	BUSINESSPROCESSCATALOGID
@CREATECONTROLREPORT	tinyint	INOUT	Create control report
@STATUSCODE	tinyint	INOUT	Status code
@PARAMETERSID	uniqueidentifier	INOUT	PARAMETERSID
@CONTROLREPORTVISIBLE	tinyint	INOUT	CONTROLREPORTVISIBLE
@EXCEPTIONREPORTVISIBLE	tinyint	INOUT	EXCEPTIONREPORTVISIBLE
@VALIDATEBATCH	bit	INOUT	Validate batch before committing
@CHECKFORDUPLICATERECORDS	bit	INOUT	Check for duplicate constituents
@BATCHSUPPORTSCHECKINGFORDUPLICATERECORDS	bit	INOUT	Batch supports checking for duplicate records

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_BATCHCOMMITPARAMETERS
    (
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,                
    @BATCHNUMBER nvarchar(100) = null output,
    @CREATEOUTPUTIDSET bit = null output,                
    @OUTPUTIDSETNAME nvarchar(100) = null output, 
    @OVERWRITEOUTPUTIDSET bit = null output,
    @CREATEEXCEPTIONBATCH bit = null output,
    @EXCEPTIONBATCHNAME nvarchar(100) = null output,                        
    @PURGEBATCH bit = null output,
    @BUSINESSPROCESSCATALOGID uniqueidentifier = null output,
    @CREATECONTROLREPORT tinyint = null output,
    @STATUSCODE tinyint = null output,
    @PARAMETERSID uniqueidentifier = null output,
    @CONTROLREPORTVISIBLE tinyint = null output,
    @EXCEPTIONREPORTVISIBLE tinyint = null output,
    @VALIDATEBATCH bit = null output,
    @CHECKFORDUPLICATERECORDS bit = null output,
    @BATCHSUPPORTSCHECKINGFORDUPLICATERECORDS bit = null output
    )
as

    set nocount on;

    set @DATALOADED = 0;                

    select
        @DATALOADED = 1,
        @BATCHNUMBER = [BATCH].[BATCHNUMBER],
        @CREATEOUTPUTIDSET = [BATCH].[CREATEOUTPUTIDSET],
        @OUTPUTIDSETNAME = [BATCH].[OUTPUTIDSETNAME],
        @OVERWRITEOUTPUTIDSET = [BATCH].[OVERWRITEOUTPUTIDSET],
        @CREATEEXCEPTIONBATCH = [BATCH].[CREATEEXCEPTIONBATCH],
        @EXCEPTIONBATCHNAME = [BATCH].[EXCEPTIONBATCHNAME],
        @PURGEBATCH = [BATCH].[PURGEBATCH],
        @BUSINESSPROCESSCATALOGID = '2D0785F5-BF9F-4e1f-81CF-D2E5FC01DC85',
        @STATUSCODE=[BATCH].[STATUSCODE],
        @CREATECONTROLREPORT=[BATCH].[CREATECONTROLREPORT],                    
        @VALIDATEBATCH = [BATCH].[VALIDATEBATCH],
        @CHECKFORDUPLICATERECORDS = [BATCH].[CHECKFORDUPLICATERECORDS],
        @PARAMETERSID = @ID                    
    from
        dbo.[BATCH]                    
    where
        [BATCH].[ID] = @ID;

    declare @CONTROLREPORTID uniqueidentifier;
    declare @EXCEPTIONREPORTID uniqueidentifier;
    select
        @CONTROLREPORTID=CONTROLREPORTREPORTSPECID,
        @EXCEPTIONREPORTID=EXCEPTIONREPORTREPORTSPECID,
        @BATCHSUPPORTSCHECKINGFORDUPLICATERECORDS = case when dbo.UFN_GLOBALDUPLICATESEARCH_ISENABLED() = 1 and SPECXML.exist('declare namespace bbspec="bb_appfx_batchtype";
            /bbspec:BatchTypeSpec/bbspec:DuplicateRecordCheck
        ') = 1 then 1 else 0 end
    from dbo.BATCH left join dbo.BATCHTEMPLATE on BATCH.BATCHTEMPLATEID = BATCHTEMPLATE.ID
    left join dbo.BATCHTYPECATALOG on BATCHTYPECATALOG.ID = BATCHTEMPLATE.BATCHTYPECATALOGID
    where BATCH.ID = @ID
        if exists (select 1 from dbo.BUSINESSPROCESSOUTPUT inner join dbo.BATCHSTATUS on BATCHSTATUS.PARAMETERSETID = @ID and BUSINESSPROCESSOUTPUT.BUSINESSPROCESSSTATUSID = BATCHSTATUS.ID and BUSINESSPROCESSOUTPUT.TABLEKEY = 'CONTROL') and @STATUSCODE > 0 and len(@CONTROLREPORTID) > 0
          set @CONTROLREPORTVISIBLE = 1;
    else
        set @CONTROLREPORTVISIBLE = 0;

    if exists (select 1 from dbo.BUSINESSPROCESSOUTPUT inner join dbo.BATCHSTATUS on BATCHSTATUS.PARAMETERSETID = @ID and BUSINESSPROCESSOUTPUT.BUSINESSPROCESSSTATUSID = BATCHSTATUS.ID and BUSINESSPROCESSOUTPUT.TABLEKEY = 'EXCEPTION') and @STATUSCODE > 0 and len(@EXCEPTIONREPORTID) > 0
        set @EXCEPTIONREPORTVISIBLE = 1;
    else
        set @EXCEPTIONREPORTVISIBLE = 0;                

    return 0;