[Home] [Help]
8: /*
9: ** Contract Projects Cost Summary
10: */
11:
12: PROCEDURE GET_SQL_PJI_REP_PC10(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);
67: , FACT.PJI_REP_TOTAL_7 "PJI_REP_TOTAL_23"
68: , FACT.PJI_REP_TOTAL_16 "PJI_REP_TOTAL_24"'
69: , P_SQL_STATEMENT => x_PMV_Sql
70: , P_PMV_OUTPUT => x_PMV_Output
71: , p_Region_Code => 'PJI_REP_PC10'
72: , p_PLSQL_Driver => 'PJI_PMV_COST.PLSQLDriver_PJI_REP_PC10'
73: , p_PLSQL_Driver_Params =>
74: ' <
75: ', <
68: , FACT.PJI_REP_TOTAL_16 "PJI_REP_TOTAL_24"'
69: , P_SQL_STATEMENT => x_PMV_Sql
70: , P_PMV_OUTPUT => x_PMV_Output
71: , p_Region_Code => 'PJI_REP_PC10'
72: , p_PLSQL_Driver => 'PJI_PMV_COST.PLSQLDriver_PJI_REP_PC10'
73: , p_PLSQL_Driver_Params =>
74: ' <
75: ', <
76: ', <
84: ', <
85: ', <
86: );
87:
88: END GET_SQL_PJI_REP_PC10;
89:
90:
91: /*
92: ** Contract Projects Cost Trend
266: ** -- PLSQL DRIVERS
267: */ -------------------------------------------------------------+
268:
269:
270: FUNCTION PLSQLDriver_PJI_REP_PC10(
271: p_Operating_Unit IN VARCHAR2 DEFAULT NULL
272: , p_Organization IN VARCHAR2
273: , p_Currency_Type IN VARCHAR2
274: , p_As_of_Date IN NUMBER
279: , p_Class_Codes IN VARCHAR2 DEFAULT NULL
280: , p_Expenditure_Category IN VARCHAR2 DEFAULT NULL
281: , p_Expenditure_Type IN VARCHAR2 DEFAULT NULL
282: , p_Work_Type IN VARCHAR2 DEFAULT NULL
283: ) RETURN PJI_REP_PC10_TBL
284: IS
285: PRAGMA AUTONOMOUS_TRANSACTION;
286: /*
287: ** -- Local Variable Declaration
315:
316: /*
317: ** -- PL/SQL Declaration
318: */
319: l_lines_tab PJI_REP_PC10_TBL := PJI_REP_PC10_TBL();
320:
321: BEGIN
322: BEGIN
323: SELECT report_cost_type
372: IF l_Convert_Classification = 'N'
373: AND l_Convert_Expenditure_Type = 'N'
374: AND l_Convert_Work_Type = 'N'
375: THEN
376: SELECT PJI_REP_PC10
377: ( ORG_ID
378: , ORGANIZATION_ID
379: , PROJECT_CLASS_ID
380: , EXPENDITURE_CATEGORY
517: ELSIF l_Convert_Classification = 'Y'
518: AND l_Convert_Expenditure_Type = 'N'
519: AND l_Convert_Work_Type = 'N'
520: THEN
521: SELECT PJI_REP_PC10
522: ( ORG_ID
523: , ORGANIZATION_ID
524: , PROJECT_CLASS_ID
525: , EXPENDITURE_CATEGORY
688: ELSIF l_Convert_Classification = 'N'
689: AND l_Convert_Expenditure_Type = 'Y'
690: AND l_Convert_Work_Type = 'N'
691: THEN
692: SELECT PJI_REP_PC10
693: ( ORG_ID
694: , ORGANIZATION_ID
695: , PROJECT_CLASS_ID
696: , EXPENDITURE_CATEGORY
857: ELSIF l_Convert_Classification = 'N'
858: AND l_Convert_Expenditure_Type = 'N'
859: AND l_Convert_Work_Type = 'Y'
860: THEN
861: SELECT PJI_REP_PC10
862: ( ORG_ID
863: , ORGANIZATION_ID
864: , PROJECT_CLASS_ID
865: , EXPENDITURE_CATEGORY
1025: ELSIF l_Convert_Classification = 'Y'
1026: AND l_Convert_Expenditure_Type = 'Y'
1027: AND l_Convert_Work_Type = 'N'
1028: THEN
1029: SELECT PJI_REP_PC10
1030: ( ORG_ID
1031: , ORGANIZATION_ID
1032: , PROJECT_CLASS_ID
1033: , EXPENDITURE_CATEGORY
1212: ELSIF l_Convert_Classification = 'N'
1213: AND l_Convert_Expenditure_Type = 'Y'
1214: AND l_Convert_Work_Type = 'Y'
1215: THEN
1216: SELECT PJI_REP_PC10
1217: ( ORG_ID
1218: , ORGANIZATION_ID
1219: , PROJECT_CLASS_ID
1220: , EXPENDITURE_CATEGORY
1397: ELSIF l_Convert_Classification = 'Y'
1398: AND l_Convert_Expenditure_Type = 'N'
1399: AND l_Convert_Work_Type = 'Y'
1400: THEN
1401: SELECT PJI_REP_PC10
1402: ( ORG_ID
1403: , ORGANIZATION_ID
1404: , PROJECT_CLASS_ID
1405: , EXPENDITURE_CATEGORY
1577: GROUP BY ORG_ID, ORGANIZATION_ID, PROJECT_CLASS_ID, EXPENDITURE_CATEGORY,
1578: EXPENDITURE_TYPE_ID,WORK_TYPE_ID;
1579: ELSE
1580:
1581: SELECT PJI_REP_PC10
1582: ( ORG_ID
1583: , ORGANIZATION_ID
1584: , PROJECT_CLASS_ID
1585: , EXPENDITURE_CATEGORY
2098: ** ---------------------------------------------------+
2099: */
2100: COMMIT;
2101: RETURN l_lines_tab;
2102: END PLSQLDriver_PJI_REP_PC10;
2103:
2104:
2105: /*
2106: ** Contract Projects Trend Report and Contract Cumulative Trend Report