APPS.ALR_ALERTS_PKG dependencies on ALR_ALERTS_S

Line 246: select ALR_ALERTS_S.nextval into l_alert_id from dual;

242:
243: exception
244: when NO_DATA_FOUND then
245:
246: select ALR_ALERTS_S.nextval into l_alert_id from dual;
247:
248: ALR_ALERTS_PKG.INSERT_ROW(
249: X_ROWID => l_row_id,
250: X_APPLICATION_ID => l_app_id,

Line 449: update ALR_ALERTS set

445: X_LAST_UPDATED_BY in NUMBER,
446: X_LAST_UPDATE_LOGIN in NUMBER
447: ) is
448: begin
449: update ALR_ALERTS set
450: ALERT_NAME = X_ALERT_NAME,
451: ALERT_CONDITION_TYPE = X_ALERT_CONDITION_TYPE,
452: ENABLED_FLAG = X_ENABLED_FLAG,
453: START_DATE_ACTIVE = X_START_DATE_ACTIVE,