APPS.PA_BUDGET_FUND_PKG dependencies on STANDARD

Line 2191: -- p_calling_code : STANDARD/COMMITMENT/BUDGET

2187: -- Procedure : get_budget_ctrl_options
2188: -- Purpose : To get Budget Control Options for given project id and
2189: -- calling mode.
2190: --Parameters :
2191: -- p_calling_code : STANDARD/COMMITMENT/BUDGET
2192: -- x_fck_req_flag --> Y (Yes), N (No)
2193: -- x_bdgt_intg_flag --> G (GL), ,C ( CC ), N (No)
2194:
2195: -- sqlplus apps/apps@padev115 @PABBFNDB.pls

Line 2218: AND ( ( p_calling_mode = 'STANDARD' AND

2214: balance_type,
2215: bdgt_cntrl_flag
2216: FROM PA_BUDGETARY_CONTROL_OPTIONS
2217: WHERE project_id = p_project_id
2218: AND ( ( p_calling_mode = 'STANDARD' AND
2219: ( nvl(external_budget_code,'-1') IN ('GL','-1') ) )
2220: OR
2221: ( p_calling_mode = 'COMMITMENT' AND
2222: ( nvl(external_budget_code,'-1') = 'CC') )

Line 2229: ( p_calling_mode IN ('COMMITMENT','STANDARD') )

2225: )
2226: AND ( ( p_calling_mode = 'BUDGET' AND
2227: ( nvl(budget_type_code,'-1') = p_budget_type_code ) )
2228: OR
2229: ( p_calling_mode IN ('COMMITMENT','STANDARD') )
2230: )
2231: AND (
2232: ( p_calling_mode = 'STANDARD'
2233: AND ( ( nvl(balance_type,'-1') = 'E' AND

Line 2232: ( p_calling_mode = 'STANDARD'

2228: OR
2229: ( p_calling_mode IN ('COMMITMENT','STANDARD') )
2230: )
2231: AND (
2232: ( p_calling_mode = 'STANDARD'
2233: AND ( ( nvl(balance_type,'-1') = 'E' AND
2234: nvl(external_budget_code,'-1') = 'GL' )
2235: OR ( nvl(balance_type,'-1') = '-1' AND
2236: nvl(external_budget_code,'-1') = '-1' ))

Line 2491: -- Parameters : P_mode S-> Standard , C -> Commitment , A -> All

2487: --
2488: -- Function : Is_bdgt_intg_enabled
2489: -- Purpose : This functions returns a true/false for a given project_id
2490: -- and mode
2491: -- Parameters : P_mode S-> Standard , C -> Commitment , A -> All
2492: -- p_project_id
2493:
2494: FUNCTION Is_bdgt_intg_enabled (p_project_id IN NUMBER,
2495: p_mode IN VARCHAR2 )