101: SELECT
102: decode( px_target_value_id, FND_API.G_MISS_NUM, NULL, px_target_value_id),
103: l.language_code,
104: SYSDATE,
105: FND_GLOBAL.user_id,
106: SYSDATE,
107: FND_GLOBAL.user_id,
108: FND_GLOBAL.conc_login_id,
109: USERENV('LANG'),
103: l.language_code,
104: SYSDATE,
105: FND_GLOBAL.user_id,
106: SYSDATE,
107: FND_GLOBAL.user_id,
108: FND_GLOBAL.conc_login_id,
109: USERENV('LANG'),
110: decode( p_description, FND_API.G_MISS_CHAR, NULL, p_description)
111: FROM fnd_languages l
104: SYSDATE,
105: FND_GLOBAL.user_id,
106: SYSDATE,
107: FND_GLOBAL.user_id,
108: FND_GLOBAL.conc_login_id,
109: USERENV('LANG'),
110: decode( p_description, FND_API.G_MISS_CHAR, NULL, p_description)
111: FROM fnd_languages l
112: WHERE l.installed_flag in ('I', 'B')
164: -- update target value description in TL table
165: update ams_dm_target_values_tl set
166: description = decode( p_description, FND_API.G_MISS_CHAR, DESCRIPTION, p_description),
167: last_update_date = SYSDATE,
168: last_updated_by = FND_GLOBAL.user_id,
169: last_update_login = FND_GLOBAL.conc_login_id,
170: source_lang = USERENV('LANG')
171: WHERE target_value_id = p_target_value_id
172: AND USERENV('LANG') IN (language, source_lang);
165: update ams_dm_target_values_tl set
166: description = decode( p_description, FND_API.G_MISS_CHAR, DESCRIPTION, p_description),
167: last_update_date = SYSDATE,
168: last_updated_by = FND_GLOBAL.user_id,
169: last_update_login = FND_GLOBAL.conc_login_id,
170: source_lang = USERENV('LANG')
171: WHERE target_value_id = p_target_value_id
172: AND USERENV('LANG') IN (language, source_lang);
173: