APPS.ECX_XREF_DTL_PKG dependencies on ECX_XREF_DTL_TL

Line 45: from ECX_XREF_DTL_TL

41: and direction = X_DIRECTION;
42:
43: select LAST_UPDATED_BY, LAST_UPDATE_DATE
44: into l_db_luby, l_db_ludate
45: from ECX_XREF_DTL_TL
46: where XREF_DTL_ID = l_dtl_id
47: and LANGUAGE = userenv('LANG');
48:
49: -- Update record, honoring customization mode.

Line 58: update ECX_XREF_DTL_TL set

54: if ((x_custom_mode = 'FORCE') or
55: ((l_luby = 0) and (l_db_luby = 1)) or
56: ((l_luby = l_db_luby) and (l_ludate > l_db_ludate)))
57: then
58: update ECX_XREF_DTL_TL set
59: DESCRIPTION = nvl(x_description, DESCRIPTION),
60: SOURCE_LANG = userenv('LANG'),
61: LAST_UPDATE_DATE = l_ludate,
62: LAST_UPDATED_BY = l_luby,

Line 227: insert into ECX_XREF_DTL_TL (

223: X_LAST_UPDATED_BY,
224: X_LAST_UPDATE_LOGIN
225: );
226:
227: insert into ECX_XREF_DTL_TL (
228: XREF_DTL_ID,
229: DESCRIPTION,
230: LAST_UPDATE_DATE,
231: LAST_UPDATED_BY,

Line 251: from ECX_XREF_DTL_TL T

247: from WF_LANGUAGES L
248: where L.INSTALLED_FLAG = 'Y'
249: and not exists
250: (select NULL
251: from ECX_XREF_DTL_TL T
252: where T.XREF_DTL_ID = X_XREF_DTL_ID
253: and T.LANGUAGE = L.CODE);
254:
255: open c;

Line 292: from ECX_XREF_DTL_TL

288:
289: cursor c1 is select
290: DESCRIPTION,
291: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
292: from ECX_XREF_DTL_TL
293: where XREF_DTL_ID = X_XREF_DTL_ID
294: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
295: for update of XREF_DTL_ID nowait;
296: begin

Line 367: update ECX_XREF_DTL_TL set

363: if (sql%notfound) then
364: raise no_data_found;
365: end if;
366:
367: update ECX_XREF_DTL_TL set
368: DESCRIPTION = X_DESCRIPTION,
369: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
370: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
371: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 385: delete from ECX_XREF_DTL_TL

381: procedure DELETE_ROW (
382: X_XREF_DTL_ID in NUMBER
383: ) is
384: begin
385: delete from ECX_XREF_DTL_TL
386: where XREF_DTL_ID = X_XREF_DTL_ID;
387:
388: if (sql%notfound) then
389: raise no_data_found;

Line 403: delete from ECX_XREF_DTL_TL T

399:
400: procedure ADD_LANGUAGE
401: is
402: begin
403: delete from ECX_XREF_DTL_TL T
404: where not exists
405: (select NULL
406: from ECX_XREF_DTL_B B
407: where B.XREF_DTL_ID = T.XREF_DTL_ID

Line 410: update ECX_XREF_DTL_TL T set (

406: from ECX_XREF_DTL_B B
407: where B.XREF_DTL_ID = T.XREF_DTL_ID
408: );
409:
410: update ECX_XREF_DTL_TL T set (
411: DESCRIPTION
412: ) = (select
413: B.DESCRIPTION
414: from ECX_XREF_DTL_TL B

Line 414: from ECX_XREF_DTL_TL B

410: update ECX_XREF_DTL_TL T set (
411: DESCRIPTION
412: ) = (select
413: B.DESCRIPTION
414: from ECX_XREF_DTL_TL B
415: where B.XREF_DTL_ID = T.XREF_DTL_ID
416: and B.LANGUAGE = T.SOURCE_LANG)
417: where (
418: T.XREF_DTL_ID,

Line 423: from ECX_XREF_DTL_TL SUBB, ECX_XREF_DTL_TL SUBT

419: T.LANGUAGE
420: ) in (select
421: SUBT.XREF_DTL_ID,
422: SUBT.LANGUAGE
423: from ECX_XREF_DTL_TL SUBB, ECX_XREF_DTL_TL SUBT
424: where SUBB.XREF_DTL_ID = SUBT.XREF_DTL_ID
425: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
426: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
427: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)

Line 431: insert into ECX_XREF_DTL_TL (

427: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
428: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
429: ));
430:
431: insert into ECX_XREF_DTL_TL (
432: XREF_DTL_ID,
433: DESCRIPTION,
434: LAST_UPDATE_DATE,
435: LAST_UPDATED_BY,

Line 451: from ECX_XREF_DTL_TL B, WF_LANGUAGES L

447: B.CREATED_BY,
448: B.LAST_UPDATE_LOGIN,
449: L.CODE,
450: B.SOURCE_LANG
451: from ECX_XREF_DTL_TL B, WF_LANGUAGES L
452: where L.INSTALLED_FLAG = 'Y'
453: and B.LANGUAGE = userenv('LANG')
454: and not exists
455: (select NULL

Line 456: from ECX_XREF_DTL_TL T

452: where L.INSTALLED_FLAG = 'Y'
453: and B.LANGUAGE = userenv('LANG')
454: and not exists
455: (select NULL
456: from ECX_XREF_DTL_TL T
457: where T.XREF_DTL_ID = B.XREF_DTL_ID
458: and T.LANGUAGE = L.CODE);
459: end ADD_LANGUAGE;
460: