eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PJI_PMV_AVL dependencies on PJI_PMV_ENGINE

Line 24: PJI_PMV_ENGINE.GENERATE_SQL(P_PAGE_PARAMETER_TBL => P_PAGE_PARAMETER_TBL

20: , X_PMV_OUTPUT OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
21: IS
22: BEGIN
23:
24: PJI_PMV_ENGINE.GENERATE_SQL(P_PAGE_PARAMETER_TBL => P_PAGE_PARAMETER_TBL
25: ,P_SELECT_LIST =>
26: 'FACT.CAPACITY "PJI_REP_MSR_3",
27: FACT.CONFIRMED "PJI_REP_MSR_4",
28: FACT.PROVISIONAL "PJI_REP_MSR_5",

Line 113: PJI_PMV_ENGINE.CONVERT_OPERATING_UNIT (P_OPERATING_UNIT_IDS=>P_OPERATING_UNIT,

109: L_THRESHOLD NUMBER:=P_THRESHOLD;
110:
111: BEGIN
112:
113: PJI_PMV_ENGINE.CONVERT_OPERATING_UNIT (P_OPERATING_UNIT_IDS=>P_OPERATING_UNIT,
114: P_VIEW_BY=>P_VIEW_BY);
115: PJI_PMV_ENGINE.CONVERT_ORGANIZATION (P_TOP_ORGANIZATION_ID=>P_ORGANIZATION,
116: P_VIEW_BY=>P_VIEW_BY,
117: P_TOP_ORGANIZATION_NAME => L_TOP_ORGANIZATION_NAME);

Line 115: PJI_PMV_ENGINE.CONVERT_ORGANIZATION (P_TOP_ORGANIZATION_ID=>P_ORGANIZATION,

111: BEGIN
112:
113: PJI_PMV_ENGINE.CONVERT_OPERATING_UNIT (P_OPERATING_UNIT_IDS=>P_OPERATING_UNIT,
114: P_VIEW_BY=>P_VIEW_BY);
115: PJI_PMV_ENGINE.CONVERT_ORGANIZATION (P_TOP_ORGANIZATION_ID=>P_ORGANIZATION,
116: P_VIEW_BY=>P_VIEW_BY,
117: P_TOP_ORGANIZATION_NAME => L_TOP_ORGANIZATION_NAME);
118: PJI_PMV_ENGINE.CONVERT_TIME(P_AS_OF_DATE=>P_AS_OF_DATE,
119: P_PERIOD_TYPE=>P_PERIOD_TYPE,

Line 118: PJI_PMV_ENGINE.CONVERT_TIME(P_AS_OF_DATE=>P_AS_OF_DATE,

114: P_VIEW_BY=>P_VIEW_BY);
115: PJI_PMV_ENGINE.CONVERT_ORGANIZATION (P_TOP_ORGANIZATION_ID=>P_ORGANIZATION,
116: P_VIEW_BY=>P_VIEW_BY,
117: P_TOP_ORGANIZATION_NAME => L_TOP_ORGANIZATION_NAME);
118: PJI_PMV_ENGINE.CONVERT_TIME(P_AS_OF_DATE=>P_AS_OF_DATE,
119: P_PERIOD_TYPE=>P_PERIOD_TYPE,
120: P_VIEW_BY=>P_VIEW_BY,
121: P_PARSE_PRIOR=>NULL,
122: P_REPORT_TYPE=>NULL,

Line 503: PJI_PMV_ENGINE.GENERATE_SQL(P_PAGE_PARAMETER_TBL => P_PAGE_PARAMETER_TBL

499: , X_PMV_OUTPUT OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
500: IS
501: BEGIN
502:
503: PJI_PMV_ENGINE.GENERATE_SQL(P_PAGE_PARAMETER_TBL => P_PAGE_PARAMETER_TBL
504: ,P_SELECT_LIST =>
505: 'FACT.CURR_AVL_RES "PJI_REP_MSR_2",
506: FACT.CURR_AVL_RES_URL_PARAMS "PJI_REP_MSR_12",
507: FACT.TOTAL_RESOURCES "PJI_REP_MSR_3",

Line 576: PJI_PMV_ENGINE.CONVERT_OPERATING_UNIT (P_OPERATING_UNIT, P_VIEW_BY);

572: L_CALENDAR_TYPE VARCHAR2(1):='E';
573: L_PERIOD_TYPE_ID NUMBER:=16;
574: BEGIN
575:
576: PJI_PMV_ENGINE.CONVERT_OPERATING_UNIT (P_OPERATING_UNIT, P_VIEW_BY);
577: PJI_PMV_ENGINE.CONVERT_ORGANIZATION (P_ORGANIZATION, P_VIEW_BY, L_TOP_ORGANIZATION_NAME);
578:
579: -- DELETE THE TIME DIMENSION TEMP TABLE FIRST BEFORE INSERTING AGAIN.
580: DELETE PJI_PMV_TIME_DIM_TMP;

Line 577: PJI_PMV_ENGINE.CONVERT_ORGANIZATION (P_ORGANIZATION, P_VIEW_BY, L_TOP_ORGANIZATION_NAME);

573: L_PERIOD_TYPE_ID NUMBER:=16;
574: BEGIN
575:
576: PJI_PMV_ENGINE.CONVERT_OPERATING_UNIT (P_OPERATING_UNIT, P_VIEW_BY);
577: PJI_PMV_ENGINE.CONVERT_ORGANIZATION (P_ORGANIZATION, P_VIEW_BY, L_TOP_ORGANIZATION_NAME);
578:
579: -- DELETE THE TIME DIMENSION TEMP TABLE FIRST BEFORE INSERTING AGAIN.
580: DELETE PJI_PMV_TIME_DIM_TMP;
581:

Line 869: PJI_PMV_ENGINE.GENERATE_SQL(P_PAGE_PARAMETER_TBL => P_PAGE_PARAMETER_TBL

865: , X_PMV_OUTPUT OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
866: IS
867: BEGIN
868:
869: PJI_PMV_ENGINE.GENERATE_SQL(P_PAGE_PARAMETER_TBL => P_PAGE_PARAMETER_TBL
870: ,P_SELECT_LIST =>
871: 'FACT.EXP_ORGANIZATION_ID "VIEWBYID",
872: FACT.CURR_AVL_RES "PJI_REP_MSR_2",
873: FACT.TOTAL_AVL_RES "PJI_REP_MSR_3",

Line 943: PJI_PMV_ENGINE.CONVERT_OPERATING_UNIT (P_OPERATING_UNIT, P_VIEW_BY);

939: l_DAY_CALENDAR_TYPE VARCHAR2(1):='C';
940: l_DAY_PERIOD_TYPE NUMBER:=1;
941: BEGIN
942:
943: PJI_PMV_ENGINE.CONVERT_OPERATING_UNIT (P_OPERATING_UNIT, P_VIEW_BY);
944: PJI_PMV_ENGINE.CONVERT_ORGANIZATION (P_ORGANIZATION, P_VIEW_BY, L_TOP_ORGANIZATION_NAME);
945: PJI_PMV_ENGINE.CONVERT_TIME (P_AS_OF_DATE=>P_AS_OF_DATE,
946: P_PERIOD_TYPE=>P_PERIOD_TYPE,
947: P_VIEW_BY =>P_VIEW_BY,

Line 944: PJI_PMV_ENGINE.CONVERT_ORGANIZATION (P_ORGANIZATION, P_VIEW_BY, L_TOP_ORGANIZATION_NAME);

940: l_DAY_PERIOD_TYPE NUMBER:=1;
941: BEGIN
942:
943: PJI_PMV_ENGINE.CONVERT_OPERATING_UNIT (P_OPERATING_UNIT, P_VIEW_BY);
944: PJI_PMV_ENGINE.CONVERT_ORGANIZATION (P_ORGANIZATION, P_VIEW_BY, L_TOP_ORGANIZATION_NAME);
945: PJI_PMV_ENGINE.CONVERT_TIME (P_AS_OF_DATE=>P_AS_OF_DATE,
946: P_PERIOD_TYPE=>P_PERIOD_TYPE,
947: P_VIEW_BY =>P_VIEW_BY,
948: P_PARSE_PRIOR=>NULL,

Line 945: PJI_PMV_ENGINE.CONVERT_TIME (P_AS_OF_DATE=>P_AS_OF_DATE,

941: BEGIN
942:
943: PJI_PMV_ENGINE.CONVERT_OPERATING_UNIT (P_OPERATING_UNIT, P_VIEW_BY);
944: PJI_PMV_ENGINE.CONVERT_ORGANIZATION (P_ORGANIZATION, P_VIEW_BY, L_TOP_ORGANIZATION_NAME);
945: PJI_PMV_ENGINE.CONVERT_TIME (P_AS_OF_DATE=>P_AS_OF_DATE,
946: P_PERIOD_TYPE=>P_PERIOD_TYPE,
947: P_VIEW_BY =>P_VIEW_BY,
948: P_PARSE_PRIOR=>NULL,
949: P_REPORT_TYPE=>NULL,

Line 1225: PJI_PMV_ENGINE.GENERATE_SQL(P_PAGE_PARAMETER_TBL => P_PAGE_PARAMETER_TBL

1221: , X_PMV_OUTPUT OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
1222: IS
1223: BEGIN
1224:
1225: PJI_PMV_ENGINE.GENERATE_SQL(P_PAGE_PARAMETER_TBL => P_PAGE_PARAMETER_TBL
1226: , P_SELECT_LIST =>
1227: 'FACT.UNASSIGNED "PJI_REP_MSR_29",
1228: FACT.AVAILABLE "PJI_REP_MSR_28",
1229: FACT.SCHEDULED_UTIL "PJI_REP_MSR_30",

Line 1265: PJI_PMV_ENGINE.CONVERT_OPERATING_UNIT (P_OPERATING_UNIT, P_VIEW_BY);

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);
1266:
1267: PJI_PMV_ENGINE.CONVERT_ORGANIZATION ( P_TOP_ORGANIZATION_ID => P_ORGANIZATION
1268: , P_VIEW_BY => P_VIEW_BY
1269: , P_TOP_ORGANIZATION_NAME => L_TOP_ORGANIZATION_NAME);

Line 1267: PJI_PMV_ENGINE.CONVERT_ORGANIZATION ( P_TOP_ORGANIZATION_ID => P_ORGANIZATION

1263: BEGIN
1264:
1265: PJI_PMV_ENGINE.CONVERT_OPERATING_UNIT (P_OPERATING_UNIT, P_VIEW_BY);
1266:
1267: PJI_PMV_ENGINE.CONVERT_ORGANIZATION ( P_TOP_ORGANIZATION_ID => P_ORGANIZATION
1268: , P_VIEW_BY => P_VIEW_BY
1269: , P_TOP_ORGANIZATION_NAME => L_TOP_ORGANIZATION_NAME);
1270:
1271: PJI_PMV_ENGINE.CONVERT_TIME ( P_AS_OF_DATE => P_AS_OF_DATE

Line 1271: PJI_PMV_ENGINE.CONVERT_TIME ( P_AS_OF_DATE => P_AS_OF_DATE

1267: PJI_PMV_ENGINE.CONVERT_ORGANIZATION ( P_TOP_ORGANIZATION_ID => P_ORGANIZATION
1268: , P_VIEW_BY => P_VIEW_BY
1269: , P_TOP_ORGANIZATION_NAME => L_TOP_ORGANIZATION_NAME);
1270:
1271: PJI_PMV_ENGINE.CONVERT_TIME ( P_AS_OF_DATE => P_AS_OF_DATE
1272: , P_PERIOD_TYPE => P_PERIOD_TYPE
1273: , P_VIEW_BY => P_VIEW_BY
1274: , P_PARSE_PRIOR => NULL
1275: , P_REPORT_TYPE => NULL

Line 1416: PJI_PMV_ENGINE.GENERATE_SQL(P_PAGE_PARAMETER_TBL => P_PAGE_PARAMETER_TBL

1412: , X_PMV_OUTPUT OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
1413: IS
1414: BEGIN
1415:
1416: PJI_PMV_ENGINE.GENERATE_SQL(P_PAGE_PARAMETER_TBL => P_PAGE_PARAMETER_TBL
1417: ,P_SELECT_LIST =>
1418: 'FACT.PERSON_NAME "VIEWBY",
1419: FACT.JOB_LEVEL "PJI_REP_MSR_2",
1420: FACT.CAPACITY "PJI_REP_MSR_3",

Line 1469: PJI_PMV_ENGINE.CONVERT_OPERATING_UNIT (P_OPERATING_UNIT, P_VIEW_BY);

1465: L_DAY_PERIOD_TYPE NUMBER:=1;
1466: L_DAY_CALENDAR_TYPE VARCHAR2(1):='C';
1467: BEGIN
1468:
1469: PJI_PMV_ENGINE.CONVERT_OPERATING_UNIT (P_OPERATING_UNIT, P_VIEW_BY);
1470: PJI_PMV_ENGINE.CONVERT_ORGANIZATION (P_ORGANIZATION, P_VIEW_BY);
1471: PJI_PMV_ENGINE.CONVERT_TIME ( P_AS_OF_DATE => P_AS_OF_DATE
1472: , P_PERIOD_TYPE => P_PERIOD_TYPE
1473: , P_VIEW_BY => P_VIEW_BY

Line 1470: PJI_PMV_ENGINE.CONVERT_ORGANIZATION (P_ORGANIZATION, P_VIEW_BY);

1466: L_DAY_CALENDAR_TYPE VARCHAR2(1):='C';
1467: BEGIN
1468:
1469: PJI_PMV_ENGINE.CONVERT_OPERATING_UNIT (P_OPERATING_UNIT, P_VIEW_BY);
1470: PJI_PMV_ENGINE.CONVERT_ORGANIZATION (P_ORGANIZATION, P_VIEW_BY);
1471: PJI_PMV_ENGINE.CONVERT_TIME ( P_AS_OF_DATE => P_AS_OF_DATE
1472: , P_PERIOD_TYPE => P_PERIOD_TYPE
1473: , P_VIEW_BY => P_VIEW_BY
1474: , P_PARSE_PRIOR => NULL

Line 1471: PJI_PMV_ENGINE.CONVERT_TIME ( P_AS_OF_DATE => P_AS_OF_DATE

1467: BEGIN
1468:
1469: PJI_PMV_ENGINE.CONVERT_OPERATING_UNIT (P_OPERATING_UNIT, P_VIEW_BY);
1470: PJI_PMV_ENGINE.CONVERT_ORGANIZATION (P_ORGANIZATION, P_VIEW_BY);
1471: PJI_PMV_ENGINE.CONVERT_TIME ( P_AS_OF_DATE => P_AS_OF_DATE
1472: , P_PERIOD_TYPE => P_PERIOD_TYPE
1473: , P_VIEW_BY => P_VIEW_BY
1474: , P_PARSE_PRIOR => NULL
1475: , P_REPORT_TYPE => NULL