Rem
Rem $Header: severity_triggers_dbconsole.sql 31-jan-2005.17:59:26 streddy Exp $
Rem
Rem severity_triggers_dbconsole.sql
Rem
Rem Copyright (c) 2005, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      severity_triggers_dbconsole.sql - <one-line expansion of the name>
Rem
Rem    DESCRIPTION
Rem      <short description of component this file declares/defines>
Rem
Rem    NOTES
Rem      <other useful comments, qualifications, etc.>
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    streddy     01/31/05 - streddy_bug-3209640
Rem    streddy     01/31/05 - Created
Rem


-- Statement level trigger to synchronously evaluate 
-- availability in SA mode
CREATE OR REPLACE TRIGGER em_violation_stmt_ins
  AFTER INSERT ON mgmt_violations
BEGIN

   IF (EMD_MAINTENANCE.IS_CENTRAL_MODE = 0 AND
       em_severity.P_LAST_TARGET_GUID IS NOT NULL) THEN
     em_severity_repos.sync_eval_parent_severities(
                       em_severity.P_LAST_TARGET_GUID);
     em_severity.P_LAST_TARGET_GUID := NULL;
   END IF;

END;
/
show errors;