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 411: ** Desc : Drop the index for each installed language in FND_LANGUAGES,

407: END create_index;
408:
409: /**
410: ** Proc : drop_index
411: ** Desc : Drop the index for each installed language in FND_LANGUAGES,
412: ** including the base language.
413: **/
414:
415: PROCEDURE drop_index

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

478: END drop_index;
479:
480: /**
481: ** Proc : rebuild_index
482: ** Desc : Rebuild the index for each installed language in FND_LANGUAGES,
483: ** including the base language.
484: **/
485:
486: PROCEDURE rebuild_index IS