APPS.DOM_DOC_REV_VERSIONS_PKG dependencies on DOM_DOC_REV_VERSIONS_TL

Line 48: insert into DOM_DOC_REV_VERSIONS_TL (

44: X_LAST_UPDATED_BY,
45: X_LAST_UPDATE_LOGIN
46: );
47:
48: insert into DOM_DOC_REV_VERSIONS_TL (
49: DOCUMENT_ID,
50: REVISION_ID,
51: VERSION_ID,
52: COMMENTS,

Line 76: from DOM_DOC_REV_VERSIONS_TL T

72: from FND_LANGUAGES L
73: where L.INSTALLED_FLAG in ('I', 'B')
74: and not exists
75: (select NULL
76: from DOM_DOC_REV_VERSIONS_TL T
77: where T.DOCUMENT_ID = X_DOCUMENT_ID
78: and T.REVISION_ID = X_REVISION_ID
79: and T.VERSION_ID = X_VERSION_ID
80: and T.LANGUAGE = L.LANGUAGE_CODE);

Line 113: from DOM_DOC_REV_VERSIONS_TL

109:
110: cursor c1 is select
111: COMMENTS,
112: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
113: from DOM_DOC_REV_VERSIONS_TL
114: where DOCUMENT_ID = X_DOCUMENT_ID
115: and REVISION_ID = X_REVISION_ID
116: and VERSION_ID = X_VERSION_ID
117: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)

Line 180: update DOM_DOC_REV_VERSIONS_TL set

176: if (sql%notfound) then
177: raise no_data_found;
178: end if;
179:
180: update DOM_DOC_REV_VERSIONS_TL set
181: COMMENTS = X_COMMENTS,
182: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
183: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
184: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 199: delete from DOM_DOC_REV_VERSIONS_TL

195: procedure DELETE_ROW (
196: X_VERSION_ID in NUMBER
197: ) is
198: begin
199: delete from DOM_DOC_REV_VERSIONS_TL
200: where VERSION_ID = X_VERSION_ID;
201:
202: if (sql%notfound) then
203: raise no_data_found;

Line 217: delete from DOM_DOC_REV_VERSIONS_TL T

213:
214: procedure ADD_LANGUAGE
215: is
216: begin
217: delete from DOM_DOC_REV_VERSIONS_TL T
218: where not exists
219: (select NULL
220: from DOM_DOC_REV_VERSIONS B
221: where B.DOCUMENT_ID = T.DOCUMENT_ID

Line 226: update DOM_DOC_REV_VERSIONS_TL T set (

222: and B.REVISION_ID = T.REVISION_ID
223: and B.VERSION_ID = T.VERSION_ID
224: );
225:
226: update DOM_DOC_REV_VERSIONS_TL T set (
227: COMMENTS
228: ) = (select
229: B.COMMENTS
230: from DOM_DOC_REV_VERSIONS_TL B

Line 230: from DOM_DOC_REV_VERSIONS_TL B

226: update DOM_DOC_REV_VERSIONS_TL T set (
227: COMMENTS
228: ) = (select
229: B.COMMENTS
230: from DOM_DOC_REV_VERSIONS_TL B
231: where B.DOCUMENT_ID = T.DOCUMENT_ID
232: and B.REVISION_ID = T.REVISION_ID
233: and B.VERSION_ID = T.VERSION_ID
234: and B.LANGUAGE = T.SOURCE_LANG)

Line 245: from DOM_DOC_REV_VERSIONS_TL SUBB, DOM_DOC_REV_VERSIONS_TL SUBT

241: SUBT.DOCUMENT_ID,
242: SUBT.REVISION_ID,
243: SUBT.VERSION_ID,
244: SUBT.LANGUAGE
245: from DOM_DOC_REV_VERSIONS_TL SUBB, DOM_DOC_REV_VERSIONS_TL SUBT
246: where SUBB.DOCUMENT_ID = SUBT.DOCUMENT_ID
247: and SUBB.REVISION_ID = SUBT.REVISION_ID
248: and SUBB.VERSION_ID = SUBT.VERSION_ID
249: and SUBB.LANGUAGE = SUBT.SOURCE_LANG

Line 255: insert into DOM_DOC_REV_VERSIONS_TL (

251: or (SUBB.COMMENTS is null and SUBT.COMMENTS is not null)
252: or (SUBB.COMMENTS is not null and SUBT.COMMENTS is null)
253: ));
254:
255: insert into DOM_DOC_REV_VERSIONS_TL (
256: DOCUMENT_ID,
257: REVISION_ID,
258: VERSION_ID,
259: COMMENTS,

Line 279: from DOM_DOC_REV_VERSIONS_TL B, FND_LANGUAGES L

275: B.LAST_UPDATE_DATE,
276: B.LAST_UPDATE_LOGIN,
277: L.LANGUAGE_CODE,
278: B.SOURCE_LANG
279: from DOM_DOC_REV_VERSIONS_TL B, FND_LANGUAGES L
280: where L.INSTALLED_FLAG in ('I', 'B')
281: and B.LANGUAGE = userenv('LANG')
282: and not exists
283: (select NULL

Line 284: from DOM_DOC_REV_VERSIONS_TL T

280: where L.INSTALLED_FLAG in ('I', 'B')
281: and B.LANGUAGE = userenv('LANG')
282: and not exists
283: (select NULL
284: from DOM_DOC_REV_VERSIONS_TL T
285: where T.DOCUMENT_ID = B.DOCUMENT_ID
286: and T.REVISION_ID = B.REVISION_ID
287: and T.VERSION_ID = B.VERSION_ID
288: and T.LANGUAGE = L.LANGUAGE_CODE);