The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT COUNT(*)
INTO l_tmp_count
FROM mtl_system_items_kfv mi
WHERE mi.inventory_item_id = p_inventory_item_id
AND mi.organization_id = p_organization_id;
SELECT COUNT(*)
INTO l_tmp_count
FROM mtl_system_items_tl mtl
WHERE mtl.inventory_item_id = p_inventory_item_id
AND mtl.organization_id = p_organization_id
AND mtl.language = mtl.source_lang;
SELECT COUNT(*)
INTO l_tmp_count
FROM mtl_item_categories mic
WHERE mic.inventory_item_id = p_inventory_item_id
AND mic.organization_id = p_organization_id
AND mic.category_set_id = 2;
IF (P_DML_TYPE = 'DELETE') THEN
-- Info: Deleting an item from the master org also deletes the items from its child orgs
l_err_loc := 800;
ICX_CAT_POPULATE_MI_PVT.populateItemDelete(P_INVENTORY_ITEM_ID, P_ORGANIZATION_ID);
IF (P_DML_TYPE = 'DELETE') THEN
l_err_loc := 1000;
ICX_CAT_POPULATE_MI_PVT.populateItemCatgDelete(P_INVENTORY_ITEM_ID, P_ORGANIZATION_ID);