APPS.AMS_LISTSOURCETYPE_PVT dependencies on AMS_LIST_SRC_TYPES_TL

Line 238: insert into AMS_LIST_SRC_TYPES_TL (

234: l_listsrctype_rec.arc_act_src_used_by,
235: l_listsrctype_rec.source_category
236: );
237:
238: insert into AMS_LIST_SRC_TYPES_TL (
239: LANGUAGE,
240: SOURCE_LANG,
241: LIST_SOURCE_NAME,
242: DESCRIPTION,

Line 264: from AMS_LIST_SRC_TYPES_TL T

260: from FND_LANGUAGES L
261: where L.INSTALLED_FLAG in ('I', 'B')
262: and not exists
263: (select NULL
264: from AMS_LIST_SRC_TYPES_TL T
265: where T.LIST_SOURCE_TYPE_ID = l_listsrctype_rec.LIST_SOURCE_TYPE_ID
266: and T.LANGUAGE = L.LANGUAGE_CODE);
267:
268: IF l_listsrctype_rec.list_source_type = L_DATA_SOURCE_ANALYTICS THEN

Line 469: DELETE FROM ams_list_src_types_tl

465: WHERE list_source_type_id = p_list_source_type_id
466: AND object_version_number = p_object_version
467: ;
468:
469: DELETE FROM ams_list_src_types_tl
470: WHERE list_source_type_id = p_list_source_type_id
471: ;
472:
473:

Line 828: update AMS_LIST_SRC_TYPES_TL set

824: END IF;
825: RAISE FND_API.g_exc_error;
826: END IF;
827:
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,

Line 845: FND_MESSAGE.Set_Token('ROW', 'AMS_ListSourceType_PVT.Upd_AMS_LIST_SRC_TYPES_TL', TRUE);

841: -- API message list. --
842: ------------------------------------------------------------------
843: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
844: FND_MESSAGE.set_name('AMS', 'API_UNEXP_ERROR_IN_PROCESSING');
845: FND_MESSAGE.Set_Token('ROW', 'AMS_ListSourceType_PVT.Upd_AMS_LIST_SRC_TYPES_TL', TRUE);
846: FND_MSG_PUB.Add;
847: END IF;
848: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
849: END IF;