463:
464: CURSOR c_get_installed_languages
465: IS
466: SELECT lng.language_code
467: FROM fnd_languages lng
468: WHERE lng.installed_flag IN ('I', 'B');
469: InstLang c_get_installed_languages%ROWTYPE;
470:
471: BEGIN
536: l_last_update_login := TypeDesc.last_update_login;
537: CLOSE c_get_descs;
538: END IF;
539:
540: /* Read fnd_languages for the installed and base languages.
541: ** For those that are found, read the types tl table.
542: ** If there isn't a record in the table for that language then
543: ** insert it and go on to the next.
544: */
1010: /* Cursors */
1011: CURSOR c_get_language
1012: IS
1013: SELECT lng.language_code
1014: FROM fnd_languages lng
1015: WHERE lng.language_code = l_language_code;
1016: LangRecord c_get_language%ROWTYPE;
1017:
1018: BEGIN
1351: B.LAST_UPDATE_DATE,
1352: B.LAST_UPDATE_LOGIN,
1353: L.LANGUAGE_CODE,
1354: B.SOURCE_LANG
1355: FROM GR_ITEM_FIELD_NAME_MASKS_TL B, FND_LANGUAGES L
1356: WHERE L.INSTALLED_FLAG in ('I', 'B')
1357: AND B.LANGUAGE = userenv('LANG')
1358: AND not exists
1359: (SELECT NULL