USP_DATAFORMTEMPLATE_VIEW_ACCOUNTINGSETUPWORKFLOW

The load procedure used by the view dataform template "Account Setup Workflow View Form"

Parameters

Parameter	Parameter Type	Mode	Description
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@ACCOUNTSTRUCTUREDEFINED	bit	INOUT	ACCOUNTSTRUCTUREDEFINED
@ACCOUNTCATEGORIESDEFINED	bit	INOUT	ACCOUNTCATEGORIESDEFINED
@GLACCOUNTSDEFINED	bit	INOUT	GLACCOUNTSDEFINED
@SEGMENTVALUESDEFINED	bit	INOUT	SEGMENTVALUESDEFINED
@ACCOUNTCODEMAPPINGSDEFINED	bit	INOUT	ACCOUNTCODEMAPPINGSDEFINED
@SEGMENTEXIST	bit	INOUT	SEGMENTEXIST
@CONSTITUENCYUSED	bit	INOUT	CONSTITUENCYUSED
@CONSTITUENCYORDEREXISTS	bit	INOUT	CONSTITUENCYORDEREXISTS

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_ACCOUNTINGSETUPWORKFLOW
(
    @DATALOADED bit = 0 output,
    @ACCOUNTSTRUCTUREDEFINED bit = null output,
    @ACCOUNTCATEGORIESDEFINED bit = null output,
    @GLACCOUNTSDEFINED bit = null output,
    @SEGMENTVALUESDEFINED bit = null output,
    @ACCOUNTCODEMAPPINGSDEFINED bit = null output,
    @SEGMENTEXIST bit = null output,
  @CONSTITUENCYUSED bit = null output,
  @CONSTITUENCYORDEREXISTS bit = null output
)
as
    set nocount on;

    set @ACCOUNTSTRUCTUREDEFINED = dbo.UFN_PDACCOUNTCODE_SETUP();
  if @ACCOUNTSTRUCTUREDEFINED = 1
    set @CONSTITUENCYUSED = dbo.UFN_PDCONSTITUENCYUSED()
  else
    set @CONSTITUENCYUSED = 0

    set @ACCOUNTCATEGORIESDEFINED = dbo.UFN_GLACCOUNT_SETUP();
    set @GLACCOUNTSDEFINED = dbo.UFN_PDACCOUNTSTRUCTURE_ACCOUNTEXISTS();
  if exists (select * from dbo.PDCONSTITUENCYORDER)
    set @CONSTITUENCYORDEREXISTS = 1
   else
    set @CONSTITUENCYORDEREXISTS = 0
    set @SEGMENTVALUESDEFINED = dbo.UFN_PDACCOUNTSEGMENTMAP_SETUP();
    set @ACCOUNTCODEMAPPINGSDEFINED = dbo.UFN_PDACCOUNTCODEMAPPING_SETUP();
    if exists(select * from PDACCOUNTSTRUCTURE where PDACCOUNTSYSTEMID = '4B121C2C-CCE6-440D-894C-EA0DEF80D50B' and SEGMENTTYPE >= 3)
        set @SEGMENTEXIST = 1
    else
        set @SEGMENTEXIST = 0
    -- be sure to set this to signify data was loaded

    set @DATALOADED = -1;

    return 0;