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.PA_EXCEPTION_ENGINE_PKG dependencies on PA_PERF_KPA_SUMMARY

Line 1230: DELETE from pa_perf_kpa_summary_det

1226: AND perf_txn_obj_id = p_project_list(i)
1227: AND trunc(creation_date) < trunc(sysdate - p_days_old)
1228: AND current_flag = 'N');
1229:
1230: DELETE from pa_perf_kpa_summary_det
1231: WHERE object_type = 'PA_PROJECTS'
1232: AND object_id = p_project_list(i)
1233: AND trunc(creation_date) < trunc(sysdate - p_days_old)
1234: AND kpa_summary_id in (SELECT kpa_summary_id

Line 1235: FROM pa_perf_kpa_summary

1231: WHERE object_type = 'PA_PROJECTS'
1232: AND object_id = p_project_list(i)
1233: AND trunc(creation_date) < trunc(sysdate - p_days_old)
1234: AND kpa_summary_id in (SELECT kpa_summary_id
1235: FROM pa_perf_kpa_summary
1236: WHERE object_type = 'PA_PROJECTS'
1237: AND object_id = p_project_list(i)
1238: AND trunc(creation_date) < trunc(sysdate - p_days_old)
1239: AND current_flag = 'N');

Line 1241: DELETE from pa_perf_kpa_summary

1237: AND object_id = p_project_list(i)
1238: AND trunc(creation_date) < trunc(sysdate - p_days_old)
1239: AND current_flag = 'N');
1240:
1241: DELETE from pa_perf_kpa_summary
1242: WHERE object_type = 'PA_PROJECTS'
1243: AND object_id = p_project_list(i)
1244: AND trunc(creation_date) < trunc(sysdate - p_days_old)
1245: AND current_flag = 'N';

Line 1509: -- mass update the current_flag in PA_PERF_KPA_SUMMARY table

1505: OPEN get_kpas;
1506: FETCH get_kpas bulk collect INTO l_kpas;
1507: CLOSE get_kpas;
1508:
1509: -- mass update the current_flag in PA_PERF_KPA_SUMMARY table
1510:
1511: IF P_PA_DEBUG_MODE = 'Y' THEN
1512: PA_DEBUG.write_file('LOG', 'Mass update the KPA Summary table');
1513: END IF;

Line 1516: UPDATE pa_perf_kpa_summary

1512: PA_DEBUG.write_file('LOG', 'Mass update the KPA Summary table');
1513: END IF;
1514:
1515: FORALL i IN p_project_list.first..p_project_list.last
1516: UPDATE pa_perf_kpa_summary
1517: SET current_flag = 'N'
1518: WHERE object_type = 'PA_PROJECTS'
1519: AND object_id = p_project_list(i);
1520:

Line 1534: SELECT pa_perf_kpa_summary_s1.nextval

1530: IF P_PA_DEBUG_MODE = 'Y' THEN
1531: PA_DEBUG.write_file('LOG', 'Project ID : '||p_project_list(i));
1532: END IF;
1533:
1534: SELECT pa_perf_kpa_summary_s1.nextval
1535: INTO l_summary_seq
1536: FROM DUAL;
1537:
1538:

Line 1560: --- record in PA_PERF_KPA_SUMMARY later on

1556:
1557: IF (l_kpa_rule_id IS NULL) THEN
1558: --- there is no exception transactions for this KPA Code
1559: --- , we still need to create a
1560: --- record in PA_PERF_KPA_SUMMARY later on
1561:
1562:
1563: l_summary_table(j).kpa_code := l_kpas(j);
1564: l_summary_table(j).indicator_code := null;

Line 1584: SELECT pa_perf_kpa_summary_det_s1.NEXTVAL

1580: CLOSE get_score_rule;
1581:
1582: IF (l_rule_id IS NOT NULL) THEN
1583:
1584: SELECT pa_perf_kpa_summary_det_s1.NEXTVAL
1585: INTO l_summary_det_seq
1586: FROM dual;
1587:
1588: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 1589: PA_DEBUG.write_file('LOG', 'Inserting into PA_PERF_KPA_SUMMARY_DET');

1585: INTO l_summary_det_seq
1586: FROM dual;
1587:
1588: IF P_PA_DEBUG_MODE = 'Y' THEN
1589: PA_DEBUG.write_file('LOG', 'Inserting into PA_PERF_KPA_SUMMARY_DET');
1590: PA_DEBUG.write_file('LOG', 'KPA code : '||l_kpas(j));
1591: PA_DEBUG.write_file('LOG', 'Rule ID : '||l_rule_id);
1592: END IF;
1593:

Line 1594: INSERT INTO pa_perf_kpa_summary_det

1590: PA_DEBUG.write_file('LOG', 'KPA code : '||l_kpas(j));
1591: PA_DEBUG.write_file('LOG', 'Rule ID : '||l_rule_id);
1592: END IF;
1593:
1594: INSERT INTO pa_perf_kpa_summary_det
1595: (
1596: kpa_summary_det_id,
1597: kpa_summary_id,
1598: object_type,

Line 1672: --- save the result into PA_PERF_KPA_SUMMARY_DET table

1668: l_retcode);
1669:
1670: IF (l_retcode = 1 ) THEN
1671: --- if we find a matching threshold
1672: --- save the result into PA_PERF_KPA_SUMMARY_DET table
1673:
1674: l_score_list.DELETE;
1675: l_count_list.DELETE;
1676:

Line 1692: SELECT pa_perf_kpa_summary_det_s1.NEXTVAL

1688:
1689: END LOOP;
1690:
1691:
1692: SELECT pa_perf_kpa_summary_det_s1.NEXTVAL
1693: INTO l_summary_det_seq
1694: FROM dual;
1695:
1696: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 1697: PA_DEBUG.write_file('LOG', 'Inserting into PA_PERF_KPA_SUMMARY_DET');

1693: INTO l_summary_det_seq
1694: FROM dual;
1695:
1696: IF P_PA_DEBUG_MODE = 'Y' THEN
1697: PA_DEBUG.write_file('LOG', 'Inserting into PA_PERF_KPA_SUMMARY_DET');
1698: PA_DEBUG.write_file('LOG', 'KPA code : '||l_kpas(j));
1699: PA_DEBUG.write_file('LOG', 'Rule ID : '||l_kpa_rule_id);
1700: END IF;
1701:

Line 1702: INSERT INTO pa_perf_kpa_summary_det

1698: PA_DEBUG.write_file('LOG', 'KPA code : '||l_kpas(j));
1699: PA_DEBUG.write_file('LOG', 'Rule ID : '||l_kpa_rule_id);
1700: END IF;
1701:
1702: INSERT INTO pa_perf_kpa_summary_det
1703: (
1704: kpa_summary_det_id,
1705: kpa_summary_id,
1706: object_type,

Line 1825: SELECT pa_perf_kpa_summary_det_s1.NEXTVAL

1821:
1822: END LOOP;
1823:
1824:
1825: SELECT pa_perf_kpa_summary_det_s1.NEXTVAL
1826: INTO l_summary_det_seq
1827: FROM dual;
1828:
1829: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 1830: PA_DEBUG.write_file('LOG', 'Inserting into PA_PERF_KPA_SUMMARY_DET');

1826: INTO l_summary_det_seq
1827: FROM dual;
1828:
1829: IF P_PA_DEBUG_MODE = 'Y' THEN
1830: PA_DEBUG.write_file('LOG', 'Inserting into PA_PERF_KPA_SUMMARY_DET');
1831: PA_DEBUG.write_file('LOG', 'KPA code : '||l_kpas(j));
1832: PA_DEBUG.write_file('LOG', 'Rule ID : '||l_kpa_rule_id);
1833: END IF;
1834:

Line 1835: INSERT INTO pa_perf_kpa_summary_det

1831: PA_DEBUG.write_file('LOG', 'KPA code : '||l_kpas(j));
1832: PA_DEBUG.write_file('LOG', 'Rule ID : '||l_kpa_rule_id);
1833: END IF;
1834:
1835: INSERT INTO pa_perf_kpa_summary_det
1836: (
1837: kpa_summary_det_id,
1838: kpa_summary_id,
1839: object_type,

Line 1959: -- create the record in PA_PERF_KPA_SUMMARY

1955: l_summary_table(i).thres_to := NULL;
1956: END LOOP;
1957:
1958: END IF;
1959: -- create the record in PA_PERF_KPA_SUMMARY
1960: INSERT INTO pa_perf_kpa_summary
1961: (
1962: kpa_summary_id,
1963: object_type,

Line 1960: INSERT INTO pa_perf_kpa_summary

1956: END LOOP;
1957:
1958: END IF;
1959: -- create the record in PA_PERF_KPA_SUMMARY
1960: INSERT INTO pa_perf_kpa_summary
1961: (
1962: kpa_summary_id,
1963: object_type,
1964: object_id,

Line 2053: from pa_perf_kpa_summary ppks, pa_perf_kpa_summary_det ppkd,

2049: AND included_in_scoring = 'Y'
2050: AND perf_txn_id NOT IN
2051: (
2052: select ppkt.perf_txn_id
2053: from pa_perf_kpa_summary ppks, pa_perf_kpa_summary_det ppkd,
2054: pa_perf_kpa_trans ppkt
2055: where ppks.object_type = 'PA_PROJECTS' and
2056: ppks.object_id = p_project_list(i)
2057: and ppks.current_flag = 'Y'