TRIGGER: APPS.IEB_SVC_PLAN_DELETE_ALERT

Source

Description

"APPS"."IEB_SVC_PLAN_DELETE_ALERT" 
 AFTER DELETE

 ON  "IEB"."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;