TRIGGER: APPS.AP_MAP_TYPES_IL

Source

Description

AP_MAP_TYPES_IL
instead of insert on AP_MAP_TYPES_VL
referencing new as MAP
for each row

Type

INSTEAD OF

Event

INSERT

Column

When

Referencing

REFERENCING NEW AS MAP OLD AS OLD

Body

declare
  row_id rowid;
begin
  AP_MAP_TYPES_PKG.INSERT_ROW(
    X_ROWID => ROW_ID,
    X_MAP_TYPE_CODE => :MAP.MAP_TYPE_CODE,
    X_FROM_APPLICATION_ID => :MAP.FROM_APPLICATION_ID,
    X_FROM_LOOKUP_TYPE => :MAP.FROM_LOOKUP_TYPE,
    X_TO_APPLICATION_ID => :MAP.TO_APPLICATION_ID,
    X_TO_LOOKUP_TYPE => :MAP.TO_LOOKUP_TYPE,
    X_DEFAULT_LOOKUP_CODE => :MAP.DEFAULT_LOOKUP_CODE,
    X_MEANING => :MAP.MEANING,
    X_DESCRIPTION => :MAP.DESCRIPTION,
    X_CREATION_DATE => :MAP.CREATION_DATE,
    X_CREATED_BY => :MAP.CREATED_BY,
    X_LAST_UPDATE_DATE => :MAP.LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY => :MAP.LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN => :MAP.LAST_UPDATE_LOGIN);
end INSERT_ROW;