[Home] [Help]
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,
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,