[Home] [Help]
281: X_LAST_UPDATED_BY in NUMBER,
282: X_LAST_UPDATE_LOGIN in NUMBER
283: ) is
284: begin
285: update AHL_SPACE_UNAVAILABLE_B set
286: ATTRIBUTE13 = X_ATTRIBUTE13,
287: ATTRIBUTE14 = X_ATTRIBUTE14,
288: ATTRIBUTE15 = X_ATTRIBUTE15,
289: SPACE_ID = X_SPACE_ID,
450: from AHL_SPACE_UNAVAILABLE_B
451: where SPACE_UNAVAILABILITY_ID = X_SPACE_UNAVAILABILITY_ID;
452:
453: cursor c_get_rec_id is
454: select AHL_SPACE_UNAVAILABLE_B_S.NEXTVAL
455: from DUAL;
456:
457: BEGIN
458: