The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT NVL(reservable_type, 1)
INTO l_sub_reservable_type
FROM mtl_secondary_inventories
WHERE organization_id = l_rsv_rec.organization_id
AND secondary_inventory_name = l_rsv_rec.subinventory_code;
SELECT NVL(reservable_type, 1)
INTO l_loc_reservable_type
FROM mtl_item_locations
WHERE organization_id = l_rsv_rec.organization_id
AND inventory_location_id = l_rsv_rec.locator_id;
SELECT NVL(reservable_type, 1)
INTO l_lot_reservable_type
FROM mtl_lot_numbers
WHERE inventory_item_id = l_rsv_rec.inventory_item_id
AND organization_id = l_rsv_rec.organization_id
AND lot_number = l_rsv_rec.lot_number;
SELECT reservable_type
INTO l_res_type
FROM mtl_material_statuses_b
WHERE status_id = l_return_status_id;
l_mtl_reservation.DELETE(i);
l_mtl_reservation.DELETE(i);
l_mtl_reservation.DELETE(i);
l_mtl_reservation.DELETE(i);
l_mtl_reservation.DELETE(i);
l_mtl_reservation.DELETE(i);
inv_reservation_pub.delete_reservation
( p_api_version_number => 1.0
, p_init_msg_lst => fnd_api.g_false
, x_return_status => l_return_status
, x_msg_count => l_msg_count
, x_msg_data => l_msg_data
, p_rsv_rec => l_mtl_reservation_non_staged(i)
, p_serial_number => l_dummy_sn
);
debug_print(' return error from delete reservation: '||l_return_status);
inv_reservation_pub.delete_reservation
( p_api_version_number => 1.0
, p_init_msg_lst => fnd_api.g_false
, x_return_status => l_return_status
, x_msg_count => l_msg_count
, x_msg_data => l_msg_data
, p_rsv_rec => l_mtl_reservation_non_staged(i)
, p_serial_number => l_dummy_sn
);
debug_print(' return error from delete reservation: '||l_return_status);
debug_print('Handling rsv qty and sec rsv qty for the reservation record which is to be updated');
debug_print('Update reservation - reservation id : ' || l_mtl_reservation_non_staged(i).reservation_id);
inv_reservation_pub.update_reservation(
p_api_version_number => 1.0
, p_init_msg_lst => fnd_api.g_false
, x_return_status => l_return_status
, x_msg_count => l_msg_count
, x_msg_data => l_msg_data
, p_original_rsv_rec => l_original_rsv_record
, p_to_rsv_rec => l_to_rsv_record
, p_original_serial_number => l_dummy_sn
, p_to_serial_number => l_dummy_sn
, p_validation_flag => fnd_api.g_true
, p_over_reservation_flag => 2
);
debug_print('return error from update reservation: '||l_return_status);
inv_reservation_pub.update_reservation(
p_api_version_number => 1.0
, p_init_msg_lst => fnd_api.g_false
, x_return_status => l_return_status
, x_msg_count => l_msg_count
, x_msg_data => l_msg_data
, p_original_rsv_rec => l_mtl_reservation_detailed(1)
, p_to_rsv_rec => l_mtl_reservation_det_qty
, p_original_serial_number => l_dummy_sn
, p_to_serial_number => l_dummy_sn
, p_validation_flag => fnd_api.g_true
, p_over_reservation_flag => 2
);
debug_print('return error from update reservation: '||l_return_status);
inv_reservation_pub.update_reservation(
p_api_version_number => 1.0
, p_init_msg_lst => fnd_api.g_false
, x_return_status => l_return_status
, x_msg_count => l_msg_count
, x_msg_data => l_msg_data
, p_original_rsv_rec => l_mtl_reservation_detailed(1)
, p_to_rsv_rec => l_mtl_reservation_staged
, p_original_serial_number => l_dummy_sn
, p_to_serial_number => l_dummy_sn
, p_validation_flag => fnd_api.g_true
, p_over_reservation_flag => 2
);
debug_print('return error from update reservation: '||l_return_status);