DBA Data[Home] [Help]

APPS.ALR_ACTION_SETS_PKG dependencies on ALR_ACTION_SETS_S

Line 153: select alr_action_sets_s.nextval into l_action_set_id from dual;

149: exception
150:
151: when NO_DATA_FOUND then
152:
153: select alr_action_sets_s.nextval into l_action_set_id from dual;
154:
155: ALR_ACTION_SETS_PKG.INSERT_ROW(
156: X_ROWID => l_row_id,
157: X_APPLICATION_ID => l_app_id,

Line 250: update ALR_ACTION_SETS set

246: X_LAST_UPDATED_BY in NUMBER,
247: X_LAST_UPDATE_LOGIN in NUMBER
248: ) is
249: begin
250: update ALR_ACTION_SETS set
251: NAME = X_NAME,
252: ALERT_ID = X_ALERT_ID,
253: END_DATE_ACTIVE = X_END_DATE_ACTIVE,
254: ENABLED_FLAG = X_ENABLED_FLAG,