The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT organization_id
FROM mtl_system_items_b
WHERE inventory_item_id = p_inventory_item_id;
SELECT element_name
FROM mtl_descr_element_values
WHERE inventory_item_id = p_inventory_item_id
AND element_name = p_element_name;
SELECT item_Catalog_group_id
FROM mtl_system_items_b
WHERE inventory_item_id = p_inventory_item_id
AND item_Catalog_group_id IS NOT NULL;
Select concatenated_segments
into l_item_number
From mtl_system_items_b_kfv
where INVENTORY_ITEM_ID = l_inventory_item_id
AND organization_id = l_org_id;
( p_Msg_Name =>'INV_IOI_ITEM_UPDATE_PRIV'
, p_token => 'VALUE'
, p_value => l_item_number );
INV_ITEM_MSG.Debug(Mctx, 'begin UPDATE mtl_descr_element_values');
UPDATE mtl_descr_element_values
SET
element_value = p_element_value
, default_element_flag = decode(p_default_element_flag,'Y','Y','N')
, last_update_date = SYSDATE
, last_updated_by = FND_GLOBAL.user_id
, last_update_login = FND_GLOBAL.login_id
, request_id = FND_GLOBAL.conc_request_id
, program_application_id = FND_GLOBAL.prog_appl_id
, program_id = FND_GLOBAL.conc_program_id
, program_update_date = SYSDATE
WHERE
inventory_item_id = l_inventory_item_id
AND element_name = p_element_name;
INV_ITEM_MSG.Debug(Mctx, 'end UPDATE mtl_descr_element_values');
INV_ITEM_MSG.Write_List (p_delete => TRUE);