TRIGGER: APPLSYS.DR$FND_ETRM_FILE_DESCTC

Source

Description

"APPLSYS"."DR$FND_ETRM_FILE_DESCTC" after insert or update on "APPLSYS"."FND_ETRM_FILES" for each row 

Type

AFTER EACH ROW

Event

INSERT OR UPDATE

Column

When

Referencing

REFERENCING NEW AS NEW OLD AS OLD

Body

declare   reindex boolean := FALSE;   updop   boolean := FALSE; begin   ctxsys.drvdml.c_updtab.delete;   ctxsys.drvdml.c_numtab.delete;   ctxsys.drvdml.c_vctab.delete;   ctxsys.drvdml.c_rowid := :new.rowid;   if (inserting or updating('DESCRIPTION')) then     reindex := TRUE;     updop := (not inserting);     ctxsys.drvdml.c_text_vc2 := :new."DESCRIPTION";   end if;   ctxsys.drvdml.ctxcat_dml('APPLSYS','FND_ETRM_FILE_DESC', reindex, updop); end;