DBA Data[Home] [Help]

TRIGGER: APPS.GML_OP_ORDR_STS_T3

Source

Description
GML_OP_ORDR_STS_T3
/* $Header: GMLOS3TG.sql 115.3 1999/11/10 12:48:23 pkm ship   $ */
instead of delete on OP_ORDR_STS_VL
referencing old as OP_ORDR_STS
for each row
Type
INSTEAD OF
Event
DELETE
Column
When
Referencing
REFERENCING NEW AS NEW OLD AS OP_ORDR_STS
Body
begin
  GML_OP_ORDR_STS_PKG.DELETE_ROW(
    X_ORDER_STATUS => :OP_ORDR_STS.ORDER_STATUS);
end DELETE_ROW;