APPS.OKC_XPRT_IMPORT_VARIABLES_PVT dependencies on FND_LANGUAGES

Line 252: FROM FND_LANGUAGES L

248: ) IS
249:
250: CURSOR csr_installed_languages IS
251: SELECT L.LANGUAGE_CODE
252: FROM FND_LANGUAGES L
253: WHERE L.INSTALLED_FLAG IN ('I', 'B');
254:
255: l_language FND_LANGUAGES.LANGUAGE_CODE%TYPE;
256:

Line 255: l_language FND_LANGUAGES.LANGUAGE_CODE%TYPE;

251: SELECT L.LANGUAGE_CODE
252: FROM FND_LANGUAGES L
253: WHERE L.INSTALLED_FLAG IN ('I', 'B');
254:
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;

Line 772: FROM FND_LANGUAGES L

768: SeqNoList_tbl SeqNoList;
769:
770: CURSOR csr_installed_languages IS
771: SELECT L.LANGUAGE_CODE
772: FROM FND_LANGUAGES L
773: WHERE L.INSTALLED_FLAG IN ('I', 'B');
774:
775: l_language FND_LANGUAGES.LANGUAGE_CODE%TYPE;
776:

Line 775: l_language FND_LANGUAGES.LANGUAGE_CODE%TYPE;

771: SELECT L.LANGUAGE_CODE
772: FROM FND_LANGUAGES L
773: WHERE L.INSTALLED_FLAG IN ('I', 'B');
774:
775: l_language FND_LANGUAGES.LANGUAGE_CODE%TYPE;
776:
777: BEGIN
778:
779: -- start debug log

Line 1143: FROM FND_LANGUAGES L

1139:
1140:
1141: CURSOR csr_installed_languages IS
1142: SELECT L.LANGUAGE_CODE
1143: FROM FND_LANGUAGES L
1144: WHERE L.INSTALLED_FLAG IN ('I', 'B');
1145:
1146:
1147: CURSOR csr_variable_options IS

Line 1164: l_language FND_LANGUAGES.LANGUAGE_CODE%TYPE;

1160: AND r.intent = p_intent
1161: AND r.status_code NOT IN ('DRAFT','INACTIVE'); -- Added inactive status for bug 4758803
1162:
1163: l_api_name CONSTANT VARCHAR2(30) := 'create_variable_options';
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;