USP_DATAFORMTEMPLATE_VIEW_ACCOUNTINGSETUPWORKFLOW2

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

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.
@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
@SYSTEMNAME	nvarchar(50)	INOUT	SYSTEMNAME
@FISCALYEAREXIST	bit	INOUT	FISCALYEAREXIST
@ISBASICPROGRAMS	bit	INOUT	ISBASICPROGRAMS
@ALLOWGLDISTRIBUTIONS	bit	INOUT	ALLOWGLDISTRIBUTIONS
@HASERRORMESSAGES	bit	INOUT	HASERRORMESSAGES
@DESIGNATIONISPROJECT	bit	INOUT
@FENXT	bit	INOUT

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_ACCOUNTINGSETUPWORKFLOW2
(
    @ID uniqueidentifier, 
    @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,
    @SYSTEMNAME nvarchar(50) = null output,
    @FISCALYEAREXIST bit = null output,
    @ISBASICPROGRAMS bit = null output,
    @ALLOWGLDISTRIBUTIONS bit = null output,
    @HASERRORMESSAGES bit = null output,
    @DESIGNATIONISPROJECT bit = null output,
    @FENXT bit = null output
)
as
    set nocount on;

    if exists (select  ID from    dbo.PDACCOUNTSTRUCTURE where PDACCOUNTSYSTEMID = @ID  and SEGMENTTYPE = 1 and length = 0 )
        set @ACCOUNTSTRUCTUREDEFINED = 0
    else

    set @ACCOUNTSTRUCTUREDEFINED = 1
    --set @ACCOUNTSTRUCTUREDEFINED = dbo.UFN_PDACCOUNTCODE_SETUP();


    if @ACCOUNTSTRUCTUREDEFINED = 1
    begin
    --set @CONSTITUENCYUSED = dbo.UFN_PDCONSTITUENCYUSED()

        if exists (select * from dbo.PDACCOUNTSTRUCTURE where PDACCOUNTSYSTEMID = @ID and PDACCOUNTTABLESAVAILABLEFORSEGMENTID = 'DF02810D-D5AF-4772-B112-75BB225ED0A2')
            set @CONSTITUENCYUSED = 1
        else
        begin
            if exists (select * from dbo.PDCOMPOSITESEGMENTTABLELIST inner join dbo.PDACCOUNTSTRUCTURE on PDCOMPOSITESEGMENTTABLELIST.PDCOMPOSITESEGMENTID = PDACCOUNTSTRUCTURE.PDACCOUNTTABLESAVAILABLEFORSEGMENTID where PDCOMPOSITESEGMENTTABLELIST.PDACCOUNTTABLESAVAILABLEFORSEGMENTID = 'DF02810D-D5AF-4772-B112-75BB225ED0A2' and PDACCOUNTSTRUCTURE.SEGMENTTYPE = 4 and PDACCOUNTSTRUCTURE.PDACCOUNTSYSTEMID = @ID)
                set @CONSTITUENCYUSED = 1
            else
                set @CONSTITUENCYUSED = 0
        end
    end 
    else
        set @CONSTITUENCYUSED = 0

    --set @ACCOUNTCATEGORIESDEFINED = dbo.UFN_GLACCOUNT_SETUP();

    --set @GLACCOUNTSDEFINED = dbo.UFN_PDACCOUNTSTRUCTURE_ACCOUNTEXISTS();

    if exists (select * from dbo.GLACCOUNT where PDACCOUNTSYSTEMID = @ID)
        set @GLACCOUNTSDEFINED = 1
    else
        set @GLACCOUNTSDEFINED = 0

    if exists (select * from dbo.PDCONSTITUENCYORDER)
        set @CONSTITUENCYORDEREXISTS = 1
    else
        set @CONSTITUENCYORDEREXISTS = 0

    set @SEGMENTVALUESDEFINED = dbo.UFN_PDACCOUNTSEGMENTMAP_SETUP2(@ID);
    set @ACCOUNTCODEMAPPINGSDEFINED = dbo.UFN_PDACCOUNTCODEMAPPING_SETUP2(@ID);
    if exists(select * from dbo.PDACCOUNTSTRUCTURE where SEGMENTTYPE >= 3 and PDACCOUNTSYSTEMID = @ID)
        set @SEGMENTEXIST = 1
    else
        set @SEGMENTEXIST = 0

    if exists (select * from dbo.GLFISCALYEAR)
        set @FISCALYEAREXIST = 1
    else
        set @FISCALYEAREXIST = 0

    select @ALLOWGLDISTRIBUTIONS = ALLOWGLDISTRIBUTIONS from    dbo.PDACCOUNTSYSTEM where ID = @ID

    -- be sure to set this to signify data was loaded

    set @DATALOADED = -1;

    --if dbo.UFN_INSTALLEDPRODUCTS_PRODUCTIS('133F9BCA-00F1-4007-9792-586B931340C6') = 1


    select @SYSTEMNAME = NAME 
    from dbo.PDACCOUNTSYSTEM 
    where ID = @ID

    select @ISBASICPROGRAMS = dbo.UFN_INSTALLEDPRODUCTS_PRODUCTIS('bb1c17bc-9e0b-4683-b490-ee40d511fa05')

    if exists(select 1 from dbo.PDACCOUNTSYSTEM where ID = @ID and DEFAULTGLACCOUNTID is not null)
        set @HASERRORMESSAGES = 1
    else
        set @HASERRORMESSAGES = CASE WHEN dbo.UFN_COUNT_UNMAPPEDTRANSACTIONERRORS(@ID) > 0 THEN 1 ELSE 0 END;

    --else

    --  set @SYSTEMNAME = 'General Ledger System'


    if exists (select 1 from dbo.PDACCOUNTSTRUCTURE where PDACCOUNTSYSTEMID = @ID and ISPROJECTSEGMENT = 1 and PDACCOUNTTABLESAVAILABLEFORSEGMENTID= '2B1E041E-8FA3-4301-A5DB-E6531E9C3CED')
        set @DESIGNATIONISPROJECT = 1;
    else
        set @DESIGNATIONISPROJECT = 0;

    if exists (select 1 from dbo.FENXTINTEGRATION where PDACCOUNTSYSTEMID = @ID)
        set @FENXT = 1;
    else
        set @FENXT = 0;

    return 0;