APPS.OKC_XPRT_IMPORT_RULES_PVT dependencies on CZ_IMP_LOCALIZED_TEXTS

Line 877: -- Insert Rule Name into cz_imp_localized_texts

873: END IF;
874:
875: END IF; -- rule text generation
876:
877: -- Insert Rule Name into cz_imp_localized_texts
878:
879: OPEN csr_installed_languages;
880: LOOP
881: FETCH csr_installed_languages INTO l_language;

Line 886: INSERT INTO CZ_IMP_LOCALIZED_TEXTS

882: EXIT WHEN csr_installed_languages%NOTFOUND;
883:
884: -- Insert into cz_imp_localized_text
885:
886: INSERT INTO CZ_IMP_LOCALIZED_TEXTS
887: (
888: LAST_UPDATE_LOGIN,
889: LOCALE_ID,
890: LOCALIZED_STR,

Line 1962: l_model_id cz_imp_localized_texts.MODEL_ID%TYPE;

1958: l_seq_nbr cz_imp_rules.seq_nbr%TYPE := 0;
1959: l_rule_name cz_imp_rules.NAME%TYPE;
1960: l_rule_description cz_imp_rules.desc_text%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:

Line 1963: l_model_osr cz_imp_localized_texts.fsk_devlproject_1_1%TYPE;

1959: l_rule_name cz_imp_rules.NAME%TYPE;
1960: l_rule_description cz_imp_rules.desc_text%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;

Line 2027: -- Insert Rule Name into cz_imp_localized_texts

2023: fnd_file.put_line(FND_FILE.LOG,' ');
2024: fnd_file.put_line(FND_FILE.LOG,'Creating Extension Rule for : '||l_model_osr);
2025: fnd_file.put_line(FND_FILE.LOG,' ');
2026:
2027: -- Insert Rule Name into cz_imp_localized_texts
2028:
2029: OPEN csr_installed_languages;
2030: LOOP
2031: FETCH csr_installed_languages INTO l_language;

Line 2035: INSERT INTO CZ_IMP_LOCALIZED_TEXTS

2031: FETCH csr_installed_languages INTO l_language;
2032: EXIT WHEN csr_installed_languages%NOTFOUND;
2033:
2034: -- Insert into cz_imp_localized_text
2035: INSERT INTO CZ_IMP_LOCALIZED_TEXTS
2036: (
2037: LAST_UPDATE_LOGIN,
2038: LOCALE_ID,
2039: LOCALIZED_STR,

Line 2401: l_model_id cz_imp_localized_texts.MODEL_ID%TYPE;

2397: l_seq_nbr cz_imp_rules.seq_nbr%TYPE := 0;
2398: l_rule_name cz_imp_rules.NAME%TYPE;
2399: l_rule_description cz_imp_rules.desc_text%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:

Line 2402: l_model_osr cz_imp_localized_texts.fsk_devlproject_1_1%TYPE;

2398: l_rule_name cz_imp_rules.NAME%TYPE;
2399: l_rule_description cz_imp_rules.desc_text%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;

Line 2466: -- Insert Rule Name into cz_imp_localized_texts

2462: fnd_file.put_line(FND_FILE.LOG,' ');
2463: fnd_file.put_line(FND_FILE.LOG,'Creating Extension Rule for : '||l_model_osr);
2464: fnd_file.put_line(FND_FILE.LOG,' ');
2465:
2466: -- Insert Rule Name into cz_imp_localized_texts
2467:
2468: OPEN csr_installed_languages;
2469: LOOP
2470: FETCH csr_installed_languages INTO l_language;

Line 2474: INSERT INTO CZ_IMP_LOCALIZED_TEXTS

2470: FETCH csr_installed_languages INTO l_language;
2471: EXIT WHEN csr_installed_languages%NOTFOUND;
2472:
2473: -- Insert into cz_imp_localized_text
2474: INSERT INTO CZ_IMP_LOCALIZED_TEXTS
2475: (
2476: LAST_UPDATE_LOGIN,
2477: LOCALE_ID,
2478: LOCALIZED_STR,