DBA Data[Home] [Help]

APPLSYS.DR$FND_ETRM_FILE_DESCTC dependencies on DRVDML

Line 1: trigger "APPLSYS"."DR$FND_ETRM_FILE_DESCTC" after insert or update on "APPLSYS"."FND_ETRM_FILES" for each row 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;

1: trigger "APPLSYS"."DR$FND_ETRM_FILE_DESCTC" after insert or update on "APPLSYS"."FND_ETRM_FILES" for each row 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;