XDO_TEMPLATES_DL
instead of delete on XDO_TEMPLATES_VL
referencing old as XDO_TEMPLATES_TABLE_HANDLER
for each row
Type
INSTEAD OF
Event
DELETE
Column
When
Referencing
REFERENCING NEW AS NEW OLD AS XDO_TEMPLATES_TABLE_HANDLER
Body
begin
XDO_TEMPLATES_PKG.DELETE_ROW(
X_APPLICATION_SHORT_NAME => :XDO_TEMPLATES_TABLE_HANDLER.APPLICATION_SHORT_NAME,
X_TEMPLATE_CODE => :XDO_TEMPLATES_TABLE_HANDLER.TEMPLATE_CODE);
end DELETE_ROW;