TRIGGER: APPS.XDO_DS_DEFINITIONS_IL

Source

Description

XDO_DS_DEFINITIONS_IL
instead of insert on XDO_DS_DEFINITIONS_VL
referencing new as XDO_DS_DEFINITION_TH
for each row

Type

INSTEAD OF

Event

INSERT

Column

When

Referencing

REFERENCING NEW AS XDO_DS_DEFINITION_TH OLD AS OLD

Body

declare
  row_id rowid;
begin
  XDO_DS_DEFINITIONS_PKG.INSERT_ROW(
      X_ROWID                 => row_id,
      X_APPLICATION_SHORT_NAME        => :XDO_DS_DEFINITION_TH.APPLICATION_SHORT_NAME,
      X_DATA_SOURCE_CODE        => :XDO_DS_DEFINITION_TH.DATA_SOURCE_CODE,
      X_DATA_SOURCE_STATUS      => :XDO_DS_DEFINITION_TH.DATA_SOURCE_STATUS,
      X_START_DATE            => :XDO_DS_DEFINITION_TH.START_DATE,
      X_END_DATE              => :XDO_DS_DEFINITION_TH.END_DATE,
      X_OBJECT_VERSION_NUMBER => :XDO_DS_DEFINITION_TH.OBJECT_VERSION_NUMBER,
      X_ATTRIBUTE_CATEGORY    => :XDO_DS_DEFINITION_TH.ATTRIBUTE_CATEGORY,
      X_ATTRIBUTE1            => :XDO_DS_DEFINITION_TH.ATTRIBUTE1,
      X_ATTRIBUTE2            => :XDO_DS_DEFINITION_TH.ATTRIBUTE2,
      X_ATTRIBUTE3            => :XDO_DS_DEFINITION_TH.ATTRIBUTE3,
      X_ATTRIBUTE4            => :XDO_DS_DEFINITION_TH.ATTRIBUTE4,
      X_ATTRIBUTE5            => :XDO_DS_DEFINITION_TH.ATTRIBUTE5,
      X_ATTRIBUTE6            => :XDO_DS_DEFINITION_TH.ATTRIBUTE6,
      X_ATTRIBUTE7            => :XDO_DS_DEFINITION_TH.ATTRIBUTE7,
      X_ATTRIBUTE8            => :XDO_DS_DEFINITION_TH.ATTRIBUTE8,
      X_ATTRIBUTE9            => :XDO_DS_DEFINITION_TH.ATTRIBUTE9,
      X_ATTRIBUTE10           => :XDO_DS_DEFINITION_TH.ATTRIBUTE10,
      X_ATTRIBUTE11           => :XDO_DS_DEFINITION_TH.ATTRIBUTE11,
      X_ATTRIBUTE12           => :XDO_DS_DEFINITION_TH.ATTRIBUTE12,
      X_ATTRIBUTE13           => :XDO_DS_DEFINITION_TH.ATTRIBUTE13,
      X_ATTRIBUTE14           => :XDO_DS_DEFINITION_TH.ATTRIBUTE14,
      X_ATTRIBUTE15           => :XDO_DS_DEFINITION_TH.ATTRIBUTE15,
      X_DATA_SOURCE_NAME      => :XDO_DS_DEFINITION_TH.DATA_SOURCE_NAME,
      X_DESCRIPTION           => :XDO_DS_DEFINITION_TH.DESCRIPTION,
      X_CREATION_DATE         => :XDO_DS_DEFINITION_TH.CREATION_DATE,
      X_CREATED_BY            => :XDO_DS_DEFINITION_TH.CREATED_BY,
      X_LAST_UPDATE_DATE      => :XDO_DS_DEFINITION_TH.LAST_UPDATE_DATE,
      X_LAST_UPDATED_BY       => :XDO_DS_DEFINITION_TH.LAST_UPDATED_BY,
      X_LAST_UPDATE_LOGIN     => :XDO_DS_DEFINITION_TH.LAST_UPDATE_LOGIN
);
end INSERT_ROW;