DBA Data[Home] [Help]

TRIGGER: APPS.GMA_SY_TEXT_TKN_T2

Source

Description
GMA_SY_TEXT_TKN_T2
instead of update on SY_TEXT_TKN_VL
referencing old as SY_TEXT_TKN
for each row
Type
INSTEAD OF
Event
UPDATE
Column
When
Referencing
REFERENCING NEW AS NEW OLD AS SY_TEXT_TKN
Body
begin
  GMA_SY_TEXT_TKN_PKG.UPDATE_ROW(
    X_TEXT_KEY => :SY_TEXT_TKN.TEXT_KEY,
    X_LANG_CODE => :SY_TEXT_TKN.LANG_CODE,
    X_TEXT_CODE => :SY_TEXT_TKN.TEXT_CODE,
    X_TOKEN_DESC => :SY_TEXT_TKN.TOKEN_DESC,
    X_LAST_UPDATE_DATE => :SY_TEXT_TKN.LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY => :SY_TEXT_TKN.LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN => :SY_TEXT_TKN.LAST_UPDATE_LOGIN);
end UPDATE_ROW;