TRIGGER: APPS.GMD_ROUTING_CLASS_IL

Source

Description

GMD_ROUTING_CLASS_IL
/* $Header: gmdrcitg.sql 120.3 2011/03/08 15:48:36 plowe ship $ */
instead of insert on GMD_ROUTING_CLASS_VL
referencing new as FM_ROUT_CLS
for each row

Type

INSTEAD OF

Event

INSERT

Column

When

Referencing

REFERENCING NEW AS FM_ROUT_CLS OLD AS OLD

Body

declare
  row_id rowid;
begin
  GMD_ROUTING_CLASS_PKG.INSERT_ROW(
    X_ROWID => ROW_ID,
    X_ROUTING_CLASS => :FM_ROUT_CLS.ROUTING_CLASS,
    X_TEXT_CODE => :FM_ROUT_CLS.TEXT_CODE,
    X_TRANS_CNT => :FM_ROUT_CLS.TRANS_CNT,
    X_DELETE_MARK => :FM_ROUT_CLS.DELETE_MARK,
    X_ROUTING_CLASS_UOM => :FM_ROUT_CLS.UOM,
    X_ROUTING_CLASS_DESC => :FM_ROUT_CLS.ROUTING_CLASS_DESC,
    X_CREATION_DATE => :FM_ROUT_CLS.CREATION_DATE,
    X_CREATED_BY => :FM_ROUT_CLS.CREATED_BY,
    X_LAST_UPDATE_DATE => :FM_ROUT_CLS.LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY => :FM_ROUT_CLS.LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN => :FM_ROUT_CLS.LAST_UPDATE_LOGIN);
end INSERT_ROW;