USP_GETTASKSTATUS_GENERALLEDGER_DEFAULTACCOUNT

create procedure dbo.USP_GETTASKSTATUS_GENERALLEDGER_DEFAULTACCOUNT
(
    @STATUS tinyint = null output, 
    @DESCRIPTION nvarchar(max) = null output,
    @CURRENTAPPUSERID uniqueidentifier
)
as begin

declare @ACCOUNTID uniqueidentifier = '4B121C2C-CCE6-440D-894C-EA0DEF80D50B'
        , @ACCOUNTSTRUCTUREDEFINED bit
        , @GLACCOUNTSDEFINED bit
        , @SEGMENTVALUESDEFINED bit
        , @ACCOUNTCODEMAPPINGSDEFINED bit
        , @SEGMENTEXIST bit
        , @CONSTITUENCYUSED bit
        , @CONSTITUENCYORDEREXISTS bit
        , @FISCALYEAREXIST bit

exec dbo.USP_DATAFORMTEMPLATE_VIEW_ACCOUNTINGSETUPWORKFLOW2 
    @ID = @ACCOUNTID
    , @ACCOUNTSTRUCTUREDEFINED = @ACCOUNTSTRUCTUREDEFINED output
    , @GLACCOUNTSDEFINED = @GLACCOUNTSDEFINED output
    , @SEGMENTVALUESDEFINED = @SEGMENTVALUESDEFINED output
    , @ACCOUNTCODEMAPPINGSDEFINED = @ACCOUNTCODEMAPPINGSDEFINED output
    , @SEGMENTEXIST = @SEGMENTEXIST output
    , @CONSTITUENCYUSED = @CONSTITUENCYUSED output
    , @CONSTITUENCYORDEREXISTS = @CONSTITUENCYORDEREXISTS output
    , @FISCALYEAREXIST = @FISCALYEAREXIST output

if (@FISCALYEAREXIST=1
    and @ACCOUNTSTRUCTUREDEFINED=1 
    and (@CONSTITUENCYUSED=0 or @CONSTITUENCYORDEREXISTS=1)
    and @GLACCOUNTSDEFINED=1 
    and (@SEGMENTEXIST=0 or @SEGMENTVALUESDEFINED=1)
    and @ACCOUNTCODEMAPPINGSDEFINED=1)
        set @STATUS = 2;
else if (@FISCALYEAREXIST=1
    or @ACCOUNTSTRUCTUREDEFINED=1 
    or (@CONSTITUENCYUSED=1 and @CONSTITUENCYORDEREXISTS=1)
    or @GLACCOUNTSDEFINED=1 
    or (@SEGMENTEXIST=1 and @SEGMENTVALUESDEFINED=1)
    or @ACCOUNTCODEMAPPINGSDEFINED=1)
        set @STATUS = 1;
else if @STATUS is null
        set @STATUS = 0;

end