DBA Data[Home] [Help]

APPS.AMS_DM_SCORES_B_PKG dependencies on FND_GLOBAL

Line 186: FND_GLOBAL.user_id,

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'),

Line 188: FND_GLOBAL.user_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'),
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)

Line 189: FND_GLOBAL.conc_login_id,

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

Line 308: last_updated_by = FND_GLOBAL.user_id,

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);

Line 309: last_update_login = FND_GLOBAL.conc_login_id,

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: