[Home] [Help]
130: END Get_SQL_PJI_REP_PBB2;
131:
132: /*
133: ** ----------------------------------------------------------
134: ** Procedure: Get_SQL_PJI_REP_PBB3
135: ** This procedure returns sql statement generated by the base
136: ** engine api for the report PJI_REP_PBB3.
137: ** ----------------------------------------------------------
138: */
132: /*
133: ** ----------------------------------------------------------
134: ** Procedure: Get_SQL_PJI_REP_PBB3
135: ** This procedure returns sql statement generated by the base
136: ** engine api for the report PJI_REP_PBB3.
137: ** ----------------------------------------------------------
138: */
139: PROCEDURE Get_SQL_PJI_REP_PBB3(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
140: , x_PMV_Sql OUT NOCOPY VARCHAR2
135: ** This procedure returns sql statement generated by the base
136: ** engine api for the report PJI_REP_PBB3.
137: ** ----------------------------------------------------------
138: */
139: PROCEDURE Get_SQL_PJI_REP_PBB3(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
140: , x_PMV_Sql OUT NOCOPY VARCHAR2
141: , x_PMV_Output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
142: IS
143: l_Err_Message VARCHAR2(3200);
165: FACT.PJI_REP_TOTAL_9 "PJI_REP_TOTAL_9",
166: FACT.PJI_REP_TOTAL_10 "PJI_REP_TOTAL_10"'
167: , P_SQL_STATEMENT => x_PMV_Sql
168: , P_PMV_OUTPUT => x_PMV_Output
169: , P_REGION_CODE => 'PJI_REP_PBB3'
170: , P_PLSQL_DRIVER => 'PJI_PMV_BOOKINGS_BACKLOG.PLSQLDriver_PBB3'
171: , P_PLSQL_DRIVER_PARAMS => ' <
172: ', <
173: ', <
175: ', <
176: ', <
177: ', <
178: ', <
179: END Get_SQL_PJI_REP_PBB3;
180:
181: /*
182: ** ----------------------------------------------------------
183: ** Procedure: Get_SQL_PJI_REP_PBB4
1878: END PLSQLDRIVER_PJI_REP_PBB2;
1879:
1880: /*
1881: ** ----------------------------------------------------------
1882: ** FUNCTION: PLSQLDRIVER_PJI_REP_PBB3
1883: ** THIS TABLE FUNCTION IS CALLED FROM SELECT STATEMENT
1884: ** GENERATED BY PJI ENGINE. THE FUNCTION RETURNS PL/SQL TABLE
1885: ** OF RECORDS WHICH HAVE TO BE DISPLAYED IN THE PMV REPORT.
1886: ** FOLLOWING ARE THE REPORTS TO WHICH THIS FUNCTION CATERS:
1883: ** THIS TABLE FUNCTION IS CALLED FROM SELECT STATEMENT
1884: ** GENERATED BY PJI ENGINE. THE FUNCTION RETURNS PL/SQL TABLE
1885: ** OF RECORDS WHICH HAVE TO BE DISPLAYED IN THE PMV REPORT.
1886: ** FOLLOWING ARE THE REPORTS TO WHICH THIS FUNCTION CATERS:
1887: ** 1. PJI_REP_PBB3 - PROJECT BOOKINGS ACTIVITY
1888: ** ----------------------------------------------------------
1889: */
1890:
1891: FUNCTION PLSQLDRIVER_PBB3 (
1897: P_VIEW_BY IN VARCHAR2,
1898: P_CLASSIFICATIONS IN VARCHAR2 DEFAULT NULL,
1899: P_CLASS_CODES IN VARCHAR2 DEFAULT NULL
1900: )
1901: RETURN PJI_REP_PBB3_TBL
1902: IS
1903: PRAGMA AUTONOMOUS_TRANSACTION;
1904: L_AC_BOOKINGS_BACKLOG_TAB PJI_REP_PBB3_TBL := PJI_REP_PBB3_TBL ();
1905: L_PARSE_CLASS_CODES VARCHAR2 (1);
1900: )
1901: RETURN PJI_REP_PBB3_TBL
1902: IS
1903: PRAGMA AUTONOMOUS_TRANSACTION;
1904: L_AC_BOOKINGS_BACKLOG_TAB PJI_REP_PBB3_TBL := PJI_REP_PBB3_TBL ();
1905: L_PARSE_CLASS_CODES VARCHAR2 (1);
1906:
1907: l_Top_Organization_Name VARCHAR2(240);
1908: l_Top_Org_Index NUMBER:=0;
1975: ** 3. SQL TO GENERATE ROWS WITH ZERO'S FOR THE VIEW BY DIMENSION
1976: ** BULK-COLLECT THE OUTPUT INTO A PL/SQL TABLE TO BE RETURNED TO
1977: ** PMV.
1978: */
1979: SELECT PJI_REP_PBB3 (
1980: ORG_ID,
1981: ORGANIZATION_ID,
1982: TIME_ID,
1983: TIME_KEY,
2125: ** 1. CURRENT YEAR
2126: ** 2. PRIOR YEAR
2127: ** 3. SQL TO GENERATE ROWS WITH ZERO'S FOR THE VIEW BY DIMENSION
2128: */
2129: SELECT PJI_REP_PBB3 (
2130: ORG_ID,
2131: ORGANIZATION_ID,
2132: TIME_ID,
2133: TIME_KEY,