APPS.ECX_XREF_STANDARDS_PKG dependencies on ECX_XREF_STANDARDS_TL

Line 43: from ECX_XREF_STANDARDS_TL

39: and XREF_INT_VALUE = X_XREF_INT_VALUE;
40:
41: select LAST_UPDATED_BY, LAST_UPDATE_DATE
42: into l_db_luby, l_db_ludate
43: from ECX_XREF_STANDARDS_TL
44: where XREF_STANDARD_ID = l_xref_standard_id
45: and LANGUAGE = userenv('LANG');
46:
47: -- Update record, honoring customization mode.

Line 56: update ECX_XREF_STANDARDS_TL set

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

Line 225: insert into ECX_XREF_STANDARDS_TL (

221: X_LAST_UPDATED_BY,
222: X_LAST_UPDATE_LOGIN
223: );
224:
225: insert into ECX_XREF_STANDARDS_TL (
226: XREF_STANDARD_ID,
227: DESCRIPTION,
228: LAST_UPDATE_DATE,
229: LAST_UPDATED_BY,

Line 249: from ECX_XREF_STANDARDS_TL T

245: from WF_LANGUAGES L
246: where L.INSTALLED_FLAG = 'Y'
247: and not exists
248: (select NULL
249: from ECX_XREF_STANDARDS_TL T
250: where T.XREF_STANDARD_ID = X_XREF_STANDARD_ID
251: and T.LANGUAGE = L.CODE);
252:
253: open c;

Line 288: from ECX_XREF_STANDARDS_TL

284:
285: cursor c1 is select
286: DESCRIPTION,
287: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
288: from ECX_XREF_STANDARDS_TL
289: where XREF_STANDARD_ID = X_XREF_STANDARD_ID
290: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
291: for update of XREF_STANDARD_ID nowait;
292: begin

Line 362: update ECX_XREF_STANDARDS_TL set

358: if (sql%notfound) then
359: raise no_data_found;
360: end if;
361:
362: update ECX_XREF_STANDARDS_TL set
363: DESCRIPTION = X_DESCRIPTION,
364: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
365: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
366: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 380: delete from ECX_XREF_STANDARDS_TL

376: procedure DELETE_ROW (
377: X_XREF_STANDARD_ID in NUMBER
378: ) is
379: begin
380: delete from ECX_XREF_STANDARDS_TL
381: where XREF_STANDARD_ID = X_XREF_STANDARD_ID;
382:
383: if (sql%notfound) then
384: raise no_data_found;

Line 398: delete from ECX_XREF_STANDARDS_TL T

394:
395: procedure ADD_LANGUAGE
396: is
397: begin
398: delete from ECX_XREF_STANDARDS_TL T
399: where not exists
400: (select NULL
401: from ECX_XREF_STANDARDS_B B
402: where B.XREF_STANDARD_ID = T.XREF_STANDARD_ID

Line 405: update ECX_XREF_STANDARDS_TL T set (

401: from ECX_XREF_STANDARDS_B B
402: where B.XREF_STANDARD_ID = T.XREF_STANDARD_ID
403: );
404:
405: update ECX_XREF_STANDARDS_TL T set (
406: DESCRIPTION
407: ) = (select
408: B.DESCRIPTION
409: from ECX_XREF_STANDARDS_TL B

Line 409: from ECX_XREF_STANDARDS_TL B

405: update ECX_XREF_STANDARDS_TL T set (
406: DESCRIPTION
407: ) = (select
408: B.DESCRIPTION
409: from ECX_XREF_STANDARDS_TL B
410: where B.XREF_STANDARD_ID = T.XREF_STANDARD_ID
411: and B.LANGUAGE = T.SOURCE_LANG)
412: where (
413: T.XREF_STANDARD_ID,

Line 418: from ECX_XREF_STANDARDS_TL SUBB, ECX_XREF_STANDARDS_TL SUBT

414: T.LANGUAGE
415: ) in (select
416: SUBT.XREF_STANDARD_ID,
417: SUBT.LANGUAGE
418: from ECX_XREF_STANDARDS_TL SUBB, ECX_XREF_STANDARDS_TL SUBT
419: where SUBB.XREF_STANDARD_ID = SUBT.XREF_STANDARD_ID
420: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
421: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
422: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)

Line 426: insert into ECX_XREF_STANDARDS_TL (

422: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
423: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
424: ));
425:
426: insert into ECX_XREF_STANDARDS_TL (
427: XREF_STANDARD_ID,
428: DESCRIPTION,
429: LAST_UPDATE_DATE,
430: LAST_UPDATED_BY,

Line 446: from ECX_XREF_STANDARDS_TL B, WF_LANGUAGES L

442: B.CREATED_BY,
443: B.LAST_UPDATE_LOGIN,
444: L.CODE,
445: B.SOURCE_LANG
446: from ECX_XREF_STANDARDS_TL B, WF_LANGUAGES L
447: where L.INSTALLED_FLAG = 'Y'
448: and B.LANGUAGE = userenv('LANG')
449: and not exists
450: (select NULL

Line 451: from ECX_XREF_STANDARDS_TL T

447: where L.INSTALLED_FLAG = 'Y'
448: and B.LANGUAGE = userenv('LANG')
449: and not exists
450: (select NULL
451: from ECX_XREF_STANDARDS_TL T
452: where T.XREF_STANDARD_ID = B.XREF_STANDARD_ID
453: and T.LANGUAGE = L.CODE);
454: end ADD_LANGUAGE;
455: