TRIGGER: APPS.IEB_WB_SC_RULES_ALERT

Source

Description

IEB_WB_SC_RULES_ALERT
 AFTER INSERT OR UPDATE OF WBSC_WBSC_ID, CLASSIFICATION, WBSCRULE_ID, ARRIVAL_ADDRESS, RULE_TYPE, SKILL_INCLUDED_Y_N
 ON IEB_WB_SVC_CAT_RULES
 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_WB_SC_RULES_ALERT',TO_CHAR(:new.WBSCRULE_ID));
END IEB_WB_SC_RULES_ALERT;