eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XTR_SYS_LANGUAGES_PKG dependencies on XTR_SYS_LANGUAGES

Line 1: package body XTR_SYS_LANGUAGES_PKG as

1: package body XTR_SYS_LANGUAGES_PKG as
2: /* $Header: xtrlangb.pls 120.3 2005/06/29 10:10:50 badiredd ship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out NOCOPY VARCHAR2,
5: X_MODULE_NAME in VARCHAR2,

Line 16: cursor C is select ROWID from XTR_SYS_LANGUAGES

12: X_LAST_UPDATE_DATE in DATE,
13: X_LAST_UPDATED_BY in NUMBER,
14: X_LAST_UPDATE_LOGIN in NUMBER
15: ) is
16: cursor C is select ROWID from XTR_SYS_LANGUAGES
17: where MODULE_NAME = X_MODULE_NAME
18: and CANVAS_TYPE = X_CANVAS_TYPE
19: and ITEM_NAME = X_ITEM_NAME
20: ;

Line 23: insert into XTR_SYS_LANGUAGES (

19: and ITEM_NAME = X_ITEM_NAME
20: ;
21: v_rowid VARCHAR2(30);
22: begin
23: insert into XTR_SYS_LANGUAGES (
24: MODULE_NAME,
25: CANVAS_TYPE,
26: ITEM_NAME,
27: ORIGINAL_TEXT,

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 107: xtr_sys_languages_pkg.update_row (

103: user_id:=1;
104: else
105: user_id:=0;
106: end if;
107: xtr_sys_languages_pkg.update_row (
108: x_module_name => X_MODULE_NAME,
109: x_canvas_type => X_CANVAS_TYPE,
110: x_item_name => X_ITEM_NAME,
111: x_original_text => X_ORIGINAL_TEXT ,

Line 119: xtr_sys_languages_pkg.insert_row(

115: x_last_updated_by => user_id,
116: x_last_update_login => 0);
117: exception
118: when no_data_found then
119: xtr_sys_languages_pkg.insert_row(
120: X_ROWID => row_id,
121: x_module_name => X_MODULE_NAME,
122: x_canvas_type => X_CANVAS_TYPE,
123: x_item_name => X_ITEM_NAME,

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 193: /* need to update xtr_sys_languages if original_text

189: declare
190: l_last_updated_by number;
191: l_original_text varchar2(100);
192: begin
193: /* need to update xtr_sys_languages if original_text
194: is changed */
195: select original_text
196: into l_original_text
197: from xtr_sys_languages

Line 197: from xtr_sys_languages

193: /* need to update xtr_sys_languages if original_text
194: is changed */
195: select original_text
196: into l_original_text
197: from xtr_sys_languages
198: where MODULE_NAME = X_MODULE_NAME
199: and CANVAS_TYPE = X_CANVAS_TYPE
200: and ITEM_NAME = X_ITEM_NAME;
201:

Line 206: update XTR_SYS_LANGUAGES set

202: if ((l_original_text <> x_original_text)
203: and
204: (x_original_text is not null))
205: then
206: update XTR_SYS_LANGUAGES set
207: ORIGINAL_TEXT = X_ORIGINAL_TEXT,
208: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
209: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
210: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN

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 267: xtr_sys_languages_pkg.update_row (

263: user_id:=1;
264: else
265: user_id:=0;
266: end if;
267: xtr_sys_languages_pkg.update_row (
268: x_module_name => X_MODULE_NAME,
269: x_canvas_type => X_CANVAS_TYPE,
270: x_item_name => X_ITEM_NAME,
271: x_original_text => X_ORIGINAL_TEXT ,

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 308: delete from XTR_SYS_LANGUAGES

304: if (sql%notfound) then
305: raise no_data_found;
306: end if;
307:
308: delete from XTR_SYS_LANGUAGES
309: where MODULE_NAME = X_MODULE_NAME
310: and CANVAS_TYPE = X_CANVAS_TYPE
311: and ITEM_NAME = X_ITEM_NAME;
312:

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 324: from XTR_SYS_LANGUAGES B

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
326: and B.CANVAS_TYPE = T.CANVAS_TYPE
327: and B.ITEM_NAME = T.ITEM_NAME
328: );

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);

Line 395: end XTR_SYS_LANGUAGES_PKG;

391: and T.ITEM_NAME = B.ITEM_NAME
392: and T.LANGUAGE = L.LANGUAGE_CODE);
393: end ADD_LANGUAGE;
394:
395: end XTR_SYS_LANGUAGES_PKG;