[Home] [Help]
61: END Get_SQL_PJI_REP_PBB1;
62:
63: /*
64: ** ----------------------------------------------------------
65: ** Procedure: Get_SQL_PJI_REP_PBB2
66: ** This procedure returns sql statement generated by the base
67: ** engine api for the report PJI_REP_PBB2.
68: ** ----------------------------------------------------------
69: */
63: /*
64: ** ----------------------------------------------------------
65: ** Procedure: Get_SQL_PJI_REP_PBB2
66: ** This procedure returns sql statement generated by the base
67: ** engine api for the report PJI_REP_PBB2.
68: ** ----------------------------------------------------------
69: */
70: PROCEDURE Get_SQL_PJI_REP_PBB2(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
71: , x_PMV_Sql OUT NOCOPY VARCHAR2
66: ** This procedure returns sql statement generated by the base
67: ** engine api for the report PJI_REP_PBB2.
68: ** ----------------------------------------------------------
69: */
70: PROCEDURE Get_SQL_PJI_REP_PBB2(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
71: , x_PMV_Sql OUT NOCOPY VARCHAR2
72: , x_PMV_Output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
73: IS
74: l_Err_Message VARCHAR2(3200);
115: FACT.PJI_REP_TOTAL_9 "PJI_REP_TOTAL_9",
116: FACT.PJI_REP_TOTAL_10 "PJI_REP_TOTAL_10"'
117: , P_SQL_STATEMENT => x_PMV_Sql
118: , P_PMV_OUTPUT => x_PMV_Output
119: , P_REGION_CODE => 'PJI_REP_PBB2'
120: , P_PLSQL_DRIVER => 'PJI_PMV_BOOKINGS_BACKLOG.PLSQLDriver_PJI_REP_PBB2'
121: , P_PLSQL_DRIVER_PARAMS => ' <
122: ', <
123: ', <
116: FACT.PJI_REP_TOTAL_10 "PJI_REP_TOTAL_10"'
117: , P_SQL_STATEMENT => x_PMV_Sql
118: , P_PMV_OUTPUT => x_PMV_Output
119: , P_REGION_CODE => 'PJI_REP_PBB2'
120: , P_PLSQL_DRIVER => 'PJI_PMV_BOOKINGS_BACKLOG.PLSQLDriver_PJI_REP_PBB2'
121: , P_PLSQL_DRIVER_PARAMS => ' <
122: ', <
123: ', <
124: ', <
126: ', <
127: ', <
128: ', <
129: ', <
130: END Get_SQL_PJI_REP_PBB2;
131:
132: /*
133: ** ----------------------------------------------------------
134: ** Procedure: Get_SQL_PJI_REP_PBB3
225: FACT.PJI_REP_TOTAL_8 "PJI_REP_TOTAL_8"'
226: , P_SQL_STATEMENT => x_PMV_Sql
227: , P_PMV_OUTPUT => x_PMV_Output
228: , P_REGION_CODE => 'PJI_REP_PBB4'
229: , P_PLSQL_DRIVER => 'PJI_PMV_BOOKINGS_BACKLOG.PLSQLDriver_PJI_REP_PBB2'
230: , P_PLSQL_DRIVER_PARAMS => ' <
231: ', <
232: ', <
233: ', <
1207: END PLSQLDriver_PJI_REP_PBB1;
1208:
1209: /*
1210: ** ----------------------------------------------------------
1211: ** FUNCTION: PLSQLDRIVER_PJI_REP_PBB2
1212: ** THIS TABLE FUNCTION IS CALLED FROM SELECT STATEMENT
1213: ** GENERATED BY PJI ENGINE. THE FUNCTION RETURNS PL/SQL TABLE
1214: ** OF RECORDS WHICH HAVE TO BE DISPLAYED IN THE PMV REPORT.
1215: ** FOLLOWING ARE THE REPORTS TO WHICH THIS FUNCTION CATERS:
1212: ** THIS TABLE FUNCTION IS CALLED FROM SELECT STATEMENT
1213: ** GENERATED BY PJI ENGINE. THE FUNCTION RETURNS PL/SQL TABLE
1214: ** OF RECORDS WHICH HAVE TO BE DISPLAYED IN THE PMV REPORT.
1215: ** FOLLOWING ARE THE REPORTS TO WHICH THIS FUNCTION CATERS:
1216: ** 1. PJI_REP_PBB2 - PROJECT BOOKINGS & BACKLOG SUMMARY
1217: ** 2. PJI_REP_PBB4 - PROJECT BOOKINGS & BACKLOG SUMMARY
1218: ** ----------------------------------------------------------
1219: */
1220:
1217: ** 2. PJI_REP_PBB4 - PROJECT BOOKINGS & BACKLOG SUMMARY
1218: ** ----------------------------------------------------------
1219: */
1220:
1221: FUNCTION PLSQLDRIVER_PJI_REP_PBB2 (
1222: P_OPERATING_UNIT IN VARCHAR2 DEFAULT NULL,
1223: P_ORGANIZATION IN VARCHAR2,
1224: P_CURRENCY_TYPE IN VARCHAR2,
1225: P_AS_OF_DATE IN NUMBER,
1228: P_CLASSIFICATIONS IN VARCHAR2 DEFAULT NULL,
1229: P_CLASS_CODES IN VARCHAR2 DEFAULT NULL,
1230: P_RUN_REVENUE_AT_RISK IN VARCHAR2 DEFAULT 'N'
1231: )
1232: RETURN PJI_REP_PBB2_TBL
1233: IS
1234: PRAGMA AUTONOMOUS_TRANSACTION;
1235: L_TOTAL_BOOKINGS_BACKLOG_TAB PJI_REP_PBB2_TBL := PJI_REP_PBB2_TBL ();
1236: X_TOTAL_BOOKINGS_BACKLOG_TAB PJI_REP_PBB2_TBL := PJI_REP_PBB2_TBL ();
1231: )
1232: RETURN PJI_REP_PBB2_TBL
1233: IS
1234: PRAGMA AUTONOMOUS_TRANSACTION;
1235: L_TOTAL_BOOKINGS_BACKLOG_TAB PJI_REP_PBB2_TBL := PJI_REP_PBB2_TBL ();
1236: X_TOTAL_BOOKINGS_BACKLOG_TAB PJI_REP_PBB2_TBL := PJI_REP_PBB2_TBL ();
1237: L_PARSE_CLASS_CODES VARCHAR2 (1);
1238: L_REORG_ROWCOUNT NUMBER;
1239: L_ACTUAL_ROWCOUNT NUMBER;
1232: RETURN PJI_REP_PBB2_TBL
1233: IS
1234: PRAGMA AUTONOMOUS_TRANSACTION;
1235: L_TOTAL_BOOKINGS_BACKLOG_TAB PJI_REP_PBB2_TBL := PJI_REP_PBB2_TBL ();
1236: X_TOTAL_BOOKINGS_BACKLOG_TAB PJI_REP_PBB2_TBL := PJI_REP_PBB2_TBL ();
1237: L_PARSE_CLASS_CODES VARCHAR2 (1);
1238: L_REORG_ROWCOUNT NUMBER;
1239: L_ACTUAL_ROWCOUNT NUMBER;
1240:
1302: ** BULK-COLLECT THE OUTPUT INTO A PL/SQL TABLE TO BE RETURNED TO
1303: ** PMV.
1304: */
1305:
1306: SELECT PJI_REP_PBB2 (PROJECT_ID,
1307: PROJECT_NAME,
1308: PROJECT_NUMBER,
1309: PJI_PMV_UTIL.Drill_To_Proj_Perf_URL(PROJECT_ID, l_curr_record_type_id, p_As_Of_Date,p_Period_Type),
1310: PRIMARY_CUSTOMER,
1514: AND prj.project_id = pjm.project_id
1515: AND prj.carrying_out_organization_id = org.ID;
1516: END;
1517:
1518: SELECT PJI_REP_PBB2 (PROJECT_ID,
1519: PROJECT_NAME,
1520: PROJECT_NUMBER,
1521: PJI_PMV_UTIL.Drill_To_Proj_Perf_URL(PROJECT_ID, l_curr_record_type_id, p_As_Of_Date,p_Period_Type),
1522: PRIMARY_CUSTOMER,
1874:
1875: END LOOP;
1876: COMMIT;
1877: RETURN X_TOTAL_BOOKINGS_BACKLOG_TAB;
1878: END PLSQLDRIVER_PJI_REP_PBB2;
1879:
1880: /*
1881: ** ----------------------------------------------------------
1882: ** FUNCTION: PLSQLDRIVER_PJI_REP_PBB3