DBA Data[Home] [Help]

APPS.AMS_LISTSOURCETYPE_PVT dependencies on FND_GLOBAL

Line 218: FND_GLOBAL.user_id,

214: )
215: VALUES (
216: l_listsrctype_rec.list_source_type_id,
217: SYSDATE,
218: FND_GLOBAL.user_id,
219: SYSDATE,
220: FND_GLOBAL.user_id,
221: FND_GLOBAL.conc_login_id,
222: 1, -- object_version_number

Line 220: FND_GLOBAL.user_id,

216: l_listsrctype_rec.list_source_type_id,
217: SYSDATE,
218: FND_GLOBAL.user_id,
219: SYSDATE,
220: FND_GLOBAL.user_id,
221: FND_GLOBAL.conc_login_id,
222: 1, -- object_version_number
223: l_listsrctype_rec.list_source_type,
224: l_listsrctype_rec.source_type_code,

Line 221: FND_GLOBAL.conc_login_id,

217: SYSDATE,
218: FND_GLOBAL.user_id,
219: SYSDATE,
220: FND_GLOBAL.user_id,
221: FND_GLOBAL.conc_login_id,
222: 1, -- object_version_number
223: l_listsrctype_rec.list_source_type,
224: l_listsrctype_rec.source_type_code,
225: l_listsrctype_rec.source_object_name,

Line 256: FND_GLOBAL.user_id,

252: l_listsrctype_rec.LIST_SOURCE_NAME,
253: l_listsrctype_rec.DESCRIPTION,
254: l_listsrctype_rec.LIST_SOURCE_TYPE_ID,
255: sysdate,
256: FND_GLOBAL.user_id,
257: sysdate,
258: FND_GLOBAL.user_id,
259: FND_GLOBAL.conc_login_id
260: from FND_LANGUAGES L

Line 258: FND_GLOBAL.user_id,

254: l_listsrctype_rec.LIST_SOURCE_TYPE_ID,
255: sysdate,
256: FND_GLOBAL.user_id,
257: sysdate,
258: FND_GLOBAL.user_id,
259: FND_GLOBAL.conc_login_id
260: from FND_LANGUAGES L
261: where L.INSTALLED_FLAG in ('I', 'B')
262: and not exists

Line 259: FND_GLOBAL.conc_login_id

255: sysdate,
256: FND_GLOBAL.user_id,
257: sysdate,
258: FND_GLOBAL.user_id,
259: FND_GLOBAL.conc_login_id
260: from FND_LANGUAGES L
261: where L.INSTALLED_FLAG in ('I', 'B')
262: and not exists
263: (select NULL

Line 802: last_updated_by = FND_GLOBAL.user_id,

798: -------------------------- update --------------------
799: UPDATE ams_list_src_types
800: SET
801: last_update_date = SYSDATE,
802: last_updated_by = FND_GLOBAL.user_id,
803: last_update_login = FND_GLOBAL.conc_login_id,
804: object_version_number = object_version_number + 1,
805: list_source_type = l_listsrctype_rec.list_source_type,
806: source_type_code = l_listsrctype_rec.source_type_code,

Line 803: last_update_login = FND_GLOBAL.conc_login_id,

799: UPDATE ams_list_src_types
800: SET
801: last_update_date = SYSDATE,
802: last_updated_by = FND_GLOBAL.user_id,
803: last_update_login = FND_GLOBAL.conc_login_id,
804: object_version_number = object_version_number + 1,
805: list_source_type = l_listsrctype_rec.list_source_type,
806: source_type_code = l_listsrctype_rec.source_type_code,
807: source_object_name = l_listsrctype_rec.source_object_name,

Line 832: LAST_UPDATE_BY = FND_GLOBAL.user_id,

828: update AMS_LIST_SRC_TYPES_TL set
829: LIST_SOURCE_NAME = l_listsrctype_rec.LIST_SOURCE_NAME,
830: DESCRIPTION = l_listsrctype_rec.DESCRIPTION,
831: LAST_UPDATE_DATE = sysdate,
832: LAST_UPDATE_BY = FND_GLOBAL.user_id,
833: LAST_UPDATE_LOGIN = FND_GLOBAL.conc_login_id,
834: SOURCE_LANG = userenv('LANG')
835: where list_source_type_id = l_listsrctype_rec.list_source_type_id
836: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line 833: LAST_UPDATE_LOGIN = FND_GLOBAL.conc_login_id,

829: LIST_SOURCE_NAME = l_listsrctype_rec.LIST_SOURCE_NAME,
830: DESCRIPTION = l_listsrctype_rec.DESCRIPTION,
831: LAST_UPDATE_DATE = sysdate,
832: LAST_UPDATE_BY = FND_GLOBAL.user_id,
833: LAST_UPDATE_LOGIN = FND_GLOBAL.conc_login_id,
834: SOURCE_LANG = userenv('LANG')
835: where list_source_type_id = l_listsrctype_rec.list_source_type_id
836: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
837: