APPS.AHL_DOC_REVISIONS_PKG dependencies on AHL_DOC_REVISIONS_TL

Line 132: insert into AHL_DOC_REVISIONS_TL (

128: X_LAST_UPDATED_BY,
129: X_LAST_UPDATE_LOGIN
130: );
131:
132: insert into AHL_DOC_REVISIONS_TL (
133: LAST_UPDATE_LOGIN,
134: COMMENTS,
135: CREATION_DATE,
136: CREATED_BY,

Line 156: from AHL_DOC_REVISIONS_TL T

152: from FND_LANGUAGES L
153: where L.INSTALLED_FLAG in ('I', 'B')
154: and not exists
155: (select NULL
156: from AHL_DOC_REVISIONS_TL T
157: where T.DOC_REVISION_ID = X_DOC_REVISION_ID
158: and T.LANGUAGE = L.LANGUAGE_CODE);
159:
160: open c;

Line 249: from AHL_DOC_REVISIONS_TL

245:
246: cursor c1 is select
247: COMMENTS,
248: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
249: from AHL_DOC_REVISIONS_TL
250: where DOC_REVISION_ID = X_DOC_REVISION_ID
251: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
252: for update of DOC_REVISION_ID nowait;
253: begin

Line 429: update AHL_DOC_REVISIONS_TL set

425: if (sql%notfound) then
426: raise no_data_found;
427: end if;
428:
429: update AHL_DOC_REVISIONS_TL set
430: COMMENTS = X_COMMENTS,
431: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
432: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
433: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 447: delete from AHL_DOC_REVISIONS_TL

443: procedure DELETE_ROW (
444: X_DOC_REVISION_ID in NUMBER
445: ) is
446: begin
447: delete from AHL_DOC_REVISIONS_TL
448: where DOC_REVISION_ID = X_DOC_REVISION_ID;
449:
450: if (sql%notfound) then
451: raise no_data_found;

Line 465: delete from AHL_DOC_REVISIONS_TL T

461:
462: procedure ADD_LANGUAGE
463: is
464: begin
465: delete from AHL_DOC_REVISIONS_TL T
466: where not exists
467: (select NULL
468: from AHL_DOC_REVISIONS_B B
469: where B.DOC_REVISION_ID = T.DOC_REVISION_ID

Line 472: update AHL_DOC_REVISIONS_TL T set (

468: from AHL_DOC_REVISIONS_B B
469: where B.DOC_REVISION_ID = T.DOC_REVISION_ID
470: );
471:
472: update AHL_DOC_REVISIONS_TL T set (
473: COMMENTS
474: ) = (select
475: B.COMMENTS
476: from AHL_DOC_REVISIONS_TL B

Line 476: from AHL_DOC_REVISIONS_TL B

472: update AHL_DOC_REVISIONS_TL T set (
473: COMMENTS
474: ) = (select
475: B.COMMENTS
476: from AHL_DOC_REVISIONS_TL B
477: where B.DOC_REVISION_ID = T.DOC_REVISION_ID
478: and B.LANGUAGE = T.SOURCE_LANG)
479: where (
480: T.DOC_REVISION_ID,

Line 485: from AHL_DOC_REVISIONS_TL SUBB, AHL_DOC_REVISIONS_TL SUBT

481: T.LANGUAGE
482: ) in (select
483: SUBT.DOC_REVISION_ID,
484: SUBT.LANGUAGE
485: from AHL_DOC_REVISIONS_TL SUBB, AHL_DOC_REVISIONS_TL SUBT
486: where SUBB.DOC_REVISION_ID = SUBT.DOC_REVISION_ID
487: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
488: and (SUBB.COMMENTS <> SUBT.COMMENTS
489: or (SUBB.COMMENTS is null and SUBT.COMMENTS is not null)

Line 493: insert into AHL_DOC_REVISIONS_TL (

489: or (SUBB.COMMENTS is null and SUBT.COMMENTS is not null)
490: or (SUBB.COMMENTS is not null and SUBT.COMMENTS is null)
491: ));
492:
493: insert into AHL_DOC_REVISIONS_TL (
494: LAST_UPDATE_LOGIN,
495: COMMENTS,
496: CREATION_DATE,
497: CREATED_BY,

Line 513: from AHL_DOC_REVISIONS_TL B, FND_LANGUAGES L

509: B.LAST_UPDATE_DATE,
510: B.LAST_UPDATED_BY,
511: L.LANGUAGE_CODE,
512: B.SOURCE_LANG
513: from AHL_DOC_REVISIONS_TL B, FND_LANGUAGES L
514: where L.INSTALLED_FLAG in ('I', 'B')
515: and B.LANGUAGE = userenv('LANG')
516: and not exists
517: (select NULL

Line 518: from AHL_DOC_REVISIONS_TL T

514: where L.INSTALLED_FLAG in ('I', 'B')
515: and B.LANGUAGE = userenv('LANG')
516: and not exists
517: (select NULL
518: from AHL_DOC_REVISIONS_TL T
519: where T.DOC_REVISION_ID = B.DOC_REVISION_ID
520: and T.LANGUAGE = L.LANGUAGE_CODE);
521: end ADD_LANGUAGE;
522:

Line 672: update AHl_DOC_REVISIONS_TL set

668: X_COMMENTS in VARCHAR2,
669: X_OWNER in VARCHAR2
670: ) is
671: begin
672: update AHl_DOC_REVISIONS_TL set
673: comments = nvl(X_COMMENTS, comments),
674: source_lang = userenv('LANG'),
675: last_update_date = sysdate,
676: last_updated_by = decode(X_OWNER, 'SEED', 1, 0),