eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.DOM_DOC_REV_VERSIONS_EXT_PKG dependencies on DOM_DOC_REV_VERSIONS_EXT_TL

Line 7: delete from DOM_DOC_REV_VERSIONS_EXT_TL T

3:
4: procedure ADD_LANGUAGE
5: is
6: begin
7: delete from DOM_DOC_REV_VERSIONS_EXT_TL T
8: where not exists
9: (select NULL
10: from DOM_DOC_REV_VERSIONS_EXT_B B
11: where B.EXTENSION_ID = T.EXTENSION_ID

Line 18: update DOM_DOC_REV_VERSIONS_EXT_TL T set (

14: and B.VERSION_ID = T.VERSION_ID
15: and B.ATTR_GROUP_ID = T.ATTR_GROUP_ID
16: );
17:
18: update DOM_DOC_REV_VERSIONS_EXT_TL T set (
19: TL_EXT_ATTR1,
20: TL_EXT_ATTR2,
21: TL_EXT_ATTR3,
22: TL_EXT_ATTR4,

Line 100: from DOM_DOC_REV_VERSIONS_EXT_TL B

96: B.TL_EXT_ATTR37,
97: B.TL_EXT_ATTR38,
98: B.TL_EXT_ATTR39,
99: B.TL_EXT_ATTR40
100: from DOM_DOC_REV_VERSIONS_EXT_TL B
101: where B.EXTENSION_ID = T.EXTENSION_ID
102: and B.DOCUMENT_ID = T.DOCUMENT_ID
103: and B.REVISION_ID = T.REVISION_ID
104: and B.VERSION_ID = T.VERSION_ID

Line 121: from DOM_DOC_REV_VERSIONS_EXT_TL SUBB, DOM_DOC_REV_VERSIONS_EXT_TL SUBT

117: SUBT.REVISION_ID,
118: SUBT.VERSION_ID,
119: SUBT.ATTR_GROUP_ID,
120: SUBT.LANGUAGE
121: from DOM_DOC_REV_VERSIONS_EXT_TL SUBB, DOM_DOC_REV_VERSIONS_EXT_TL SUBT
122: where SUBB.EXTENSION_ID = SUBT.EXTENSION_ID
123: and SUBB.DOCUMENT_ID = SUBT.DOCUMENT_ID
124: and SUBB.REVISION_ID = SUBT.REVISION_ID
125: and SUBB.VERSION_ID = SUBT.VERSION_ID

Line 250: insert into DOM_DOC_REV_VERSIONS_EXT_TL (

246: or (SUBB.TL_EXT_ATTR40 is null and SUBT.TL_EXT_ATTR40 is not null)
247: or (SUBB.TL_EXT_ATTR40 is not null and SUBT.TL_EXT_ATTR40 is null)
248: ));
249:
250: insert into DOM_DOC_REV_VERSIONS_EXT_TL (
251: ATTR_GROUP_ID,
252: CATEGORY_ID,
253: DOCUMENT_ID,
254: REVISION_ID,

Line 358: from DOM_DOC_REV_VERSIONS_EXT_TL B, FND_LANGUAGES L

354: B.LAST_UPDATE_DATE,
355: B.LAST_UPDATE_LOGIN,
356: L.LANGUAGE_CODE,
357: B.SOURCE_LANG
358: from DOM_DOC_REV_VERSIONS_EXT_TL B, FND_LANGUAGES L
359: where L.INSTALLED_FLAG in ('I', 'B')
360: and B.LANGUAGE = userenv('LANG')
361: and not exists
362: (select NULL

Line 363: from DOM_DOC_REV_VERSIONS_EXT_TL T

359: where L.INSTALLED_FLAG in ('I', 'B')
360: and B.LANGUAGE = userenv('LANG')
361: and not exists
362: (select NULL
363: from DOM_DOC_REV_VERSIONS_EXT_TL T
364: where T.EXTENSION_ID = B.EXTENSION_ID
365: and T.DOCUMENT_ID = B.DOCUMENT_ID
366: and T.REVISION_ID = B.REVISION_ID
367: and T.VERSION_ID = B.VERSION_ID