[Home] [Help]
255: l_language FND_LANGUAGES.LANGUAGE_CODE%TYPE;
256:
257: l_cz_imp_ps_nodes_rec CZ_IMP_PS_NODES%ROWTYPE;
258: l_api_name CONSTANT VARCHAR2(30) := 'create_variable_component';
259: l_model_component_name CZ_IMP_LOCALIZED_TEXTS.LOCALIZED_STR%TYPE;
260:
261: BEGIN
262:
263: -- start debug log
282: EXIT WHEN csr_installed_languages%NOTFOUND;
283:
284: -- Insert into cz_imp_localized_text
285:
286: INSERT INTO CZ_IMP_LOCALIZED_TEXTS
287: (
288: LAST_UPDATE_LOGIN,
289: LOCALE_ID,
290: LOCALIZED_STR,
785:
786: x_return_status := G_RET_STS_SUCCESS;
787:
788: -- Get the variables to be imported as Features Under the Variable Model
789: -- insert ALL installed language records into cz_imp_localized_texts
790: OPEN csr_variables(p_language => NULL);
791: FETCH csr_variables BULK COLLECT INTO variableCode_tbl,
792: variableName_tbl,
793: variableDatatype_tbl,
810:
811: FORALL i IN variableCode_tbl.FIRST..variableCode_tbl.LAST
812: -- Insert into cz_imp_localized_text
813:
814: INSERT INTO CZ_IMP_LOCALIZED_TEXTS
815: (
816: LAST_UPDATE_LOGIN,
817: LOCALE_ID,
818: LOCALIZED_STR,
1164: l_language FND_LANGUAGES.LANGUAGE_CODE%TYPE;
1165:
1166: TYPE VariableCodeList IS TABLE OF okc_xprt_rule_conditions.object_code%TYPE INDEX BY BINARY_INTEGER;
1167: TYPE VariableOptionList IS TABLE OF okc_xprt_rule_conditions.object_value_code%TYPE INDEX BY BINARY_INTEGER;
1168: TYPE VariableOptionDesc IS TABLE OF cz_imp_localized_texts.localized_str%TYPE INDEX BY BINARY_INTEGER;
1169: TYPE SeqNoList IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
1170:
1171: variableCode_tbl VariableCodeList;
1172: variableOption_tbl VariableOptionList;
1208: FORALL i IN variableOptionDesc_tbl.FIRST..variableOptionDesc_tbl.LAST
1209:
1210: -- Insert into cz_imp_localized_text
1211:
1212: INSERT INTO CZ_IMP_LOCALIZED_TEXTS
1213: (
1214: LAST_UPDATE_LOGIN,
1215: LOCALE_ID,
1216: LOCALIZED_STR,