TRIGGER: APPS.IEB_SERVICE_PLANS_ALERT

Source

Description

IEB_SERVICE_PLANS_ALERT
 AFTER INSERT OR UPDATE OF SVCPLN_ID, DIRECTION, TREATMENT, SERVICE_PLAN_NAME
 ON 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;