3355: , p_Project_IDS IN VARCHAR2 DEFAULT NULL
3356: , p_Expenditure_Category IN VARCHAR2 DEFAULT NULL
3357: , p_Expenditure_Type IN VARCHAR2 DEFAULT NULL
3358: , p_Work_Type IN VARCHAR2 DEFAULT NULL
3359: ) RETURN PJI_REP_PC9_TBL
3360: IS
3361:
3362: PRAGMA AUTONOMOUS_TRANSACTION;
3363:
3363:
3364: /*
3365: ** PL/SQL Declaration
3366: */
3367: l_detail_tab PJI_REP_PC9_TBL := PJI_REP_PC9_TBL();
3368:
3369: l_Cost NUMBER := 0;
3370: l_Capital_Cost NUMBER := 0;
3371: l_Cap_Cost_Percent_Of_Cost NUMBER := 0;