APPS.AHL_OSP_SHIPMENT_PUB dependencies on OE_LOT_SERIAL_UTIL

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

4096: ELSIF (p_line_tbl(i).operation = 'U') THEN
4097: OPEN ahl_oe_lot_serial_id (p_line_tbl(i).line_id);
4098: FETCH ahl_oe_lot_serial_id INTO l_lot_serial_id;
4099: IF (ahl_oe_lot_serial_id%FOUND) THEN
4100: OE_LOT_SERIAL_UTIL.Query_Row(p_lot_serial_id => l_lot_serial_id,
4101: x_lot_serial_rec =>l_lot_serial_rec);
4102: l_lot_serial_rec.from_serial_number := p_line_tbl(i).serial_number;
4103: l_lot_serial_rec.lot_number := p_line_tbl(i).lot_number;
4104: l_lot_serial_rec.quantity := p_line_tbl(i).ordered_quantity;

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

7016: IF (ahl_oe_lot_serial_id%FOUND) THEN
7017: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7018: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'l_lot_serial_id=>'||l_lot_serial_id);
7019: END IF;
7020: OE_LOT_SERIAL_UTIL.Query_Row(p_lot_serial_id => l_lot_serial_id, x_lot_serial_rec =>l_oe_lot_serial_rec);
7021: END IF;
7022: -- Missed CLOSE statement added by jaramana on 12-APR-2010
7023: CLOSE ahl_oe_lot_serial_id;
7024: