DBA Data[Home] [Help]

APPS.CZ_IMP_IM_XFR dependencies on CZ_LOCALIZED_TEXTS

Line 868: INSERT INTO cz_localized_texts (intl_text_id, localized_str,

864: SELECT CZ_INTL_TEXTS_S.NEXTVAL INTO l_def_num_value FROM dual;
865: FOR i IN(SELECT language_code FROM FND_LANGUAGES
866: WHERE installed_flag in( 'B', 'I'))
867: LOOP
868: INSERT INTO cz_localized_texts (intl_text_id, localized_str,
869: language, source_lang, deleted_flag,
870: creation_date, last_update_date, created_by,
871: last_updated_by,orig_sys_ref, model_id)
872: VALUES

Line 1066: INSERT INTO cz_localized_texts (intl_text_id, localized_str,

1062: SELECT CZ_INTL_TEXTS_S.NEXTVAL INTO l_def_num_value FROM dual;
1063: FOR i IN(SELECT language_code FROM FND_LANGUAGES
1064: WHERE installed_flag in( 'B', 'I'))
1065: LOOP
1066: INSERT INTO cz_localized_texts (intl_text_id, localized_str,
1067: language, source_lang, deleted_flag,
1068: creation_date, last_update_date, created_by,
1069: last_updated_by,orig_sys_ref, model_id)
1070: VALUES

Line 1079: UPDATE cz_localized_texts

1075: '0',
1076: SYSDATE, SYSDATE, -UID, -UID,p_xfr_property.ORIG_SYS_REF, 0);
1077: END LOOP;
1078: ELSE
1079: UPDATE cz_localized_texts
1080: SET localized_str=DECODE(NOUPDATE_DEF_VALUE,0,p_xfr_property.DEF_VALUE,localized_str)
1081: WHERE intl_text_id=p_xfr_property.DEF_NUM_VALUE;
1082: END IF;
1083: ELSE