PL/SQL (MOSC)

MOSC Banner

AFTER UPDATE Trigger not firing

edited Mar 25, 2014 8:58AM in PL/SQL (MOSC) 3 commentsAnswered

Hi

I have the following 2 triggers, the 'after insert' trigger fires and a new record is created on the custom table, however, the 'after update' trigger does not appear to fire - I have tried removing the majority of the code (including the when clause), just leaving in the call to 'xxhr_pay_changes_pkg.createMostCurrentRecord' but it still doesn't appear to fire.

create or replace TRIGGER APPS.xxhr_pay_peit_air
AFTER INSERT
ON PER_PEOPLE_EXTRA_INFO
FOR EACH ROW
WHEN (
      NVL(:NEW.PEI_INFORMATION_TYPE,'?') = 'XXHR_PASSPORT'
      )
DECLARE

   CURSOR c_get_bg_id (cp_person_id      IN NUMBER

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center