[Home] [Help]
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;