2881: AND q.value_attribute_type = vat.value_attribute_type)
2882: AND '$Header: AFFFKAIB.pls 120.10.12010000.1 2008/07/25 14:14:04 appldev ship $' IS NOT NULL;
2883: END;
2884:
2885: INSERT INTO fnd_id_flex_segments_tl(application_id,
2886: id_flex_code,
2887: id_flex_num,
2888: application_column_name,
2889: language,
2917: FROM fnd_languages l
2918: WHERE l.installed_flag IN ('I', 'B')
2919: AND NOT EXISTS
2920: (SELECT NULL
2921: FROM fnd_id_flex_segments_tl t
2922: WHERE t.application_id = flexfield.application_id
2923: AND t.id_flex_code = flexfield.flex_code
2924: AND t.id_flex_num = structure.structure_number
2925: AND t.application_column_name = segment.column_name
3122: AND '$Header: AFFFKAIB.pls 120.10.12010000.1 2008/07/25 14:14:04 appldev ship $' IS NOT NULL;
3123: END;
3124:
3125:
3126: UPDATE fnd_id_flex_segments_tl SET
3127: application_column_name = segment.column_name,
3128: form_left_prompt = segment.window_prompt,
3129: form_above_prompt = segment.lov_prompt,
3130: description = segment.description,
3170:
3171: --
3172: -- Delete from translation table.
3173: --
3174: DELETE FROM fnd_id_flex_segments_tl
3175: WHERE application_id = flexfield.application_id
3176: AND id_flex_code = flexfield.flex_code
3177: AND id_flex_num = structure.structure_number
3178: AND application_column_name = segment.column_name