[Home] [Help]
2103: -- Procedure : get_budget_ctrl_options
2104: -- Purpose : To get Budget Control Options for given project id and
2105: -- calling mode.
2106: --Parameters :
2107: -- p_calling_code : STANDARD/COMMITMENT/BUDGET
2108: -- x_fck_req_flag --> Y (Yes), N (No)
2109: -- x_bdgt_intg_flag --> G (GL), ,C ( CC ), N (No)
2110:
2111: -- sqlplus apps/apps@padev115 @PABBFNDB.pls
2130: balance_type,
2131: bdgt_cntrl_flag
2132: FROM PA_BUDGETARY_CONTROL_OPTIONS
2133: WHERE project_id = p_project_id
2134: AND ( ( p_calling_mode = 'STANDARD' AND
2135: ( nvl(external_budget_code,'-1') IN ('GL','-1') ) )
2136: OR
2137: ( p_calling_mode = 'COMMITMENT' AND
2138: ( nvl(external_budget_code,'-1') = 'CC') )
2141: )
2142: AND ( ( p_calling_mode = 'BUDGET' AND
2143: ( nvl(budget_type_code,'-1') = p_budget_type_code ) )
2144: OR
2145: ( p_calling_mode IN ('COMMITMENT','STANDARD') )
2146: )
2147: AND (
2148: ( p_calling_mode = 'STANDARD'
2149: AND ( ( nvl(balance_type,'-1') = 'E' AND
2144: OR
2145: ( p_calling_mode IN ('COMMITMENT','STANDARD') )
2146: )
2147: AND (
2148: ( p_calling_mode = 'STANDARD'
2149: AND ( ( nvl(balance_type,'-1') = 'E' AND
2150: nvl(external_budget_code,'-1') = 'GL' )
2151: OR ( nvl(balance_type,'-1') = '-1' AND
2152: nvl(external_budget_code,'-1') = '-1' ))
2394: --
2395: -- Function : Is_bdgt_intg_enabled
2396: -- Purpose : This functions returns a true/false for a given project_id
2397: -- and mode
2398: -- Parameters : P_mode S-> Standard , C -> Commitment , A -> All
2399: -- p_project_id
2400:
2401: FUNCTION Is_bdgt_intg_enabled (p_project_id IN NUMBER,
2402: p_mode IN VARCHAR2 )