Create a Trigger on FND_FLEX_VALUES table

Hi Team:

We need to create a trigger in the fnd_flex_vale table, to disable the attribute21 field when it is a record update. And enable it if the value_name exists is active on another list of values.

----------------------------------------

RDBMS : 11.2.0.3.0

Oracle Applications : 12.1.3

1- Can we do it??

2- This would be our trigger script, we will appreciate if you confirm if there is an error.

DROP TRIGGER XXAPPS.XXFND_ACTUALIZAR_RAMO_FF

CREATE OR REPLACE TRIGGER XXAPPS.XXFND_ACTUALIZAR_RAMO_FF

                 BEFORE     UPDATE

                 ON         APPLSYS.FND_FLEX_VALUES

                 REFERENCING NEW AS NEW OLD AS OLD

                 FOR        EACH ROW