TRIGGER: APPS.IEB_SVC_PLAN_DELETE_ALERT

Source

Description

IEB_SVC_PLAN_DELETE_ALERT
 AFTER DELETE
 ON IEB_SERVICE_PLANS
 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_SVC_PLAN_DELETE_ALERT', TO_CHAR(:old.SVCPLN_ID));
END IEB_SVC_PLAN_DELETE_ALERT;