DBA Data[Home] [Help]

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,