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_CATALOGS_PKG dependencies on DOM_DOCUMENT_CATALOGS

Line 1: package body DOM_DOCUMENT_CATALOGS_PKG as

1: package body DOM_DOCUMENT_CATALOGS_PKG as
2: /* $Header: DOMCATB.pls 120.0 2006/02/23 02:12:07 ysireesh noship $ */
3:
4: procedure INSERT_ROW (
5: X_ROWID in out nocopy VARCHAR2,

Line 16: cursor C is select ROWID from DOM_DOCUMENT_CATALOGS

12: X_LAST_UPDATE_DATE in DATE,
13: X_LAST_UPDATED_BY in NUMBER,
14: X_LAST_UPDATE_LOGIN in NUMBER
15: ) is
16: cursor C is select ROWID from DOM_DOCUMENT_CATALOGS
17: where CATALOG_ID = X_CATALOG_ID
18: ;
19: begin
20: insert into DOM_DOCUMENT_CATALOGS (

Line 20: insert into DOM_DOCUMENT_CATALOGS (

16: cursor C is select ROWID from DOM_DOCUMENT_CATALOGS
17: where CATALOG_ID = X_CATALOG_ID
18: ;
19: begin
20: insert into DOM_DOCUMENT_CATALOGS (
21: CATALOG_ID,
22: INTERNAL_NAME,
23: CREATION_DATE,
24: CREATED_BY,

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 88: from DOM_DOCUMENT_CATALOGS

84: X_DESCRIPTION in VARCHAR2
85: ) is
86: cursor c is select
87: INTERNAL_NAME
88: from DOM_DOCUMENT_CATALOGS
89: where CATALOG_ID = X_CATALOG_ID
90: for update of CATALOG_ID nowait;
91: recinfo c%rowtype;
92:

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 146: update DOM_DOCUMENT_CATALOGS set

142: X_LAST_UPDATED_BY in NUMBER,
143: X_LAST_UPDATE_LOGIN in NUMBER
144: ) is
145: begin
146: update DOM_DOCUMENT_CATALOGS set
147: INTERNAL_NAME = X_INTERNAL_NAME,
148: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
149: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
150: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN

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 183: delete from DOM_DOCUMENT_CATALOGS

179: if (sql%notfound) then
180: raise no_data_found;
181: end if;
182:
183: delete from DOM_DOCUMENT_CATALOGS
184: where CATALOG_ID = X_CATALOG_ID;
185:
186: if (sql%notfound) then
187: 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 197: from DOM_DOCUMENT_CATALOGS B

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
199: );
200:
201: update DOM_DOCUMENT_CATALOGS_TL T set (

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:

Line 261: end DOM_DOCUMENT_CATALOGS_PKG;

257: where T.CATALOG_ID = B.CATALOG_ID
258: and T.LANGUAGE = L.LANGUAGE_CODE);
259: end ADD_LANGUAGE;
260:
261: end DOM_DOCUMENT_CATALOGS_PKG;