APPS.FND_ISO_LANGUAGES_PKG dependencies on FND_ISO_LANGUAGES_TL

Line 41: insert into FND_ISO_LANGUAGES_TL (

37: X_LAST_UPDATED_BY,
38: X_LAST_UPDATE_LOGIN
39: );
40:
41: insert into FND_ISO_LANGUAGES_TL (
42: ISO_LANGUAGE_3,
43: NAME,
44: DESCRIPTION,
45: CREATED_BY,

Line 67: from FND_ISO_LANGUAGES_TL T

63: from FND_LANGUAGES L
64: where L.INSTALLED_FLAG in ('I', 'B')
65: and not exists
66: (select NULL
67: from FND_ISO_LANGUAGES_TL T
68: where T.ISO_LANGUAGE_3 = X_ISO_LANGUAGE_3
69: and T.LANGUAGE = L.LANGUAGE_CODE);
70:
71: open c;

Line 100: from FND_ISO_LANGUAGES_TL

96: cursor c1 is select
97: NAME,
98: DESCRIPTION,
99: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
100: from FND_ISO_LANGUAGES_TL
101: where ISO_LANGUAGE_3 = X_ISO_LANGUAGE_3
102: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
103: for update of ISO_LANGUAGE_3 nowait;
104: begin

Line 161: update FND_ISO_LANGUAGES_TL set

157: if (sql%notfound) then
158: raise no_data_found;
159: end if;
160:
161: update FND_ISO_LANGUAGES_TL set
162: NAME = X_NAME,
163: DESCRIPTION = X_DESCRIPTION,
164: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
165: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 180: delete from FND_ISO_LANGUAGES_TL

176: procedure DELETE_ROW (
177: X_ISO_LANGUAGE_3 in VARCHAR2
178: ) is
179: begin
180: delete from FND_ISO_LANGUAGES_TL
181: where ISO_LANGUAGE_3 = X_ISO_LANGUAGE_3;
182:
183: if (sql%notfound) then
184: raise no_data_found;

Line 203: delete from FND_ISO_LANGUAGES_TL T

199: /* The following update statements are commented out */
200: /* as a quick workaround to fix the time-consuming table handler issue */
201: /* Eventually we'll need to turn them into a separate fix_language procedure */
202: /*
203: delete from FND_ISO_LANGUAGES_TL T
204: where not exists
205: (select NULL
206: from FND_ISO_LANGUAGES B
207: where B.ISO_LANGUAGE_3 = T.ISO_LANGUAGE_3

Line 210: update FND_ISO_LANGUAGES_TL T set (

206: from FND_ISO_LANGUAGES B
207: where B.ISO_LANGUAGE_3 = T.ISO_LANGUAGE_3
208: );
209:
210: update FND_ISO_LANGUAGES_TL T set (
211: NAME,
212: DESCRIPTION
213: ) = (select
214: B.NAME,

Line 216: from FND_ISO_LANGUAGES_TL B

212: DESCRIPTION
213: ) = (select
214: B.NAME,
215: B.DESCRIPTION
216: from FND_ISO_LANGUAGES_TL B
217: where B.ISO_LANGUAGE_3 = T.ISO_LANGUAGE_3
218: and B.LANGUAGE = T.SOURCE_LANG)
219: where (
220: T.ISO_LANGUAGE_3,

Line 225: from FND_ISO_LANGUAGES_TL SUBB, FND_ISO_LANGUAGES_TL SUBT

221: T.LANGUAGE
222: ) in (select
223: SUBT.ISO_LANGUAGE_3,
224: SUBT.LANGUAGE
225: from FND_ISO_LANGUAGES_TL SUBB, FND_ISO_LANGUAGES_TL SUBT
226: where SUBB.ISO_LANGUAGE_3 = SUBT.ISO_LANGUAGE_3
227: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
228: and (SUBB.NAME <> SUBT.NAME
229: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 233: insert into FND_ISO_LANGUAGES_TL (

229: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION
230: ));
231: */
232:
233: insert into FND_ISO_LANGUAGES_TL (
234: ISO_LANGUAGE_3,
235: NAME,
236: DESCRIPTION,
237: CREATED_BY,

Line 255: from FND_ISO_LANGUAGES_TL B, FND_LANGUAGES L

251: B.LAST_UPDATE_DATE,
252: B.LAST_UPDATE_LOGIN,
253: L.LANGUAGE_CODE,
254: B.SOURCE_LANG
255: from FND_ISO_LANGUAGES_TL B, FND_LANGUAGES L
256: where L.INSTALLED_FLAG in ('I', 'B')
257: and B.LANGUAGE = userenv('LANG')
258: and not exists
259: (select NULL

Line 260: from FND_ISO_LANGUAGES_TL T

256: where L.INSTALLED_FLAG in ('I', 'B')
257: and B.LANGUAGE = userenv('LANG')
258: and not exists
259: (select NULL
260: from FND_ISO_LANGUAGES_TL T
261: where T.ISO_LANGUAGE_3 = B.ISO_LANGUAGE_3
262: and T.LANGUAGE = L.LANGUAGE_CODE);
263: end ADD_LANGUAGE;
264:

Line 288: from fnd_iso_languages_tl

284:
285: begin
286: select last_updated_by, last_update_date
287: into db_luby, db_ludate
288: from fnd_iso_languages_tl
289: where iso_language_3 = X_ISO_LANGUAGE_3
290: and language = userenv('LANG');
291:
292: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

Line 294: update FND_ISO_LANGUAGES_TL set

290: and language = userenv('LANG');
291:
292: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
293: db_ludate, X_CUSTOM_MODE)) then
294: update FND_ISO_LANGUAGES_TL set
295: NAME = X_NAME,
296: DESCRIPTION = X_DESCRIPTION,
297: LAST_UPDATE_DATE = f_ludate,
298: LAST_UPDATED_BY = f_luby,