TRIGGER: APPS.IEB_WBSTSCM_DELETE_ALERT

Source

Description

IEB_WBSTSCM_DELETE_ALERT
 AFTER DELETE
 ON IEB_WBST_WB_SC_RULES
 FOR EACH ROW

Type

AFTER EACH ROW

Event

DELETE

Column

When

Referencing

REFERENCING NEW AS NEW OLD AS OLD

Body

BEGIN
DBMS_ALERT.SIGNAL('IEB_WBSTSCM_DELETE_ALERT', CONCAT(TO_CHAR(:old.WBSKTR_WBSKTR_ID), CONCAT(':', TO_CHAR(:old.WBSCRULE_WBSCRULE_ID))));
END IEB_WBSTSCM_DELETE_ALERT;