DBA Data[Home] [Help]

APPS.AMS_LISTFIELD_PVT dependencies on FND_GLOBAL

Line 256: last_updated_by = FND_GLOBAL.user_id,

252: column_data_length = l_listfield_rec.column_data_length,
253: enabled_flag = l_listfield_rec.enabled_flag,
254: list_type_field_apply_on = l_listfield_rec.list_type_field_apply_on,
255: last_update_date = SYSDATE,
256: last_updated_by = FND_GLOBAL.user_id,
257: last_update_login = FND_GLOBAL.conc_login_id
258: WHERE list_field_id = l_listfield_rec.list_field_id;
259:
260: IF (SQL%NOTFOUND) THEN

Line 257: last_update_login = FND_GLOBAL.conc_login_id

253: enabled_flag = l_listfield_rec.enabled_flag,
254: list_type_field_apply_on = l_listfield_rec.list_type_field_apply_on,
255: last_update_date = SYSDATE,
256: last_updated_by = FND_GLOBAL.user_id,
257: last_update_login = FND_GLOBAL.conc_login_id
258: WHERE list_field_id = l_listfield_rec.list_field_id;
259:
260: IF (SQL%NOTFOUND) THEN
261: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN

Line 272: last_updated_by = FND_GLOBAL.user_id,

268: UPDATE ams_list_fields_tl
269: SET
270: description = l_listfield_rec.description,
271: last_update_date = SYSDATE,
272: last_updated_by = FND_GLOBAL.user_id,
273: last_update_login = FND_GLOBAL.conc_login_id,
274: source_lang = USERENV('LANG')
275: WHERE list_field_id = l_listfield_rec.list_field_id
276: AND USERENV('LANG') IN (language, source_lang);

Line 273: last_update_login = FND_GLOBAL.conc_login_id,

269: SET
270: description = l_listfield_rec.description,
271: last_update_date = SYSDATE,
272: last_updated_by = FND_GLOBAL.user_id,
273: last_update_login = FND_GLOBAL.conc_login_id,
274: source_lang = USERENV('LANG')
275: WHERE list_field_id = l_listfield_rec.list_field_id
276: AND USERENV('LANG') IN (language, source_lang);
277: