DBA Data[Home] [Help]

APPS.INV_ITEM_CATALOG_ELE_PVT dependencies on MTL_DESCR_ELEMENT_VALUES

Line 66: FROM mtl_descr_element_values

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

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

245: END IF;
246:
247: -- Update the production table
248:
249: INV_ITEM_MSG.Debug(Mctx, 'begin UPDATE mtl_descr_element_values');
250:
251: UPDATE mtl_descr_element_values
252: SET
253: element_value = p_element_value

Line 251: UPDATE mtl_descr_element_values

247: -- Update the production table
248:
249: INV_ITEM_MSG.Debug(Mctx, 'begin UPDATE mtl_descr_element_values');
250:
251: UPDATE mtl_descr_element_values
252: SET
253: element_value = p_element_value
254: , default_element_flag = decode(p_default_element_flag,'Y','Y','N')
255: , last_update_date = SYSDATE

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

263: inventory_item_id = l_inventory_item_id
264: AND element_name = p_element_name;
265:
266:
267: INV_ITEM_MSG.Debug(Mctx, 'end UPDATE mtl_descr_element_values');
268:
269: -- Standard check of p_commit
270: IF (FND_API.To_Boolean (p_commit)) THEN
271: