AFTER UPDATE Trigger not firing
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