APPS.ALR_VALID_RESPONSES_PKG dependencies on ALR_VALID_RESPONSES_S
Line 148: select ALR_VALID_RESPONSES_S.nextval into l_response_id from DUAL;
144: exception
145:
146: when NO_DATA_FOUND then
147: 148: select ALR_VALID_RESPONSES_S.nextval into l_response_id from DUAL; 149:
150: ALR_VALID_RESPONSES_PKG.INSERT_ROW(
151: X_ROWID => l_row_id,
152: X_APPLICATION_ID => l_app_id,
Line 224: update ALR_VALID_RESPONSES set
220: X_LAST_UPDATED_BY in NUMBER,
221: X_LAST_UPDATE_LOGIN in NUMBER
222: ) is
223: begin 224: update ALR_VALID_RESPONSES set 225: TYPE = X_TYPE,
226: RESPONSE_TEXT = X_RESPONSE_TEXT,
227: RESPONSE_NAME = X_RESPONSE_NAME,
228: APPLICATION_ID = X_APPLICATION_ID,