The following lines contain the word 'select', 'insert', 'update' or 'delete':
l_trolin_rec.operation := INV_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
)
IS
l_trolin_rec INV_Move_Order_PUB.Trolin_Rec_Type;
l_trolin_rec.operation := INV_GLOBALS.G_OPR_UPDATE;
x_last_update_date := l_x_trolin_rec.last_update_date;
x_last_updated_by := l_x_trolin_rec.last_updated_by;
x_last_update_login := l_x_trolin_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_line_id IN NUMBER
)
IS
l_trolin_rec INV_Move_Order_PUB.Trolin_Rec_Type;
l_trolin_rec.operation := INV_GLOBALS.G_OPR_DELETE;
, 'Delete_Row'
);
END Delete_Row;
, 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);
l_trolin_rec.last_updated_by := p_last_updated_by;
l_trolin_rec.last_update_date := p_last_update_date;
l_trolin_rec.last_update_login := p_last_update_login;
l_trolin_rec.program_update_date := p_program_update_date;