DBA Data[Home] [Help]

TRIGGER: APPS.FEM_BUS_TYPE_CD_DL

Source

Description
FEM_BUS_TYPE_CD_DL
instead of delete on FEM_BUS_TYPE_CD_VL
referencing old as FEM_BUS_TYPE_CD_B
for each row
Type
INSTEAD OF
Event
DELETE
Column
When
Referencing
REFERENCING NEW AS NEW OLD AS FEM_BUS_TYPE_CD_B
Body
begin
  FEM_BUS_TYPE_CD_PKG.DELETE_ROW(
    X_BUS_TYPE_CD_CODE => :FEM_BUS_TYPE_CD_B.BUS_TYPE_CD_CODE);
 ---
end DELETE_ROW;
 ---