TRIGGER: APPS.GMD_ROUTINGS_DL

Source

Description

GMD_ROUTINGS_DL
/* $Header: gmdrtdtg.sql 120.3 2011/03/08 16:29:30 plowe ship $ */
instead of delete on GMD_ROUTINGS_VL
referencing old as FM_ROUT_HDR
for each row

Type

INSTEAD OF

Event

DELETE

Column

When

Referencing

REFERENCING NEW AS NEW OLD AS FM_ROUT_HDR

Body

begin
  GMD_ROUTINGS_PKG.DELETE_ROW(
    X_ROUTING_ID => :FM_ROUT_HDR.ROUTING_ID);
end DELETE_ROW;