APPS.OKC_XPRT_IMPORT_TEMPLATE_PVT dependencies on FND_LANGUAGES

Line 286: FROM FND_LANGUAGES L

282:
283:
284: CURSOR csr_installed_languages IS
285: SELECT L.LANGUAGE_CODE
286: FROM FND_LANGUAGES L
287: WHERE L.INSTALLED_FLAG IN ('I', 'B');
288:
289: l_language FND_LANGUAGES.LANGUAGE_CODE%TYPE;
290:

Line 289: l_language FND_LANGUAGES.LANGUAGE_CODE%TYPE;

285: SELECT L.LANGUAGE_CODE
286: FROM FND_LANGUAGES L
287: WHERE L.INSTALLED_FLAG IN ('I', 'B');
288:
289: l_language FND_LANGUAGES.LANGUAGE_CODE%TYPE;
290:
291: l_cz_imp_ps_nodes_rec CZ_IMP_PS_NODES%ROWTYPE;
292: l_api_name CONSTANT VARCHAR2(30) := 'create_template_component';
293:

Line 1362: FROM FND_LANGUAGES L

1358: -- and create records in cz_imp_localized_texts table
1359:
1360: CURSOR csr_installed_languages IS
1361: SELECT L.LANGUAGE_CODE
1362: FROM FND_LANGUAGES L
1363: WHERE L.INSTALLED_FLAG IN ('I', 'B');
1364:
1365:
1366: l_api_name CONSTANT VARCHAR2(30) := 'create_template_options';

Line 1391: l_language FND_LANGUAGES.LANGUAGE_CODE%TYPE;

1387: l_sequence_sql_stmt LONG;
1388: l_error_message VARCHAR2(4000);
1389: l_valueset_type fnd_flex_value_sets.validation_type%TYPE;
1390: l_question_name okc_xprt_questions_tl.question_name%TYPE;
1391: l_language FND_LANGUAGES.LANGUAGE_CODE%TYPE;
1392:
1393: TYPE cur_typ IS REF CURSOR;
1394: c_cursor cur_typ;
1395:

Line 1971: FROM FND_LANGUAGES L

1967:
1968:
1969: CURSOR csr_installed_languages IS
1970: SELECT L.LANGUAGE_CODE
1971: FROM FND_LANGUAGES L
1972: WHERE L.INSTALLED_FLAG IN ('I', 'B');
1973:
1974: l_language FND_LANGUAGES.LANGUAGE_CODE%TYPE;
1975:

Line 1974: l_language FND_LANGUAGES.LANGUAGE_CODE%TYPE;

1970: SELECT L.LANGUAGE_CODE
1971: FROM FND_LANGUAGES L
1972: WHERE L.INSTALLED_FLAG IN ('I', 'B');
1973:
1974: l_language FND_LANGUAGES.LANGUAGE_CODE%TYPE;
1975:
1976: l_cz_imp_ps_nodes_rec CZ_IMP_PS_NODES%ROWTYPE;
1977: l_api_name CONSTANT VARCHAR2(30) := 'create_clause_model_ref';
1978: l_clause_model_name VARCHAR2(255);