APPS.CZ_RULE_IMPORT dependencies on CZ_LOCALIZED_TEXTS

Line 481: FROM cz_localized_texts

477:
478: IF(t_fsk_localized_text_1(i) IS NOT NULL)THEN
479:
480: SELECT intl_text_id BULK COLLECT INTO t_intl_text_id
481: FROM cz_localized_texts
482: WHERE deleted_flag = CZRI_FLAG_NOT_DELETED
483: AND model_id = t_devl_project_id(i)
484: AND orig_sys_ref = t_fsk_localized_text_1(i);
485:

Line 1477: ' FROM cz_localized_texts ' ||

1473: t_disposition table_of_varchar;
1474:
1475: resolveIntlTextId VARCHAR2(4000) :=
1476: 'SELECT intl_text_id ' ||
1477: ' FROM cz_localized_texts ' ||
1478: ' WHERE deleted_flag = ''' || CZRI_FLAG_NOT_DELETED || ''' ' ||
1479: ' AND model_id = :1 ' ||
1480: ' AND language = :2 ' ||
1481: ' AND orig_sys_ref = :3';

Line 1485: ' FROM cz_localized_texts ' ||

1481: ' AND orig_sys_ref = :3';
1482:
1483: getIntlTextId VARCHAR2(4000) :=
1484: 'SELECT intl_text_id ' ||
1485: ' FROM cz_localized_texts ' ||
1486: ' WHERE deleted_flag = ''' || CZRI_FLAG_NOT_DELETED || ''' ' ||
1487: ' AND model_id = :1 ' ||
1488: ' AND orig_sys_ref = :2 ' ||
1489: ' AND ROWNUM = 1';

Line 1733: INSERT INTO cz_localized_texts

1729: END IF;
1730: END LOOP;
1731:
1732: FORALL i IN 1..t_intl_text_id.COUNT
1733: INSERT INTO cz_localized_texts
1734: (last_update_login, locale_id, localized_str, intl_text_id, deleted_flag, security_mask,
1735: checkout_user, orig_sys_ref, language, source_lang, model_id, seeded_flag)
1736: VALUES
1737: (t_last_update_login(i), t_locale_id(i), t_localized_str(i), t_intl_text_id(i),

Line 1788: UPDATE cz_localized_texts SET

1784: END IF;
1785: END LOOP;
1786:
1787: FORALL i IN 1..t_intl_text_id.COUNT
1788: UPDATE cz_localized_texts SET
1789: last_update_login = t_last_update_login(i),
1790: locale_id = t_locale_id(i),
1791: localized_str = t_localized_str(i),
1792: deleted_flag = t_deleted_flag(i),

Line 1848: INSERT INTO cz_localized_texts

1844:
1845: IF(t_disposition(i) = CZRI_DISPOSITION_INSERT)THEN
1846:
1847: BEGIN
1848: INSERT INTO cz_localized_texts
1849: (last_update_login, locale_id, localized_str, intl_text_id, deleted_flag, security_mask,
1850: checkout_user, orig_sys_ref, language, source_lang, model_id, seeded_flag)
1851: VALUES
1852: (t_last_update_login(i), t_locale_id(i), t_localized_str(i), t_intl_text_id(i),

Line 1886: UPDATE cz_localized_texts SET

1882:
1883: IF(t_disposition(i) = CZRI_DISPOSITION_MODIFY)THEN
1884:
1885: BEGIN
1886: UPDATE cz_localized_texts SET
1887: last_update_login = t_last_update_login(i),
1888: locale_id = t_locale_id(i),
1889: localized_str = t_localized_str(i),
1890: deleted_flag = t_deleted_flag(i),