APPS.PA_EXCEPTION_ENGINE_PKG dependencies on PA_PERF_KPA_SUMMARY_DET

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 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 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'