APPS.AHL_DOCUMENTS_PKG dependencies on AHL_DOCUMENTS_TL

Line 108: insert into AHL_DOCUMENTS_TL (

104: X_LAST_UPDATED_BY,
105: X_LAST_UPDATE_LOGIN
106: );
107:
108: insert into AHL_DOCUMENTS_TL (
109: CREATED_BY,
110: CREATION_DATE,
111: DOCUMENT_TITLE,
112: LAST_UPDATED_BY,

Line 132: from AHL_DOCUMENTS_TL T

128: from FND_LANGUAGES L
129: where L.INSTALLED_FLAG in ('I', 'B')
130: and not exists
131: (select NULL
132: from AHL_DOCUMENTS_TL T
133: where T.DOCUMENT_ID = X_DOCUMENT_ID
134: and T.LANGUAGE = L.LANGUAGE_CODE);
135:
136: open c;

Line 209: from AHL_DOCUMENTS_TL

205:
206: cursor c1 is select
207: DOCUMENT_TITLE,
208: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
209: from AHL_DOCUMENTS_TL
210: where DOCUMENT_ID = X_DOCUMENT_ID
211: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
212: for update of DOCUMENT_ID nowait;
213: begin

Line 356: update AHL_DOCUMENTS_TL set

352: if (sql%notfound) then
353: raise no_data_found;
354: end if;
355:
356: update AHL_DOCUMENTS_TL set
357: DOCUMENT_TITLE = X_DOCUMENT_TITLE,
358: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
359: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
360: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 374: delete from AHL_DOCUMENTS_TL

370: procedure DELETE_ROW (
371: X_DOCUMENT_ID in NUMBER
372: ) is
373: begin
374: delete from AHL_DOCUMENTS_TL
375: where DOCUMENT_ID = X_DOCUMENT_ID;
376:
377: if (sql%notfound) then
378: raise no_data_found;

Line 392: delete from AHL_DOCUMENTS_TL T

388:
389: procedure ADD_LANGUAGE
390: is
391: begin
392: delete from AHL_DOCUMENTS_TL T
393: where not exists
394: (select NULL
395: from AHL_DOCUMENTS_B B
396: where B.DOCUMENT_ID = T.DOCUMENT_ID

Line 399: update AHL_DOCUMENTS_TL T set (

395: from AHL_DOCUMENTS_B B
396: where B.DOCUMENT_ID = T.DOCUMENT_ID
397: );
398:
399: update AHL_DOCUMENTS_TL T set (
400: DOCUMENT_TITLE
401: ) = (select
402: B.DOCUMENT_TITLE
403: from AHL_DOCUMENTS_TL B

Line 403: from AHL_DOCUMENTS_TL B

399: update AHL_DOCUMENTS_TL T set (
400: DOCUMENT_TITLE
401: ) = (select
402: B.DOCUMENT_TITLE
403: from AHL_DOCUMENTS_TL B
404: where B.DOCUMENT_ID = T.DOCUMENT_ID
405: and B.LANGUAGE = T.SOURCE_LANG)
406: where (
407: T.DOCUMENT_ID,

Line 412: from AHL_DOCUMENTS_TL SUBB, AHL_DOCUMENTS_TL SUBT

408: T.LANGUAGE
409: ) in (select
410: SUBT.DOCUMENT_ID,
411: SUBT.LANGUAGE
412: from AHL_DOCUMENTS_TL SUBB, AHL_DOCUMENTS_TL SUBT
413: where SUBB.DOCUMENT_ID = SUBT.DOCUMENT_ID
414: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
415: and (SUBB.DOCUMENT_TITLE <> SUBT.DOCUMENT_TITLE
416: or (SUBB.DOCUMENT_TITLE is null and SUBT.DOCUMENT_TITLE is not null)

Line 420: insert into AHL_DOCUMENTS_TL (

416: or (SUBB.DOCUMENT_TITLE is null and SUBT.DOCUMENT_TITLE is not null)
417: or (SUBB.DOCUMENT_TITLE is not null and SUBT.DOCUMENT_TITLE is null)
418: ));
419:
420: insert into AHL_DOCUMENTS_TL (
421: CREATED_BY,
422: CREATION_DATE,
423: DOCUMENT_TITLE,
424: LAST_UPDATED_BY,

Line 440: from AHL_DOCUMENTS_TL B, FND_LANGUAGES L

436: B.LAST_UPDATE_DATE,
437: B.LAST_UPDATE_LOGIN,
438: L.LANGUAGE_CODE,
439: B.SOURCE_LANG
440: from AHL_DOCUMENTS_TL B, FND_LANGUAGES L
441: where L.INSTALLED_FLAG in ('I', 'B')
442: and B.LANGUAGE = userenv('LANG')
443: and not exists
444: (select NULL

Line 445: from AHL_DOCUMENTS_TL T

441: where L.INSTALLED_FLAG in ('I', 'B')
442: and B.LANGUAGE = userenv('LANG')
443: and not exists
444: (select NULL
445: from AHL_DOCUMENTS_TL T
446: where T.DOCUMENT_ID = B.DOCUMENT_ID
447: and T.LANGUAGE = L.LANGUAGE_CODE);
448: end ADD_LANGUAGE;
449:

Line 573: update AHl_DOCUMENTS_TL set

569: X_DOCUMENT_TITLE in VARCHAR2,
570: X_OWNER in VARCHAR2
571: ) is
572: begin
573: update AHl_DOCUMENTS_TL set
574: document_title = nvl(X_DOCUMENT_TITLE, document_title),
575: source_lang = userenv('LANG'),
576: last_update_date = sysdate,
577: last_updated_by = decode(X_OWNER, 'SEED', 1, 0),