APPS.INV_TO_FORM_TROHDR SQL Statements

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

Line: 372

        l_trohdr_rec.operation := INV_GLOBALS.G_OPR_UPDATE;

Line: 735

,   x_last_update_date              OUT NOCOPY DATE
,   x_last_updated_by               OUT NOCOPY NUMBER
,   x_last_update_login             OUT NOCOPY NUMBER
)
IS
l_trohdr_rec                  INV_Move_Order_PUB.Trohdr_Rec_Type;

Line: 810

        l_trohdr_rec.operation := INV_GLOBALS.G_OPR_UPDATE;

Line: 842

    x_last_update_date             := l_x_trohdr_rec.last_update_date;

Line: 843

    x_last_updated_by              := l_x_trohdr_rec.last_updated_by;

Line: 844

    x_last_update_login            := l_x_trohdr_rec.last_update_login;

Line: 915

PROCEDURE Delete_Row
(   x_return_status                 OUT NOCOPY VARCHAR2
,   x_msg_count                     OUT NOCOPY NUMBER
,   x_msg_data                      OUT NOCOPY VARCHAR2
,   p_header_id                     IN  NUMBER
)
IS
l_trohdr_rec                  INV_Move_Order_PUB.Trohdr_Rec_Type;

Line: 954

    l_trohdr_rec.operation := INV_GLOBALS.G_OPR_DELETE;

Line: 1025

            ,   'Delete_Row'
            );

Line: 1036

END Delete_Row;

Line: 1286

,   p_last_updated_by               IN  NUMBER
,   p_last_update_date              IN  DATE
,   p_last_update_login             IN  NUMBER
,   p_organization_id               IN  NUMBER
,   p_program_application_id        IN  NUMBER
,   p_program_id                    IN  NUMBER
,   p_program_update_date           IN  DATE
,   p_request_id                    IN  NUMBER
,   p_request_number                IN  VARCHAR2
,   p_status_date                   IN  DATE
,   p_to_account_id                 IN  NUMBER
,   p_to_subinventory_code          IN  VARCHAR2
,   p_move_order_type               IN  NUMBER
,   p_transaction_type_id	    IN  NUMBER
,   p_ship_to_location_id           IN  NUMBER
)
IS
l_return_status               VARCHAR2(1);

Line: 1335

    l_trohdr_rec.last_updated_by   := p_last_updated_by;

Line: 1336

    l_trohdr_rec.last_update_date  := p_last_update_date;

Line: 1337

    l_trohdr_rec.last_update_login := p_last_update_login;

Line: 1341

    l_trohdr_rec.program_update_date := p_program_update_date;