APPS.INV_ITEM_CATEGORY_PUB dependencies on MTL_CATEGORIES_TL

Line 2034: UPDATE mtl_categories_tl

2030: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2031: FND_MSG_PUB.initialize;
2032: END IF;
2033:
2034: UPDATE mtl_categories_tl
2035: SET
2036: description = p_description,
2037: last_update_date = Sysdate,
2038: last_updated_by = fnd_global.user_id,

Line 2244: delete from mtl_categories_tl

2240: END IF;
2241: RAISE FND_API.G_EXC_ERROR;
2242: END IF;
2243:
2244: delete from mtl_categories_tl
2245: where category_id = p_category_id ;
2246:
2247: if (sql%notfound) then
2248: fnd_message.set_name('INV','INV_VALID_CAT');

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

2247: if (sql%notfound) then
2248: fnd_message.set_name('INV','INV_VALID_CAT');
2249: fnd_msg_pub.ADD;
2250: IF (l_debug = 1) THEN
2251: mdebug('Trying to delete non-existant Category Id from MTL_CATEGORIES_TL.');
2252: END IF;
2253: RAISE NO_DATA_FOUND;
2254: end if;
2255: