APPS.ALR_RESPONSE_VARIABLES_PKG dependencies on ALR_RESPONSE_VARIABLES_S
Line 160: select ALR_RESPONSE_VARIABLES_S.nextval into l_variable_number from dual;
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,
Line 256: update ALR_RESPONSE_VARIABLES set
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,