TRG_SALE_ORDER_ITEMS

<DEFAULT SERVER>   >   <DEFAULT DATABASE>   >   <DEFAULT SCHEMA>   >   TRG_SALE_ORDER_ITEMS

Simple Trigger of BEFORE "DELETE on sales_order_items"

CREATE OR REPLACE TRIGGER TRG_Sale_ORDER_Items BEFORE DELETE on sales_order_items

DECLARE

begin
  AppLogPk.LogDeletingSalesOrderItem(:new.Id);

end

Name	Types	Description
<DEFAULT SCHEMA>.APPLOGPK	Package	Package, Interface
<DEFAULT SCHEMA>.SALES_ORDER_ITEMS	Table	Table
<DEFAULT SCHEMA>.APPLOGPK.LogDeletingSalesOrderItem	Procedure	Procedure interface LogDeletingSalesOrderItem(saleOrderItemId NUMBER), Package APPLOGPK
<DEFAULT SCHEMA>.SALES_ORDER_ITEMS.ID	Primary Key	Column

Name	Types	Description
<DEFAULT SCHEMA>.SALEORDER.DeleteOrderItemById.Delete	Delete Statement	DELETE sales_order_items where id = orderId