[Home] [Help]
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)
49: IS
50: l_Err_Message VARCHAR2(3200);
65: FACT.ENDING_BACKLOG "PJI_REP_MSR_13",
66: FACT.CHANGE "PJI_REP_MSR_11"'
67: , P_SQL_STATEMENT => x_PMV_Sql
68: , P_PMV_OUTPUT => x_PMV_Output
69: , P_REGION_CODE => 'PJI_REP_PB2'
70: , P_PLSQL_DRIVER => 'PJI_PMV_BACKLOG.PLSQLDriver_PB2'
71: , P_PLSQL_DRIVER_PARAMS => ' <
72: ', <
73: ', <
75: ', <
76: ', <
77: ', <
78: ', <
79: END Get_SQL_PJI_REP_PB2;
80:
81: --**********************************************************************
82: -- Project Backlog Summary - PB1
83: --**********************************************************************
791: , p_Period_Type IN VARCHAR2
792: , p_View_BY IN VARCHAR2
793: , p_Classifications IN VARCHAR2 DEFAULT NULL
794: , p_Class_Codes IN VARCHAR2 DEFAULT NULL
795: ) RETURN PJI_REP_PB2_TBL
796: IS
797: PRAGMA AUTONOMOUS_TRANSACTION;
798: l_Backlog_Trend_Tab PJI_REP_PB2_TBL:=PJI_REP_PB2_TBL();
799: l_Parse_Class_Codes VARCHAR2(1);
794: , p_Class_Codes IN VARCHAR2 DEFAULT NULL
795: ) RETURN PJI_REP_PB2_TBL
796: IS
797: PRAGMA AUTONOMOUS_TRANSACTION;
798: l_Backlog_Trend_Tab PJI_REP_PB2_TBL:=PJI_REP_PB2_TBL();
799: l_Parse_Class_Codes VARCHAR2(1);
800: l_Ending_Backlog_itd NUMBER;
801: l_Ending_Lost_Backlog_itd NUMBER;
802: l_Ending_Revenue_at_Risk_itd NUMBER;
828: ** 3. SQL to generate rows with zero's for the view by dimension
829: ** Bulk-Collect the output into a pl/sql table to be returned to
830: ** pmv.
831: */
832: SELECT PJI_REP_PB2( ORG_ID
833: , ORGANIZATION_ID
834: , TIME_ID
835: , TIME_KEY
836: , PROJECT_CLASS_ID
997: ** 1. Current Year
998: ** 2. Prior Year
999: ** 3. SQL to generate rows with zero's for the view by dimension
1000: */
1001: SELECT PJI_REP_PB2( ORG_ID
1002: , ORGANIZATION_ID
1003: , TIME_ID
1004: , TIME_KEY
1005: , PROJECT_CLASS_ID