APPS.XTR_SYS_LANGUAGES_PKG dependencies on XTR_SYS_LANGUAGES_TL

Line 45: insert into XTR_SYS_LANGUAGES_TL (

41: X_LAST_UPDATED_BY,
42: X_LAST_UPDATE_LOGIN
43: );
44:
45: insert into XTR_SYS_LANGUAGES_TL (
46: MODULE_NAME,
47: TEXT,
48: CREATED_BY,
49: CREATION_DATE,

Line 73: from XTR_SYS_LANGUAGES_TL T

69: from FND_LANGUAGES L
70: where L.INSTALLED_FLAG in ('I', 'B')
71: and not exists
72: (select NULL
73: from XTR_SYS_LANGUAGES_TL T
74: where T.MODULE_NAME = X_MODULE_NAME
75: and T.CANVAS_TYPE = X_CANVAS_TYPE
76: and T.ITEM_NAME = X_ITEM_NAME
77: and T.LANGUAGE = L.LANGUAGE_CODE);

Line 144: from XTR_SYS_LANGUAGES_TL

140: ) is
141: cursor c1 is select
142: TEXT,
143: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
144: from XTR_SYS_LANGUAGES_TL
145: where MODULE_NAME = X_MODULE_NAME
146: and CANVAS_TYPE = X_CANVAS_TYPE
147: and ITEM_NAME = X_ITEM_NAME
148: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)

Line 219: from xtr_sys_languages_tl

215:
216: /* end of change for update of original_text */
217: select last_updated_by
218: into l_last_updated_by
219: from xtr_sys_languages_tl
220: where MODULE_NAME = X_MODULE_NAME
221: and CANVAS_TYPE = X_CANVAS_TYPE
222: and ITEM_NAME = X_ITEM_NAME
223: and LANGUAGE = userenv('LANG') ;

Line 228: update XTR_SYS_LANGUAGES_TL set

224:
225: If ( l_last_updated_by = 1 or x_last_updated_by <> 1)
226: /* Update as long as Database is not CUSTOM and File is SEED */
227: then
228: update XTR_SYS_LANGUAGES_TL set
229: TEXT = X_TEXT,
230: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
231: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
232: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 277: /* update XTR_SYS_LANGUAGES_TL set

273: x_last_update_date => sysdate ,
274: x_last_updated_by => user_id,
275: x_last_update_login => 0);
276:
277: /* update XTR_SYS_LANGUAGES_TL set
278: TEXT = X_TEXT,
279: LAST_UPDATE_DATE = sysdate,
280: LAST_UPDATED_BY = 1,
281: LAST_UPDATE_LOGIN = 0,

Line 299: delete from XTR_SYS_LANGUAGES_TL

295: X_CANVAS_TYPE in VARCHAR2,
296: X_ITEM_NAME in VARCHAR2
297: ) is
298: begin
299: delete from XTR_SYS_LANGUAGES_TL
300: where MODULE_NAME = X_MODULE_NAME
301: and CANVAS_TYPE = X_CANVAS_TYPE
302: and ITEM_NAME = X_ITEM_NAME;
303:

Line 321: delete from XTR_SYS_LANGUAGES_TL T

317:
318: procedure ADD_LANGUAGE
319: is
320: begin
321: delete from XTR_SYS_LANGUAGES_TL T
322: where not exists
323: (select NULL
324: from XTR_SYS_LANGUAGES B
325: where B.MODULE_NAME = T.MODULE_NAME

Line 330: update XTR_SYS_LANGUAGES_TL T set (

326: and B.CANVAS_TYPE = T.CANVAS_TYPE
327: and B.ITEM_NAME = T.ITEM_NAME
328: );
329:
330: update XTR_SYS_LANGUAGES_TL T set (
331: TEXT
332: ) = (select
333: B.TEXT
334: from XTR_SYS_LANGUAGES_TL B

Line 334: from XTR_SYS_LANGUAGES_TL B

330: update XTR_SYS_LANGUAGES_TL T set (
331: TEXT
332: ) = (select
333: B.TEXT
334: from XTR_SYS_LANGUAGES_TL B
335: where B.MODULE_NAME = T.MODULE_NAME
336: and B.CANVAS_TYPE = T.CANVAS_TYPE
337: and B.ITEM_NAME = T.ITEM_NAME
338: and B.LANGUAGE = T.SOURCE_LANG)

Line 349: from XTR_SYS_LANGUAGES_TL SUBB, XTR_SYS_LANGUAGES_TL SUBT

345: SUBT.MODULE_NAME,
346: SUBT.CANVAS_TYPE,
347: SUBT.ITEM_NAME,
348: SUBT.LANGUAGE
349: from XTR_SYS_LANGUAGES_TL SUBB, XTR_SYS_LANGUAGES_TL SUBT
350: where SUBB.MODULE_NAME = SUBT.MODULE_NAME
351: and SUBB.CANVAS_TYPE = SUBT.CANVAS_TYPE
352: and SUBB.ITEM_NAME = SUBT.ITEM_NAME
353: and SUBB.LANGUAGE = SUBT.SOURCE_LANG

Line 359: insert into XTR_SYS_LANGUAGES_TL (

355: or (SUBB.TEXT is null and SUBT.TEXT is not null)
356: or (SUBB.TEXT is not null and SUBT.TEXT is null)
357: ));
358:
359: insert into XTR_SYS_LANGUAGES_TL (
360: MODULE_NAME,
361: TEXT,
362: CREATED_BY,
363: CREATION_DATE,

Line 383: from XTR_SYS_LANGUAGES_TL B, FND_LANGUAGES L

379: B.CANVAS_TYPE,
380: B.ITEM_NAME,
381: L.LANGUAGE_CODE,
382: B.SOURCE_LANG
383: from XTR_SYS_LANGUAGES_TL B, FND_LANGUAGES L
384: where L.INSTALLED_FLAG in ('I', 'B')
385: and B.LANGUAGE = userenv('LANG')
386: and not exists
387: (select NULL

Line 388: from XTR_SYS_LANGUAGES_TL T

384: where L.INSTALLED_FLAG in ('I', 'B')
385: and B.LANGUAGE = userenv('LANG')
386: and not exists
387: (select NULL
388: from XTR_SYS_LANGUAGES_TL T
389: where T.MODULE_NAME = B.MODULE_NAME
390: and T.CANVAS_TYPE = B.CANVAS_TYPE
391: and T.ITEM_NAME = B.ITEM_NAME
392: and T.LANGUAGE = L.LANGUAGE_CODE);