TRIGGER: APPS.GMD_ACTIVITIES_UL

Source

Description

GMD_ACTIVITIES_UL
/* $Header: gmdatutg.sql 120.2 2011/03/07 20:17:35 plowe ship $ */
instead of update on GMD_ACTIVITIES_VL
referencing new as FM_ACTV_MST
for each row

Type

INSTEAD OF

Event

UPDATE

Column

When

Referencing

REFERENCING NEW AS FM_ACTV_MST OLD AS OLD

Body

begin
  GMD_ACTIVITIES_PKG.UPDATE_ROW(
    X_ACTIVITY => :FM_ACTV_MST.ACTIVITY,
    X_COST_ANALYSIS_CODE => :FM_ACTV_MST.COST_ANALYSIS_CODE,
    X_DELETE_MARK => :FM_ACTV_MST.DELETE_MARK,
    X_TEXT_CODE => :FM_ACTV_MST.TEXT_CODE,
    X_TRANS_CNT => :FM_ACTV_MST.TRANS_CNT,
    X_ACTIVITY_DESC => :FM_ACTV_MST.ACTIVITY_DESC,
    X_LAST_UPDATE_DATE => :FM_ACTV_MST.LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY => :FM_ACTV_MST.LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN => :FM_ACTV_MST.LAST_UPDATE_LOGIN);
end UPDATE_ROW;