APPS.AMW_PROCESS_CERT_SUMMARY dependencies on AMW_PROC_CERT_EVAL_SUM

Line 690: UPDATE amw_proc_cert_eval_sum

686: p_certification_id,
687: null, null,
688: null, null);
689:
690: UPDATE amw_proc_cert_eval_sum
691: SET certification_opinion_id = l_certification_opinion_id,
692: evaluation_opinion_id = l_evaluation_opinion_id,
693: evaluation_opinion_log_id= l_evaluation_opinion_log_id,
694: unmitigated_risks = l_unmitigated_risks,

Line 723: INSERT INTO amw_proc_cert_eval_sum(certification_opinion_id,

719:
720: IF (SQL%NOTFOUND)
721: THEN
722:
723: INSERT INTO amw_proc_cert_eval_sum(certification_opinion_id,
724: evaluation_opinion_id,
725: evaluation_opinion_log_id,
726: unmitigated_risks,
727: evaluated_risks,

Line 817: FROM amw_proc_cert_eval_sum

813:
814: CURSOR get_specific_records
815: IS
816: SELECT last_update_date
817: FROM amw_proc_cert_eval_sum
818: WHERE certification_id = p_certification_id
819: FOR UPDATE NOWAIT;
820:
821:

Line 1005: --suggest to use amw_proc_cert_eval_sum instead of amw_execution_scope because it can sync with ProcCertIssuesVO definition.

1001: AND aov.pk3_value = aes.organization_id
1002: AND aov.pk2_value = p_certification_id
1003: AND aov.pk1_value = aes.process_id));
1004: --modified by dliao on 10.06.05, add distinct on select statement.
1005: --suggest to use amw_proc_cert_eval_sum instead of amw_execution_scope because it can sync with ProcCertIssuesVO definition.
1006:
1007: CURSOR global_proc_with_issue IS
1008: SELECT count(1)
1009: FROM (SELECT distinct aes.organization_id, aes.process_id

Line 1653: UPDATE amw_proc_cert_eval_sum

1649: p_certification_id,
1650: null, null,
1651: null, null);
1652:
1653: UPDATE amw_proc_cert_eval_sum
1654: SET open_findings = l_open_findings,
1655: open_issues = l_open_issues,
1656: last_update_date = SYSDATE,
1657: last_updated_by = G_USER_ID,