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