DBA Data[Home] [Help]

APPS.AMS_LISTSOURCETYPE_PVT dependencies on FND_GLOBAL

Line 220: FND_GLOBAL.user_id,

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

Line 222: FND_GLOBAL.user_id,

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

Line 223: FND_GLOBAL.conc_login_id,

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

Line 258: FND_GLOBAL.user_id,

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

Line 260: FND_GLOBAL.user_id,

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

Line 261: FND_GLOBAL.conc_login_id

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

Line 804: last_updated_by = FND_GLOBAL.user_id,

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

Line 805: last_update_login = FND_GLOBAL.conc_login_id,

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

Line 834: LAST_UPDATE_BY = FND_GLOBAL.user_id,

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

Line 835: LAST_UPDATE_LOGIN = FND_GLOBAL.conc_login_id,

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