TRIGGER: APPS.FEM_DIMENSIONS_UL

Source

Description

FEM_DIMENSIONS_UL
instead of update on FEM_DIMENSIONS_VL
referencing new as DIMENSION
for each row

Type

INSTEAD OF

Event

UPDATE

Column

When

Referencing

REFERENCING NEW AS DIMENSION OLD AS OLD

Body

begin
  FEM_DIMENSIONS_PKG.UPDATE_ROW(
    X_DIMENSION_ID => :DIMENSION.DIMENSION_ID,
    X_OBJECT_VERSION_NUMBER => :DIMENSION.OBJECT_VERSION_NUMBER,
    X_DIMENSION_VARCHAR_LABEL => :DIMENSION.DIMENSION_VARCHAR_LABEL,
    X_DIM_OWNER_APPLICATION_ID => :DIMENSION.DIM_OWNER_APPLICATION_ID,
    X_DIMENSION_NAME => :DIMENSION.DIMENSION_NAME,
    X_DESCRIPTION => :DIMENSION.DESCRIPTION,
    X_LAST_UPDATE_DATE => :DIMENSION.LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY => :DIMENSION.LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN => :DIMENSION.LAST_UPDATE_LOGIN);
 ---
end UPDATE_ROW;
 ---