APPS.AHL_SPACES_PKG dependencies on AHL_SPACES_B

Line 34: cursor C is select ROWID from AHL_SPACES_B

30: X_LAST_UPDATE_DATE in DATE,
31: X_LAST_UPDATED_BY in NUMBER,
32: X_LAST_UPDATE_LOGIN in NUMBER
33: ) is
34: cursor C is select ROWID from AHL_SPACES_B
35: where SPACE_ID = X_SPACE_ID
36: ;
37: begin
38: insert into AHL_SPACES_B (

Line 38: insert into AHL_SPACES_B (

34: cursor C is select ROWID from AHL_SPACES_B
35: where SPACE_ID = X_SPACE_ID
36: ;
37: begin
38: insert into AHL_SPACES_B (
39: ATTRIBUTE13,
40: ATTRIBUTE14,
41: ATTRIBUTE15,
42: ATTRIBUTE3,

Line 181: from AHL_SPACES_B

177: ATTRIBUTE11,
178: ATTRIBUTE12,
179: SPACE_CATEGORY,
180: OBJECT_VERSION_NUMBER
181: from AHL_SPACES_B
182: where SPACE_ID = X_SPACE_ID
183: for update of SPACE_ID nowait;
184: recinfo c%rowtype;
185:

Line 290: update AHL_SPACES_B set

286: X_LAST_UPDATED_BY in NUMBER,
287: X_LAST_UPDATE_LOGIN in NUMBER
288: ) is
289: begin
290: update AHL_SPACES_B set
291: ATTRIBUTE13 = X_ATTRIBUTE13,
292: ATTRIBUTE14 = X_ATTRIBUTE14,
293: ATTRIBUTE15 = X_ATTRIBUTE15,
294: ATTRIBUTE3 = X_ATTRIBUTE3,

Line 346: delete from AHL_SPACES_B

342: if (sql%notfound) then
343: raise no_data_found;
344: end if;
345:
346: delete from AHL_SPACES_B
347: where SPACE_ID = X_SPACE_ID;
348:
349: if (sql%notfound) then
350: raise no_data_found;

Line 360: from AHL_SPACES_B B

356: begin
357: delete from AHL_SPACES_TL T
358: where not exists
359: (select NULL
360: from AHL_SPACES_B B
361: where B.SPACE_ID = T.SPACE_ID
362: );
363:
364: update AHL_SPACES_TL T set (

Line 452: from AHL_SPACES_B

448:
449:
450: cursor c_obj_verno is
451: select object_version_number
452: from AHL_SPACES_B
453: where SPACE_ID = X_SPACE_ID;
454:
455: cursor c_chk_rec_exists is
456: select 'x'

Line 457: from AHL_SPACES_B

453: where SPACE_ID = X_SPACE_ID;
454:
455: cursor c_chk_rec_exists is
456: select 'x'
457: from AHL_SPACES_B
458: where SPACE_ID = X_SPACE_ID;
459:
460: cursor c_get_rec_id is
461: select AHL_SPACES_B_S.NEXTVAL

Line 461: select AHL_SPACES_B_S.NEXTVAL

457: from AHL_SPACES_B
458: where SPACE_ID = X_SPACE_ID;
459:
460: cursor c_get_rec_id is
461: select AHL_SPACES_B_S.NEXTVAL
462: from DUAL;
463:
464: BEGIN
465: