[Home] [Help]
1: PACKAGE BODY PJI_PMV_BACKLOG AS
2: /* $Header: PJIRF03B.pls 120.5 2005/10/11 18:23:16 appldev noship $ */
3:
4: PROCEDURE Get_SQL_PJI_REP_PB1(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
5: , x_PMV_Sql OUT NOCOPY VARCHAR2
6: , x_PMV_Output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
7: IS
8: l_Err_Message VARCHAR2(3200);
30: FACT.PJI_REP_TOTAL_9 "PJI_REP_TOTAL_9",
31: FACT.PJI_REP_TOTAL_10 "PJI_REP_TOTAL_10"'
32: , P_SQL_STATEMENT => x_PMV_Sql
33: , P_PMV_OUTPUT => x_PMV_Output
34: , P_REGION_CODE => 'PJI_REP_PB1'
35: , P_PLSQL_DRIVER => 'PJI_PMV_BACKLOG.PLSQLDriver_PB1'
36: , P_PLSQL_DRIVER_PARAMS => ' <
37: ', <
38: ', <
40: ', <
41: ', <
42: ', <
43: ', <
44: END Get_SQL_PJI_REP_PB1;
45:
46: PROCEDURE Get_SQL_PJI_REP_PB2(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
47: , x_PMV_Sql OUT NOCOPY VARCHAR2
48: , x_PMV_Output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
90: , p_Period_Type IN VARCHAR2
91: , p_View_BY IN VARCHAR2
92: , p_Classifications IN VARCHAR2 DEFAULT NULL
93: , p_Class_Codes IN VARCHAR2 DEFAULT NULL
94: )RETURN PJI_REP_PB1_TBL
95: IS
96: PRAGMA AUTONOMOUS_TRANSACTION;
97:
98: l_Total_AC_Backlog_Tab PJI_REP_PB1_TBL:=PJI_REP_PB1_TBL();
94: )RETURN PJI_REP_PB1_TBL
95: IS
96: PRAGMA AUTONOMOUS_TRANSACTION;
97:
98: l_Total_AC_Backlog_Tab PJI_REP_PB1_TBL:=PJI_REP_PB1_TBL();
99: l_Parse_Class_Codes VARCHAR2(1);
100:
101: l_Top_Org_Index NUMBER:=0;
102: l_Top_Organization_Name VARCHAR2(240);
153: ** 3. SQL to generate rows with zero's for the view by dimension
154: ** Bulk-Collect the output into a pl/sql table to be returned to
155: ** pmv.
156: */
157: SELECT PJI_REP_PB1( ORG_ID
158: , ORGANIZATION_ID
159: , TIME_ID
160: , TIME_KEY
161: , PROJECT_CLASS_ID
363: ** 1. Current Year
364: ** 2. Prior Year
365: ** 3. SQL to generate rows with zero's for the view by dimension
366: */
367: SELECT PJI_REP_PB1
368: ( ORG_ID
369: , ORGANIZATION_ID
370: , TIME_ID
371: , TIME_KEY