182: SELECT
183: decode( p_score_ID, FND_API.G_MISS_NUM, NULL, p_score_ID),
184: l.language_code,
185: SYSDATE,
186: FND_GLOBAL.user_id,
187: SYSDATE,
188: FND_GLOBAL.user_id,
189: FND_GLOBAL.conc_login_id,
190: USERENV('LANG'),
184: l.language_code,
185: SYSDATE,
186: FND_GLOBAL.user_id,
187: SYSDATE,
188: FND_GLOBAL.user_id,
189: FND_GLOBAL.conc_login_id,
190: USERENV('LANG'),
191: decode( p_score_name, FND_API.G_MISS_CHAR, NULL, p_score_name),
192: decode( p_description, FND_API.G_MISS_CHAR, NULL, p_description)
185: SYSDATE,
186: FND_GLOBAL.user_id,
187: SYSDATE,
188: FND_GLOBAL.user_id,
189: FND_GLOBAL.conc_login_id,
190: USERENV('LANG'),
191: decode( p_score_name, FND_API.G_MISS_CHAR, NULL, p_score_name),
192: decode( p_description, FND_API.G_MISS_CHAR, NULL, p_description)
193: FROM fnd_languages l
304: update ams_dm_scores_all_tl set
305: score_name = decode( p_score_NAME, FND_API.G_MISS_CHAR, score_NAME, p_score_NAME),
306: description = decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, DESCRIPTION, p_DESCRIPTION),
307: last_update_date = SYSDATE,
308: last_updated_by = FND_GLOBAL.user_id,
309: last_update_login = FND_GLOBAL.conc_login_id,
310: source_lang = USERENV('LANG')
311: WHERE score_id = p_score_ID
312: AND USERENV('LANG') IN (language, source_lang);
305: score_name = decode( p_score_NAME, FND_API.G_MISS_CHAR, score_NAME, p_score_NAME),
306: description = decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, DESCRIPTION, p_DESCRIPTION),
307: last_update_date = SYSDATE,
308: last_updated_by = FND_GLOBAL.user_id,
309: last_update_login = FND_GLOBAL.conc_login_id,
310: source_lang = USERENV('LANG')
311: WHERE score_id = p_score_ID
312: AND USERENV('LANG') IN (language, source_lang);
313: