APPS.AHL_SPACE_UNAVAILABLE_PKG dependencies on AHL_SPACE_UNAVAILABLE_TL

Line 93: insert into AHL_SPACE_UNAVAILABLE_TL (

89: X_LAST_UPDATED_BY,
90: X_LAST_UPDATE_LOGIN
91: );
92:
93: insert into AHL_SPACE_UNAVAILABLE_TL (
94: DESCRIPTION,
95: SPACE_UNAVAILABILITY_ID,
96: LAST_UPDATE_DATE,
97: LAST_UPDATED_BY,

Line 117: from AHL_SPACE_UNAVAILABLE_TL T

113: from FND_LANGUAGES L
114: where L.INSTALLED_FLAG in ('I', 'B')
115: and not exists
116: (select NULL
117: from AHL_SPACE_UNAVAILABLE_TL T
118: where T.SPACE_UNAVAILABILITY_ID = X_SPACE_UNAVAILABILITY_ID
119: and T.LANGUAGE = L.LANGUAGE_CODE);
120:
121: open c;

Line 184: from AHL_SPACE_UNAVAILABLE_TL

180:
181: cursor c1 is select
182: DESCRIPTION,
183: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
184: from AHL_SPACE_UNAVAILABLE_TL
185: where SPACE_UNAVAILABILITY_ID = X_SPACE_UNAVAILABILITY_ID
186: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
187: for update of SPACE_UNAVAILABILITY_ID nowait;
188: begin

Line 315: update AHL_SPACE_UNAVAILABLE_TL set

311: if (sql%notfound) then
312: raise no_data_found;
313: end if;
314:
315: update AHL_SPACE_UNAVAILABLE_TL set
316: DESCRIPTION = X_DESCRIPTION,
317: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
318: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
319: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 333: delete from AHL_SPACE_UNAVAILABLE_TL

329: procedure DELETE_ROW (
330: X_SPACE_UNAVAILABILITY_ID in NUMBER
331: ) is
332: begin
333: delete from AHL_SPACE_UNAVAILABLE_TL
334: where SPACE_UNAVAILABILITY_ID = X_SPACE_UNAVAILABILITY_ID;
335:
336: if (sql%notfound) then
337: raise no_data_found;

Line 351: delete from AHL_SPACE_UNAVAILABLE_TL T

347:
348: procedure ADD_LANGUAGE
349: is
350: begin
351: delete from AHL_SPACE_UNAVAILABLE_TL T
352: where not exists
353: (select NULL
354: from AHL_SPACE_UNAVAILABLE_B B
355: where B.SPACE_UNAVAILABILITY_ID = T.SPACE_UNAVAILABILITY_ID

Line 358: update AHL_SPACE_UNAVAILABLE_TL T set (

354: from AHL_SPACE_UNAVAILABLE_B B
355: where B.SPACE_UNAVAILABILITY_ID = T.SPACE_UNAVAILABILITY_ID
356: );
357:
358: update AHL_SPACE_UNAVAILABLE_TL T set (
359: DESCRIPTION
360: ) = (select
361: B.DESCRIPTION
362: from AHL_SPACE_UNAVAILABLE_TL B

Line 362: from AHL_SPACE_UNAVAILABLE_TL B

358: update AHL_SPACE_UNAVAILABLE_TL T set (
359: DESCRIPTION
360: ) = (select
361: B.DESCRIPTION
362: from AHL_SPACE_UNAVAILABLE_TL B
363: where B.SPACE_UNAVAILABILITY_ID = T.SPACE_UNAVAILABILITY_ID
364: and B.LANGUAGE = T.SOURCE_LANG)
365: where (
366: T.SPACE_UNAVAILABILITY_ID,

Line 371: from AHL_SPACE_UNAVAILABLE_TL SUBB, AHL_SPACE_UNAVAILABLE_TL SUBT

367: T.LANGUAGE
368: ) in (select
369: SUBT.SPACE_UNAVAILABILITY_ID,
370: SUBT.LANGUAGE
371: from AHL_SPACE_UNAVAILABLE_TL SUBB, AHL_SPACE_UNAVAILABLE_TL SUBT
372: where SUBB.SPACE_UNAVAILABILITY_ID = SUBT.SPACE_UNAVAILABILITY_ID
373: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
374: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
375: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)

Line 379: insert into AHL_SPACE_UNAVAILABLE_TL (

375: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
376: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
377: ));
378:
379: insert into AHL_SPACE_UNAVAILABLE_TL (
380: DESCRIPTION,
381: SPACE_UNAVAILABILITY_ID,
382: LAST_UPDATE_DATE,
383: LAST_UPDATED_BY,

Line 399: from AHL_SPACE_UNAVAILABLE_TL B, FND_LANGUAGES L

395: B.CREATED_BY,
396: B.LAST_UPDATE_LOGIN,
397: L.LANGUAGE_CODE,
398: B.SOURCE_LANG
399: from AHL_SPACE_UNAVAILABLE_TL B, FND_LANGUAGES L
400: where L.INSTALLED_FLAG in ('I', 'B')
401: and B.LANGUAGE = userenv('LANG')
402: and not exists
403: (select NULL

Line 404: from AHL_SPACE_UNAVAILABLE_TL T

400: where L.INSTALLED_FLAG in ('I', 'B')
401: and B.LANGUAGE = userenv('LANG')
402: and not exists
403: (select NULL
404: from AHL_SPACE_UNAVAILABLE_TL T
405: where T.SPACE_UNAVAILABILITY_ID = B.SPACE_UNAVAILABILITY_ID
406: and T.LANGUAGE = L.LANGUAGE_CODE);
407: end ADD_LANGUAGE;
408:

Line 560: update AHL_SPACE_UNAVAILABLE_TL set

556: X_OWNER in VARCHAR2
557: ) IS
558:
559: begin
560: update AHL_SPACE_UNAVAILABLE_TL set
561: DESCRIPTION = NVL(X_DESCRIPTION,DESCRIPTION),
562: source_lang = userenv('LANG'),
563: last_update_date = sysdate,
564: last_updated_by = decode(x_owner, 'SEED', 1, 0),