APPS.INV_TO_FORM_TROLIN SQL Statements

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

Line: 542

        l_trolin_rec.operation := INV_GLOBALS.G_OPR_UPDATE;

Line: 1152

,   x_last_update_date              OUT NOCOPY DATE
,   x_last_updated_by               OUT NOCOPY NUMBER
,   x_last_update_login             OUT NOCOPY NUMBER
)
IS
l_trolin_rec                  INV_Move_Order_PUB.Trolin_Rec_Type;

Line: 1273

        l_trolin_rec.operation := INV_GLOBALS.G_OPR_UPDATE;

Line: 1311

    x_last_update_date             := l_x_trolin_rec.last_update_date;

Line: 1312

    x_last_updated_by              := l_x_trolin_rec.last_updated_by;

Line: 1313

    x_last_update_login            := l_x_trolin_rec.last_update_login;

Line: 1384

PROCEDURE Delete_Row
(   x_return_status                 OUT NOCOPY VARCHAR2
,   x_msg_count                     OUT NOCOPY NUMBER
,   x_msg_data                      OUT NOCOPY VARCHAR2
,   p_line_id                       IN  NUMBER
)
IS
l_trolin_rec                  INV_Move_Order_PUB.Trolin_Rec_Type;

Line: 1425

    l_trolin_rec.operation := INV_GLOBALS.G_OPR_DELETE;

Line: 1500

            ,   'Delete_Row'
            );

Line: 1511

END Delete_Row;

Line: 1654

,   p_last_updated_by               IN  NUMBER
,   p_last_update_date              IN  DATE
,   p_last_update_login             IN  NUMBER
,   p_line_id                       IN  NUMBER
,   p_line_number                   IN  NUMBER
,   p_line_status                   IN  NUMBER
,   p_lot_number                    IN  VARCHAR2
,   p_organization_id               IN  NUMBER
,   p_program_application_id        IN  NUMBER
,   p_program_id                    IN  NUMBER
,   p_program_update_date           IN  DATE
,   p_project_id                    IN  NUMBER
,   p_quantity                      IN  NUMBER
,   p_quantity_delivered            IN  NUMBER
,   p_quantity_detailed             IN  NUMBER
,   p_reason_id                     IN  NUMBER
,   p_reference                     IN  VARCHAR2
,   p_reference_id                  IN  NUMBER
,   p_reference_type_code           IN  NUMBER
,   p_request_id                    IN  NUMBER
,   p_revision                      IN  VARCHAR2
,   p_serial_number_end             IN  VARCHAR2
,   p_serial_number_start           IN  VARCHAR2
,   p_status_date                   IN  DATE
,   p_task_id                       IN  NUMBER
,   p_to_account_id                 IN  NUMBER
,   p_to_locator_id                 IN  NUMBER
,   p_to_subinventory_code          IN  VARCHAR2
,   p_to_subinventory_id            IN  NUMBER
,   p_transaction_header_id         IN  NUMBER
,   p_transaction_type_id           IN  NUMBER
,   p_transaction_source_type_id    IN  NUMBER
,   p_txn_source_id                 IN  NUMBER
,   p_txn_source_line_id            IN  NUMBER
,   p_txn_source_line_detail_id     IN  NUMBER
,   p_primary_quantity              IN  NUMBER
,   p_to_organization_id            IN  NUMBER
,   p_pick_strategy_id              IN  NUMBER
,   p_put_away_strategy_id          IN  NUMBER
,   p_unit_number          	    IN  VARCHAR2
,   p_uom_code                      IN  VARCHAR2
,   p_ship_to_location_id           IN  NUMBER
,   p_from_cost_group_id	    IN  NUMBER DEFAULT NULL
,   p_to_cost_group_id		    IN  NUMBER DEFAULT NULL
,   p_lpn_id			    IN  NUMBER DEFAULT NULL
,   p_to_lpn_id               IN  NUMBER DEFAULT NULL
,   p_secondary_quantity            IN NUMBER DEFAULT NULL   --INVCONV change
,   p_secondary_quantity_delivered  IN NUMBER DEFAULT NULL   --INVCONV change
,   p_secondary_quantity_detailed   IN NUMBER DEFAULT NULL   --INVCONV change
,   p_secondary_uom_code            IN VARCHAR2 DEFAULT NULL --INVCONV change
,   p_grade_code                    IN VARCHAR2 DEFAULT NULL --INVCONV change
)
IS
l_return_status               VARCHAR2(1);

Line: 1742

    l_trolin_rec.last_updated_by   := p_last_updated_by;

Line: 1743

    l_trolin_rec.last_update_date  := p_last_update_date;

Line: 1744

    l_trolin_rec.last_update_login := p_last_update_login;

Line: 1752

    l_trolin_rec.program_update_date := p_program_update_date;