DBA Data[Home] [Help]

TRIGGER: APPS.GMD_FORMULA_CLASS_UL

Source

Description
GMD_FORMULA_CLASS_UL
/* $Header: gmdfcutg.sql 120.1 2005/06/09 05:11:01 appldev  $ */
instead of update on GMD_FORMULA_CLASS_VL
referencing new as FM_FORM_CLS
for each row
Type
INSTEAD OF
Event
UPDATE
Column
When
Referencing
REFERENCING NEW AS FM_FORM_CLS OLD AS OLD
Body
begin
  GMD_FORMULA_CLASS_PKG.UPDATE_ROW(
    X_FORMULA_CLASS => :FM_FORM_CLS.FORMULA_CLASS,
    X_TRANS_CNT => :FM_FORM_CLS.TRANS_CNT,
    X_DELETE_MARK => :FM_FORM_CLS.DELETE_MARK,
    X_TEXT_CODE => :FM_FORM_CLS.TEXT_CODE,
    X_FORMULA_CLASS_DESC => :FM_FORM_CLS.FORMULA_CLASS_DESC,
    X_LAST_UPDATE_DATE => :FM_FORM_CLS.LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY => :FM_FORM_CLS.LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN => :FM_FORM_CLS.LAST_UPDATE_LOGIN);
end UPDATE_ROW;