1: PACKAGE BODY PJI_PMV_AVL AS
2: -- $Header: PJIRR01B.pls 120.4 2005/11/12 17:15:34 appldev noship $
3:
4: -- CACHE THE LABOUR UNITS OPTION SPECIFIED IN THE PJI SETUP.
5: G_LABOUR_UNITS VARCHAR2(40);
49: FACT.PJI_REP_TOTAL_12 "PJI_REP_TOTAL_12"'
50: ,P_SQL_STATEMENT => X_PMV_SQL
51: ,P_PMV_OUTPUT => X_PMV_OUTPUT,
52: P_REGION_CODE => 'PJI_REP_RA1',
53: P_PLSQL_DRIVER => 'PJI_PMV_AVL.PLSQLDRIVER_RA1',
54: P_PLSQL_DRIVER_PARAMS => '<
55: '<
56: '<
57: '<
523: FACT.PJI_REP_TOTAL_6 "PJI_REP_TOTAL_7"'
524: ,P_SQL_STATEMENT => X_PMV_SQL
525: ,P_PMV_OUTPUT => X_PMV_OUTPUT,
526: P_REGION_CODE => 'PJI_REP_RA2',
527: P_PLSQL_DRIVER => 'PJI_PMV_AVL.PLSQLDRIVER_RA2',
528: P_PLSQL_DRIVER_PARAMS => '<
529: '<
530: '<
531: '<
889: FACT.PJI_REP_TOTAL_9 "PJI_REP_TOTAL_9"'
890: ,P_SQL_STATEMENT => X_PMV_SQL
891: ,P_PMV_OUTPUT => X_PMV_OUTPUT,
892: P_REGION_CODE => 'PJI_REP_RA3',
893: P_PLSQL_DRIVER => 'PJI_PMV_AVL.PLSQLDRIVER_RA3',
894: P_PLSQL_DRIVER_PARAMS => '<
895: '<
896: '<
897: '<
1237: FACT.SCHEDULED_UTIL_PER "PJI_REP_MSR_15"'
1238: ,P_SQL_STATEMENT => X_PMV_SQL
1239: ,P_PMV_OUTPUT => X_PMV_OUTPUT,
1240: P_REGION_CODE => 'PJI_REP_RA4',
1241: P_PLSQL_DRIVER => 'PJI_PMV_AVL.PLSQLDRIVER_RA4',
1242: P_PLSQL_DRIVER_PARAMS => '<
1243: '<
1244: '<
1245: '<
1435: FACT.CONF_WTD_S "PJI_REP_MSR_30"'
1436: ,P_SQL_STATEMENT => X_PMV_SQL
1437: ,P_PMV_OUTPUT => X_PMV_OUTPUT,
1438: P_REGION_CODE => 'PJI_REP_RA5',
1439: P_PLSQL_DRIVER => 'PJI_PMV_AVL.PLSQLDRIVER_RA5',
1440: P_PLSQL_DRIVER_PARAMS => '<
1441: '<
1442: '<
1443: '<
2422: END IF;
2423: END LOOP;
2424: END GET_NEXT_ASSIGNMENT_INFO;
2425:
2426: END PJI_PMV_AVL;
2427: