APPS.CZ_RULE_IMPORT dependencies on CZ_LOCALIZED_TEXTS

Line 686: FROM cz_localized_texts

682:
683: IF(t_fsk_localized_text_2(i) IS NOT NULL)THEN
684:
685: SELECT intl_text_id BULK COLLECT INTO l_intl_text_id
686: FROM cz_localized_texts
687: WHERE deleted_flag = CZRI_FLAG_NOT_DELETED
688: AND model_id = t_devl_project_id(i)
689: AND orig_sys_ref = t_fsk_localized_text_2(i);
690:

Line 720: FROM cz_localized_texts

716:
717: IF(t_fsk_localized_text_1(i) IS NOT NULL)THEN
718:
719: SELECT intl_text_id BULK COLLECT INTO t_intl_text_id
720: FROM cz_localized_texts
721: WHERE deleted_flag = CZRI_FLAG_NOT_DELETED
722: AND model_id = t_devl_project_id(i)
723: AND orig_sys_ref = t_fsk_localized_text_1(i);
724:

Line 1845: ' FROM cz_localized_texts ' ||

1841: n_local_string table_of_varchar;
1842:
1843: resolveIntlTextId VARCHAR2(4000) :=
1844: 'SELECT intl_text_id, model_id, orig_sys_ref, language,source_lang,localized_str ' ||
1845: ' FROM cz_localized_texts ' ||
1846: ' WHERE deleted_flag = ''' || CZRI_FLAG_NOT_DELETED || ''' ' ||
1847: ' AND model_id = :1 ' ||
1848: ' AND language = :2 ' ||
1849: ' AND orig_sys_ref = :3';

Line 1853: ' FROM cz_localized_texts ' ||

1849: ' AND orig_sys_ref = :3';
1850:
1851: getIntlTextId VARCHAR2(4000) :=
1852: 'SELECT intl_text_id ' ||
1853: ' FROM cz_localized_texts ' ||
1854: ' WHERE deleted_flag = ''' || CZRI_FLAG_NOT_DELETED || ''' ' ||
1855: ' AND model_id = :1 ' ||
1856: ' AND orig_sys_ref = :2 ' ||
1857: ' AND ROWNUM = 1';

Line 2132: INSERT INTO cz_localized_texts

2128: END IF;
2129: END LOOP;
2130:
2131: FORALL i IN 1..t_intl_text_id.COUNT
2132: INSERT INTO cz_localized_texts
2133: (last_update_login, locale_id, localized_str, intl_text_id, deleted_flag, security_mask,
2134: checkout_user, orig_sys_ref, language, source_lang, model_id, seeded_flag)
2135: VALUES
2136: (t_last_update_login(i), t_locale_id(i), t_localized_str(i), t_intl_text_id(i),

Line 2187: UPDATE cz_localized_texts SET

2183: END IF;
2184: END LOOP;
2185:
2186: FORALL i IN 1..t_intl_text_id.COUNT
2187: UPDATE cz_localized_texts SET
2188: last_update_login = t_last_update_login(i),
2189: locale_id = t_locale_id(i),
2190: localized_str = t_localized_str(i),
2191: deleted_flag = t_deleted_flag(i),

Line 2248: INSERT INTO cz_localized_texts

2244:
2245: IF(t_disposition(i) = CZRI_DISPOSITION_INSERT)THEN
2246:
2247: BEGIN
2248: INSERT INTO cz_localized_texts
2249: (last_update_login, locale_id, localized_str, intl_text_id, deleted_flag, security_mask,
2250: checkout_user, orig_sys_ref, language, source_lang, model_id, seeded_flag)
2251: VALUES
2252: (t_last_update_login(i), t_locale_id(i), t_localized_str(i), t_intl_text_id(i),

Line 2286: UPDATE cz_localized_texts SET

2282:
2283: IF(t_disposition(i) = CZRI_DISPOSITION_MODIFY)THEN
2284:
2285: BEGIN
2286: UPDATE cz_localized_texts SET
2287: last_update_login = t_last_update_login(i),
2288: locale_id = t_locale_id(i),
2289: localized_str = t_localized_str(i),
2290: deleted_flag = t_deleted_flag(i),

Line 2822: UPDATE cz_localized_texts

2818: END IF;
2819: END LOOP;
2820:
2821: FORALL i IN 1..t_rowid.COUNT
2822: UPDATE cz_localized_texts
2823: SET localized_str = t_text_str(i)
2824: WHERE intl_text_id = (SELECT reason_id from cz_rules where rule_id = t_rules_id(i));
2825: RETURN TRUE;
2826:

Line 2850: INSERT INTO cz_localized_texts_vl

2846: IF(t_disposition(i) = CZRI_DISPOSITION_INSERT)THEN
2847:
2848: BEGIN
2849: SAVEPOINT insert_msg_record;
2850: INSERT INTO cz_localized_texts_vl
2851: (last_update_login, text_str, intl_text_id, deleted_flag, model_id)
2852: VALUES
2853: (t_last_update_login(i), t_text_str(i), cz_intl_texts_s.NEXTVAL, 0, t_model_id(i)) ;
2854:

Line 2875: UPDATE cz_localized_texts

2871: IF (t_disposition(i) = CZRI_DISPOSITION_MODIFY)THEN
2872: BEGIN
2873: SAVEPOINT update_msg_record;
2874:
2875: UPDATE cz_localized_texts
2876: SET localized_str = t_text_str(i)
2877: WHERE intl_text_id = (SELECT reason_id from cz_rules where rule_id = t_rules_id(i));
2878:
2879: EXCEPTION