118: AND x_loc_control = WIP_CONSTANTS.PRESPECIFIED THEN
119:
120: SELECT COUNT(*)
121: INTO x_count
122: FROM MTL_ITEM_LOCATIONS
123: WHERE (DISABLE_DATE > SYSDATE or
124: DISABLE_DATE IS NULL)
125: AND SUBINVENTORY_CODE = P_Subinventory_Code
126: AND INVENTORY_LOCATION_ID = P_Locator_Id
134: ELSE
135:
136: SELECT COUNT(*)
137: INTO x_count
138: FROM MTL_ITEM_LOCATIONS
139: WHERE (DISABLE_DATE > SYSDATE or
140: DISABLE_DATE IS NULL)
141: AND INVENTORY_LOCATION_ID = P_Locator_Id
142: AND NVL(SUBINVENTORY_CODE,'Z')
161:
162: P_Locator_Id := FND_FLEX_KEYVAL.COMBINATION_ID;
163:
164: IF x_loc_control = WIP_CONSTANTS.DYNAMIC THEN
165: UPDATE MTL_ITEM_LOCATIONS
166: SET SUBINVENTORY_CODE = P_Subinventory_Code
167: WHERE INVENTORY_LOCATION_ID = P_Locator_Id
168: AND ORGANIZATION_ID = P_Organization_Id;
169: END IF;