APPS.OKC_XPRT_IMPORT_RULES_PVT dependencies on CZ_IMP_LOCALIZED_TEXTS

Line 891: -- Insert Rule Name into cz_imp_localized_texts

887: END IF;
888:
889: END IF; -- rule text generation
890:
891: -- Insert Rule Name into cz_imp_localized_texts
892:
893: OPEN csr_installed_languages;
894: LOOP
895: FETCH csr_installed_languages INTO l_language;

Line 900: INSERT INTO CZ_IMP_LOCALIZED_TEXTS

896: EXIT WHEN csr_installed_languages%NOTFOUND;
897:
898: -- Insert into cz_imp_localized_text
899:
900: INSERT INTO CZ_IMP_LOCALIZED_TEXTS
901: (
902: LAST_UPDATE_LOGIN,
903: LOCALE_ID,
904: LOCALIZED_STR,

Line 1976: l_model_id cz_imp_localized_texts.MODEL_ID%TYPE;

1972: l_seq_nbr cz_imp_rules.seq_nbr%TYPE := 0;
1973: l_rule_name cz_imp_rules.NAME%TYPE;
1974: l_rule_description cz_imp_rules.desc_text%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:

Line 1977: l_model_osr cz_imp_localized_texts.fsk_devlproject_1_1%TYPE;

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

Line 2041: -- Insert Rule Name into cz_imp_localized_texts

2037: fnd_file.put_line(FND_FILE.LOG,' ');
2038: fnd_file.put_line(FND_FILE.LOG,'Creating Extension Rule for : '||l_model_osr);
2039: fnd_file.put_line(FND_FILE.LOG,' ');
2040:
2041: -- Insert Rule Name into cz_imp_localized_texts
2042:
2043: OPEN csr_installed_languages;
2044: LOOP
2045: FETCH csr_installed_languages INTO l_language;

Line 2049: INSERT INTO CZ_IMP_LOCALIZED_TEXTS

2045: FETCH csr_installed_languages INTO l_language;
2046: EXIT WHEN csr_installed_languages%NOTFOUND;
2047:
2048: -- Insert into cz_imp_localized_text
2049: INSERT INTO CZ_IMP_LOCALIZED_TEXTS
2050: (
2051: LAST_UPDATE_LOGIN,
2052: LOCALE_ID,
2053: LOCALIZED_STR,

Line 2415: l_model_id cz_imp_localized_texts.MODEL_ID%TYPE;

2411: l_seq_nbr cz_imp_rules.seq_nbr%TYPE := 0;
2412: l_rule_name cz_imp_rules.NAME%TYPE;
2413: l_rule_description cz_imp_rules.desc_text%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:

Line 2416: l_model_osr cz_imp_localized_texts.fsk_devlproject_1_1%TYPE;

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

Line 2480: -- Insert Rule Name into cz_imp_localized_texts

2476: fnd_file.put_line(FND_FILE.LOG,' ');
2477: fnd_file.put_line(FND_FILE.LOG,'Creating Extension Rule for : '||l_model_osr);
2478: fnd_file.put_line(FND_FILE.LOG,' ');
2479:
2480: -- Insert Rule Name into cz_imp_localized_texts
2481:
2482: OPEN csr_installed_languages;
2483: LOOP
2484: FETCH csr_installed_languages INTO l_language;

Line 2488: INSERT INTO CZ_IMP_LOCALIZED_TEXTS

2484: FETCH csr_installed_languages INTO l_language;
2485: EXIT WHEN csr_installed_languages%NOTFOUND;
2486:
2487: -- Insert into cz_imp_localized_text
2488: INSERT INTO CZ_IMP_LOCALIZED_TEXTS
2489: (
2490: LAST_UPDATE_LOGIN,
2491: LOCALE_ID,
2492: LOCALIZED_STR,