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