1: PACKAGE BODY PJI_PMV_UTLZ AS
2: /* $Header: PJIRR02B.pls 120.2 2005/12/07 20:53:36 appldev ship $ */
3:
4: PROCEDURE Get_SQL_PJI_REP_UAP1(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
5: , x_PMV_Sql OUT NOCOPY VARCHAR2
45: FACT.PJI_REP_TOTAL_5 "PJI_REP_TOTAL_16" '
46: ,P_SQL_STATEMENT => x_PMV_Sql
47: ,P_PMV_OUTPUT => x_PMV_Output,
48: P_REGION_CODE => 'PJI_REP_UAP1',
49: P_PLSQL_DRIVER => 'PJI_PMV_UTLZ.PLSQLDriver_U1',
50: P_PLSQL_DRIVER_PARAMS => '<
51: '<
52: '<
53: '<
99: FACT.PJI_REP_TOTAL_11 "PJI_REP_TOTAL_8" '
100: ,P_SQL_STATEMENT => x_PMV_Sql
101: ,P_PMV_OUTPUT => x_PMV_Output,
102: P_REGION_CODE => 'PJI_REP_U1',
103: P_PLSQL_DRIVER => 'PJI_PMV_UTLZ.PLSQLDriver_U1',
104: P_PLSQL_DRIVER_PARAMS => '<
105: '<
106: '<
107: '<
146: FACT.SCH_UTIL_PERCENT "PJI_REP_MSR_26" '
147: ,P_SQL_STATEMENT => x_PMV_Sql
148: ,P_PMV_OUTPUT => x_PMV_Output,
149: P_REGION_CODE => 'PJI_REP_U2',
150: P_PLSQL_DRIVER => 'PJI_PMV_UTLZ.PLSQLDriver_U2',
151: P_PLSQL_DRIVER_PARAMS => '<
152: '<
153: '<
154: '<
198: FACT.PJI_REP_TOTAL_14 "PJI_REP_TOTAL_14" '
199: ,P_SQL_STATEMENT => x_PMV_Sql
200: ,P_PMV_OUTPUT => x_PMV_Output,
201: P_REGION_CODE => 'PJI_REP_U3',
202: P_PLSQL_DRIVER => 'PJI_PMV_UTLZ.PLSQLDriver_U3',
203: P_PLSQL_DRIVER_PARAMS => '<
204: '<
205: '<
206: '<
256: FACT.PJI_REP_TOTAL_17 "PJI_REP_TOTAL_15" '
257: ,P_SQL_STATEMENT => x_PMV_Sql
258: ,P_PMV_OUTPUT => x_PMV_Output,
259: P_REGION_CODE => 'PJI_REP_U4',
260: P_PLSQL_DRIVER => 'PJI_PMV_UTLZ.PLSQLDriver_U4',
261: P_PLSQL_DRIVER_PARAMS => '<
262: '<
263: '<
264: '<
308: FACT.PJI_REP_TOTAL_23 "PJI_REP_TOTAL_8" '
309: ,P_SQL_STATEMENT => x_PMV_Sql
310: ,P_PMV_OUTPUT => x_PMV_Output,
311: P_REGION_CODE => 'PJI_REP_U5',
312: P_PLSQL_DRIVER => 'PJI_PMV_UTLZ.PLSQLDriver_U4',
313: P_PLSQL_DRIVER_PARAMS => '<
314: '<
315: '<
316: '<
5746: FACT.PJI_REP_TOTAL_10 "PJI_REP_TOTAL_10" '
5747: ,P_SQL_STATEMENT => x_PMV_Sql
5748: ,P_PMV_OUTPUT => x_PMV_Output,
5749: P_REGION_CODE => 'PJI_REP_U6',
5750: P_PLSQL_DRIVER => 'PJI_PMV_UTLZ.PLSQLDriver_PJI_REP_U6',
5751: P_PLSQL_DRIVER_PARAMS => '<
5752: '<
5753: '<
5754: '<
6381: FACT.PJI_REP_TOTAL_12 "PJI_REP_TOTAL_12" '
6382: ,P_SQL_STATEMENT => x_PMV_Sql
6383: ,P_PMV_OUTPUT => x_PMV_Output,
6384: P_REGION_CODE => 'PJI_REP_U7',
6385: P_PLSQL_DRIVER => 'PJI_PMV_UTLZ.PLSQLDriver_PJI_REP_U7',
6386: P_PLSQL_DRIVER_PARAMS => '<
6387: '<
6388: '<
6389: '<
7059: FACT.PJI_REP_TOTAL_12 "PJI_REP_TOTAL_12" '
7060: ,P_SQL_STATEMENT => x_PMV_Sql
7061: ,P_PMV_OUTPUT => x_PMV_Output,
7062: P_REGION_CODE => 'PJI_REP_U8',
7063: P_PLSQL_DRIVER => 'PJI_PMV_UTLZ.PLSQLDriver_PJI_REP_U8',
7064: P_PLSQL_DRIVER_PARAMS => '<
7065: '<
7066: '<
7067: '<
8151:
8152: END PLSQLDriver_PJI_REP_U8;
8153:
8154:
8155: END PJI_PMV_UTLZ;