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_REPOSITORIES_PKG dependencies on DOM_REPOSITORIES

Line 1: package body DOM_REPOSITORIES_PKG as

1: package body DOM_REPOSITORIES_PKG as
2: /* $Header: DOMREPOB.pls 120.6 2005/11/18 01:23 ysireesh noship $ */
3:
4: procedure INSERT_ROW (
5: X_ROWID in out nocopy VARCHAR2,

Line 21: cursor C is select ROWID from DOM_REPOSITORIES

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_REPOSITORIES
22: where ID = X_ID ;
23: begin
24: insert into DOM_REPOSITORIES (
25: DAV_URL,

Line 24: insert into DOM_REPOSITORIES (

20: ) is
21: cursor C is select ROWID from DOM_REPOSITORIES
22: where ID = X_ID ;
23: begin
24: insert into DOM_REPOSITORIES (
25: DAV_URL,
26: SEQUENCE,
27: CERTIFICATE_PATH,
28: ID,

Line 54: insert into DOM_REPOSITORIES_TL (

50: X_LAST_UPDATED_BY,
51: X_LAST_UPDATE_LOGIN
52: );
53:
54: insert into DOM_REPOSITORIES_TL (
55: CREATED_BY,
56: CREATION_DATE,
57: LAST_UPDATED_BY,
58: LAST_UPDATE_DATE,

Line 80: from DOM_REPOSITORIES_TL T

76: from FND_LANGUAGES L
77: where L.INSTALLED_FLAG in ('I', 'B')
78: and not exists
79: (select NULL
80: from DOM_REPOSITORIES_TL T
81: where T.ID = X_ID
82: and T.LANGUAGE = L.LANGUAGE_CODE);
83:
84: open c;

Line 112: from DOM_REPOSITORIES

108: CERTIFICATE_PATH,
109: SHORT_NAME,
110: PROTOCOL,
111: SERVICE_URL
112: from DOM_REPOSITORIES
113: where ID = X_ID
114: for update of ID nowait;
115: recinfo c%rowtype;
116:

Line 121: from DOM_REPOSITORIES_TL

117: cursor c1 is select
118: NAME,
119: DESCRIPTION,
120: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
121: from DOM_REPOSITORIES_TL
122: where ID = X_ID
123: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
124: for update of ID nowait;
125: begin

Line 185: update DOM_REPOSITORIES set

181: X_LAST_UPDATED_BY in NUMBER,
182: X_LAST_UPDATE_LOGIN in NUMBER
183: ) is
184: begin
185: update DOM_REPOSITORIES set
186: DAV_URL = X_DAV_URL,
187: SEQUENCE = X_SEQUENCE,
188: CERTIFICATE_PATH = X_CERTIFICATE_PATH,
189: SHORT_NAME = X_SHORT_NAME,

Line 201: update DOM_REPOSITORIES_TL set

197: if (sql%notfound) then
198: raise no_data_found;
199: end if;
200:
201: update DOM_REPOSITORIES_TL set
202: NAME = X_NAME,
203: DESCRIPTION = X_DESCRIPTION,
204: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
205: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 220: delete from DOM_REPOSITORIES_TL

216: procedure DELETE_ROW (
217: X_ID in NUMBER
218: ) is
219: begin
220: delete from DOM_REPOSITORIES_TL
221: where ID = X_ID;
222:
223: if (sql%notfound) then
224: raise no_data_found;

Line 227: delete from DOM_REPOSITORIES

223: if (sql%notfound) then
224: raise no_data_found;
225: end if;
226:
227: delete from DOM_REPOSITORIES
228: where ID = X_ID;
229:
230: if (sql%notfound) then
231: raise no_data_found;

Line 239: delete from DOM_REPOSITORIES_TL T

235: procedure ADD_LANGUAGE
236: is
237: begin
238:
239: delete from DOM_REPOSITORIES_TL T
240: where not exists
241: (select NULL
242: from DOM_REPOSITORIES B
243: where B.ID = T.ID

Line 242: from DOM_REPOSITORIES B

238:
239: delete from DOM_REPOSITORIES_TL T
240: where not exists
241: (select NULL
242: from DOM_REPOSITORIES B
243: where B.ID = T.ID
244: );
245:
246: update DOM_REPOSITORIES_TL T set (

Line 246: update DOM_REPOSITORIES_TL T set (

242: from DOM_REPOSITORIES B
243: where B.ID = T.ID
244: );
245:
246: update DOM_REPOSITORIES_TL T set (
247: NAME,
248: DESCRIPTION
249: ) = (select
250: B.NAME,

Line 252: from DOM_REPOSITORIES_TL B

248: DESCRIPTION
249: ) = (select
250: B.NAME,
251: B.DESCRIPTION
252: from DOM_REPOSITORIES_TL B
253: where B.ID = T.ID
254: and B.LANGUAGE = T.SOURCE_LANG)
255: where (
256: T.ID,

Line 261: from DOM_REPOSITORIES_TL SUBB, DOM_REPOSITORIES_TL SUBT

257: T.LANGUAGE
258: ) in (select
259: SUBT.ID,
260: SUBT.LANGUAGE
261: from DOM_REPOSITORIES_TL SUBB, DOM_REPOSITORIES_TL SUBT
262: where SUBB.ID = SUBT.ID
263: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
264: and (SUBB.NAME <> SUBT.NAME
265: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 270: insert into DOM_REPOSITORIES_TL(

266: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
267: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
268: ));
269:
270: insert into DOM_REPOSITORIES_TL(
271: ID,
272: NAME,
273: DESCRIPTION,
274: CREATION_DATE,

Line 292: from DOM_REPOSITORIES_TL B, FND_LANGUAGES L

288: B.LAST_UPDATED_BY,
289: B.LAST_UPDATE_LOGIN,
290: L.LANGUAGE_CODE,
291: B.SOURCE_LANG
292: from DOM_REPOSITORIES_TL B, FND_LANGUAGES L
293: where L.INSTALLED_FLAG in ('I', 'B')
294: and B.LANGUAGE = userenv('LANG')
295: and not exists
296: (select NULL

Line 297: from DOM_REPOSITORIES_TL T

293: where L.INSTALLED_FLAG in ('I', 'B')
294: and B.LANGUAGE = userenv('LANG')
295: and not exists
296: (select NULL
297: from DOM_REPOSITORIES_TL T
298: where T.ID = B.ID
299: and T.LANGUAGE = L.LANGUAGE_CODE);
300: end ADD_LANGUAGE;
301:

Line 302: end DOM_REPOSITORIES_PKG;

298: where T.ID = B.ID
299: and T.LANGUAGE = L.LANGUAGE_CODE);
300: end ADD_LANGUAGE;
301:
302: end DOM_REPOSITORIES_PKG;