168: ITEM_LOT_NOT_FOUND EXCEPTION;
169:
170: CURSOR c_item_parentlot IS
171: SELECT 1
172: FROM mtl_lot_numbers
173: WHERE inventory_item_id = p_inventory_item_id
174: AND organization_id = p_organization_id
175: AND parent_lot_number = p_parent_lot_number;
176:
175: AND parent_lot_number = p_parent_lot_number;
176:
177: CURSOR c_item_lot IS
178: SELECT 1
179: FROM mtl_lot_numbers
180: WHERE inventory_item_id = p_inventory_item_id
181: AND organization_id = p_organization_id
182: AND parent_lot_number = p_parent_lot_number
183: AND lot_number = p_lot_number;
361: IS
362:
363: CURSOR Cur_lot_data IS
364: SELECT creation_date, hold_date
365: FROM mtl_lot_numbers
366: WHERE inventory_item_id = p_inventory_item_id
367: AND organization_id = p_organization_id
368: AND lot_number = p_lot_number
369: AND ((p_parent_lot_number IS NULL)
377: CLOSE Cur_lot_data;
378: ELSIF (p_lot_number IS NOT NULL) THEN
379: SELECT max(creation_date)
380: INTO x_lot_created
381: FROM mtl_lot_numbers
382: WHERE lot_number = p_lot_number
383: AND organization_id = p_organization_id
384: AND inventory_item_id = p_inventory_item_id;
385:
384: AND inventory_item_id = p_inventory_item_id;
385:
386: SELECT max(hold_date)
387: INTO x_hold_date
388: FROM mtl_lot_numbers
389: WHERE lot_number = p_lot_number
390: AND organization_id = p_organization_id
391: AND inventory_item_id = p_inventory_item_id;
392: END IF;
1341:
1342: BEGIN
1343: SELECT grade_code, status_id
1344: INTO l_from_grade_code, l_from_lot_status_id
1345: FROM mtl_lot_numbers
1346: WHERE ((lot_number = l_lot_number) OR (l_lot_number IS NULL))
1347: AND ((parent_lot_number = l_parent_lot_number) OR (l_parent_lot_number IS NULL))
1348: AND organization_id = l_organization_id
1349: AND inventory_item_id = l_inventory_item_id;