TRIGGER: HR.DR$PER_ADDRESSES_N4TC

Source

Description

"HR"."DR$PER_ADDRESSES_N4TC" after insert or update on "HR"."PER_ADDRESSES" 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('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;