[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;