Oracle Version : 10g

As you know inside a Oracle row trigger you cannot access to the base table, for example when you make a trigger like this, on a table named “activity“.

CREATE OR REPLACE TRIGGER IFABER.ACTIVITY_FK_MENU_INTEGRITY
AFTER INSERT OR UPDATE
ON IFABER.ACTIVITY
REFERENCING NEW AS New OLD AS Old
FOR EACH ROW
DECLARE

tmpVar NUMBER;
e_Menu_Already_Exists EXCEPTION;

/******************************************************************************
NAME:
[...]