APPS.OE_OE_FORM_LOT_SERIAL SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 514

        l_x_Lot_Serial_rec.operation := OE_GLOBALS.G_OPR_UPDATE;

Line: 848

, 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;

Line: 910

        l_x_Lot_Serial_rec.operation := OE_GLOBALS.G_OPR_UPDATE;

Line: 964

    x_last_update_date             := l_x_Lot_Serial_rec.last_update_date;

Line: 965

    x_last_updated_by              := l_x_Lot_Serial_rec.last_updated_by;

Line: 966

    x_last_update_login            := l_x_Lot_Serial_rec.last_update_login;

Line: 1056

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;

Line: 1106

    l_x_Lot_Serial_rec.operation := OE_GLOBALS.G_OPR_DELETE;

Line: 1187

            ,   'Delete_Row'
            );

Line: 1198

END Delete_Row;