APPS.PJI_PMV_AVL dependencies on PJI_REP_RA4

Line 1219: PROCEDURE GET_SQL_PJI_REP_RA4 (P_PAGE_PARAMETER_TBL IN BIS_PMV_PAGE_PARAMETER_TBL

1215:
1216: /******************************************************
1217: * RA4: AVAILABILITY TREND REPORT FUNCTIONS
1218: ******************************************************/
1219: PROCEDURE GET_SQL_PJI_REP_RA4 (P_PAGE_PARAMETER_TBL IN BIS_PMV_PAGE_PARAMETER_TBL
1220: , X_PMV_SQL OUT NOCOPY VARCHAR2
1221: , X_PMV_OUTPUT OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
1222: IS
1223: BEGIN

Line 1240: P_REGION_CODE => 'PJI_REP_RA4',

1236: FACT.PER_HRS_AVAILABLE "PJI_REP_MSR_13",
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: '<>, ' ||

Line 1248: END GET_SQL_PJI_REP_RA4;

1244: '<>, ' ||
1245: '<>, ' ||
1246: '<>, ' ||
1247: '<>');
1248: END GET_SQL_PJI_REP_RA4;
1249:
1250: FUNCTION PLSQLDRIVER_RA4 (
1251: P_OPERATING_UNIT IN VARCHAR2 DEFAULT NULL,
1252: P_ORGANIZATION IN VARCHAR2,

Line 1257: ) RETURN PJI_REP_RA4_TBL

1253: P_THRESHOLD IN NUMBER,
1254: P_AS_OF_DATE IN NUMBER,
1255: P_PERIOD_TYPE IN VARCHAR2,
1256: P_VIEW_BY IN VARCHAR2
1257: ) RETURN PJI_REP_RA4_TBL
1258: IS
1259: PRAGMA AUTONOMOUS_TRANSACTION;
1260: L_TOP_ORGANIZATION_NAME VARCHAR2(240);
1261: L_RA4_TBL PJI_REP_RA4_TBL := PJI_REP_RA4_TBL();

Line 1261: L_RA4_TBL PJI_REP_RA4_TBL := PJI_REP_RA4_TBL();

1257: ) RETURN PJI_REP_RA4_TBL
1258: IS
1259: PRAGMA AUTONOMOUS_TRANSACTION;
1260: L_TOP_ORGANIZATION_NAME VARCHAR2(240);
1261: L_RA4_TBL PJI_REP_RA4_TBL := PJI_REP_RA4_TBL();
1262: L_THRESHOLD NUMBER:=P_THRESHOLD;
1263: BEGIN
1264:
1265: PJI_PMV_ENGINE.CONVERT_OPERATING_UNIT (P_OPERATING_UNIT, P_VIEW_BY);

Line 1301: SELECT PJI_REP_RA4(

1297: END;
1298: END IF;
1299:
1300:
1301: SELECT PJI_REP_RA4(
1302: ORG_ID
1303: ,ORGANIZATION_ID
1304: ,TIME_ID
1305: ,TIME_KEY