APPS.ALR_RESPONSE_SETS_PKG dependencies on ALR_RESPONSE_SETS_S
Line 145: select ALR_RESPONSE_SETS_S.nextval into l_resp_set_id from DUAL;
141: exception
142:
143: when NO_DATA_FOUND then
144: 145: select ALR_RESPONSE_SETS_S.nextval into l_resp_set_id from DUAL; 146:
147: ALR_RESPONSE_SETS_PKG.INSERT_ROW(
148: X_ROWID => l_row_id,
149: X_APPLICATION_ID => l_app_id,
Line 222: update ALR_RESPONSE_SETS set
218: X_LAST_UPDATED_BY in NUMBER,
219: X_LAST_UPDATE_LOGIN in NUMBER
220: ) is
221: begin 222: update ALR_RESPONSE_SETS set 223: NAME = X_NAME,
224: DESCRIPTION = X_DESCRIPTION,
225: ENABLED_FLAG = X_ENABLED_FLAG,
226: END_DATE_ACTIVE = X_END_DATE_ACTIVE,