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 1402: ** temporary table PJI_REP_XTD_MEASURES_TMP.

1398:
1399: /**
1400: ** This API prepares, calculates, retrieves the measures to be used by
1401: ** Overview Page and breakdown pages. The measures are stored on the
1402: ** temporary table PJI_REP_XTD_MEASURES_TMP.
1403: **
1404: ** Return: xDaysSinceITD = number of days since Inception to Date
1405: ** Return: xDaysInPeriod = number of days in current period
1406: **

Line 1503: DELETE PJI_REP_XTD_MEASURES_TMP;

1499:
1500: --
1501: -- Delete the existing records in temporary table.
1502: --
1503: DELETE PJI_REP_XTD_MEASURES_TMP;
1504:
1505: BEGIN
1506:
1507: --

Line 1594: INSERT INTO PJI_REP_XTD_MEASURES_TMP

1590: --
1591: -- Bulk Insert the amounts into the temporary table.
1592: --
1593: FORALL i IN 1..x_measure_set_code.LAST
1594: INSERT INTO PJI_REP_XTD_MEASURES_TMP
1595: (
1596: MEASURE_SET_CODE, MEASURE_TYPE, MEASURE_LABEL,
1597: PTD_VALUE, QTD_VALUE, YTD_VALUE, ITD_VALUE, AC_VALUE, PRP_VALUE,
1598: PTD_HTML, QTD_HTML, YTD_HTML, ITD_HTML, AC_HTML, PRP_HTML,