The following lines contain the word 'select', 'insert', 'update' or 'delete':
l_x_Lot_Serial_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
, x_last_update_date OUT NOCOPY DATE
, x_last_updated_by OUT NOCOPY NUMBER
, x_last_update_login OUT NOCOPY NUMBER
, x_lock_control OUT NOCOPY NUMBER
)
IS
l_x_old_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
l_x_Lot_Serial_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
x_last_update_date := l_x_Lot_Serial_rec.last_update_date;
x_last_updated_by := l_x_Lot_Serial_rec.last_updated_by;
x_last_update_login := l_x_Lot_Serial_rec.last_update_login;
PROCEDURE Delete_Row
( x_return_status OUT NOCOPY VARCHAR2
, x_msg_count OUT NOCOPY NUMBER
, x_msg_data OUT NOCOPY VARCHAR2
, p_lot_serial_id IN NUMBER
)
IS
l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
l_x_Lot_Serial_rec.operation := OE_GLOBALS.G_OPR_DELETE;
, 'Delete_Row'
);
END Delete_Row;