APPS.DOM_DOCUMENT_CATALOGS_PKG dependencies on DOM_DOCUMENT_CATALOGS_TL

Line 38: insert into DOM_DOCUMENT_CATALOGS_TL (

34: X_LAST_UPDATED_BY,
35: X_LAST_UPDATE_LOGIN
36: );
37:
38: insert into DOM_DOCUMENT_CATALOGS_TL (
39: CATALOG_ID,
40: INTERNAL_NAME,
41: NAME,
42: DESCRIPTION,

Line 66: from DOM_DOCUMENT_CATALOGS_TL T

62: from FND_LANGUAGES L
63: where L.INSTALLED_FLAG in ('I', 'B')
64: and not exists
65: (select NULL
66: from DOM_DOCUMENT_CATALOGS_TL T
67: where T.CATALOG_ID = X_CATALOG_ID
68: and T.LANGUAGE = L.LANGUAGE_CODE);
69:
70: open c;

Line 97: from DOM_DOCUMENT_CATALOGS_TL

93: cursor c1 is select
94: NAME,
95: DESCRIPTION,
96: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
97: from DOM_DOCUMENT_CATALOGS_TL
98: where CATALOG_ID = X_CATALOG_ID
99: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
100: for update of CATALOG_ID nowait;
101: begin

Line 157: update DOM_DOCUMENT_CATALOGS_TL set

153: if (sql%notfound) then
154: raise no_data_found;
155: end if;
156:
157: update DOM_DOCUMENT_CATALOGS_TL set
158: NAME = X_NAME,
159: DESCRIPTION = X_DESCRIPTION,
160: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
161: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 176: delete from DOM_DOCUMENT_CATALOGS_TL

172: procedure DELETE_ROW (
173: X_CATALOG_ID in NUMBER
174: ) is
175: begin
176: delete from DOM_DOCUMENT_CATALOGS_TL
177: where CATALOG_ID = X_CATALOG_ID;
178:
179: if (sql%notfound) then
180: raise no_data_found;

Line 194: delete from DOM_DOCUMENT_CATALOGS_TL T

190:
191: procedure ADD_LANGUAGE
192: is
193: begin
194: delete from DOM_DOCUMENT_CATALOGS_TL T
195: where not exists
196: (select NULL
197: from DOM_DOCUMENT_CATALOGS B
198: where B.CATALOG_ID = T.CATALOG_ID

Line 201: update DOM_DOCUMENT_CATALOGS_TL T set (

197: from DOM_DOCUMENT_CATALOGS B
198: where B.CATALOG_ID = T.CATALOG_ID
199: );
200:
201: update DOM_DOCUMENT_CATALOGS_TL T set (
202: NAME,
203: DESCRIPTION
204: ) = (select
205: B.NAME,

Line 207: from DOM_DOCUMENT_CATALOGS_TL B

203: DESCRIPTION
204: ) = (select
205: B.NAME,
206: B.DESCRIPTION
207: from DOM_DOCUMENT_CATALOGS_TL B
208: where B.CATALOG_ID = T.CATALOG_ID
209: and B.LANGUAGE = T.SOURCE_LANG)
210: where (
211: T.CATALOG_ID,

Line 216: from DOM_DOCUMENT_CATALOGS_TL SUBB, DOM_DOCUMENT_CATALOGS_TL SUBT

212: T.LANGUAGE
213: ) in (select
214: SUBT.CATALOG_ID,
215: SUBT.LANGUAGE
216: from DOM_DOCUMENT_CATALOGS_TL SUBB, DOM_DOCUMENT_CATALOGS_TL SUBT
217: where SUBB.CATALOG_ID = SUBT.CATALOG_ID
218: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
219: and (SUBB.NAME <> SUBT.NAME
220: or (SUBB.NAME is null and SUBT.NAME is not null)

Line 227: insert into DOM_DOCUMENT_CATALOGS_TL (

223: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
224: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
225: ));
226:
227: insert into DOM_DOCUMENT_CATALOGS_TL (
228: CATALOG_ID,
229: INTERNAL_NAME,
230: NAME,
231: DESCRIPTION,

Line 251: from DOM_DOCUMENT_CATALOGS_TL B, FND_LANGUAGES L

247: B.LAST_UPDATE_DATE,
248: B.LAST_UPDATE_LOGIN,
249: L.LANGUAGE_CODE,
250: B.SOURCE_LANG
251: from DOM_DOCUMENT_CATALOGS_TL B, FND_LANGUAGES L
252: where L.INSTALLED_FLAG in ('I', 'B')
253: and B.LANGUAGE = userenv('LANG')
254: and not exists
255: (select NULL

Line 256: from DOM_DOCUMENT_CATALOGS_TL T

252: where L.INSTALLED_FLAG in ('I', 'B')
253: and B.LANGUAGE = userenv('LANG')
254: and not exists
255: (select NULL
256: from DOM_DOCUMENT_CATALOGS_TL T
257: where T.CATALOG_ID = B.CATALOG_ID
258: and T.LANGUAGE = L.LANGUAGE_CODE);
259: end ADD_LANGUAGE;
260: