APPS.AHL_SPACES_PKG dependencies on AHL_SPACES_TL

Line 96: insert into AHL_SPACES_TL (

92: X_LAST_UPDATED_BY,
93: X_LAST_UPDATE_LOGIN
94: );
95:
96: insert into AHL_SPACES_TL (
97: SPACE_ID,
98: LAST_UPDATE_DATE,
99: LAST_UPDATED_BY,
100: CREATION_DATE,

Line 120: from AHL_SPACES_TL T

116: from FND_LANGUAGES L
117: where L.INSTALLED_FLAG in ('I', 'B')
118: and not exists
119: (select NULL
120: from AHL_SPACES_TL T
121: where T.SPACE_ID = X_SPACE_ID
122: and T.LANGUAGE = L.LANGUAGE_CODE);
123:
124: open c;

Line 189: from AHL_SPACES_TL

185:
186: cursor c1 is select
187: SPACE_NAME,
188: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
189: from AHL_SPACES_TL
190: where SPACE_ID = X_SPACE_ID
191: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
192: for update of SPACE_ID nowait;
193: begin

Line 321: update AHL_SPACES_TL set

317: if (sql%notfound) then
318: raise no_data_found;
319: end if;
320:
321: update AHL_SPACES_TL set
322: SPACE_NAME = X_SPACE_NAME,
323: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
324: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
325: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 339: delete from AHL_SPACES_TL

335: procedure DELETE_ROW (
336: X_SPACE_ID in NUMBER
337: ) is
338: begin
339: delete from AHL_SPACES_TL
340: where SPACE_ID = X_SPACE_ID;
341:
342: if (sql%notfound) then
343: raise no_data_found;

Line 357: delete from AHL_SPACES_TL T

353:
354: procedure ADD_LANGUAGE
355: is
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

Line 364: update AHL_SPACES_TL T set (

360: from AHL_SPACES_B B
361: where B.SPACE_ID = T.SPACE_ID
362: );
363:
364: update AHL_SPACES_TL T set (
365: SPACE_NAME
366: ) = (select
367: B.SPACE_NAME
368: from AHL_SPACES_TL B

Line 368: from AHL_SPACES_TL B

364: update AHL_SPACES_TL T set (
365: SPACE_NAME
366: ) = (select
367: B.SPACE_NAME
368: from AHL_SPACES_TL B
369: where B.SPACE_ID = T.SPACE_ID
370: and B.LANGUAGE = T.SOURCE_LANG)
371: where (
372: T.SPACE_ID,

Line 377: from AHL_SPACES_TL SUBB, AHL_SPACES_TL SUBT

373: T.LANGUAGE
374: ) in (select
375: SUBT.SPACE_ID,
376: SUBT.LANGUAGE
377: from AHL_SPACES_TL SUBB, AHL_SPACES_TL SUBT
378: where SUBB.SPACE_ID = SUBT.SPACE_ID
379: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
380: and (SUBB.SPACE_NAME <> SUBT.SPACE_NAME
381: or (SUBB.SPACE_NAME is null and SUBT.SPACE_NAME is not null)

Line 385: insert into AHL_SPACES_TL (

381: or (SUBB.SPACE_NAME is null and SUBT.SPACE_NAME is not null)
382: or (SUBB.SPACE_NAME is not null and SUBT.SPACE_NAME is null)
383: ));
384:
385: insert into AHL_SPACES_TL (
386: SPACE_ID,
387: LAST_UPDATE_DATE,
388: LAST_UPDATED_BY,
389: CREATION_DATE,

Line 405: from AHL_SPACES_TL B, FND_LANGUAGES L

401: B.LAST_UPDATE_LOGIN,
402: B.SPACE_NAME,
403: L.LANGUAGE_CODE,
404: B.SOURCE_LANG
405: from AHL_SPACES_TL B, FND_LANGUAGES L
406: where L.INSTALLED_FLAG in ('I', 'B')
407: and B.LANGUAGE = userenv('LANG')
408: and not exists
409: (select NULL

Line 410: from AHL_SPACES_TL T

406: where L.INSTALLED_FLAG in ('I', 'B')
407: and B.LANGUAGE = userenv('LANG')
408: and not exists
409: (select NULL
410: from AHL_SPACES_TL T
411: where T.SPACE_ID = B.SPACE_ID
412: and T.LANGUAGE = L.LANGUAGE_CODE);
413: end ADD_LANGUAGE;
414:

Line 568: update AHL_SPACES_TL set

564: X_OWNER in VARCHAR2
565: ) IS
566:
567: begin
568: update AHL_SPACES_TL set
569: SPACE_NAME = nvl(X_SPACE_NAME,space_name),
570: source_lang = userenv('LANG'),
571: last_update_date = sysdate,
572: last_updated_by = decode(x_owner, 'SEED', 1, 0),