APPS.AMS_LISTSOURCETYPE_PVT dependencies on AMS_LIST_SRC_TYPES_TL

Line 240: insert into AMS_LIST_SRC_TYPES_TL (

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

Line 266: from AMS_LIST_SRC_TYPES_TL T

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

Line 471: DELETE FROM ams_list_src_types_tl

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

Line 830: update AMS_LIST_SRC_TYPES_TL set

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

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

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