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
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: ', <
39: ', <
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: ', <
74: ', <