APPS.DOM_REPOSITORIES_PKG dependencies on DOM_REPOSITORIES_TL

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 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 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 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 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: