Why You dont try to create this trigger
with a when clause eg:

create or replace trigger YOUR_TRIGGER before update of status on AAAA
for each row
when (new.year=old.year and new.status = 1)
begin
-- your code here
end;


In last sample i've included then column status in before clause, but, i believe, to fire a trigger only in the records you want, You need to like this sample.

Silas - [email protected]
---------------------------------------