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