DBA Data[Home] [Help]

APPS.CZ_IMP_IM_XFR dependencies on CZ_LOCALIZED_TEXTS

Line 908: INSERT INTO cz_localized_texts (intl_text_id, localized_str,

904: SELECT CZ_INTL_TEXTS_S.NEXTVAL INTO l_def_num_value FROM dual;
905: FOR i IN(SELECT language_code FROM FND_LANGUAGES
906: WHERE installed_flag in( 'B', 'I'))
907: LOOP
908: INSERT INTO cz_localized_texts (intl_text_id, localized_str,
909: language, source_lang, deleted_flag,
910: creation_date, last_update_date, created_by,
911: last_updated_by,orig_sys_ref, model_id)
912: VALUES

Line 1114: INSERT INTO cz_localized_texts (intl_text_id, localized_str,

1110: SELECT CZ_INTL_TEXTS_S.NEXTVAL INTO l_def_num_value FROM dual;
1111: FOR i IN(SELECT language_code FROM FND_LANGUAGES
1112: WHERE installed_flag in( 'B', 'I'))
1113: LOOP
1114: INSERT INTO cz_localized_texts (intl_text_id, localized_str,
1115: language, source_lang, deleted_flag,
1116: creation_date, last_update_date, created_by,
1117: last_updated_by,orig_sys_ref, model_id)
1118: VALUES

Line 1127: UPDATE cz_localized_texts

1123: '0',
1124: SYSDATE, SYSDATE, -UID, -UID,p_xfr_property.ORIG_SYS_REF, 0);
1125: END LOOP;
1126: ELSE
1127: UPDATE cz_localized_texts
1128: SET localized_str=DECODE(NOUPDATE_DEF_VALUE,0,p_xfr_property.DEF_VALUE,localized_str)
1129: WHERE intl_text_id=p_xfr_property.DEF_NUM_VALUE;
1130: END IF;
1131: ELSE