APPS.EDR_IDX_XML_ELEMENT_PKG dependencies on EDR_IDX_XML_ELEMENT_TL

Line 56: insert into EDR_IDX_XML_ELEMENT_TL (

52: X_LAST_UPDATED_BY,
53: X_LAST_UPDATE_LOGIN
54: );
55:
56: insert into EDR_IDX_XML_ELEMENT_TL (
57: LAST_UPDATE_DATE,
58: LAST_UPDATED_BY,
59: LAST_UPDATE_LOGIN,
60: CREATED_BY,

Line 82: from EDR_IDX_XML_ELEMENT_TL T

78: from FND_LANGUAGES L
79: where L.INSTALLED_FLAG in ('I', 'B')
80: and not exists
81: (select NULL
82: from EDR_IDX_XML_ELEMENT_TL T
83: where T.ELEMENT_ID = X_ELEMENT_ID
84: and T.LANGUAGE = L.LANGUAGE_CODE);
85: */
86: INSERT_ROW

Line 176: insert into EDR_IDX_XML_ELEMENT_TL (

172: X_LAST_UPDATED_BY,
173: X_LAST_UPDATE_LOGIN
174: );
175:
176: insert into EDR_IDX_XML_ELEMENT_TL (
177: LAST_UPDATE_DATE,
178: LAST_UPDATED_BY,
179: LAST_UPDATE_LOGIN,
180: CREATED_BY,

Line 202: from EDR_IDX_XML_ELEMENT_TL T

198: from FND_LANGUAGES L
199: where L.INSTALLED_FLAG in ('I', 'B')
200: and not exists
201: (select NULL
202: from EDR_IDX_XML_ELEMENT_TL T
203: where T.ELEMENT_ID = X_ELEMENT_ID
204: and T.LANGUAGE = L.LANGUAGE_CODE);
205: end INSERT_ROW;
206: --Bug 3783242 : End

Line 235: from EDR_IDX_XML_ELEMENT_TL

231: cursor c1 is select
232: DISPLAY_NAME,
233: DESCRIPTION,
234: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
235: from EDR_IDX_XML_ELEMENT_TL
236: where ELEMENT_ID = X_ELEMENT_ID
237: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
238: for update of ELEMENT_ID nowait;
239: begin

Line 309: update EDR_IDX_XML_ELEMENT_TL set

305: if (sql%notfound) then
306: raise no_data_found;
307: end if;
308:
309: update EDR_IDX_XML_ELEMENT_TL set
310: DISPLAY_NAME = X_DISPLAY_NAME,
311: DESCRIPTION = X_DESCRIPTION,
312: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
313: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 322: insert into EDR_IDX_XML_ELEMENT_TL (

318:
319: if (sql%notfound) then
320: --Bug 4417387: Start
321: --raise no_data_found;
322: insert into EDR_IDX_XML_ELEMENT_TL (
323: LAST_UPDATE_DATE,
324: LAST_UPDATED_BY,
325: LAST_UPDATE_LOGIN,
326: CREATED_BY,

Line 348: from EDR_IDX_XML_ELEMENT_TL T

344: from FND_LANGUAGES L
345: where L.INSTALLED_FLAG in ('I', 'B')
346: and not exists
347: (select NULL
348: from EDR_IDX_XML_ELEMENT_TL T
349: where T.ELEMENT_ID = X_ELEMENT_ID
350: and T.LANGUAGE = L.LANGUAGE_CODE);
351: --Bug 4417387: End
352: end if;

Line 360: delete from EDR_IDX_XML_ELEMENT_TL

356: procedure DELETE_ROW (
357: X_ELEMENT_ID in NUMBER
358: ) is
359: begin
360: delete from EDR_IDX_XML_ELEMENT_TL
361: where ELEMENT_ID = X_ELEMENT_ID;
362:
363: if (sql%notfound) then
364: raise no_data_found;

Line 378: delete from EDR_IDX_XML_ELEMENT_TL T

374:
375: procedure ADD_LANGUAGE
376: is
377: begin
378: delete from EDR_IDX_XML_ELEMENT_TL T
379: where not exists
380: (select NULL
381: from EDR_IDX_XML_ELEMENT_B B
382: where B.ELEMENT_ID = T.ELEMENT_ID

Line 385: update EDR_IDX_XML_ELEMENT_TL T set (

381: from EDR_IDX_XML_ELEMENT_B B
382: where B.ELEMENT_ID = T.ELEMENT_ID
383: );
384:
385: update EDR_IDX_XML_ELEMENT_TL T set (
386: DISPLAY_NAME,
387: DESCRIPTION
388: ) = (select
389: B.DISPLAY_NAME,

Line 391: from EDR_IDX_XML_ELEMENT_TL B

387: DESCRIPTION
388: ) = (select
389: B.DISPLAY_NAME,
390: B.DESCRIPTION
391: from EDR_IDX_XML_ELEMENT_TL B
392: where B.ELEMENT_ID = T.ELEMENT_ID
393: and B.LANGUAGE = T.SOURCE_LANG)
394: where (
395: T.ELEMENT_ID,

Line 400: from EDR_IDX_XML_ELEMENT_TL SUBB, EDR_IDX_XML_ELEMENT_TL SUBT

396: T.LANGUAGE
397: ) in (select
398: SUBT.ELEMENT_ID,
399: SUBT.LANGUAGE
400: from EDR_IDX_XML_ELEMENT_TL SUBB, EDR_IDX_XML_ELEMENT_TL SUBT
401: where SUBB.ELEMENT_ID = SUBT.ELEMENT_ID
402: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
403: and (SUBB.DISPLAY_NAME <> SUBT.DISPLAY_NAME
404: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 409: insert into EDR_IDX_XML_ELEMENT_TL (

405: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
406: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
407: ));
408:
409: insert into EDR_IDX_XML_ELEMENT_TL (
410: LAST_UPDATE_DATE,
411: LAST_UPDATED_BY,
412: LAST_UPDATE_LOGIN,
413: CREATED_BY,

Line 431: from EDR_IDX_XML_ELEMENT_TL B, FND_LANGUAGES L

427: B.DISPLAY_NAME,
428: B.DESCRIPTION,
429: L.LANGUAGE_CODE,
430: B.SOURCE_LANG
431: from EDR_IDX_XML_ELEMENT_TL B, FND_LANGUAGES L
432: where L.INSTALLED_FLAG in ('I', 'B')
433: and B.LANGUAGE = userenv('LANG')
434: and not exists
435: (select NULL

Line 436: from EDR_IDX_XML_ELEMENT_TL T

432: where L.INSTALLED_FLAG in ('I', 'B')
433: and B.LANGUAGE = userenv('LANG')
434: and not exists
435: (select NULL
436: from EDR_IDX_XML_ELEMENT_TL T
437: where T.ELEMENT_ID = B.ELEMENT_ID
438: and T.LANGUAGE = L.LANGUAGE_CODE);
439: end ADD_LANGUAGE;
440: