APPS.FND_NATURAL_LANGUAGES_PKG dependencies on FND_NATURAL_LANGUAGES_TL

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 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 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 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 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,