TRIGGER: APPS.IEB_WB_SERVERS_ALERT

Source

Description

"APPS"."IEB_WB_SERVERS_ALERT" 
 AFTER UPDATE OF LAST_UPDATE_DATE, AUTO_SHUT_DOWN_Y_N,
 STAT_DUMP_SUNDAY_Y_N, LAST_UPDATE_LOGIN, AUTO_SHUT_DOWN_TIME_HHMM,
 STAT_DUMP_MONDAY_Y_N, VIRTUAL_Q_CLEANUP_SIZE, STAT_DUMP_TUESDAY_Y_N,
 WB_SERVER_NAME, WORK_QUEUE_CACHE_SIZE, STAT_DUMP_WEDNESDAY_Y_N, LOG_FILE_NAME,
 LOG_DBC_FILE_NAME, TRACE_FILE_NAME, STAT_DUMP_THURSDAY_Y_N, WB_SERVER_TYPE,
 STAT_DUMP_FRIDAY_Y_N, STAT_DUMP_SATURDAY_Y_N, STAT_DUMP_BEG_TIME_HHMM, STAT_DUMP_END_TIME_HHMM,
 DAILY_CLEANUP_Y_N, CCI_DBC_FILE_NAME, WBSVR_ID, LAST_UPDATED_BY, CLEANUP_TIME_HHMM

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

Type

AFTER EACH ROW

Event

UPDATE

Column

When

Referencing

REFERENCING NEW AS NEW OLD AS OLD

Body

BEGIN
DBMS_ALERT.SIGNAL('IEB_WB_SERVERS_ALERT', TO_CHAR(:new.WBSVR_ID));
END IEB_WB_SERVERS_ALERT;