APPS.OKC_XPRT_IMPORT_RULES_PVT dependencies on FND_LANGUAGES

Line 726: FROM FND_LANGUAGES L

722: -- WHERE orig_sys_ref = G_TEMPLATE_MODEL_OSR||p_org_id||':'||p_intent||':'||p_tmpl_id
723:
724: CURSOR csr_installed_languages IS
725: SELECT L.LANGUAGE_CODE
726: FROM FND_LANGUAGES L
727: WHERE L.INSTALLED_FLAG IN ('I', 'B');
728:
729: l_api_name CONSTANT VARCHAR2(30) := 'build_and_insert_rule';
730: l_rule_id okc_xprt_rule_hdrs_all.rule_id%TYPE;

Line 739: l_language FND_LANGUAGES.LANGUAGE_CODE%TYPE;

735: l_rule_type okc_xprt_rule_hdrs_all.rule_type%TYPE;
736: l_deleted_flag cz_imp_rules.deleted_flag%TYPE;
737:
738: l_rule_text cz_imp_rules.rule_text%TYPE;
739: l_language FND_LANGUAGES.LANGUAGE_CODE%TYPE;
740:
741:
742: l_template_name OKC_TERMS_TEMPLATES_ALL.template_name%TYPE;
743: l_template_id OKC_TERMS_TEMPLATES_ALL.template_id%TYPE;

Line 1950: FROM FND_LANGUAGES L

1946: AND deleted_flag = 0;
1947:
1948: CURSOR csr_installed_languages IS
1949: SELECT L.LANGUAGE_CODE
1950: FROM FND_LANGUAGES L
1951: WHERE L.INSTALLED_FLAG IN ('I', 'B');
1952:
1953: l_api_name CONSTANT VARCHAR2(30) := 'attach_extension_rule';
1954: l_rule_id okc_xprt_rule_hdrs_all.rule_id%TYPE;

Line 1965: l_language FND_LANGUAGES.LANGUAGE_CODE%TYPE;

1961: l_rule_text cz_imp_rules.rule_text%TYPE;
1962: l_model_id cz_imp_localized_texts.MODEL_ID%TYPE;
1963: l_model_osr cz_imp_localized_texts.fsk_devlproject_1_1%TYPE;
1964:
1965: l_language FND_LANGUAGES.LANGUAGE_CODE%TYPE;
1966:
1967: l_cz_imp_rules cz_imp_rules%ROWTYPE;
1968:
1969: BEGIN

Line 2389: FROM FND_LANGUAGES L

2385: AND deleted_flag = 0;
2386:
2387: CURSOR csr_installed_languages IS
2388: SELECT L.LANGUAGE_CODE
2389: FROM FND_LANGUAGES L
2390: WHERE L.INSTALLED_FLAG IN ('I', 'B');
2391:
2392: l_api_name CONSTANT VARCHAR2(30) := 'attach_extension_rule_tmpl';
2393: l_rule_id okc_xprt_rule_hdrs_all.rule_id%TYPE;

Line 2404: l_language FND_LANGUAGES.LANGUAGE_CODE%TYPE;

2400: l_rule_text cz_imp_rules.rule_text%TYPE;
2401: l_model_id cz_imp_localized_texts.MODEL_ID%TYPE;
2402: l_model_osr cz_imp_localized_texts.fsk_devlproject_1_1%TYPE;
2403:
2404: l_language FND_LANGUAGES.LANGUAGE_CODE%TYPE;
2405:
2406: l_cz_imp_rules cz_imp_rules%ROWTYPE;
2407:
2408: BEGIN