[Home] [Help]
4965: AND l_lot_control_code = 2) THEN
4966: BEGIN
4967: SELECT expiration_date
4968: INTO l_expiration_date
4969: FROM mtl_lot_numbers
4970: WHERE inventory_item_id = l_inventory_item_id
4971: AND organization_id = l_lpn_org
4972: AND lot_number = l_lot_number;
4973: EXCEPTION
5087: SELECT expiration_date
5088: , status_id
5089: INTO l_expiration_date
5090: , l_lot_status_id
5091: FROM mtl_lot_numbers
5092: WHERE inventory_item_id = l_inventory_item_id
5093: AND organization_id = l_lpn_org
5094: AND lot_number = l_lot_number;
5095:
6238: print_debug('Checking if ' || i.lot_number || ' exists', 1);
6239: END IF;
6240:
6241: /* Before creating move orders, lot numbers should exist in
6242: ** mtl_lot_numbers. So, insert the lot number from
6243: ** mtl_transactions_lot_temp into mtl_lot_numbers
6244: ** by calling API INV_LOT_API_PUB.insertLot.
6245: ** This API takes care of populating attributes also.
6246: */
6239: END IF;
6240:
6241: /* Before creating move orders, lot numbers should exist in
6242: ** mtl_lot_numbers. So, insert the lot number from
6243: ** mtl_transactions_lot_temp into mtl_lot_numbers
6244: ** by calling API INV_LOT_API_PUB.insertLot.
6245: ** This API takes care of populating attributes also.
6246: */
6247: BEGIN
6246: */
6247: BEGIN
6248: SELECT '1'
6249: INTO l_dummy
6250: FROM mtl_lot_numbers
6251: WHERE lot_number = i.lot_number
6252: AND inventory_item_id = p_item_id
6253: AND organization_id = p_org_id; --Added bug3466942
6254: