APPS.OKC_XPRT_IMPORT_CLAUSES_PVT dependencies on FND_LANGUAGES

Line 257: FROM FND_LANGUAGES L

253: ) IS
254:
255: CURSOR csr_installed_languages IS
256: SELECT L.LANGUAGE_CODE
257: FROM FND_LANGUAGES L
258: WHERE L.INSTALLED_FLAG IN ('I', 'B');
259:
260: l_language FND_LANGUAGES.LANGUAGE_CODE%TYPE;
261:

Line 260: l_language FND_LANGUAGES.LANGUAGE_CODE%TYPE;

256: SELECT L.LANGUAGE_CODE
257: FROM FND_LANGUAGES L
258: WHERE L.INSTALLED_FLAG IN ('I', 'B');
259:
260: l_language FND_LANGUAGES.LANGUAGE_CODE%TYPE;
261:
262: l_cz_imp_ps_nodes_rec CZ_IMP_PS_NODES%ROWTYPE;
263: l_api_name CONSTANT VARCHAR2(30) := 'create_clause_component';
264: l_model_component_name CZ_IMP_LOCALIZED_TEXTS.LOCALIZED_STR%TYPE;

Line 686: FROM FND_LANGUAGES L

682: ) IS
683:
684: CURSOR csr_installed_languages IS
685: SELECT L.LANGUAGE_CODE
686: FROM FND_LANGUAGES L
687: WHERE L.INSTALLED_FLAG IN ('I', 'B');
688:
689: l_language FND_LANGUAGES.LANGUAGE_CODE%TYPE;
690:

Line 689: l_language FND_LANGUAGES.LANGUAGE_CODE%TYPE;

685: SELECT L.LANGUAGE_CODE
686: FROM FND_LANGUAGES L
687: WHERE L.INSTALLED_FLAG IN ('I', 'B');
688:
689: l_language FND_LANGUAGES.LANGUAGE_CODE%TYPE;
690:
691: l_cz_imp_ps_nodes_rec CZ_IMP_PS_NODES%ROWTYPE;
692: l_api_name CONSTANT VARCHAR2(30) := 'create_clause_feature';
693: l_model_feature_name CZ_IMP_LOCALIZED_TEXTS.LOCALIZED_STR%TYPE;

Line 1156: FROM FND_LANGUAGES L

1152: -- and create records in cz_imp_localized_texts table
1153:
1154: CURSOR csr_installed_languages IS
1155: SELECT L.LANGUAGE_CODE
1156: FROM FND_LANGUAGES L
1157: WHERE L.INSTALLED_FLAG IN ('I', 'B');
1158:
1159:
1160: l_api_name CONSTANT VARCHAR2(30) := 'create_clause_options';

Line 1170: l_language FND_LANGUAGES.LANGUAGE_CODE%TYPE;

1166:
1167: ClauseIdList_tbl ClauseIdList;
1168: ClauseTitleList_tbl ClauseTitleList;
1169: SeqNoList_tbl SeqNoList;
1170: l_language FND_LANGUAGES.LANGUAGE_CODE%TYPE;
1171:
1172:
1173:
1174: BEGIN

Line 1507: FROM FND_LANGUAGES L

1503: ) IS
1504:
1505: CURSOR csr_installed_languages IS
1506: SELECT L.LANGUAGE_CODE
1507: FROM FND_LANGUAGES L
1508: WHERE L.INSTALLED_FLAG IN ('I', 'B');
1509:
1510: l_language FND_LANGUAGES.LANGUAGE_CODE%TYPE;
1511:

Line 1510: l_language FND_LANGUAGES.LANGUAGE_CODE%TYPE;

1506: SELECT L.LANGUAGE_CODE
1507: FROM FND_LANGUAGES L
1508: WHERE L.INSTALLED_FLAG IN ('I', 'B');
1509:
1510: l_language FND_LANGUAGES.LANGUAGE_CODE%TYPE;
1511:
1512: l_cz_imp_ps_nodes_rec CZ_IMP_PS_NODES%ROWTYPE;
1513: l_api_name CONSTANT VARCHAR2(30) := 'create_variable_model_ref';
1514: l_variable_model_name CZ_IMP_LOCALIZED_TEXTS.LOCALIZED_STR%TYPE;