eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PJI_PMV_CAPITAL_COST dependencies on PJI_REP_PC9

Line 172: PROCEDURE GET_SQL_PJI_REP_PC9(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL

168: ** Projects Capital Cost Detail Report
169: */
170:
171:
172: PROCEDURE GET_SQL_PJI_REP_PC9(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
173: , x_PMV_Sql OUT NOCOPY VARCHAR2
174: , x_PMV_Output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
175: IS
176: l_Err_Message VARCHAR2(3200);

Line 201: , p_Region_Code => 'PJI_REP_PC9'

197: , FACT.PJI_REP_TOTAL_3 "PJI_REP_TOTAL_3"
198: , FACT.PJI_REP_TOTAL_4 "PJI_REP_TOTAL_4"'
199: , P_SQL_STATEMENT => x_PMV_Sql
200: , P_PMV_OUTPUT => x_PMV_Output
201: , p_Region_Code => 'PJI_REP_PC9'
202: , p_PLSQL_Driver => 'PJI_PMV_CAPITAL_COST.PLSQLDriver_PJI_REP_PC9'
203: , p_PLSQL_Driver_Params => ' <>'||
204: ', <>'||
205: ', <>'||

Line 202: , p_PLSQL_Driver => 'PJI_PMV_CAPITAL_COST.PLSQLDriver_PJI_REP_PC9'

198: , FACT.PJI_REP_TOTAL_4 "PJI_REP_TOTAL_4"'
199: , P_SQL_STATEMENT => x_PMV_Sql
200: , P_PMV_OUTPUT => x_PMV_Output
201: , p_Region_Code => 'PJI_REP_PC9'
202: , p_PLSQL_Driver => 'PJI_PMV_CAPITAL_COST.PLSQLDriver_PJI_REP_PC9'
203: , p_PLSQL_Driver_Params => ' <>'||
204: ', <>'||
205: ', <>'||
206: ', <>'||

Line 216: END GET_SQL_PJI_REP_PC9;

212: ', <> '||
213: ', <> '||
214: ', <> '
215: );
216: END GET_SQL_PJI_REP_PC9;
217:
218:
219: /* -------------------------------------------------------------+
220: ** -- PLSQL DRIVERS

Line 3346: FUNCTION PLSQLDriver_PJI_REP_PC9(

3342: ** Projects Capital Cost Detail Report
3343: */
3344:
3345:
3346: FUNCTION PLSQLDriver_PJI_REP_PC9(
3347: p_Operating_Unit IN VARCHAR2 DEFAULT NULL
3348: , p_Organization IN VARCHAR2
3349: , p_Currency_Type IN VARCHAR2
3350: , p_As_of_Date IN NUMBER

Line 3359: ) RETURN PJI_REP_PC9_TBL

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:

Line 3367: l_detail_tab PJI_REP_PC9_TBL := PJI_REP_PC9_TBL();

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;

Line 3491: SELECT PJI_REP_PC9 (PROJECT_ID

3487: IF (l_Convert_Classification = 'N')
3488: and (l_Convert_Expenditure_Type = 'N')
3489: and (l_Convert_Work_Type = 'N')
3490: THEN
3491: SELECT PJI_REP_PC9 (PROJECT_ID
3492: , NULL
3493: , NULL
3494: , PJI_PMV_UTIL.Drill_To_Proj_Perf_URL(PROJECT_ID, l_curr_record_type_id, p_As_of_Date,p_Period_Type)
3495: , NULL

Line 3543: SELECT PJI_REP_PC9 (PROJECT_ID

3539: ELSIF (l_Convert_Classification = 'Y')
3540: and (l_Convert_Expenditure_Type = 'N')
3541: and (l_Convert_Work_Type = 'N')
3542: THEN
3543: SELECT PJI_REP_PC9 (PROJECT_ID
3544: , NULL
3545: , NULL
3546: , PJI_PMV_UTIL.Drill_To_Proj_Perf_URL(PROJECT_ID, l_curr_record_type_id, p_As_of_Date,p_Period_Type)
3547: , NULL

Line 3597: SELECT PJI_REP_PC9 (PROJECT_ID

3593: ELSIF (l_Convert_Classification = 'N')
3594: and (l_Convert_Expenditure_Type = 'Y')
3595: and (l_Convert_Work_Type = 'N')
3596: THEN
3597: SELECT PJI_REP_PC9 (PROJECT_ID
3598: , NULL
3599: , NULL
3600: , PJI_PMV_UTIL.Drill_To_Proj_Perf_URL(PROJECT_ID, l_curr_record_type_id, p_As_of_Date,p_Period_Type)
3601: , NULL

Line 3653: SELECT PJI_REP_PC9 (PROJECT_ID

3649: ELSIF (l_Convert_Classification = 'N')
3650: and (l_Convert_Expenditure_Type = 'N')
3651: and (l_Convert_Work_Type = 'Y')
3652: THEN
3653: SELECT PJI_REP_PC9 (PROJECT_ID
3654: , NULL
3655: , NULL
3656: , PJI_PMV_UTIL.Drill_To_Proj_Perf_URL(PROJECT_ID, l_curr_record_type_id, p_As_of_Date,p_Period_Type)
3657: , NULL

Line 3709: SELECT PJI_REP_PC9 (PROJECT_ID

3705: ELSIF (l_Convert_Classification = 'Y')
3706: and (l_Convert_Expenditure_Type = 'Y')
3707: and (l_Convert_Work_Type = 'N')
3708: THEN
3709: SELECT PJI_REP_PC9 (PROJECT_ID
3710: , NULL
3711: , NULL
3712: , PJI_PMV_UTIL.Drill_To_Proj_Perf_URL(PROJECT_ID, l_curr_record_type_id, p_As_of_Date,p_Period_Type)
3713: , NULL

Line 3765: SELECT PJI_REP_PC9 (PROJECT_ID

3761: ELSIF (l_Convert_Classification = 'N')
3762: and (l_Convert_Expenditure_Type = 'Y')
3763: and (l_Convert_Work_Type = 'Y')
3764: THEN
3765: SELECT PJI_REP_PC9 (PROJECT_ID
3766: , NULL
3767: , NULL
3768: , PJI_PMV_UTIL.Drill_To_Proj_Perf_URL(PROJECT_ID, l_curr_record_type_id, p_As_of_Date,p_Period_Type)
3769: , NULL

Line 3824: SELECT PJI_REP_PC9 (PROJECT_ID

3820: and (l_Convert_Expenditure_Type = 'N')
3821: and (l_Convert_Work_Type = 'Y')
3822: THEN
3823:
3824: SELECT PJI_REP_PC9 (PROJECT_ID
3825: , NULL
3826: , NULL
3827: , PJI_PMV_UTIL.Drill_To_Proj_Perf_URL(PROJECT_ID, l_curr_record_type_id, p_As_of_Date,p_Period_Type)
3828: , NULL

Line 3871: SELECT PJI_REP_PC9 (PROJECT_ID

3867: ) FCT
3868: GROUP BY PROJECT_ID,ORGANIZATION_ID;
3869:
3870: ELSE
3871: SELECT PJI_REP_PC9 (PROJECT_ID
3872: , NULL
3873: , NULL
3874: , PJI_PMV_UTIL.Drill_To_Proj_Perf_URL(PROJECT_ID, l_curr_record_type_id, p_As_of_Date,p_Period_Type)
3875: , NULL

Line 3987: END PLSQLDriver_PJI_REP_PC9;

3983: COMMIT;
3984: RETURN l_detail_tab;
3985:
3986:
3987: END PLSQLDriver_PJI_REP_PC9;
3988:
3989:
3990: end PJI_PMV_CAPITAL_COST;