40: --
41: l_value varchar2(2000);
42: CURSOR c IS
43: SELECT concatenated_segments
44: FROM mtl_item_locations_kfv
45: WHERE inventory_location_id = p_locator_id and
46: organization_id = p_org_id;
47:
48: BEGIN
262: RETURN NULL;
263: END IF;
264:
265: select concatenated_segments into locator_name
266: from mtl_item_locations_kfv
267: where INVENTORY_LOCATION_ID = x_locator_id
268: and organization_id = x_org_id
269: and rownum=1;
270:
293: --
294:
295: /*
296: select inventory_location_id into id
297: from mtl_item_locations_kfv
298: where concatenated_segments = x_locator
299: and organization_id = x_org_id
300: and rownum = 1;
301: