APPS.AHL_OSP_SHIPMENT_PUB dependencies on OE_LOT_SERIAL_UTIL

Line 4116: OE_LOT_SERIAL_UTIL.Query_Row(p_lot_serial_id => l_lot_serial_id,

4112: ELSIF (p_line_tbl(i).operation = 'U') THEN
4113: OPEN ahl_oe_lot_serial_id (p_line_tbl(i).line_id);
4114: FETCH ahl_oe_lot_serial_id INTO l_lot_serial_id;
4115: IF (ahl_oe_lot_serial_id%FOUND) THEN
4116: OE_LOT_SERIAL_UTIL.Query_Row(p_lot_serial_id => l_lot_serial_id,
4117: x_lot_serial_rec =>l_lot_serial_rec);
4118: l_lot_serial_rec.from_serial_number := p_line_tbl(i).serial_number;
4119: l_lot_serial_rec.lot_number := p_line_tbl(i).lot_number;
4120: l_lot_serial_rec.quantity := p_line_tbl(i).ordered_quantity;

Line 6972: OE_LOT_SERIAL_UTIL.Query_Row(p_lot_serial_id => l_lot_serial_id, x_lot_serial_rec =>l_oe_lot_serial_rec);

6968: IF (ahl_oe_lot_serial_id%FOUND) THEN
6969: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6970: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'l_lot_serial_id=>'||l_lot_serial_id);
6971: END IF;
6972: OE_LOT_SERIAL_UTIL.Query_Row(p_lot_serial_id => l_lot_serial_id, x_lot_serial_rec =>l_oe_lot_serial_rec);
6973: END IF;
6974:
6975: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6976: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'l_instance_dtls_rec.inventory_item_id =>'||l_instance_dtls_rec.inventory_item_id);