eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CZ_RULE_IMPORT dependencies on CZ_IMP_LOCALIZED_TEXTS

Line 1294: FROM cz_imp_localized_texts

1290:
1291: CURSOR c_rec IS
1292: SELECT ROWID, model_id, message, orig_sys_ref, language, source_lang,
1293: seeded_flag, deleted_flag, disposition
1294: FROM cz_imp_localized_texts
1295: WHERE run_id = p_run_id
1296: AND rec_status IS NULL
1297: AND disposition IS NULL;
1298:

Line 1325: UPDATE cz_imp_localized_texts SET

1321: PROCEDURE update_table_data(p_upper_limit IN PLS_INTEGER) IS
1322: BEGIN
1323:
1324: FORALL i IN 1..p_upper_limit
1325: UPDATE cz_imp_localized_texts SET
1326: message = t_message(i),
1327: seeded_flag = t_seeded_flag(i),
1328: deleted_flag = t_deleted_flag(i),
1329: rec_status = CZRI_RECSTATUS_CND,

Line 1460: FROM cz_imp_localized_texts

1456: v_debug NUMBER := 3000;
1457:
1458: CURSOR c_rec IS
1459: SELECT ROWID, intl_text_id, model_id, message, orig_sys_ref, language, rec_status, disposition
1460: FROM cz_imp_localized_texts
1461: WHERE run_id = p_run_id
1462: AND rec_status = CZRI_RECSTATUS_CND
1463: AND disposition = CZRI_DISPOSITION_PASSED
1464: ORDER BY model_id, orig_sys_ref, language;

Line 1491: last_orig_sys_ref cz_imp_localized_texts.orig_sys_ref%TYPE;

1487: ' AND model_id = :1 ' ||
1488: ' AND orig_sys_ref = :2 ' ||
1489: ' AND ROWNUM = 1';
1490:
1491: last_orig_sys_ref cz_imp_localized_texts.orig_sys_ref%TYPE;
1492: last_model_id cz_imp_localized_texts.model_id%TYPE;
1493: last_language cz_imp_localized_texts.language%TYPE;
1494: last_intl_text_id cz_imp_localized_texts.intl_text_id%TYPE;
1495:

Line 1492: last_model_id cz_imp_localized_texts.model_id%TYPE;

1488: ' AND orig_sys_ref = :2 ' ||
1489: ' AND ROWNUM = 1';
1490:
1491: last_orig_sys_ref cz_imp_localized_texts.orig_sys_ref%TYPE;
1492: last_model_id cz_imp_localized_texts.model_id%TYPE;
1493: last_language cz_imp_localized_texts.language%TYPE;
1494: last_intl_text_id cz_imp_localized_texts.intl_text_id%TYPE;
1495:
1496: last_id_allocated NUMBER := NULL;

Line 1493: last_language cz_imp_localized_texts.language%TYPE;

1489: ' AND ROWNUM = 1';
1490:
1491: last_orig_sys_ref cz_imp_localized_texts.orig_sys_ref%TYPE;
1492: last_model_id cz_imp_localized_texts.model_id%TYPE;
1493: last_language cz_imp_localized_texts.language%TYPE;
1494: last_intl_text_id cz_imp_localized_texts.intl_text_id%TYPE;
1495:
1496: last_id_allocated NUMBER := NULL;
1497: next_id_to_use NUMBER := 0;

Line 1494: last_intl_text_id cz_imp_localized_texts.intl_text_id%TYPE;

1490:
1491: last_orig_sys_ref cz_imp_localized_texts.orig_sys_ref%TYPE;
1492: last_model_id cz_imp_localized_texts.model_id%TYPE;
1493: last_language cz_imp_localized_texts.language%TYPE;
1494: last_intl_text_id cz_imp_localized_texts.intl_text_id%TYPE;
1495:
1496: last_id_allocated NUMBER := NULL;
1497: next_id_to_use NUMBER := 0;
1498: id_increment NUMBER := CZRI_LOCALIZED_TEXTS_INC;

Line 1504: UPDATE cz_imp_localized_texts SET

1500: PROCEDURE update_table_data(p_upper_limit IN PLS_INTEGER) IS
1501: BEGIN
1502:
1503: FORALL i IN 1..p_upper_limit
1504: UPDATE cz_imp_localized_texts SET
1505: intl_text_id = t_intl_text_id(i),
1506: message = t_message(i),
1507: rec_status = CZRI_RECSTATUS_KRS,
1508: disposition = t_disposition(i)

Line 1658: FROM cz_imp_localized_texts

1654: CURSOR c_rec IS
1655: SELECT ROWID,last_update_login, locale_id, localized_str, intl_text_id, deleted_flag, security_mask,
1656: checkout_user, orig_sys_ref, language, source_lang, model_id, seeded_flag,
1657: disposition, message
1658: FROM cz_imp_localized_texts
1659: WHERE run_id = p_run_id
1660: AND rec_status = CZRI_RECSTATUS_KRS
1661: AND disposition IN (CZRI_DISPOSITION_INSERT, CZRI_DISPOSITION_MODIFY);
1662:

Line 1686: UPDATE cz_imp_localized_texts SET

1682: --We updating rec_status to OK, not XFR, because, unlike the rules which still have
1683: --to be parsed, import of localized texts is done.
1684:
1685: FORALL i IN 1..p_upper_limit
1686: UPDATE cz_imp_localized_texts SET
1687: message = t_message(i),
1688: rec_status = CZRI_RECSTATUS_OK,
1689: disposition = t_disposition(i)
1690: WHERE ROWID = t_rowid(i);

Line 1955: FROM cz_imp_localized_texts

1951: v_debug NUMBER := 5000;
1952: BEGIN
1953:
1954: FOR c_stat IN (SELECT disposition, rec_status, COUNT(*) as records
1955: FROM cz_imp_localized_texts
1956: WHERE run_id = p_run_id
1957: AND rec_status IS NOT NULL
1958: AND disposition IS NOT NULL
1959: GROUP BY disposition, rec_status) LOOP

Line 1962: VALUES (p_run_id, 'CZ_IMP_LOCALIZED_TEXTS', c_stat.disposition, c_stat.rec_status, c_stat.records);

1958: AND disposition IS NOT NULL
1959: GROUP BY disposition, rec_status) LOOP
1960:
1961: INSERT INTO cz_xfr_run_results (run_id, imp_table, disposition, rec_status, records)
1962: VALUES (p_run_id, 'CZ_IMP_LOCALIZED_TEXTS', c_stat.disposition, c_stat.rec_status, c_stat.records);
1963: END LOOP;
1964:
1965: COMMIT;
1966: EXCEPTION

Line 2128: UPDATE cz_imp_localized_texts SET run_id = p_run_id

2124: WHERE disposition IS NULL
2125: AND rec_status IS NULL
2126: AND run_id IS NULL;
2127:
2128: UPDATE cz_imp_localized_texts SET run_id = p_run_id
2129: WHERE disposition IS NULL
2130: AND rec_status IS NULL
2131: AND run_id IS NULL;
2132: