TRIGGER: APPS.IEB_SERVICE_PLANS_ALERT

Source

Description

"APPS"."IEB_SERVICE_PLANS_ALERT" 
 AFTER INSERT OR UPDATE OF SVCPLN_ID, DIRECTION, TREATMENT, SERVICE_PLAN_NAME

 ON  "IEB"."IEB_SERVICE_PLANS#"   FOR EACH ROW

Type

AFTER EACH ROW

Event

INSERT OR UPDATE

Column

When

Referencing

REFERENCING NEW AS NEW OLD AS OLD

Body

BEGIN
DBMS_ALERT.SIGNAL('IEB_SERVICE_PLANS_ALERT', TO_CHAR(:new.SVCPLN_ID));
END IEB_SERVICE_PLANS_ALERT;