TRIGGER: APPS.GMA_SY_TEXT_TBL_T2

Source

Description

GMA_SY_TEXT_TBL_T2
instead of update on SY_TEXT_TBL_VL
referencing old as SY_TEXT_TBL
for each row

Type

INSTEAD OF

Event

UPDATE

Column

When

Referencing

REFERENCING NEW AS NEW OLD AS SY_TEXT_TBL

Body

begin
  GMA_SY_TEXT_TBL_PKG.UPDATE_ROW(
    X_ROW_ID => :SY_TEXT_TBL.ROW_ID,
-- Bug #1806284 (JKB)
    X_TEXT_CODE => :SY_TEXT_TBL.TEXT_CODE,
    X_LANG_CODE => :SY_TEXT_TBL.LANG_CODE,
    X_PARAGRAPH_CODE => :SY_TEXT_TBL.PARAGRAPH_CODE,
    X_SUB_PARACODE => :SY_TEXT_TBL.SUB_PARACODE,
    X_LINE_NO => :SY_TEXT_TBL.LINE_NO,
    X_TEXT => :SY_TEXT_TBL.TEXT,
    X_LAST_UPDATE_DATE => :SY_TEXT_TBL.LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY => :SY_TEXT_TBL.LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN => :SY_TEXT_TBL.LAST_UPDATE_LOGIN);
end UPDATE_ROW;