APPS.ICX_POR_INTERMEDIA_INDEX dependencies on FND_LANGUAGES

Line 12: from fnd_languages

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

Line 18: ** language in FND_LANGUAGES, including the base language.

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:

Line 26: xLang fnd_languages.language_code%TYPE;

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';

Line 27: xNLSLang fnd_languages.nls_language%TYPE;

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';

Line 381: ** Desc : Drop the index for each installed language in FND_LANGUAGES,

377: END create_index;
378:
379: /**
380: ** Proc : drop_index
381: ** Desc : Drop the index for each installed language in FND_LANGUAGES,
382: ** including the base language.
383: **/
384:
385: PROCEDURE drop_index IS

Line 448: ** Desc : Rebuild the index for each installed language in FND_LANGUAGES,

444: END drop_index;
445:
446: /**
447: ** Proc : rebuild_index
448: ** Desc : Rebuild the index for each installed language in FND_LANGUAGES,
449: ** including the base language.
450: **/
451:
452: PROCEDURE rebuild_index IS