TRIGGER: APPS.INSTEAD_OF_UPDATE

Source

Description

instead_of_update
  INSTEAD OF UPDATE ON GMD_TECHNICAL_DATA_VL
  REFERENCING NEW AS NEW OLD AS OLD
  FOR EACH ROW

Type

INSTEAD OF

Event

UPDATE

Column

When

Referencing

REFERENCING NEW AS NEW OLD AS OLD

Body

BEGIN
	UPDATE gmd_technical_data_hdr
	  SET ORGN_CODE = NVL(:NEW.LAB_TYPE, ORGN_CODE);
END instead_of_update;