APPS.INV_ITEM_CATALOG_ELE_PVT dependencies on MTL_DESCR_ELEMENT_VALUES

Line 67: FROM mtl_descr_element_values

63:
64: CURSOR catalog_group_element_csr (p_element_name VARCHAR2,p_inventory_item_id NUMBER)
65: IS
66: SELECT element_name
67: FROM mtl_descr_element_values
68: WHERE inventory_item_id = p_inventory_item_id
69: AND element_name = p_element_name;
70:
71: CURSOR catalog_group_csr (p_inventory_item_id NUMBER)

Line 278: INV_ITEM_MSG.Debug(Mctx, 'begin UPDATE mtl_descr_element_values');

274: END IF;
275:
276: -- Update the production table
277:
278: INV_ITEM_MSG.Debug(Mctx, 'begin UPDATE mtl_descr_element_values');
279:
280: UPDATE mtl_descr_element_values
281: SET
282: element_value = p_element_value

Line 280: UPDATE mtl_descr_element_values

276: -- Update the production table
277:
278: INV_ITEM_MSG.Debug(Mctx, 'begin UPDATE mtl_descr_element_values');
279:
280: UPDATE mtl_descr_element_values
281: SET
282: element_value = p_element_value
283: , default_element_flag = decode(p_default_element_flag,'Y','Y','N')
284: , last_update_date = SYSDATE

Line 296: INV_ITEM_MSG.Debug(Mctx, 'end UPDATE mtl_descr_element_values');

292: inventory_item_id = l_inventory_item_id
293: AND element_name = p_element_name;
294:
295:
296: INV_ITEM_MSG.Debug(Mctx, 'end UPDATE mtl_descr_element_values');
297:
298: -- Standard check of p_commit
299: IF (FND_API.To_Boolean (p_commit)) THEN
300: