DBA Data[Home] [Help]

HR.DR$PER_ADDRESSES_N4TC dependencies on DRVDML

Line 1: trigger "HR"."DR$PER_ADDRESSES_N4TC" after insert or update on "HR"."PER_ADDRESSES" 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('DERIVED_LOCALE')) then reindex := TRUE; updop := (not inserting); ctxsys.drvdml.c_text_vc2 := :new."DERIVED_LOCALE"; end if; ctxsys.drvdml.ctxcat_dml('HR','PER_ADDRESSES_N4', reindex, updop); end;

1: trigger "HR"."DR$PER_ADDRESSES_N4TC" after insert or update on "HR"."PER_ADDRESSES" 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('DERIVED_LOCALE')) then reindex := TRUE; updop := (not inserting); ctxsys.drvdml.c_text_vc2 := :new."DERIVED_LOCALE"; end if; ctxsys.drvdml.ctxcat_dml('HR','PER_ADDRESSES_N4', reindex, updop); end;