Untitled

CREATE OR REPLACE TRIGGER TRG_ELE_LAST_UPDATED_BY

AFTER INSERT OR UPDATE ON

ERROR_LEVEL

FOR EACH ROW

BEGIN

IF (:new.last_updated_by IS NOT NULL AND (INSERTING OR

(:new.last_updated_by !=:old.last_updated_by)))

THEN

syn_pkg_lkp_contact.check_RI(:new.last_updated_by);

END IF;