TRIGGER: APPS.GMA_MR_TEXT_TBL_T1

Source

Description

GMA_MR_TEXT_TBL_T1
instead of insert on MR_TEXT_TBL_VL
referencing new as MR_TEXT_TBL
for each row

Type

INSTEAD OF

Event

INSERT

Column

When

Referencing

REFERENCING NEW AS MR_TEXT_TBL OLD AS OLD

Body

declare
  row_id rowid;
begin
  GMA_MR_TEXT_TBL_PKG.INSERT_ROW(
    X_ROWID => ROW_ID,
    X_TEXT_CODE => :MR_TEXT_TBL.TEXT_CODE,
    X_LANG_CODE => :MR_TEXT_TBL.LANG_CODE,
    X_PARAGRAPH_CODE => :MR_TEXT_TBL.PARAGRAPH_CODE,
    X_SUB_PARACODE => :MR_TEXT_TBL.SUB_PARACODE,
    X_LINE_NO => :MR_TEXT_TBL.LINE_NO,
    X_TEXT => :MR_TEXT_TBL.TEXT,
    X_CREATION_DATE => :MR_TEXT_TBL.CREATION_DATE,
    X_CREATED_BY => :MR_TEXT_TBL.CREATED_BY,
    X_LAST_UPDATE_DATE => :MR_TEXT_TBL.LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY => :MR_TEXT_TBL.LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN => :MR_TEXT_TBL.LAST_UPDATE_LOGIN);
end INSERT_ROW;