APPS.INV_ITEM_CATEGORY_PUB dependencies on MTL_CATEGORIES_TL

Line 2053: UPDATE mtl_categories_tl

2049: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2050: FND_MSG_PUB.initialize;
2051: END IF;
2052:
2053: UPDATE mtl_categories_tl
2054: SET
2055: description = p_description,
2056: last_update_date = Sysdate,
2057: last_updated_by = fnd_global.user_id,

Line 2263: delete from mtl_categories_tl

2259: END IF;
2260: RAISE FND_API.G_EXC_ERROR;
2261: END IF;
2262:
2263: delete from mtl_categories_tl
2264: where category_id = p_category_id ;
2265:
2266: if (sql%notfound) then
2267: fnd_message.set_name('INV','INV_VALID_CAT');

Line 2270: mdebug('Trying to delete non-existant Category Id from MTL_CATEGORIES_TL.');

2266: if (sql%notfound) then
2267: fnd_message.set_name('INV','INV_VALID_CAT');
2268: fnd_msg_pub.ADD;
2269: IF (l_debug = 1) THEN
2270: mdebug('Trying to delete non-existant Category Id from MTL_CATEGORIES_TL.');
2271: END IF;
2272: RAISE NO_DATA_FOUND;
2273: end if;
2274: