CREATE  OR REPLACE  TRIGGER PSD_LOCATIONS_update
 AFTER update
 ON maximo.LOCATIONS  FOR EACH ROW
 DECLARE
v_is_exist PLS_INTEGER;
 BEGIN
SELECT count(*)
  into v_is_exist
  FROM CLASSSTRUCTURE  WHERE CLASSIFICATIONID IN ('PSD') and CLASSSTRUCTUREID=:NEW.CLASSSTRUCTUREID ;
	 IF  v_is_exist >0 
THEN 
delete maximo.ODK_LOCATIONS where LOCATIONSID=:new.LOCATIONSID;
 
INSERT INTO maximo.PSD_LOCATIONS (LOCATION)
values (:NEW.LOCATION);
end if; 
 END;


CREATE  OR REPLACE  TRIGGER PSD_LOCATIONS_delete
 AFTER delete
 ON maximo.LOCATIONS  FOR EACH ROW
 DECLARE
 v_is_exist PLS_INTEGER;
 BEGIN
SELECT count(*)
  into v_is_exist
  FROM CLASSSTRUCTURE  WHERE CLASSIFICATIONID IN ('PSD') and CLASSSTRUCTUREID=:old.CLASSSTRUCTUREID ;
	 IF  v_is_exist >0 
THEN 	 
delete maximo.PSD_LOCATIONS where LOCATIONSID=:old.LOCATIONSID;
end if; 
 END;

...
END;
/
...
END;
/