APPS.PA_EXCEPTION_ENGINE_PKG dependencies on PA_PERF_KPA_TRANS

Line 1222: DELETE from pa_perf_kpa_trans

1218: AND trunc(creation_date) < trunc(sysdate - p_days_old)
1219: AND current_flag = 'N');
1220:
1221: /*** clean up the the KPA Scoring Summary ***/
1222: DELETE from pa_perf_kpa_trans
1223: WHERE perf_txn_id in (SELECT perf_txn_id
1224: FROM pa_perf_transactions
1225: WHERE perf_txn_obj_type = 'PA_PROJECTS'
1226: AND perf_txn_obj_id = p_project_list(i)

Line 1758: --- save the result to PA_PERF_KPA_TRANS table

1754: fnd_global.login_id
1755:
1756: );
1757:
1758: --- save the result to PA_PERF_KPA_TRANS table
1759: IF P_PA_DEBUG_MODE = 'Y' THEN
1760: PA_DEBUG.write_file('LOG', 'Inserting into PA_PERF_KPA_TRANS');
1761: END IF;
1762:

Line 1760: PA_DEBUG.write_file('LOG', 'Inserting into PA_PERF_KPA_TRANS');

1756: );
1757:
1758: --- save the result to PA_PERF_KPA_TRANS table
1759: IF P_PA_DEBUG_MODE = 'Y' THEN
1760: PA_DEBUG.write_file('LOG', 'Inserting into PA_PERF_KPA_TRANS');
1761: END IF;
1762:
1763: INSERT INTO pa_perf_kpa_trans
1764: (kpa_summary_det_id,

Line 1763: INSERT INTO pa_perf_kpa_trans

1759: IF P_PA_DEBUG_MODE = 'Y' THEN
1760: PA_DEBUG.write_file('LOG', 'Inserting into PA_PERF_KPA_TRANS');
1761: END IF;
1762:
1763: INSERT INTO pa_perf_kpa_trans
1764: (kpa_summary_det_id,
1765: perf_txn_id,
1766: creation_date,
1767: created_by ,

Line 1890: --- save the result to PA_PERF_KPA_TRANS table

1886: fnd_global.user_id,
1887: fnd_global.login_id
1888: );
1889:
1890: --- save the result to PA_PERF_KPA_TRANS table
1891: INSERT INTO pa_perf_kpa_trans
1892: (kpa_summary_det_id,
1893: perf_txn_id,
1894: creation_date,

Line 1891: INSERT INTO pa_perf_kpa_trans

1887: fnd_global.login_id
1888: );
1889:
1890: --- save the result to PA_PERF_KPA_TRANS table
1891: INSERT INTO pa_perf_kpa_trans
1892: (kpa_summary_det_id,
1893: perf_txn_id,
1894: creation_date,
1895: created_by ,

Line 2054: pa_perf_kpa_trans ppkt

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'
2058: and ppks.kpa_summary_id = ppkd.kpa_summary_id