[Home] [Help]
TRIGGER: APPS.GMA_IN_TEXT_TBL_T1
Source
Description
GMA_IN_TEXT_TBL_T1
instead of insert on IN_TEXT_TBL_VL
referencing new as IN_TEXT_TBL
for each row
Type
INSTEAD OF
Event
INSERT
Column
When
Referencing
REFERENCING NEW AS IN_TEXT_TBL OLD AS OLD
Body
declare
row_id rowid;
begin
GMA_IN_TEXT_TBL_PKG.INSERT_ROW(
X_ROWID => ROW_ID,
X_TEXT_CODE => :IN_TEXT_TBL.TEXT_CODE,
X_LANG_CODE => :IN_TEXT_TBL.LANG_CODE,
X_PARAGRAPH_CODE => :IN_TEXT_TBL.PARAGRAPH_CODE,
X_SUB_PARACODE => :IN_TEXT_TBL.SUB_PARACODE,
X_LINE_NO => :IN_TEXT_TBL.LINE_NO,
X_TEXT => :IN_TEXT_TBL.TEXT,
X_CREATION_DATE => :IN_TEXT_TBL.CREATION_DATE,
X_CREATED_BY => :IN_TEXT_TBL.CREATED_BY,
X_LAST_UPDATE_DATE => :IN_TEXT_TBL.LAST_UPDATE_DATE,
X_LAST_UPDATED_BY => :IN_TEXT_TBL.LAST_UPDATED_BY,
X_LAST_UPDATE_LOGIN => :IN_TEXT_TBL.LAST_UPDATE_LOGIN);
end INSERT_ROW;