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_DOCUMENT_REVISIONS_PKG dependencies on DOM_DOCUMENT_REVISIONS

Line 1: package body DOM_DOCUMENT_REVISIONS_PKG as

1: package body DOM_DOCUMENT_REVISIONS_PKG as
2: /* $Header: DOMREVB.pls 120.2 2006/03/24 17:32:26 dedatta noship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out nocopy VARCHAR2,
5: X_DOCUMENT_ID in NUMBER,

Line 21: cursor C is select ROWID from DOM_DOCUMENT_REVISIONS

17: X_LAST_UPDATE_DATE in DATE,
18: X_LAST_UPDATED_BY in NUMBER,
19: X_LAST_UPDATE_LOGIN in NUMBER
20: ) is
21: cursor C is select ROWID from DOM_DOCUMENT_REVISIONS
22: where DOCUMENT_ID = X_DOCUMENT_ID
23: and REVISION_ID = X_REVISION_ID
24: ;
25: begin

Line 26: insert into DOM_DOCUMENT_REVISIONS (

22: where DOCUMENT_ID = X_DOCUMENT_ID
23: and REVISION_ID = X_REVISION_ID
24: ;
25: begin
26: insert into DOM_DOCUMENT_REVISIONS (
27: CATEGORY_ID,
28: DOCUMENT_ID,
29: REVISION_ID,
30: REVISION,

Line 58: insert into DOM_DOCUMENT_REVISIONS_TL (

54: X_LAST_UPDATED_BY,
55: X_LAST_UPDATE_LOGIN
56: );
57:
58: insert into DOM_DOCUMENT_REVISIONS_TL (
59: DOCUMENT_ID,
60: CATEGORY_ID,
61: REVISION_ID,
62: COMMENTS,

Line 86: from DOM_DOCUMENT_REVISIONS_TL T

82: from FND_LANGUAGES L
83: where L.INSTALLED_FLAG in ('I', 'B')
84: and not exists
85: (select NULL
86: from DOM_DOCUMENT_REVISIONS_TL T
87: where T.DOCUMENT_ID = X_DOCUMENT_ID
88: and T.REVISION_ID = X_REVISION_ID
89: and T.LANGUAGE = L.LANGUAGE_CODE);
90:

Line 121: from DOM_DOCUMENT_REVISIONS

117: CHECKED_OUT_BY,
118: CREATION_REASON,
119: LIFECYCLE_PHASE_ID,
120: LIFECYCLE_TRACKING_ID
121: from DOM_DOCUMENT_REVISIONS
122: where DOCUMENT_ID = X_DOCUMENT_ID
123: and REVISION_ID = X_REVISION_ID
124: for update of DOCUMENT_ID nowait;
125: recinfo c%rowtype;

Line 130: from DOM_DOCUMENT_REVISIONS_TL

126:
127: cursor c1 is select
128: COMMENTS,
129: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
130: from DOM_DOCUMENT_REVISIONS_TL
131: where DOCUMENT_ID = X_DOCUMENT_ID
132: and REVISION_ID = X_REVISION_ID
133: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
134: for update of DOCUMENT_ID nowait;

Line 196: update DOM_DOCUMENT_REVISIONS set

192: X_LAST_UPDATED_BY in NUMBER,
193: X_LAST_UPDATE_LOGIN in NUMBER
194: ) is
195: begin
196: update DOM_DOCUMENT_REVISIONS set
197: CATEGORY_ID = X_CATEGORY_ID,
198: REVISION = X_REVISION,
199: CHECKOUT_STATUS = X_CHECKOUT_STATUS,
200: CHECKED_OUT_BY = X_CHECKED_OUT_BY,

Line 214: update DOM_DOCUMENT_REVISIONS_TL set

210: if (sql%notfound) then
211: raise no_data_found;
212: end if;
213:
214: update DOM_DOCUMENT_REVISIONS_TL set
215: COMMENTS = X_COMMENTS,
216: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
217: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
218: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 234: delete from DOM_DOCUMENT_REVISIONS_TL

230: X_DOCUMENT_ID in NUMBER,
231: X_REVISION_ID in NUMBER
232: ) is
233: begin
234: delete from DOM_DOCUMENT_REVISIONS_TL
235: where DOCUMENT_ID = X_DOCUMENT_ID
236: and REVISION_ID = X_REVISION_ID;
237:
238: if (sql%notfound) then

Line 242: delete from DOM_DOCUMENT_REVISIONS

238: if (sql%notfound) then
239: raise no_data_found;
240: end if;
241:
242: delete from DOM_DOCUMENT_REVISIONS
243: where DOCUMENT_ID = X_DOCUMENT_ID
244: and REVISION_ID = X_REVISION_ID;
245:
246: if (sql%notfound) then

Line 254: delete from DOM_DOCUMENT_REVISIONS_TL T

250:
251: procedure ADD_LANGUAGE
252: is
253: begin
254: delete from DOM_DOCUMENT_REVISIONS_TL T
255: where not exists
256: (select NULL
257: from DOM_DOCUMENT_REVISIONS B
258: where B.DOCUMENT_ID = T.DOCUMENT_ID

Line 257: from DOM_DOCUMENT_REVISIONS B

253: begin
254: delete from DOM_DOCUMENT_REVISIONS_TL T
255: where not exists
256: (select NULL
257: from DOM_DOCUMENT_REVISIONS B
258: where B.DOCUMENT_ID = T.DOCUMENT_ID
259: and B.REVISION_ID = T.REVISION_ID
260: );
261:

Line 262: update DOM_DOCUMENT_REVISIONS_TL T set (

258: where B.DOCUMENT_ID = T.DOCUMENT_ID
259: and B.REVISION_ID = T.REVISION_ID
260: );
261:
262: update DOM_DOCUMENT_REVISIONS_TL T set (
263: COMMENTS
264: ) = (select
265: B.COMMENTS
266: from DOM_DOCUMENT_REVISIONS_TL B

Line 266: from DOM_DOCUMENT_REVISIONS_TL B

262: update DOM_DOCUMENT_REVISIONS_TL T set (
263: COMMENTS
264: ) = (select
265: B.COMMENTS
266: from DOM_DOCUMENT_REVISIONS_TL B
267: where B.DOCUMENT_ID = T.DOCUMENT_ID
268: and B.REVISION_ID = T.REVISION_ID
269: and B.LANGUAGE = T.SOURCE_LANG)
270: where (

Line 278: from DOM_DOCUMENT_REVISIONS_TL SUBB, DOM_DOCUMENT_REVISIONS_TL SUBT

274: ) in (select
275: SUBT.DOCUMENT_ID,
276: SUBT.REVISION_ID,
277: SUBT.LANGUAGE
278: from DOM_DOCUMENT_REVISIONS_TL SUBB, DOM_DOCUMENT_REVISIONS_TL SUBT
279: where SUBB.DOCUMENT_ID = SUBT.DOCUMENT_ID
280: and SUBB.REVISION_ID = SUBT.REVISION_ID
281: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
282: and (SUBB.COMMENTS <> SUBT.COMMENTS

Line 287: insert into DOM_DOCUMENT_REVISIONS_TL (

283: or (SUBB.COMMENTS is null and SUBT.COMMENTS is not null)
284: or (SUBB.COMMENTS is not null and SUBT.COMMENTS is null)
285: ));
286:
287: insert into DOM_DOCUMENT_REVISIONS_TL (
288: DOCUMENT_ID,
289: CATEGORY_ID,
290: REVISION_ID,
291: COMMENTS,

Line 311: from DOM_DOCUMENT_REVISIONS_TL B, FND_LANGUAGES L

307: B.LAST_UPDATE_DATE,
308: B.LAST_UPDATE_LOGIN,
309: L.LANGUAGE_CODE,
310: B.SOURCE_LANG
311: from DOM_DOCUMENT_REVISIONS_TL B, FND_LANGUAGES L
312: where L.INSTALLED_FLAG in ('I', 'B')
313: and B.LANGUAGE = userenv('LANG')
314: and not exists
315: (select NULL

Line 316: from DOM_DOCUMENT_REVISIONS_TL T

312: where L.INSTALLED_FLAG in ('I', 'B')
313: and B.LANGUAGE = userenv('LANG')
314: and not exists
315: (select NULL
316: from DOM_DOCUMENT_REVISIONS_TL T
317: where T.DOCUMENT_ID = B.DOCUMENT_ID
318: and T.REVISION_ID = B.REVISION_ID
319: and T.LANGUAGE = L.LANGUAGE_CODE);
320: end ADD_LANGUAGE;

Line 322: end DOM_DOCUMENT_REVISIONS_PKG;

318: and T.REVISION_ID = B.REVISION_ID
319: and T.LANGUAGE = L.LANGUAGE_CODE);
320: end ADD_LANGUAGE;
321:
322: end DOM_DOCUMENT_REVISIONS_PKG;