APPS.AMW_PROCESS_CERT_SUMMARY dependencies on AMW_CERT_DASHBOARD_SUM

Line 1324: UPDATE AMW_CERT_DASHBOARD_SUM

1320: FETCH orgs_pending_cert INTO l_orgs_pending_cert;
1321: CLOSE orgs_pending_cert;
1322: fnd_file.put_line(fnd_file.LOG, 'after orgs_pending_cert:'||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));
1323:
1324: UPDATE AMW_CERT_DASHBOARD_SUM
1325: SET NEW_RISKS_ADDED = l_new_risks_added,
1326: NEW_CONTROLS_ADDED = l_new_controls_added,
1327: PROCESSES_NOT_CERT = l_global_proc_not_certified,
1328: PROCESSES_CERT_ISSUES = l_global_proc_with_issue,

Line 1345: INSERT INTO AMW_CERT_DASHBOARD_SUM (

1341: ORGS_PENDING_CERTIFICATION = l_orgs_pending_cert
1342: WHERE certification_id = p_certification_id;
1343:
1344: IF (SQL%NOTFOUND) THEN
1345: INSERT INTO AMW_CERT_DASHBOARD_SUM (
1346: CERTIFICATION_ID,
1347: NEW_RISKS_ADDED,
1348: NEW_CONTROLS_ADDED,
1349: PROCESSES_NOT_CERT,