[Home] [Help]
5240: AND l_lot_control_code = 2) THEN
5241: BEGIN
5242: SELECT expiration_date
5243: INTO l_expiration_date
5244: FROM mtl_lot_numbers
5245: WHERE inventory_item_id = l_inventory_item_id
5246: AND organization_id = l_lpn_org
5247: AND lot_number = l_lot_number;
5248: EXCEPTION
5362: SELECT expiration_date
5363: , status_id
5364: INTO l_expiration_date
5365: , l_lot_status_id
5366: FROM mtl_lot_numbers
5367: WHERE inventory_item_id = l_inventory_item_id
5368: AND organization_id = l_lpn_org
5369: AND lot_number = l_lot_number;
5370:
6589: print_debug('Checking if ' || i.lot_number || ' exists', 1);
6590: END IF;
6591:
6592: /* Before creating move orders, lot numbers should exist in
6593: ** mtl_lot_numbers. So, insert the lot number from
6594: ** mtl_transactions_lot_temp into mtl_lot_numbers
6595: ** by calling API INV_LOT_API_PUB.insertLot.
6596: ** This API takes care of populating attributes also.
6597: */
6590: END IF;
6591:
6592: /* Before creating move orders, lot numbers should exist in
6593: ** mtl_lot_numbers. So, insert the lot number from
6594: ** mtl_transactions_lot_temp into mtl_lot_numbers
6595: ** by calling API INV_LOT_API_PUB.insertLot.
6596: ** This API takes care of populating attributes also.
6597: */
6598: BEGIN
6597: */
6598: BEGIN
6599: SELECT '1'
6600: INTO l_dummy
6601: FROM mtl_lot_numbers
6602: WHERE lot_number = i.lot_number
6603: AND inventory_item_id = p_item_id
6604: AND organization_id = p_org_id; --Added bug3466942
6605: