210: SELECT
211: decode( p_MODEL_ID, FND_API.G_MISS_NUM, NULL, p_MODEL_ID),
212: l.language_code,
213: SYSDATE,
214: FND_GLOBAL.user_id,
215: SYSDATE,
216: FND_GLOBAL.user_id,
217: FND_GLOBAL.conc_login_id,
218: USERENV('LANG'),
212: l.language_code,
213: SYSDATE,
214: FND_GLOBAL.user_id,
215: SYSDATE,
216: FND_GLOBAL.user_id,
217: FND_GLOBAL.conc_login_id,
218: USERENV('LANG'),
219: decode( p_MODEL_NAME, FND_API.G_MISS_CHAR, NULL, p_MODEL_NAME),
220: decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_DESCRIPTION)
213: SYSDATE,
214: FND_GLOBAL.user_id,
215: SYSDATE,
216: FND_GLOBAL.user_id,
217: FND_GLOBAL.conc_login_id,
218: USERENV('LANG'),
219: decode( p_MODEL_NAME, FND_API.G_MISS_CHAR, NULL, p_MODEL_NAME),
220: decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_DESCRIPTION)
221: FROM fnd_languages l
348: update ams_dm_models_all_tl set
349: model_name = decode( p_MODEL_NAME, FND_API.G_MISS_CHAR, MODEL_NAME, p_MODEL_NAME),
350: description = decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, DESCRIPTION, p_DESCRIPTION),
351: last_update_date = SYSDATE,
352: last_updated_by = FND_GLOBAL.user_id,
353: last_update_login = FND_GLOBAL.conc_login_id,
354: source_lang = USERENV('LANG')
355: WHERE model_id = p_MODEL_ID
356: AND USERENV('LANG') IN (language, source_lang);
349: model_name = decode( p_MODEL_NAME, FND_API.G_MISS_CHAR, MODEL_NAME, p_MODEL_NAME),
350: description = decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, DESCRIPTION, p_DESCRIPTION),
351: last_update_date = SYSDATE,
352: last_updated_by = FND_GLOBAL.user_id,
353: last_update_login = FND_GLOBAL.conc_login_id,
354: source_lang = USERENV('LANG')
355: WHERE model_id = p_MODEL_ID
356: AND USERENV('LANG') IN (language, source_lang);
357: