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.FND_NATURAL_LANGUAGES_PKG dependencies on FND_NATURAL_LANGUAGES

Line 1: package body FND_NATURAL_LANGUAGES_PKG as

1: package body FND_NATURAL_LANGUAGES_PKG as
2: /* $Header: AFNLNTLB.pls 115.1 2004/04/15 22:14:58 rsuzuki noship $ */
3:
4: procedure INSERT_ROW (
5: X_ROWID in out nocopy VARCHAR2,

Line 18: cursor C is select ROWID from FND_NATURAL_LANGUAGES

14: X_LAST_UPDATE_DATE in DATE,
15: X_LAST_UPDATED_BY in NUMBER,
16: X_LAST_UPDATE_LOGIN in NUMBER
17: ) is
18: cursor C is select ROWID from FND_NATURAL_LANGUAGES
19: where LANGUAGE_CODE = X_LANGUAGE_CODE
20: ;
21: begin
22: insert into FND_NATURAL_LANGUAGES (

Line 22: insert into FND_NATURAL_LANGUAGES (

18: cursor C is select ROWID from FND_NATURAL_LANGUAGES
19: where LANGUAGE_CODE = X_LANGUAGE_CODE
20: ;
21: begin
22: insert into FND_NATURAL_LANGUAGES (
23: LANGUAGE_CODE,
24: ISO_LANGUAGE_3,
25: ISO_TERRITORY,
26: ENABLED_FLAG,

Line 44: insert into FND_NATURAL_LANGUAGES_TL (

40: X_LAST_UPDATED_BY,
41: X_LAST_UPDATE_LOGIN
42: );
43:
44: insert into FND_NATURAL_LANGUAGES_TL (
45: LANGUAGE_CODE,
46: NAME,
47: DESCRIPTION,
48: CREATED_BY,

Line 70: from FND_NATURAL_LANGUAGES_TL T

66: from FND_LANGUAGES L
67: where L.INSTALLED_FLAG in ('I', 'B')
68: and not exists
69: (select NULL
70: from FND_NATURAL_LANGUAGES_TL T
71: where T.LANGUAGE_CODE = X_LANGUAGE_CODE
72: and T.LANGUAGE = L.LANGUAGE_CODE);
73:
74: open c;

Line 96: from FND_NATURAL_LANGUAGES

92: cursor c is select
93: ISO_LANGUAGE_3,
94: ISO_TERRITORY,
95: ENABLED_FLAG
96: from FND_NATURAL_LANGUAGES
97: where LANGUAGE_CODE = X_LANGUAGE_CODE
98: for update of LANGUAGE_CODE nowait;
99: recinfo c%rowtype;
100:

Line 105: from FND_NATURAL_LANGUAGES_TL

101: cursor c1 is select
102: NAME,
103: DESCRIPTION,
104: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
105: from FND_NATURAL_LANGUAGES_TL
106: where LANGUAGE_CODE = X_LANGUAGE_CODE
107: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
108: for update of LANGUAGE_CODE nowait;
109: begin

Line 157: update FND_NATURAL_LANGUAGES set

153: X_LAST_UPDATED_BY in NUMBER,
154: X_LAST_UPDATE_LOGIN in NUMBER
155: ) is
156: begin
157: update FND_NATURAL_LANGUAGES set
158: ISO_LANGUAGE_3 = X_ISO_LANGUAGE_3,
159: ISO_TERRITORY = X_ISO_TERRITORY,
160: ENABLED_FLAG = X_ENABLED_FLAG,
161: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 170: update FND_NATURAL_LANGUAGES_TL set

166: if (sql%notfound) then
167: raise no_data_found;
168: end if;
169:
170: update FND_NATURAL_LANGUAGES_TL set
171: NAME = X_NAME,
172: DESCRIPTION = X_DESCRIPTION,
173: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
174: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 189: delete from FND_NATURAL_LANGUAGES_TL

185: procedure DELETE_ROW (
186: X_LANGUAGE_CODE in VARCHAR2
187: ) is
188: begin
189: delete from FND_NATURAL_LANGUAGES_TL
190: where LANGUAGE_CODE = X_LANGUAGE_CODE;
191:
192: if (sql%notfound) then
193: raise no_data_found;

Line 196: delete from FND_NATURAL_LANGUAGES

192: if (sql%notfound) then
193: raise no_data_found;
194: end if;
195:
196: delete from FND_NATURAL_LANGUAGES
197: where LANGUAGE_CODE = X_LANGUAGE_CODE;
198:
199: if (sql%notfound) then
200: raise no_data_found;

Line 212: delete from FND_NATURAL_LANGUAGES_TL T

208: /* The following update statements are commented out */
209: /* as a quick workaround to fix the time-consuming table handler issue */
210: /* Eventually we'll need to turn them into a separate fix_language procedure */
211: /*
212: delete from FND_NATURAL_LANGUAGES_TL T
213: where not exists
214: (select NULL
215: from FND_NATURAL_LANGUAGES B
216: where B.LANGUAGE_CODE = T.LANGUAGE_CODE

Line 215: from FND_NATURAL_LANGUAGES B

211: /*
212: delete from FND_NATURAL_LANGUAGES_TL T
213: where not exists
214: (select NULL
215: from FND_NATURAL_LANGUAGES B
216: where B.LANGUAGE_CODE = T.LANGUAGE_CODE
217: );
218:
219: update FND_NATURAL_LANGUAGES_TL T set (

Line 219: update FND_NATURAL_LANGUAGES_TL T set (

215: from FND_NATURAL_LANGUAGES B
216: where B.LANGUAGE_CODE = T.LANGUAGE_CODE
217: );
218:
219: update FND_NATURAL_LANGUAGES_TL T set (
220: NAME,
221: DESCRIPTION
222: ) = (select
223: B.NAME,

Line 225: from FND_NATURAL_LANGUAGES_TL B

221: DESCRIPTION
222: ) = (select
223: B.NAME,
224: B.DESCRIPTION
225: from FND_NATURAL_LANGUAGES_TL B
226: where B.LANGUAGE_CODE = T.LANGUAGE_CODE
227: and B.LANGUAGE = T.SOURCE_LANG)
228: where (
229: T.LANGUAGE_CODE,

Line 234: from FND_NATURAL_LANGUAGES_TL SUBB, FND_NATURAL_LANGUAGES_TL SUBT

230: T.LANGUAGE
231: ) in (select
232: SUBT.LANGUAGE_CODE,
233: SUBT.LANGUAGE
234: from FND_NATURAL_LANGUAGES_TL SUBB, FND_NATURAL_LANGUAGES_TL SUBT
235: where SUBB.LANGUAGE_CODE = SUBT.LANGUAGE_CODE
236: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
237: and (SUBB.NAME <> SUBT.NAME
238: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 242: insert into FND_NATURAL_LANGUAGES_TL (

238: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION
239: ));
240: */
241:
242: insert into FND_NATURAL_LANGUAGES_TL (
243: LANGUAGE_CODE,
244: NAME,
245: DESCRIPTION,
246: CREATED_BY,

Line 264: from FND_NATURAL_LANGUAGES_TL B, FND_LANGUAGES L

260: B.LAST_UPDATE_DATE,
261: B.LAST_UPDATE_LOGIN,
262: L.LANGUAGE_CODE,
263: B.SOURCE_LANG
264: from FND_NATURAL_LANGUAGES_TL B, FND_LANGUAGES L
265: where L.INSTALLED_FLAG in ('I', 'B')
266: and B.LANGUAGE = userenv('LANG')
267: and not exists
268: (select NULL

Line 269: from FND_NATURAL_LANGUAGES_TL T

265: where L.INSTALLED_FLAG in ('I', 'B')
266: and B.LANGUAGE = userenv('LANG')
267: and not exists
268: (select NULL
269: from FND_NATURAL_LANGUAGES_TL T
270: where T.LANGUAGE_CODE = B.LANGUAGE_CODE
271: and T.LANGUAGE = L.LANGUAGE_CODE);
272: end ADD_LANGUAGE;
273:

Line 297: from fnd_natural_languages_tl

293:
294: begin
295: select last_updated_by, last_update_date
296: into db_luby, db_ludate
297: from fnd_natural_languages_tl
298: where language_code = X_LANGUAGE_CODE
299: and language = userenv('LANG');
300:
301: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

Line 303: update FND_NATURAL_LANGUAGES_TL set

299: and language = userenv('LANG');
300:
301: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
302: db_ludate, X_CUSTOM_MODE)) then
303: update FND_NATURAL_LANGUAGES_TL set
304: NAME = X_NAME,
305: DESCRIPTION = X_DESCRIPTION,
306: LAST_UPDATE_DATE = f_ludate,
307: LAST_UPDATED_BY = f_luby,

Line 347: from fnd_natural_languages

343:
344: begin
345: select LAST_UPDATED_BY, LAST_UPDATE_DATE
346: into db_luby, db_ludate
347: from fnd_natural_languages
348: where language_code = X_LANGUAGE_CODE;
349:
350: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
351: db_ludate, X_CUSTOM_MODE)) then

Line 352: FND_NATURAL_LANGUAGES_PKG.UPDATE_ROW(

348: where language_code = X_LANGUAGE_CODE;
349:
350: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
351: db_ludate, X_CUSTOM_MODE)) then
352: FND_NATURAL_LANGUAGES_PKG.UPDATE_ROW(
353: X_LANGUAGE_CODE,
354: X_ISO_LANGUAGE_3,
355: X_ISO_TERRITORY,
356: X_ENABLED_FLAG,

Line 366: FND_NATURAL_LANGUAGES_PKG.INSERT_ROW(

362: end if;
363:
364: exception
365: when no_data_found then
366: FND_NATURAL_LANGUAGES_PKG.INSERT_ROW(
367: X_ROWID,
368: X_LANGUAGE_CODE,
369: X_ISO_LANGUAGE_3,
370: X_ISO_TERRITORY,

Line 382: end FND_NATURAL_LANGUAGES_PKG;

378: 0);
379: end;
380: end LOAD_ROW;
381:
382: end FND_NATURAL_LANGUAGES_PKG;