GMD_ACTIVITIES_DL
/* $Header: gmdatdtg.sql 120.1 2005/06/09 05:06:42 appldev $ */
instead of delete on GMD_ACTIVITIES_VL
referencing old as FM_ACTV_MST
for each row
Type
INSTEAD OF
Event
DELETE
Column
When
Referencing
REFERENCING NEW AS NEW OLD AS FM_ACTV_MST
Body
begin
GMD_ACTIVITIES_PKG.DELETE_ROW(
X_ACTIVITY => :FM_ACTV_MST.ACTIVITY);
end DELETE_ROW;