[Home] [Help]
8: ** Capital Projects Cost Summary
9: *********************************
10: */
11:
12: procedure GET_SQL_PJI_REP_PC6(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL
13: , x_PMV_Sql out nocopy VARCHAR2
14: , x_PMV_Output out nocopy BIS_QUERY_ATTRIBUTES_TBL)
15: is
16: l_Err_Message VARCHAR2(3200);
37: , FACT.PJI_REP_TOTAL_4 "PJI_REP_TOTAL_17"
38: , FACT.PJI_REP_TOTAL_7 "PJI_REP_TOTAL_18"'
39: , P_SQL_STATEMENT => x_PMV_Sql
40: , P_PMV_OUTPUT => x_PMV_Output
41: , p_Region_Code => 'PJI_REP_PC6'
42: , p_PLSQL_Driver => 'PJI_PMV_CAPITAL_COST.PLSQLDriver_PJI_REP_PC6'
43: , p_PLSQL_Driver_Params =>
44: ' <
45: ', <
38: , FACT.PJI_REP_TOTAL_7 "PJI_REP_TOTAL_18"'
39: , P_SQL_STATEMENT => x_PMV_Sql
40: , P_PMV_OUTPUT => x_PMV_Output
41: , p_Region_Code => 'PJI_REP_PC6'
42: , p_PLSQL_Driver => 'PJI_PMV_CAPITAL_COST.PLSQLDriver_PJI_REP_PC6'
43: , p_PLSQL_Driver_Params =>
44: ' <
45: ', <
46: ', <
53: ', <
54: ', <
55: ', <
56: );
57: end GET_SQL_PJI_REP_PC6;
58:
59: /*
60: *******************************
61: ** Capital Project Cost Trend
220: ** -- PLSQL DRIVERS
221: */ -------------------------------------------------------------+
222:
223:
224: function PLSQLDriver_PJI_REP_PC6(
225: p_Operating_Unit in VARCHAR2 default null
226: , p_Organization in VARCHAR2
227: , p_Currency_Type in VARCHAR2
228: , p_As_of_Date in NUMBER
233: , p_Class_Codes in VARCHAR2 default null
234: , p_Expenditure_Category IN VARCHAR2 DEFAULT NULL
235: , p_Expenditure_Type IN VARCHAR2 DEFAULT NULL
236: , p_Work_Type IN VARCHAR2 DEFAULT NULL
237: ) return PJI_REP_PC6_TBL
238: is
239:
240: pragma autonomous_transaction;
241:
279:
280: /*
281: ** -- PL/SQL Declaration
282: */
283: l_lines_tab PJI_REP_PC6_TBL := PJI_REP_PC6_TBL();
284:
285:
286: begin
287: begin
341: AND l_Convert_Expenditure_Type = 'N'
342: AND l_Convert_Work_Type = 'N'
343: THEN
344:
345: select PJI_REP_PC6 ( ORG_ID
346: , ORGANIZATION_ID
347: , PROJECT_CLASS_ID
348: , EXPENDITURE_CATEGORY
349: , EXPENDITURE_TYPE_ID
505: l_Convert_Classification = 'Y'
506: AND l_Convert_Expenditure_Type = 'N'
507: AND l_Convert_Work_Type = 'N'
508: THEN
509: select PJI_REP_PC6 ( ORG_ID
510: , ORGANIZATION_ID
511: , PROJECT_CLASS_ID
512: , EXPENDITURE_CATEGORY
513: , EXPENDITURE_TYPE_ID
694: l_Convert_Classification = 'N'
695: AND l_Convert_Expenditure_Type = 'Y'
696: AND l_Convert_Work_Type = 'N'
697: THEN
698: select PJI_REP_PC6 ( ORG_ID
699: , ORGANIZATION_ID
700: , PROJECT_CLASS_ID
701: , EXPENDITURE_CATEGORY
702: , EXPENDITURE_TYPE_ID
885: l_Convert_Classification = 'N'
886: AND l_Convert_Expenditure_Type = 'N'
887: AND l_Convert_Work_Type = 'Y'
888: THEN
889: select PJI_REP_PC6 ( ORG_ID
890: , ORGANIZATION_ID
891: , PROJECT_CLASS_ID
892: , EXPENDITURE_CATEGORY
893: , EXPENDITURE_TYPE_ID
1073: l_Convert_Classification = 'Y'
1074: AND l_Convert_Expenditure_Type = 'Y'
1075: AND l_Convert_Work_Type = 'N'
1076: THEN
1077: select PJI_REP_PC6 ( ORG_ID
1078: , ORGANIZATION_ID
1079: , PROJECT_CLASS_ID
1080: , EXPENDITURE_CATEGORY
1081: , EXPENDITURE_TYPE_ID
1287: l_Convert_Classification = 'N'
1288: AND l_Convert_Expenditure_Type = 'Y'
1289: AND l_Convert_Work_Type = 'Y'
1290: THEN
1291: select PJI_REP_PC6 ( ORG_ID
1292: , ORGANIZATION_ID
1293: , PROJECT_CLASS_ID
1294: , EXPENDITURE_CATEGORY
1295: , EXPENDITURE_TYPE_ID
1502: l_Convert_Classification = 'Y'
1503: AND l_Convert_Expenditure_Type = 'N'
1504: AND l_Convert_Work_Type = 'Y'
1505: THEN
1506: select PJI_REP_PC6 ( ORG_ID
1507: , ORGANIZATION_ID
1508: , PROJECT_CLASS_ID
1509: , EXPENDITURE_CATEGORY
1510: , EXPENDITURE_TYPE_ID
1713: */
1714:
1715:
1716: ELSE
1717: select PJI_REP_PC6 ( ORG_ID
1718: , ORGANIZATION_ID
1719: , PROJECT_CLASS_ID
1720: , EXPENDITURE_CATEGORY
1721: , EXPENDITURE_TYPE_ID
2167: */
2168:
2169: COMMIT;
2170: return l_lines_tab;
2171: end PLSQLDriver_PJI_REP_PC6;
2172:
2173:
2174: /*
2175: ** Capital Cost Trend Report and Capital Cost Cumulative Trend Report