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_REP_MEASURE_UTIL dependencies on PJI_REP_XTD_MEASURES_TMP

Line 1409: ** temporary table PJI_REP_XTD_MEASURES_TMP.

1405:
1406: /**
1407: ** This API prepares, calculates, retrieves the measures to be used by
1408: ** Overview Page and breakdown pages. The measures are stored on the
1409: ** temporary table PJI_REP_XTD_MEASURES_TMP.
1410: **
1411: ** Return: xDaysSinceITD = number of days since Inception to Date
1412: ** Return: xDaysInPeriod = number of days in current period
1413: **

Line 1510: DELETE PJI_REP_XTD_MEASURES_TMP;

1506:
1507: --
1508: -- Delete the existing records in temporary table.
1509: --
1510: DELETE PJI_REP_XTD_MEASURES_TMP;
1511:
1512: BEGIN
1513:
1514: --

Line 1601: INSERT INTO PJI_REP_XTD_MEASURES_TMP

1597: --
1598: -- Bulk Insert the amounts into the temporary table.
1599: --
1600: FORALL i IN 1..x_measure_set_code.LAST
1601: INSERT INTO PJI_REP_XTD_MEASURES_TMP
1602: (
1603: MEASURE_SET_CODE, MEASURE_TYPE, MEASURE_LABEL,
1604: PTD_VALUE, QTD_VALUE, YTD_VALUE, ITD_VALUE, AC_VALUE, PRP_VALUE,
1605: PTD_HTML, QTD_HTML, YTD_HTML, ITD_HTML, AC_HTML, PRP_HTML,