8: select language_code,
9: -- Bug 2249721, Multi-Lexer, ZXZHANG, Mar-04-02
10: nls_language,
11: installed_flag
12: from fnd_languages
13: where installed_flag in ('B', 'I');
14:
15: /**
16: ** Proc : create_index
14:
15: /**
16: ** Proc : create_index
17: ** Desc : Create interMedia index with multi-lex for each installed
18: ** language in FND_LANGUAGES, including the base language.
19: **/
20:
21: PROCEDURE create_index IS
22:
22:
23: xErrLoc INTEGER := 0;
24:
25: -- Bug 2249721, Multi-Lexer, ZXZHANG, Mar-04-02
26: xLang fnd_languages.language_code%TYPE;
27: xNLSLang fnd_languages.nls_language%TYPE;
28:
29: -- Bug 1802907, zxzhang, May-24-01
30: ctx_index_tbsp VARCHAR2(100):='USER_IDX';
23: xErrLoc INTEGER := 0;
24:
25: -- Bug 2249721, Multi-Lexer, ZXZHANG, Mar-04-02
26: xLang fnd_languages.language_code%TYPE;
27: xNLSLang fnd_languages.nls_language%TYPE;
28:
29: -- Bug 1802907, zxzhang, May-24-01
30: ctx_index_tbsp VARCHAR2(100):='USER_IDX';
31: ctx_data_tbsp VARCHAR2(100):='USER_DATA';
366: END create_index;
367:
368: /**
369: ** Proc : drop_index
370: ** Desc : Drop the index for each installed language in FND_LANGUAGES,
371: ** including the base language.
372: **/
373:
374: PROCEDURE drop_index IS
433: END drop_index;
434:
435: /**
436: ** Proc : rebuild_index
437: ** Desc : Rebuild the index for each installed language in FND_LANGUAGES,
438: ** including the base language.
439: **/
440:
441: PROCEDURE rebuild_index IS