APPS.DOM_DOC_REV_VERSIONS_PKG dependencies on DOM_DOC_REV_VERSIONS

Line 1: package body DOM_DOC_REV_VERSIONS_PKG as

1: package body DOM_DOC_REV_VERSIONS_PKG as
2: /* $Header: DOMVERB.pls 120.3 2006/04/13 06:53:49 sabatra noship $ */
3:
4: procedure INSERT_ROW (
5: X_ROWID in out nocopy VARCHAR2,

Line 18: cursor C is select ROWID from DOM_DOC_REV_VERSIONS

14: X_LAST_UPDATE_DATE in DATE,
15: X_LAST_UPDATED_BY in NUMBER,
16: X_LAST_UPDATE_LOGIN in NUMBER
17: ) is
18: cursor C is select ROWID from DOM_DOC_REV_VERSIONS
19: where DOCUMENT_ID = X_DOCUMENT_ID
20: and REVISION_ID = X_REVISION_ID
21: and VERSION_ID = X_VERSION_ID
22: ;

Line 24: insert into DOM_DOC_REV_VERSIONS (

20: and REVISION_ID = X_REVISION_ID
21: and VERSION_ID = X_VERSION_ID
22: ;
23: begin
24: insert into DOM_DOC_REV_VERSIONS (
25: DOCUMENT_ID,
26: REVISION_ID,
27: VERSION_ID,
28: VERSION,

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 103: from DOM_DOC_REV_VERSIONS

99: ) is
100: cursor c is select
101: VERSION,
102: STATUS_CODE
103: from DOM_DOC_REV_VERSIONS
104: where DOCUMENT_ID = X_DOCUMENT_ID
105: and REVISION_ID = X_REVISION_ID
106: and VERSION_ID = X_VERSION_ID
107: for update of DOCUMENT_ID nowait;

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 166: update DOM_DOC_REV_VERSIONS set

162: X_LAST_UPDATED_BY in NUMBER,
163: X_LAST_UPDATE_LOGIN in NUMBER
164: ) is
165: begin
166: update DOM_DOC_REV_VERSIONS set
167: REVISION_ID = X_REVISION_ID,
168: VERSION = X_VERSION,
169: STATUS_CODE = X_STATUS_CODE,
170: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

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 206: delete from DOM_DOC_REV_VERSIONS

202: if (sql%notfound) then
203: raise no_data_found;
204: end if;
205:
206: delete from DOM_DOC_REV_VERSIONS
207: where VERSION_ID = X_VERSION_ID;
208:
209: if (sql%notfound) then
210: 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 220: from DOM_DOC_REV_VERSIONS B

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
222: and B.REVISION_ID = T.REVISION_ID
223: and B.VERSION_ID = T.VERSION_ID
224: );

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);

Line 291: end DOM_DOC_REV_VERSIONS_PKG;

287: and T.VERSION_ID = B.VERSION_ID
288: and T.LANGUAGE = L.LANGUAGE_CODE);
289: end ADD_LANGUAGE;
290:
291: end DOM_DOC_REV_VERSIONS_PKG;