APPS.ICX_CAT_INTERMEDIA_INDEX_PVT dependencies on FND_LANGUAGES

Line 12: FROM fnd_languages

8: CURSOR installed_languages_csr IS
9: SELECT language_code,
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-lexer for each installed
18: ** language in FND_LANGUAGES, including the base language.
19: **/
20:
21: PROCEDURE create_index
22: IS

Line 26: l_lang fnd_languages.language_code%TYPE;

22: IS
23: l_api_name CONSTANT VARCHAR2(30):= 'create_index';
24: l_err_loc PLS_INTEGER := 0;
25:
26: l_lang fnd_languages.language_code%TYPE;
27: l_nls_lang fnd_languages.nls_language%TYPE;
28:
29: l_ctx_index_tbsp VARCHAR2(100):='USER_IDX';
30: l_ctx_data_tbsp VARCHAR2(100):='USER_DATA';

Line 27: l_nls_lang fnd_languages.nls_language%TYPE;

23: l_api_name CONSTANT VARCHAR2(30):= 'create_index';
24: l_err_loc PLS_INTEGER := 0;
25:
26: l_lang fnd_languages.language_code%TYPE;
27: l_nls_lang fnd_languages.nls_language%TYPE;
28:
29: l_ctx_index_tbsp VARCHAR2(100):='USER_IDX';
30: l_ctx_data_tbsp VARCHAR2(100):='USER_DATA';
31:

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

398: END create_index;
399:
400: /**
401: ** Proc : drop_index
402: ** Desc : Drop the index for each installed language in FND_LANGUAGES,
403: ** including the base language.
404: **/
405:
406: PROCEDURE drop_index

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

469: END drop_index;
470:
471: /**
472: ** Proc : rebuild_index
473: ** Desc : Rebuild the index for each installed language in FND_LANGUAGES,
474: ** including the base language.
475: **/
476:
477: PROCEDURE rebuild_index IS