The following lines contain the word 'select', 'insert', 'update' or 'delete':
'(SELECT SECONDARY_LOCATOR FROM MTL_SECONDARY_LOCATORS ' ||
'WHERE INVENTORY_ITEM_ID = ' ||
TO_CHAR(P_Item_Id) ||
' AND ORGANIZATION_ID = ' || to_char(P_Organization_Id)
|| ' AND SUBINVENTORY_CODE = ' || P_Subinventory_Code || ')'; */
'(SELECT SECONDARY_LOCATOR FROM MTL_SECONDARY_LOCATORS ' ||
'WHERE INVENTORY_ITEM_ID = ''' ||
TO_NUMBER(P_Item_Id) ||'''' ||
' AND ORGANIZATION_ID = ''' || to_number(P_Organization_Id)||''''
|| ' AND SUBINVENTORY_CODE = ''' || P_Subinventory_Code||'''' || ')';
SELECT COUNT(*)
INTO x_count
FROM MTL_ITEM_LOCATIONS
WHERE (DISABLE_DATE > SYSDATE or
DISABLE_DATE IS NULL)
AND SUBINVENTORY_CODE = P_Subinventory_Code
AND INVENTORY_LOCATION_ID = P_Locator_Id
AND INVENTORY_LOCATION_ID IN
(SELECT SECONDARY_LOCATOR
FROM MTL_SECONDARY_LOCATORS
WHERE INVENTORY_ITEM_ID = P_Item_Id
AND ORGANIZATION_ID = P_Organization_Id
AND SUBINVENTORY_CODE = P_Subinventory_Code);
SELECT COUNT(*)
INTO x_count
FROM MTL_ITEM_LOCATIONS
WHERE (DISABLE_DATE > SYSDATE or
DISABLE_DATE IS NULL)
AND INVENTORY_LOCATION_ID = P_Locator_Id
AND NVL(SUBINVENTORY_CODE,'Z')
= NVL(P_Subinventory_Code,'Z');
UPDATE MTL_ITEM_LOCATIONS
SET SUBINVENTORY_CODE = P_Subinventory_Code
WHERE INVENTORY_LOCATION_ID = P_Locator_Id
AND ORGANIZATION_ID = P_Organization_Id;