APPS.OKC_XPRT_IMPORT_RULES_PVT dependencies on FND_LANGUAGES

Line 740: FROM FND_LANGUAGES L

736: -- WHERE orig_sys_ref = G_TEMPLATE_MODEL_OSR||p_org_id||':'||p_intent||':'||p_tmpl_id
737:
738: CURSOR csr_installed_languages IS
739: SELECT L.LANGUAGE_CODE
740: FROM FND_LANGUAGES L
741: WHERE L.INSTALLED_FLAG IN ('I', 'B');
742:
743: l_api_name CONSTANT VARCHAR2(30) := 'build_and_insert_rule';
744: l_rule_id okc_xprt_rule_hdrs_all.rule_id%TYPE;

Line 753: l_language FND_LANGUAGES.LANGUAGE_CODE%TYPE;

749: l_rule_type okc_xprt_rule_hdrs_all.rule_type%TYPE;
750: l_deleted_flag cz_imp_rules.deleted_flag%TYPE;
751:
752: l_rule_text cz_imp_rules.rule_text%TYPE;
753: l_language FND_LANGUAGES.LANGUAGE_CODE%TYPE;
754:
755:
756: l_template_name OKC_TERMS_TEMPLATES_ALL.template_name%TYPE;
757: l_template_id OKC_TERMS_TEMPLATES_ALL.template_id%TYPE;

Line 1964: FROM FND_LANGUAGES L

1960: AND deleted_flag = 0;
1961:
1962: CURSOR csr_installed_languages IS
1963: SELECT L.LANGUAGE_CODE
1964: FROM FND_LANGUAGES L
1965: WHERE L.INSTALLED_FLAG IN ('I', 'B');
1966:
1967: l_api_name CONSTANT VARCHAR2(30) := 'attach_extension_rule';
1968: l_rule_id okc_xprt_rule_hdrs_all.rule_id%TYPE;

Line 1979: l_language FND_LANGUAGES.LANGUAGE_CODE%TYPE;

1975: l_rule_text cz_imp_rules.rule_text%TYPE;
1976: l_model_id cz_imp_localized_texts.MODEL_ID%TYPE;
1977: l_model_osr cz_imp_localized_texts.fsk_devlproject_1_1%TYPE;
1978:
1979: l_language FND_LANGUAGES.LANGUAGE_CODE%TYPE;
1980:
1981: l_cz_imp_rules cz_imp_rules%ROWTYPE;
1982:
1983: BEGIN

Line 2403: FROM FND_LANGUAGES L

2399: AND deleted_flag = 0;
2400:
2401: CURSOR csr_installed_languages IS
2402: SELECT L.LANGUAGE_CODE
2403: FROM FND_LANGUAGES L
2404: WHERE L.INSTALLED_FLAG IN ('I', 'B');
2405:
2406: l_api_name CONSTANT VARCHAR2(30) := 'attach_extension_rule_tmpl';
2407: l_rule_id okc_xprt_rule_hdrs_all.rule_id%TYPE;

Line 2418: l_language FND_LANGUAGES.LANGUAGE_CODE%TYPE;

2414: l_rule_text cz_imp_rules.rule_text%TYPE;
2415: l_model_id cz_imp_localized_texts.MODEL_ID%TYPE;
2416: l_model_osr cz_imp_localized_texts.fsk_devlproject_1_1%TYPE;
2417:
2418: l_language FND_LANGUAGES.LANGUAGE_CODE%TYPE;
2419:
2420: l_cz_imp_rules cz_imp_rules%ROWTYPE;
2421:
2422: BEGIN