[Home] [Help]
156: exception
157:
158: when NO_DATA_FOUND then
159:
160: select ALR_RESPONSE_VARIABLES_S.nextval into l_variable_number from dual;
161:
162: ALR_RESPONSE_VARIABLES_PKG.INSERT_ROW(
163: X_ROWID => l_row_id,
164: X_APPLICATION_ID => l_app_id,
252: X_LAST_UPDATED_BY in NUMBER,
253: X_LAST_UPDATE_LOGIN in NUMBER
254: ) is
255: begin
256: update ALR_RESPONSE_VARIABLES set
257: TYPE = X_TYPE,
258: DEFAULT_VALUE = X_DEFAULT_VALUE,
259: DATA_TYPE = X_DATA_TYPE,
260: DETAIL_MAX_LEN = X_DETAIL_MAX_LEN,